chardb: Added main char field + editing

The field isn't used yet.

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;