Derby uses float values here
authorMarkus Bröker <mbroeker@largo.dyndns.tv>
Tue, 09 Feb 2010 08:38:01 +0100
changeset 109 3d84eda3f16f
parent 108 d6a52e0152fb
child 110 e1bc09732fa3
Derby uses float values here committer: Markus Bröker <mbroeker@largo.homelinux.org>
javadb/sql/euroleague.sql
--- 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);