From 5fab00011eeed532ac5c7a9c64c03b72f56c40d6 Mon Sep 17 00:00:00 2001
From: Evgeniy Khramtsov <ekhramtsov@process-one.net>
Date: Tue, 3 Apr 2012 20:23:41 +1000
Subject: ODBC support for mod_irc

---
 src/odbc/mysql.sql | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'src/odbc/mysql.sql')

diff --git a/src/odbc/mysql.sql b/src/odbc/mysql.sql
index ecb2b08e..e57b135e 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,
-- 
cgit v1.2.3

