-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathscript.sql
51 lines (41 loc) · 1.97 KB
/
script.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
-- phpMyAdmin SQL Dump
-- version 4.7.0
-- https://www.phpmyadmin.net/
--
-- Servidor: 127.0.0.1
-- Tiempo de generación: 04-06-2019 a las 16:58:49
-- Versión del servidor: 10.1.25-MariaDB
-- Versión de PHP: 7.1.7
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
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 utf8mb4 */;
--
-- Base de datos: `blog`
--
DROP DATABASE IF EXISTS `blog`;
CREATE DATABASE IF NOT EXISTS `blog` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `blog`;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `entradas`
--
CREATE TABLE `entradas` (
`id` int(11) NOT NULL,
`titulo` varchar(500) NOT NULL,
`contenido` text NOT NULL,
`autor` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Volcado de datos para la tabla `entradas`
--
INSERT INTO `entradas` (`id`, `titulo`, `contenido`, `autor`) VALUES
(0, 'Inside the crazy, musical mind of Look Mum No Computer', 'Sam Battle, best known by his musical persona Look Mum No Computer, isn\'t your average YouTube star. He\'s built an impressive following not through traditional songwriting or perfectly-edited music videos -- though he\'s adept at both -- but ludicrously ambitious inventions. Over the last few years, Battle has created a creepy but strangely-mesmerizing Furby organ, a synthesizer fused with a classic Raleigh Chopper bicycle, and a hauntingly beautiful Gameboy Triple Oscillator which he described online, with refreshing honesty, as \"basically three Arduinoboys stuck together.\"', 'Nick Summers');
COMMIT;
/*!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 */;