diff options
| author | megamage <none@none> | 2008-12-27 11:31:14 -0600 |
|---|---|---|
| committer | megamage <none@none> | 2008-12-27 11:31:14 -0600 |
| commit | 8a337e26c5c41bc126f6fd0b3bfbb783fc6b8aa4 (patch) | |
| tree | 3d50697c51d344a193e1510aae56ce217bc83acb /sql | |
| parent | bf6e13c8bde0ef08691b4831a0732caf06f3c0c1 (diff) | |
| parent | d5e9d0b2c4389998cdbed7cf8fc6fb81c2a22829 (diff) | |
*HG 681.
--HG--
branch : trunk
Diffstat (limited to 'sql')
| -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 | ||||
| -rw-r--r-- | sql/updates/678_world_scripts.sql | 1 |
4 files changed, 2 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 diff --git a/sql/updates/678_world_scripts.sql b/sql/updates/678_world_scripts.sql new file mode 100644 index 00000000000..15d43204734 --- /dev/null +++ b/sql/updates/678_world_scripts.sql @@ -0,0 +1 @@ +update creature_template set scriptname='npc_deathstalker_erland' where entry=1978;
\ No newline at end of file |