Pastebin launched a little side project called HostCabi.net, check it out ;-)Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: big_buka on Jan 28th, 2012  |  syntax: SQL  |  size: 1.71 KB  |  hits: 47  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1.  
  2. CREATE TABLE IF NOT EXISTS `ban_hwid` (
  3.   `ban_id` INT(11) NOT NULL,
  4.   `HWID` VARCHAR(100) COLLATE utf8_bin NOT NULL,
  5.   `useHWID` tinyint(1) NOT NULL DEFAULT '1',
  6.   KEY `ban_id` (`ban_id`,`HWID`)
  7. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  8.  
  9. -- --------------------------------------------------------
  10.  
  11. CREATE TABLE IF NOT EXISTS `ban_ip` (
  12.   `ban_id` INT(11) NOT NULL,
  13.   `ban_ip` VARCHAR(15) COLLATE utf8_bin NOT NULL DEFAULT '127.0.0.1',
  14.   KEY `ban_id` (`ban_id`,`ban_ip`)
  15. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  16.  
  17. -- --------------------------------------------------------
  18.  
  19.  
  20. CREATE TABLE IF NOT EXISTS `ban_nick` (
  21.   `ban_id` INT(11) NOT NULL,
  22.   `nick` VARCHAR(50) COLLATE utf8_bin NOT NULL,
  23.   KEY `ban_id` (`ban_id`,`nick`)
  24. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  25.  
  26. -- --------------------------------------------------------
  27.  
  28. CREATE TABLE IF NOT EXISTS `ban_reason` (
  29.   `ban_id` INT(11) NOT NULL,
  30.   `ban_reason` mediumtext CHARACTER SET cp1251 COLLATE cp1251_bin NOT NULL,
  31.   KEY `ban_id` (`ban_id`)
  32. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  33.  
  34. -- --------------------------------------------------------
  35.  
  36. CREATE TABLE IF NOT EXISTS `ban_unbantime` (
  37.   `ban_id` INT(11) NOT NULL,
  38.   `ban_unbanTime` datetime NOT NULL,
  39.   `use_unbanTime` INT(1) NOT NULL,
  40.   `ban_banTime` datetime NOT NULL,
  41.   KEY `ban_id` (`ban_id`)
  42. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  43.  
  44. -- --------------------------------------------------------
  45.  
  46.  
  47. CREATE TABLE IF NOT EXISTS `ban_xuid` (
  48.   `ban_id` INT(11) NOT NULL,
  49.   `ban_XUID` VARCHAR(16) COLLATE utf8_bin NOT NULL,
  50.   KEY `ban_id` (`ban_id`,`ban_XUID`)
  51. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;