16 |
CREATE TABLE installation |
CREATE TABLE installation |
17 |
( |
( |
18 |
id serial, |
id serial, |
19 |
|
description text, |
20 |
address character varying(100) NOT NULL, |
address character varying(100) NOT NULL, |
21 |
customerid integer NOT NULL, |
customerid integer NOT NULL, |
22 |
boilertype character varying(100) NOT NULL, |
furnacetype character varying(100) NOT NULL, |
23 |
installationphonenr character varying(50) NOT NULL, |
installationphonenr character varying(50) NOT NULL, |
24 |
imei character(16) NOT NULL, |
imei character(16) NOT NULL, |
25 |
updaterate integer NOT NULL, |
updaterate integer NOT NULL, |
|
description text, |
|
26 |
commerror boolean NOT NULL DEFAULT false, |
commerror boolean NOT NULL DEFAULT false, |
27 |
PRIMARY KEY (id), |
PRIMARY KEY (id), |
28 |
FOREIGN KEY (customerid) REFERENCES customer (id) ON UPDATE CASCADE ON DELETE CASCADE |
FOREIGN KEY (customerid) REFERENCES customer (id) ON UPDATE CASCADE ON DELETE CASCADE |
71 |
( |
( |
72 |
id serial, |
id serial, |
73 |
realname character varying(100) NOT NULL, |
realname character varying(100) NOT NULL, |
74 |
username character(30) NOT NULL, |
username character varying(30) NOT NULL, |
75 |
"password" character(32) NOT NULL, |
"password" character(32) NOT NULL, |
76 |
enabled boolean NOT NULL DEFAULT true, |
enabled boolean NOT NULL DEFAULT true, |
77 |
useradmin boolean NOT NULL DEFAULT false, |
useradmin boolean NOT NULL DEFAULT false, |