diff options
author | Yorhel <git@yorhel.nl> | 2018-05-25 16:11:01 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2018-05-25 16:11:03 +0200 |
commit | b0f7086211dd326ef612d30561ddc69e7abf98fb (patch) | |
tree | 6a076efdfbe348d95e8a9c2893a130814f549589 /util | |
parent | 0a39d801c10fd644bbfd4c9c4f3e357e3c522788 (diff) |
Add uncensored flag to release entries
As discussed in https://vndb.org/t10665
Diffstat (limited to 'util')
-rw-r--r-- | util/sql/schema.sql | 6 | ||||
-rw-r--r-- | util/updates/update_20180525.sql | 5 |
2 files changed, 9 insertions, 2 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql index c580894f..02f15e09 100644 --- a/util/sql/schema.sql +++ b/util/sql/schema.sql @@ -265,7 +265,8 @@ CREATE TABLE releases ( -- dbentry_type=r resolution smallint NOT NULL DEFAULT 0, voiced smallint NOT NULL DEFAULT 0, ani_story smallint NOT NULL DEFAULT 0, - ani_ero smallint NOT NULL DEFAULT 0 + ani_ero smallint NOT NULL DEFAULT 0, + uncensored boolean NOT NULL DEFAULT FALSE ); -- releases_hist @@ -286,7 +287,8 @@ CREATE TABLE releases_hist ( resolution smallint NOT NULL DEFAULT 0, voiced smallint NOT NULL DEFAULT 0, ani_story smallint NOT NULL DEFAULT 0, - ani_ero smallint NOT NULL DEFAULT 0 + ani_ero smallint NOT NULL DEFAULT 0, + uncensored boolean NOT NULL DEFAULT FALSE ); -- releases_lang diff --git a/util/updates/update_20180525.sql b/util/updates/update_20180525.sql index 2196cb17..f71b0d52 100644 --- a/util/updates/update_20180525.sql +++ b/util/updates/update_20180525.sql @@ -2,3 +2,8 @@ SELECT edit_d_init(NULL, NULL); UPDATE edit_revision SET requester = 1, comments = 'Empty page', ip = '0.0.0.0'; UPDATE edit_docs SET title = 'Privacy Policy'; SELECT edit_d_commit(); + + +ALTER TABLE releases ADD COLUMN uncensored boolean NOT NULL DEFAULT FALSE; +ALTER TABLE releases_hist ADD COLUMN uncensored boolean NOT NULL DEFAULT FALSE; +\i util/sql/editfunc.sql |