Changeset 2457

Timestamp:

09/17/05 23:43:47 (19 years ago)

Author:

jerome

Message:

Fixed database schema to use an SQL keyword instead of a string.

Location:

pykota/trunk/initscripts/postgresql

Files:

• pykota-postgresql.sql (modified) (1 diff)
• upgrade-to-1.23.sql (modified) (2 diffs)

pykota/trunk/initscripts/postgresql/pykota-postgresql.sql

@@ -72 +72 @@
                       priceperpage FLOAT DEFAULT 0.0,
                       priceperjob FLOAT DEFAULT 0.0,
-                      passthrough BOOLEAN DEFAULT 'f',
+                      passthrough BOOLEAN DEFAULT FALSE,
                       maxjobsize INT4);
                     

pykota/trunk/initscripts/postgresql/upgrade-to-1.23.sql

@@ -37 +37 @@
 ALTER TABLE printers ADD COLUMN maxjobsize INT4;
 ALTER TABLE printers ADD COLUMN passthrough BOOLEAN;
-ALTER TABLE printers ALTER COLUMN passthrough SET DEFAULT 'f';
+ALTER TABLE printers ALTER COLUMN passthrough SET DEFAULT FALSE;
 ALTER TABLE jobhistory ADD COLUMN precomputedjobsize INT4;
 ALTER TABLE jobhistory ADD COLUMN precomputedjobprice FLOAT;
@@ -48 +48 @@
 --
 -- Just to be sure
-UPDATE printers SET passthrough='f';
+UPDATE printers SET passthrough=FALSE;
 
 --