-- http://www.phpmyadmin.net
-- 
-- 
-- Database: `orodb`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `content`
-- 

-- -- CREATE TABLE `content` (
-- --   `c_num` int(11) NOT NULL auto_increment,
-- --   `content_type` varchar(20) NOT NULL default '',
-- --   `icon_file_name` varchar(50) NOT NULL default '',
-- --   PRIMARY KEY  (`c_num`)
-- -- ) TYPE=MyISAM AUTO_INCREMENT=3 ;
-- -- 
-- -- -- 
-- -- -- Dumping data for table `content`
-- -- -- 
-- -- 
-- -- INSERT INTO `content` VALUES (1, 'Text Ministry', 'html.gif');
-- -- INSERT INTO `content` VALUES (2, 'Link', 'link.gif');

-- --------------------------------------------------------

-- 
-- Table structure for table `entries`
-- 

-- -- CREATE TABLE `entries` (
-- --   `e_num` int(11) NOT NULL auto_increment,
-- --   `title` varchar(50) NOT NULL default '',
-- --   `file_name` varchar(50) default NULL,
-- --   `c_num` int(11) NOT NULL default '0',
-- --   `rt_num` int(11) NOT NULL default '0',
-- --   PRIMARY KEY  (`e_num`)
-- -- ) TYPE=MyISAM AUTO_INCREMENT=32 ;
-- -- 
-- -- -- 
-- -- -- Dumping data for table `entries`
-- -- -- 
-- -- 
-- -- INSERT INTO `entries` VALUES (1, 'Main', NULL, 2, 1);
-- -- INSERT INTO `entries` VALUES (2, 'Algunas preguntas a los creyentes', '20_Preguntas.html', 1, 2);
-- -- INSERT INTO `entries` VALUES (3, 'Siete Claves para la Familia', 'July2005-7_Claves_para_la_Familia.html', 1, 5);
-- -- INSERT INTO `entries` VALUES (4, 'Su Amor Para Nosotros', 'July2005-Su_Amor_Para_Nosotros.html', 1, 5);
-- -- INSERT INTO `entries` VALUES (5, 'Lucas 15 - el hijo menor', 'Lucas_15.htm', 1, 4);
-- -- INSERT INTO `entries` VALUES (6, 'Lucas 15 - el hijo mayor', 'Lucas 15 parte 2.htm', 1, 4);
-- -- INSERT INTO `entries` VALUES (7, 'Lucas 15 - El padre que busca su hijo', NULL, 2, 4);
-- -- INSERT INTO `entries` VALUES (8, 'El Pastor Cristiano - una revista para familias', NULL, 2, 5);
-- -- INSERT INTO `entries` VALUES (9, 'Pensamientos sobre la iglesia de Dios', NULL, 2, 2);
-- -- INSERT INTO `entries` VALUES (10, 'Pensamientos sobre el amor de Dios', NULL, 2, 4);
-- -- INSERT INTO `entries` VALUES (11, 'Informacion sobre el Pastor Cristiano', 'El Pastor Cristiano.htm', 1, 5);
-- -- INSERT INTO `entries` VALUES (12, 'Buenas Noticias', NULL, 2, 6);
-- -- INSERT INTO `entries` VALUES (13, 'Nunca', 'Nunca.html', 1, 6);
-- -- INSERT INTO `entries` VALUES (14, 'El amor lo puede todo', 'ElAmorLoPuedeTodo.html', 1, 6);
-- -- INSERT INTO `entries` VALUES (15, 'PC - Volumen 9', NULL, 2, 5);
-- -- INSERT INTO `entries` VALUES (16, 'PC - Volumen 9 Numero 1', NULL, 2, 5);
-- -- INSERT INTO `entries` VALUES (17, 'PC - Volumen 9 Numero 7', NULL, 2, 5);
-- -- INSERT INTO `entries` VALUES (18, 'El la amo', 'El_La_Amo.htm', 1, 5);
-- -- INSERT INTO `entries` VALUES (19, 'Banderas', 'Banderas.htm', 1, 5);
-- -- INSERT INTO `entries` VALUES (20, 'Editorial', 'Editorial.htm', 1, 5);
-- -- INSERT INTO `entries` VALUES (21, 'Lucas 15:10 al fin', 'ElHijoProdico.htm', 1, 4);
-- -- INSERT INTO `entries` VALUES (22, 'La Perla Incomparable', 'LaPerlaIncomparable.htm', 1, 6);
-- -- INSERT INTO `entries` VALUES (23, 'Caminando por la Fe', 'Caminando_por_la_fe.htm', 1, 5);
-- -- INSERT INTO `entries` VALUES (24, 'El Unico Lugar', NULL, 1, 2);
-- -- INSERT INTO `entries` VALUES (25, 'Hijo De Esperanza', 'HijoDeEsperanza.html', 1, 6);
-- -- INSERT INTO `entries` VALUES (26, ' 	PC - Volumen 9 Numero 6', NULL, 2, 5);
-- -- INSERT INTO `entries` VALUES (27, 'Gracia Abundante', 'CS200506GraciaAbundante.html', 1, 4);
-- -- INSERT INTO `entries` VALUES (28, 'Amor O Deber', 'AmorODeber.html', 1, 6);
-- -- INSERT INTO `entries` VALUES (29, 'Los Ganadores', 'CS200506LosGanadores.html', 1, 5);
-- -- INSERT INTO `entries` VALUES (30, 'Un Gran Abismo', 'UnGranAbismo.html', 1, 6);
-- -- INSERT INTO `entries` VALUES (31, 'Un Ragalo Gratis', 'regalos.html', 1, 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `entry_link`
-- 

-- -- CREATE TABLE `entry_link` (
-- --   `menu_e_num` int(11) NOT NULL default '0',
-- --   `e_num` int(11) NOT NULL default '0'
-- -- ) TYPE=MyISAM;
-- -- 
-- -- -- 
-- -- -- Dumping data for table `entry_link`
-- -- -- 
-- -- 
-- -- INSERT INTO `entry_link` VALUES (9, 2);
-- -- INSERT INTO `entry_link` VALUES (17, 3);
-- -- INSERT INTO `entry_link` VALUES (17, 4);
-- -- INSERT INTO `entry_link` VALUES (12, 13);
-- -- INSERT INTO `entry_link` VALUES (1, 12);
-- -- INSERT INTO `entry_link` VALUES (10, 7);
-- -- INSERT INTO `entry_link` VALUES (1, -1);
-- -- INSERT INTO `entry_link` VALUES (1, 8);
-- -- INSERT INTO `entry_link` VALUES (1, 9);
-- -- INSERT INTO `entry_link` VALUES (1, 10);
-- -- INSERT INTO `entry_link` VALUES (10, 4);
-- -- INSERT INTO `entry_link` VALUES (7, 5);
-- -- INSERT INTO `entry_link` VALUES (7, 6);
-- -- INSERT INTO `entry_link` VALUES (8, 11);
-- -- INSERT INTO `entry_link` VALUES (12, 14);
-- -- INSERT INTO `entry_link` VALUES (8, 15);
-- -- INSERT INTO `entry_link` VALUES (15, 16);
-- -- INSERT INTO `entry_link` VALUES (15, 17);
-- -- INSERT INTO `entry_link` VALUES (16, 18);
-- -- INSERT INTO `entry_link` VALUES (16, 19);
-- -- INSERT INTO `entry_link` VALUES (16, 20);
-- -- INSERT INTO `entry_link` VALUES (7, 21);
-- -- INSERT INTO `entry_link` VALUES (10, 21);
-- -- INSERT INTO `entry_link` VALUES (12, 21);
-- -- INSERT INTO `entry_link` VALUES (12, 22);
-- -- INSERT INTO `entry_link` VALUES (16, 23);
-- -- INSERT INTO `entry_link` VALUES (12, 25);
-- -- INSERT INTO `entry_link` VALUES (15, 26);
-- -- INSERT INTO `entry_link` VALUES (26, 27);
-- -- INSERT INTO `entry_link` VALUES (12, 28);
-- -- INSERT INTO `entry_link` VALUES (26, 29);
-- -- INSERT INTO `entry_link` VALUES (12, 30);
-- -- INSERT INTO `entry_link` VALUES (1, 31);

-- --------------------------------------------------------

-- 
-- Table structure for table `reference`
-- 

CREATE TABLE `reference` (
  `r_num` int(11) NOT NULL auto_increment,
  `book_num` int(11) NOT NULL default '0',
  `chapter_num` int(11) NOT NULL default '0',
  `verse_num` int(11) NOT NULL default '0',
  PRIMARY KEY  (`r_num`)
) TYPE=MyISAM AUTO_INCREMENT=55 ;

-- 
-- Dumping data for table `reference`
-- 

INSERT INTO `reference` VALUES (1, 19, 19, 10);
INSERT INTO `reference` VALUES (2, 1, 2, 12);
INSERT INTO `reference` VALUES (3, 40, 2, 11);
INSERT INTO `reference` VALUES (4, 44, 3, 6);
INSERT INTO `reference` VALUES (5, 46, 3, 12);
INSERT INTO `reference` VALUES (6, 60, 1, 7);
INSERT INTO `reference` VALUES (7, 66, 3, 18);
INSERT INTO `reference` VALUES (8, 66, 21, 18);
INSERT INTO `reference` VALUES (9, 66, 21, 21);
INSERT INTO `reference` VALUES (10, 23, 40, 11);
INSERT INTO `reference` VALUES (11, 44, 2, 47);
INSERT INTO `reference` VALUES (12, 44, 9, 31);
INSERT INTO `reference` VALUES (13, 44, 14, 27);
INSERT INTO `reference` VALUES (14, 44, 15, 22);
INSERT INTO `reference` VALUES (15, 44, 10, 2);
INSERT INTO `reference` VALUES (16, 44, 11, 14);
INSERT INTO `reference` VALUES (17, 44, 16, 31);
INSERT INTO `reference` VALUES (18, 44, 16, 32);
INSERT INTO `reference` VALUES (19, 44, 16, 34);
INSERT INTO `reference` VALUES (20, 62, 4, 9);
INSERT INTO `reference` VALUES (21, 62, 4, 18);
INSERT INTO `reference` VALUES (22, 45, 5, 8);
INSERT INTO `reference` VALUES (23, 43, 3, 16);
INSERT INTO `reference` VALUES (24, 22, 2, 4);
INSERT INTO `reference` VALUES (25, 43, 15, 13);
INSERT INTO `reference` VALUES (26, 19, 23, 5);
INSERT INTO `reference` VALUES (27, 19, 23, 1);
INSERT INTO `reference` VALUES (28, 60, 2, 25);
INSERT INTO `reference` VALUES (29, 4, 27, 17);
INSERT INTO `reference` VALUES (30, 21, 12, 11);
INSERT INTO `reference` VALUES (31, 26, 34, 12);
INSERT INTO `reference` VALUES (32, 26, 34, 23);
INSERT INTO `reference` VALUES (33, 43, 10, 11);
INSERT INTO `reference` VALUES (34, 43, 10, 14);
INSERT INTO `reference` VALUES (35, 47, 4, 6);
INSERT INTO `reference` VALUES (36, 51, 1, 14);
INSERT INTO `reference` VALUES (37, 45, 3, 23);
INSERT INTO `reference` VALUES (38, 43, 5, 24);
INSERT INTO `reference` VALUES (39, 43, 6, 35);
INSERT INTO `reference` VALUES (40, 43, 6, 37);
INSERT INTO `reference` VALUES (41, 42, 2, 11);
INSERT INTO `reference` VALUES (42, 44, 8, 35);
INSERT INTO `reference` VALUES (43, 44, 13, 38);
INSERT INTO `reference` VALUES (44, 44, 13, 39);
INSERT INTO `reference` VALUES (45, 49, 2, 8);
INSERT INTO `reference` VALUES (46, 49, 2, 9);
INSERT INTO `reference` VALUES (47, 45, 4, 25);
INSERT INTO `reference` VALUES (48, 45, 5, 6);
INSERT INTO `reference` VALUES (49, 48, 1, 4);
INSERT INTO `reference` VALUES (50, 47, 6, 2);
INSERT INTO `reference` VALUES (51, 43, 10, 27);
INSERT INTO `reference` VALUES (52, 43, 10, 28);
INSERT INTO `reference` VALUES (53, 43, 10, 3);
INSERT INTO `reference` VALUES (54, 23, 32, 18);

-- --------------------------------------------------------

-- 
-- Table structure for table `reference_link`
-- 

CREATE TABLE `reference_link` (
  `rt_num` int(11) NOT NULL default '0',
  `r_num` int(11) NOT NULL default '0'
) TYPE=MyISAM;

-- 
-- Dumping data for table `reference_link`
-- 

INSERT INTO `reference_link` VALUES (1, 1);
INSERT INTO `reference_link` VALUES (1, 2);
INSERT INTO `reference_link` VALUES (1, 3);
INSERT INTO `reference_link` VALUES (1, 4);
INSERT INTO `reference_link` VALUES (1, 5);
INSERT INTO `reference_link` VALUES (1, 6);
INSERT INTO `reference_link` VALUES (1, 7);
INSERT INTO `reference_link` VALUES (1, 8);
INSERT INTO `reference_link` VALUES (1, 9);
INSERT INTO `reference_link` VALUES (4, 10);
INSERT INTO `reference_link` VALUES (3, 10);
INSERT INTO `reference_link` VALUES (2, 11);
INSERT INTO `reference_link` VALUES (2, 12);
INSERT INTO `reference_link` VALUES (2, 13);
INSERT INTO `reference_link` VALUES (4, 13);
INSERT INTO `reference_link` VALUES (2, 14);
INSERT INTO `reference_link` VALUES (3, 15);
INSERT INTO `reference_link` VALUES (3, 16);
INSERT INTO `reference_link` VALUES (4, 16);
INSERT INTO `reference_link` VALUES (3, 17);
INSERT INTO `reference_link` VALUES (3, 18);
INSERT INTO `reference_link` VALUES (3, 19);
INSERT INTO `reference_link` VALUES (4, 20);
INSERT INTO `reference_link` VALUES (4, 21);
INSERT INTO `reference_link` VALUES (4, 22);
INSERT INTO `reference_link` VALUES (4, 23);
INSERT INTO `reference_link` VALUES (4, 24);
INSERT INTO `reference_link` VALUES (4, 25);
INSERT INTO `reference_link` VALUES (2, 26);
INSERT INTO `reference_link` VALUES (5, 27);
INSERT INTO `reference_link` VALUES (5, 28);
INSERT INTO `reference_link` VALUES (5, 29);
INSERT INTO `reference_link` VALUES (5, 30);
INSERT INTO `reference_link` VALUES (5, 10);
INSERT INTO `reference_link` VALUES (5, 31);
INSERT INTO `reference_link` VALUES (5, 32);
INSERT INTO `reference_link` VALUES (5, 33);
INSERT INTO `reference_link` VALUES (5, 34);
INSERT INTO `reference_link` VALUES (4, 35);
INSERT INTO `reference_link` VALUES (6, 35);
INSERT INTO `reference_link` VALUES (6, 36);
INSERT INTO `reference_link` VALUES (6, 37);
INSERT INTO `reference_link` VALUES (6, 38);
INSERT INTO `reference_link` VALUES (6, 39);
INSERT INTO `reference_link` VALUES (6, 40);
INSERT INTO `reference_link` VALUES (6, 23);
INSERT INTO `reference_link` VALUES (4, 41);
INSERT INTO `reference_link` VALUES (6, 41);
INSERT INTO `reference_link` VALUES (6, 17);
INSERT INTO `reference_link` VALUES (6, 42);
INSERT INTO `reference_link` VALUES (6, 43);
INSERT INTO `reference_link` VALUES (6, 44);
INSERT INTO `reference_link` VALUES (4, 45);
INSERT INTO `reference_link` VALUES (6, 45);
INSERT INTO `reference_link` VALUES (6, 46);
INSERT INTO `reference_link` VALUES (6, 47);
INSERT INTO `reference_link` VALUES (6, 22);
INSERT INTO `reference_link` VALUES (6, 48);
INSERT INTO `reference_link` VALUES (6, 49);
INSERT INTO `reference_link` VALUES (6, 50);
INSERT INTO `reference_link` VALUES (5, 51);
INSERT INTO `reference_link` VALUES (6, 52);
INSERT INTO `reference_link` VALUES (5, 53);
INSERT INTO `reference_link` VALUES (6, 33);
INSERT INTO `reference_link` VALUES (2, 54);

-- --------------------------------------------------------

-- 
-- Table structure for table `reference_topic`
-- 

CREATE TABLE `reference_topic` (
  `rt_num` int(11) NOT NULL auto_increment,
  `topic_name` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`rt_num`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;

-- 
-- Dumping data for table `reference_topic`
-- 

INSERT INTO `reference_topic` VALUES (1, 'Fine Gold');
INSERT INTO `reference_topic` VALUES (2, 'Assembly');
INSERT INTO `reference_topic` VALUES (3, 'Family');
INSERT INTO `reference_topic` VALUES (4, 'Gods love for us');
INSERT INTO `reference_topic` VALUES (5, 'CS articles');
INSERT INTO `reference_topic` VALUES (6, 'Gospel');
