ODBC support for mod_irc

2 files changed, 18 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,
diff --git a/src/odbc/pg.sql b/src/odbc/pg.sql
index 30ea19ca5..1abc84abf 100644
--- a/src/odbc/pg.sql
+++ b/src/odbc/pg.sql
@@ -245,6 +245,15 @@ 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 irc_custom (
+    jid text NOT NULL,
+    host text NOT NULL,
+    data text NOT NULL,
+    created_at TIMESTAMP NOT NULL DEFAULT now()
+);
+
+CREATE UNIQUE INDEX i_irc_custom_jid_host ON irc_custom USING btree (jid, host);
+
 CREATE TABLE motd (
     username text PRIMARY KEY,
     xml text,