From 4f7ef2c538da67f612fac579382764e081063774 Mon Sep 17 00:00:00 2001
From: Jochen Topf <jochen@topf.org>
Date: Thu, 14 Oct 2010 15:53:40 +0200
Subject: Added experimental protovis bar chart to key values tab allow more
 rows to be show in flexigrid tables

---
 sources/wiki/get_wiki_data.rb |  3 ++-
 sources/wiki/pre.sql          | 43 ++++++++++++++++++++++---------------------
 2 files changed, 24 insertions(+), 22 deletions(-)

(limited to 'sources/wiki')

diff --git a/sources/wiki/get_wiki_data.rb b/sources/wiki/get_wiki_data.rb
index 742e520..f4632ca 100755
--- a/sources/wiki/get_wiki_data.rb
+++ b/sources/wiki/get_wiki_data.rb
@@ -117,12 +117,13 @@ class WikiPage
 
     def insert(db)
         db.execute(
-            "INSERT INTO wikipages (lang, tag, key, value, title, tgroup, type, has_templ, parsed, description, image, on_node, on_way, on_area, on_relation, tags_implies, tags_combination, tags_linked) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
+            "INSERT INTO wikipages (lang, tag, key, value, title, body, tgroup, type, has_templ, parsed, description, image, on_node, on_way, on_area, on_relation, tags_implies, tags_combination, tags_linked) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
             lang,
             tag,
             key,
             value,
             title,
+            content,
             group,
             type,
             has_templ,
diff --git a/sources/wiki/pre.sql b/sources/wiki/pre.sql
index 2cb3bfd..04071eb 100644
--- a/sources/wiki/pre.sql
+++ b/sources/wiki/pre.sql
@@ -28,53 +28,54 @@ CREATE TABLE stats (
 DROP TABLE IF EXISTS wikipages;
 
 CREATE TABLE wikipages (
-    lang             VARCHAR,
-    tag              VARCHAR,
-    key              VARCHAR,
-    value            VARCHAR,
-    title            VARCHAR,
-    tgroup           VARCHAR,
-    type             VARCHAR,
+    lang             TEXT,
+    tag              TEXT,
+    key              TEXT,
+    value            TEXT,
+    title            TEXT,
+    body             TEXT,
+    tgroup           TEXT,
+    type             TEXT,
     has_templ        INTEGER,
     parsed           INTEGER,
-    description      VARCHAR,
-    image            VARCHAR,
+    description      TEXT,
+    image            TEXT,
     on_node          INTEGER,
     on_way           INTEGER,
     on_area          INTEGER,
     on_relation      INTEGER,
-    tags_implies     VARCHAR,
-    tags_combination VARCHAR,
-    tags_linked      VARCHAR,
-    status           VARCHAR
+    tags_implies     TEXT,
+    tags_combination TEXT,
+    tags_linked      TEXT,
+    status           TEXT
 );
 
 DROP TABLE IF EXISTS wikipages_keys;
 
 CREATE TABLE wikipages_keys (
-    key   VARCHAR,
-    langs VARCHAR
+    key   TEXT,
+    langs TEXT
 );
 
 DROP TABLE IF EXISTS wikipages_tags;
 
 CREATE TABLE wikipages_tags (
-    key   VARCHAR,
-    value VARCHAR,
-    langs VARCHAR
+    key   TEXT,
+    value TEXT,
+    langs TEXT
 );
 
 DROP TABLE IF EXISTS wiki_languages;
 
 CREATE TABLE wiki_languages (
-    language    VARCHAR,
-    count_pages INT
+    language    TEXT,
+    count_pages INTEGER
 );
 
 DROP TABLE IF EXISTS stats;
 
 CREATE TABLE stats (
-    key   VARCHAR,
+    key   TEXT,
     value INT64
 );
 
-- 
cgit v1.2.3