aboutsummaryrefslogtreecommitdiffstats
path: root/library/ajaxchat/chat/chat.sql
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2014-01-27 18:37:06 -0800
committerfriendica <info@friendica.com>2014-01-27 18:37:06 -0800
commiteb21bbdd550e4d1efc9a4c6e506eb64ba2cf9842 (patch)
tree887fbfc6ba78c4c2e12d0361003b33c6e76926ac /library/ajaxchat/chat/chat.sql
parent3100b5d93e9f440a17b99d2856ee022b29d73f80 (diff)
downloadvolse-hubzilla-eb21bbdd550e4d1efc9a4c6e506eb64ba2cf9842.tar.gz
volse-hubzilla-eb21bbdd550e4d1efc9a4c6e506eb64ba2cf9842.tar.bz2
volse-hubzilla-eb21bbdd550e4d1efc9a4c6e506eb64ba2cf9842.zip
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.
Diffstat (limited to 'library/ajaxchat/chat/chat.sql')
-rw-r--r--library/ajaxchat/chat/chat.sql47
1 files changed, 0 insertions, 47 deletions
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;