· 7 years ago · Sep 08, 2018, 02:28 PM
1-- phpMyAdmin SQL Dump
2-- version 4.1.14
3-- http://www.phpmyadmin.net
4--
5-- Client : 127.0.0.1
6-- Généré le : Mar 07 Août 2018 à 14:58
7-- Version du serveur : 5.6.17
8-- Version de PHP : 5.5.12
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Base de données : `bellesaison`
21--
22
23
24-- --------------------------------------------------------
25
26--
27-- Structure de la table `representants`
28--
29
30CREATE TABLE IF NOT EXISTS `representants` (
31 `Numero` int(2) NOT NULL AUTO_INCREMENT,
32 `Nom` varchar(20) DEFAULT NULL,
33 `DateNaissance` date NOT NULL,
34 `Categorie` varchar(1) DEFAULT NULL,
35 `Secteur` varchar(5) DEFAULT NULL,
36 `Salaire` decimal(6,2) DEFAULT NULL,
37 `Niveau` varchar(5) DEFAULT NULL,
38 `CARealise` decimal(7,2) DEFAULT NULL,
39 `NbClients` int(2) DEFAULT NULL,
40 `NbEnfants` int(1) DEFAULT NULL,
41 `Situation` varchar(11) DEFAULT NULL,
42 PRIMARY KEY (`Numero`)
43) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=90 ;
44
45--
46-- Contenu de la table `representants`
47--
48
49INSERT INTO `representants` (`Numero`, `Nom`, `DateNaissance`, `Categorie`, `Secteur`, `Salaire`, `Niveau`, `CARealise`, `NbClients`, `NbEnfants`, `Situation`) VALUES
50(38, 'BATY Véronique', '1986-06-27', 'A', 'NORD', '1307.00', 'BAC', '42000.00', 12, 0, 'MARIE'),
51(39, 'GALAUP Jérôme', '1987-06-27', 'B', 'NORD', '1230.00', 'BAC+2', '40500.00', 11, 0, 'CELIBATAIRE'),
52(40, 'LISNARD Michel', '1979-06-29', 'A', 'NORD', '1307.00', 'BAC', '43000.00', 10, 3, 'MARIE'),
53(41, 'GARNIER Gérard', '1987-06-27', 'B', 'SUD', '1384.00', 'BAC+2', '44000.00', 10, 2, 'MARIE'),
54(42, 'KLEIN Lise', '1975-06-30', 'A', 'OUEST', '1615.00', 'BAC', '48000.00', 14, 0, 'CELIBATAIRE'),
55(43, 'JOUDOUX Josette', '1969-07-01', 'C', 'EST', '1307.00', 'BAC', '39500.00', 14, 1, 'MARIE'),
56(44, 'COLIN Claire', '1985-06-27', 'C', 'SUD', '1846.00', 'BAC', '60500.00', 10, 1, 'DIVORCE'),
57(45, 'AMAURY Jacques', '1963-07-03', 'C', 'OUEST', '2307.00', 'BAC+2', '72000.00', 12, 0, 'CELIBATAIRE'),
58(46, 'NAUDIN Jean', '1976-06-29', 'C', 'NORD', '2230.00', 'BAC', '70500.00', 14, 0, 'CELIBATAIRE'),
59(47, 'GOUMONT Victor', '1983-06-28', 'A', 'OUEST', '3307.00', 'BAC+2', '92000.00', 12, 0, 'MARIE'),
60(48, 'PLANCHAIS Muriel', '1976-06-29', 'A', 'OUEST', '2846.00', 'BAC', '85000.00', 11, 2, 'DIVORCE'),
61(49, 'YSENGRIN Daniel', '1976-06-29', 'B', 'EST', '1461.00', 'BAC+2', '45000.00', 12, 0, 'CELIBATAIRE'),
62(50, 'PORTIER Vincent', '1985-06-27', 'C', 'NORD', '1230.00', 'BAC', '41000.00', 11, 0, 'MARIE'),
63(51, 'ZIMMERMANN Patrick', '1974-06-30', 'C', 'SUD', '1307.00', 'BAC', '40500.00', 12, 1, 'MARIE'),
64(52, 'KODIA Maryse', '1987-06-27', 'C', 'OUEST', '1230.00', 'BAC+4', '39500.00', 10, 0, 'MARIE'),
65(53, 'ROUSTAND Philippe', '1961-07-03', 'B', 'EST', '1153.00', 'BAC+4', '36500.00', 14, 5, 'MARIE'),
66(54, 'GILARDI Ren', '1987-06-27', 'A', 'NORD', '1384.00', 'BAC', '42000.00', 11, 0, 'CELIBATAIRE'),
67(55, 'DANIEL Dominique', '1983-06-28', 'A', 'OUEST', '1538.00', 'BAC+2', '44000.00', 12, 1, 'DIVORCE'),
68(56, 'RIVIERE Bruno', '1976-06-29', 'B', 'SUD', '1692.00', 'BAC+4', '45500.00', 11, 0, 'MARIE'),
69(57, 'ORLANDO Sylviane', '1985-06-27', 'B', 'NORD', '1461.00', 'BAC+4', '55000.00', 12, 0, 'CELIBATAIRE'),
70(58, 'SOUBIRE Jean', '1974-06-30', 'A', 'OUEST', '1307.00', 'BAC', '45000.00', 10, 0, 'MARIE'),
71(59, 'DIENER Rémi', '1982-06-28', 'B', 'EST', '1615.00', 'BAC+2', '60000.00', 11, 1, 'MARIE'),
72(60, 'HAMOUN Marie', '1987-06-27', 'A', 'NORD', '1846.00', 'BAC', '65000.00', 10, 0, 'MARIE'),
73(61, 'HARDY Paul', '1985-06-27', 'B', 'SUD', '2307.00', 'BAC', '80000.00', 14, 0, 'CELIBATAIRE'),
74(62, 'JOUDOUX Michel', '1976-06-29', 'B', 'OUEST', '1307.00', 'BAC+2', '45000.00', 12, 2, 'MARIE'),
75(63, 'CAMARET Monique', '1969-07-01', 'B', 'SUD', '1230.00', 'BAC', '39000.00', 11, 3, 'MARIE'),
76(64, 'HAMILTON Robert', '1975-06-30', 'A', 'OUEST', '1230.00', 'BAC', '41000.00', 11, 1, 'MARIE'),
77(65, 'BIDAUX Claude', '1987-06-27', 'C', 'NORD', '1384.00', 'BAC+2', '44000.00', 10, 0, 'CELIBATAIRE'),
78(66, 'LUCAS Eric', '1983-06-28', 'A', 'EST', '1461.00', 'BAC', '46000.00', 14, 0, 'DIVORCE'),
79(67, 'RICARD Geneviève', '1962-07-03', 'C', 'SUD', '1384.00', 'BAC', '44500.00', 12, 3, 'MARIE'),
80(68, 'MICHEL Eléonore', '1983-06-28', 'B', 'EST', '1538.00', 'BAC+2', '50000.00', 12, 0, 'DIVORCE'),
81(69, 'PETIT Pierre', '1974-06-30', 'A', 'SUD', '1692.00', 'BAC', '56000.00', 14, 2, 'DIVORCE'),
82(70, 'LOUIS Estelle', '1985-06-27', 'B', 'NORD', '1846.00', 'BAC+4', '58000.00', 14, 0, 'MARIE'),
83(71, 'EBRARD Michelle', '1972-06-30', 'A', 'SUD', '2230.00', 'BAC', '65000.00', 12, 2, 'MARIE'),
84(72, 'LONGCHAMP Bernard', '1987-06-27', 'C', 'EST', '1769.00', 'BAC+4', '52000.00', 11, 0, 'MARIE'),
85(73, 'KERMADEC Marise', '1972-06-30', 'A', 'EST', '1461.00', 'BAC', '48000.00', 10, 1, 'MARIE'),
86(74, 'KERMADEC Jean-Luc', '1976-06-29', 'A', 'NORD', '1153.00', 'BAC+2', '37500.00', 13, 1, 'DIVORCE'),
87(75, 'BREMONTIER François', '1965-07-02', 'A', 'SUD', '1307.00', 'BAC', '40500.00', 11, 3, 'MARIE'),
88(76, 'DRAPRON Maurice', '1986-06-27', 'C', 'EST', '1153.00', 'BAC', '36000.00', 10, 1, 'DIVORCE'),
89(77, 'LARCHER Jo', '1983-06-28', 'C', 'NORD', '1769.00', 'BAC+2', '45000.00', 14, 2, 'MARIE'),
90(78, 'BAILLY Madeleine', '1982-06-28', 'B', 'SUD', '1384.00', 'BAC', '40500.00', 10, 2, 'MARIE'),
91(79, 'GILBERT Charles', '1977-06-29', 'A', 'OUEST', '1307.00', 'BAC', '40000.00', 13, 1, 'MARIE'),
92(80, 'SAMSON Ginette', '1980-06-28', 'B', 'OUEST', '1230.00', 'BAC+4', '41000.00', 12, 0, 'MARIE'),
93(81, 'COHEN Daniel', '1973-06-30', 'C', 'NORD', '1230.00', 'BAC', '42000.00', 11, 0, 'CELIBATAIRE'),
94(82, 'DE LACOUR Pierre', '1966-07-02', 'A', 'SUD', '1307.00', 'BAC', '40500.00', 10, 2, 'MARIE'),
95(83, 'DEHU Michelle', '1979-06-29', 'A', 'NORD', '1461.00', 'BAC', '44500.00', 10, 2, 'MARIE'),
96(84, 'LOUVET Eric', '1980-06-28', 'A', 'EST', '1615.00', 'BAC+2', '46000.00', 10, 0, 'CELIBATAIRE'),
97(85, 'YVANOFF Nicolas', '1986-06-27', 'B', 'SUD', '1692.00', 'BAC', '48000.00', 12, 1, 'MARIE'),
98(86, 'TOUAMI Amin', '1986-06-27', 'B', 'SUD', '1538.00', 'BAC+2', '42000.00', 12, 2, 'MARIE'),
99(87, 'DABOUJI Rachid', '1986-06-27', 'A', 'NORD', '1230.00', 'BAC', '43000.00', 11, 1, 'CELIBATAIRE'),
100(88, 'MADIGNIER Pascal', '1980-06-28', 'A', 'EST', '1846.00', 'BAC+2', '44000.00', 10, 2, 'MARIE'),
101(89, 'REVERET lionel', '1981-06-28', 'A', 'NORD', '2307.00', 'BAC+3', '45000.00', 11, 1, 'MARIE');
102
103/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
104/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
105/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;