ddon-server/Arrowgene.Ddon.Database/Files/Database/Script/crest_migration.sql

9 lines
392 B
MySQL
Raw Permalink Normal View History

2024-07-30 18:35:32 -04:00
CREATE TABLE ddon_crests (
"character_common_id" INTEGER NOT NULL,
"item_uid" VARCHAR(8) NOT NULL,
"slot" INTEGER NOT NULL,
"crest_id" INTEGER NOT NULL,
"crest_amount" INTEGER NOT NULL,
FOREIGN KEY("item_uid") REFERENCES "ddon_storage_item"("item_uid") ON DELETE CASCADE,
FOREIGN KEY("character_common_id") REFERENCES "ddon_character_common"("character_common_id") ON DELETE CASCADE
);