diff options
author | Yorhel <git@yorhel.nl> | 2019-09-03 13:50:52 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2019-09-03 13:50:52 +0200 |
commit | 01f935095c90a4419fd9dfbb806fece94262cf89 (patch) | |
tree | c0a4a1e073bad6e91ae9a325deb1419dc6d8962e /util/sql | |
parent | 409ea71adee83d05b53f14d2be10abc153905ca9 (diff) |
Add Pixiv ID to staff entries
Diffstat (limited to 'util/sql')
-rw-r--r-- | util/sql/schema.sql | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql index bea433a0..5d4a801e 100644 --- a/util/sql/schema.sql +++ b/util/sql/schema.sql @@ -522,7 +522,8 @@ CREATE TABLE staff ( -- dbentry_type=s l_site varchar(250) NOT NULL DEFAULT '', -- [pub] l_twitter varchar(16) NOT NULL DEFAULT '', -- [pub] l_anidb integer, -- [pub] - l_wikidata integer -- [pub] + l_wikidata integer, -- [pub] + l_pixiv integer NOT NULL DEFAULT 0 -- [pub] ); -- staff_hist @@ -536,7 +537,8 @@ CREATE TABLE staff_hist ( l_site varchar(250) NOT NULL DEFAULT '', l_twitter varchar(16) NOT NULL DEFAULT '', l_anidb integer, - l_wikidata integer + l_wikidata integer, + l_pixiv integer NOT NULL DEFAULT 0 ); -- staff_alias |