sebastian-heinz / Arrowgene.DragonsDogmaOnline

Server for Dragons Dogma Online
GNU Affero General Public License v3.0
161 stars 52 forks source link

Save Rewards in the db #328

Closed pacampbell closed 3 months ago

pacampbell commented 3 months ago

Checklist:

pacampbell commented 3 months ago

rules to update existing database

CREATE TABLE IF NOT EXISTS "ddon_reward_box" (
    "uniq_reward_id"    INTEGER NOT NULL,
    "character_common_id"   INTEGER NOT NULL,
    "quest_id"  INTEGER NOT NULL,
    "num_random_rewards"    INTEGER NOT NULL,
    "random_reward0_index"  INTEGER NOT NULL,
    "random_reward1_index"  INTEGER NOT NULL,
    "random_reward2_index"  INTEGER NOT NULL,
    "random_reward3_index"  INTEGER NOT NULL,
    PRIMARY KEY("uniq_reward_id" AUTOINCREMENT),
    CONSTRAINT "fk_ddon_reward_box_character_common_id" FOREIGN KEY("character_common_id") REFERENCES "ddon_character_common"("character_common_id") ON DELETE CASCADE
);
alborrajo commented 3 months ago

Feel free to merge