/[H9]/trunk/docs/Database.txt
ViewVC logotype

Diff of /trunk/docs/Database.txt

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 89 by torben, Wed Nov 28 22:27:17 2007 UTC revision 96 by torben, Thu Nov 29 09:51:06 2007 UTC
# Line 1  Line 1 
1    -- Plase note that the flisfyr database must be created with iso-8859-1 encoding like this
2    -- CREATE DATABASE flisfyr ENCODING 'LATIN1';
3    
4    
5  CREATE TABLE customer  CREATE TABLE customer
6  (  (
7     id serial,     id serial,
# Line 88  GRANT select,insert,update,delete ON ins Line 92  GRANT select,insert,update,delete ON ins
92  GRANT select,insert,update,delete ON customer TO serrenab;  GRANT select,insert,update,delete ON customer TO serrenab;
93  GRANT select,insert,update,delete ON logtable TO serrenab;  GRANT select,insert,update,delete ON logtable TO serrenab;
94    
95    -- these sequences are auto created by postgresql
96    GRANT ALL ON customer_id_seq  TO serrenab;
97    GRANT ALL ON command_id_seq TO serrenab;
98    GRANT ALL ON installation_id_seq TO serrenab;
99    GRANT ALL ON logtable_id_seq TO serrenab;
100    GRANT ALL ON users_id_seq TO serrenab;
101    
102  REVOKE create ON SCHEMA public FROM public;  REVOKE create ON SCHEMA public FROM public;
103    
104  INSERT INTO users (realname,username,password,enabled,useradmin) VALUES ('Admin User','admin',md5('admin'),true,true);  INSERT INTO users (realname,username,password,enabled,useradmin) VALUES ('Admin User','admin',md5('admin'),true,true);
Legend:
Removed from v.89  
changed lines
  Added in v.96
  ViewVC Help
Powered by ViewVC 1.1.20