mirror of
https://github.com/sebastian-heinz/Arrowgene.DragonsDogmaOnline
synced 2026-08-03 11:12:41 -04:00
17 lines
786 B
MySQL
17 lines
786 B
MySQL
|
CREATE TABLE "ddon_clan_shop_purchases"
|
||
|
|
(
|
||
|
|
"clan_id" INTEGER NOT NULL,
|
||
|
|
"lineup_id" INTEGER NOT NULL,
|
||
|
|
CONSTRAINT "pk_ddon_clan_shop_purchases" PRIMARY KEY ("clan_id", "lineup_id"),
|
||
|
|
CONSTRAINT "fl_ddon_clan_shop_purchases_clan_id" FOREIGN KEY ("clan_id") REFERENCES "ddon_clan_param" ("clan_id") ON DELETE CASCADE
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE "ddon_clan_base_customization"
|
||
|
|
(
|
||
|
|
"clan_id" INTEGER NOT NULL,
|
||
|
|
"type" INTEGER NOT NULL,
|
||
|
|
"furniture_id" INTEGER NOT NULL,
|
||
|
|
CONSTRAINT "pk_ddon_clan_base_customization" PRIMARY KEY ("clan_id", "type"),
|
||
|
|
CONSTRAINT "fl_ddon_clan_base_customization_clan_id" FOREIGN KEY ("clan_id") REFERENCES "ddon_clan_param" ("clan_id") ON DELETE CASCADE
|
||
|
|
);
|