diff options
author | Yorhel <git@yorhel.nl> | 2011-02-18 16:44:21 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2011-02-18 16:44:21 +0100 |
commit | 9470cf12cb6ae8a4610a24ae5b60017ddfcc1568 (patch) | |
tree | ef9aa0d74b38649937cbb2f3331096a95a9f9fc0 /util/sql | |
parent | 04db44f229360b5ff206419f0e17c4f525ea9aed (diff) |
chardb: Implemented BWH/height/weight fields
Diffstat (limited to 'util/sql')
-rw-r--r-- | util/sql/func.sql | 6 |
1 files changed, 2 insertions, 4 deletions
diff --git a/util/sql/func.sql b/util/sql/func.sql index 2b204902..ffc39d3b 100644 --- a/util/sql/func.sql +++ b/util/sql/func.sql @@ -373,8 +373,6 @@ $$ LANGUAGE plpgsql; --- PLACEHOLDERS, not complete yet - CREATE OR REPLACE FUNCTION edit_char_init(hid integer) RETURNS void AS $$ BEGIN BEGIN @@ -390,7 +388,7 @@ BEGIN INSERT INTO edit_char DEFAULT VALUES; -- load revision ELSE - INSERT INTO edit_char SELECT name, original, alias, image, "desc" FROM chars_rev WHERE id = hid; + INSERT INTO edit_char SELECT name, original, alias, image, "desc", s_bust, s_waist, s_hip, b_month, b_day, height, weight FROM chars_rev WHERE id = hid; END IF; END; $$ LANGUAGE plpgsql; @@ -405,7 +403,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" FROM edit_char; + 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 FROM edit_char; UPDATE chars SET latest = r.cid WHERE id = r.iid; RETURN r; END; |