/[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 97 by torben, Thu Nov 29 09:51:51 2007 UTC revision 199 by torben, Sun Dec 9 09:46:11 2007 UTC
# Line 71  CREATE TABLE users Line 71  CREATE TABLE users
71  (  (
72     id serial,     id serial,
73     realname character varying(100) NOT NULL,     realname character varying(100) NOT NULL,
74     username character(30) NOT NULL,     username character varying(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 DEFAULT false,     useradmin boolean NOT NULL DEFAULT false,
# Line 82  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    CREATE INDEX logtable_messagenr_idx ON logtable(messagenr);
86    
87  CREATE ROLE serrenab LOGIN PASSWORD 'furnacemonitor';  CREATE ROLE serrenab LOGIN PASSWORD 'furnacemonitor';
88    
Legend:
Removed from v.97  
changed lines
  Added in v.199
  ViewVC Help
Powered by ViewVC 1.1.20