2024-08-09 14:54:07 -07:00
|
|
|
CREATE TABLE "ddon_preset_ability" (
|
2024-08-10 15:23:45 -07:00
|
|
|
"character_id" INTEGER NOT NULL,
|
|
|
|
|
"preset_no" INTEGER NOT NULL,
|
|
|
|
|
"preset_name" TEXT,
|
|
|
|
|
"ability_1" INTEGER,
|
|
|
|
|
"ability_2" INTEGER,
|
|
|
|
|
"ability_3" INTEGER,
|
|
|
|
|
"ability_4" INTEGER,
|
|
|
|
|
"ability_5" INTEGER,
|
|
|
|
|
"ability_6" INTEGER,
|
|
|
|
|
"ability_7" INTEGER,
|
|
|
|
|
"ability_8" INTEGER,
|
|
|
|
|
"ability_9" INTEGER,
|
|
|
|
|
"ability_10" INTEGER,
|
2024-08-09 14:54:07 -07:00
|
|
|
CONSTRAINT "fk_preset_ability" FOREIGN KEY("character_id") REFERENCES "ddon_character"("character_id") ON DELETE CASCADE
|
2024-08-10 15:23:45 -07:00
|
|
|
CONSTRAINT "pk_preset_ability" PRIMARY KEY("character_id","preset_no")
|
2024-08-09 14:54:07 -07:00
|
|
|
);
|
|
|
|
|
|
|
|
|
|
DELETE FROM "ddon_equipped_ability";
|
