mirror of
https://github.com/sebastian-heinz/Arrowgene.DragonsDogmaOnline
synced 2026-08-03 11:12:41 -04:00
16 lines
656 B
SQL
16 lines
656 B
SQL
UPDATE ddon_storage SET slot_max=30 WHERE storage_type=14;
|
|
UPDATE ddon_storage SET slot_max=90 WHERE storage_type=15;
|
|
|
|
DROP TABLE ddon_system_mail_attachment;
|
|
CREATE TABLE "ddon_system_mail_attachment" (
|
|
"attachment_id" INTEGER NOT NULL,
|
|
"message_id" INTEGER NOT NULL,
|
|
"attachment_type" INTEGER NOT NULL,
|
|
"is_received" BOOLEAN NOT NULL DEFAULT FALSE,
|
|
"param0" VARCHAR(256) NOT NULL DEFAULT "",
|
|
"param1" INTEGER NOT NULL DEFAULT 0,
|
|
"param2" INTEGER NOT NULL DEFAULT 0,
|
|
"param3" INTEGER NOT NULL DEFAULT 0,
|
|
PRIMARY KEY("attachment_id" AUTOINCREMENT),
|
|
FOREIGN KEY("message_id") REFERENCES "ddon_system_mail"("message_id") ON DELETE CASCADE
|
|
);
|