diff options
| author | Machiavelli <machiavelli.trinity@gmail.com> | 2011-03-06 23:45:22 +0100 |
|---|---|---|
| committer | Machiavelli <machiavelli.trinity@gmail.com> | 2011-03-06 23:45:22 +0100 |
| commit | d6ddc6410c9c9cde6f6960bf57207b007195cf6c (patch) | |
| tree | f890ea3f19f95dc64e5db772d9d2f5e825ef2456 /sql | |
| parent | 4437cb9e3cf13c6dcee88689b36ac8b921a43811 (diff) | |
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
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2011_03_06_5_world_vehicle_accessory.sql | 12 |
1 files changed, 12 insertions, 0 deletions
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 |