l3m.sql 3.76 KB
Newer Older
1 2 3
-- phpMyAdmin SQL Dump
-- version 4.6.6deb5
-- https://www.phpmyadmin.net/
Corentin Bettiol's avatar
Corentin Bettiol committed
4 5
--
-- Client :  localhost:3306
Corentin Bettiol's avatar
Corentin Bettiol committed
6
-- Généré le :  Jeu 21 Mars 2019 à 18:13
Corentin Bettiol's avatar
Corentin Bettiol committed
7 8
-- Version du serveur :  5.7.25-0ubuntu0.18.04.2
-- Version de PHP :  7.2.15-0ubuntu0.18.04.1
9 10 11 12

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

13 14 15 16 17 18

/*!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 */;

Corentin Bettiol's avatar
Corentin Bettiol committed
19 20 21
--
-- Base de données :  `l3m`
--
Corentin Bettiol's avatar
Corentin Bettiol committed
22
CREATE DATABASE IF NOT EXISTS `l3m` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
Corentin Bettiol's avatar
Corentin Bettiol committed
23 24 25 26 27 28 29 30 31
USE `l3m`;

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

--
-- Structure de la table `l3m_blog`
--

DROP TABLE IF EXISTS `l3m_blog`;
32 33 34
CREATE TABLE `l3m_blog` (
  `id` int(11) NOT NULL,
  `time` datetime NOT NULL,
35 36 37 38
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `shortContent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Ce billet de blog ne dispose d''aucune description.'
39 40
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Corentin Bettiol's avatar
Corentin Bettiol committed
41 42 43 44 45 46 47
-- --------------------------------------------------------

--
-- Structure de la table `l3m_projects`
--

DROP TABLE IF EXISTS `l3m_projects`;
48 49
CREATE TABLE `l3m_projects` (
  `id` int(11) NOT NULL,
50 51 52 53 54
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `shortContent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Pas de description.'
55 56
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Corentin Bettiol's avatar
Corentin Bettiol committed
57 58
-- --------------------------------------------------------

59
--
Corentin Bettiol's avatar
Corentin Bettiol committed
60
-- Structure de la table `l3m_tag`
61 62
--

Corentin Bettiol's avatar
Corentin Bettiol committed
63 64 65
DROP TABLE IF EXISTS `l3m_tag`;
CREATE TABLE `l3m_tag` (
  `id` int(11) NOT NULL,
Corentin Bettiol's avatar
Corentin Bettiol committed
66 67
  `tag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) NOT NULL
Corentin Bettiol's avatar
Corentin Bettiol committed
68 69 70 71
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

72
--
Corentin Bettiol's avatar
Corentin Bettiol committed
73
-- Structure de la table `l3m_tag_post`
74 75
--

Corentin Bettiol's avatar
Corentin Bettiol committed
76 77 78 79 80 81
DROP TABLE IF EXISTS `l3m_tag_post`;
CREATE TABLE `l3m_tag_post` (
  `id` int(11) NOT NULL,
  `tag` int(11) NOT NULL,
  `post` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
82 83 84 85 86

--
-- Index pour les tables exportées
--

Corentin Bettiol's avatar
Corentin Bettiol committed
87 88 89
--
-- Index pour la table `l3m_blog`
--
90 91 92
ALTER TABLE `l3m_blog`
  ADD PRIMARY KEY (`id`);

Corentin Bettiol's avatar
Corentin Bettiol committed
93 94 95 96 97
--
-- Index pour la table `l3m_projects`
--
ALTER TABLE `l3m_projects`
  ADD PRIMARY KEY (`id`);
98

Corentin Bettiol's avatar
Corentin Bettiol committed
99 100 101 102 103 104 105 106 107 108 109 110
--
-- Index pour la table `l3m_tag`
--
ALTER TABLE `l3m_tag`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `l3m_tag_post`
--
ALTER TABLE `l3m_tag_post`
  ADD PRIMARY KEY (`id`);

111 112 113 114 115 116 117 118
--
-- AUTO_INCREMENT pour les tables exportées
--

--
-- AUTO_INCREMENT pour la table `l3m_blog`
--
ALTER TABLE `l3m_blog`
Corentin Bettiol's avatar
Corentin Bettiol committed
119
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
120 121 122 123
--
-- AUTO_INCREMENT pour la table `l3m_projects`
--
ALTER TABLE `l3m_projects`
Corentin Bettiol's avatar
Corentin Bettiol committed
124 125 126 127 128
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pour la table `l3m_tag`
--
ALTER TABLE `l3m_tag`
Corentin Bettiol's avatar
Corentin Bettiol committed
129
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
Corentin Bettiol's avatar
Corentin Bettiol committed
130 131 132 133
--
-- AUTO_INCREMENT pour la table `l3m_tag_post`
--
ALTER TABLE `l3m_tag_post`
Corentin Bettiol's avatar
Corentin Bettiol committed
134
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;
135 136 137
/*!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 */;