2024-07-26 17:13:24 -07:00
|
|
|
CREATE TABLE "ddon_character_playpoint_data" (
|
2024-07-29 13:24:14 -07:00
|
|
|
"character_id" INTEGER NOT NULL,
|
2024-07-26 17:13:24 -07:00
|
|
|
"job" SMALLINT NOT NULL,
|
|
|
|
|
"play_point" INTEGER NOT NULL DEFAULT 0,
|
|
|
|
|
"exp_mode" TINYINT NOT NULL DEFAULT 1,
|
2024-07-29 13:24:14 -07:00
|
|
|
CONSTRAINT pk_character_playpoint PRIMARY KEY (character_id, job),
|
|
|
|
|
CONSTRAINT fk_character_playpoint_character_id FOREIGN KEY("character_id") REFERENCES "ddon_character"("character_id") ON DELETE CASCADE
|
2024-07-26 17:13:24 -07:00
|
|
|
);
|
|
|
|
|
|
2024-07-29 13:24:14 -07:00
|
|
|
INSERT INTO "ddon_character_playpoint_data" SELECT c.character_id, j.job, 0, 1 FROM "ddon_character" c INNER JOIN "ddon_character_job_data" j ON c.character_common_id = j.character_common_id;
|