Keep both rst and html rendered content in the database. News edit feature

1 files changed, 2 insertions, 0 deletions

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),