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

CREATE TABLE IF NOT EXISTS `forum_f` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `pos` int(11) NOT
NULL,
  `opis` varchar(512) NOT NULL,
  `adm` set('0','1') NOT NULL
DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `forum_files` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `id_post` int(11) NOT NULL,
  `name`
varchar(64) DEFAULT NULL,
  `ras` varchar(32) NOT NULL,
  `size` int(11)
NOT NULL,
  `type` varchar(32) NOT NULL,
  `count` int(11) NOT NULL
DEFAULT '0',
  `rating` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY
(`id`),
  KEY `id_post` (`id_post`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `forum_files_rating` (

 `id_file` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `rating`
int(11) DEFAULT '0',
  KEY `id_file` (`id_file`),
  KEY `id_user`
(`id_user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT
EXISTS `forum_opr` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_them`
int(11) NOT NULL,
  `var` varchar(512) CHARACTER SET utf8 NOT NULL,
 
`id_forum` int(11) NOT NULL,
  `id_razdel` int(11) NOT NULL,
  `id_post`
int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS
`forum_opres` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_forum`
int(11) NOT NULL,
  `id_razdel` int(11) NOT NULL,
  `id_them` int(11) NOT
NULL,
  `id_post` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
 
`id_var` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `forum_p`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_forum` int(11) NOT
NULL,
  `id_razdel` int(11) NOT NULL,
  `id_them` int(11) NOT NULL,
 
`id_user` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `msg`
varchar(10000) NOT NULL,
  `cit` int(11) DEFAULT NULL,
  `opros`
enum('0','1') NOT NULL DEFAULT '0',
  `red` int(1) NOT NULL DEFAULT '0',

 `rating` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY
`id_user` (`id_user`),
  KEY `time` (`time`),
  KEY `id_forum`
(`id_forum`),
  KEY `id_razdel` (`id_razdel`),
  KEY `id_them`
(`id_them`),
  FULLTEXT KEY `msg` (`msg`)
) ENGINE=MyISAM  DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS
`forum_phis` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_forum`
int(11) NOT NULL,
  `id_razdel` int(11) NOT NULL,
  `id_them` int(11) NOT
NULL,
  `id_post` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
 
`msg` varchar(1024) NOT NULL,
  `data` int(11) NOT NULL,
  PRIMARY KEY
(`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `forum_p_rating` (
 
`id_user` int(11) NOT NULL,
  `id_post` int(11) NOT NULL,
  `rating`
int(11) DEFAULT '0',
  KEY `id_them` (`id_user`),
  KEY `id_user`
(`id_post`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT
EXISTS `forum_r` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_forum`
int(11) NOT NULL,
  `name` varchar(32) NOT NULL,
  `time` int(11) NOT
NULL,
  PRIMARY KEY (`id`),
  KEY `id_forum` (`id_forum`,`time`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


CREATE TABLE IF
NOT EXISTS `forum_t` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`id_forum` int(11) NOT NULL,
  `id_razdel` int(11) DEFAULT NULL,
  `name`
varchar(32) NOT NULL,
  `id_user` int(11) DEFAULT NULL,
  `time_create`
int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `up` set('0','1') NOT NULL
DEFAULT '0',
  `close` set('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY
(`id`),
  KEY `id_forum` (`id_forum`,`id_razdel`),
  FULLTEXT KEY `name`
(`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;


CREATE TABLE IF NOT EXISTS `forum_zakl` (
  `id_user` int(11) NOT
NULL,
  `id_them` int(11) NOT NULL,
  `time` int(11) NOT NULL,
 
`time_obn` int(11) NOT NULL,
  KEY `id_user`
(`id_user`,`id_them`,`time`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `forum_zhal` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `id_forum` int(11) NOT NULL,
 
`id_razdel` int(11) NOT NULL,
  `id_them` int(11) NOT NULL,
  `id_post`
int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `data` int(11) NOT
NULL,
  `msg` varchar(512) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY
(`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1 ;