news

Upload: sergio-villarreal

Post on 09-Mar-2016

215 views

Category:

Documents


0 download

DESCRIPTION

News of Mysql

TRANSCRIPT

  • -- phpMyAdmin SQL Dump-- version 4.0.10deb1-- http://www.phpmyadmin.net---- Servidor: localhost-- Tiempo de generacin: 25-01-2016 a las 00:05:01-- Versin del servidor: 5.5.46-0ubuntu0.14.04.2-- Versin de PHP: 5.5.9-1ubuntu4.14

    SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";SET time_zone = "+00:00";

    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8 */;

    ----

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

    ---- Estructura de tabla para la tabla `news`--

    CREATE TABLE IF NOT EXISTS `news` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `description` text NOT NULL, `date` date NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

    ---- Volcado de datos para la tabla `news`--

    INSERT INTO `news` (`id`, `name`, `description`, `date`) VALUES(1, 'Promocin Febrero', 'Promocin de Febrero. Todas las nuevas altas mensuales tendrn una bajada de precio de 29 a 5.', '2016-01-24');

    /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;