changeset 109 | 3d84eda3f16f |
parent 100 | a6d2add085d7 |
108:d6a52e0152fb | 109:3d84eda3f16f |
---|---|
2 drop table uefa; |
2 drop table uefa; |
3 drop table euroleague; |
3 drop table euroleague; |
4 create table euroleague ( |
4 create table euroleague ( |
5 team char(20), |
5 team char(20), |
6 lwin int, ldraw int, llost int, |
6 lwin int, ldraw int, llost int, |
7 cup double, |
7 cup float, |
8 uwin int, udraw int, |
8 uwin int, udraw int, |
9 bonus double, |
9 bonus float, |
10 country char(15)); |
10 country char(15)); |
11 |
11 |
12 create unique index team_idx on euroleague(team); |
12 create unique index team_idx on euroleague(team); |
13 |
13 |
14 insert into euroleague values('FC Toulouse', 16, 16, 6, 0, 0, 0, 0, 'Frankreich'); |
14 insert into euroleague values('FC Toulouse', 16, 16, 6, 0, 0, 0, 0, 'Frankreich'); |
77 insert into euroleague values('Schachtjor Donezk', 19, 7, 4, 0.25, 8, 4, 8, 'Ukraine'); |
77 insert into euroleague values('Schachtjor Donezk', 19, 7, 4, 0.25, 8, 4, 8, 'Ukraine'); |
78 |
78 |
79 select * from euroleague order by lwin desc, ldraw desc; |
79 select * from euroleague order by lwin desc, ldraw desc; |
80 create table uefa ( |
80 create table uefa ( |
81 country char(20), |
81 country char(20), |
82 coeff double); |
82 coeffizient float); |
83 |
83 |
84 create unique index uefa_idx on uefa(country); |
84 create unique index uefa_idx on uefa(country); |
85 |
85 |
86 insert into uefa values('Deutschland', 56.695); |
86 insert into uefa values('Deutschland', 56.695); |
87 insert into uefa values('England', 79.498999999999995); |
87 insert into uefa values('England', 79.498999999999995); |