From 18a8041cac4ef0e29b5afe0176c78cea5c9f20dd Mon Sep 17 00:00:00 2001
From: Jesse Morgan <jesse@jesterpm.net>
Date: Thu, 2 Jun 2011 18:21:43 -0700
Subject: Changed to soft deletion and added 404 pages.

---
 design/database.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'design/database.sql')

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)
-- 
cgit v1.2.3