/[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 61 by torben, Mon Nov 26 22:25:15 2007 UTC revision 63 by torben, Tue Nov 27 08:16:08 2007 UTC
# Line 69  CREATE TABLE users Line 69  CREATE TABLE users
69     realname character varying(100) NOT NULL,     realname character varying(100) NOT NULL,
70     username character(30) NOT NULL,     username character(30) NOT NULL,
71     "password" character(32) NOT NULL,     "password" character(32) NOT NULL,
72     enabled boolean NOT NULL,     enabled boolean NOT NULL DEFAULT true,
73     useradmin boolean NOT NULL,     useradmin boolean NOT NULL,
74      PRIMARY KEY (id)      PRIMARY KEY (id)
75  ) WITHOUT OIDS;  ) WITHOUT OIDS;
76    
77  CREATE INDEX installation_customer_idx ON installation (customerid);  CREATE INDEX installation_customer_idx ON installation (customerid);
78    CREATE UNIQUE INDEX installation_phonenr_idx ON installation (installationphonenr);
79  CREATE INDEX logtable_installationnr_idx ON logtable (installationnr);  CREATE INDEX logtable_installationnr_idx ON logtable (installationnr);
80  CREATE UNIQUE INDEX users_username_idx ON users (username);  CREATE UNIQUE INDEX users_username_idx ON users (username);
Legend:
Removed from v.61  
changed lines
  Added in v.63
  ViewVC Help
Powered by ViewVC 1.1.20