--- trunk/docs/Database.txt	2007/11/29 14:00:15	102
+++ trunk/docs/Database.txt	2007/12/11 22:10:17	244
@@ -16,11 +16,11 @@
 CREATE TABLE installation
 (
    id serial, 
-   description text, 
+   description character varying(100), 
    address character varying(100) NOT NULL, 
    customerid integer NOT NULL, 
    furnacetype character varying(100) NOT NULL, 
-   installationphonenr character varying(50) NOT NULL, 
+   installationphonenr character varying(30) NOT NULL, 
    imei character(16) NOT NULL, 
    updaterate integer NOT NULL, 
    commerror boolean NOT NULL DEFAULT false, 
@@ -82,6 +82,7 @@
 CREATE UNIQUE INDEX installation_phonenr_idx ON installation (installationphonenr);
 CREATE INDEX logtable_installationnr_idx ON logtable (installationnr);
 CREATE UNIQUE INDEX users_username_idx ON users (username);
+CREATE INDEX logtable_messagenr_idx ON logtable(messagenr);
 
 CREATE ROLE serrenab LOGIN PASSWORD 'furnacemonitor';