diff options
| author | Philip Nicolcev <frugen@gmail.com> | 2016-04-30 14:05:23 -0400 |
|---|---|---|
| committer | Philip Nicolcev <frugen@gmail.com> | 2016-04-30 14:05:23 -0400 |
| commit | 3e670958120317a6a778304d807e238b26bdb4ca (patch) | |
| tree | 1ccb2c97a578c2440b474d45481a445c12ae6f64 | |
| parent | 82e4babe6196f7b9b68523d026e949a5485acafb (diff) | |
| download | AJAX-Chat-3e670958120317a6a778304d807e238b26bdb4ca.zip AJAX-Chat-3e670958120317a6a778304d807e238b26bdb4ca.tar.gz AJAX-Chat-3e670958120317a6a778304d807e238b26bdb4ca.tar.bz2 | |
Use unsigned ints for userID and channel
| -rw-r--r-- | chat/changelog.txt | 8 | ||||
| -rw-r--r-- | chat/chat.sql | 15 | ||||
| -rw-r--r-- | chat/install.php | 1 |
3 files changed, 15 insertions, 9 deletions
diff --git a/chat/changelog.txt b/chat/changelog.txt index e3d0831..714f705 100644 --- a/chat/changelog.txt +++ b/chat/changelog.txt @@ -870,3 +870,11 @@ Bugfixes: Misc: - Removed unneeded call to mt_srand() - thanks to Joshua Embrey. + +Version 0.8.9 (??.??.2016) +------------------------------- +Bugfixes: +- French translation typo fixed. - thanks to Excale. + +Misc: +- Database userID and channel fields changed to unsigned int. 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) diff --git a/chat/install.php b/chat/install.php index fd19e1b..63c580f 100644 --- a/chat/install.php +++ b/chat/install.php @@ -77,4 +77,3 @@ $ajaxChatInstaller = new CustomAJAXChatInstaller(); // Create the database tables: $ajaxChatInstaller->createDataBaseTables(); -?>
\ No newline at end of file |