summaryrefslogtreecommitdiff
path: root/util/sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2011-02-18 16:44:21 +0100
committerYorhel <git@yorhel.nl>2011-02-18 16:44:21 +0100
commit9470cf12cb6ae8a4610a24ae5b60017ddfcc1568 (patch)
treeef9aa0d74b38649937cbb2f3331096a95a9f9fc0 /util/sql
parent04db44f229360b5ff206419f0e17c4f525ea9aed (diff)
chardb: Implemented BWH/height/weight fields
Diffstat (limited to 'util/sql')
-rw-r--r--util/sql/func.sql6
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;