--- trunk/docs/Database.txt 2007/11/29 09:51:06 96 +++ trunk/docs/Database.txt 2007/11/29 09:51:51 97 @@ -16,13 +16,13 @@ CREATE TABLE installation ( id serial, + description text, address character varying(100) NOT NULL, customerid integer NOT NULL, - boilertype character varying(100) NOT NULL, + furnacetype character varying(100) NOT NULL, installationphonenr character varying(50) NOT NULL, imei character(16) NOT NULL, updaterate integer NOT NULL, - description text, commerror boolean NOT NULL DEFAULT false, PRIMARY KEY (id), FOREIGN KEY (customerid) REFERENCES customer (id) ON UPDATE CASCADE ON DELETE CASCADE