Changeset 2457 for pykota/trunk/initscripts/postgresql/upgrade-to-1.23.sql

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.

Files:

• pykota/trunk/initscripts/postgresql/upgrade-to-1.23.sql (modified) (2 diffs)

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;
 
 --