--- trunk/docs/Database.txt 2007/12/09 09:45:11 198 +++ trunk/docs/Database.txt 2007/12/09 09:46:11 199 @@ -82,6 +82,7 @@ CREATE UNIQUE INDEX installation_phonenr_idx ON installation (installationphonenr); CREATE INDEX logtable_installationnr_idx ON logtable (installationnr); CREATE UNIQUE INDEX users_username_idx ON users (username); +CREATE INDEX logtable_messagenr_idx ON logtable(messagenr); CREATE ROLE serrenab LOGIN PASSWORD 'furnacemonitor';