summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
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 (