· 6 years ago · Jul 22, 2019, 11:00 PM
1-- phpMyAdmin SQL Dump
2-- version 4.8.5
3-- https://www.phpmyadmin.net/
4--
5-- Hôte : 127.0.0.1:3306
6-- Généré le : lun. 22 juil. 2019 à 22:57
7-- Version du serveur : 5.7.26
8-- Version de PHP : 7.2.18
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Base de données : `database`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Structure de la table `blog`
29--
30
31DROP TABLE IF EXISTS `blog`;
32CREATE TABLE IF NOT EXISTS `blog` (
33 `id` int(11) NOT NULL AUTO_INCREMENT,
34 `titre` text NOT NULL,
35 `image` text NOT NULL,
36 `texte` text NOT NULL,
37 `date` text NOT NULL,
38 PRIMARY KEY (`id`)
39) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
40
41--
42-- Déchargement des données de la table `blog`
43--
44
45INSERT INTO `blog` (`id`, `titre`, `image`, `texte`, `date`) VALUES
46(8, 'test', 'https://pic.clubic.com/v1/images/1709696/raw?width=1200&fit=max&hash=b66a110eab5bfb759d547630534eb1be823a7b82', 'test', '12/05/2019'),
47(9, 'testt', 'https://lvdneng.rosselcdn.net/sites/default/files/dpistyles_v2/ena_16_9_extra_big/2018/10/29/node_478363/39827015/public/2018/10/29/B9717417001Z.1_20181029114947_000%2BGJPCALLV0.1-0.jpg?itok=7FeycSvi', 'testt', '12/05/2019'),
48(10, 'test3', 'https://images.frandroid.com/wp-content/uploads/2018/03/developpeurs-pexels-christina-morillo.jpeg', 'test3', '12/05/2019');
49
50-- --------------------------------------------------------
51
52--
53-- Structure de la table `commentaire`
54--
55
56DROP TABLE IF EXISTS `commentaire`;
57CREATE TABLE IF NOT EXISTS `commentaire` (
58 `id` int(11) NOT NULL AUTO_INCREMENT,
59 `nom` text NOT NULL,
60 `email` text NOT NULL,
61 `message` text NOT NULL,
62 PRIMARY KEY (`id`)
63) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
64
65--
66-- Déchargement des données de la table `commentaire`
67--
68
69INSERT INTO `commentaire` (`id`, `nom`, `email`, `message`) VALUES
70(1, 'rayan', 'test@test.test', 'beaux blog'),
71(2, 'test', 'coffre.forteresse@gmail.com', 'test'),
72(3, ':name', ':email2', ':message'),
73(4, 'niquebebekus le chien', 'mdrlol123@gmail.com', 'niquer vos pere'),
74(5, 'adqs', 'coffrse.forteresse@gmail.com', 'qsdqsdqsdqd'),
75(6, 'adqs', 'coffrse.forteresse@gmail.com', 'qsdqsdqsdqd'),
76(7, 'adqs', 'coffrse.forteresse@gmail.com', 'qsdqsdqsdqd'),
77(8, 'adqs', 'coffrse.forteresse@gmail.com', 'qsdqsdqsdqd');
78
79-- --------------------------------------------------------
80
81--
82-- Structure de la table `email`
83--
84
85DROP TABLE IF EXISTS `email`;
86CREATE TABLE IF NOT EXISTS `email` (
87 `id` int(11) NOT NULL AUTO_INCREMENT,
88 `email` text NOT NULL,
89 PRIMARY KEY (`id`)
90) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
91
92--
93-- Déchargement des données de la table `email`
94--
95
96INSERT INTO `email` (`id`, `email`) VALUES
97(1, 'coffre.forteresse@gmail.com'),
98(2, 'obito9330@yahoo.fr'),
99(3, 'nawel.bourlinesq@qsdqsd.fr'),
100(4, 'obito9330@yahoo.fr'),
101(5, 'test@test.fr'),
102(6, 'admin@arkalys.com'),
103(7, 'admin@arkalys.com'),
104(8, 'obito939930@yahoo.fr'),
105(9, 'nawel.bourline');
106COMMIT;
107
108/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
109/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
110/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;