 URLSignature TEXT NULL,
 introduction TEXT NULL
 );
--- Chinese
--- INSERT INTO Version VALUES ('CUVSPD', 'cnm', 'EBIBLE', 'CUVS', 'Chinese Union Version (Simplified)', 'BIBLE', 'CUVSPD.db', 'T', 'F', '2016-09-06',
--- 'Chinese Union Version (Simplified), Public Domain, eBible.org.', NULL, NULL);
--- INSERT INTO Version VALUES ('CUVTPD', 'cnm', 'EBIBLE', 'CUVT', 'Chinese Union Version (Traditional)', 'BIBLE', 'CUVTPD.db', 'T', 'F', '2016-09-06',
--- 'Chinese Union Version (Traditional), Public Domain, eBible.org.', NULL, NULL);
-
--- English
-INSERT INTO Version VALUES ('WEB_SHORT', 'eng', 'EBIBLE', 'WEB', 'WEB Genesis and Titus for testing', 'BIBLE_PNT', 'WEB_SHORT.db', 'T', 'F', '2016-09-06',
-'', NULL, NULL);
+-- America
+INSERT INTO Version VALUES ('ERV-ENG', 'eng', 'BLI', 'ERV-ENG', 'Holy Bible: Easy-to-Read Version (ERV), International Edition', 'BIBLE', 'ERV-ENG.db', 'T', 'F', '2016-10-01', 'Holy Bible: Easy-to-Read Version (ERV), International Edition © 2013, 2016 Bible League International', NULL, NULL);
+INSERT INTO Version VALUES ('ERV-POR', 'por', 'BLI', 'ERV-POR', 'Novo Testamento: Versão Fácil de Ler', 'BIBLE_NT', 'ERV-POR.db', 'T', 'F', '2016-10-10',
+'Novo Testamento: Versão Fácil de Ler (VFL) © 1999, 2014 Bible League International', NULL, NULL);
+INSERT INTO Version VALUES ('ERV-SPA', 'spa', 'BLI', 'ERV-SPA', 'La Biblia: La Palabra de Dios para todos', 'BIBLE', 'ERV-SPA.db', 'T', 'F', '2016-10-08',
+'La Biblia: La Palabra de Dios para todos (PDT) © 2005, 2015 Bible League International', NULL, NULL);
 INSERT INTO Version VALUES ('ESV', 'eng', 'CRSWY', 'ESV', 'English Standard Version', 'BIBLE', 'ESV.db', 'T', 'F', '2020-01-01',
 'English Standard Version®, copyright © 2001 by Crossway Bibles, a publishing ministry of Good News Publishers. Used by permission. All rights reserved.', NULL, NULL);
-INSERT INTO Version VALUES ('ERV-ENG', 'eng', 'BLI', 'ERV-ENG', 'Holy Bible: Easy-to-Read Version (ERV), International Edition', 'BIBLE', 'ERV-ENG.db', 'T', 'F', '2016-10-01', 
-'Holy Bible: Easy-to-Read Version (ERV), International Edition © 2013, 2016 Bible League International', NULL, NULL);
 INSERT INTO Version VALUES ('KJVPD', 'eng', 'EBIBLE', 'KJV', 'King James Version', 'BIBLE', 'KJVPD.db', 'T', 'F', '2016-09-06', 
 'King James Version 1611 (KJV), Public Domain, eBible.org.', NULL, NULL);
 INSERT INTO Version VALUES ('WEB', 'eng', 'EBIBLE', 'WEB', 'World English Bible', 'BIBLE', 'WEB.db', 'T', 'F', '2016-09-06', 
 'World English Bible (WEB), Public Domain, eBible.org.', NULL, NULL);
