From baf946bdc74221e0c2873e42da7e2bfad9fe18a7 Mon Sep 17 00:00:00 2001 From: teacher Date: Thu, 25 Mar 2010 00:01:02 +0100 Subject: Changed default value for WDBVerified field for better future handling. --HG-- branch : trunk --- sql/updates/7692_world_creature_template.sql | 1 + sql/updates/7692_world_gameobject_template.sql | 1 + sql/updates/7692_world_item_template.sql | 1 + sql/updates/7692_world_npc_text.sql | 1 + sql/updates/7692_world_page_text.sql | 1 + sql/updates/7692_world_quest_template.sql | 1 + 6 files changed, 6 insertions(+) create mode 100644 sql/updates/7692_world_creature_template.sql create mode 100644 sql/updates/7692_world_gameobject_template.sql create mode 100644 sql/updates/7692_world_item_template.sql create mode 100644 sql/updates/7692_world_npc_text.sql create mode 100644 sql/updates/7692_world_page_text.sql create mode 100644 sql/updates/7692_world_quest_template.sql (limited to 'sql/updates') diff --git a/sql/updates/7692_world_creature_template.sql b/sql/updates/7692_world_creature_template.sql new file mode 100644 index 00000000000..a094f2ca9f2 --- /dev/null +++ b/sql/updates/7692_world_creature_template.sql @@ -0,0 +1 @@ +ALTER TABLE `creature_template` CHANGE COLUMN `WDBVerified` `WDBVerified` smallint(5) signed DEFAULT '1'; \ No newline at end of file diff --git a/sql/updates/7692_world_gameobject_template.sql b/sql/updates/7692_world_gameobject_template.sql new file mode 100644 index 00000000000..8e9e5cb59aa --- /dev/null +++ b/sql/updates/7692_world_gameobject_template.sql @@ -0,0 +1 @@ +ALTER TABLE `gameobject_template` CHANGE COLUMN `WDBVerified` `WDBVerified` smallint(5) signed DEFAULT '1'; \ No newline at end of file diff --git a/sql/updates/7692_world_item_template.sql b/sql/updates/7692_world_item_template.sql new file mode 100644 index 00000000000..cab268a8c68 --- /dev/null +++ b/sql/updates/7692_world_item_template.sql @@ -0,0 +1 @@ +ALTER TABLE `item_template` CHANGE COLUMN `WDBVerified` `WDBVerified` smallint(5) signed DEFAULT '1'; \ No newline at end of file diff --git a/sql/updates/7692_world_npc_text.sql b/sql/updates/7692_world_npc_text.sql new file mode 100644 index 00000000000..adcb38b570f --- /dev/null +++ b/sql/updates/7692_world_npc_text.sql @@ -0,0 +1 @@ +ALTER TABLE `npc_text` CHANGE COLUMN `WDBVerified` `WDBVerified` smallint(5) signed DEFAULT '1'; \ No newline at end of file diff --git a/sql/updates/7692_world_page_text.sql b/sql/updates/7692_world_page_text.sql new file mode 100644 index 00000000000..ccbe66997e1 --- /dev/null +++ b/sql/updates/7692_world_page_text.sql @@ -0,0 +1 @@ +ALTER TABLE `page_text` CHANGE COLUMN `WDBVerified` `WDBVerified` smallint(5) signed DEFAULT '1'; \ No newline at end of file diff --git a/sql/updates/7692_world_quest_template.sql b/sql/updates/7692_world_quest_template.sql new file mode 100644 index 00000000000..1c0cb7dc47f --- /dev/null +++ b/sql/updates/7692_world_quest_template.sql @@ -0,0 +1 @@ +ALTER TABLE `quest_template` CHANGE COLUMN `WDBVerified` `WDBVerified` smallint(5) signed DEFAULT '1'; \ No newline at end of file -- cgit v1.2.3 From 808254af5056f17e695876e4d3d11b02b756079c Mon Sep 17 00:00:00 2001 From: Brian Date: Wed, 24 Mar 2010 18:36:46 -0600 Subject: * Missed SQL from previous commit --HG-- branch : trunk --- sql/updates/7694_world_npc_trainer.sql | 2 ++ sql/updates/7694_world_npc_vendor.sql | 2 ++ sql/world.sql | 4 ++-- 3 files changed, 6 insertions(+), 2 deletions(-) create mode 100644 sql/updates/7694_world_npc_trainer.sql create mode 100644 sql/updates/7694_world_npc_vendor.sql (limited to 'sql/updates') diff --git a/sql/updates/7694_world_npc_trainer.sql b/sql/updates/7694_world_npc_trainer.sql new file mode 100644 index 00000000000..0e79b01c931 --- /dev/null +++ b/sql/updates/7694_world_npc_trainer.sql @@ -0,0 +1,2 @@ +ALTER TABLE `npc_trainer` MODIFY COLUMN `spell` MEDIUMINT(8) NOT NULL DEFAULT 0; + diff --git a/sql/updates/7694_world_npc_vendor.sql b/sql/updates/7694_world_npc_vendor.sql new file mode 100644 index 00000000000..e2fcff7deb1 --- /dev/null +++ b/sql/updates/7694_world_npc_vendor.sql @@ -0,0 +1,2 @@ +ALTER TABLE `npc_vendor` MODIFY COLUMN `item` MEDIUMINT(8) NOT NULL DEFAULT 0; + diff --git a/sql/world.sql b/sql/world.sql index 903c3a593cc..646a4c6bacb 100644 --- a/sql/world.sql +++ b/sql/world.sql @@ -2093,7 +2093,7 @@ DROP TABLE IF EXISTS `game_event_npc_vendor`; CREATE TABLE `game_event_npc_vendor` ( `event` mediumint(8) unsigned NOT NULL DEFAULT '0', `guid` mediumint(8) unsigned NOT NULL DEFAULT '0', - `item` mediumint(8) unsigned NOT NULL DEFAULT '0', + `item` mediumint(8) NOT NULL DEFAULT '0', `maxcount` mediumint(8) unsigned NOT NULL DEFAULT '0', `incrtime` mediumint(8) unsigned NOT NULL DEFAULT '0', `ExtendedCost` mediumint(8) unsigned NOT NULL DEFAULT '0', @@ -3660,7 +3660,7 @@ DROP TABLE IF EXISTS `npc_trainer`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `npc_trainer` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', - `spell` mediumint(8) unsigned NOT NULL DEFAULT '0', + `spell` mediumint(8) NOT NULL DEFAULT '0', `spellcost` int(10) unsigned NOT NULL DEFAULT '0', `reqskill` smallint(5) unsigned NOT NULL DEFAULT '0', `reqskillvalue` smallint(5) unsigned NOT NULL DEFAULT '0', -- cgit v1.2.3