-- http://www.phpmyadmin.net
--
-- Client :  algomic.sql-pro.online.net
-- Généré le :  Mer 14 Octobre 2015 à 08:57
-- Version du serveur :  5.5.38-0ubuntu0.14.04.1folays1
-- Version de PHP :  5.5.9-1ubuntu4.13




-- --------------------------------------------------------

--
-- Structure de la table `QR_client_compl`
--

CREATE TABLE IF NOT EXISTS `QR_client_compl` (
`ID` int(11) NOT NULL,
  `ID_cli` int(11) NOT NULL,
  `gmaps` varchar(200) COLLATE latin1_general_ci DEFAULT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=77 ;

--
-- Contenu de la table `QR_client_compl`
--

INSERT INTO `QR_client_compl` (`ID`, `ID_cli`, `gmaps`) VALUES
(76, 13, '!1m18!1m12!1m3!1d2793.1464339110444!2d5.922318999999997!3d45.56749380000001!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x478ba8f97296f211%3A0x96c6bca196fd44c0!2s2+Rue+Guillaume+Fichet%2C+73000+');

-- --------------------------------------------------------

--
-- Structure de la table `QR_flash`
--

CREATE TABLE IF NOT EXISTS `QR_flash` (
`id` int(11) NOT NULL,
  `id_offre` int(11) NOT NULL,
  `origine` int(11) NOT NULL,
  `date_flash` datetime NOT NULL,
  `id_clicli` int(11) DEFAULT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=164 ;

--
-- Contenu de la table `QR_flash`
--

INSERT INTO `QR_flash` (`id`, `id_offre`, `origine`, `date_flash`, `id_clicli`) VALUES
(1, 54, 19, '2015-09-25 17:33:32', 0),
(2, 78, 20, '2015-09-25 17:55:27', 27),
(3, 78, 21, '2015-09-25 17:59:57', 27),
(4, 78, 1, '2015-09-25 18:06:19', 0),
(18, 82, 36, '2015-09-26 13:05:03', 0),
(6, 82, 1, '2015-09-25 21:00:09', 0),
(7, 82, 1, '2015-09-25 21:00:39', 0),
(8, 13, 1, '2015-09-25 21:04:22', 27),
(17, 84, 40, '2015-09-26 13:03:30', 0),
(16, 82, 39, '2015-09-26 12:54:51', 0),
(15, 84, 41, '2015-09-26 12:52:00', 0),
(12, 82, 1, '2015-09-25 21:28:19', 27),
(13, 82, 1, '2015-09-25 21:30:36', 27),
(19, 84, 41, '2015-09-26 13:07:21', 27),
(131, 11, 6, '2015-10-12 21:51:38', 0),
(130, 102, 6, '2015-10-12 19:04:31', 0),
(22, 20, 1, '2015-09-26 13:16:20', 27),
(23, 85, 1, '2015-09-26 13:45:42', 0),
(24, 85, 1, '2015-09-26 13:46:01', 0),
(25, 85, 1, '2015-09-26 13:49:12', 13),
(26, 85, 43, '2015-09-26 14:05:51', 13),
(27, 85, 43, '2015-09-26 14:10:47', 13),
(28, 85, 44, '2015-09-26 14:11:54', 13),
(29, 85, 6, '2015-09-26 15:43:39', 0),
(30, 54, 6, '2015-09-26 15:43:39', 0),
(31, 78, 6, '2015-09-26 15:43:39', 0),
(32, 12, 6, '2015-09-26 15:43:39', 0),
(33, 5, 6, '2015-09-26 15:43:39', 0),
(34, 13, 6, '2015-09-26 15:43:40', 0),
(35, 82, 6, '2015-09-26 15:43:40', 0),
(36, 82, 39, '2015-09-26 23:05:49', 0),
(124, 94, 6, '2015-10-10 14:04:00', 0),
(123, 49, 6, '2015-10-10 10:07:50', 0),
(39, 85, 1, '2015-09-26 23:09:16', 0),
(40, 5, 6, '2015-09-26 23:13:41', 0),
(41, 14, 6, '2015-09-26 23:14:25', 0),
(42, 14, 6, '2015-09-26 23:15:07', 0),
(107, 92, 1, '2015-10-03 09:25:23', 0),
(106, 92, 51, '2015-10-02 22:00:39', 0),
(122, 90, 6, '2015-10-10 10:02:05', 0),
(121, 87, 43, '2015-10-10 01:24:16', 0),
(47, 84, 6, '2015-09-27 18:12:17', 0),
(48, 84, 6, '2015-09-27 18:27:49', 0),
(49, 84, 6, '2015-09-27 18:32:55', 0),
(50, 85, 6, '2015-09-27 18:34:42', 0),
(51, 84, 6, '2015-09-27 18:49:43', 0),
(52, 84, 6, '2015-09-27 18:51:30', 0),
(105, 92, 1, '2015-10-02 21:26:48', 0),
(54, 84, 6, '2015-09-27 18:51:43', 0),
(116, 90, 44, '2015-10-08 22:40:08', 0),
(115, 92, 44, '2015-10-08 22:39:34', 0),
(57, 85, 6, '2015-09-27 19:12:07', 0),
(58, 85, 6, '2015-09-27 19:12:21', 0),
(59, 84, 6, '2015-09-28 16:41:52', 0),
(60, 49, 6, '2015-09-28 17:18:46', 27),
(128, 100, 6, '2015-10-12 13:51:04', 27),
(62, 49, 6, '2015-09-28 17:39:16', 0),
(63, 49, 6, '2015-09-28 17:40:21', 0),
(114, 92, 44, '2015-10-08 22:36:47', 0),
(65, 85, 6, '2015-09-28 20:10:28', 0),
(66, 49, 6, '2015-09-28 21:38:32', 0),
(67, 49, 6, '2015-09-28 21:42:36', 0),
(68, 49, 6, '2015-09-28 21:43:05', 0),
(69, 82, 6, '2015-09-28 21:48:06', 27),
(70, 49, 6, '2015-09-28 22:24:52', 0),
(129, 102, 6, '2015-10-12 19:03:02', 0),
(72, 82, 6, '2015-09-28 22:26:31', 27),
(73, 43, 6, '2015-09-28 22:26:57', 27),
(74, 49, 6, '2015-09-28 22:28:54', 27),
(75, 5, 6, '2015-09-28 22:31:05', 27),
(76, 84, 6, '2015-09-28 22:31:17', 27),
(77, 84, 6, '2015-09-28 22:36:00', 27),
(78, 84, 6, '2015-09-28 22:36:56', 27),
(113, 85, 44, '2015-10-08 22:34:31', 0),
(80, 49, 6, '2015-09-29 09:33:48', 0),
(81, 74, 6, '2015-09-29 09:34:04', 0),
(82, 85, 6, '2015-09-29 09:35:53', 0),
(83, 49, 6, '2015-09-29 19:52:12', 0),
(84, 49, 6, '2015-09-29 19:55:03', 0),
(104, 92, 1, '2015-10-02 20:09:40', 0),
(112, 85, 1, '2015-10-08 21:45:30', 0),
(111, 85, 1, '2015-10-08 21:45:07', 0),
(110, 85, 6, '2015-10-08 21:42:58', 0),
(89, 49, 6, '2015-09-29 21:33:48', 0),
(90, 49, 6, '2015-09-29 21:33:57', 0),
(91, 49, 6, '2015-09-29 21:34:04', 0),
(92, 85, 6, '2015-09-29 21:34:29', 50),
(93, 49, 6, '2015-09-29 21:35:48', 50),
(109, 90, 44, '2015-10-08 21:40:27', 0),
(95, 49, 6, '2015-09-30 08:41:48', 0),
(96, 43, 6, '2015-09-30 08:41:57', 0),
(97, 43, 6, '2015-09-30 08:43:57', 0),
(98, 49, 6, '2015-09-30 17:05:42', 0),
(127, 97, 6, '2015-10-12 13:44:23', 0),
(126, 97, 6, '2015-10-12 13:43:41', 0),
(125, 101, 6, '2015-10-10 15:07:41', 0),
(102, 67, 7, '2015-09-30 20:09:39', 0),
(103, 67, 7, '2015-09-30 20:14:38', 0),
(132, 11, 6, '2015-10-12 23:23:14', 0),
(133, 102, 6, '2015-10-12 23:23:44', 0),
(134, 5, 68, '2015-10-13 20:13:14', 0),
(135, 5, 68, '2015-10-13 20:14:41', 0),
(136, 46, 68, '2015-10-13 20:15:17', 0),
(137, 139, 68, '2015-10-13 20:29:10', 0),
(138, 46, 68, '2015-10-13 21:04:05', 0),
(139, 46, 68, '2015-10-13 21:09:39', 0),
(140, 139, 68, '2015-10-13 21:55:46', 0),
(141, 139, 68, '2015-10-13 21:56:11', 0),
(142, 5, 68, '2015-10-13 21:57:14', 0),
(143, 4, 58, '2015-10-13 22:01:02', 0),
(144, 140, 58, '2015-10-13 22:03:13', 0),
(145, 107, 58, '2015-10-13 22:10:43', 0),
(146, 107, 58, '2015-10-13 22:16:50', 27),
(147, 102, 6, '2015-10-13 22:26:40', 0),
(148, 102, 6, '2015-10-13 22:26:56', 0),
(149, 102, 6, '2015-10-13 22:26:58', 0),
(150, 102, 6, '2015-10-13 22:27:10', 0),
(151, 90, 6, '2015-10-13 22:31:46', 27),
(152, 102, 6, '2015-10-13 22:32:11', 27),
(153, 76, 6, '2015-10-13 22:32:58', 27),
(154, 12, 6, '2015-10-13 22:39:45', 27),
(155, 49, 6, '2015-10-13 22:40:05', 27),
(156, 82, 6, '2015-10-13 22:50:45', 27),
(157, 4, 6, '2015-10-13 23:10:04', 27),
(158, 49, 6, '2015-10-13 23:11:54', 27),
(159, 49, 6, '2015-10-13 23:30:55', 27),
(160, 107, 58, '2015-10-13 23:40:06', 0),
(161, 49, 6, '2015-10-13 23:45:31', 27),
(162, 49, 6, '2015-10-13 23:47:59', 27),
(163, 90, 6, '2015-10-14 08:06:45', 0);

-- --------------------------------------------------------

--
-- Structure de la table `QR_offre`
--

CREATE TABLE IF NOT EXISTS `QR_offre` (
`id` int(11) NOT NULL,
  `date_creation` date NOT NULL,
  `libelle` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `apromo` tinyint(1) NOT NULL DEFAULT '0',
  `date_deb` date NOT NULL,
  `date_fin` date NOT NULL,
  `id_client` int(11) NOT NULL,
  `mail_exig` tinyint(1) NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=141 ;

--
-- Contenu de la table `QR_offre`
--

INSERT INTO `QR_offre` (`id`, `date_creation`, `libelle`, `apromo`, `date_deb`, `date_fin`, `id_client`, `mail_exig`) VALUES
(1, '2015-03-30', '20% sur la couleur de votre choix.', 0, '2015-04-01', '2015-06-30', 13, 0),
(5, '2015-05-01', '1 jour de location gratuit', 0, '2015-01-01', '2015-12-30', 20, 0),
(4, '2015-05-01', 'l''apéro', 0, '2015-01-01', '2015-12-30', 19, 0),
(6, '2015-05-01', '20 % sur toutes les bières avant 23 heures', 0, '2015-01-01', '2015-05-30', 21, 0),
(7, '2015-05-07', '4 tomates cœur de bœuf bien mures', 0, '2015-04-01', '2015-08-01', 22, 1),
(13, '2015-05-14', 'Livraison de gravier gratuite', 0, '2015-01-01', '2015-05-30', 27, 0),
(12, '2015-05-14', 'Une BMW 430', 0, '2015-01-01', '2015-12-30', 26, 1),
(11, '2015-05-08', 'Pour 1 pizza achetée 15 vous sont offertes et livrées à  domicile dans une rayon de 20 kms.', 0, '2015-01-01', '2015-12-30', 23, 0),
(14, '2015-05-14', 'Location de camion benne + grue', 0, '2015-01-01', '2015-05-30', 28, 1),
(15, '2015-05-14', 'une paire de chaussette pour tout achat d''une paire de chaussure à 300€', 0, '2015-01-01', '2015-12-30', 29, 0),
(20, '2015-05-16', '10% sur l''étude de voisinnage', 0, '2015-02-18', '2015-10-18', 49, 0),
(21, '2015-05-16', 'Concert gratuit', 0, '2015-02-18', '2015-09-18', 50, 0),
(22, '2015-05-16', 'Concert gratuit', 0, '2015-02-18', '2015-09-18', 50, 0),
(46, '0000-00-00', 'une bouteille à la mer', 0, '2014-12-01', '2015-12-08', 20, 1),
(42, '0000-00-00', 'Une paire de lunettes de soleil aux verres indice 4', 0, '2015-01-12', '2015-05-30', 60, 0),
(43, '0000-00-00', '300000€', 0, '2015-07-01', '2016-12-21', 61, 0),
(40, '0000-00-00', 'Un Vélo électrique BMW ', 0, '2015-02-18', '2015-09-18', 26, 0),
(49, '0000-00-00', 'Une bouteille de blanc pour tout achat de plus de 200€', 0, '2015-02-18', '2015-10-18', 22, 1),
(37, '0000-00-00', 'le marathon de Paris pour tout achat d''une paire de running Nike', 0, '2015-02-18', '2015-09-18', 29, 0),
(45, '0000-00-00', 'Un croissant gratuit pour une tarte achetée', 0, '2015-02-18', '2015-09-18', 63, 0),
(54, '0000-00-00', '10% sur une entrée au PAX', 0, '2015-12-01', '2015-12-31', 64, 1),
(35, '0000-00-00', 'ça va être sympa ', 0, '2015-01-01', '2015-05-30', 55, 0),
(36, '0000-00-00', 'bieres a gogo ', 0, '2015-12-09', '2015-12-31', 55, 0),
(84, '2015-09-26', 'Un stylo Mont Blanc', 0, '2015-09-01', '2015-12-02', 48, 1),
(56, '0000-00-00', 'Prestation à 50% avec le pass promo', 0, '2015-01-01', '2015-10-30', 52, 0),
(57, '0000-00-00', 'Le buffet après cérémonie gratuit pour l''organisation complète de votre mariage', 0, '2015-01-01', '2015-05-30', 59, 0),
(58, '0000-00-00', 'Un sandwich offert pour une salade commandée', 0, '2015-01-01', '2015-05-30', 59, 0),
(59, '0000-00-00', 'Une très belle nuit', 0, '2015-01-01', '2015-05-30', 24, 1),
(60, '0000-00-00', 'L''apéritif est offert', 0, '2015-01-01', '2015-06-30', 67, 0),
(61, '0000-00-00', 'Ce sera une surprise', 0, '2015-01-01', '2015-10-30', 51, 0),
(100, '2015-10-10', 'Apromo', 1, '2015-01-01', '2020-12-31', 22, 0),
(70, '0000-00-00', 'le 3ème god gratuit', 0, '2015-01-12', '2015-08-30', 68, 1),
(75, '0000-00-00', '40% sur ton forfait journée ', 0, '2016-01-01', '2016-02-01', 69, 1),
(71, '0000-00-00', 'Un sex-toy pour 15 DVD', 0, '2015-01-01', '2015-08-30', 68, 0),
(65, '0000-00-00', 'Une grenadine entre 15 et 16 heures ', 0, '2015-06-30', '2015-07-31', 22, 1),
(67, '0000-00-00', 'Un composteur pour 3000 € d''achat', 0, '2015-09-01', '2015-10-15', 22, 1),
(69, '0000-00-00', '1 moto GS', 0, '2015-02-18', '2016-03-20', 26, 1),
(74, '0000-00-00', 'Un jus de carotte ', 0, '2015-01-01', '2015-12-31', 22, 0),
(73, '0000-00-00', 'un jambon acheté = un voyage en Espagne', 0, '2015-02-18', '2015-09-18', 63, 1),
(76, '0000-00-00', 'Une visite des studios', 0, '2015-01-01', '2015-11-30', 70, 1),
(78, '0000-00-00', '15% sur le forfait séjour aux ARCS', 0, '2015-01-01', '2015-01-30', 64, 1),
(80, '2015-09-25', 'Une participation à la Matinale de FI', 0, '2016-01-31', '2016-01-31', 70, 1),
(81, '2015-09-25', 'Le forfait enfants pour 2 adultes', 0, '2016-01-09', '2016-01-16', 64, 1),
(82, '2015-09-25', 'Invitation gratuite à la conférence du Medef', 0, '2015-12-01', '2015-12-01', 48, 1),
(85, '2015-09-26', 'Le forfait saison à 20€', 0, '2015-01-01', '2015-10-02', 72, 1),
(95, '2015-10-09', 'Désolé aucune offre actuellement', 1, '2015-01-01', '2020-01-01', 72, 0),
(94, '2015-10-09', 'la nouvelle offre', 0, '2015-10-01', '2016-01-02', 72, 1),
(88, '2015-10-02', 'Un jus de poire', 0, '2015-04-01', '2016-01-16', 22, 0),
(90, '2015-10-02', 'Un choucas pour un forfait saison', 0, '2015-04-01', '2016-01-16', 72, 0),
(102, '2015-10-12', '3 cours ESF pour 3 forfaits semaine enfants', 0, '2015-10-10', '2016-01-31', 72, 1),
(96, '2015-10-10', 'Un cendrier gm', 0, '0000-00-00', '0000-00-00', 72, 0),
(92, '2015-10-02', 'Une heure avec service de secours', 0, '2016-01-05', '2016-01-05', 72, 0),
(97, '2015-10-10', 'Un canon de blanc au départ de Vernant', 0, '2015-09-01', '2016-01-02', 72, 0),
(98, '2015-10-10', 'Livraison gratuite', 1, '2015-09-24', '2016-03-30', 23, 0),
(99, '2015-10-10', 'Aucune offre actuellement', 1, '2015-01-01', '2029-01-01', 23, 0),
(101, '2015-10-10', 'Contrôles au Phare', 1, '2015-09-09', '2016-09-23', 22, 0),
(103, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2000-10-13', '2999-12-31', 70, 0),
(104, '2015-10-13', 'Une participation à ''''ça peut pas faire de mal''''', 0, '2015-02-18', '2016-01-16', 70, 1),
(105, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 1, 0),
(106, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 4, 0),
(107, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 19, 0),
(108, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 20, 0),
(109, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 21, 0),
(110, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 22, 0),
(111, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 23, 0),
(112, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 24, 0),
(113, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 26, 0),
(114, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 27, 0),
(115, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 28, 0),
(116, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 29, 0),
(117, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 48, 0),
(118, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 49, 0),
(119, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 50, 0),
(120, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 51, 0),
(121, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 52, 0),
(122, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 53, 0),
(123, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 54, 0),
(124, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 55, 0),
(125, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 56, 0),
(126, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 57, 0),
(127, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 59, 0),
(128, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 60, 0),
(129, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 61, 0),
(130, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 63, 0),
(131, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 65, 0),
(132, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 66, 0),
(133, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 67, 0),
(134, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 68, 0),
(135, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 69, 0),
(136, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 70, 0),
(137, '2015-10-13', 'Désolé pas de promo actuellement', 1, '2015-01-01', '2999-12-31', 72, 0),
(138, '2015-10-13', '1 litre d''huile de synthèse', 0, '2015-02-18', '2016-03-20', 26, 0),
(139, '2015-10-13', 'Une soirée ', 0, '2015-09-01', '2016-01-02', 20, 0),
(140, '2015-10-13', 'Champagne pour tout le monde', 0, '2015-01-01', '2016-01-02', 19, 1);

-- --------------------------------------------------------

--
-- Structure de la table `QR_OF_Affect`
--

CREATE TABLE IF NOT EXISTS `QR_OF_Affect` (
`id` int(11) NOT NULL,
  `id_of` int(11) NOT NULL,
  `id_of_orig` int(11) NOT NULL,
  `of_date_crea` date NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=198 ;

--
-- Contenu de la table `QR_OF_Affect`
--

INSERT INTO `QR_OF_Affect` (`id`, `id_of`, `id_of_orig`, `of_date_crea`) VALUES
(1, 76, 1, '2015-09-23'),
(123, 76, 1, '2015-10-02'),
(122, 76, 1, '2015-10-02'),
(121, 76, 1, '2015-10-02'),
(120, 76, 1, '2015-10-02'),
(119, 76, 1, '2015-10-02'),
(118, 74, 7, '2015-09-30'),
(117, 95, 50, '2015-09-29'),
(103, 85, 48, '2015-09-26'),
(102, 85, 47, '2015-09-26'),
(12, 76, 1, '2015-09-25'),
(13, 76, 1, '2015-09-25'),
(14, 76, 1, '2015-09-25'),
(15, 76, 1, '2015-09-25'),
(16, 76, 1, '2015-09-25'),
(17, 76, 1, '2015-09-25'),
(18, 76, 1, '2015-09-25'),
(19, 76, 1, '2015-09-25'),
(20, 76, 1, '2015-09-25'),
(21, 76, 1, '2015-09-25'),
(22, 76, 1, '2015-09-25'),
(23, 76, 1, '2015-09-25'),
(24, 76, 1, '2015-09-25'),
(25, 76, 1, '2015-09-25'),
(26, 76, 1, '2015-09-25'),
(27, 76, 1, '2015-09-25'),
(28, 76, 1, '2015-09-25'),
(29, 76, 1, '2015-09-25'),
(30, 76, 1, '2015-09-25'),
(31, 76, 1, '2015-09-25'),
(32, 76, 1, '2015-09-25'),
(33, 76, 1, '2015-09-25'),
(34, 76, 1, '2015-09-25'),
(35, 76, 1, '2015-09-25'),
(36, 76, 1, '2015-09-25'),
(37, 76, 1, '2015-09-25'),
(38, 76, 1, '2015-09-25'),
(39, 76, 1, '2015-09-25'),
(40, 76, 1, '2015-09-25'),
(41, 76, 1, '2015-09-25'),
(42, 76, 1, '2015-09-25'),
(114, 76, 1, '2015-09-27'),
(148, 15, 43, '2015-10-09'),
(150, 95, 49, '2015-10-09'),
(46, 76, 1, '2015-09-25'),
(47, 76, 1, '2015-09-25'),
(48, 76, 1, '2015-09-25'),
(49, 76, 1, '2015-09-25'),
(50, 76, 1, '2015-09-25'),
(51, 76, 1, '2015-09-25'),
(52, 76, 1, '2015-09-25'),
(53, 76, 1, '2015-09-25'),
(54, 76, 1, '2015-09-25'),
(55, 76, 1, '2015-09-25'),
(56, 76, 1, '2015-09-25'),
(57, 76, 1, '2015-09-25'),
(59, 76, 1, '2015-09-25'),
(101, 85, 46, '2015-09-26'),
(100, 85, 46, '2015-09-26'),
(152, 76, 1, '2015-10-09'),
(98, 76, 1, '2015-09-26'),
(147, 15, 44, '2015-10-08'),
(149, 95, 49, '2015-10-09'),
(112, 95, 45, '2015-09-26'),
(94, 76, 1, '2015-09-26'),
(93, 77, 42, '2015-09-26'),
(69, 76, 1, '2015-09-25'),
(92, 84, 41, '2015-09-26'),
(71, 76, 1, '2015-09-25'),
(91, 84, 40, '2015-09-26'),
(90, 76, 1, '2015-09-26'),
(89, 82, 39, '2015-09-26'),
(88, 83, 38, '2015-09-26'),
(87, 83, 37, '2015-09-26'),
(86, 76, 1, '2015-09-26'),
(85, 82, 36, '2015-09-26'),
(84, 55, 35, '2015-09-26'),
(83, 55, 34, '2015-09-26'),
(82, 55, 33, '2015-09-26'),
(137, 15, 43, '2015-10-08'),
(151, 95, 53, '2015-10-09'),
(146, 76, 1, '2015-10-08'),
(145, 15, 44, '2015-10-08'),
(139, 95, 52, '2015-10-08'),
(153, 15, 43, '2015-10-09'),
(154, 95, 45, '2015-10-09'),
(155, 15, 44, '2015-10-09'),
(156, 95, 49, '2015-10-09'),
(157, 95, 53, '2015-10-09'),
(158, 76, 1, '2015-10-09'),
(159, 95, 51, '2015-10-09'),
(160, 95, 50, '2015-10-09'),
(161, 95, 52, '2015-10-10'),
(162, 76, 1, '2015-10-10'),
(163, 76, 1, '2015-10-10'),
(164, 76, 1, '2015-10-10'),
(165, 95, 52, '2015-10-10'),
(166, 95, 54, '2015-10-10'),
(167, 11, 55, '2015-10-10'),
(168, 76, 1, '2015-10-10'),
(169, 76, 1, '2015-10-10'),
(170, 76, 1, '2015-10-10'),
(171, 11, 56, '2015-10-10'),
(172, 76, 1, '2015-10-10'),
(173, 49, 2, '2015-10-10'),
(174, 76, 1, '2015-10-10'),
(175, 76, 1, '2015-10-10'),
(176, 74, 11, '2015-10-10'),
(177, 49, 2, '2015-10-10'),
(178, 74, 57, '2015-10-10'),
(179, 76, 1, '2015-10-10'),
(180, 107, 58, '2015-10-12'),
(181, 95, 54, '2015-10-12'),
(184, 95, 60, '2015-10-12'),
(185, 95, 59, '2015-10-12'),
(186, 95, 61, '2015-10-12'),
(187, 76, 1, '2015-10-12'),
(188, 104, 64, '2015-10-13'),
(189, 104, 65, '2015-10-13'),
(190, 76, 1, '2015-10-13'),
(191, 12, 66, '2015-10-13'),
(192, 69, 67, '2015-10-13'),
(193, 138, 1, '2015-10-13'),
(194, 5, 68, '2015-10-13'),
(195, 139, 69, '2015-10-13'),
(196, 139, 1, '2015-10-13'),
(197, 140, 1, '2015-10-13');

-- --------------------------------------------------------

--
-- Structure de la table `QR_OF_Affect_histo`
--

CREATE TABLE IF NOT EXISTS `QR_OF_Affect_histo` (
`id` int(11) NOT NULL,
  `id_of` int(11) NOT NULL,
  `id_of_orig` int(11) NOT NULL,
  `of_date_crea` date NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=132 ;

-- --------------------------------------------------------

--
-- Structure de la table `QR_OF_Type`
--

CREATE TABLE IF NOT EXISTS `QR_OF_Type` (
`id` int(11) NOT NULL,
  `libelle` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `Commentaire` varchar(200) COLLATE latin1_general_ci NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=14 ;

--
-- Contenu de la table `QR_OF_Type`
--

INSERT INTO `QR_OF_Type` (`id`, `libelle`, `Commentaire`) VALUES
(1, 'Portail', 'Provient d''un flash depuis le portail'),
(2, 'Web', 'Sur tous les sites web'),
(9, 'Edition', 'Tracts panneau Set de table Autocollant'),
(10, 'Presse', 'Presse '),
(11, 'Electronique', 'Ecran Promo Tablette smartphone'),
(12, 'Autre', 'Autre support'),
(13, 'Véhicule', 'Support sur véhicule - vecteur mobile');

-- --------------------------------------------------------

--
-- Structure de la table `QR_origine`
--

CREATE TABLE IF NOT EXISTS `QR_origine` (
`id` int(11) NOT NULL,
  `libelle` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `commentaire_ori` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `id_client` int(11) NOT NULL,
  `id_type` int(11) NOT NULL,
  `qr_fixe` int(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=70 ;

--
-- Contenu de la table `QR_origine`
--

INSERT INTO `QR_origine` (`id`, `libelle`, `commentaire_ori`, `id_client`, `id_type`, `qr_fixe`) VALUES
(1, 'Portail FEC', 'Portail de flash-e-code', 22, 1, 0),
(2, 'Tracts FS', 'Tracting sur la foire de Savoie', 22, 2, 0),
(3, 'papier', 'Tract', 70, 8, 0),
(4, 'papier', 'Affiche', 20, 8, 0),
(5, 'papier', 'Carte A5', 20, 8, 0),
(6, 'http', 'Portail', 20, 8, 0),
(7, 'Ecran CHY', 'Ecran de l''agence des Bellevilles', 22, 11, 0),
(11, 'Ecran G Chy', 'Écran géant extérieur', 22, 11, 0),
(16, 'www.franceinter.fr', 'Sur la page d''accueil ', 70, 2, 0),
(17, 'Mag Express', 'Insert pub 1/2 page dans pages média', 70, 10, 0),
(18, 'Mag le Figaro', '1/2 page dans les pages TV', 70, 10, 0),
(19, 'Borne Caisse Vernant', 'Sticker sur les bornes de Vernant', 64, 11, 0),
(20, 'Mag TGV', 'Mag TGV de mars 2015', 64, 10, 0),
(21, 'Le bon coin', 'Page Parisienne ', 64, 2, 0),
(22, '4x3 Entrer Flaine', 'A retirer ', 64, 9, 0),
(23, 'Com Presse Paris', 'Tracts distribué par hôtesses ', 48, 9, 0),
(30, 'Com Presse Paris', 'test', 48, 1, 0),
(31, 'Com Presse Paris', 'test', 48, 11, 0),
(32, 'Com Presse Paris', 'express', 48, 11, 0),
(33, 'Le Dauphiné 09/15', 'Pages Chambéry', 48, 10, 0),
(34, 'Tract Marché ', 'Tract sur le marché de Chambéry ', 48, 9, 0),
(35, 'Site commercial 2015', 'Sur la page accueil depuis le 01/07/2015', 48, 12, 0),
(36, 'Ecran Info Agence Belleville', 'Depuis le début de la saison', 48, 11, 0),
(37, 'Site', 'Accueil', 48, 2, 0),
(38, 'Le magazine TGV', 'Semestre 1 2016', 48, 10, 0),
(39, 'Le canard enchainé', '02/12/12015', 48, 10, 0),
(40, 'Tracting marché CHY', 'Tracting du mois de mai à juillet 2015', 48, 9, 0),
(41, 'Site commercial 2015', 'Page promo', 48, 2, 0),
(42, 'Ecran Agence Boulogne', 'Depuis le 15/02/2002', 49, 11, 0),
(43, 'Ecran Vernant', 'Petit écran dans la file d''attente', 72, 11, 0),
(44, 'Sticker sur CTRL GV', 'Depuis le 15/02/2002', 72, 9, 1),
(45, 'Com Presse Paris', 'Déménagement Hausman', 72, 9, 0),
(49, 'Ecran DMC 1', 'Dans le hall du DMC', 72, 11, 0),
(50, 'Site de Flaine.com', 'Page d''accueil du site saison 15/16', 72, 2, 0),
(51, 'Autocollant DMC', 'Dans les cabines Fixe 2016', 72, 9, 1),
(52, 'Flash-E-code', '', 72, 1, 0),
(53, '4X3 Chatillon', 'Mis en place le 10/08/2015', 72, 9, 0),
(54, 'Navette Giffre Ext.', 'Sur le cul des bus ', 72, 1, 0),
(55, 'Le 73', 'Première page 600€', 23, 10, 0),
(56, 'Camion livraison ', 'Derrriere', 23, 9, 0),
(57, 'Bus Stac', 'Dans les bus de la Stac de chy', 22, 9, 0),
(58, '4X3 Chatillon', 'Le panneau à la sortie de Chatillon', 19, 11, 0),
(59, 'Navette Giffre Int', 'Intérieure de la navette', 72, 13, 0),
(60, 'Voiture entreprise', '4X4', 72, 13, 0),
(61, 'Gal. Flaine', 'Affichage Galerie Marchande Flaine', 72, 9, 0),
(62, 'Voiture perso', 'Portière avant', 51, 13, 0),
(63, 'test écran', 'test', 70, 11, 0),
(64, 'Accueil Radio', 'Dans la salle d''accueil invité', 70, 11, 0),
(65, 'Véhicule serv Com', 'Les véhicules des commerciaux', 70, 13, 0),
(66, 'Tablette Salon', 'Tablette sur le salon de Francfort', 26, 11, 0),
(67, '4X4', 'Sur les 4X4 du salon', 26, 13, 0),
(68, 'Le 73', 'A la une en gauche du titre', 20, 9, 0),
(69, 'Audi com', 'Sur les portière de l''Audi du commercial', 20, 13, 0);

-- --------------------------------------------------------

--
-- Structure de la table `QR_relation_clicli`
--

CREATE TABLE IF NOT EXISTS `QR_relation_clicli` (
`id` int(11) NOT NULL,
  `id_cli` int(11) NOT NULL,
  `id_clicli` int(11) NOT NULL,
  `id_offre` int(11) NOT NULL,
  `date_consultation` date NOT NULL,
  `date_utilisation` date NOT NULL,
  `id_valideur` int(11) NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=32 ;

--
-- Contenu de la table `QR_relation_clicli`
--

INSERT INTO `QR_relation_clicli` (`id`, `id_cli`, `id_clicli`, `id_offre`, `date_consultation`, `date_utilisation`, `id_valideur`) VALUES
(1, 20, 27, 5, '2015-08-02', '0000-00-00', 0),
(2, 26, 27, 12, '2015-08-02', '2015-08-02', 0),
(4, 20, 27, 46, '2015-08-02', '0000-00-00', 0),
(5, 69, 27, 75, '2015-08-02', '2015-08-02', 0),
(6, 70, 27, 76, '2015-08-02', '2015-10-13', 0),
(7, 28, 27, 14, '2015-08-02', '2015-08-07', 0),
(8, 26, 50, 12, '2015-08-12', '0000-00-00', 0),
(9, 20, 50, 5, '2015-08-12', '0000-00-00', 0),
(10, 23, 50, 11, '2015-08-12', '0000-00-00', 0),
(11, 22, 27, 65, '2015-08-18', '0000-00-00', 0),
(12, 64, 27, 78, '2015-09-24', '2015-09-24', 0),
(13, 64, 27, 54, '2015-09-24', '0000-00-00', 0),
(14, 48, 27, 82, '2015-09-25', '2015-10-13', 0),
(15, 27, 27, 13, '2015-09-25', '0000-00-00', 0),
(17, 49, 27, 20, '2015-09-26', '0000-00-00', 0),
(18, 72, 13, 85, '2015-09-26', '2015-09-26', 0),
(20, 22, 27, 49, '2015-09-28', '2015-10-13', 47),
(21, 61, 27, 43, '2015-09-28', '0000-00-00', 0),
(22, 48, 27, 84, '2015-09-28', '0000-00-00', 0),
(25, 22, 50, 49, '2015-09-29', '0000-00-00', 0),
(26, 72, 50, 85, '2015-09-29', '0000-00-00', 0),
(30, 72, 27, 102, '2015-10-12', '2015-10-12', 0),
(29, 72, 27, 97, '2015-10-12', '0000-00-00', 0),
(31, 19, 27, 4, '2015-10-13', '0000-00-00', 0);

--
-- Index pour la table `QR_client_compl`
--
ALTER TABLE `QR_client_compl`
 ADD PRIMARY KEY (`ID`);

--
-- Index pour la table `QR_flash`
--
ALTER TABLE `QR_flash`
 ADD PRIMARY KEY (`id`);

--
-- Index pour la table `QR_offre`
--
ALTER TABLE `QR_offre`
 ADD PRIMARY KEY (`id`);

--
-- Index pour la table `QR_OF_Affect`
--
ALTER TABLE `QR_OF_Affect`
 ADD PRIMARY KEY (`id`);

--
-- Index pour la table `QR_OF_Affect_histo`
--
ALTER TABLE `QR_OF_Affect_histo`
 ADD PRIMARY KEY (`id`);

--
-- Index pour la table `QR_OF_Type`
--
ALTER TABLE `QR_OF_Type`
 ADD PRIMARY KEY (`id`);

--
-- Index pour la table `QR_origine`
--
ALTER TABLE `QR_origine`
 ADD PRIMARY KEY (`id`);

--
-- Index pour la table `QR_relation_clicli`
--
ALTER TABLE `QR_relation_clicli`
 ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT pour la table `QR_client_compl`
--
ALTER TABLE `QR_client_compl`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=77;
--
-- AUTO_INCREMENT pour la table `QR_flash`
--
ALTER TABLE `QR_flash`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=164;
--
-- AUTO_INCREMENT pour la table `QR_offre`
--
ALTER TABLE `QR_offre`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=141;
--
-- AUTO_INCREMENT pour la table `QR_OF_Affect`
--
ALTER TABLE `QR_OF_Affect`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=198;
--
-- AUTO_INCREMENT pour la table `QR_OF_Affect_histo`
--
ALTER TABLE `QR_OF_Affect_histo`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=132;
--
-- AUTO_INCREMENT pour la table `QR_OF_Type`
--
ALTER TABLE `QR_OF_Type`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT pour la table `QR_origine`
--
ALTER TABLE `QR_origine`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=70;
--
-- AUTO_INCREMENT pour la table `QR_relation_clicli`
--
ALTER TABLE `QR_relation_clicli`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=32;
