-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Dim 15 Mai 2011 à 19:06
-- Version du serveur: 5.1.36
-- Version de PHP: 5.2.9-2

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

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

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

--
-- Structure de la table `administration`
--

CREATE TABLE IF NOT EXISTS `administration` (
  `id` tinyint(5) NOT NULL AUTO_INCREMENT,
  `identifiant` varchar(30) NOT NULL DEFAULT '',
  `password` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Contenu de la table `administration`
--

INSERT INTO `administration` (`id`, `identifiant`, `password`) VALUES
(1, 'superuser', 'azerty');

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

--
-- Structure de la table `bloc`
--

CREATE TABLE IF NOT EXISTS `bloc` (
  `id` tinyint(4) unsigned NOT NULL AUTO_INCREMENT,
  `nom_bloc` varchar(30) NOT NULL,
  `lien_projet` varchar(30) NOT NULL,
  `heure` varchar(30) NOT NULL,
  `date` varchar(30) NOT NULL,
  `date_schema` varchar(30) NOT NULL,
  `date_debut` varchar(30) NOT NULL,
  `date_plan` varchar(30) NOT NULL,
  `affectation` varchar(30) NOT NULL,
  `owner` varchar(30) NOT NULL,
  `notes` blob NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

--
-- Contenu de la table `bloc`
--

INSERT INTO `bloc` (`id`, `nom_bloc`, `lien_projet`, `heure`, `date`, `date_schema`, `date_debut`, `date_plan`, `affectation`, `owner`, `notes`) VALUES
(1, 'mlù', 'none', '12:10', '14-05-2011', '', '', ',', 'Anissa', 'superuser', 0x0909),
(2, 'tutu', 'none', '16:50', '14-05-2011', 'eed', '5', 'tyth,', 'Julien', 'superuser', 0x09096bc3b96d6c6b),
(3, 'bob', 'none', '16:59', '14-05-2011', '', '', ',', 'Anissa', 'superuser', 0x0909),
(4, 'aze', 'none', '17:02', '14-05-2011', '', '', ',', 'Anissa', 'superuser', 0x0909),
(5, 'bling', 'none', '17:44', '14-05-2011', '', '', ',', 'Anissa', 'superuser', 0x0909),
(6, '', 'none', '18:00', '14-05-2011', '', '', ',', 'Anissa', 'superuser', 0x0909),
(7, 'rfgdgdg', 'none', '18:01', '14-05-2011', '', '', ',', 'Anissa', 'superuser', 0x0909),
(8, 'coco', 'none', '18:32', '14-05-2011', '', '', ',', 'Anissa', 'superuser', 0x0909),
(9, 'balou', 'none', '18:35', '14-05-2011', '', '05/05/2011', ',', 'Anissa', 'superuser', 0x0909),
(10, 'pousin', '2', '22:22', '14-05-2011', '19/05/2011', '10/06/2011', '18,', 'Julien', 'superuser', 0x6e616461),
(11, 'aqwzsx', '1', '22:41', '14-05-2011', '', '', '', 'Anissa', 'superuser', 0x0909),
(12, 'gloupi', '', '22:52', '14-05-2011', '', '', '', 'Anissa', 'superuser', 0x0909),
(13, 'prout', '', '22:54', '14-05-2011', '', '', '', 'Anissa', 'superuser', 0x0909),
(14, 'la praline', 'BX99A', '23:10', '14-05-2011', '31/05/2011', '01/05/2011', '5464', 'Anissa', 'superuser', 0x09096269656e),
(15, 'mpg', 'BX99A', '23:29', '14-05-2011', '11-05-2011', '12-05-2011', '100', 'Anissa', 'superuser', 0x0909),
(16, 'putin', 'WW01A', '23:32', '14-05-2011', '', '', '', 'Patrice', 'superuser', 0x0909),
(17, 'gh', '', '23:33', '14-05-2011', '', '', '', 'Aurore', 'superuser', 0x0909),
(18, 'gigi', 'WW01A', '23:34', '14-05-2011', '', '', '', 'Virginie', 'superuser', 0x0909);

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

--
-- Structure de la table `projet`
--

CREATE TABLE IF NOT EXISTS `projet` (
  `id` tinyint(4) unsigned NOT NULL AUTO_INCREMENT,
  `nom_projet` varchar(30) NOT NULL,
  `famille` varchar(30) NOT NULL,
  `owner` varchar(30) NOT NULL,
  `status` varchar(30) NOT NULL,
  `heure` varchar(50) NOT NULL,
  `date` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Contenu de la table `projet`
--

INSERT INTO `projet` (`id`, `nom_projet`, `famille`, `owner`, `status`, `heure`, `date`) VALUES
(1, 'BX99A', 'Power management', 'superuser', '', '18:31', '13-05-2011'),
(2, 'WW01A', 'Audio', 'superuser', 'actif', '18:33', '13-05-2011');