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, |
23 |
installationphonenr character varying(50) NOT NULL, |
installationphonenr character varying(30) NOT NULL, |
24 |
imei character(16) NOT NULL, |
imei character(16) NOT NULL, |
25 |
updaterate integer NOT NULL, |
updaterate integer NOT NULL, |
26 |
commerror boolean NOT NULL DEFAULT false, |
commerror boolean NOT NULL DEFAULT false, |
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 |
|
|