#36 mysql5 support - completely cleaned up initdb-mysql

[Auke Kok]

Here's a gratuitous mysql initdb file that not only
fixes the mysql5 setup problem but does a full cleanup
to the file which was badly needed. For 0.9.5.

[Auke Kok]

[Paul D. Smith]

Logged In: YES
user_id=30808
Originator: NO

Nice, but there's a bug here; the last line should read:

GRANT ALL ON `lxrtest`.* TO `lxr`@`localhost`;

(note the extra backticks in the user@host field).

[Paul D. Smith]

Logged In: YES
user_id=30808
Originator: NO

Whoops. Change `lxrtest` back to `lxr` :)

[Paul D. Smith]

Logged In: YES
user_id=30808
Originator: NO

Ouch, there's another bug in this version of initdb-mysql. In the lxr_releases table, one of the fields is left off the primary key. The line:

PRIMARY KEY     \(\`fileid\`\)

Should instead be:

PRIMARY KEY     \(\`fileid\`,\`release\`\)

Also, I don't know why the comment "/* Broken */" appears before this table... it's certainly broken without the release in the primary key, since many different releases can have the same fileid present!

[Andre-Littoz]

Fixed sometime in the past