mirror of
https://github.com/sebastian-heinz/Arrowgene.DragonsDogmaOnline
synced 2026-08-03 11:12:41 -04:00
965478519d
- Fixed an issue with HIBO orb unlocks not applied to player on login - Fixed an issue where some HighOrb nodes were labeled as blood orbs - Fixed migration key issue
16 lines
885 B
SQL
16 lines
885 B
SQL
CREATE TABLE ddon_skill_augmentation_released_elements_copy (
|
|
"character_id" INTEGER NOT NULL,
|
|
"orb_tree_type" INTEGER NOT NULL,
|
|
"job_id" INTEGER NOT NULL,
|
|
"release_id" INTEGER NOT NULL,
|
|
CONSTRAINT pk_ddon_skill_augmentation_released_elements_copy PRIMARY KEY ("character_id", "orb_tree_type", "job_id", "release_id"),
|
|
CONSTRAINT fk_ddon_skill_augmentation_released_elements_copy_character_id FOREIGN KEY ("character_id") REFERENCES "ddon_character" ("character_id") ON DELETE CASCADE
|
|
);
|
|
|
|
INSERT INTO ddon_skill_augmentation_released_elements_copy (character_id, orb_tree_type, job_id, release_id)
|
|
SELECT character_id, 1, job_id, release_id
|
|
FROM ddon_skill_augmentation_released_elements;
|
|
|
|
DROP TABLE ddon_skill_augmentation_released_elements;
|
|
|
|
ALTER TABLE ddon_skill_augmentation_released_elements_copy RENAME TO ddon_skill_augmentation_released_elements;
|