DROP TABLE IF EXISTS `bb_key_genre`;
CREATE TABLE `bb_key_genre` (
  `g` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Genre ID',
  `n` varchar(255) NOT NULL COMMENT 'Name of genre',
  PRIMARY KEY (`g`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COMMENT='Table mapping genre IDs to genre names for book table lookup' AUTO_INCREMENT=9 ;

--
-- Dumping data for table `key_genre_english`
--

INSERT INTO `bb_key_genre` (`g`, `n`) VALUES
(1, 'Lalàna'),
(2, 'Tantara'),
(3, 'Fahendrena'),
(4, 'Mpaminany'),
(5, 'Filazan-tsara'),
(6, 'Asa'),
(7, 'Episitily'),
(8, 'Fanambarana');

CREATE TABLE `bb_key_book` (
  `b` int(11) NOT NULL COMMENT 'Book #',
  `n` text NOT NULL COMMENT 'Name',
  `t` varchar(2) NOT NULL COMMENT 'Which Testament this book is in',
  `g` tinyint(3) unsigned NOT NULL COMMENT 'A genre ID to identify the type of book this is',
  PRIMARY KEY (`b`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `bb_key_book` (`b`, `n`, `t`, `g`) VALUES
(1, 'Genesisy', 'TT', 1),
(2, 'Eksodosy', 'TT', 1),
(3, 'Levitikosy', 'TT', 1),
(4, 'Nomery', 'TT', 1),
(5, 'Deotoronomia', 'TT', 1),
(6, 'Josoa', 'TT', 2),
(7, 'Mpitsara', 'TT', 2),
(8, 'Rota', 'TT', 2),
(9, '1 Samoela', 'TT', 2),
(10, '2 Samoela', 'TT', 2),
(11, '1 Mpanjaka', 'TT', 2),
(12, '2 Mpanjaka', 'TT', 2),
(13, '1 Tantara', 'TT', 2),
(14, '2 Tantara', 'TT', 2),
(15, 'Ezra', 'TT', 2),
(16, 'Nehemia', 'TT', 2),
(17, 'Estera', 'TT', 2),
(18, 'Joba', 'TT', 3),
(19, 'Salamo', 'TT', 3),
(20, 'Ohabolana', 'TT', 3),
(21, 'Mpitoriteny', 'TT', 3),
(22, 'Tonon-kiran''i Solomona', 'TT', 3),
(23, 'Isaia', 'TT', 4),
(24, 'Jeremia', 'TT', 4),
(25, 'Fitomaniana', 'TT', 4),
(26, 'Ezekiela', 'TT', 4),
(27, 'Daniela', 'TT', 4),
(28, 'Hosea', 'TT', 4),
(29, 'Joela', 'TT', 4),
(30, 'Amosa', 'TT', 4),
(31, 'Obadia', 'TT', 4),
(32, 'Jona', 'TT', 4),
(33, 'Mika', 'TT', 4),
(34, 'Nahoma', 'TT', 4),
(35, 'Habakoka', 'TT', 4),
(36, 'Zefania', 'TT', 4),
(37, 'Hagay', 'TT', 4),
(38, 'Zakaria', 'TT', 4),
(39, 'Malakia', 'TT', 4),
(40, 'Matio', 'TV', 5),
(41, 'Marka', 'TV', 5),
(42, 'Lioka', 'TV', 5),
(43, 'Jaona', 'TV', 5),
(44, 'Asan''ny Apostoly', 'TV', 6),
(45, 'Romana', 'TV', 7),
(46, '1 Korintiana', 'TV', 7),
(47, '2 Korintiana', 'TV', 7),
(48, 'Galatiana', 'TV', 7),
(49, 'Efesiana', 'TV', 7),
(50, 'Filipiana', 'TV', 7),
(51, 'Kolosiana', 'TV', 7),
(52, '1 Tesaloniana', 'TV', 7),
(53, '2 Tesaloniana', 'TV', 7),
(54, '1 Timoty', 'TV', 7),
(55, '2 Timoty', 'TV', 7),
(56, 'Titosy', 'TV', 7),
(57, 'Filemona', 'TV', 7),
(58, 'Hebreo', 'TV', 7),
(59, 'Jakoba', 'TV', 7),
(60, '1 Petera', 'TV', 7),
(61, '2 Petera', 'TV', 7),
(62, '1 Jaona', 'TV', 7),
(63, '2 Jaona', 'TV', 7),
(64, '3 Jaona', 'TV', 7),
(65, 'Joda', 'TV', 7),
(66, 'Apokalypsy', 'TV', 8);

CREATE TABLE `bb_versets` (
  `id` int(8) unsigned zerofill NOT NULL,
  `b` int(11) NOT NULL,
  `c` int(11) NOT NULL,
  `v` int(11) NOT NULL,
  `t` text NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_3` (`id`),
  KEY `id` (`id`),
  KEY `id_2` (`id`),
  KEY `id_4` (`id`),
  KEY `id_5` (`id`),
  KEY `id_6` (`id`),
  KEY `id_7` (`id`),
  KEY `id_8` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;