diff options
author | morkt <> | 2015-01-04 09:30:48 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2015-01-04 09:30:48 +0100 |
commit | 34331f1a4625eec8df708a4142b4570c155fb40e (patch) | |
tree | 7ac17cab87fc1c5a23f60d3b11715a0d1d741387 /util | |
parent | d28afb07f7cd0219d1e702883530d6aff158bb6f (diff) |
staff: Add some link fields and guidelines
Diffstat (limited to 'util')
-rw-r--r-- | util/sql/func.sql | 6 | ||||
-rw-r--r-- | util/sql/staff.sql | 5 |
2 files changed, 7 insertions, 4 deletions
diff --git a/util/sql/func.sql b/util/sql/func.sql index a1d776d2..345f4411 100644 --- a/util/sql/func.sql +++ b/util/sql/func.sql @@ -483,7 +483,7 @@ BEGIN INSERT INTO edit_staff (aid) VALUES (0); -- load revision ELSE - INSERT INTO edit_staff SELECT aid, image, gender, lang, "desc", l_wp FROM staff_rev WHERE id = cid; + INSERT INTO edit_staff SELECT aid, image, gender, lang, "desc", l_wp, l_site, l_twitter, l_anidb FROM staff_rev WHERE id = cid; INSERT INTO edit_staff_aliases SELECT id, name, original FROM staff_alias WHERE rid = cid; END IF; END; @@ -500,8 +500,8 @@ BEGIN SELECT INTO r * FROM edit_commit(); INSERT INTO staff_alias (id, rid, name, original) SELECT id, r.cid, name, original FROM edit_staff_aliases; - INSERT INTO staff_rev (id, sid, aid, image, gender, lang, "desc", l_wp) - SELECT r.cid, r.iid, aid, image, gender, lang, "desc", l_wp FROM edit_staff; + INSERT INTO staff_rev (id, sid, aid, image, gender, lang, "desc", l_wp, l_site, l_twitter, l_anidb) + SELECT r.cid, r.iid, aid, image, gender, lang, "desc", l_wp, l_site, l_twitter, l_anidb FROM edit_staff; UPDATE staff SET latest = r.cid WHERE id = r.iid; RETURN r; END; diff --git a/util/sql/staff.sql b/util/sql/staff.sql index 7c99971e..75a34979 100644 --- a/util/sql/staff.sql +++ b/util/sql/staff.sql @@ -18,7 +18,10 @@ CREATE TABLE staff_rev ( gender gender NOT NULL DEFAULT 'unknown', lang language NOT NULL DEFAULT 'ja', "desc" text NOT NULL DEFAULT '', - l_wp varchar(150) NOT NULL DEFAULT '' + l_wp varchar(150) NOT NULL DEFAULT '', + l_site varchar(250) NOT NULL DEFAULT '', + l_twitter varchar(16) NOT NULL DEFAULT '', + l_anidb integer ); CREATE TABLE staff_alias ( |