From 76d58425de6a1e3505c777921b1e58bf03370366 Mon Sep 17 00:00:00 2001 From: Thibaut Horel Date: Fri, 9 Nov 2012 23:41:01 +0100 Subject: Import old database. The database is in the file new.db. dump,sql contains a sqlite3 compliant dump. To regenerate the database from the dump: $ sqlite3 old.db < dump.sql $ python createdb.py -s schema.sql -d new.db $ python import.py old.db new.db --- schema.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'schema.sql') diff --git a/schema.sql b/schema.sql index 6c8c721..0248ce7 100644 --- a/schema.sql +++ b/schema.sql @@ -30,7 +30,7 @@ drop table if exists comments; create table comments ( id integer primary key autoincrement, date string default (strftime('%Y-%m-%dT%H:%M:%SZ','now')), - content string not null, + content string, content_cache string not null, user_id integer, news_id integer, -- cgit v1.2.3-70-g09d2