diff options
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 |