SHARE
TWEET

Untitled

a guest Dec 12th, 2018 73 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- Create syntax for TABLE 'ajax_chat_bans'
  2. CREATE TABLE `ajax_chat_bans` (
  3.   `userID` int(11) NOT NULL,
  4.   `userName` varchar(64) COLLATE utf8_bin NOT NULL,
  5.   `dateTime` datetime NOT NULL,
  6.   `ip` varbinary(16) NOT NULL
  7. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  8.  
  9. -- Create syntax for TABLE 'ajax_chat_invitations'
  10. CREATE TABLE `ajax_chat_invitations` (
  11.   `userID` int(11) NOT NULL,
  12.   `channel` int(11) NOT NULL,
  13.   `dateTime` datetime NOT NULL
  14. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  15.  
  16. -- Create syntax for TABLE 'ajax_chat_messages'
  17. CREATE TABLE `ajax_chat_messages` (
  18.   `id` int(11) NOT NULL AUTO_INCREMENT,
  19.   `userID` int(11) NOT NULL,
  20.   `userName` varchar(64) COLLATE utf8_bin NOT NULL,
  21.   `userRole` int(1) NOT NULL,
  22.   `channel` int(11) NOT NULL,
  23.   `dateTime` datetime NOT NULL,
  24.   `ip` varbinary(16) NOT NULL,
  25.   `text` text COLLATE utf8_bin,
  26.   PRIMARY KEY (`id`)
  27. ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  28.  
  29. -- Create syntax for TABLE 'ajax_chat_online'
  30. CREATE TABLE `ajax_chat_online` (
  31.   `userID` int(11) NOT NULL,
  32.   `userName` varchar(64) COLLATE utf8_bin NOT NULL,
  33.   `userRole` int(1) NOT NULL,
  34.   `channel` int(11) NOT NULL,
  35.   `dateTime` datetime NOT NULL,
  36.   `ip` varbinary(16) NOT NULL
  37. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top