diff options
author | Mickaël Rémond <mickael.remond@process-one.net> | 2006-11-05 16:48:33 +0000 |
---|---|---|
committer | Mickaël Rémond <mickael.remond@process-one.net> | 2006-11-05 16:48:33 +0000 |
commit | 37061880dc869d02993946af0c00fbfa3883ad02 (patch) | |
tree | 7374bbefc2e8110bf55d5a7fa98c675ed012321d /src | |
parent | * src/mod_private_odbc.erl: Support for MySQL and MSSQL. (diff) |
* src/odbc/mysql.sql: Fix database creation script.
SVN Revision: 675
Diffstat (limited to 'src')
-rw-r--r-- | src/odbc/mysql.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/odbc/mysql.sql b/src/odbc/mysql.sql index 607a7407f..edb060a59 100644 --- a/src/odbc/mysql.sql +++ b/src/odbc/mysql.sql @@ -42,7 +42,7 @@ CREATE INDEX pk_rosterg_user_jid ON rostergroups(username(75), jid(75)); CREATE TABLE spool ( username varchar(250) NOT NULL, xml text, - seq INTEGER UNSIGNED NOT NULL AUTO_INCREMENT + seq BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE ) CHARACTER SET utf8; CREATE INDEX i_despool USING BTREE ON spool(username); @@ -100,7 +100,7 @@ CREATE TABLE private_storage ( ) CHARACTER SET utf8; CREATE INDEX i_private_storage_username USING BTREE ON private_storage(username); -CREATE UNIQUE INDEX i_private_storage_username_namespace USING BTREE ON private_storage(username, namespace); +CREATE UNIQUE INDEX i_private_storage_username_namespace USING BTREE ON private_storage(username(75), namespace(75)); --- To update from 1.x: -- ALTER TABLE rosterusers ADD COLUMN askmessage text AFTER ask; |