summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--lib/VNDB/DB/Staff.pm2
-rw-r--r--lib/VNDB/Handler/Staff.pm1
-rw-r--r--util/sql/func.sql6
-rw-r--r--util/sql/staff.sql1
4 files changed, 4 insertions, 6 deletions
diff --git a/lib/VNDB/DB/Staff.pm b/lib/VNDB/DB/Staff.pm
index cd2f7477..3e26e360 100644
--- a/lib/VNDB/DB/Staff.pm
+++ b/lib/VNDB/DB/Staff.pm
@@ -113,7 +113,7 @@ sub dbStaffRevisionInsert {
}
my %staff = map exists($o->{$_}) ? (qq|"$_" = ?|, $o->{$_}) : (),
- qw|aid image gender lang desc l_wp l_site l_twitter l_anidb|;
+ qw|aid gender lang desc l_wp l_site l_twitter l_anidb|;
$self->dbExec('UPDATE edit_staff !H', \%staff) if %staff;
for my $alias (@{$o->{aliases}}) {
if ($alias->[0]) {
diff --git a/lib/VNDB/Handler/Staff.pm b/lib/VNDB/Handler/Staff.pm
index 981a9fa8..4daf5d89 100644
--- a/lib/VNDB/Handler/Staff.pm
+++ b/lib/VNDB/Handler/Staff.pm
@@ -225,7 +225,6 @@ sub edit {
{ post => 'l_site', required => 0, template => 'url', maxlength => 250, default => '' },
{ post => 'l_twitter', required => 0, maxlength => 16, default => '', regex => [ qr/^\S+$/, mt('_staffe_form_tw_err') ] },
{ post => 'l_anidb', required => 0, template => 'int', default => undef },
- { post => 'image', required => 0, default => 0, template => 'int' },
{ post => 'aliases', required => 0, maxlength => 5000, default => '' },
{ post => 'editsum', required => 0, maxlength => 5000 },
{ post => 'ihid', required => 0 },
diff --git a/util/sql/func.sql b/util/sql/func.sql
index 345f4411..a7e2acf8 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, l_site, l_twitter, l_anidb FROM staff_rev WHERE id = cid;
+ INSERT INTO edit_staff SELECT aid, 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, 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;
+ INSERT INTO staff_rev (id, sid, aid, gender, lang, "desc", l_wp, l_site, l_twitter, l_anidb)
+ SELECT r.cid, r.iid, aid, 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 75a34979..5f43158f 100644
--- a/util/sql/staff.sql
+++ b/util/sql/staff.sql
@@ -14,7 +14,6 @@ CREATE TABLE staff_rev (
id integer NOT NULL PRIMARY KEY,
sid integer NOT NULL, -- references staff
aid integer NOT NULL, -- true name, references staff_alias
- image integer NOT NULL DEFAULT 0,
gender gender NOT NULL DEFAULT 'unknown',
lang language NOT NULL DEFAULT 'ja',
"desc" text NOT NULL DEFAULT '',