diff options
author | morkt <> | 2014-12-24 09:24:58 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2014-12-24 09:24:58 +0100 |
commit | 8719a8e69f5fc46c4ccf44e6e99c33b60c342d76 (patch) | |
tree | 852ccf8d82b51eaad1e84c23482bda7777db52b7 /util | |
parent | ac784a64d0f74f9e04ac41890075c411e50ca823 (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.sql | 3 |
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 ( |