aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/base/world_database.sql2
-rw-r--r--sql/updates/10570_world_disables.sql3
2 files changed, 5 insertions, 0 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 72970b0d351..4265dc0434b 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -1852,6 +1852,8 @@ CREATE TABLE `disables` (
`sourceType` int(10) unsigned NOT NULL,
`entry` int(10) unsigned NOT NULL,
`flags` tinyint(3) unsigned NOT NULL default '0',
+ `params_0` varchar(255) NOT NULL default '',
+ `params_1` varchar(255) NOT NULL default '',
`comment` varchar(255) character set utf8 NOT NULL default '',
PRIMARY KEY (`sourceType`,`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
diff --git a/sql/updates/10570_world_disables.sql b/sql/updates/10570_world_disables.sql
new file mode 100644
index 00000000000..a7e1a961d4a
--- /dev/null
+++ b/sql/updates/10570_world_disables.sql
@@ -0,0 +1,3 @@
+ALTER TABLE `disables`
+ADD COLUMN params_0 varchar (255) NOT NULL default '' AFTER flags,
+ADD COLUMN params_1 VARCHAR (255) NOT NULL default '' AFTER params_0;