diff options
Diffstat (limited to 'util/sql/staff.sql')
-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 ( |