The MySQL migration adding the 'creationdate' column to the job table does not work

Description

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.

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

Reporter

Priority

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
Loading...