summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
Diffstat (limited to 'util')
-rw-r--r--util/sql/func.sql4
-rw-r--r--util/updates/update_2.19.sql2
2 files changed, 3 insertions, 3 deletions
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;