diff options
| author | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2012-04-03 20:23:41 +1000 |
|---|---|---|
| committer | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2012-04-03 20:23:41 +1000 |
| commit | 5fab00011eeed532ac5c7a9c64c03b72f56c40d6 (patch) | |
| tree | d58975a959db8542d51f787246e99a91abbed3d3 /src/odbc/mysql.sql | |
| parent | ODBC support for mod_vcard_xupdate (diff) | |
ODBC support for mod_irc
Diffstat (limited to 'src/odbc/mysql.sql')
| -rw-r--r-- | src/odbc/mysql.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/src/odbc/mysql.sql b/src/odbc/mysql.sql index ecb2b08e9..e57b135ed 100644 --- a/src/odbc/mysql.sql +++ b/src/odbc/mysql.sql @@ -244,6 +244,15 @@ 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 irc_custom ( + jid text NOT NULL, + host text NOT NULL, + data text NOT NULL, + created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP +) CHARACTER SET utf8; + +CREATE UNIQUE INDEX i_irc_custom_jid_host USING BTREE ON irc_custom(jid(75), host(75)); + CREATE TABLE motd ( username varchar(250) PRIMARY KEY, xml text, |