summaryrefslogtreecommitdiff
path: root/design/database.sql
diff options
context:
space:
mode:
authorJesse Morgan <jesse@jesterpm.net>2011-06-02 18:21:43 -0700
committerJesse Morgan <jesse@jesterpm.net ; true>2011-06-02 18:21:43 -0700
commit18a8041cac4ef0e29b5afe0176c78cea5c9f20dd (patch)
treeab763bb7a02ba629664180c3f8412a7da297b537 /design/database.sql
parent4364c76c16103870fb4a4cf6be9261871195c06f (diff)
Changed to soft deletion and added 404 pages.
Diffstat (limited to 'design/database.sql')
-rw-r--r--design/database.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/design/database.sql b/design/database.sql
index caecbeb..06b607c 100644
--- a/design/database.sql
+++ b/design/database.sql
@@ -54,7 +54,8 @@ CREATE TABLE post (
stage ENUM('verification',
'moderation',
'approved',
- 'rejected') NOT NULL DEFAULT 'verification',
+ 'rejected',
+ 'deleted') NOT NULL DEFAULT 'verification',
PRIMARY KEY(id),
UNIQUE KEY(secretid)