/[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 63 by torben, Tue Nov 27 08:16:08 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 70  CREATE TABLE users Line 74  CREATE TABLE users
74     username character(30) NOT NULL,     username character(30) NOT NULL,
75     "password" character(32) NOT NULL,     "password" character(32) NOT NULL,
76     enabled boolean NOT NULL DEFAULT true,     enabled boolean NOT NULL DEFAULT true,
77     useradmin boolean NOT NULL,     useradmin boolean NOT NULL DEFAULT false,
78      PRIMARY KEY (id)      PRIMARY KEY (id)
79  ) WITHOUT OIDS;  ) WITHOUT OIDS;
80    
# Line 78  CREATE INDEX installation_customer_idx O Line 82  CREATE INDEX installation_customer_idx O
82  CREATE UNIQUE INDEX installation_phonenr_idx ON installation (installationphonenr);  CREATE UNIQUE INDEX installation_phonenr_idx ON installation (installationphonenr);
83  CREATE INDEX logtable_installationnr_idx ON logtable (installationnr);  CREATE INDEX logtable_installationnr_idx ON logtable (installationnr);
84  CREATE UNIQUE INDEX users_username_idx ON users (username);  CREATE UNIQUE INDEX users_username_idx ON users (username);
85    
86    CREATE ROLE serrenab LOGIN PASSWORD 'furnacemonitor';
87    
88    GRANT select,insert,update,delete ON users TO serrenab;
89    GRANT select,insert,update,delete ON config TO serrenab;
90    GRANT select,insert,update,delete ON command TO serrenab;
91    GRANT select,insert,update,delete ON installation TO serrenab;
92    GRANT select,insert,update,delete ON customer 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.63  
changed lines
  Added in v.91
  ViewVC Help
Powered by ViewVC 1.1.20