summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authormorkt <>2015-01-04 09:30:48 +0100
committerYorhel <git@yorhel.nl>2015-01-04 09:30:48 +0100
commit34331f1a4625eec8df708a4142b4570c155fb40e (patch)
tree7ac17cab87fc1c5a23f60d3b11715a0d1d741387 /util
parentd28afb07f7cd0219d1e702883530d6aff158bb6f (diff)
staff: Add some link fields and guidelines
Diffstat (limited to 'util')
-rw-r--r--util/sql/func.sql6
-rw-r--r--util/sql/staff.sql5
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 (