The MySQL migration adding the 'creationdate' column to the job table does not work
Field Tab
Test
Field Tab
Test
Description
Checklist
Activity
Show:

SrJanuary 23, 2013 at 2:51 PM
Verified in TEST2A using MySQL as the database and using revision 2605

SrJanuary 23, 2013 at 11:04 AM
I suggest just removing the DEFAULT NULL from the MYSQL migration code.
Fixed
Details
Assignee
SrSrReporter
SrSrPriority
Minor
Details
Details
Assignee

Reporter

Priority
Checklist
Open Checklist
Checklist
Open Checklist
Checklist
Open Checklist
Created January 23, 2013 at 11:02 AM
Updated January 23, 2013 at 2:51 PM
Resolved January 23, 2013 at 2:51 PM
Currently, the same migration code is used for all database-types (derby, mysql, postgresql): ALTER TABLE jobs ADD creationdate TIMESTAMP DEFAULT NULL
However, the "DEFAULT NULL" is not allowed in mysql.