mirror of
https://github.com/araxiaonline/OneDB.git
synced 2026-06-13 03:02:22 -04:00
37 lines
1.2 KiB
SQL
37 lines
1.2 KiB
SQL
/*
|
|
Add build column to *_properties tables
|
|
*/
|
|
|
|
ALTER TABLE `creature_properties`
|
|
ADD COLUMN `build` SMALLINT(6) NOT NULL DEFAULT 12340 AFTER `entry`,
|
|
DROP PRIMARY KEY,
|
|
ADD PRIMARY KEY (`entry`,`build`),
|
|
ADD UNIQUE KEY `unique_index` (`entry`,`build`) USING BTREE;
|
|
|
|
ALTER TABLE `gameobject_properties`
|
|
ADD COLUMN `build` SMALLINT(6) NOT NULL DEFAULT 12340 AFTER `entry`,
|
|
DROP PRIMARY KEY,
|
|
ADD PRIMARY KEY (`entry`,`build`),
|
|
ADD UNIQUE KEY `unique_index` (`entry`,`build`) USING BTREE;
|
|
|
|
ALTER TABLE `item_properties`
|
|
ADD COLUMN `build` SMALLINT(6) NOT NULL DEFAULT 12340 AFTER `entry`,
|
|
DROP PRIMARY KEY,
|
|
ADD PRIMARY KEY (`entry`,`build`),
|
|
ADD UNIQUE KEY `unique_index` (`entry`,`build`) USING BTREE;
|
|
|
|
ALTER TABLE `quest_properties`
|
|
ADD COLUMN `build` SMALLINT(6) NOT NULL DEFAULT 12340 AFTER `entry`,
|
|
DROP PRIMARY KEY,
|
|
ADD PRIMARY KEY (`entry`,`build`),
|
|
ADD UNIQUE KEY `unique_index` (`entry`,`build`) USING BTREE;
|
|
|
|
ALTER TABLE `worldmap_info`
|
|
ADD COLUMN `build` SMALLINT(6) NOT NULL DEFAULT 12340 AFTER `entry`,
|
|
DROP PRIMARY KEY,
|
|
ADD PRIMARY KEY (`entry`,`build`),
|
|
ADD UNIQUE KEY `unique_index` (`entry`,`build`) USING BTREE;
|
|
|
|
DELETE FROM `world_db_version`;
|
|
INSERT INTO `world_db_version` VALUES ('20180331-00_build_creature_properties');
|