diff options
author | marijus <mario@localhost.localdomain> | 2014-01-30 00:08:40 +0100 |
---|---|---|
committer | marijus <mario@localhost.localdomain> | 2014-01-30 00:08:40 +0100 |
commit | a58239b9a8d8c35fa0e0b916617fa53d1014da58 (patch) | |
tree | 4ebaf732d319efb80d9edebd941fb0be9e35cc06 /library/ajaxchat/chat/chat.sql | |
parent | b39475db86eca7b5e5615d377d8adc64e6a33056 (diff) | |
parent | fe2b6f3dfb4a9473905dde49b7741a6c03699c23 (diff) | |
download | volse-hubzilla-a58239b9a8d8c35fa0e0b916617fa53d1014da58.tar.gz volse-hubzilla-a58239b9a8d8c35fa0e0b916617fa53d1014da58.tar.bz2 volse-hubzilla-a58239b9a8d8c35fa0e0b916617fa53d1014da58.zip |
Merge branch 'upstream'
Diffstat (limited to 'library/ajaxchat/chat/chat.sql')
-rw-r--r-- | library/ajaxchat/chat/chat.sql | 47 |
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; |