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

CREATE TABLE IF NOT EXISTS `loads_dop` (
  `name` varchar(256) NOT NULL,

 `size` int(11) NOT NULL,
  `loads` int(11) NOT NULL DEFAULT '0',
 
`path` varchar(1000) NOT NULL DEFAULT '/',
  KEY `name` (`name`),
  KEY
`size` (`size`),
  KEY `loads` (`loads`),
  FULLTEXT KEY `path_2`
(`path`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE
`loads_komm` (
  `id` int(11) NOT NULL auto_increment,
  `file`
varchar(64) NOT NULL,
  `path` varchar(1024) NOT NULL,
  `time` int(11)
NOT NULL,
  `msg` varchar(512) NOT NULL,
  `id_user` int(11) NOT NULL,
 
PRIMARY KEY  (`id`),
  KEY `file` (`file`),
  KEY `path` (`path`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS
`loads_list` (
  `name` varchar(256) NOT NULL,
  `id_user` int(11) NOT
NULL,
  `size` int(11) NOT NULL,
  `path` varchar(1000) NOT NULL DEFAULT
'/',
  `time` int(11) NOT NULL,
  `time_r` int(11) NOT NULL,
  `rating`
int(11) NOT NULL DEFAULT '0',
  `kol` int(11) NOT NULL DEFAULT '0',
 
`user` varchar(128) NOT NULL,
  `loads` int(11) NOT NULL DEFAULT '0',
 
`prosm` int(11) NOT NULL DEFAULT '0',
  `opis` varchar(1024) NOT NULL,
 
KEY `time` (`time`),
  KEY `time_r` (`time_r`),
  KEY `size` (`size`),
 
KEY `name` (`name`),
  KEY `id_user` (`id_user`),
  KEY `loads`
(`loads`),
  KEY `prosm` (`prosm`),
  KEY `rating` (`rating`),
  KEY
`kol` (`kol`),
  KEY `user` (`user`),
  FULLTEXT KEY `path_2` (`path`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS
`loads_rating` (
  `id_user` int(32) NOT NULL,
  `name` varchar(1024) NOT
NULL,
  `path` varchar(1000) NOT NULL DEFAULT '/',
  KEY `id_user`
(`id_user`),
  KEY `name` (`name`),
  FULLTEXT KEY `path_2` (`path`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;