-
--- Spanish
-INSERT INTO Version VALUES ('ERV-SPA', 'spa', 'BLI', 'ERV-SPA', 'La Biblia: La Palabra de Dios para todos', 'BIBLE', 'ERV-SPA.db', 'T', 'F', '2016-10-08',
-'La Biblia: La Palabra de Dios para todos (PDT) © 2005, 2015 Bible League International', NULL, NULL);
-INSERT INTO Version VALUES ('ERV-POR', 'por', 'BLI', 'ERV-POR', 'Novo Testamento: Versão Fácil de Ler', 'BIBLE_NT', 'ERV-POR.db', 'T', 'F', '2016-10-10',
-'Novo Testamento: Versão Fácil de Ler (VFL) © 1999, 2014 Bible League International', NULL, NULL);
--- INSERT INTO Version VALUES ('RVR09PD', 'spa', 'EBIBLE', 'RVR1909', 'Santa Biblia — Reina Valera 1909', 'BIBLE', 'RVR09PD.db', 'T', 'F', '2016-09-06',
--- 'Santa Biblia — Reina Valera 1909 (RVR1909), Public Domain, eBible.org', NULL, NULL);
--- INSERT INTO Version VALUES ('BLP', 'spa', 'SPN', 'BLP', 'La Palabra (versión española)', 'BIBLE', 'BLP.db', 'T', 'F', '2016-09-06',
--- 'La Palabra (BLP) versión española Copyright © Sociedad Bíblica de España, 2010 Utilizada con permiso', NULL, NULL);
--- INSERT INTO Version VALUES ('BLPH', 'spa', 'SPN', 'BLPH', 'La Palabra (versión hispanoamericana)','BIBLE', 'BLPH.db', 'T', 'F', '2016-09-06',
--- 'La Palabra (BLPH) versión hispanoamericana Copyright © Sociedad Bíblica de España, 2010 Utilizada con permiso', NULL, NULL);
-
--- Arabic Languages
+INSERT INTO Version VALUES ('WEB_SHORT', 'eng', 'EBIBLE', 'WEB', 'WEB Genesis and Titus for testing', 'BIBLE_PNT', 'WEB_SHORT.db', 'T', 'F', '2016-09-06',
+'', NULL, NULL);
+
+-- East Asia
+INSERT INTO Version VALUES ('ERV-CMN', 'cmn', 'BLI', 'ERV-CMN', '圣经–普通话本', 'BIBLE', 'ERV-CMN.db', 'T', 'F', '2016-10-12',
+'圣经–普通话本（普通话）© 1999，2015 Bible League International', NULL, NULL);
+INSERT INTO Version VALUES ('ERV-IND', 'ind', 'BLI', 'ERV-IND', 'Perjanjian Baru: Versi Mudah Dibaca', 'BIBLE_NT', 'ERV-IND.db', 'T', 'F', '2016-10-12',
+'Perjanjian Baru: Versi Mudah Dibaca (VMD) © 2003 Bible League International', NULL, NULL);
+INSERT INTO Version VALUES ('ERV-NEP', 'nep', 'BLI', 'ERV-NEP', 'TBD', 'BIBLE', 'ERV-NEP.db', 'T', 'F', '2016-10-17',
+'copyright', NULL, NULL);
+
+
+INSERT INTO Version VALUES ('ERV-THA', 'tha', 'BLI', 'ERV-THA', 'พระ​คริสต​ธรรม​คัมภีร์ ฉบับ​อ่าน​เข้า​ใจ​ง่าย', 'BIBLE', 'ERV-THA.db', 'T', 'F', '2016-10-12',
+'พระคริสต​ธรรม​คัมภีร์: ฉบับ​อ่าน​เข้า​ใจ​ง่าย (ขจง) © 2015 Bible League International', NULL, NULL);
+INSERT INTO Version VALUES ('ERV-VIE', 'vie', 'BLI', 'ERV-VIE', 'Thánh Kinh: Bản Phổ thông', 'BIBLE', 'ERV-VIE.db', 'T', 'F', '2016-10-12',
+'Thánh Kinh: Bản Phổ thông (BPT) © 2010 Bible League International', NULL, NULL);
+
+-- Middle East
 INSERT INTO Version VALUES ('ARBVDPD', 'arb', 'EBIBLE', 'ARBVD', 'الكتاب المقدس ترجمة فان دايك', 'BIBLE', 'ARBVDPD.db', 'F', 'F', '2016-09-06',
 'Arabic Bible: Van Dyck Translation (ARBVD), Public Domain, eBible.org', NULL, NULL);
 INSERT INTO Version VALUES ('ERV-ARB', 'arb', 'BLI', 'ERV-ARB', 'name', 'BIBLE', 'ERV-ARB.db', 'F', 'T', '2016-10',


DROP TABLE IF EXISTS Translation;
DROP TABLE IF EXISTS InstalledVersion;
DROP TABLE IF EXISTS CountryVersion;
DROP TABLE IF EXISTS Version;
DROP TABLE IF EXISTS Owner;

);
-- World Languages
INSERT INTO Language VALUES ('arb', 'ar', 'rtl', 'Arabic', 'العربية');
INSERT INTO Language VALUES ('awa', 'awa', 'ltr', 'Awadhi', ''); -- no tranlation
INSERT INTO Language VALUES ('ben', 'bn', 'ltr', 'Bengali', 'বাঙালি');
INSERT INTO Language VALUES ('bul', 'bg', 'ltr', 'Bulgarian', 'български език');
INSERT INTO Language VALUES ('cmn', 'zh', 'ltr', 'Chinese', '汉语, 漢語');
INSERT INTO Language VALUES ('eng', 'en', 'ltr', 'English', 'English');
INSERT INTO Language VALUES ('hin', 'hi', 'ltr', 'Hindi', 'हिंदी');
INSERT INTO Language VALUES ('hrv', 'hr', 'ltr', 'Croatian', 'hrvatski');
INSERT INTO Language VALUES ('hun', 'hu', 'ltr', 'Hungarian', 'Magyar');
INSERT INTO Language VALUES ('ind', 'id', 'ltr', 'Indonesian', 'Bahasa Indonesia');
INSERT INTO Language VALUES ('kan', 'kn', 'ltr', 'Kannada', 'ಕನ್ನಡ');
INSERT INTO Language VALUES ('mar', 'mr', 'ltr', 'Marathi', 'मराठी');
INSERT INTO Language VALUES ('nep', 'ne', 'ltr', 'Nepali', 'नेपाली');
INSERT INTO Language VALUES ('ori', 'or', 'ltr', 'Oriya', ''); -- no translation
INSERT INTO Language VALUES ('pan', 'pa', 'ltr', 'Punjabi', 'ਪੰਜਾਬੀ ਦੇ');
INSERT INTO Language VALUES ('pes', 'fa', 'rtl', 'Persian', 'فارسی');
INSERT INTO Language VALUES ('por', 'pt', 'ltr', 'Portuguese', 'Português');
INSERT INTO Language VALUES ('rus', 'ru', 'ltr', 'Russian', 'русский');
INSERT INTO Language VALUES ('srp', 'sr', 'ltr', 'Serbian', 'Српски');
INSERT INTO Language VALUES ('spa', 'es', 'ltr', 'Spanish', 'Español');
INSERT INTO Language VALUES ('tam', 'ta', 'ltr', 'Tamil', 'தமிழ் மொழி');
INSERT INTO Language VALUES ('tha', 'th', 'ltr', 'Thai', 'ภาษาไทย');
INSERT INTO Language VALUES ('ukr', 'uk', 'ltr', 'Ukrainian', 'українська мова');
INSERT INTO Language VALUES ('urd', 'ur', 'rtl', 'Urdu', 'اردو زبان');
INSERT INTO Language VALUES ('vie', 'vi', 'ltr', 'Vietnamese', 'Tiếng Việt');


CREATE TABLE Owner (
