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 DEFAULT true, |
enabled boolean NOT NULL DEFAULT true, |
73 |
useradmin boolean NOT NULL, |
useradmin boolean NOT NULL DEFAULT false, |
74 |
PRIMARY KEY (id) |
PRIMARY KEY (id) |
75 |
) WITHOUT OIDS; |
) WITHOUT OIDS; |
76 |
|
|
78 |
CREATE UNIQUE INDEX installation_phonenr_idx ON installation (installationphonenr); |
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); |
81 |
|
|
82 |
|
CREATE ROLE serrenab LOGIN PASSWORD 'furnacemonitor'; |
83 |
|
|
84 |
|
GRANT select,insert,update,delete ON users TO serrenab; |
85 |
|
GRANT select,insert,update,delete ON config TO serrenab; |
86 |
|
GRANT select,insert,update,delete ON command TO serrenab; |
87 |
|
GRANT select,insert,update,delete ON installation TO serrenab; |
88 |
|
GRANT select,insert,update,delete ON customer TO serrenab; |
89 |
|
GRANT select,insert,update,delete ON logtable TO serrenab; |