From d6ddc6410c9c9cde6f6960bf57207b007195cf6c Mon Sep 17 00:00:00 2001 From: Machiavelli Date: Sun, 6 Mar 2011 23:45:22 +0100 Subject: Core/Vehicles: Rename vehicle_accessory to vehicle_template_accessory, and implement a new table named vehicle_accessory to allow accessory definitions based on GUID that will overwrite defeinitions based on entry. Fixes #Nay --- sql/updates/world/2011_03_06_5_world_vehicle_accessory.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 sql/updates/world/2011_03_06_5_world_vehicle_accessory.sql (limited to 'sql') diff --git a/sql/updates/world/2011_03_06_5_world_vehicle_accessory.sql b/sql/updates/world/2011_03_06_5_world_vehicle_accessory.sql new file mode 100644 index 00000000000..0f95f9dc6ad --- /dev/null +++ b/sql/updates/world/2011_03_06_5_world_vehicle_accessory.sql @@ -0,0 +1,12 @@ +RENAME TABLE `vehicle_accessory` TO `vehicle_template_accessory`; + +CREATE TABLE IF NOT EXISTS `vehicle_accessory` ( + `guid` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0, + `accessory_entry` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0, + `seat_id` TINYINT(1) NOT NULL DEFAULT 0, + `minion` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, + `description` TEXT NOT NULL, + `summontype` TINYINT(3) UNSIGNED NOT NULL DEFAULT 6 COMMENT 'see enum TempSummonType', + `summontimer` INT(10) UNSIGNED NOT NULL DEFAULT 30000 COMMENT 'timer, only relevant for certain summontypes', + PRIMARY KEY (`guid`,`seat_id`) +) ENGINE=MYISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED -- cgit v1.2.3