[Buildbot-commits] [Buildbot] #988: tables.sql is incompatible with MySQL (and it's missing v5 indexes)

[Buildbot]

#988: tables.sql is incompatible with MySQL (and it's missing v5 indexes)
------------------------+---------------------------------------------------
Reporter:  PiotrSikora  |       Owner:           
    Type:  defect       |      Status:  new      
Priority:  major        |   Milestone:  undecided
 Version:  0.8.1        |    Keywords:  database 
------------------------+---------------------------------------------------
 `tables.sql`:

 - is using `AUTOINCREMENT`, but MySQL uses `AUTO_INCREMENT`,

 - uses too long `schedulers.name` and `schedulers.class_name` and because
 of that index cannot be created on MySQL database created with `COLLATE
 utf8_general_ci` (which is required for UTF-8 support),

 - misses v5 indexes,

 - misses version number, so it cannot be used to kick-start database.

 Attached version fixes all of the above.

-- 
Ticket URL: <http://buildbot.net/trac/ticket/988>
Buildbot <http://buildbot.net/>
Buildbot: build/test automation