Added experimental protovis bar chart to key values tab

allow more rows to be show in flexigrid tables

2 files changed, 24 insertions, 22 deletions

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