--- trunk/docs/Database.txt	2007/11/26 22:25:15	61
+++ trunk/docs/Database.txt	2007/11/27 08:16:08	63
@@ -69,11 +69,12 @@
    realname character varying(100) NOT NULL, 
    username character(30) NOT NULL, 
    "password" character(32) NOT NULL, 
-   enabled boolean NOT NULL, 
+   enabled boolean NOT NULL DEFAULT true, 
    useradmin boolean NOT NULL, 
     PRIMARY KEY (id)
 ) WITHOUT OIDS;
 
 CREATE INDEX installation_customer_idx ON installation (customerid);
+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);