diff options
| -rw-r--r-- | ChangeLog | 3 | ||||
| -rw-r--r-- | src/odbc/mysql.sql | 12 |
2 files changed, 9 insertions, 6 deletions
@@ -6,6 +6,9 @@ * src/odbc/mysql.sql: Likewise. * src/odbc/mssql.sql: Likewise. + * src/odbc/mysql: Database creation script should now be compliant with + MySQL 4.0.x. + 2006-10-29 Mickael Remond <mickael.remond@process-one.net> * doc/guide.tex: XEP-0065 proxy documentation (thanks to Evgeniy diff --git a/src/odbc/mysql.sql b/src/odbc/mysql.sql index 4288cef13..2394f9901 100644 --- a/src/odbc/mysql.sql +++ b/src/odbc/mysql.sql @@ -1,4 +1,4 @@ --- Needs MySQL (at least 4.1.x) with innodb back-end +-- Needs MySQL (at least 4.0.x) with innodb back-end SET table_type=InnoDB; CREATE TABLE users ( @@ -26,9 +26,9 @@ CREATE TABLE rosterusers ( type text ) CHARACTER SET utf8; -CREATE UNIQUE INDEX i_rosteru_user_jid USING HASH ON rosterusers(username(75), jid(75)); -CREATE INDEX i_rosteru_username USING HASH ON rosterusers(username); -CREATE INDEX i_rosteru_jid USING HASH ON rosterusers(jid); +CREATE UNIQUE INDEX i_rosteru_user_jid ON rosterusers(username(75), jid(75)); +CREATE INDEX i_rosteru_username ON rosterusers(username); +CREATE INDEX i_rosteru_jid ON rosterusers(jid); CREATE TABLE rostergroups ( username varchar(250) NOT NULL, @@ -36,13 +36,13 @@ CREATE TABLE rostergroups ( grp text NOT NULL ) CHARACTER SET utf8; -CREATE INDEX pk_rosterg_user_jid USING HASH ON rostergroups(username(75), jid(75)); +CREATE INDEX pk_rosterg_user_jid ON rostergroups(username(75), jid(75)); CREATE TABLE spool ( username varchar(250) NOT NULL, xml text, - seq SERIAL + seq INTEGER UNSIGNED NOT NULL AUTO_INCREMENT ) CHARACTER SET utf8; CREATE INDEX i_despool USING BTREE ON spool(username); |