mirror of
https://github.com/ProjectSkyfire/SkyFire_548
synced 2026-08-18 06:32:13 -04:00
8 lines
410 B
SQL
8 lines
410 B
SQL
-- Create guid column
|
|
ALTER TABLE `group_instance` ADD `guid` INT(11) NOT NULL FIRST;
|
|
-- populate column
|
|
UPDATE `group_instance` SET `guid`=(SELECT `groups`.`guid` FROM `groups` WHERE `leaderGuid`=`group_instance`.`leaderGuid`);
|
|
-- Update pk
|
|
ALTER TABLE `group_instance` DROP PRIMARY KEY, ADD PRIMARY KEY (`guid`, `instance`);
|
|
-- Remove unused column leaderguid
|
|
ALTER TABLE `group_instance` DROP `leaderGuid`;
|