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

CREATE TABLE IF NOT EXISTS `guard_black_list` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `name` varchar(500) NOT NULL,
  `domains` varchar(1000)
NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT
CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `guard_dossier` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL,
  `section`
varchar(100) NOT NULL,
  `type` varchar(100) NOT NULL,
  `step`
varchar(1000) DEFAULT NULL,
  `msg` varchar(1000) DEFAULT NULL,
  `new`
int(1) DEFAULT '1',
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB  DEFAULT CHARSET=utf8;

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

CREATE TABLE IF NOT EXISTS `guard_tracking` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) DEFAULT NULL,
 
`aut_status` smallint(2) DEFAULT NULL,
  `user_agent` varchar(1000)
DEFAULT NULL,
  `ip` varchar(100) DEFAULT NULL,
  `proxy_ip` varchar(100)
DEFAULT NULL,
  `referer` varchar(100) DEFAULT NULL,
  `method`
varchar(10) DEFAULT NULL,
  `php_self` varchar(1000) DEFAULT NULL,
 
`query_string` varchar(1000) DEFAULT NULL,
  `generation` float DEFAULT
'0',
  `time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
 DEFAULT CHARSET=utf8;

ALTER TABLE `user` ADD `last_msg` INT DEFAULT '0'
NOT NULL;