summaryrefslogtreecommitdiff
path: root/sources/wiki/pre.sql
diff options
context:
space:
mode:
authorJochen Topf <jochen@topf.org>2010-11-13 21:31:39 +0100
committerJochen Topf <jochen@topf.org>2010-11-13 21:31:39 +0100
commit9db63dc2526bf0b2a94e7a6f37a0f7dabdb8f12d (patch)
tree0d2ae6de413c39c21d30aaf296a98ee37977ab45 /sources/wiki/pre.sql
parentc82bbe69572398d44187ca7b57b1ce572f435d65 (diff)
downloadtaginfo-9db63dc2526bf0b2a94e7a6f37a0f7dabdb8f12d.tar
taginfo-9db63dc2526bf0b2a94e7a6f37a0f7dabdb8f12d.tar.gz
Multiple changes
* Improved and cleaned up source import scripts * Improved some reports and report overview * New osmium version that uses a better hash function * Some experimental magic to include Javascipt in an easier way (tested in keys.erb)
Diffstat (limited to 'sources/wiki/pre.sql')
-rw-r--r--sources/wiki/pre.sql19
1 files changed, 1 insertions, 18 deletions
diff --git a/sources/wiki/pre.sql b/sources/wiki/pre.sql
index 0e8200e..56e9538 100644
--- a/sources/wiki/pre.sql
+++ b/sources/wiki/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 'wiki', 'Wiki', 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 'wiki', 'Wiki', datetime('now'), datetime('now');
DROP TABLE IF EXISTS wikipages;