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);