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.
    (We need to do this in a more sensible way in the future... sorry)
- Drop the 'statistics' table.  It's not needed anymore.
- Delete the lines relating to '$mysqlid' from db.inc.php (which I can't do, since that file is not versioned).
  Those lines have been moved to sqlEmbedded.php.  The only thing that should be left are the four lines defining the servername/username/etc.
- Open includes\playerStats.php, and set CP_EARLIEST_DATE to the date we want to start counting ties/wins/champion points from.
  We could also pretty easily recalculate the other stats (mazes and total moves) from that date, if you want; then that date would be like the 'start' of pathery.
- Go to the admin page in the browser, and click on the button that says "recalculate player statistics."  All the above steps must be done before this.


Notes from previous updates: