Database : koursi

-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Mar 04 Mai 2010 à 15:36
-- Version du serveur: 5.1.36
-- Version de PHP: 5.3.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

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

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

--
-- Structure de la table `articles`
--

CREATE TABLE IF NOT EXISTS `articles` (
  `id` bigint(21) NOT NULL AUTO_INCREMENT,
  `Titre` varchar(50) NOT NULL,
  `chemin` varchar(60) NOT NULL,
  `date_creation` datetime NOT NULL,
  `maj` datetime DEFAULT NULL,
  `statut` varchar(10) NOT NULL,
  `idConference` bigint(21) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `Titre` (`Titre`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Contenu de la table `articles`
--

INSERT INTO `articles` (`id`, `Titre`, `chemin`, `date_creation`, `maj`, `statut`, `idConference`) VALUES
(1, 'mon premier Article', '/uploads/articles/', '2010-05-04 00:33:39', NULL, 'waitting', 2),
(2, 'article conference 1 de ramy', '/uploads/articles/', '2010-05-04 08:13:26', NULL, 'waitting', 1);

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

--
-- Structure de la table `assignationrapport`
--

CREATE TABLE IF NOT EXISTS `assignationrapport` (
  `idPersonne` bigint(21) NOT NULL,
  `idArticle` bigint(21) NOT NULL,
  `fait` varchar(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `assignationrapport`
--

INSERT INTO `assignationrapport` (`idPersonne`, `idArticle`, `fait`) VALUES
(4, 2, 'oui');

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

--
-- Structure de la table `auteur`
--

CREATE TABLE IF NOT EXISTS `auteur` (
  `idArticle` bigint(21) NOT NULL,
  `idPersonne` bigint(21) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `auteur`
--

INSERT INTO `auteur` (`idArticle`, `idPersonne`) VALUES
(2, 2),
(1, 2);

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

--
-- Structure de la table `chairs`
--

CREATE TABLE IF NOT EXISTS `chairs` (
  `id_conference` varchar(256) NOT NULL,
  `id_personne` bigint(21) NOT NULL,
  KEY `id_conference` (`id_conference`),
  KEY `id_perssone` (`id_personne`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `chairs`
--

INSERT INTO `chairs` (`id_conference`, `id_personne`) VALUES
('1', 1),
('2', 1);

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

--
-- Structure de la table `commentaire`
--

CREATE TABLE IF NOT EXISTS `commentaire` (
  `id` bigint(21) NOT NULL AUTO_INCREMENT,
  `idRapport` bigint(21) NOT NULL,
  `idPersonne` bigint(21) NOT NULL,
  `commentaire` varchar(256) NOT NULL,
  PRIMARY KEY (`id`,`idRapport`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Contenu de la table `commentaire`
--

INSERT INTO `commentaire` (`id`, `idRapport`, `idPersonne`, `commentaire`) VALUES
(1, 4, 4, 'merde'),
(2, 3, 4, 'puree'),
(3, 3, 4, 'ceci est une image'),
(4, 3, 4, 'bien');

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

--
-- Structure de la table `conference`
--

CREATE TABLE IF NOT EXISTS `conference` (
  `id` bigint(21) NOT NULL AUTO_INCREMENT,
  `nom` varchar(20) NOT NULL,
  `date_creation` date NOT NULL,
  `limite_depot` date NOT NULL,
  `limite_rendu` date NOT NULL,
  `resultats` date NOT NULL,
  `limite_modif` date NOT NULL,
  `date_envoi` date NOT NULL,
  PRIMARY KEY (`id`,`nom`),
  UNIQUE KEY `nom` (`nom`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Contenu de la table `conference`
--

INSERT INTO `conference` (`id`, `nom`, `date_creation`, `limite_depot`, `limite_rendu`, `resultats`, `limite_modif`, `date_envoi`) VALUES
(1, 'ma premiere conferen', '2010-05-03', '2010-05-06', '2010-05-20', '2010-05-21', '2010-05-25', '2010-05-31'),
(2, 'ma deuxieme conferen', '2010-05-03', '2010-05-05', '2010-05-12', '2010-05-17', '2010-05-26', '2010-05-28');

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

--
-- Structure de la table `personne`
--

CREATE TABLE IF NOT EXISTS `personne` (
  `id` bigint(21) NOT NULL AUTO_INCREMENT,
  `nom` varchar(20) NOT NULL,
  `prenom` varchar(20) NOT NULL,
  `login` varchar(20) NOT NULL,
  `password` varchar(50) CHARACTER SET utf8 NOT NULL,
  `mail` varchar(30) NOT NULL,
  `date_inscription` datetime NOT NULL,
  `photo` tinyint(1) DEFAULT NULL,
  `extension` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mail` (`mail`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Contenu de la table `personne`
--

INSERT INTO `personne` (`id`, `nom`, `prenom`, `login`, `password`, `mail`, `date_inscription`, `photo`, `extension`) VALUES
(1, 'bendris', 'amine', 'bendris.amine', 'e10adc3949ba59abbe56e057f20f883e', 'bendris.amine@gmail.com', '2010-05-03 13:56:41', 1, 'jpg'),
(2, 'boudames', 'ramy', 'hamouramix', 'e10adc3949ba59abbe56e057f20f883e', 'hamouramix@gmail.com', '2010-05-03 23:46:28', 0, ''),
(3, 'afsatou', 'toure', 'afsa', 'e10adc3949ba59abbe56e057f20f883e', 'afsa@gmail.com', '2010-05-04 00:35:47', 0, ''),
(4, 'bendris', 'hamza', 'mezzzou', 'e10adc3949ba59abbe56e057f20f883e', 'hbenriss@hotmail.com', '2010-05-04 00:36:31', 0, ''),
(5, 'messali', 'farouk', 'foufou.eni', 'e10adc3949ba59abbe56e057f20f883e', 'messali-ini@yahoo.fr', '2010-05-04 00:37:23', 0, ''),
(6, 'sarkozy', 'nicolas', 'sarko', 'e10adc3949ba59abbe56e057f20f883e', 'nicolas.one@hotmail.com', '2010-05-04 00:38:23', 0, '');

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

--
-- Structure de la table `rapport`
--

CREATE TABLE IF NOT EXISTS `rapport` (
  `id` bigint(21) NOT NULL AUTO_INCREMENT,
  `depot` datetime NOT NULL,
  `maj` datetime NOT NULL,
  `idPersone` bigint(21) NOT NULL,
  `idArticle` bigint(21) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Contenu de la table `rapport`
--

INSERT INTO `rapport` (`id`, `depot`, `maj`, `idPersone`, `idArticle`) VALUES
(3, '2010-05-04 10:26:20', '2010-05-04 10:26:20', 4, 2),
(4, '2010-05-04 10:29:01', '2010-05-04 10:29:01', 4, 2),
(5, '2010-05-04 10:30:17', '2010-05-04 10:30:17', 4, 2);

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

--
-- Structure de la table `rapporteurs`
--

CREATE TABLE IF NOT EXISTS `rapporteurs` (
  `id_conference` bigint(21) NOT NULL,
  `id_perssone` bigint(21) NOT NULL,
  KEY `id_conference` (`id_conference`),
  KEY `id_perssone` (`id_perssone`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `rapporteurs`
--

INSERT INTO `rapporteurs` (`id_conference`, `id_perssone`) VALUES
(1, 2),
(1, 3),
(1, 4),
(1, 5),
(1, 6);