From 101f820153cdb047d13166672d3f46cfef31677d Mon Sep 17 00:00:00 2001
From: Thibaut Horel <thibaut.horel@gmail.com>
Date: Thu, 8 Nov 2012 01:34:02 +0100
Subject: Keep both rst and html rendered content in the database. News edit
 feature

---
 schema.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index 43e4822..bae55ab 100644
--- a/schema.sql
+++ b/schema.sql
@@ -11,6 +11,7 @@ create table news (
     title string not null,
     date string default (strftime('%Y-%m-%dT%H:%M:%S','now')),
     content string not null,
+    content_cache string not null,
     user_id integer,
     FOREIGN KEY(user_id) REFERENCES users(id)
 );
@@ -20,6 +21,7 @@ create table comments (
     id integer primary key autoincrement,
     date string default (strftime('%Y-%m-%dT%H:%M:%S','now')),
     content string not null,
+    content_cache string not null,
     user_id integer,
     news_id integer,
     FOREIGN KEY(user_id) REFERENCES users(id),
-- 
cgit v1.2.3-70-g09d2

