Просмотр архива New Top System

CREATE TABLE IF NOT EXISTS `ip_ban` (
  `ip` varchar(45) NOT NULL,
 
`reason` varchar(200) NOT NULL DEFAULT '',
  `until_time` int UNSIGNED NOT
NULL DEFAULT 0,
  `time_add` int UNSIGNED NOT NULL DEFAULT 0,
  `admin_id`
int UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`ip`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT
EXISTS `cheat_log` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `pf`
int UNSIGNED NOT NULL DEFAULT 0,
  `ip` varchar(45) NOT NULL DEFAULT '',
 
`ua` varchar(255) NOT NULL DEFAULT '',
  `kind` varchar(10) NOT NULL
DEFAULT 'hit',
  `reason` varchar(32) NOT NULL DEFAULT '',
  `time` int
UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `time` (`time`),
 
KEY `ip` (`ip`),
  KEY `reason` (`reason`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;