aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorteacher <none@none>2010-03-25 00:01:02 +0100
committerteacher <none@none>2010-03-25 00:01:02 +0100
commitbaf946bdc74221e0c2873e42da7e2bfad9fe18a7 (patch)
treeb932384ddc571c58a8067a4540104e1458268871 /sql/updates
parent99e186c8303e02d61130113b59e0a6baba30eacf (diff)
Changed default value for WDBVerified field for better future handling.
--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
6 files changed, 6 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