View file files/upload/alpha_installer/sql/db.sql

CREATE TABLE IF NOT EXISTS `WAR_SEXES` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `TIME` int(11) NOT NULL,
  `TIME_OFF` int(11) DEFAULT '0',
  `MAN` int(11) DEFAULT '0',
  `WOMAN` 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 `WAR_SEXES_USERS` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `TIME` int(11) NOT NULL,
  `USER_ID` 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',
  `TOUR_ID` int(11) DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `WAR_SEXES_WEAPONS` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `TIME` int(11) NOT NULL,
  `USER_ID` int(11) DEFAULT '0',
  `TOUR_ID` int(11) DEFAULT '0',
  `WEAPON_ID` 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;