From 8719a8e69f5fc46c4ccf44e6e99c33b60c342d76 Mon Sep 17 00:00:00 2001
From: morkt <>
Date: Wed, 24 Dec 2014 09:24:58 +0100
Subject: 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
---
 util/sql/staff.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'util')

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 (
-- 
cgit v1.2.3