Changeset 2647 for pykota/trunk/initscripts

Timestamp:

02/03/06 17:24:51 (19 years ago)

Author:

matt

Message:

Fixed typo in jobhistory table

Files:

• pykota/trunk/initscripts/mysql/pykota-mysql.sql (modified) (2 diffs)

pykota/trunk/initscripts/mysql/pykota-mysql.sql

@@ -42 +42 @@
 -- Now connect to the new database
 -- 
-use pykota;
+USE pykota;
 
 --
@@ -117 +117 @@
                         precomputedjobsize INT4,
                         precomputedjobprice FLOAT,
-                        jobdate TIMESTAMP DEFAULT,
-                        CONSTRAINT checkUserPQuota FOREIGN KEY (userid, printerid) REFERENCES userpquota(userid, printerid)) TYPE=INNODB;
+                        jobdate TIMESTAMP DEFAULT now(),
+                        CONSTRAINT checkUserPQuota FOREIGN KEY (userid, printerid) REFERENCES userpquota (userid, printerid)
+                        ) TYPE=INNODB;
 CREATE INDEX jobhistory_u_id_ix ON jobhistory (userid);
 CREATE INDEX jobhistory_p_id_ix ON jobhistory (printerid);