Просмотр архива Копия Napumbe

ALTER TABLE `user` ADD `FUTBOL_act` INT (10) NOT NULL default '0';
ALTER
TABLE `user` ADD `FUTBOL_energi` INT (10) NOT NULL default '0';
ALTER
TABLE `user` ADD `FUTBOL_vg` INT (10) NOT NULL default '0';
ALTER TABLE
`user` ADD `FUTBOL_vk` VARCHAR( 32 ) NOT NULL ;
ALTER TABLE `user` ADD
`FUTBOL_gool` INT (10) NOT NULL default '0';
ALTER TABLE `user` ADD
`FUTBOL_set` int(11) NOT NULL DEFAULT '0';


CREATE TABLE IF NOT EXISTS
`FUTBOL` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11)
NOT NULL,
  `balls` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `sex`
varchar(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;


CREATE TABLE `FUTBOL_UDAR` (
`id`
int(11) NOT NULL auto_increment,
`id_user` int(11) NOT NULL,
`time`
int(11) NOT NULL,
`type` text(1024) NOT NULL,
PRIMARY KEY  (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS
`FUTBOL_komm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id`
int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `msg` varchar(1024) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `FUTBOL_reward` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `balls`
int(11) NOT NULL,
  `money` int(11) NOT NULL,
  `rating` int(11) NOT
NULL,
  `female` varchar(5) NOT NULL,
  `mail` int(2) NOT NULL,
  `time`
int(11) NOT NULL,
  `stop` int(11) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

CREATE TABLE IF
NOT EXISTS `FUTBOL_result` (
  `men` int(10) NOT NULL,
  `women` int(10)
NOT NULL,
  `null` int(11) NOT NULL,
  `stop` int(11) NOT NULL,
  `off`
int(11) NOT NULL DEFAULT '0',
  `money` int(11) NOT NULL,
  `money_on`
int(11) NOT NULL,
  `balls` int(11) NOT NULL,
  `balls_on` int(11) NOT
NULL,
  `rating` int(11) NOT NULL,
  `rating_on` int(11) NOT NULL
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `FUTBOL_result` (`men`,
`women`, `null`, `stop`, `off`, `money`, `money_on`, `balls`, `balls_on`,
`rating`, `rating_on`) VALUES
(0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0);