Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

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