mw@nuncius:~/svn/roomplanner/trunk/sql$ svn diff -r12:17 create_ermodell.sql 
Index: create_ermodell.sql
===================================================================
--- create_ermodell.sql	(Revision 12)
+++ create_ermodell.sql	(Revision 17)
@@ -110,7 +110,7 @@
 CREATE TABLE "rooms" (
     "id" INTEGER DEFAULT nextval('rooms_seq')  NOT NULL,
     "code" CHARACTER VARYING(8)  NOT NULL,
-    "area" NUMERIC(5,2)  NOT NULL,
+    "area" FLOAT  NOT NULL,
     "usage" CHARACTER VARYING(2)  NOT NULL,
     "floor" CHARACTER(1)  NOT NULL,
     "type" CHARACTER(1)  NOT NULL,
@@ -156,7 +156,7 @@
 
 CREATE TABLE "location" (
     "mnemonic" CHARACTER VARYING(3)  NOT NULL,
-    "description" CHARACTER(20)  NOT NULL,
+    "description" CHARACTER VARYING(20)  NOT NULL,
     CONSTRAINT "PK_location" PRIMARY KEY ("mnemonic")
 );
 
@@ -274,7 +274,7 @@
 /* ---------------------------------------------------------------------- */
 
 CREATE TABLE "history" (
-    "id" BIGINT DEFAULT nextval('history_seq')  NOT NULL,
+    "id" INTEGER DEFAULT nextval('history_seq')  NOT NULL,
     "date" DATE  NOT NULL,
     "uid" INTEGER  NOT NULL,
     "action" CHARACTER VARYING(50)  NOT NULL,