summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2022-07-31 17:07:48 +0200
committerYorhel <git@yorhel.nl>2022-07-31 17:07:49 +0200
commit691797f62bdc6df8307f6bd47b9ca14dda8920d7 (patch)
tree52a50373bf865faca97a64b22905824f3879dc24 /sql
parentec20437fc576d156eb8ccec7ac49a01fecf76add (diff)
Add VN development status field
https://vndb.org/t18854
Diffstat (limited to 'sql')
-rw-r--r--sql/schema.sql6
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