diff options
| author | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2012-04-02 14:49:13 +1000 |
|---|---|---|
| committer | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2012-04-02 14:49:13 +1000 |
| commit | b43444f674e577a21bac889b732c4752530036e5 (patch) | |
| tree | 21d5b57b0f433270e44ec8491b6e3edd4ed53a45 /src/odbc | |
| parent | Add ODBC exporting function for privacy table (diff) | |
ODBC support for mod_announce
Diffstat (limited to 'src/odbc')
| -rw-r--r-- | src/odbc/mysql.sql | 6 | ||||
| -rw-r--r-- | src/odbc/pg.sql | 6 |
2 files changed, 12 insertions, 0 deletions
diff --git a/src/odbc/mysql.sql b/src/odbc/mysql.sql index d67ca6c88..104b44481 100644 --- a/src/odbc/mysql.sql +++ b/src/odbc/mysql.sql @@ -238,3 +238,9 @@ CREATE TABLE muc_registered ( CREATE INDEX i_muc_registered_nick USING BTREE ON muc_registered(nick(75)); CREATE UNIQUE INDEX i_muc_registered_jid_host USING BTREE ON muc_registered(jid(75), host(75)); + +CREATE TABLE motd ( + username varchar(250) PRIMARY KEY, + xml text, + created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP +) CHARACTER SET utf8; diff --git a/src/odbc/pg.sql b/src/odbc/pg.sql index aae472d6b..f28cf8af2 100644 --- a/src/odbc/pg.sql +++ b/src/odbc/pg.sql @@ -238,3 +238,9 @@ CREATE TABLE muc_registered ( CREATE INDEX i_muc_registered_nick ON muc_registered USING btree (nick); CREATE UNIQUE INDEX i_muc_registered_jid_host ON muc_registered USING btree (jid, host); + +CREATE TABLE motd ( + username text PRIMARY KEY, + xml text, + created_at TIMESTAMP NOT NULL DEFAULT now() +); |