diff options
| author | Yorhel <git@yorhel.nl> | 2022-04-05 11:15:39 +0200 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2022-04-05 12:52:06 +0200 |
| commit | 220f88425e6dfe0be88cacdb3c9ad8b17e38ddb2 (patch) | |
| tree | 6db4bccceeb34370a5726a9930a8009e28cafc0f /sql | |
| parent | 74ac7376cc39a43f53074da5be3e9573aa566510 (diff) | |
Releases: Add "has ero" flag
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 2e6e851a..034decf8 100644 --- a/sql/schema.sql +++ b/sql/schema.sql @@ -436,7 +436,8 @@ CREATE TABLE releases ( -- dbentry_type=r ani_ero_sp animation, -- [pub] ani_ero_cg animation, -- [pub] ani_bg boolean, -- [pub] - ani_face boolean -- [pub] + ani_face boolean, -- [pub] + has_ero boolean NOT NULL DEFAULT FALSE -- [pub] ); -- releases_hist @@ -498,7 +499,8 @@ CREATE TABLE releases_hist ( ani_ero_sp animation, ani_ero_cg animation, ani_bg boolean, - ani_face boolean + ani_face boolean, + has_ero boolean NOT NULL DEFAULT FALSE ); -- releases_lang |