Просмотр архива DCMS Special 7.5.0

CREATE TABLE IF NOT EXISTS `rekl` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `img` varchar(100) NOT
NULL,
  `link` varchar(100) NOT NULL,
  `time_last` int(11) NOT NULL,
 
`sel` set('1','2','3','4') NOT NULL DEFAULT '1',
  `count` int(11) NOT NULL
DEFAULT '0',
  `icon` varchar(32) DEFAULT 'tag',
  `dop_str` set('0','1')
NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `sel` (`sel`),
  KEY
`time_last` (`time_last`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE
TABLE `rekl_ban` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user`
int(11) NOT NULL,
  `id_ban` int(11) NOT NULL,
  `time` int(11) NOT NULL,
 
`prich` varchar(1024) NOT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB  DEFAULT
CHARSET=utf8;

CREATE TABLE `rekl_link` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `time` int(11) NOT NULL,
 
`link` varchar(64) NOT NULL,
  `prich` varchar(1024) NOT NULL,
  PRIMARY
KEY (id)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

CREATE TABLE `rekl_story`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
 
`time` int(11) NOT NULL,
  `time_rekl` int(11) NOT NULL,
  `name`
varchar(32) NOT NULL,
  `link` varchar(64) NOT NULL,
  `sel` int(11) NOT
NULL,
  `img` varchar(64) NOT NULL,
  `money` int(11) NOT NULL,
  PRIMARY
KEY (id)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;