-
Notifications
You must be signed in to change notification settings - Fork 0
/
fixtures.sql
125 lines (100 loc) · 4.01 KB
/
fixtures.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
-- phpMyAdmin SQL Dump
-- version 3.4.10.1deb1
-- http://www.phpmyadmin.net
--
-- Client: localhost
-- Généré le : Mar 27 Novembre 2012 à 15:12
-- Version du serveur: 5.5.28
-- Version de PHP: 5.3.10-1ubuntu3.4
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!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 utf8 */;
--
-- Base de données: `web-dev-esgi`
--
-- --------------------------------------------------------
--
-- Structure de la table `events`
--
CREATE TABLE IF NOT EXISTS `events` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` varchar(6) NOT NULL,
`title` varchar(255) NOT NULL,
`description` text NOT NULL,
`starts_at` datetime NOT NULL,
`ends_at` datetime NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Contenu de la table `events`
--
INSERT INTO `events` (`id`, `code`, `title`, `description`, `starts_at`, `ends_at`, `created_at`, `updated_at`) VALUES
(1, 'e00001', 'Ruby et JavaScript dans une application', 'Utilisation de deux technologies de développement Web récentes.', '2012-11-22 12:30:00', '2012-11-22 12:30:00', '2012-11-17 18:37:14', '2012-11-17 18:37:14');
-- --------------------------------------------------------
--
-- Structure de la table `ideas`
--
CREATE TABLE IF NOT EXISTS `ideas` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` varchar(6) NOT NULL,
`type` enum('course','talk','hackathon') NOT NULL,
`title` varchar(255) NOT NULL,
`description` text NOT NULL,
`email` varchar(50) NOT NULL,
`firstname` varchar(50) NOT NULL,
`lastname` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Contenu de la table `ideas`
--
INSERT INTO `ideas` (`id`, `code`, `type`, `title`, `description`, `email`, `firstname`, `lastname`) VALUES
(1, 'i00001', 'course', 'TDD en PHP', 'Introduction à la méthode Test Driven Development avec PHP.', '[email protected]', 'Fabien', 'Potencier');
-- --------------------------------------------------------
--
-- Structure de la table `subscribers`
--
CREATE TABLE IF NOT EXISTS `subscribers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`event_id` varchar(6) NOT NULL,
`email` varchar(100) NOT NULL,
`firstname` varchar(30) NOT NULL,
`lastname` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
--
-- Contenu de la table `subscribers`
--
INSERT INTO `subscribers` (`id`, `event_id`, `email`, `firstname`, `lastname`) VALUES
(1, 'e00001', '[email protected]', 'Rémy', 'Hannequin'),
(2, 'e00001', '[email protected]', 'Hank', 'Moody'),
(3, 'e00001', '[email protected]', 'Walter', 'White'),
(4, 'e00001', '[email protected]', 'Abed', 'Nadir');
-- --------------------------------------------------------
--
-- Structure de la table `talks`
--
CREATE TABLE IF NOT EXISTS `talks` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` varchar(6) NOT NULL,
`event_id` varchar(6) NOT NULL,
`title` varchar(255) NOT NULL,
`description` text NOT NULL,
`speaker` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Contenu de la table `talks`
--
INSERT INTO `talks` (`id`, `code`, `event_id`, `title`, `description`, `speaker`) VALUES
(1, 't00001', 'e00001', 'Getting Started With Ruby', 'Introduction au langage Ruby et ses différentes utilisations dans le développement Web.', 'Rémy Hannequin'),
(2, 't00002', 'e00001', 'Underscore.js vs Lo-Dash.js', 'Comparaison des deux bibliothèques de fonctions utilitaires JavaScript les plus populaires.', 'Walter White');
/*!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 */;