
-- http://www.phpmyadmin.net
--


--
-- Database: `a5629695_apococh`
--

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

--
-- Table structure for table `ciudad`
--

CREATE TABLE `ciudad` (
  `codigo` int(11) NOT NULL AUTO_INCREMENT,
  `descripcion` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`codigo`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=100 ;

--
-- Dumping data for table `ciudad`
--

INSERT INTO `ciudad` VALUES(1, 'Santo Domingo');
INSERT INTO `ciudad` VALUES(2, 'Santiago');
INSERT INTO `ciudad` VALUES(3, 'Bavaro');
INSERT INTO `ciudad` VALUES(4, 'Punta Cana');
INSERT INTO `ciudad` VALUES(5, 'Beron');
INSERT INTO `ciudad` VALUES(6, 'Higuey');
INSERT INTO `ciudad` VALUES(7, 'San Pedro de Macoris');
INSERT INTO `ciudad` VALUES(8, 'La Romana');
INSERT INTO `ciudad` VALUES(9, 'La Vega');
INSERT INTO `ciudad` VALUES(10, 'Azua');
INSERT INTO `ciudad` VALUES(11, 'Bonao');
INSERT INTO `ciudad` VALUES(12, 'San Francisco');
INSERT INTO `ciudad` VALUES(13, 'Nagua');
INSERT INTO `ciudad` VALUES(14, 'Sanchez Ramirez');
INSERT INTO `ciudad` VALUES(15, 'Samana');
INSERT INTO `ciudad` VALUES(16, 'Las Terrenas');
INSERT INTO `ciudad` VALUES(17, 'San Juan de la Maguana');
INSERT INTO `ciudad` VALUES(18, 'Puerto Plata');
INSERT INTO `ciudad` VALUES(19, 'Sosua');
INSERT INTO `ciudad` VALUES(20, 'Sanchez');
INSERT INTO `ciudad` VALUES(21, 'Samana');
INSERT INTO `ciudad` VALUES(22, 'Nagua');
INSERT INTO `ciudad` VALUES(23, 'San Pedro');
INSERT INTO `ciudad` VALUES(99, 'Internacional');
INSERT INTO `ciudad` VALUES(24, 'Cotui');
INSERT INTO `ciudad` VALUES(25, 'San Cristobal');
INSERT INTO `ciudad` VALUES(26, 'Boca Chica');
INSERT INTO `ciudad` VALUES(27, 'Juan Dolio');
INSERT INTO `ciudad` VALUES(28, 'La Romana');
INSERT INTO `ciudad` VALUES(29, 'Higuey');
INSERT INTO `ciudad` VALUES(30, 'Bavaro');
INSERT INTO `ciudad` VALUES(31, 'Mao');
INSERT INTO `ciudad` VALUES(32, 'Santiago Rodriguez');
INSERT INTO `ciudad` VALUES(33, 'Moca');
INSERT INTO `ciudad` VALUES(34, 'Hermanas Mirabal');

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

--
-- Table structure for table `informac`
--

CREATE TABLE `informac` (
  `idinformac` int(10) NOT NULL AUTO_INCREMENT,
  `compraus` varchar(10) NOT NULL,
  `ventaus` varchar(10) NOT NULL,
  `compraeur` varchar(10) NOT NULL,
  `ventaeur` varchar(10) NOT NULL,
  `gasolinpre` varchar(10) NOT NULL,
  `gasolinreg` varchar(10) NOT NULL,
  `dieselpre` varchar(10) NOT NULL,
  `dieselreg` varchar(10) NOT NULL,
  `glp` varchar(10) NOT NULL,
  PRIMARY KEY (`idinformac`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `informac`
--

INSERT INTO `informac` VALUES(1, '42.83', '42.34', '57.13', '57.80', '264.40', '246.60', '218.60', '218.60', '103.00');

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

--
-- Table structure for table `inscripcion`
--

CREATE TABLE `inscripcion` (
  `idpublicidad` int(11) NOT NULL AUTO_INCREMENT,
  `strnombre` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `strtelefono` varchar(12) COLLATE latin1_general_ci NOT NULL,
  `strcelular` varchar(12) COLLATE latin1_general_ci NOT NULL,
  `stremail` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `strasunto` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `strcomentario` varchar(100) COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`idpublicidad`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `inscripcion`
--

INSERT INTO `inscripcion` VALUES(1, 'Angel Brito', '809-388-2281', '829-448-8707', 'angelbrito19@yahoo.com', 'Necesito Publicidad Buena', 'Vamos a ver como esto trabaja');
INSERT INTO `inscripcion` VALUES(2, 'gpciXIbVQIsfdESH', 'cEkBHhQJpJxU', 'fKGEkVfqCwPZ', 'wpfnnp@yjtmir.com', 'LTHacklSeW', 'L7x5kT  <a href="http://afxbdyfzpsdb.com/">afxbdyfzpsdb</a>, [url=http://tggspsdtrbxc.com/]tggspsdtr');

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

--
-- Table structure for table `tblaudituser`
--

CREATE TABLE `tblaudituser` (
  `nombre` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  `email` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  `fechasist` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `tblaudituser`
--


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

--
-- Table structure for table `tblcategoria`
--

CREATE TABLE `tblcategoria` (
  `idCategoria` int(11) NOT NULL AUTO_INCREMENT,
  `strDescripcion` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`idCategoria`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=63 ;

--
-- Dumping data for table `tblcategoria`
--

INSERT INTO `tblcategoria` VALUES(1, 'Nacionales');
INSERT INTO `tblcategoria` VALUES(2, 'Justicia');
INSERT INTO `tblcategoria` VALUES(3, 'Deportes');
INSERT INTO `tblcategoria` VALUES(8, 'Tecnologia');
INSERT INTO `tblcategoria` VALUES(7, 'Sociedad');
INSERT INTO `tblcategoria` VALUES(6, 'Espectaculos');
INSERT INTO `tblcategoria` VALUES(4, 'Economicas');
INSERT INTO `tblcategoria` VALUES(5, 'Salud');
INSERT INTO `tblcategoria` VALUES(9, 'Politica');
INSERT INTO `tblcategoria` VALUES(10, 'Religion');
INSERT INTO `tblcategoria` VALUES(11, 'Tiempo');

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

--
-- Table structure for table `tblcliente`
--

CREATE TABLE `tblcliente` (
  `idcliente` int(11) NOT NULL AUTO_INCREMENT,
  `nombreclte` varchar(50) DEFAULT NULL,
  `direcclt` varchar(50) DEFAULT NULL,
  `celclt` varchar(50) DEFAULT NULL,
  `emailclt` varchar(50) DEFAULT NULL,
  `interesaclt` varchar(50) DEFAULT NULL,
  `nota` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`idcliente`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tblcliente`
--

INSERT INTO `tblcliente` VALUES(1, 'Angel Brito', 'C/Flor de Loto', '809-481-8508', 'angelbrito19@yahoo.com', 'Apartamentos', 'Casa y Apartamento');
INSERT INTO `tblcliente` VALUES(2, 'Angel Manuel', 'Los Tres Brazos', '829-407-5561', 'enyelelmorenito@hotmail.com', 'Casas, Apartamentos', 'Favor Avisarme con mis Datos');

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

--
-- Table structure for table `tblidioma`
--

CREATE TABLE `tblidioma` (
  `codigo` int(11) NOT NULL AUTO_INCREMENT,
  `descrip` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`codigo`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `tblidioma`
--

INSERT INTO `tblidioma` VALUES(1, 'Español');
INSERT INTO `tblidioma` VALUES(2, 'Ingles');
INSERT INTO `tblidioma` VALUES(3, 'Aleman');
INSERT INTO `tblidioma` VALUES(4, 'Frances');
INSERT INTO `tblidioma` VALUES(5, 'Ruso');

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

--
-- Table structure for table `tblvisitas`
--

CREATE TABLE `tblvisitas` (
  `codigo` varchar(10) NOT NULL,
  `cant` int(11) DEFAULT NULL,
  `cantid` varchar(10) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
