--- trunk/docs/Database.txt	2007/11/27 08:16:08	63
+++ trunk/docs/Database.txt	2007/11/28 22:27:17	89
@@ -70,7 +70,7 @@
    username character(30) NOT NULL, 
    "password" character(32) NOT NULL, 
    enabled boolean NOT NULL DEFAULT true, 
-   useradmin boolean NOT NULL, 
+   useradmin boolean NOT NULL DEFAULT false, 
     PRIMARY KEY (id)
 ) WITHOUT OIDS;
 
@@ -78,3 +78,16 @@
 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;
+
+REVOKE create ON SCHEMA public FROM public;
+
+INSERT INTO users (realname,username,password,enabled,useradmin) VALUES ('Admin User','admin',md5('admin'),true,true);
\ No newline at end of file