<?php

	// ensure file called from install function.
	if(!defined('AMDBIBLE_INSTALL')) {
	   die('Direct access not permitted');
	}
	// check user capabilities
	if ( ! current_user_can( 'activate_plugins' ) ) {
		return;
	}

	global $wpdb;
	
	$table_name = $wpdb->prefix . "amdbible_key_eng";
	$wpdb->query("
	INSERT INTO
		`$table_name`
		(`b`, `n`, `t`, `g`)
	VALUES
		(1, 'Genesis', 'OT', 1),
		(2, 'Exodus', 'OT', 1),
		(3, 'Leviticus', 'OT', 1),
		(4, 'Numbers', 'OT', 1),
		(5, 'Deuteronomy', 'OT', 1),
		(6, 'Joshua', 'OT', 2),
		(7, 'Judges', 'OT', 2),
		(8, 'Ruth', 'OT', 2),
		(9, '1 Samuel', 'OT', 2),
		(10, '2 Samuel', 'OT', 2),
		(11, '1 Kings', 'OT', 2),
		(12, '2 Kings', 'OT', 2),
		(13, '1 Chronicles', 'OT', 2),
		(14, '2 Chronicles', 'OT', 2),
		(15, 'Ezra', 'OT', 2),
		(16, 'Nehemiah', 'OT', 2),
		(17, 'Esther', 'OT', 2),
		(18, 'Job', 'OT', 3),
		(19, 'Psalms', 'OT', 3),
		(20, 'Proverbs', 'OT', 3),
		(21, 'Ecclesiastes', 'OT', 3),
		(22, 'Song of Solomon', 'OT', 3),
		(23, 'Isaiah', 'OT', 4),
		(24, 'Jeremiah', 'OT', 4),
		(25, 'Lamentations', 'OT', 4),
		(26, 'Ezekiel', 'OT', 4),
		(27, 'Daniel', 'OT', 4),
		(28, 'Hosea', 'OT', 4),
		(29, 'Joel', 'OT', 4),
		(30, 'Amos', 'OT', 4),
		(31, 'Obadiah', 'OT', 4),
		(32, 'Jonah', 'OT', 4),
		(33, 'Micah', 'OT', 4),
		(34, 'Nahum', 'OT', 4),
		(35, 'Habakkuk', 'OT', 4),
		(36, 'Zephaniah', 'OT', 4),
		(37, 'Haggai', 'OT', 4),
		(38, 'Zechariah', 'OT', 4),
		(39, 'Malachi', 'OT', 4),
		(40, 'Matthew', 'NT', 5),
		(41, 'Mark', 'NT', 5),
		(42, 'Luke', 'NT', 5),
		(43, 'John', 'NT', 5),
		(44, 'Acts', 'NT', 6),
		(45, 'Romans', 'NT', 7),
		(46, '1 Corinthians', 'NT', 7),
		(47, '2 Corinthians', 'NT', 7),
		(48, 'Galatians', 'NT', 7),
		(49, 'Ephesians', 'NT', 7),
		(50, 'Philippians', 'NT', 7),
		(51, 'Colossians', 'NT', 7),
		(52, '1 Thessalonians', 'NT', 7),
		(53, '2 Thessalonians', 'NT', 7),
		(54, '1 Timothy', 'NT', 7),
		(55, '2 Timothy', 'NT', 7),
		(56, 'Titus', 'NT', 7),
		(57, 'Philemon', 'NT', 7),
		(58, 'Hebrews', 'NT', 7),
		(59, 'James', 'NT', 7),
		(60, '1 Peter', 'NT', 7),
		(61, '2 Peter', 'NT', 7),
		(62, '1 John', 'NT', 7),
		(63, '2 John', 'NT', 7),
		(64, '3 John', 'NT', 7),
		(65, 'Jude', 'NT', 7),
		(66, 'Revelation', 'NT', 8)
	");
	
	$table_name = $wpdb->prefix . "amdbible_key_abbr_eng";
	$wpdb->query("
	INSERT INTO
		`$table_name`
		(`a`, `b`, `p`)
	VALUES 
		('Gen', 1, 1),
		('Ge', 1, 0),
		('Gn', 1, 0),
		('Exo', 2, 1),
		('Ex', 2, 0),
		('Exod', 2, 0),
		('Lev', 3, 1),
		('Le', 3, 0),
		('Lv', 3, 0),
		('Num', 4, 1),
		('Nu', 4, 0),
		('Nm', 4, 0),
		('Nb', 4, 0),
		('Deut', 5, 1),
		('Dt', 5, 0),
		('Josh', 6, 1),
		('Jos', 6, 0),
		('Jsh', 6, 0),
		('Judg', 7, 1),
		('Jdg', 7, 0),
		('Jg', 7, 0),
		('Jdgs', 7, 0),
		('Rth', 8, 1),
		('Ru', 8, 0),
		('1 Sam', 9, 1),
		('1 Sa', 9, 0),
		('1Samuel', 9, 0),
		('1S', 9, 0),
		('I Sa', 9, 0),
		('1 Sm', 9, 0),
		('1Sa', 9, 0),
		('I Sam', 9, 0),
		('1Sam', 9, 0),
		('I Samuel', 9, 0),
		('1st Samuel', 9, 0),
		('First Samuel', 9, 0),
		('2 Sam', 10, 1),
		('2 Sa', 10, 0),
		('2S', 10, 0),
		('II Sa', 10, 0),
		('2 Sm', 10, 0),
		('2Sa', 10, 0),
		('II Sam', 10, 0),
		('2Sam', 10, 0),
		('II Samuel', 10, 0),
		('2Samuel', 10, 0),
		('2nd Samuel', 10, 0),
		('Second Samuel', 10, 0),
		('1 Kgs', 11, 1),
		('1 Ki', 11, 0),
		('1K', 11, 0),
		('I Kgs', 11, 0),
		('1Kgs', 11, 0),
		('I Ki', 11, 0),
		('1Ki', 11, 0),
		('I Kings', 11, 0),
		('1Kings', 11, 0),
		('1st Kgs', 11, 0),
		('1st Kings', 11, 0),
		('First Kings', 11, 0),
		('First Kgs', 11, 0),
		('1Kin', 11, 0),
		('1King', 11, 0),
		('2 Kgs', 12, 1),
		('2 Ki', 12, 0),
		('2K', 12, 0),
		('II Kgs', 12, 0),
		('2Kgs', 12, 0),
		('II Ki', 12, 0),
		('2Ki', 12, 0),
		('II Kings', 12, 0),
		('2Kings', 12, 0),
		('2nd Kgs', 12, 0),
		('2nd Kings', 12, 0),
		('Second Kings', 12, 0),
		('Second Kgs', 12, 0),
		('2Kin', 12, 0),
		('2King', 12, 0),
		('1 Chron', 13, 1),
		('1 Ch', 13, 0),
		('I Ch', 13, 0),
		('1Ch', 13, 0),
		('1 Chr', 13, 0),
		('I Chr', 13, 0),
		('1Chr', 13, 0),
		('I Chron', 13, 0),
		('1Chron', 13, 0),
		('I Chronicles', 13, 0),
		('1Chronicles', 13, 0),
		('1st Chronicles', 13, 0),
		('First Chronicles', 13, 0),
		('2 Chron', 14, 1),
		('2 Ch', 14, 0),
		('II Ch', 14, 0),
		('2Ch', 14, 0),
		('II Chr', 14, 0),
		('2Chr', 14, 0),
		('II Chron', 14, 0),
		('2Chron', 14, 0),
		('II Chronicles', 14, 0),
		('2Chronicles', 14, 0),
		('2nd Chronicles', 14, 0),
		('Second Chronicles', 14, 0),
		('Ezra', 15, 1),
		('Ezr', 15, 0),
		('Neh', 16, 1),
		('Ne', 16, 0),
		('Esth', 17, 1),
		('Es', 17, 0),
		('Est', 17, 0),
		('Job', 18, 1),
		('Job', 18, 0),
		('Jb', 18, 0),
		('Pslm', 19, 1),
		('Ps', 19, 0),
		('Psalms', 19, 0),
		('Psa', 19, 0),
		('Psm', 19, 0),
		('Pss', 19, 0),
		('Prov', 20, 1),
		('Pr', 20, 0),
		('Prv', 20, 0),
		('Eccles', 21, 1),
		('Ec', 21, 0),
		('Ecc', 21, 0),
		('Qoh', 21, 0),
		('Qoheleth', 21, 0),
		('Song', 22, 1),
		('So', 22, 0),
		('Canticle of Canticles', 22, 0),
		('Canticles', 22, 0),
		('Song of Songs', 22, 0),
		('Solomon', 22, 0),
		('SOS', 22, 0),
		('Isa', 23, 1),
		('Is', 23, 0),
		('Jer', 24, 1),
		('Je', 24, 0),
		('Jr', 24, 0),
		('Lam', 25, 1),
		('La', 25, 0),
		('Ezek', 26, 1),
		('Eze', 26, 0),
		('Ezk', 26, 0),
		('Dan', 27, 1),
		('Da', 27, 0),
		('Dn', 27, 0),
		('Hos', 28, 1),
		('Ho', 28, 0),
		('Joel', 29, 1),
		('Joe', 29, 0),
		('Jl', 29, 0),
		('Amos', 30, 1),
		('Am', 30, 0),
		('Obad', 31, 1),
		('Ob', 31, 0),
		('Oba', 31, 0),
		('Jnh', 32, 1),
		('Jon', 32, 0),
		('Micah', 33, 1),
		('Mic', 33, 0),
		('Nah', 34, 1),
		('Na', 34, 0),
		('Hab', 35, 1),
		('Zeph', 36, 1),
		('Zep', 36, 0),
		('Zp', 36, 0),
		('Haggai', 37, 1),
		('Hag', 37, 0),
		('Hg', 37, 0),
		('Zech', 38, 1),
		('Zec', 38, 0),
		('Zc', 38, 0),
		('Mal', 39, 1),
		('Mal', 39, 0),
		('Ml', 39, 0),
		('Matt', 40, 1),
		('Mt', 40, 0),
		('Mrk', 41, 1),
		('Mk', 41, 0),
		('Mr', 41, 0),
		('Luk', 42, 1),
		('Lk', 42, 0),
		('John', 43, 1),
		('Jn', 43, 0),
		('Jhn', 43, 0),
		('Acts', 44, 1),
		('Ac', 44, 0),
		('Rom', 45, 1),
		('Ro', 45, 0),
		('Rm', 45, 0),
		('1 Cor', 46, 1),
		('1 Co', 46, 0),
		('I Co', 46, 0),
		('1Co', 46, 0),
		('I Cor', 46, 0),
		('1Cor', 46, 0),
		('I Corinthians', 46, 0),
		('1Corinthians', 46, 0),
		('1st Corinthians', 46, 0),
		('First Corinthians', 46, 0),
		('2 Cor', 47, 1),
		('2 Co', 47, 0),
		('II Co', 47, 0),
		('2Co', 47, 0),
		('II Cor', 47, 0),
		('2Cor', 47, 0),
		('II Corinthians', 47, 0),
		('2Corinthians', 47, 0),
		('2nd Corinthians', 47, 0),
		('Second Corinthians', 47, 0),
		('Gal', 48, 1),
		('Ga', 48, 0),
		('Ephes', 49, 1),
		('Eph', 49, 0),
		('Phil', 50, 1),
		('Php', 50, 0),
		('Col', 51, 1),
		('Col', 51, 0),
		('1 Thess', 52, 1),
		('1 Th', 52, 0),
		('I Th', 52, 0),
		('1Th', 52, 0),
		('I Thes', 52, 0),
		('1Thes', 52, 0),
		('I Thess', 52, 0),
		('1Thess', 52, 0),
		('I Thessalonians', 52, 0),
		('1Thessalonians', 52, 0),
		('1st Thessalonians', 52, 0),
		('First Thessalonians', 52, 0),
		('2 Thess', 53, 1),
		('2 Th', 53, 0),
		('II Th', 53, 0),
		('2Th', 53, 0),
		('II Thes', 53, 0),
		('2Thes', 53, 0),
		('II Thess', 53, 0),
		('2Thess', 53, 0),
		('II Thessalonians', 53, 0),
		('2Thessalonians', 53, 0),
		('2nd Thessalonians', 53, 0),
		('Second Thessalonians', 53, 0),
		('1 Tim', 54, 1),
		('1 Ti', 54, 0),
		('I Ti', 54, 0),
		('1Ti', 54, 0),
		('I Tim', 54, 0),
		('1Tim', 54, 0),
		('I Timothy', 54, 0),
		('1Timothy', 54, 0),
		('1st Timothy', 54, 0),
		('First Timothy', 54, 0),
		('2 Tim', 55, 1),
		('2 Ti', 55, 0),
		('II Ti', 55, 0),
		('2Ti', 55, 0),
		('II Tim', 55, 0),
		('2Tim', 55, 0),
		('II Timothy', 55, 0),
		('2Timothy', 55, 0),
		('2nd Timothy', 55, 0),
		('Second Timothy', 55, 0),
		('Titus', 56, 1),
		('Tit', 56, 0),
		('Philem', 57, 1),
		('Phm', 57, 0),
		('Hebrews', 58, 1),
		('Heb', 58, 0),
		('James', 59, 1),
		('Jas', 59, 0),
		('Jm', 59, 0),
		('1 Pet', 60, 1),
		('1 Pe', 60, 0),
		('I Pe', 60, 0),
		('1Pe', 60, 0),
		('I Pet', 60, 0),
		('1Pet', 60, 0),
		('I Pt', 60, 0),
		('1 Pt', 60, 0),
		('1Pt', 60, 0),
		('I Peter', 60, 0),
		('1Peter', 60, 0),
		('1st Peter', 60, 0),
		('First Peter', 60, 0),
		('2 Pet', 61, 1),
		('2 Pe', 61, 0),
		('II Pe', 61, 0),
		('2Pe', 61, 0),
		('II Pet', 61, 0),
		('2Pet', 61, 0),
		('II Pt', 61, 0),
		('2 Pt', 61, 0),
		('2Pt', 61, 0),
		('II Peter', 61, 0),
		('2Peter', 61, 0),
		('2nd Peter', 61, 0),
		('Second Peter', 61, 0),
		('1 John', 62, 1),
		('1 Jn', 62, 0),
		('I Jn', 62, 0),
		('1Jn', 62, 0),
		('I Jo', 62, 0),
		('1Jo', 62, 0),
		('I Joh', 62, 0),
		('1Joh', 62, 0),
		('I Jhn', 62, 0),
		('1 Jhn', 62, 0),
		('1Jhn', 62, 0),
		('I John', 62, 0),
		('1John', 62, 0),
		('1st John', 62, 0),
		('First John', 62, 0),
		('2 John', 63, 1),
		('2 Jn', 63, 0),
		('II Jn', 63, 0),
		('2Jn', 63, 0),
		('II Jo', 63, 0),
		('2Jo', 63, 0),
		('II Joh', 63, 0),
		('2Joh', 63, 0),
		('II Jhn', 63, 0),
		('2 Jhn', 63, 0),
		('2Jhn', 63, 0),
		('II John', 63, 0),
		('2John', 63, 0),
		('2nd John', 63, 0),
		('Second John', 63, 0),
		('3 John', 64, 1),
		('3 Jn', 64, 0),
		('III Jn', 64, 0),
		('3Jn', 64, 0),
		('III Jo', 64, 0),
		('3Jo', 64, 0),
		('III Joh', 64, 0),
		('3Joh', 64, 0),
		('III Jhn', 64, 0),
		('3 Jhn', 64, 0),
		('3Jhn', 64, 0),
		('III John', 64, 0),
		('3John', 64, 0),
		('3rd John', 64, 0),
		('Third John', 64, 0),
		('Jude', 65, 1),
		('Jud', 65, 0),
		('Rev', 66, 1),
		('Re', 66, 0),
		('The Revelation', 66, 0),
		('Genesis', 1, 1),
		('Exodus', 2, 1),
		('Leviticus', 3, 1),
		('Numbers', 4, 1),
		('Deuteronomy', 5, 1),
		('Joshua', 6, 1),
		('Judges', 7, 1),
		('Ruth', 8, 1),
		('1 Samuel', 9, 1),
		('2 Samuel', 10, 1),
		('1 Kings', 11, 1),
		('2 Kings', 12, 1),
		('1 Chronicles', 13, 1),
		('2 Chronicles', 14, 1),
		('Ezra', 15, 1),
		('Nehemiah', 16, 2),
		('Esther', 17, 2),
		('Job', 18, 1),
		('Psalms', 19, 1),
		('Psalm', 19, 1),
		('Proverbs', 20, 1),
		('Ecclesiastes', 21, 1),
		('Song of Solomon', 22, 1),
		('Isaiah', 23, 1),
		('Jeremiah', 24, 1),
		('Lamentations', 25, 1),
		('Ezekiel', 26, 1),
		('Daniel', 27, 1),
		('Hosea', 28, 1),
		('Joel', 29, 1),
		('Amos', 30, 1),
		('Obadiah', 31, 1),
		('Jonah', 32, 1),
		('Micah', 33, 1),
		('Nahum', 34, 1),
		('Habakkuk', 35, 1),
		('Zephaniah', 36, 1),
		('Haggai', 37, 1),
		('Zechariah', 38, 1),
		('Malachi', 39, 1),
		('Matthew', 40, 1),
		('Mark', 41, 1),
		('Luke', 42, 1),
		('John', 43, 1),
		('Acts', 44, 1),
		('Romans', 45, 1),
		('1 Corinthians', 46, 1),
		('2 Corinthians', 47, 1),
		('Galatians', 48, 1),
		('Ephesians', 49, 1),
		('Philippians', 50, 1),
		('Colossians', 51, 1),
		('1 Thessalonians', 52, 1),
		('2 Thessalonians', 53, 1),
		('1 Timothy', 54, 1),
		('2 Timothy', 55, 1),
		('Titus', 56, 1),
		('Philemon', 57, 1),
		('Hebrews', 58, 1),
		('James', 59, 1),
		('1 Peter', 60, 1),
		('2 Peter', 61, 1),
		('1 John', 62, 1),
		('2 John', 63, 1),
		('3 John', 64, 1),
		('Jude', 65, 1),
		('Revelation', 66, 1)
	");
	
	$table_name = $wpdb->prefix . "amdbible_key_genre_eng";
	$wpdb->query("
	INSERT INTO
		`$table_name`
		(`g`, `n`)
	VALUES
		(1, 'Law'),
		(2, 'History'),
		(3, 'Wisdom'),
		(4, 'Prophets'),
		(5, 'Gospels'),
		(6, 'Acts'),
		(7, 'Epistles'),
		(8, 'Apocalyptic')
	");
?>