From eb21bbdd550e4d1efc9a4c6e506eb64ba2cf9842 Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
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

