From eb21bbdd550e4d1efc9a4c6e506eb64ba2cf9842 Mon Sep 17 00:00:00 2001 From: friendica Date: Mon, 27 Jan 2014 18:37:06 -0800 Subject: Ajaxchat package has way too many incompatible assumptions - after a lot of review, we can't work with it without re-writing huge chunks. Think I'll just start fresh. Ajax chat isn't that hard and we can do stuff with it that you just can't do with other chat clients because - well we've got zot. --- library/ajaxchat/chat/chat.sql | 47 ------------------------------------------ 1 file changed, 47 deletions(-) delete mode 100644 library/ajaxchat/chat/chat.sql (limited to 'library/ajaxchat/chat/chat.sql') diff --git a/library/ajaxchat/chat/chat.sql b/library/ajaxchat/chat/chat.sql deleted file mode 100644 index 5e7efea35..000000000 --- a/library/ajaxchat/chat/chat.sql +++ /dev/null @@ -1,47 +0,0 @@ - -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; -- cgit v1.2.3