ALTER TABLE `{$prefix}scorehistory_s1_t1` CHANGE `ranking_id` `ranking_id` INT UNSIGNED NOT NULL, CHANGE `score_order` `score_order` INT UNSIGNED NOT NULL DEFAULT '0', CHANGE `type` `type` TINYINT UNSIGNED NOT NULL DEFAULT '0', CHANGE `source_id` `source_id` INT UNSIGNED NOT NULL, CHANGE `user_id` `user_id` INT UNSIGNED NOT NULL, CHANGE `score` `score` INT UNSIGNED NOT NULL, CHANGE `full` `full` SMALLINT UNSIGNED NOT NULL DEFAULT '0', CHANGE `toto` `toto` SMALLINT UNSIGNED NOT NULL DEFAULT '0', CHANGE `goal_bonus` `goal_bonus` SMALLINT UNSIGNED NOT NULL DEFAULT '0', CHANGE `goal_diff_bonus` `goal_diff_bonus` SMALLINT UNSIGNED NOT NULL DEFAULT '0', CHANGE `total_score` `total_score` INT UNSIGNED NOT NULL DEFAULT '0', CHANGE `ranking` `ranking` INT UNSIGNED NOT NULL;
ALTER TABLE `{$prefix}scorehistory_s1_t2` CHANGE `ranking_id` `ranking_id` INT UNSIGNED NOT NULL, CHANGE `score_order` `score_order` INT UNSIGNED NOT NULL DEFAULT '0', CHANGE `type` `type` TINYINT UNSIGNED NOT NULL DEFAULT '0', CHANGE `source_id` `source_id` INT UNSIGNED NOT NULL, CHANGE `user_id` `user_id` INT UNSIGNED NOT NULL, CHANGE `score` `score` INT UNSIGNED NOT NULL, CHANGE `full` `full` SMALLINT UNSIGNED NOT NULL DEFAULT '0', CHANGE `toto` `toto` SMALLINT UNSIGNED NOT NULL DEFAULT '0', CHANGE `goal_bonus` `goal_bonus` SMALLINT UNSIGNED NOT NULL DEFAULT '0', CHANGE `goal_diff_bonus` `goal_diff_bonus` SMALLINT UNSIGNED NOT NULL DEFAULT '0', CHANGE `total_score` `total_score` INT UNSIGNED NOT NULL DEFAULT '0', CHANGE `ranking` `ranking` INT UNSIGNED NOT NULL;
