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
|
-- phpMyAdmin SQL Dump
-- version 4.2.12deb2+deb8u1
-- http://www.phpmyadmin.net
--
-- Client : localhost
-- Généré le : Ven 02 Septembre 2016 à 08:16
-- Version du serveur : 10.0.26-MariaDB-1~jessie
-- Version de PHP : 5.6.23-0+deb8u1
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
--
-- Base de données :
--
-- --------------------------------------------------------
--
-- Structure de la table `fab_booking`
--
CREATE TABLE IF NOT EXISTS `fab_booking` (
`id` int(11) NOT NULL,
`book_event_id` smallint(1) DEFAULT NULL,
`datetme` datetime DEFAULT NULL,
`book_company` varchar(255) DEFAULT NULL,
`book_bookingdate` datetime DEFAULT NULL,
`book_starttime` smallint(5) unsigned DEFAULT NULL,
`book_termrental` smallint(5) unsigned DEFAULT NULL,
`book_landingtime` text,
`book_bookingstartdate` datetime DEFAULT NULL,
`book_bookingenddate` datetime DEFAULT NULL,
`book_crewstartdate` datetime DEFAULT NULL,
`book_crewenddate` datetime DEFAULT NULL,
`date_time` datetime DEFAULT NULL
) ENGINE=MyISAM AUTO_INCREMENT=78 DEFAULT CHARSET=utf8;
--
-- Contenu de la table `fab_booking`
--
INSERT INTO `fab_booking` (`id`, `book_event_id`, `datetme`, `book_company`, `book_bookingdate`, `book_starttime`, `book_termrental`, `book_landingtime`, `book_bookingstartdate`, `book_bookingenddate`, `book_crewstartdate`, `book_crewenddate`, `date_time`) VALUES
(35, 1, '2016-04-23 00:00:00', 'Entreprise 1', '2016-04-26 00:00:00', 1, 1, '11:00', '2016-04-26 08:00:00', '2016-04-26 11:00:00', '2016-04-26 07:30:00', '2016-04-26 13:30:00', NULL),
(36, 1, '2016-05-18 00:00:00', 'Entreprise 2', '2016-05-25 00:00:00', 1, 3, '13:00', '2016-05-25 08:00:00', '2016-05-25 13:00:00', '2016-05-25 07:30:00', '2016-05-25 13:30:00', NULL),
(37, 1, '2016-05-25 00:00:00', 'Entreprise 3', '2016-06-26 00:00:00', 2, 5, '15:00', '2016-06-26 08:00:00', '2016-06-26 15:00:00', '2016-06-26 07:30:00', '2016-06-26 15:30:00', NULL),
(38, 1, '2016-05-18 00:00:00', 'Entreprise 4', '2016-09-01 00:00:00', 3, 5, '15:30', '2016-09-01 08:30:00', '2016-09-01 15:30:00', '2016-09-01 07:00:00', '2016-09-01 17:00:00', NULL),
(44, 1, '2016-05-18 00:00:00', 'Entreprise 5', '2016-09-02 00:00:00', 2, 5, '15:00', '2016-09-02 08:00:00', '2016-09-02 15:00:00', '2016-09-02 06:30:00', '2016-09-02 16:30:00', NULL),
(45, 1, '2016-05-28 00:00:00', 'Entreprise 6', '2016-09-03 00:00:00', 2, 1, '11:00', '2016-09-03 08:00:00', '2016-09-03 11:00:00', '2016-09-03 06:30:00', '2016-09-03 12:30:00', NULL),
(46, 1, '2016-05-27 00:00:00', 'Entreprise 7', '2016-09-04 00:00:00', 1, 3, '13:00', '2016-09-04 08:00:00', '2016-09-04 13:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(47, 1, '2016-06-02 00:00:00', 'Entreprise 8', '2016-09-05 13:11:06', 2, 1, '11:00', '2016-09-05 08:00:00', '2016-09-05 11:00:00', '2016-09-05 06:30:00', '2016-09-05 12:30:00', NULL),
(50, 2, '2016-06-11 00:00:00', 'Training session', '2016-08-01 08:30:00', 3, 3, '11:30', '2016-08-01 08:30:00', '2016-08-01 11:30:00', '2016-08-01 08:00:00', '2016-08-01 12:00:00', NULL),
(53, 1, '2016-07-13 00:00:00', 'Entreprise 9', '2016-09-06 17:23:10', 3, 1, '11:30', '2016-09-06 08:30:00', '2016-09-06 11:30:00', '2016-09-06 07:00:00', '2016-09-06 13:00:00', NULL),
(55, 3, '0000-00-00 00:00:00', 'Internation event', '2016-08-04 00:00:00', 3, 2, '11:00', '2016-08-04 09:00:00', '2016-08-04 11:00:00', '2016-08-04 08:30:00', '2016-08-04 11:30:00', NULL),
(56, 1, '2016-07-02 00:00:00', 'Entreprise 10', '2016-09-07 17:09:16', 1, 1, '11:00', '2016-09-07 08:00:00', '2016-09-07 11:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(57, 1, '2016-07-02 00:00:00', 'Entreprise 11', '2016-09-08 17:12:52', 2, 1, '11:30', '2016-09-08 08:30:00', '2016-09-08 11:30:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(59, 3, '0000-00-00 00:00:00', 'Internation event', '2016-08-07 00:00:00', 3, 1, '10:00', '2016-08-07 09:00:00', '2016-08-07 10:00:00', '2016-08-07 08:30:00', '2016-08-07 10:30:00', NULL),
(61, 2, '0000-00-00 00:00:00', 'Training session', '2016-08-10 18:00:00', 41, 1, '19:00', '2016-08-10 18:00:00', '2016-08-10 19:00:00', '2016-08-10 17:30:00', '2016-08-10 19:30:00', NULL),
(62, 3, '0000-00-00 00:00:00', 'Internation event', '2016-08-12 00:00:00', 3, 1, '10:00', '2016-08-12 09:00:00', '2016-08-12 10:00:00', '2016-08-12 08:30:00', '2016-08-12 11:30:00', NULL),
(63, 2, '0000-00-00 00:00:00', 'Training session', '2016-08-15 14:30:00', 27, 1, '15:30', '2016-08-15 14:30:00', '2016-08-15 15:30:00', '2016-08-15 14:00:00', '2016-08-15 16:00:00', NULL),
(64, 3, '0000-00-00 00:00:00', 'Internation event', '2016-08-18 00:00:00', 3, 1, '10:00', '2016-08-18 09:00:00', '2016-08-18 10:00:00', '2016-08-18 08:30:00', '2016-08-18 10:30:00', NULL),
(65, 2, '0000-00-00 00:00:00', 'Training session', '2016-08-22 20:00:00', 49, 1, '21:00', '2016-08-22 20:00:00', '2016-08-22 21:00:00', '2016-08-22 19:30:00', '2016-08-22 21:30:00', NULL),
(66, 2, '0000-00-00 00:00:00', 'Training session', '2016-08-31 14:00:00', 25, 1, '15:00', '2016-08-31 14:00:00', '2016-08-31 15:00:00', '2016-08-31 13:30:00', '2016-08-31 15:30:00', NULL),
(68, 3, '0000-00-00 00:00:00', 'Internation event', '2016-08-30 00:00:00', 3, 1, '10:00', '2016-08-30 09:00:00', '2016-08-30 10:00:00', '2016-08-30 08:30:00', '2016-08-30 10:30:00', NULL),
(69, 2, '0000-00-00 00:00:00', 'Training session', '2016-08-04 15:30:00', 31, 1, '16:30', '2016-08-04 15:30:00', '2016-08-04 16:30:00', '2016-08-04 15:00:00', '2016-08-04 17:00:00', NULL),
(70, 3, '0000-00-00 00:00:00', 'Internation event', '2016-08-31 00:00:00', 1, 1, '09:00', '2016-08-31 08:00:00', '2016-08-31 09:00:00', '2016-08-31 08:30:00', '2016-08-31 09:30:00', NULL),
(71, 2, '0000-00-00 00:00:00', 'Training session', '2016-08-29 08:00:00', 1, 1, '09:00', '2016-08-29 08:00:00', '2016-08-29 09:00:00', '2016-08-29 07:30:00', '2016-08-29 09:30:00', NULL),
(72, 2, '0000-00-00 00:00:00', 'Training session', '2016-08-22 09:00:00', 5, 1, '10:00', '2016-08-22 09:00:00', '2016-08-22 10:00:00', '2016-08-22 08:30:00', '2016-08-22 10:30:00', NULL),
(73, 3, '0000-00-00 00:00:00', 'Internation event', '2016-08-23 00:00:00', 11, 1, '14:00', '2016-08-23 13:00:00', '2016-08-23 14:00:00', '2016-08-23 12:30:00', '2016-08-23 13:30:00', NULL),
(74, 3, '0000-00-00 00:00:00', 'Internation event', '2016-08-22 00:00:00', 7, 1, '12:00', '2016-08-22 11:00:00', '2016-08-22 12:00:00', '2016-08-22 10:30:00', '2016-08-22 11:30:00', NULL),
(75, 2, '0000-00-00 00:00:00', 'Training session', '2016-08-23 08:00:00', 1, 2, '10:00', '2016-08-23 08:00:00', '2016-08-23 10:00:00', '2016-08-23 07:30:00', '2016-08-23 10:30:00', NULL),
(76, 1, '2016-08-24 00:00:00', 'Entreprise 12', '2016-10-31 00:00:00', 2, 1, '11:00', '2016-10-31 08:00:00', '2016-10-31 11:00:00', '2016-10-31 06:30:00', '2016-10-31 12:30:00', NULL),
(77, 2, '0000-00-00 00:00:00', 'Training session', '2016-08-26 14:00:00', 25, 3, '17:00', '2016-08-26 14:00:00', '2016-08-26 17:00:00', '2016-08-26 13:30:00', '2016-08-26 17:30:00', NULL);
--
-- Index pour les tables exportées
--
--
-- Index pour la table `fab_booking`
--
ALTER TABLE `fab_booking`
ADD PRIMARY KEY (`id`), ADD KEY `fb_prefilter_book_event_id_INDEX` (`book_event_id`);
--
-- AUTO_INCREMENT pour les tables exportées
--
--
-- AUTO_INCREMENT pour la table `fab_booking`
--
ALTER TABLE `fab_booking`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=78; |
Partager