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
| CREATE TABLE IF NOT EXISTS `t_adherents` (
`adherentId` int(5) NOT NULL auto_increment,
`adherentCivilite` tinyint(1) NOT NULL,
`adherentNom` varchar(30) character set utf8 NOT NULL,
`adherentPrenom` varchar(30) character set utf8 NOT NULL,
`adherentSaisonSaisonId` int(2) NOT NULL default '1',
`adherentTelephone` varchar(15) character set utf8 NOT NULL,
`adherentEmail` varchar(50) character set utf8 NOT NULL,
`adherentDateNaissance` date default NULL,
`adherentAdresse` varchar(50) character set utf8 NOT NULL,
`adherentCodePostal` int(6) NOT NULL,
`adherentVille` varchar(30) character set utf8 NOT NULL,
`adherentDateCertificat` date default NULL,
`adherentNotes` text character set utf8 NOT NULL,
`adherentFlag` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`adherentId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=4 ;
--
-- Contenu de la table `t_adherents`
--
INSERT INTO `t_adherents` (`adherentId`, `adherentCivilite`, `adherentNom`, `adherentPrenom`, `adherentSaisonSaisonId`, `adherentTelephone`, `adherentEmail`, `adherentDateNaissance`, `adherentAdresse`, `adherentCodePostal`, `adherentVille`, `adherentDateCertificat`, `adherentNotes`, `adherentFlag`) VALUES
(1, 1, 'Morales', 'Jackie', 1, '0140025555', 'leblaireau@jackychantal.fr', '1958-04-10', '6 avenue dausmenil', 75012, 'Paris', '2016-05-19', '', 0),
(2, 2, 'durand', 'pauline', 1, '0460015555', 'marie@live.fr', '1949-06-28', '4 Rue du 19 Mars 1962', 13000, 'Marseille', NULL, ' l''éèçù pourquoi', 0),
(3, 1, 'Dupont', 'Jojo', 2, '0256565656', 'jojo@jojo.fr', '2017-12-04', '6 Rue du finistere', 29000, 'Quimper', NULL, '', 0);
CREATE TABLE IF NOT EXISTS `t_typemarches` (
`typeMarcheId` int(2) NOT NULL auto_increment,
`typeMarcheLibelle` varchar(50) NOT NULL,
`typeMarcheEssai` tinyint(1) NOT NULL default '0',
`typeMarcheNotes` text NOT NULL,
`typeMarcheFlag` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`typeMarcheId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
--
-- Contenu de la table `t_typemarches`
--
INSERT INTO `t_typemarches` (`typeMarcheId`, `typeMarcheLibelle`, `typeMarcheEssai`, `typeMarcheNotes`, `typeMarcheFlag`) VALUES
(1, 'Marche Classique', 0, '', 0),
(2, 'Marche Nordique', 0, '', 0),
(3, 'Marche Rando Sante', 0, '', 0),
(4, 'Marche Rando Sante Essai', 1, '', 0),
(5, 'Marche Mini Rando Essai', 1, '', 0),
(6, 'Marche Super Mini Essai', 1, '', 0),
(7, 'Marche Vendredi Samedi Essai', 1, '', 0),
(8, 'Marche Nordique Essai', 1, '', 0);
CREATE TABLE IF NOT EXISTS `t_choixmarches` (
`choixMarcheId` int(5) NOT NULL auto_increment,
`choixMarcheAdherentId` int(5) NOT NULL,
`choixMarcheTypeMarcheId` int(1) NOT NULL,
`choixMarcheDate` date default NULL,
`choixMarcheFlag` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`choixMarcheId`),
KEY `fk_choixmarches_1` (`choixMarcheAdherentId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
--
-- Contenu de la table `t_choixmarches`
--
INSERT INTO `t_choixmarches` (`choixMarcheId`, `choixMarcheAdherentId`, `choixMarcheTypeMarcheId`, `choixMarcheDate`, `choixMarcheFlag`) VALUES
(1, 1, 1, '2017-12-29', 0),
(2, 1, 3, '2017-12-29', 0),
(3, 2, 2, '2017-12-29', 0),
(4, 3, 1, '2017-12-29', 0),
(5, 3, 2, '2017-12-29', 0),
(6, 3, 3, '2017-12-29', 0); |
Partager