--- trunk/docs/Database.txt	2007/11/28 10:59:26	76
+++ trunk/docs/Database.txt	2007/11/29 09:51:06	96
@@ -1,3 +1,7 @@
+-- Plase note that the flisfyr database must be created with iso-8859-1 encoding like this
+-- CREATE DATABASE flisfyr ENCODING 'LATIN1';
+
+
 CREATE TABLE customer
 (
    id serial, 
@@ -86,4 +90,15 @@
 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
+GRANT select,insert,update,delete ON logtable TO serrenab;
+
+-- these sequences are auto created by postgresql
+GRANT ALL ON customer_id_seq  TO serrenab;
+GRANT ALL ON command_id_seq TO serrenab;
+GRANT ALL ON installation_id_seq TO serrenab;
+GRANT ALL ON logtable_id_seq TO serrenab;
+GRANT ALL ON users_id_seq 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