/[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 102 by torben, Thu Nov 29 14:00:15 2007 UTC revision 221 by torben, Tue Dec 11 07:48:55 2007 UTC
# Line 16  CREATE TABLE customer Line 16  CREATE TABLE customer
16  CREATE TABLE installation  CREATE TABLE installation
17  (  (
18     id serial,     id serial,
19     description text,     description character varying(100),
20     address character varying(100) NOT NULL,     address character varying(100) NOT NULL,
21     customerid integer NOT NULL,     customerid integer NOT NULL,
22     furnacetype character varying(100) NOT NULL,     furnacetype character varying(100) NOT NULL,
# 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.102  
changed lines
  Added in v.221
  ViewVC Help
Powered by ViewVC 1.1.20