1 files changed, 15 insertions, 0 deletions
diff --git a/sources/db/pre.sql b/sources/db/pre.sql
index 9faf613..c896758 100644
--- a/sources/db/pre.sql
+++ b/sources/db/pre.sql
@@ -27,6 +27,7 @@ CREATE TABLE keys (
   cells_nodes      INTEGER DEFAULT 0,
   cells_ways       INTEGER DEFAULT 0,
   in_wiki          INTEGER DEFAULT 0,
+  in_wiki_en       INTEGER DEFAULT 0,
   in_projects      INTEGER DEFAULT 0,
   characters       VARCHAR,
   grade            CHAR DEFAULT 'u'
@@ -81,6 +82,7 @@ CREATE TABLE tags (
   count_ways       INTEGER DEFAULT 0,
   count_relations  INTEGER DEFAULT 0,
   in_wiki          INTEGER DEFAULT 0,
+  in_wiki_en       INTEGER DEFAULT 0,
   in_projects      INTEGER DEFAULT 0
 );
 
@@ -139,3 +141,16 @@ CREATE TABLE prevalent_roles (
   fraction REAL
 );
 
+DROP TABLE IF EXISTS key_characters;
+
+CREATE TABLE key_characters (
+  key       TEXT,
+  num       INTEGER,
+  utf8      TEXT,
+  codepoint TEXT,
+  block     INTEGER,
+  category  TEXT,
+  direction INTEGER,
+  name      TEXT
+);
+