diff options
author | Yorhel <git@yorhel.nl> | 2022-07-31 17:07:48 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2022-07-31 17:07:49 +0200 |
commit | 691797f62bdc6df8307f6bd47b9ca14dda8920d7 (patch) | |
tree | 52a50373bf865faca97a64b22905824f3879dc24 /sql | |
parent | ec20437fc576d156eb8ccec7ac49a01fecf76add (diff) |
Add VN development status field
https://vndb.org/t18854
Diffstat (limited to 'sql')
-rw-r--r-- | sql/schema.sql | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/sql/schema.sql b/sql/schema.sql index f9156de3..31a706ef 100644 --- a/sql/schema.sql +++ b/sql/schema.sql @@ -1136,7 +1136,8 @@ CREATE TABLE vn ( -- dbentry_type=v c_developers vndbid[] NOT NULL DEFAULT '{}', c_average smallint, -- [pub], decimal vote*100, i.e. 100 - 1000 c_length smallint, - c_lengthnum smallint NOT NULL DEFAULT 0 + c_lengthnum smallint NOT NULL DEFAULT 0, + devstatus smallint NOT NULL DEFAULT 0 -- [pub] (0/finished 1/ongoing 2/cancelled) ); -- vn_hist @@ -1151,7 +1152,8 @@ CREATE TABLE vn_hist ( l_wp varchar(150) NOT NULL DEFAULT '', l_encubed varchar(100) NOT NULL DEFAULT '', l_renai varchar(100) NOT NULL DEFAULT '', - "desc" text NOT NULL DEFAULT '' + "desc" text NOT NULL DEFAULT '', + devstatus smallint NOT NULL DEFAULT 0 ); -- vn_anime |