From 101f820153cdb047d13166672d3f46cfef31677d Mon Sep 17 00:00:00 2001 From: Thibaut Horel 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