1 files changed, 47 insertions, 0 deletions
diff --git a/library/ajaxchat/chat/chat.sql b/library/ajaxchat/chat/chat.sql
new file mode 100644
index 000000000..5e7efea35
--- /dev/null
+++ b/library/ajaxchat/chat/chat.sql
@@ -0,0 +1,47 @@
+
+DROP TABLE IF EXISTS ajax_chat_online;
+CREATE TABLE ajax_chat_online (
+	userID INT(11) NOT NULL,
+	userName VARCHAR(64) NOT NULL,
+	userRole INT(1) NOT NULL,
+	channel INT(11) NOT NULL,
+	dateTime DATETIME NOT NULL,
+	ip VARBINARY(16) NOT NULL,
+	PRIMARY KEY (userID),
+	INDEX (userName)
+) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+
+DROP TABLE IF EXISTS ajax_chat_messages;
+CREATE TABLE ajax_chat_messages (
+	id INT(11) NOT NULL AUTO_INCREMENT,
+	userID INT(11) NOT NULL,
+	userName VARCHAR(64) NOT NULL,
+	userRole INT(1) NOT NULL,
+	channel INT(11) NOT NULL,
+	dateTime DATETIME NOT NULL,
+	ip VARBINARY(16) NOT NULL,
+	text TEXT,
+	PRIMARY KEY (id),
+	INDEX message_condition (id, channel, dateTime),
+	INDEX (dateTime)
+) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+
+DROP TABLE IF EXISTS ajax_chat_bans;
+CREATE TABLE ajax_chat_bans (
+	userID INT(11) NOT NULL,
+	userName VARCHAR(64) NOT NULL,
+	dateTime DATETIME NOT NULL,
+	ip VARBINARY(16) NOT NULL,
+	PRIMARY KEY (userID),
+	INDEX (userName),
+	INDEX (dateTime)
+) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+
+DROP TABLE IF EXISTS ajax_chat_invitations;
+CREATE TABLE ajax_chat_invitations (
+	userID INT(11) NOT NULL,
+	channel INT(11) NOT NULL,
+	dateTime DATETIME NOT NULL,
+	PRIMARY KEY (userID, channel),
+	INDEX (dateTime)
+) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;