Changeset 2647
- Timestamp:
- 02/03/06 17:24:51 (19 years ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
pykota/trunk/initscripts/mysql/pykota-mysql.sql
r2638 r2647 42 42 -- Now connect to the new database 43 43 -- 44 usepykota;44 USE pykota; 45 45 46 46 -- … … 117 117 precomputedjobsize INT4, 118 118 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; 121 122 CREATE INDEX jobhistory_u_id_ix ON jobhistory (userid); 122 123 CREATE INDEX jobhistory_p_id_ix ON jobhistory (printerid);