diff options
author | Yorhel <git@yorhel.nl> | 2011-02-22 11:16:59 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2011-02-22 11:41:08 +0100 |
commit | 1c74dfdf44f080bc4a30be6303bf2845c2f5f7b0 (patch) | |
tree | e5eebe46c7f87939df5b6ff880a4e05a53eb2e81 /util/sql | |
parent | 54d983f9090f63136df11ff15861c17f7e96508a (diff) |
chardb: +image quality, -other blood type, typo fix, +gender icons
Diffstat (limited to 'util/sql')
-rw-r--r-- | util/sql/func.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/util/sql/func.sql b/util/sql/func.sql index c655159a..6ae0312b 100644 --- a/util/sql/func.sql +++ b/util/sql/func.sql @@ -424,7 +424,7 @@ BEGIN INSERT INTO edit_char DEFAULT VALUES; -- load revision ELSE - INSERT INTO edit_char SELECT name, original, alias, image, "desc", s_bust, s_waist, s_hip, b_month, b_day, height, weight, bloodt, gender 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 FROM chars_rev WHERE id = hid; INSERT INTO edit_char_traits SELECT tid, spoil FROM chars_traits WHERE cid = hid; END IF; END; @@ -440,7 +440,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", s_bust, s_waist, s_hip, b_month, b_day, height, weight, bloodt, gender 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 FROM edit_char; INSERT INTO chars_traits SELECT r.cid, tid, spoil FROM edit_char_traits; UPDATE chars SET latest = r.cid WHERE id = r.iid; RETURN r; |