diff options
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, |