CREATE TABLE type(id INTEGER, label INTEGER, singular_label INTEGER, icon INTEGER, top_mentioned_entities TEXT, PRIMARY KEY(id));
INSERT INTO `type` VALUES ('1','9','10','1', '');
INSERT INTO `type` VALUES ('2','11','12','2', '');
CREATE TABLE string(id INTEGER, language TEXT, text TEXT);
INSERT INTO `string` VALUES ('0','de','Alle');
INSERT INTO `string` VALUES ('0','en','All');
INSERT INTO `string` VALUES ('0','en-US','All');
INSERT INTO `string` VALUES ('0','es','Todo');
INSERT INTO `string` VALUES ('0','fr','Tout');
INSERT INTO `string` VALUES ('0','it','Tutto');
INSERT INTO `string` VALUES ('0','ja','すべて');
INSERT INTO `string` VALUES ('0','nl','Alles');
INSERT INTO `string` VALUES ('0','pt-BR','Todos');
INSERT INTO `string` VALUES ('0','ru','Все');
INSERT INTO `string` VALUES ('0','zh-CN','全部');
INSERT INTO `string` VALUES ('1','de','Buch');
INSERT INTO `string` VALUES ('1','en','Book');
INSERT INTO `string` VALUES ('1','en-US','Book');
INSERT INTO `string` VALUES ('1','es','Libro');
INSERT INTO `string` VALUES ('1','fr','Livre');
INSERT INTO `string` VALUES ('1','it','Libro');
INSERT INTO `string` VALUES ('1','ja','本');
INSERT INTO `string` VALUES ('1','nl','Boek');
INSERT INTO `string` VALUES ('1','pt-BR','eBook');
INSERT INTO `string` VALUES ('1','ru','Книга');
INSERT INTO `string` VALUES ('1','zh-CN','电子书');
INSERT INTO `string` VALUES ('2','de','Baidu Baike');
INSERT INTO `string` VALUES ('2','en','Baidu Baike');
INSERT INTO `string` VALUES ('2','en-US','Baidu Baike');
INSERT INTO `string` VALUES ('2','es','Baidu Baike');
INSERT INTO `string` VALUES ('2','fr','Baidu Baike');
INSERT INTO `string` VALUES ('2','it','Baidu Baike');
INSERT INTO `string` VALUES ('2','ja','百度百科');
INSERT INTO `string` VALUES ('2','nl','Baidu Baike');
INSERT INTO `string` VALUES ('2','pt-BR','Baidu Baike');
INSERT INTO `string` VALUES ('2','ru','Baidu Baike');
INSERT INTO `string` VALUES ('2','zh-CN','百度百科');
INSERT INTO `string` VALUES ('3','de','Autor');
INSERT INTO `string` VALUES ('3','en','Author');
INSERT INTO `string` VALUES ('3','en-US','Author');
INSERT INTO `string` VALUES ('3','es','Autor');
INSERT INTO `string` VALUES ('3','fr','Auteur');
INSERT INTO `string` VALUES ('3','it','Autore');
INSERT INTO `string` VALUES ('3','ja','著者');
INSERT INTO `string` VALUES ('3','nl','Auteur');
INSERT INTO `string` VALUES ('3','pt-BR','Autor');
INSERT INTO `string` VALUES ('3','ru','Автор');
INSERT INTO `string` VALUES ('3','zh-CN','作者');
INSERT INTO `string` VALUES ('4','de','Shelfari');
INSERT INTO `string` VALUES ('4','en','Shelfari');
INSERT INTO `string` VALUES ('4','en-US','Shelfari');
INSERT INTO `string` VALUES ('4','es','Shelfari');
INSERT INTO `string` VALUES ('4','fr','Shelfari');
INSERT INTO `string` VALUES ('4','it','Shelfari');
INSERT INTO `string` VALUES ('4','ja','Shelfari');
INSERT INTO `string` VALUES ('4','nl','Shelfari');
INSERT INTO `string` VALUES ('4','pt-BR','Shelfari');
INSERT INTO `string` VALUES ('4','ru','Shelfari');
INSERT INTO `string` VALUES ('4','zh-CN','Shelfari');
INSERT INTO `string` VALUES ('5','de','Kindle-Shop');
INSERT INTO `string` VALUES ('5','en','Kindle Store');
INSERT INTO `string` VALUES ('5','en-US','Kindle Store');
INSERT INTO `string` VALUES ('5','es','Tienda Kindle');
INSERT INTO `string` VALUES ('5','fr','Boutique Kindle');
INSERT INTO `string` VALUES ('5','it','Kindle Store');
INSERT INTO `string` VALUES ('5','ja','Kindleストア');
INSERT INTO `string` VALUES ('5','nl','Kindle-winkel');
INSERT INTO `string` VALUES ('5','pt-BR','Loja Kindle');
INSERT INTO `string` VALUES ('5','ru','Магазин Kindle');
INSERT INTO `string` VALUES ('5','zh-CN','Kindle 商店');
INSERT INTO `string` VALUES ('6','de','Wikipedia');
INSERT INTO `string` VALUES ('6','en','Wikipedia');
INSERT INTO `string` VALUES ('6','en-US','Wikipedia');
INSERT INTO `string` VALUES ('6','es','Wikipedia');
INSERT INTO `string` VALUES ('6','fr','Wikipédia');
INSERT INTO `string` VALUES ('6','it','Wikipedia');
INSERT INTO `string` VALUES ('6','ja','Wikipedia');
INSERT INTO `string` VALUES ('6','nl','Wikipedia');
INSERT INTO `string` VALUES ('6','pt-BR','Wikipédia');
INSERT INTO `string` VALUES ('6','ru','Википедия');
INSERT INTO `string` VALUES ('6','zh-CN','维基百科');
INSERT INTO `string` VALUES ('7','en','Creative Commons Attribution Share-Alike license');
INSERT INTO `string` VALUES ('8','en','http://creativecommons.org/licenses/by-sa/3.0/legalcode');
INSERT INTO `string` VALUES ('1000','de','Wichtige Clips');
INSERT INTO `string` VALUES ('1000','en','Notable Clips');
INSERT INTO `string` VALUES ('1000','en-US','Notable Clips');
INSERT INTO `string` VALUES ('1000','es','Recortes destacables');
INSERT INTO `string` VALUES ('1000','fr','Extraits importants');
INSERT INTO `string` VALUES ('1000','it','Ritagli rilevanti');
INSERT INTO `string` VALUES ('1000','ja','重要な抜粋');
INSERT INTO `string` VALUES ('1000','nl','Opvallende clips');
INSERT INTO `string` VALUES ('1000','pt-BR','Recortes notáveis');
INSERT INTO `string` VALUES ('1000','ru','Важные отрывки');
INSERT INTO `string` VALUES ('1000','zh-CN','选段');
INSERT INTO `string` VALUES ('1001','de','Wichtige Clips');
INSERT INTO `string` VALUES ('1001','en','Notable Clips');
INSERT INTO `string` VALUES ('1001','en-US','Notable Clips');
INSERT INTO `string` VALUES ('1001','es','Recortes destacables');
INSERT INTO `string` VALUES ('1001','fr','Extraits importants');
INSERT INTO `string` VALUES ('1001','it','Ritagli rilevanti');
INSERT INTO `string` VALUES ('1001','ja','重要な抜粋');
INSERT INTO `string` VALUES ('1001','nl','Opvallende clips');
INSERT INTO `string` VALUES ('1001','pt-BR','Recortes notáveis');
INSERT INTO `string` VALUES ('1001','ru','Важные отрывки');
INSERT INTO `string` VALUES ('1001','zh-CN','选段');
INSERT INTO `string` VALUES ('9','de','Personen');
INSERT INTO `string` VALUES ('9','en','People');
INSERT INTO `string` VALUES ('9','en-US','People');
INSERT INTO `string` VALUES ('9','es','Gente');
INSERT INTO `string` VALUES ('9','fr','Personnes');
INSERT INTO `string` VALUES ('9','it','Persone');
INSERT INTO `string` VALUES ('9','ja','人物');
INSERT INTO `string` VALUES ('9','nl','Mensen');
INSERT INTO `string` VALUES ('9','pt-BR','Pessoas');
INSERT INTO `string` VALUES ('9','ru','Люди');
INSERT INTO `string` VALUES ('9','zh-CN','人物');
INSERT INTO `string` VALUES ('10','de','Person');
INSERT INTO `string` VALUES ('10','en','Person');
INSERT INTO `string` VALUES ('10','en-US','Person');
INSERT INTO `string` VALUES ('10','es','Persona');
INSERT INTO `string` VALUES ('10','fr','Personne');
INSERT INTO `string` VALUES ('10','it','Persona');
INSERT INTO `string` VALUES ('10','ja','人物');
INSERT INTO `string` VALUES ('10','nl','Persoon');
INSERT INTO `string` VALUES ('10','pt-BR','Pessoa');
INSERT INTO `string` VALUES ('10','ru','Человек');
INSERT INTO `string` VALUES ('10','zh-CN','人物');
INSERT INTO `string` VALUES ('11','de','Begriffe');
INSERT INTO `string` VALUES ('11','en','Terms');
INSERT INTO `string` VALUES ('11','en-US','Terms');
INSERT INTO `string` VALUES ('11','es','Términos');
INSERT INTO `string` VALUES ('11','fr','Termes');
INSERT INTO `string` VALUES ('11','it','Termini');
INSERT INTO `string` VALUES ('11','ja','トピック');
INSERT INTO `string` VALUES ('11','nl','Termen');
INSERT INTO `string` VALUES ('11','pt-BR','Termos');
INSERT INTO `string` VALUES ('11','ru','Термины');
INSERT INTO `string` VALUES ('11','zh-CN','术语');
INSERT INTO `string` VALUES ('12','de','Begriff');
INSERT INTO `string` VALUES ('12','en','Term');
INSERT INTO `string` VALUES ('12','en-US','Term');
INSERT INTO `string` VALUES ('12','es','Término');
INSERT INTO `string` VALUES ('12','fr','Terme');
INSERT INTO `string` VALUES ('12','it','Termine');
INSERT INTO `string` VALUES ('12','ja','トピック');
INSERT INTO `string` VALUES ('12','nl','Term');
INSERT INTO `string` VALUES ('12','pt-BR','Termo');
INSERT INTO `string` VALUES ('12','ru','Термин');
INSERT INTO `string` VALUES ('12','zh-CN','术语');
INSERT INTO `string` VALUES ('13','de','Themen');
INSERT INTO `string` VALUES ('13','en','Themes');
INSERT INTO `string` VALUES ('13','en-US','Themes');
INSERT INTO `string` VALUES ('13','es','Temas');
INSERT INTO `string` VALUES ('13','fr','Thèmes');
INSERT INTO `string` VALUES ('13','it','Temi');
INSERT INTO `string` VALUES ('13','ja','テーマ');
INSERT INTO `string` VALUES ('13','nl','Themas');
INSERT INTO `string` VALUES ('13','pt-BR','Tema');
INSERT INTO `string` VALUES ('13','ru','Темы');
INSERT INTO `string` VALUES ('13','zh-CN','主题');
INSERT INTO `string` VALUES ('14','de','Thema');
INSERT INTO `string` VALUES ('14','en','Theme');
INSERT INTO `string` VALUES ('14','en-US','Theme');
INSERT INTO `string` VALUES ('14','es','Tema');
INSERT INTO `string` VALUES ('14','fr','Thème');
INSERT INTO `string` VALUES ('14','it','Tema');
INSERT INTO `string` VALUES ('14','ja','テーマ');
INSERT INTO `string` VALUES ('14','nl','Thema');
INSERT INTO `string` VALUES ('14','pt-BR','Tema');
INSERT INTO `string` VALUES ('14','ru','Тема');
INSERT INTO `string` VALUES ('14','zh-CN','主题');
INSERT INTO `string` VALUES ('15','en','store://%s');
INSERT INTO `string` VALUES ('16','en','http://en.wikipedia.org/wiki/%s');
INSERT INTO `string` VALUES ('17','en',NULL);
CREATE TABLE source(id INTEGER, label INTEGER, url INTEGER, license_label INTEGER, license_url INTEGER, PRIMARY KEY(id));
INSERT INTO `source` VALUES ('0','5','20',NULL,NULL);
INSERT INTO `source` VALUES ('1','4','21',NULL,NULL);
INSERT INTO `source` VALUES ('2','6','22','7','8');
CREATE TABLE occurrence(entity INTEGER, start INTEGER, length INTEGER);
CREATE TABLE excerpt(id INTEGER, start INTEGER, length INTEGER, image TEXT, related_entities TEXT, goto INTEGER, PRIMARY KEY(id));
CREATE TABLE entity_excerpt(entity INTEGER, excerpt INTEGER);
CREATE TABLE entity_description(text TEXT, source_wildcard TEXT, source INTEGER, entity INTEGER, PRIMARY KEY(entity));
CREATE TABLE entity(id INTEGER, label TEXT, loc_label INTEGER, type INTEGER, count INTEGER, has_info_card TINYINT, PRIMARY KEY(id));
INSERT INTO `entity` VALUES ('0',NULL,'1',NULL,NULL,'0');
CREATE TABLE book_metadata(srl INTEGER, erl INTEGER, has_images TINYINT, has_excerpts TINYINT, show_spoilers_default TINYINT, num_people INTEGER, num_terms INTEGER, num_images INTEGER, preview_images TEXT);