Просмотр архива DCMS Special v 7.3.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',
  `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;