Просмотр архива Война Полов с выводом


CREATE TABLE IF NOT EXISTS `sexwars` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `time` int(11) NOT NULL,
  `time_end` int(11) DEFAULT
'0',
  `male` int(11) DEFAULT '0',
  `female` int(11) DEFAULT '0',
  `win`
varchar(128) DEFAULT '0',
  `active` int(1) DEFAULT '0',
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE
TABLE IF NOT EXISTS `sexwars_chat` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `time` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
 
`msg` varchar(512) DEFAULT NULL,
  `id_tournament` int(11) DEFAULT '0',
 
`sex` varchar(12) DEFAULT 'male',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM 
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS
`sexwars_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `time` int(11)
NOT NULL,
  `id_user` int(11) NOT NULL,
  `level` int(11) DEFAULT '0',
 
`sex` varchar(32) NOT NULL DEFAULT 'male',
  `rating` int(11) DEFAULT '0',

 `time_reboot` int(11) DEFAULT '0',
  `count_weapon` int(11) DEFAULT '0',
 
`count_win` int(11) DEFAULT '0',
  `count_loss` int(11) DEFAULT '0',
 
`id_tournament` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM 
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS
`sexwars_weapons` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `time`
int(11) NOT NULL,
  `id_user` int(11) DEFAULT '0',
  `id_tournament`
int(11) DEFAULT '0',
  `id_weapon` int(11) DEFAULT '1',
  `type`
varchar(32) DEFAULT 'tomate',
  `style` varchar(512) DEFAULT '',
  `sex`
varchar(128) DEFAULT 'male',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;