/[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 198 by torben, Thu Nov 29 14:00:15 2007 UTC revision 199 by torben, Sun Dec 9 09:46:11 2007 UTC
# 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.198  
changed lines
  Added in v.199
  ViewVC Help
Powered by ViewVC 1.1.20