Changeset 2647

Show
Ignore:
Timestamp:
02/03/06 17:24:51 (19 years ago)
Author:
matt
Message:

Fixed typo in jobhistory table

Files:
1 modified

Legend:

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

    r2638 r2647  
    4242-- Now connect to the new database 
    4343--  
    44 use pykota; 
     44USE pykota; 
    4545 
    4646-- 
     
    117117                        precomputedjobsize INT4, 
    118118                        precomputedjobprice FLOAT, 
    119                         jobdate TIMESTAMP DEFAULT, 
    120                         CONSTRAINT checkUserPQuota FOREIGN KEY (userid, printerid) REFERENCES userpquota(userid, printerid)) TYPE=INNODB; 
     119                        jobdate TIMESTAMP DEFAULT now(), 
     120                        CONSTRAINT checkUserPQuota FOREIGN KEY (userid, printerid) REFERENCES userpquota (userid, printerid) 
     121                        ) TYPE=INNODB; 
    121122CREATE INDEX jobhistory_u_id_ix ON jobhistory (userid); 
    122123CREATE INDEX jobhistory_p_id_ix ON jobhistory (printerid);