eEL86EPG

1-- phpMyAdmin SQL Dump
2-- version 4.7.9
3-- https://www.phpmyadmin.net/
4--
5-- Hôte : 127.0.0.1:3306
6-- Généré le :  mer. 22 août 2018 à 00:25
7-- Version du serveur :  5.7.21
8-- Version de PHP :  5.6.35
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 :  `test1`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Structure de la table `articles`
29--
30
31DROP TABLE IF EXISTS `articles`;
32CREATE TABLE IF NOT EXISTS `articles` (
33  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
34  `title` varchar(50) DEFAULT NULL,
35  `body` text,
36  `created` datetime DEFAULT NULL,
37  `modified` datetime DEFAULT NULL,
38  PRIMARY KEY (`id`)
39) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
40
41--
42-- Déchargement des données de la table `articles`
43--
44
45INSERT INTO `articles` (`id`, `title`, `body`, `created`, `modified`) VALUES
46(1, 'The title', 'This is the article body.', '2018-08-13 22:50:33', NULL),
47(2, 'A title once again', 'And the article body follows.', '2018-08-13 22:50:34', NULL),
48(3, 'Title strikes back', 'This is really exciting! Not.', '2018-08-13 22:50:34', NULL),
49(6, 'titre', 'fdsa', '2018-08-14 03:31:08', '2018-08-14 03:31:08');
50
51-- --------------------------------------------------------
52
53--
54-- Structure de la table `todos`
55--
56
57DROP TABLE IF EXISTS `todos`;
58CREATE TABLE IF NOT EXISTS `todos` (
59  `id` int(11) NOT NULL AUTO_INCREMENT,
60  `titre` varchar(50) NOT NULL,
61  `description` text,
62  `creation` date NOT NULL,
63  `due` date NOT NULL,
64  `completed_date` date NOT NULL,
65  `completed` int(11) NOT NULL,
66  `deleted` int(11) NOT NULL,
67  `priority` int(11) NOT NULL,
68  PRIMARY KEY (`id`)
69) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
70
71--
72-- Déchargement des données de la table `todos`
73--
74
75INSERT INTO `todos` (`id`, `titre`, `description`, `creation`, `due`, `completed_date`, `completed`, `deleted`, `priority`) VALUES
76(1, 'Test1', 'test complet du module toto', '2018-08-14', '2018-08-31', '2018-08-31', 1, 1, 2),
77(2, 'fdsaf', 'fdsa', '2018-08-18', '2018-08-18', '1970-01-01', 0, 0, 1),
78(3, 'completed', 'finis', '2018-08-18', '2018-08-18', '1970-01-01', 0, 0, 1),
79(4, 'deleted', 'deleted todo', '2018-08-18', '2018-08-18', '1970-01-01', 0, 1, 1),
80(5, 'teset a vide', '', '2018-08-18', '2018-08-18', '1970-01-01', 0, 1, 1),
81(6, 'test 42', 'ceci est un test a la con', '2018-08-18', '2018-08-18', '1970-01-01', 0, 0, 1);
82
83-- --------------------------------------------------------
84
85--
86-- Structure de la table `todo_notes`
87--
88
89DROP TABLE IF EXISTS `todo_notes`;
90CREATE TABLE IF NOT EXISTS `todo_notes` (
91  `id` int(11) NOT NULL AUTO_INCREMENT,
92  `todo_id` int(11) NOT NULL,
93  `titre` varchar(50) NOT NULL,
94  `description` text NOT NULL,
95  `creation_date` date NOT NULL,
96  PRIMARY KEY (`id`)
97) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
98
99--
100-- Déchargement des données de la table `todo_notes`
101--
102
103INSERT INTO `todo_notes` (`id`, `todo_id`, `titre`, `description`, `creation_date`) VALUES
104(1, 1, 'ajout a la 1', 'description', '2018-08-08'),
105(2, 2, 'ajout a la 2', 'description', '2018-08-08'),
106(3, 1, 'second ajout 1', 'description 2', '2018-08-13'),
107(4, 1, 'fdsaf', 'dsfadsfa', '2018-08-14'),
108(5, 1, 'Ajout d\'une note', 'Il faut également penser a la possibilité de suprimmer et modifier les notes', '2018-08-14'),
109(6, 6, 'note', '', '2018-08-18'),
110(7, 6, 'note', '', '2018-08-18'),
111(8, 6, 'note de plus sur 32', 'ceci est du blabla', '2018-08-18');
112COMMIT;
113
114/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
115/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
116/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;