changeset 109 | 3d84eda3f16f |
parent 100 | a6d2add085d7 |
--- a/javadb/sql/euroleague.sql +++ b/javadb/sql/euroleague.sql @@ -4,9 +4,9 @@ create table euroleague ( team char(20), lwin int, ldraw int, llost int, - cup double, + cup float, uwin int, udraw int, - bonus double, + bonus float, country char(15)); create unique index team_idx on euroleague(team); @@ -79,7 +79,7 @@ select * from euroleague order by lwin desc, ldraw desc; create table uefa ( country char(20), - coeff double); + coeffizient float); create unique index uefa_idx on uefa(country);