diff options
Diffstat (limited to 'util/dump.sql')
-rw-r--r-- | util/dump.sql | 28 |
1 files changed, 14 insertions, 14 deletions
diff --git a/util/dump.sql b/util/dump.sql index a96365ac..3294179e 100644 --- a/util/dump.sql +++ b/util/dump.sql @@ -45,8 +45,8 @@ CREATE TABLE changes ( CREATE TABLE producers ( id SERIAL NOT NULL PRIMARY KEY, latest integer NOT NULL DEFAULT 0, - locked smallint NOT NULL DEFAULT 0, - hidden smallint NOT NULL DEFAULT 0 + locked boolean NOT NULL DEFAULT FALSE, + hidden boolean NOT NULL DEFAULT FALSE ); -- producers_rev @@ -65,8 +65,8 @@ CREATE TABLE producers_rev ( CREATE TABLE releases ( id SERIAL NOT NULL PRIMARY KEY, latest integer NOT NULL DEFAULT 0, - locked smallint NOT NULL DEFAULT 0, - hidden smallint NOT NULL DEFAULT 0 + locked boolean NOT NULL DEFAULT FALSE, + hidden boolean NOT NULL DEFAULT FALSE ); -- releases_media @@ -135,8 +135,8 @@ CREATE TABLE screenshots ( CREATE TABLE threads ( id SERIAL NOT NULL PRIMARY KEY, title varchar(50) NOT NULL DEFAULT '', - locked smallint NOT NULL DEFAULT 0, - hidden smallint NOT NULL DEFAULT 0, + locked boolean NOT NULL DEFAULT FALSE, + hidden boolean NOT NULL DEFAULT FALSE, count smallint NOT NULL DEFAULT 0 ); @@ -148,7 +148,7 @@ CREATE TABLE threads_posts ( date bigint NOT NULL DEFAULT DATE_PART('epoch', NOW()), edited bigint NOT NULL DEFAULT 0, msg text NOT NULL DEFAULT '', - hidden smallint NOT NULL DEFAULT 0, + hidden boolean NOT NULL DEFAULT FALSE, PRIMARY KEY(tid, num) ); @@ -175,8 +175,8 @@ CREATE TABLE users ( CREATE TABLE vn ( id SERIAL NOT NULL PRIMARY KEY, latest integer NOT NULL DEFAULT 0, - locked smallint NOT NULL DEFAULT 0, - hidden smallint NOT NULL DEFAULT 0, + locked boolean NOT NULL DEFAULT FALSE, + hidden boolean NOT NULL DEFAULT FALSE, rgraph integer NOT NULL DEFAULT 0, c_released integer NOT NULL DEFAULT 0, c_languages varchar(32) NOT NULL DEFAULT '', @@ -212,7 +212,7 @@ CREATE TABLE vn_rev ( vid integer NOT NULL DEFAULT 0, title varchar(250) NOT NULL DEFAULT '', alias varchar(500) NOT NULL DEFAULT '', - img_nsfw smallint NOT NULL DEFAULT 0, + img_nsfw boolean NOT NULL DEFAULT FALSE, length smallint NOT NULL DEFAULT 0, "desc" text NOT NULL DEFAULT '', l_wp varchar(150) NOT NULL DEFAULT '', @@ -226,7 +226,7 @@ CREATE TABLE vn_rev ( CREATE TABLE vn_screenshots ( vid integer NOT NULL DEFAULT 0, scr integer NOT NULL DEFAULT 0, - nsfw smallint NOT NULL DEFAULT 0, + nsfw boolean NOT NULL DEFAULT FALSE, PRIMARY KEY(vid, scr) ); @@ -354,7 +354,7 @@ BEGIN JOIN releases_vn rv1 ON rr1.id = rv1.rid WHERE rv1.vid = vn.id AND rr1.type <> 2 - AND r1.hidden = 0 + AND r1.hidden = FALSE AND rr1.released <> 0 GROUP BY rv1.vid ), 0), @@ -366,7 +366,7 @@ BEGIN WHERE rv2.vid = vn.id AND rr2.type <> 2 AND rr2.released <= TO_CHAR(''today''::timestamp, ''YYYYMMDD'')::integer - AND r2.hidden = 0 + AND r2.hidden = FALSE GROUP BY rr2.language ORDER BY rr2.language ), ''/''), ''''), @@ -379,7 +379,7 @@ BEGIN WHERE rv3.vid = vn.id AND rr3.type <> 2 AND rr3.released <= TO_CHAR(''today''::timestamp, ''YYYYMMDD'')::integer - AND r3.hidden = 0 + AND r3.hidden = FALSE GROUP BY rp3.platform ORDER BY rp3.platform ), ''/''), '''') |