diff options
Diffstat (limited to 'sources/potlatch/pre.sql')
-rw-r--r-- | sources/potlatch/pre.sql | 19 |
1 files changed, 1 insertions, 18 deletions
diff --git a/sources/potlatch/pre.sql b/sources/potlatch/pre.sql index 9f79445..35d8c9d 100644 --- a/sources/potlatch/pre.sql +++ b/sources/potlatch/pre.sql @@ -6,24 +6,7 @@ .bail ON -DROP TABLE IF EXISTS meta; - -CREATE TABLE meta ( - source_id TEXT, - source_name TEXT, - update_start TEXT, - update_end TEXT, - data_until TEXT -); - -INSERT INTO meta (source_id, source_name, update_start, data_until) SELECT 'potlatch', 'Potlatch', datetime('now'), datetime('now'); - -DROP TABLE IF EXISTS stats; - -CREATE TABLE stats ( - key TEXT, - value INT64 -); +INSERT INTO source (id, name, update_start, data_until) SELECT 'potlatch', 'Potlatch', datetime('now'), datetime('now'); -- -- categories |