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');


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=1 ;

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,
  notes blob NOT NULL,
  PRIMARY KEY (id)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;