summaryrefslogtreecommitdiff
path: root/util/dump.sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-07-19 11:36:54 +0200
committerYorhel <git@yorhel.nl>2009-07-19 11:36:54 +0200
commit678a78d71534441d5471ed24aa8b471ba08c6664 (patch)
treeba79c25216a87b7f56d71f864ed641d8a91222e4 /util/dump.sql
parent4df0638b6f615489bd946c03753b3bbe0269e3b2 (diff)
Converted and renamed screenshots.status (int) to processed (bool)
There were only two states, processed and unprocessed, so simply using a boolean column with correct naming is more clarifying.
Diffstat (limited to 'util/dump.sql')
-rw-r--r--util/dump.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/util/dump.sql b/util/dump.sql
index 583212cd..003c33ea 100644
--- a/util/dump.sql
+++ b/util/dump.sql
@@ -156,7 +156,7 @@ CREATE TABLE rlists (
-- screenshots
CREATE TABLE screenshots (
id SERIAL NOT NULL PRIMARY KEY,
- status smallint NOT NULL DEFAULT 0,
+ processed boolean NOT NULL DEFAULT FALSE,
width smallint NOT NULL DEFAULT 0,
height smallint NOT NULL DEFAULT 0
);