-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Mar 22 Décembre 2009 à 22:48
-- Version du serveur: 5.1.37
-- Version de PHP: 5.2.10


--
-- Base de données: `cae`
--
CREATE DATABASE `cae` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `cae`;

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

--
-- Structure de la table `bookmark`
--

CREATE TABLE `bookmark` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Contenu de la table `bookmark`
--

INSERT INTO `bookmark` VALUES(1, 'Google', 'http://www.google.com');
INSERT INTO `bookmark` VALUES(2, 'Nancy 2', 'http://www.univ-nancy2.fr');
INSERT INTO `bookmark` VALUES(3, 'Free', 'http://www.free.fr');
INSERT INTO `bookmark` VALUES(4, 'Facebook', 'http://www.facebook.com');
--
-- Base de données: `cweb`
--
CREATE DATABASE `cweb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `cweb`;

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

--
-- Structure de la table `message`
--

CREATE TABLE `message` (
  `id` int(11) NOT NULL,
  `sujet` varchar(255) DEFAULT NULL,
  `contenu` varchar(255) DEFAULT NULL,
  `adr_auteur` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK38EB000723B3D1D` (`adr_auteur`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `message`
--

INSERT INTO `message` VALUES(1, 'Un super sujet', 'Et un super Contenu', 'paul@nancy.fr');
INSERT INTO `message` VALUES(2, 'Ni hao', 'Ni hao han', 'bruno@nancy.fr');
INSERT INTO `message` VALUES(3, 'Sujet 1', 'Super contenu 1', 'paul@nancy.fr');
--
-- Base de données: `cweb-examen-paul-clement`
--
CREATE DATABASE `cweb-examen-paul-clement` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `cweb-examen-paul-clement`;

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

--
-- Structure de la table `Client`
--

CREATE TABLE `Client` (
  `numClient` int(3) NOT NULL AUTO_INCREMENT,
  `nom` varchar(60) NOT NULL,
  `prenom` varchar(60) NOT NULL,
  PRIMARY KEY (`numClient`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Contenu de la table `Client`
--

INSERT INTO `Client` VALUES(1, 'CLEMENT', 'Paul');
INSERT INTO `Client` VALUES(2, 'BARNIER', 'Bruno');
INSERT INTO `Client` VALUES(3, 'PERRIN', 'Gaetan');
INSERT INTO `Client` VALUES(4, 'PAQUELIER', 'Michael');

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

--
-- Structure de la table `CompteCourant`
--

CREATE TABLE `CompteCourant` (
  `numero` varchar(255) NOT NULL,
  `intituleCompte` varchar(255) NOT NULL,
  `dernierSolde` float NOT NULL,
  `dateCreation` datetime NOT NULL,
  `dateDernierSolde` datetime NOT NULL,
  `numClient` int(3) NOT NULL,
  PRIMARY KEY (`numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `CompteCourant`
--

INSERT INTO `CompteCourant` VALUES('N0000001', 'Compte courant 1', 10000, '2009-12-08 14:47:50', '2009-12-08 14:47:54', 1);
INSERT INTO `CompteCourant` VALUES('N0000002', 'Coupte Courant 2', 500, '2009-12-08 14:48:03', '2009-12-08 14:48:06', 1);

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

--
-- Structure de la table `LivretEpargne`
--

CREATE TABLE `LivretEpargne` (
  `numero` varchar(255) NOT NULL,
  `intituleCompte` varchar(255) NOT NULL,
  `dernierSolde` float NOT NULL,
  `dateCreation` datetime NOT NULL,
  `dateDernierSolde` datetime NOT NULL,
  `taux` float NOT NULL,
  `numClient` int(3) NOT NULL,
  PRIMARY KEY (`numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `LivretEpargne`
--

INSERT INTO `LivretEpargne` VALUES('S000003', 'Livret Epargne 1', 666666, '2009-12-07 14:50:33', '2009-12-07 14:50:38', 0.04, 1);
INSERT INTO `LivretEpargne` VALUES('S000004', 'Livret Epargne 2\r\n', 150, '2007-12-28 14:50:54', '2009-12-02 14:51:02', 0.01, 1);

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

--
-- Structure de la table `Mouvement`
--

CREATE TABLE `Mouvement` (
  `numMouvement` int(3) NOT NULL AUTO_INCREMENT,
  `libelleMouvement` varchar(255) NOT NULL,
  `montant` float NOT NULL,
  `dateMouv` datetime NOT NULL,
  `dateValeur` datetime NOT NULL,
  `numero` varchar(255) NOT NULL,
  PRIMARY KEY (`numMouvement`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Contenu de la table `Mouvement`
--

INSERT INTO `Mouvement` VALUES(1, 'ASNL - Bordeaux', 12, '2009-11-29 14:41:38', '2009-11-29 14:41:54', 'N0000001');
INSERT INTO `Mouvement` VALUES(2, 'CB Jules', 80, '2009-12-08 14:42:15', '2009-12-08 14:42:20', 'N0000001');
INSERT INTO `Mouvement` VALUES(3, 'CB Restaurant Le paradizio', 60, '2009-12-05 14:42:45', '2009-12-06 14:42:51', 'S000003');
INSERT INTO `Mouvement` VALUES(4, 'CB Kinépolis', 19, '2009-12-07 14:43:10', '2009-12-07 14:43:14', 'S000003');
--
-- Base de données: `cweb-seam`
--
CREATE DATABASE `cweb-seam` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `cweb-seam`;
--
-- Base de données: `evaluation`
--
CREATE DATABASE `evaluation` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `evaluation`;

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

--
-- Structure de la table `avis`
--

CREATE TABLE `avis` (
  `identifiant_avis` bigint(20) NOT NULL AUTO_INCREMENT,
  `identifiant_utilisateur_avis` bigint(20) NOT NULL,
  `identifiant_page_avis` bigint(20) NOT NULL,
  `valeur_avis` int(11) NOT NULL,
  PRIMARY KEY (`identifiant_avis`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Contenu de la table `avis`
--

INSERT INTO `avis` VALUES(1, 2, 1, 20);
INSERT INTO `avis` VALUES(2, 2, 1, 18);
INSERT INTO `avis` VALUES(3, 2, 1, 1);
INSERT INTO `avis` VALUES(4, 2, 1, 10);
INSERT INTO `avis` VALUES(5, 2, 1, 10);

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

--
-- Structure de la table `matiere`
--

CREATE TABLE `matiere` (
  `identifiant_matiere` bigint(20) NOT NULL AUTO_INCREMENT,
  `libelle_matiere` varchar(30) NOT NULL,
  PRIMARY KEY (`identifiant_matiere`),
  UNIQUE KEY `libelle_matiere` (`libelle_matiere`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

--
-- Contenu de la table `matiere`
--

INSERT INTO `matiere` VALUES(1, 'APPLICATIONS DISTRIBUEES');
INSERT INTO `matiere` VALUES(2, 'SECURITE');
INSERT INTO `matiere` VALUES(3, 'SERVICES');
INSERT INTO `matiere` VALUES(4, 'EJB3.0');
INSERT INTO `matiere` VALUES(5, 'MULTIMEDIA');
INSERT INTO `matiere` VALUES(6, 'CONCEPTION WEB');
INSERT INTO `matiere` VALUES(7, 'PATRONS');
INSERT INTO `matiere` VALUES(8, 'MANAGEMENT');
INSERT INTO `matiere` VALUES(9, 'GESTION D''ERREURS');
INSERT INTO `matiere` VALUES(10, 'ANGLAIS');
INSERT INTO `matiere` VALUES(11, 'AGENTS');
INSERT INTO `matiere` VALUES(12, 'FOUILLES DE DONNEES');
INSERT INTO `matiere` VALUES(13, 'SPRING');

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

--
-- Structure de la table `note`
--

CREATE TABLE `note` (
  `identifiant_note` bigint(20) NOT NULL AUTO_INCREMENT,
  `identifiant_utilisateur_note` bigint(20) NOT NULL,
  `identifiant_matiere_note` bigint(20) NOT NULL,
  `valeur_note` int(2) NOT NULL,
  PRIMARY KEY (`identifiant_note`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ;

--
-- Contenu de la table `note`
--

INSERT INTO `note` VALUES(1, 1, 1, 20);
INSERT INTO `note` VALUES(2, 1, 2, 15);
INSERT INTO `note` VALUES(3, 1, 3, 20);
INSERT INTO `note` VALUES(4, 1, 4, 18);
INSERT INTO `note` VALUES(5, 1, 5, 17);
INSERT INTO `note` VALUES(6, 1, 6, 15);
INSERT INTO `note` VALUES(7, 1, 7, 19);
INSERT INTO `note` VALUES(8, 1, 8, 12);
INSERT INTO `note` VALUES(9, 1, 9, 9);
INSERT INTO `note` VALUES(10, 1, 10, 10);
INSERT INTO `note` VALUES(11, 1, 11, 14);
INSERT INTO `note` VALUES(12, 1, 12, 13);
INSERT INTO `note` VALUES(13, 1, 13, 20);
INSERT INTO `note` VALUES(14, 2, 1, 13);
INSERT INTO `note` VALUES(15, 2, 2, 14);
INSERT INTO `note` VALUES(16, 2, 3, 20);
INSERT INTO `note` VALUES(17, 2, 4, 11);
INSERT INTO `note` VALUES(18, 2, 5, 10);
INSERT INTO `note` VALUES(19, 2, 6, 18);
INSERT INTO `note` VALUES(20, 2, 7, 7);
INSERT INTO `note` VALUES(21, 2, 8, 14);
INSERT INTO `note` VALUES(22, 2, 9, 16);
INSERT INTO `note` VALUES(23, 2, 10, 17);
INSERT INTO `note` VALUES(24, 2, 11, 18);
INSERT INTO `note` VALUES(25, 2, 12, 11);
INSERT INTO `note` VALUES(26, 2, 13, 15);
INSERT INTO `note` VALUES(27, 3, 1, 20);
INSERT INTO `note` VALUES(28, 3, 2, 20);
INSERT INTO `note` VALUES(29, 3, 3, 20);
INSERT INTO `note` VALUES(30, 3, 4, 20);
INSERT INTO `note` VALUES(31, 3, 5, 20);
INSERT INTO `note` VALUES(32, 3, 6, 20);
INSERT INTO `note` VALUES(33, 3, 7, 20);
INSERT INTO `note` VALUES(34, 3, 8, 0);
INSERT INTO `note` VALUES(35, 3, 9, 20);
INSERT INTO `note` VALUES(36, 3, 10, 1);
INSERT INTO `note` VALUES(37, 3, 11, 2);
INSERT INTO `note` VALUES(38, 3, 12, 20);
INSERT INTO `note` VALUES(39, 3, 13, 20);

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

--
-- Structure de la table `page`
--

CREATE TABLE `page` (
  `identifiant_url` bigint(20) NOT NULL AUTO_INCREMENT,
  `adresse_url` varchar(255) NOT NULL,
  `nom_fichier_url` varchar(30) NOT NULL,
  PRIMARY KEY (`identifiant_url`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Contenu de la table `page`
--

INSERT INTO `page` VALUES(1, '/pages/', 'page1.jsp');
INSERT INTO `page` VALUES(2, '/pages/', 'page2.jsp');
INSERT INTO `page` VALUES(3, '/pages/', 'page3.jsp');
INSERT INTO `page` VALUES(4, '/pages/', 'page4.jsp');
--
-- Base de données: `ipom`
--
CREATE DATABASE `ipom` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `ipom`;

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

--
-- Structure de la table `codd_disponibilites`
--

CREATE TABLE `codd_disponibilites` (
  `dispo_id` int(9) NOT NULL AUTO_INCREMENT,
  `dispo_date` varchar(8) NOT NULL,
  `dispo_heuredeb` time DEFAULT NULL,
  `dispo_heurefin` time DEFAULT NULL,
  `dispo_ok` tinyint(1) NOT NULL,
  `dispo_joueur` int(9) NOT NULL,
  `dispo_commentaire` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`dispo_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=257 ;

--
-- Contenu de la table `codd_disponibilites`
--

INSERT INTO `codd_disponibilites` VALUES(3, '14072009', '00:00:00', '00:00:00', 0, 1, 'feu d''artifice');
INSERT INTO `codd_disponibilites` VALUES(2, '15072009', '21:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(52, '17072009', '21:00:00', '00:00:00', 1, 4, 'wow (HM) ou cod ! hmm :x');
INSERT INTO `codd_disponibilites` VALUES(51, '01082009', '00:00:00', '00:00:00', 0, 1, '');
INSERT INTO `codd_disponibilites` VALUES(182, '31072009', '21:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(169, '28072009', '21:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(164, '29072009', '21:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(165, '30072009', '21:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(45, '15072009', '00:00:00', '00:00:00', 0, 4, '');
INSERT INTO `codd_disponibilites` VALUES(44, '14072009', '21:00:00', '00:00:00', 1, 4, 'avec variante quoi !\r\n');
INSERT INTO `codd_disponibilites` VALUES(26, '16072009', '20:00:00', '00:00:00', 1, 3, '');
INSERT INTO `codd_disponibilites` VALUES(25, '15072009', '20:30:00', '00:00:00', 1, 3, '');
INSERT INTO `codd_disponibilites` VALUES(71, '15072009', '00:00:00', '00:00:00', 1, 7, 'a patir de 00h00');
INSERT INTO `codd_disponibilites` VALUES(24, '14072009', '21:00:00', '00:00:00', 1, 3, '');
INSERT INTO `codd_disponibilites` VALUES(68, '16072009', '00:00:00', '00:00:00', 0, 7, '');
INSERT INTO `codd_disponibilites` VALUES(27, '17072009', '20:30:00', '00:00:00', 1, 3, '');
INSERT INTO `codd_disponibilites` VALUES(28, '16072009', '20:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(29, '17072009', '20:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(30, '18072009', '00:00:00', '00:00:00', 0, 1, 'barbecue time');
INSERT INTO `codd_disponibilites` VALUES(33, '19072009', '20:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(134, '20072009', '21:00:00', '00:00:00', 1, 1, 'Je bouffe avec un pote, je sais pas trop quand je rentre. Pas trop tard j\\''imagine ...');
INSERT INTO `codd_disponibilites` VALUES(35, '21072009', '20:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(36, '22072009', '20:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(37, '23072009', '20:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(160, '24072009', '21:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(161, '25072009', '21:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(156, '26072009', '00:00:00', '00:00:00', 0, 1, '');
INSERT INTO `codd_disponibilites` VALUES(41, '15072009', '21:00:00', '00:00:00', 1, 5, ':)');
INSERT INTO `codd_disponibilites` VALUES(163, '27072009', '21:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(54, '05082009', '00:00:00', '00:00:00', 0, 1, 'vacances jusqu\\''au 15');
INSERT INTO `codd_disponibilites` VALUES(55, '06082009', '00:00:00', '00:00:00', 0, 1, 'vacances jusqu\\''au 15');
INSERT INTO `codd_disponibilites` VALUES(56, '07082009', '00:00:00', '00:00:00', 0, 1, 'vacances jusqu\\''au 15');
INSERT INTO `codd_disponibilites` VALUES(57, '08082009', '00:00:00', '00:00:00', 0, 1, 'vacances jusqu\\''au 15');
INSERT INTO `codd_disponibilites` VALUES(58, '09082009', '00:00:00', '00:00:00', 0, 1, 'vacances jusqu\\''au 15');
INSERT INTO `codd_disponibilites` VALUES(59, '10082009', '00:00:00', '00:00:00', 0, 1, 'vacances jusqu\\''au 15');
INSERT INTO `codd_disponibilites` VALUES(60, '11082009', '00:00:00', '00:00:00', 0, 1, 'vacances jusqu\\''au 15');
INSERT INTO `codd_disponibilites` VALUES(61, '12082009', '00:00:00', '00:00:00', 0, 1, 'vacances jusqu\\''au 15');
INSERT INTO `codd_disponibilites` VALUES(62, '13082009', '00:00:00', '00:00:00', 0, 1, 'vacances jusqu\\''au 15');
INSERT INTO `codd_disponibilites` VALUES(63, '14082009', '00:00:00', '00:00:00', 0, 1, 'vacances jusqu\\''au 15');
INSERT INTO `codd_disponibilites` VALUES(64, '15082009', '00:00:00', '00:00:00', 0, 1, 'vacances jusqu\\''au 15');
INSERT INTO `codd_disponibilites` VALUES(74, '03082009', '00:00:00', '00:00:00', 0, 1, 'vacances');
INSERT INTO `codd_disponibilites` VALUES(75, '04082009', '00:00:00', '00:00:00', 0, 1, 'vacances');
INSERT INTO `codd_disponibilites` VALUES(70, '18072009', '00:00:00', '00:00:00', 0, 7, '');
INSERT INTO `codd_disponibilites` VALUES(73, '02082009', '00:00:00', '00:00:00', 0, 1, 'vacances');
INSERT INTO `codd_disponibilites` VALUES(76, '17072009', '20:00:00', '00:00:00', 1, 6, '');
INSERT INTO `codd_disponibilites` VALUES(77, '17072009', '20:45:00', '00:00:00', 1, 5, 'Soir&eacute;e en mod g33K');
INSERT INTO `codd_disponibilites` VALUES(78, '16072009', '00:00:00', '00:00:00', 0, 5, 'Cinoch a priori');
INSERT INTO `codd_disponibilites` VALUES(79, '20072009', '21:00:00', '22:30:00', 1, 5, '');
INSERT INTO `codd_disponibilites` VALUES(80, '18072009', '00:00:00', '00:00:00', 0, 4, 'parce que');
INSERT INTO `codd_disponibilites` VALUES(91, '19072009', '20:00:00', '00:00:00', 1, 4, 'bah ouais !');
INSERT INTO `codd_disponibilites` VALUES(82, '20072009', '00:00:00', '00:00:00', 0, 4, '');
INSERT INTO `codd_disponibilites` VALUES(83, '21072009', '21:00:00', '00:00:00', 1, 4, '');
INSERT INTO `codd_disponibilites` VALUES(105, '19072009', '20:30:00', '00:00:00', 1, 3, '');
INSERT INTO `codd_disponibilites` VALUES(89, '16072009', '20:00:00', '23:00:00', 1, 4, 'Sorties aux Tardives apr&egrave;s.');
INSERT INTO `codd_disponibilites` VALUES(92, '22072009', '00:00:00', '00:00:00', 0, 4, '');
INSERT INTO `codd_disponibilites` VALUES(93, '23072009', '20:00:00', '00:00:00', 1, 4, '');
INSERT INTO `codd_disponibilites` VALUES(94, '24072009', '20:00:00', '00:00:00', 1, 4, '');
INSERT INTO `codd_disponibilites` VALUES(95, '26072009', '20:00:00', '00:00:00', 1, 4, '');
INSERT INTO `codd_disponibilites` VALUES(96, '25072009', '00:00:00', '00:00:00', 0, 4, 'because !');
INSERT INTO `codd_disponibilites` VALUES(97, '27072009', '00:00:00', '00:00:00', 0, 4, 'gnii');
INSERT INTO `codd_disponibilites` VALUES(98, '28072009', '20:00:00', '00:00:00', 1, 4, '');
INSERT INTO `codd_disponibilites` VALUES(99, '29072009', '00:00:00', '00:00:00', 0, 4, 'prout !');
INSERT INTO `codd_disponibilites` VALUES(174, '30072009', '00:00:00', '00:00:00', 0, 4, '');
INSERT INTO `codd_disponibilites` VALUES(102, '31072009', '00:00:00', '00:00:00', 0, 4, 'Je monte a Paris !');
INSERT INTO `codd_disponibilites` VALUES(103, '01082009', '00:00:00', '00:00:00', 0, 4, 'Je suis &agrave; Paris !');
INSERT INTO `codd_disponibilites` VALUES(104, '02082009', '00:00:00', '00:00:00', 0, 4, 'Je reviens de Paris !');
INSERT INTO `codd_disponibilites` VALUES(106, '20072009', '20:30:00', '00:00:00', 1, 3, '');
INSERT INTO `codd_disponibilites` VALUES(107, '21072009', '20:30:00', '00:00:00', 1, 3, '');
INSERT INTO `codd_disponibilites` VALUES(110, '17072009', '20:00:00', '00:00:00', 1, 7, 'up ! ');
INSERT INTO `codd_disponibilites` VALUES(111, '22072009', '21:00:00', '00:00:00', 1, 3, '');
INSERT INTO `codd_disponibilites` VALUES(112, '24072009', '21:00:00', '00:00:00', 1, 3, '');
INSERT INTO `codd_disponibilites` VALUES(113, '23072009', '21:00:00', '00:00:00', 1, 3, '');
INSERT INTO `codd_disponibilites` VALUES(120, '21072009', '00:00:00', '00:00:00', 0, 5, 'anniv de la miss');
INSERT INTO `codd_disponibilites` VALUES(121, '26072009', '00:00:00', '00:00:00', 0, 5, 'barbeuc');
INSERT INTO `codd_disponibilites` VALUES(115, '22072009', '21:00:00', '00:00:00', 1, 5, '');
INSERT INTO `codd_disponibilites` VALUES(116, '23072009', '21:00:00', '00:00:00', 1, 5, '');
INSERT INTO `codd_disponibilites` VALUES(151, '24072009', '00:00:00', '00:00:00', 0, 5, '');
INSERT INTO `codd_disponibilites` VALUES(122, '25072009', '21:00:00', '00:00:00', 1, 5, 'pas de sous pas de soir&eacute;e');
INSERT INTO `codd_disponibilites` VALUES(123, '01082009', '00:00:00', '00:00:00', 0, 5, 'Biarritzzzzzzz');
INSERT INTO `codd_disponibilites` VALUES(124, '02082009', '00:00:00', '00:00:00', 0, 5, 'Biarritzzzzzzz');
INSERT INTO `codd_disponibilites` VALUES(125, '03082009', '00:00:00', '00:00:00', 0, 5, 'Biarritzzzzzzz');
INSERT INTO `codd_disponibilites` VALUES(126, '04082009', '00:00:00', '00:00:00', 0, 5, 'Biarritzzzzzzz');
INSERT INTO `codd_disponibilites` VALUES(127, '05082009', '00:00:00', '00:00:00', 0, 5, 'Biarritzzzzzzz');
INSERT INTO `codd_disponibilites` VALUES(128, '06082009', '00:00:00', '00:00:00', 0, 5, 'Biarritzzzzzzz');
INSERT INTO `codd_disponibilites` VALUES(129, '07082009', '00:00:00', '00:00:00', 0, 5, 'Biarritzzzzzzz');
INSERT INTO `codd_disponibilites` VALUES(130, '08082009', '00:00:00', '00:00:00', 0, 5, 'Biarritzzzzzzz');
INSERT INTO `codd_disponibilites` VALUES(132, '09082009', '21:00:00', '00:00:00', 1, 5, 'En mod G33K pour le retour de la plage ;)');
INSERT INTO `codd_disponibilites` VALUES(135, '29082009', '00:00:00', '00:00:00', 0, 1, 'vac =&gt; 13 septembre');
INSERT INTO `codd_disponibilites` VALUES(136, '30082009', '00:00:00', '00:00:00', 0, 1, 'vac =&gt; 13 septembre');
INSERT INTO `codd_disponibilites` VALUES(137, '31082009', '00:00:00', '00:00:00', 0, 1, 'vac =&gt; 13 septembre');
INSERT INTO `codd_disponibilites` VALUES(138, '01092009', '00:00:00', '00:00:00', 0, 1, 'vac =&gt; 13 septembre');
INSERT INTO `codd_disponibilites` VALUES(139, '02092009', '00:00:00', '00:00:00', 0, 1, 'vac =&gt; 13 septembre');
INSERT INTO `codd_disponibilites` VALUES(140, '03092009', '00:00:00', '00:00:00', 0, 1, 'vac =&gt; 13 septembre');
INSERT INTO `codd_disponibilites` VALUES(141, '04092009', '00:00:00', '00:00:00', 0, 1, 'vac =&gt; 13 septembre');
INSERT INTO `codd_disponibilites` VALUES(142, '05092009', '00:00:00', '00:00:00', 0, 1, 'vac =&gt; 13 septembre');
INSERT INTO `codd_disponibilites` VALUES(143, '06092009', '00:00:00', '00:00:00', 0, 1, 'vac =&gt; 13 septembre');
INSERT INTO `codd_disponibilites` VALUES(144, '07092009', '00:00:00', '00:00:00', 0, 1, 'vac =&gt; 13 septembre');
INSERT INTO `codd_disponibilites` VALUES(145, '08092009', '00:00:00', '00:00:00', 0, 1, 'vac =&gt; 13 septembre');
INSERT INTO `codd_disponibilites` VALUES(146, '09092009', '00:00:00', '00:00:00', 0, 1, 'vac =&gt; 13 septembre');
INSERT INTO `codd_disponibilites` VALUES(147, '10092009', '00:00:00', '00:00:00', 0, 1, 'vac =&gt; 13 septembre');
INSERT INTO `codd_disponibilites` VALUES(148, '11092009', '00:00:00', '00:00:00', 0, 1, 'vac =&gt; 13 septembre');
INSERT INTO `codd_disponibilites` VALUES(149, '12092009', '00:00:00', '00:00:00', 0, 1, 'vac =&gt; 13 septembre');
INSERT INTO `codd_disponibilites` VALUES(150, '22072009', '20:00:00', '23:30:00', 1, 6, '');
INSERT INTO `codd_disponibilites` VALUES(152, '28072009', '21:00:00', '00:00:00', 1, 5, '');
INSERT INTO `codd_disponibilites` VALUES(153, '27072009', '21:00:00', '00:00:00', 1, 5, '');
INSERT INTO `codd_disponibilites` VALUES(154, '23072009', '20:00:00', '00:00:00', 1, 6, '');
INSERT INTO `codd_disponibilites` VALUES(162, '26072009', '21:00:00', '00:00:00', 1, 6, '');
INSERT INTO `codd_disponibilites` VALUES(168, '27072009', '21:00:00', '23:30:00', 1, 6, '');
INSERT INTO `codd_disponibilites` VALUES(170, '28072009', '21:00:00', '00:00:00', 1, 3, '');
INSERT INTO `codd_disponibilites` VALUES(171, '29072009', '20:30:00', '00:00:00', 1, 3, '');
INSERT INTO `codd_disponibilites` VALUES(172, '30072009', '20:30:00', '00:00:00', 1, 3, '');
INSERT INTO `codd_disponibilites` VALUES(173, '28072009', '21:00:00', '00:00:00', 1, 6, '');
INSERT INTO `codd_disponibilites` VALUES(175, '03082009', '00:00:00', '00:00:00', 0, 4, '');
INSERT INTO `codd_disponibilites` VALUES(176, '04082009', '00:00:00', '00:00:00', 0, 4, '');
INSERT INTO `codd_disponibilites` VALUES(177, '29072009', '21:00:00', '00:00:00', 1, 6, '');
INSERT INTO `codd_disponibilites` VALUES(178, '30072009', '21:00:00', '00:00:00', 1, 6, '');
INSERT INTO `codd_disponibilites` VALUES(181, '31072009', '21:00:00', '22:30:00', 1, 6, 'un peu mort, donc je verrais ce soir');
INSERT INTO `codd_disponibilites` VALUES(183, '12082009', '21:00:00', '00:00:00', 1, 6, '');
INSERT INTO `codd_disponibilites` VALUES(184, '16082009', '21:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(185, '17082009', '21:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(198, '18082009', '00:00:00', '00:00:00', 0, 1, 'resto');
INSERT INTO `codd_disponibilites` VALUES(187, '19082009', '21:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(188, '20082009', '21:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(189, '21082009', '21:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(190, '24082009', '21:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(191, '25082009', '21:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(192, '26082009', '21:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(202, '27082009', '00:00:00', '00:00:00', 0, 1, '');
INSERT INTO `codd_disponibilites` VALUES(194, '28082009', '21:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(195, '14082009', '21:00:00', '00:00:00', 1, 6, '');
INSERT INTO `codd_disponibilites` VALUES(196, '16082009', '21:00:00', '00:00:00', 1, 6, '');
INSERT INTO `codd_disponibilites` VALUES(197, '17082009', '21:00:00', '00:00:00', 1, 6, '');
INSERT INTO `codd_disponibilites` VALUES(199, '18082009', '21:00:00', '00:00:00', 1, 6, '');
INSERT INTO `codd_disponibilites` VALUES(200, '19082009', '21:00:00', '00:00:00', 1, 6, '');
INSERT INTO `codd_disponibilites` VALUES(201, '23082009', '21:00:00', '22:45:00', 1, 6, '');
INSERT INTO `codd_disponibilites` VALUES(203, '13092009', '21:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(204, '14092009', '21:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(226, '15092009', '00:00:00', '00:00:00', 0, 1, 'foot');
INSERT INTO `codd_disponibilites` VALUES(206, '16092009', '00:00:00', '00:00:00', 0, 1, '');
INSERT INTO `codd_disponibilites` VALUES(207, '11092009', '21:00:00', '00:00:00', 1, 7, '');
INSERT INTO `codd_disponibilites` VALUES(208, '12092009', '21:00:00', '00:00:00', 1, 7, '');
INSERT INTO `codd_disponibilites` VALUES(209, '13092009', '21:00:00', '00:00:00', 1, 3, '');
INSERT INTO `codd_disponibilites` VALUES(210, '14092009', '21:00:00', '00:00:00', 1, 3, '');
INSERT INTO `codd_disponibilites` VALUES(212, '12092009', '21:00:00', '00:00:00', 1, 7, '');
INSERT INTO `codd_disponibilites` VALUES(227, '15092009', '00:00:00', '00:00:00', 0, 3, 'foot, dispo apr&egrave;s au cas ou il y est du monde');
INSERT INTO `codd_disponibilites` VALUES(214, '12092009', '21:00:00', '00:00:00', 1, 3, '');
INSERT INTO `codd_disponibilites` VALUES(215, '12092009', '00:00:00', '00:00:00', 1, 7, '');
INSERT INTO `codd_disponibilites` VALUES(224, '15092009', '00:00:00', '00:00:00', 0, 7, 'sortie exceptionnelle &eacute;tudiante ;) ');
INSERT INTO `codd_disponibilites` VALUES(217, '14092009', '21:00:00', '00:00:00', 1, 7, '');
INSERT INTO `codd_disponibilites` VALUES(218, '13092009', '21:00:00', '00:00:00', 1, 7, '');
INSERT INTO `codd_disponibilites` VALUES(219, '14092009', '21:00:00', '00:00:00', 1, 5, '');
INSERT INTO `codd_disponibilites` VALUES(220, '15092009', '21:00:00', '00:00:00', 1, 5, '');
INSERT INTO `codd_disponibilites` VALUES(221, '16092009', '21:00:00', '00:00:00', 1, 5, '');
INSERT INTO `codd_disponibilites` VALUES(222, '17092009', '21:00:00', '00:00:00', 1, 5, '');
INSERT INTO `codd_disponibilites` VALUES(223, '18092009', '21:00:00', '00:00:00', 1, 5, '');
INSERT INTO `codd_disponibilites` VALUES(225, '12092009', '00:00:00', '00:00:00', 1, 7, '');
INSERT INTO `codd_disponibilites` VALUES(228, '16092009', '21:00:00', '00:00:00', 1, 3, '');
INSERT INTO `codd_disponibilites` VALUES(229, '12092009', '00:00:00', '00:00:00', 1, 7, '');
INSERT INTO `codd_disponibilites` VALUES(230, '16092009', '00:00:00', '00:00:00', 0, 7, '');
INSERT INTO `codd_disponibilites` VALUES(231, '17092009', '00:00:00', '00:00:00', 0, 7, '');
INSERT INTO `codd_disponibilites` VALUES(232, '18092009', '21:00:00', '00:00:00', 1, 7, '');
INSERT INTO `codd_disponibilites` VALUES(233, '19092009', '21:00:00', '00:00:00', 1, 7, '');
INSERT INTO `codd_disponibilites` VALUES(234, '18092009', '21:00:00', '00:00:00', 1, 3, '');
INSERT INTO `codd_disponibilites` VALUES(235, '17092009', '21:00:00', '00:00:00', 1, 3, '');
INSERT INTO `codd_disponibilites` VALUES(236, '12092009', '00:00:00', '00:00:00', 1, 7, '');
INSERT INTO `codd_disponibilites` VALUES(237, '12092009', '00:00:00', '00:00:00', 1, 7, '');
INSERT INTO `codd_disponibilites` VALUES(238, '12092009', '00:00:00', '00:00:00', 1, 7, '');
INSERT INTO `codd_disponibilites` VALUES(239, '12092009', '00:00:00', '00:00:00', 1, 7, '');
INSERT INTO `codd_disponibilites` VALUES(240, '20092009', '00:00:00', '00:00:00', 0, 7, '');
INSERT INTO `codd_disponibilites` VALUES(241, '19092009', '00:00:00', '00:00:00', 0, 1, '');
INSERT INTO `codd_disponibilites` VALUES(242, '20092009', '21:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(243, '22092009', '00:00:00', '00:00:00', 0, 1, 'rentre de la salsa a 21h30');
INSERT INTO `codd_disponibilites` VALUES(244, '23092009', '00:00:00', '00:00:00', 0, 1, 'Nancy - Monaco');
INSERT INTO `codd_disponibilites` VALUES(245, '24092009', '00:00:00', '00:00:00', 0, 1, 'soir&eacute;e d\\''int&eacute;gration');
INSERT INTO `codd_disponibilites` VALUES(246, '25092009', '21:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(247, '21092009', '21:00:00', '00:00:00', 1, 1, '');
INSERT INTO `codd_disponibilites` VALUES(248, '18092009', '00:00:00', '00:00:00', 0, 1, '');
INSERT INTO `codd_disponibilites` VALUES(249, '17092009', '00:00:00', '00:00:00', 0, 1, '');
INSERT INTO `codd_disponibilites` VALUES(250, '26092009', '00:00:00', '00:00:00', 0, 1, '');
INSERT INTO `codd_disponibilites` VALUES(251, '03102009', '00:00:00', '00:00:00', 0, 1, 'oktoberfest');
INSERT INTO `codd_disponibilites` VALUES(252, '04102009', '00:00:00', '00:00:00', 0, 1, 'oktoberfest');
INSERT INTO `codd_disponibilites` VALUES(256, '27092009', '21:00:00', '00:00:00', 1, 1, '');
--
-- Base de données: `services`
--
CREATE DATABASE `services` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `services`;
--
-- Base de données: `site`
--
CREATE DATABASE `site` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `site`;

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

--
-- Structure de la table `Groupe`
--

CREATE TABLE `Groupe` (
  `id_groupe` int(9) NOT NULL AUTO_INCREMENT,
  `nom_groupe` varchar(255) NOT NULL,
  `date_creation_groupe` date NOT NULL,
  PRIMARY KEY (`id_groupe`),
  UNIQUE KEY `id_groupe` (`id_groupe`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;

--
-- Contenu de la table `Groupe`
--

INSERT INTO `Groupe` VALUES(1, 'Groupe 1', '2009-11-29');
INSERT INTO `Groupe` VALUES(2, 'Groupe 2', '2009-11-30');
INSERT INTO `Groupe` VALUES(3, 'Groupe 3', '2009-12-03');

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

--
-- Structure de la table `Probleme`
--

CREATE TABLE `Probleme` (
  `id_probleme` int(9) NOT NULL AUTO_INCREMENT,
  `titre_probleme` varchar(255) NOT NULL,
  `description_probleme` varchar(255) NOT NULL,
  `date_creation_probleme` date NOT NULL,
  `date_butoir_probleme` date NOT NULL,
  `etat_probleme` varchar(255) NOT NULL,
  `id_groupe` int(9) NOT NULL,
  PRIMARY KEY (`id_probleme`),
  UNIQUE KEY `id_probleme` (`id_probleme`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Contenu de la table `Probleme`
--

INSERT INTO `Probleme` VALUES(1, 'Probleme 1', 'Description P1', '2009-11-30', '2010-05-10', 'en cours', 1);
INSERT INTO `Probleme` VALUES(2, 'Probleme 2', 'Description P2', '2009-11-20', '2010-05-01', 'terminé', 1);
INSERT INTO `Probleme` VALUES(4, 'qsdqsd', 'qsd', '0000-00-00', '2029-03-01', 'en cours', 2);
INSERT INTO `Probleme` VALUES(5, 'qsdqsd', 'qsd', '0000-00-00', '2029-03-01', 'en cours', 2);
INSERT INTO `Probleme` VALUES(6, 'Probleme test', 'hohoho', '0000-00-00', '2029-01-01', 'en cours', 2);
INSERT INTO `Probleme` VALUES(7, 'Probleme test2', 'hohoho', '2009-11-30', '2029-01-01', 'en cours', 2);
INSERT INTO `Probleme` VALUES(8, 'Probleme test2', 'hohoho', '2009-11-30', '2029-01-01', 'en cours', 2);
INSERT INTO `Probleme` VALUES(9, 'qsdqsd', 'sqdqsdqd', '2009-11-30', '2027-05-01', 'en cours', 0);
INSERT INTO `Probleme` VALUES(10, 'azeaqsdqsd', 'azesfghg', '2009-11-30', '2026-04-01', 'en cours', 1);
INSERT INTO `Probleme` VALUES(11, 'HIHI', 'HOHO', '2009-12-05', '2011-03-17', 'en cours', 2);

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

--
-- Structure de la table `appartient_groupe`
--

CREATE TABLE `appartient_groupe` (
  `id_groupe` int(9) NOT NULL,
  `id_interpretant` int(9) NOT NULL,
  PRIMARY KEY (`id_groupe`,`id_interpretant`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `appartient_groupe`
--

INSERT INTO `appartient_groupe` VALUES(1, 1);
INSERT INTO `appartient_groupe` VALUES(1, 23);
INSERT INTO `appartient_groupe` VALUES(1, 25);
INSERT INTO `appartient_groupe` VALUES(2, 1);
INSERT INTO `appartient_groupe` VALUES(3, 26);
