diff options
| author | Christophe Romain <christophe.romain@process-one.net> | 2009-08-07 08:29:24 +0000 |
|---|---|---|
| committer | Christophe Romain <christophe.romain@process-one.net> | 2009-08-07 08:29:24 +0000 |
| commit | 0b0310694687b1259bb20c489cb19212ed027586 (patch) | |
| tree | 5265fa9fe10d6c6e3f4884825d5fc378856b178f | |
| parent | initial merge of pubsub odbc, compilation pass ok (diff) | |
typo fix on subscriptions
SVN Revision: 2438
| -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); |