summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authormorkt <>2014-12-24 09:24:58 +0100
committerYorhel <git@yorhel.nl>2014-12-24 09:24:58 +0100
commit8719a8e69f5fc46c4ccf44e6e99c33b60c342d76 (patch)
tree852ccf8d82b51eaad1e84c23482bda7777db52b7 /util
parentac784a64d0f74f9e04ac41890075c411e50ca823 (diff)
Further progress on the staff database
- Moves staff<->vn linking form to the main VN edit form - Fixes a bug with linking staff aliases to VNs - Adds staff changes to the VN revisions - And some misc. improvements
Diffstat (limited to 'util')
-rw-r--r--util/sql/staff.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/util/sql/staff.sql b/util/sql/staff.sql
index 074aacae..a53b8955 100644
--- a/util/sql/staff.sql
+++ b/util/sql/staff.sql
@@ -33,7 +33,8 @@ CREATE TABLE vn_staff (
vid integer NOT NULL, -- vn_rev reference
aid integer NOT NULL, -- staff_alias reference
role credit_type NOT NULL DEFAULT 'staff',
- note varchar(250) NOT NULL DEFAULT ''
+ note varchar(250) NOT NULL DEFAULT '',
+ PRIMARY KEY (vid, aid, role)
);
CREATE TABLE chars_seiyuu (