[Buildbot-commits] [Buildbot] #988: tables.sql is incompatible with MySQL (and it's missing v5 indexes)
Buildbot
buildbot-devel at lists.sourceforge.net
Wed Sep 15 00:53:12 UTC 2010
#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
More information about the Commits
mailing list