diff options
| author | runningnak3d <none@none> | 2008-12-27 09:27:52 +0000 |
|---|---|---|
| committer | runningnak3d <none@none> | 2008-12-27 09:27:52 +0000 |
| commit | 46aa1294aa9a0f7cdc1c279d7503ed0717778b28 (patch) | |
| tree | da33b1dbbc4e18b230d32a96b136f49dfcb5175e /sql/updates | |
| parent | 48d84dbad4548e1efdc9c548ccd381086ae6806e (diff) | |
* More clean up.
--HG--
branch : trunk
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/541_characters.sql | 5 | ||||
| -rw-r--r-- | sql/updates/559_characters.sql | 2 | ||||
| -rw-r--r-- | sql/updates/608_world.sql | 2 |
3 files changed, 1 insertions, 8 deletions
diff --git a/sql/updates/541_characters.sql b/sql/updates/541_characters.sql index 0cca696278b..2651c069e05 100644 --- a/sql/updates/541_characters.sql +++ b/sql/updates/541_characters.sql @@ -3,11 +3,6 @@ CREATE TABLE `saved_variables` ( `NextArenaPointDistributionTime` bigint(40) UNSIGNED NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves'; -ALTER TABLE arena_team_member CHANGE games_week played_week int(10) unsigned NOT NULL default '0'; -ALTER TABLE arena_team_member CHANGE wins_week wons_week int(10) unsigned NOT NULL default '0'; -ALTER TABLE arena_team_member CHANGE games_season played_season int(10) unsigned NOT NULL default '0'; -ALTER TABLE arena_team_member CHANGE wins_season wons_season int(10) unsigned NOT NULL default '0'; - ALTER TABLE `arena_team_member` DROP COLUMN `points_to_add`; ALTER TABLE `arena_team_member` ADD COLUMN `personal_rating` int(10) UNSIGNED NOT NULL DEFAULT '0'; ALTER TABLE `characters` ADD COLUMN `arena_pending_points` int(10) UNSIGNED NOT NULL default '0' AFTER `taxi_path`; diff --git a/sql/updates/559_characters.sql b/sql/updates/559_characters.sql deleted file mode 100644 index 4544be275b2..00000000000 --- a/sql/updates/559_characters.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE characters - CHANGE COLUMN gmstate extra_flags int(11) unsigned NOT NULL default '0'; diff --git a/sql/updates/608_world.sql b/sql/updates/608_world.sql index 7e38dc43c38..5c052ecd078 100644 --- a/sql/updates/608_world.sql +++ b/sql/updates/608_world.sql @@ -163,4 +163,4 @@ INSERT INTO `spell_script_target` VALUES (46852,0,181605), -- Ribbon Pole Music (46896,0,181605), (47104,1,26401), -(49058,1,24968); -- Rocket Bot Attack
\ No newline at end of file +(49058,1,24968); -- Rocket Bot Attack |