Show
Ignore:
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:
2 modified

Legend:

Unmodified
Added
Removed
  • pykota/trunk/initscripts/postgresql/pykota-postgresql.sql

    r2452 r2457  
    7272                      priceperpage FLOAT DEFAULT 0.0, 
    7373                      priceperjob FLOAT DEFAULT 0.0, 
    74                       passthrough BOOLEAN DEFAULT 'f', 
     74                      passthrough BOOLEAN DEFAULT FALSE, 
    7575                      maxjobsize INT4); 
    7676                     
  • pykota/trunk/initscripts/postgresql/upgrade-to-1.23.sql

    r2452 r2457  
    3737ALTER TABLE printers ADD COLUMN maxjobsize INT4; 
    3838ALTER TABLE printers ADD COLUMN passthrough BOOLEAN; 
    39 ALTER TABLE printers ALTER COLUMN passthrough SET DEFAULT 'f'; 
     39ALTER TABLE printers ALTER COLUMN passthrough SET DEFAULT FALSE; 
    4040ALTER TABLE jobhistory ADD COLUMN precomputedjobsize INT4; 
    4141ALTER TABLE jobhistory ADD COLUMN precomputedjobprice FLOAT; 
     
    4848-- 
    4949-- Just to be sure 
    50 UPDATE printers SET passthrough='f'; 
     50UPDATE printers SET passthrough=FALSE; 
    5151 
    5252--