From 1b40945878f33ab4b8af8089ea6c5be02b9d0761 Mon Sep 17 00:00:00 2001 From: Patrick Davison Date: Tue, 14 Jan 2014 02:59:16 -0800 Subject: Channellist preperations. - Fixes with regards to close() which apparently means DESTROY or something retarded. --- update notes.txt | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) (limited to 'update notes.txt') diff --git a/update notes.txt b/update notes.txt index 1ff219c..df95be1 100644 --- a/update notes.txt +++ b/update notes.txt @@ -1,3 +1,22 @@ + +Add Table: + +CREATE TABLE IF NOT EXISTS `chatUsers` ( + `ID` int(11) NOT NULL AUTO_INCREMENT, + `userID` int(11) NOT NULL, + `channel` int(11) NOT NULL, + `client` varchar(16) NOT NULL, + `dateEntered` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + `dateLastActive` timestamp NULL DEFAULT NULL, + `isHere` tinyint(1) NOT NULL, + `isAdmin` tinyint(1) NOT NULL, + `isMod` tinyint(1) NOT NULL, + PRIMARY KEY (`ID`), + KEY `userID` (`userID`,`channel`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; + + + -- Did we do everything below? I think we did.. Jan 13 2014? For next update: - Move the new columns from BlueRaja's database over to your other databases (see also: db updates.sql. Most, but not all, are in there. I don't think Snap added his stuff there). Make sure to get not only the type, but nullable/default as well. -- cgit v1.2.3