/[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 91 by torben, Wed Nov 28 23:23:13 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    REVOKE create ON SCHEMA public FROM public;
96    
97    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.91
  ViewVC Help
Powered by ViewVC 1.1.20