aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorXanadu <none@none>2010-03-25 17:09:45 +0100
committerXanadu <none@none>2010-03-25 17:09:45 +0100
commitd0c10d44b87b8a5fb0a2c0db19bf1468d1be4246 (patch)
treeb38b1d72679b2a90e841af1fe09674e9279e7026 /sql/updates
parent20de79f6baae006c4536cadb3d1a598bcb792363 (diff)
parent7d6923d8c764f6f0de0a82133c80add8eaf85dd1 (diff)
Merge
--HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/7692_world_creature_template.sql1
-rw-r--r--sql/updates/7692_world_gameobject_template.sql1
-rw-r--r--sql/updates/7692_world_item_template.sql1
-rw-r--r--sql/updates/7692_world_npc_text.sql1
-rw-r--r--sql/updates/7692_world_page_text.sql1
-rw-r--r--sql/updates/7692_world_quest_template.sql1
-rw-r--r--sql/updates/7694_world_npc_trainer.sql2
-rw-r--r--sql/updates/7694_world_npc_vendor.sql2
8 files changed, 10 insertions, 0 deletions
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
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;
+