· 8 years ago · Aug 29, 2018, 02:58 PM
1-- Adminer 4.6.3 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8CREATE DATABASE `my_cms` /*!40100 DEFAULT CHARACTER SET utf8 */;
9USE `my_cms`;
10
11DROP TABLE IF EXISTS `pages`;
12CREATE TABLE `pages` (
13 `id` int(11) NOT NULL AUTO_INCREMENT,
14 `title` varchar(250) NOT NULL,
15 `content` longtext NOT NULL,
16 `hidden` tinyint(1) NOT NULL DEFAULT '1',
17 PRIMARY KEY (`id`)
18) ENGINE=InnoDB DEFAULT CHARSET=utf8;
19
20INSERT INTO `pages` (`id`, `title`, `content`, `hidden`) VALUES
21(1, 'Home', '<h1>Ceci est ma maison !</h1>', 0);
22
23-- 2018-08-29 14:45:09