/[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 76 by torben, Wed Nov 28 10:59:26 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 86  GRANT select,insert,update,delete ON con Line 90  GRANT select,insert,update,delete ON con
90  GRANT select,insert,update,delete ON command TO serrenab;  GRANT select,insert,update,delete ON command TO serrenab;
91  GRANT select,insert,update,delete ON installation TO serrenab;  GRANT select,insert,update,delete ON installation TO serrenab;
92  GRANT select,insert,update,delete ON customer TO serrenab;  GRANT select,insert,update,delete ON customer TO serrenab;
 GRANT select,insert,update,delete ON logtable TO serrenab;  
93    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;
103    
104    INSERT INTO users (realname,username,password,enabled,useradmin) VALUES ('Admin User','admin',md5('admin'),true,true);
Legend:
Removed from v.76  
changed lines
  Added in v.96
  ViewVC Help
Powered by ViewVC 1.1.20