Просмотр архива Комеди баттл

DROP TABLE IF EXISTS `comedy_battle`;
CREATE TABLE `comedy_battle` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `time` int(11) NOT NULL,
  `time_close`
int(11) DEFAULT '0',
  `status` int(11) DEFAULT '0',
  `count_user` int(11)
DEFAULT '0',
  `count_protivnik` int(11) DEFAULT '0',
  `id_user` int(11)
NOT NULL,
  `id_protivnik` int(11) NOT NULL,
  `text_user` varchar(1024)
NOT NULL,
  `text_protivnik` varchar(1024) NOT NULL,
  `win` int(11)
DEFAULT NULL,
  `ban` int(1) DEFAULT '0',
  `id_ban` int(11) DEFAULT '0',
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT
CHARSET=utf8;

DROP TABLE IF EXISTS `comedy_info`;
CREATE TABLE
`comedy_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11)
NOT NULL,
  `win` int(11) DEFAULT '0',
  `draw` int(11) DEFAULT '0',
 
`lesions` int(11) DEFAULT '0',
  `rating` int(11) DEFAULT '0',
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

DROP
TABLE IF EXISTS `comedy_votes`;
CREATE TABLE `comedy_votes` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
 
`id_battle` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;