Просмотр архива Хата, соцка на DCMS 664

CREATE TABLE IF NOT EXISTS `guard_attempt_hacks` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `user` int(11) NOT NULL,
  `query` varchar(3000) NOT
NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB 
DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `guard_hackers` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL,
  `time`
int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT
CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `guard_janitor` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) DEFAULT NULL,
 
`user_agent` varchar(1000) DEFAULT NULL,
  `ip` varchar(1000) DEFAULT
NULL,
  `proxy_ip` varchar(1000) DEFAULT NULL,
  `referer` varchar(1000)
DEFAULT NULL,
  `method` varchar(1000) DEFAULT NULL,
  `php_self`
varchar(1000) DEFAULT NULL,
  `query_string` varchar(1000) DEFAULT NULL,

 `speed` float NOT NULL,
  `hack` int(11) NOT NULL,
  `overload` int(11)
NOT NULL,
  `time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB  DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS
`guard_links` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `link`
varchar(1000) NOT NULL,
  KEY `id` (`id`)
) ENGINE=InnoDB  DEFAULT
CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `guard_potential_spamers` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL,
  `time`
int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT
CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `guard_suspic_msgs` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL,
  `msg`
varchar(3000) NOT NULL,
  `module` varchar(100) DEFAULT NULL,
  `time`
int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT
CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `guard_users_nicks` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;