SET NAMES utf8; DROP TEMPORARY TABLE IF EXISTS `temp_round_table`; CREATE TEMPORARY TABLE `temp_round_table` ( `league_id` int(10) unsigned NOT NULL DEFAULT '0', `position` int(1) NOT NULL DEFAULT '0', `team_id` int(10) unsigned NOT NULL DEFAULT '0', `team_name` varchar(80) CHARACTER SET utf8 NOT NULL DEFAULT '', `played` double DEFAULT NULL, `won` double DEFAULT NULL, `drew` double DEFAULT NULL, `lost` double DEFAULT NULL, `scored` double DEFAULT NULL, `lossed` double DEFAULT NULL, `points` double DEFAULT NULL, `small_points` int(1) NOT NULL DEFAULT '0', `small_ballance` int(1) NOT NULL DEFAULT '0', `small_scored` int(1) NOT NULL DEFAULT '0', `history` text CHARACTER SET utf8, `exclude` int(1) NOT NULL DEFAULT '0', KEY `league_id` (`league_id`), KEY `team_id` (`team_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci; INSERT INTO `temp_round_table` VALUES (141,0,975,'GCZM Zarys Zabrze',1,0,0,1,2,5,0,0,0,0,'p',0),(141,0,976,'Vlassenroot',1,1,0,0,6,2,3,0,0,0,'w',0),(141,0,977,'FC Roma',1,0,1,0,2,2,1,0,0,0,'r',0),(141,0,978,'Fortuna',1,0,0,1,1,11,0,0,0,0,'p',0),(141,0,979,'ZZRG Bielszowice',1,1,0,0,11,1,3,0,0,0,'w',0),(141,0,980,'Mostostal KP',1,0,1,0,2,2,1,0,0,0,'r',0),(141,0,981,'Promil',1,0,0,1,2,6,0,0,0,0,'p',0),(141,0,982,'Walczymy z NadwagÄ…',1,1,0,0,5,2,3,0,0,0,'w',0); CALL fill_smallpts_09(); CALL fill_smallpts_09();