diff options
| author | Jerome Sautret <jerome.sautret@process-one.net> | 2017-02-23 16:04:29 +0100 |
|---|---|---|
| committer | Jerome Sautret <jerome.sautret@process-one.net> | 2017-02-23 16:04:29 +0100 |
| commit | bc9f178b6d3d08beaf67ce22d59a747258a36c0a (patch) | |
| tree | eb82bbbed5ea6f741de62ec1fc000d55c89a67ac /sql/mysql.sql | |
| parent | Start/stop auth modules when host is added/deleted (diff) | |
Fix pubsub MySQL schema
Diffstat (limited to 'sql/mysql.sql')
| -rw-r--r-- | sql/mysql.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/sql/mysql.sql b/sql/mysql.sql index 5339614c9..9b2114ae5 100644 --- a/sql/mysql.sql +++ b/sql/mysql.sql @@ -220,7 +220,7 @@ CREATE TABLE roster_version ( CREATE TABLE pubsub_node ( host text NOT NULL, node text NOT NULL, - parent text NOT NULL DEFAULT '', + parent VARCHAR(191) NOT NULL DEFAULT '', type text NOT NULL, nodeid bigint auto_increment primary key ) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; @@ -246,7 +246,7 @@ CREATE TABLE pubsub_state ( nodeid bigint, jid text NOT NULL, affiliation character(1), - subscriptions text NOT NULL DEFAULT '', + subscriptions VARCHAR(191) NOT NULL DEFAULT '', stateid bigint auto_increment primary key ) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; CREATE INDEX i_pubsub_state_jid ON pubsub_state(jid(60)); @@ -259,7 +259,7 @@ CREATE TABLE pubsub_item ( publisher text NOT NULL, creation text NOT NULL, modification text NOT NULL, - payload text NOT NULL DEFAULT '' + payload text NOT NULL ) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; CREATE INDEX i_pubsub_item_itemid ON pubsub_item(itemid(36)); CREATE UNIQUE INDEX i_pubsub_item_tuple ON pubsub_item(nodeid, itemid(36)); |