--- trunk/docs/Database.txt	2007/11/26 22:25:15	61
+++ trunk/docs/Database.txt	2007/11/28 10:59:26	76
@@ -69,11 +69,21 @@
    realname character varying(100) NOT NULL, 
    username character(30) NOT NULL, 
    "password" character(32) NOT NULL, 
-   enabled boolean NOT NULL, 
-   useradmin boolean NOT NULL, 
+   enabled boolean NOT NULL DEFAULT true, 
+   useradmin boolean NOT NULL DEFAULT false, 
     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);
+
+CREATE ROLE serrenab LOGIN PASSWORD 'furnacemonitor';
+
+GRANT select,insert,update,delete ON users TO serrenab;
+GRANT select,insert,update,delete ON config TO serrenab;
+GRANT select,insert,update,delete ON command TO serrenab;
+GRANT select,insert,update,delete ON installation TO serrenab;
+GRANT select,insert,update,delete ON customer TO serrenab;
+GRANT select,insert,update,delete ON logtable TO serrenab;
\ No newline at end of file