diff options
| author | Philip Nicolcev <frugen@gmail.com> | 2016-04-30 15:46:28 -0400 |
|---|---|---|
| committer | Philip Nicolcev <frugen@gmail.com> | 2016-04-30 15:46:28 -0400 |
| commit | bb824fabf6cb01d1a2581f4d93926986b6f3bb4c (patch) | |
| tree | 363d133610eda6ef060a4d2d5bb31a65dadf3034 /chat/chat.sql | |
| parent | 3716716f1bc45ab5962ab53393e8296ea6a13bda (diff) | |
| parent | 6a4c92984fbe42e4633a6a65792847973f7d36da (diff) | |
| download | AJAX-Chat-origin/smf.zip AJAX-Chat-origin/smf.tar.gz AJAX-Chat-origin/smf.tar.bz2 | |
Merge remote-tracking branch 'origin' into smforigin/smf
Conflicts:
chat/lib/custom.php
Diffstat (limited to 'chat/chat.sql')
| -rw-r--r-- | chat/chat.sql | 15 |
1 files changed, 7 insertions, 8 deletions
diff --git a/chat/chat.sql b/chat/chat.sql index 5e7efea..9daae49 100644 --- a/chat/chat.sql +++ b/chat/chat.sql @@ -1,10 +1,9 @@ - DROP TABLE IF EXISTS ajax_chat_online; CREATE TABLE ajax_chat_online ( - userID INT(11) NOT NULL, + userID INT(10) UNSIGNED NOT NULL, userName VARCHAR(64) NOT NULL, userRole INT(1) NOT NULL, - channel INT(11) NOT NULL, + channel INT(10) UNSIGNED NOT NULL, dateTime DATETIME NOT NULL, ip VARBINARY(16) NOT NULL, PRIMARY KEY (userID), @@ -14,10 +13,10 @@ CREATE TABLE ajax_chat_online ( DROP TABLE IF EXISTS ajax_chat_messages; CREATE TABLE ajax_chat_messages ( id INT(11) NOT NULL AUTO_INCREMENT, - userID INT(11) NOT NULL, + userID INT(10) UNSIGNED NOT NULL, userName VARCHAR(64) NOT NULL, userRole INT(1) NOT NULL, - channel INT(11) NOT NULL, + channel INT(10) UNSIGNED NOT NULL, dateTime DATETIME NOT NULL, ip VARBINARY(16) NOT NULL, text TEXT, @@ -28,7 +27,7 @@ CREATE TABLE ajax_chat_messages ( DROP TABLE IF EXISTS ajax_chat_bans; CREATE TABLE ajax_chat_bans ( - userID INT(11) NOT NULL, + userID INT(10) UNSIGNED NOT NULL, userName VARCHAR(64) NOT NULL, dateTime DATETIME NOT NULL, ip VARBINARY(16) NOT NULL, @@ -39,8 +38,8 @@ CREATE TABLE ajax_chat_bans ( DROP TABLE IF EXISTS ajax_chat_invitations; CREATE TABLE ajax_chat_invitations ( - userID INT(11) NOT NULL, - channel INT(11) NOT NULL, + userID INT(10) UNSIGNED NOT NULL, + channel INT(10) UNSIGNED NOT NULL, dateTime DATETIME NOT NULL, PRIMARY KEY (userID, channel), INDEX (dateTime) |