summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2018-05-25 16:11:01 +0200
committerYorhel <git@yorhel.nl>2018-05-25 16:11:03 +0200
commitb0f7086211dd326ef612d30561ddc69e7abf98fb (patch)
tree6a076efdfbe348d95e8a9c2893a130814f549589 /util
parent0a39d801c10fd644bbfd4c9c4f3e357e3c522788 (diff)
Add uncensored flag to release entries
As discussed in https://vndb.org/t10665
Diffstat (limited to 'util')
-rw-r--r--util/sql/schema.sql6
-rw-r--r--util/updates/update_20180525.sql5
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