l3m.sql 782 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12
-- phpMyAdmin SQL Dump
-- version 4.6.6deb5
-- https://www.phpmyadmin.net/

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

CREATE TABLE `l3m_blog` (
  `id` int(11) NOT NULL,
  `time` datetime NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` text NOT NULL,
13
  `shortContent` varchar(255) NOT NULL DEFAULT 'Ce billet de blog ne dispose d''aucune description.'
14 15 16 17 18 19 20 21 22 23 24 25 26 27
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `l3m_projects` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `shortContent` varchar(255) NOT NULL DEFAULT 'Pas de description.'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `l3m_blog`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `l3m_projects`
28
  ADD PRIMARY KEY (`id`);