-- phpMyAdmin SQL Dump
-- version 4.4.15.7
-- http://www.phpmyadmin.net
--
-- Client :  cliquedepapyclic.mysql.db
-- Généré le :  Mer 14 Septembre 2016 à 06:44
-- Version du serveur :  5.5.49-0+deb7u1-log
-- Version de PHP :  5.4.45-0+deb7u4

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 utf8mb4 */;

--
-- Base de données :  `cliquedepapyclic`
--

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

--
-- Structure de la table `cdc_gerer`
--

CREATE TABLE IF NOT EXISTS `cdc_gerer` (
  `idpers` int(11) NOT NULL COMMENT 'ID de la personne',
  `idclic` int(11) NOT NULL DEFAULT '1' COMMENT 'ID de la clique',
  `idfonc` int(11) NOT NULL COMMENT 'ID de la fonction dans la clique',
  `ddebut` date NOT NULL COMMENT 'Date de prise de fonction',
  `dfin` date NOT NULL COMMENT 'date de fin de fonction'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Table de relation : adhérents - gérer - clique';

--
-- Contenu de la table `cdc_gerer`
--

INSERT INTO `cdc_gerer` (`idpers`, `idclic`, `idfonc`, `ddebut`, `dfin`) VALUES
(14, 1, 8, '1991-09-01', '2001-08-31'),
(14, 1, 7, '1993-09-01', '1997-08-31'),
(2, 1, 7, '1993-09-01', '1997-08-31'),
(2, 1, 1, '1994-04-01', '2000-03-31'),
(14, 1, 2, '1994-04-01', '1996-03-31'),
(33, 1, 3, '1994-04-01', '1995-03-31'),
(24, 1, 4, '1994-04-01', '1995-03-31'),
(1, 1, 5, '1994-04-01', '2000-03-31'),
(30, 1, 6, '1994-04-01', '1997-03-31'),
(38, 1, 7, '1994-09-01', '2004-08-31'),
(10, 1, 3, '1995-04-01', '2001-03-31'),
(33, 1, 4, '1995-04-01', '1996-03-31'),
(23, 1, 7, '1995-09-01', '1996-08-31'),
(3, 1, 7, '1995-09-01', '1996-08-31'),
(33, 1, 2, '1996-04-01', '2003-03-31'),
(9, 1, 4, '1996-04-01', '1998-03-31'),
(7, 1, 6, '1997-04-01', '1998-03-31'),
(9, 1, 7, '1997-09-01', '1998-08-31'),
(7, 1, 7, '1997-09-01', '1998-08-31'),
(24, 1, 4, '1998-04-01', '1999-03-31'),
(145, 1, 7, '1999-09-01', '2000-08-31'),
(1, 1, 1, '2000-04-01', '2003-03-31'),
(7, 1, 5, '2000-04-01', '2003-03-31'),
(16, 1, 6, '2000-04-01', '2002-03-31'),
(2, 1, 7, '2000-09-01', '2001-08-31'),
(16, 1, 3, '2001-04-01', '2004-03-31'),
(5, 1, 4, '2001-04-01', '2003-03-31'),
(52, 1, 8, '2001-09-01', '2012-08-31'),
(65, 1, 6, '2002-04-01', '2010-03-31'),
(21, 1, 7, '2002-09-01', '2003-08-31'),
(4, 1, 7, '2002-09-01', '2003-08-31'),
(2, 1, 1, '2003-04-01', '0000-00-00'),
(13, 1, 2, '2003-04-01', '2006-03-31'),
(169, 1, 4, '2003-04-01', '2004-03-31'),
(21, 1, 5, '2003-04-01', '2014-03-31'),
(37, 1, 7, '2003-09-01', '2005-08-31'),
(169, 1, 3, '2004-04-01', '2009-03-31'),
(60, 1, 4, '2004-04-01', '2008-03-31'),
(75, 1, 7, '2004-09-01', '2005-08-31'),
(4, 1, 2, '2006-04-01', '2013-03-31'),
(170, 1, 4, '2008-04-01', '2009-03-31'),
(52, 1, 7, '2008-09-01', '0000-00-00'),
(170, 1, 3, '2009-04-01', '2011-03-31'),
(112, 1, 6, '2010-04-01', '2014-03-31'),
(146, 1, 7, '2011-09-01', '2013-08-31'),
(142, 1, 7, '2011-09-01', '2012-08-31'),
(148, 1, 7, '2012-09-01', '2013-08-31'),
(147, 1, 8, '2012-09-01', '2013-08-31'),
(124, 1, 3, '2013-04-01', '2014-03-31'),
(2, 1, 7, '2013-09-01', '2015-08-31'),
(3, 1, 7, '2013-09-01', '2015-08-31'),
(4, 1, 7, '2013-09-01', '2014-08-31'),
(160, 1, 8, '2013-09-01', '2014-08-31'),
(4, 1, 4, '2014-04-01', '2015-03-31'),
(117, 1, 5, '2014-04-01', '2016-03-31'),
(1, 1, 6, '2014-04-01', '0000-00-00'),
(164, 1, 7, '2014-09-01', '0000-00-00'),
(164, 1, 8, '2014-09-01', '0000-00-00'),
(113, 1, 3, '2015-04-01', '2016-03-31'),
(111, 1, 7, '2015-09-01', '0000-00-00'),
(117, 1, 3, '2016-04-01', '0000-00-00'),
(113, 1, 4, '2016-04-01', '0000-00-00'),
(174, 1, 5, '2016-04-01', '0000-00-00'),
(2, 1, 7, '2016-09-01', '0000-00-00'),
(4, 1, 9, '2016-09-01', '0000-00-00');

--
-- Index pour les tables exportées
--

--
-- Index pour la table `cdc_gerer`
--
ALTER TABLE `cdc_gerer`
  ADD PRIMARY KEY (`idpers`,`idclic`,`idfonc`,`ddebut`);

/*!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 */;
