diff options
Diffstat (limited to 'src')
| -rw-r--r-- | src/odbc/mysql.sql | 2 | ||||
| -rw-r--r-- | src/odbc/pg.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/src/odbc/mysql.sql b/src/odbc/mysql.sql index be182bf5f..8e1d242c4 100644 --- a/src/odbc/mysql.sql +++ b/src/odbc/mysql.sql @@ -188,7 +188,7 @@ CREATE TABLE pubsub_state ( nodeid bigint, jid text, affiliation character(1), - subscription character(1), + subscriptions text, stateid bigint auto_increment primary key ) CHARACTER SET utf8; CREATE INDEX i_pubsub_state_jid ON pubsub_state(jid(60)); diff --git a/src/odbc/pg.sql b/src/odbc/pg.sql index d02a9154e..269262672 100644 --- a/src/odbc/pg.sql +++ b/src/odbc/pg.sql @@ -190,7 +190,7 @@ CREATE TABLE pubsub_state ( nodeid bigint REFERENCES pubsub_node(nodeid) ON DELETE CASCADE, jid text, affiliation character(1), - subscription character(1), + subscriptions text, stateid SERIAL UNIQUE ); CREATE INDEX i_pubsub_state_jid ON pubsub_state USING btree (jid); |