aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorShauren <none@none>2010-08-06 12:13:13 +0200
committerShauren <none@none>2010-08-06 12:13:13 +0200
commit7cae47210ed01473d9025d7627f69adc08f989db (patch)
treed2916a1652351a13fa4480e732cdb9ac5ca1ba24 /sql
parent9cfef5c39f451fdfcd8e403dbbefd37c5321e1c9 (diff)
Added ScriptName to transports table for script system rewrite
--HG-- branch : trunk
Diffstat (limited to 'sql')
-rw-r--r--sql/base/world_database.sql1
-rw-r--r--sql/updates/9189_world_transports.sql1
2 files changed, 2 insertions, 0 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 3365b352406..87c843618da 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -14728,6 +14728,7 @@ CREATE TABLE `transports` (
`entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
`name` text,
`period` mediumint(8) unsigned NOT NULL DEFAULT '0',
+ `ScriptName` char(64) NOT NULL DEFAULT '',
PRIMARY KEY (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Transports';
/*!40101 SET character_set_client = @saved_cs_client */;
diff --git a/sql/updates/9189_world_transports.sql b/sql/updates/9189_world_transports.sql
new file mode 100644
index 00000000000..da3d2245c54
--- /dev/null
+++ b/sql/updates/9189_world_transports.sql
@@ -0,0 +1 @@
+ALTER TABLE `transports` ADD `ScriptName` char(64) NOT NULL DEFAULT '' AFTER `period`;