From bf16424bf5173830e2c162dc7dc06e961d5aa0a3 Mon Sep 17 00:00:00 2001 From: Yorhel Date: Mon, 14 Mar 2011 16:44:03 +0100 Subject: chardb: Added main char field + editing The field isn't used yet. --- util/sql/func.sql | 4 ++-- util/updates/update_2.19.sql | 2 +- 2 files changed, 3 insertions(+), 3 deletions(-) (limited to 'util') diff --git a/util/sql/func.sql b/util/sql/func.sql index 5a43ae0f..75e5ecad 100644 --- a/util/sql/func.sql +++ b/util/sql/func.sql @@ -426,7 +426,7 @@ BEGIN INSERT INTO edit_char DEFAULT VALUES; -- load revision ELSE - INSERT INTO edit_char SELECT name, original, alias, image, "desc", gender, s_bust, s_waist, s_hip, b_month, b_day, height, weight, bloodt FROM chars_rev WHERE id = hid; + INSERT INTO edit_char SELECT name, original, alias, image, "desc", gender, s_bust, s_waist, s_hip, b_month, b_day, height, weight, bloodt, main, main_spoil FROM chars_rev WHERE id = hid; INSERT INTO edit_char_traits SELECT tid, spoil FROM chars_traits WHERE cid = hid; INSERT INTO edit_char_vns SELECT vid, rid, spoil, role FROM chars_vns WHERE cid = hid; END IF; @@ -443,7 +443,7 @@ BEGIN RAISE 'edit_char must have exactly one row!'; END IF; SELECT INTO r * FROM edit_commit(); - INSERT INTO chars_rev SELECT r.cid, r.iid, name, original, alias, image, "desc", gender, s_bust, s_waist, s_hip, b_month, b_day, height, weight, bloodt FROM edit_char; + INSERT INTO chars_rev SELECT r.cid, r.iid, name, original, alias, image, "desc", gender, s_bust, s_waist, s_hip, b_month, b_day, height, weight, bloodt, main, main_spoil FROM edit_char; INSERT INTO chars_traits SELECT r.cid, tid, spoil FROM edit_char_traits; INSERT INTO chars_vns SELECT r.cid, vid, rid, spoil, role FROM edit_char_vns; UPDATE chars SET latest = r.cid WHERE id = r.iid; diff --git a/util/updates/update_2.19.sql b/util/updates/update_2.19.sql index 76379e96..313fa567 100644 --- a/util/updates/update_2.19.sql +++ b/util/updates/update_2.19.sql @@ -61,7 +61,7 @@ CREATE TABLE chars_rev ( weight smallint NOT NULL DEFAULT 0, bloodt blood_type NOT NULL DEFAULT 'unknown', main integer REFERENCES chars (id), - main_spoil boolean NOT NULL DEFAULT false + main_spoil smallint NOT NULL DEFAULT 0 ); ALTER TABLE chars ADD FOREIGN KEY (latest) REFERENCES chars_rev (id) DEFERRABLE INITIALLY DEFERRED; -- cgit v1.2.3