/[H9]/trunk/docs/Database.txt
ViewVC logotype

Diff of /trunk/docs/Database.txt

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 199 by torben, Sun Dec 9 09:46:11 2007 UTC revision 244 by torben, Tue Dec 11 22:10:17 2007 UTC
# Line 16  CREATE TABLE customer Line 16  CREATE TABLE customer
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,
Legend:
Removed from v.199  
changed lines
  Added in v.244
  ViewVC Help
Powered by ViewVC 1.1.20