# phpMyAdmin MySQL-Dump
# version 2.4.0
# http://www.phpmyadmin.net/ (download page)
#
# Serveur: localhost
# Gnr le : Mercredi 30 Juillet 2003  22:33
# Version du serveur: 4.0.11
# Version de PHP: 4.3.1
# Base de donnes: `epnadmin`
# --------------------------------------------------------

#
# Structure de la table `animateurs`
#

DROP TABLE IF EXISTS `animateurs`;
CREATE TABLE `animateurs` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `nom` varchar(30) NOT NULL default '',
  `prenom` varchar(30) NOT NULL default '',
  `login` varchar(30) NOT NULL default '',
  `motdepasse` varchar(32) NOT NULL default '',
  `sexe` enum('m','f') default NULL,
  `naissance` date default NULL,
  `adresse` varchar(100) NOT NULL default '',
  `ville` varchar(50) NOT NULL default '',
  `telephone` varchar(50) default NULL,
  `courriel` varchar(50) default NULL,
  `siteweb` varchar(64) default NULL,
  `id_structure_provenance` int(11) unsigned default NULL,
  `commentaires` text,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `nom` (`nom`),
  KEY `login` (`login`),
  KEY `motdepasse` (`motdepasse`),
  KEY `id_structure_provenance` (`id_structure_provenance`)
) TYPE=MyISAM COMMENT='Renseignements sur les animateurs';
# --------------------------------------------------------

#
# Structure de la table `animateurs_calendrier`
#

DROP TABLE IF EXISTS `animateurs_calendrier`;
CREATE TABLE `animateurs_calendrier` (
  `id_animateur` int(10) NOT NULL default '0',
  `id_localisation` int(11) NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `debut` time NOT NULL default '00:00:00',
  `fin` time NOT NULL default '00:00:00',
  PRIMARY KEY  (`id_animateur`,`date`,`debut`),
  KEY `id_localisation` (`id_localisation`),
  KEY `debut` (`debut`),
  KEY `date` (`date`),
  KEY `fin` (`fin`),
  KEY `id_animateur` (`id_animateur`)
) TYPE=MyISAM COMMENT='Calendrier des animateurs';
# --------------------------------------------------------

#
# Structure de la table `animateurs_horaires`
#

DROP TABLE IF EXISTS `animateurs_horaires`;
CREATE TABLE `animateurs_horaires` (
  `id_animateur` int(11) NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `debut` time NOT NULL default '00:00:00',
  `fin` time NOT NULL default '00:00:00',
  `presence` enum('disponible','affect','absent') NOT NULL default 'absent',
  KEY `id_animateur` (`id_animateur`),
  KEY `debut` (`debut`),
  KEY `date` (`date`),
  KEY `presence` (`presence`),
  KEY `fin` (`fin`)
) TYPE=MyISAM COMMENT='Calendrier des presence d animateur';
# --------------------------------------------------------

#
# Structure de la table `animateurs_initiations`
#

DROP TABLE IF EXISTS `animateurs_initiations`;
CREATE TABLE `animateurs_initiations` (
  `id_initiations` int(11) NOT NULL default '0',
  `id_animateurs` int(10) NOT NULL default '0',
  `niveau` enum('dbutant(e)','initi(e)','avanc(e)') NOT NULL default 'dbutant(e)',
  PRIMARY KEY  (`id_initiations`,`id_animateurs`)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Structure de la table `animateurs_modeles_horaires`
#

DROP TABLE IF EXISTS `animateurs_modeles_horaires`;
CREATE TABLE `animateurs_modeles_horaires` (
  `id_animateur` int(11) NOT NULL default '0',
  `jour` enum('dimanche','lundi','mardi','mercredi','jeudi','vendredi','samedi') NOT NULL default 'dimanche',
  `debut` time NOT NULL default '00:00:00',
  `fin` time NOT NULL default '00:00:00',
  `presence` enum('disponible','affect','absent') NOT NULL default 'absent',
  KEY `id_animateur` (`id_animateur`),
  KEY `debut` (`debut`),
  KEY `jour` (`jour`),
  KEY `fin` (`fin`),
  KEY `presence` (`presence`)
) TYPE=MyISAM COMMENT='Calendrier des jours de fermeture';
# --------------------------------------------------------

#
# Structure de la table `calendrier`
#

DROP TABLE IF EXISTS `calendrier`;
CREATE TABLE `calendrier` (
  `id_localisation` int(11) NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `debut` time NOT NULL default '00:00:00',
  `fin` time NOT NULL default '00:00:00',
  `ouverture` enum('accs individuels','activits collectives') NOT NULL default 'accs individuels',
  KEY `id_localisation` (`id_localisation`),
  KEY `debut` (`debut`),
  KEY `date` (`date`),
  KEY `ouverture` (`ouverture`),
  KEY `fin` (`fin`)
) TYPE=MyISAM COMMENT='Calendrier des jours de fermeture';
# --------------------------------------------------------

#
# Structure de la table `credits`
#

DROP TABLE IF EXISTS `credits`;
CREATE TABLE `credits` (
  `id_usager` int(10) unsigned NOT NULL default '0',
  `id_tarif` int(11) NOT NULL default '1',
  `credit_acces_individuel` bigint(20) NOT NULL default '0',
  `credit_activites_collectives` bigint(20) NOT NULL default '0',
  `credit_reservable` bigint(20) NOT NULL default '0',
  `commentaires` text NOT NULL,
  `debut_abonnement_acces_individuel` date NOT NULL default '0000-00-00',
  `fin_abonnement_acces_individuel` date NOT NULL default '0000-00-00',
  `debut_abonnement_activites_collectives` date NOT NULL default '0000-00-00',
  `fin_abonnement_activites_collectives` date NOT NULL default '0000-00-00',
  `carte` enum('attente','prte','imprime') NOT NULL default 'attente',
  PRIMARY KEY  (`id_usager`),
  KEY `tarif` (`id_tarif`),
  KEY `carte` (`carte`)
) TYPE=MyISAM COMMENT='Renseignements sur les usagers';
# --------------------------------------------------------

#
# Structure de la table `domaines`
#

DROP TABLE IF EXISTS `domaines`;
CREATE TABLE `domaines` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `domaine` varchar(64) NOT NULL default '',
  `visible` enum('non','oui') NOT NULL default 'non',
  PRIMARY KEY  (`id`),
  KEY `domaine` (`domaine`),
  KEY `visible` (`visible`)
) TYPE=MyISAM COMMENT='Liste des pages perso et des courriels hbergs localement';
# --------------------------------------------------------

#
# Structure de la table `droits`
#

DROP TABLE IF EXISTS `droits`;
CREATE TABLE `droits` (
  `id_structure` int(11) NOT NULL default '0',
  `id_fonction` int(11) NOT NULL default '0',
  `actif` enum('n','y') NOT NULL default 'n',
  `moi` enum('n','r','w') NOT NULL default 'n',
  `autres` enum('n','r','w') NOT NULL default 'n',
  PRIMARY KEY  (`id_structure`,`id_fonction`),
  KEY `id_structure` (`id_structure`),
  KEY `id_fonction` (`id_fonction`)
) TYPE=MyISAM COMMENT='Permissions des structures  accder aux fonctionnalits';
# --------------------------------------------------------

#
# Structure de la table `fonctions`
#

DROP TABLE IF EXISTS `fonctions`;
CREATE TABLE `fonctions` (
  `id` int(11) NOT NULL auto_increment,
  `fonction` varchar(63) NOT NULL default '',
  `couleur` varchar(20) default NULL,
  `depend` varchar(20) default NULL,
  `ordre` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `fonction` (`fonction`)
) TYPE=MyISAM COMMENT='Fonctionnalits de l''application';
# --------------------------------------------------------

#
# Structure de la table `hebergements`
#

DROP TABLE IF EXISTS `hebergements`;
CREATE TABLE `hebergements` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `id_structure` int(10) unsigned default NULL,
  `id_usager` int(11) unsigned default NULL,
  `type` enum('siteweb','aliassiteweb','courriel','aliascourriel') NOT NULL default 'siteweb',
  `sousdomaine` varchar(64) NOT NULL default '',
  `login` varchar(64) default NULL,
  `motdepasse` varchar(32) default NULL,
  PRIMARY KEY  (`id`),
  KEY `type` (`type`),
  KEY `domaine` (`sousdomaine`),
  KEY `login` (`login`),
  KEY `id_structure` (`id_structure`),
  KEY `id_usager` (`id_usager`)
) TYPE=MyISAM COMMENT='Liste des pages perso et des courriels hbergs localement';
# --------------------------------------------------------

#
# Structure de la table `initiations`
#

DROP TABLE IF EXISTS `initiations`;
CREATE TABLE `initiations` (
  `id` int(11) NOT NULL auto_increment,
  `id_theme` int(11) NOT NULL default '0',
  `initiation` varchar(127) NOT NULL default '',
  `niveau` enum('dbutant(e)','initi(e)','avanc(e)') NOT NULL default 'dbutant(e)',
  `objectifs` text NOT NULL,
  `moyen_evaluation` text NOT NULL,
  `prerequis` varchar(20) default NULL,
  `duree` time NOT NULL default '01:00:00',
  `nbmaxparticipants` tinyint(4) NOT NULL default '8',
  `contenu` text,
  `preparation` text,
  `role_formateur` text,
  `role_apprenants` text,
  `prolongements` varchar(20) default NULL,
  `dans_parcours` enum('oui','non') NOT NULL default 'oui',
  `public` enum('oui','non') NOT NULL default 'oui',
  `auteurs_versions` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `niveau` (`niveau`),
  KEY `id_theme` (`id_theme`),
  KEY `initiation` (`initiation`)
) TYPE=MyISAM COMMENT='theme_session';
# --------------------------------------------------------

#
# Structure de la table `initiations_fichiers`
#

DROP TABLE IF EXISTS `initiations_fichiers`;
CREATE TABLE `initiations_fichiers` (
  `id` int(11) NOT NULL default '0',
  `id_initiation` int(11) NOT NULL default '0',
  `fichier` varchar(200) NOT NULL default '',
  `usager` enum('y','n') NOT NULL default 'n',
  `public` enum('y','n') NOT NULL default 'y',
  PRIMARY KEY  (`id`),
  KEY `id_initiation` (`id_initiation`)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Structure de la table `initiations_serveurs`
#

DROP TABLE IF EXISTS `initiations_serveurs`;
CREATE TABLE `initiations_serveurs` (
  `id` int(11) NOT NULL auto_increment,
  `serveur` varchar(200) NOT NULL default '',
  `commentaire` text NOT NULL,
  `date` date NOT NULL default '0000-00-00',
  `source` varchar(200) NOT NULL default '',
  `etat` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `serveur` (`serveur`)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Structure de la table `journal`
#

DROP TABLE IF EXISTS `journal`;
CREATE TABLE `journal` (
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `TYPE` varchar(255) NOT NULL default '',
  `id` int(11) NOT NULL default '0',
  KEY `date` (`date`,`TYPE`,`id`)
) TYPE=MyISAM COMMENT='Journal des identifications';
# --------------------------------------------------------

#
# Structure de la table `localisations`
#

DROP TABLE IF EXISTS `localisations`;
CREATE TABLE `localisations` (
  `id` int(11) NOT NULL auto_increment,
  `id_structure` int(11) NOT NULL default '0',
  `salle` varchar(100) NOT NULL default '',
  `description` text,
  `image` varchar(120) default NULL,
  `image2` varchar(120) default NULL,
  PRIMARY KEY  (`id`),
  KEY `salle` (`salle`),
  KEY `id_structure` (`id_structure`)
) TYPE=MyISAM COMMENT='Liste des lieux d''accs et des salles';
# --------------------------------------------------------

#
# Structure de la table `logi_mate`
#

DROP TABLE IF EXISTS `logi_mate`;
CREATE TABLE `logi_mate` (
  `id_logiciel` int(11) NOT NULL default '0',
  `id_materiel` int(11) NOT NULL default '0',
  KEY `id_logiciel` (`id_logiciel`),
  KEY `id_materiel` (`id_materiel`)
) TYPE=MyISAM COMMENT='Lien entre les logiciels et les matriels';
# --------------------------------------------------------

#
# Structure de la table `logiciels`
#

DROP TABLE IF EXISTS `logiciels`;
CREATE TABLE `logiciels` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `type` varchar(30) default NULL,
  `titre` varchar(80) NOT NULL default '',
  `id_structure` int(11) NOT NULL default '0',
  `licence` varchar(40) NOT NULL default '',
  `info_achat` text,
  `commentaire` text,
  `reservable` enum('oui','non') NOT NULL default 'non',
  `pret_possible` enum('oui','non') NOT NULL default 'non',
  `image` varchar(40) default NULL,
  PRIMARY KEY  (`id`),
  KEY `type` (`type`),
  KEY `titre` (`titre`),
  KEY `id_structure` (`id_structure`)
) TYPE=MyISAM COMMENT='Cette table lie les ordinateurs aux logiciels qui y sont ins';
# --------------------------------------------------------

#
# Structure de la table `materiels`
#

DROP TABLE IF EXISTS `materiels`;
CREATE TABLE `materiels` (
  `id` int(11) NOT NULL auto_increment,
  `type` enum('Unit centrale','Moniteur','Serveur','Portable','Priphrique entre','Priphrique sortie','Divers','Documentation') NOT NULL default 'Unit centrale',
  `materiel` varchar(20) default NULL,
  `specificite` varchar(20) default NULL,
  `id_localisation` int(11) default NULL,
  `ip` varchar(20) default NULL,
  `info_achat` text,
  `description` text NOT NULL,
  `usages` varchar(40) default NULL,
  `reservable` enum('oui','non',' deux') NOT NULL default 'non',
  `pret_possible` enum('oui','non') NOT NULL default 'non',
  `image` varchar(80) default NULL,
  PRIMARY KEY  (`id`),
  KEY `type` (`type`),
  KEY `materiel` (`materiel`),
  KEY `id_localisation` (`id_localisation`),
  KEY `reservable` (`reservable`)
) TYPE=MyISAM COMMENT='Liste des ordinateurs dans l\\''Arobase';
# --------------------------------------------------------

#
# Structure de la table `menus`
#

DROP TABLE IF EXISTS `menus`;
CREATE TABLE `menus` (
  `level_order` varchar(10) NOT NULL default '1',
  `language` char(2) NOT NULL default 'fr',
  `value` varchar(255) NOT NULL default '',
  `comment` varchar(255) default NULL,
  `link` varchar(255) default NULL,
  `icon` varchar(255) default NULL,
  `visitors` enum('y','n') NOT NULL default 'n',
  `users` enum('y','n') NOT NULL default 'n',
  `leaders` enum('y','n') NOT NULL default 'n',
  `structures` enum('y','n') NOT NULL default 'n',
  `id_fonction` int(11) NOT NULL default '0',
  `rights_me` enum('any','active','see','change','no') NOT NULL default 'no',
  `rights_others` enum('any','active','see','change','no') NOT NULL default 'no',
  KEY `id_fonction` (`id_fonction`),
  KEY `language` (`language`),
  KEY `level_order` (`level_order`)
) TYPE=MyISAM COMMENT='Menus dynamique';
# --------------------------------------------------------

#
# Structure de la table `modeles_horaires`
#

DROP TABLE IF EXISTS `modeles_horaires`;
CREATE TABLE `modeles_horaires` (
  `id_localisation` int(11) NOT NULL default '0',
  `jour` enum('dimanche','lundi','mardi','mercredi','jeudi','vendredi','samedi') NOT NULL default 'dimanche',
  `debut` time NOT NULL default '00:00:00',
  `fin` time NOT NULL default '00:00:00',
  `ouverture` enum('accs individuels','activits collectives') NOT NULL default 'accs individuels',
  KEY `id_localisation` (`id_localisation`),
  KEY `debut` (`debut`),
  KEY `jour` (`jour`),
  KEY `fin` (`fin`),
  KEY `ouverture` (`ouverture`)
) TYPE=MyISAM COMMENT='Calendrier des jours de fermeture';
# --------------------------------------------------------

#
# Structure de la table `parcours`
#

DROP TABLE IF EXISTS `parcours`;
CREATE TABLE `parcours` (
  `id_usager` int(11) NOT NULL default '0',
  `id_initiation` int(11) NOT NULL default '0',
  `id_session` int(11) default NULL,
  `etat` enum('indispensable','conseill','effectu','en retard','absent','problme') NOT NULL default 'indispensable',
  KEY `id_usager` (`id_usager`),
  KEY `id_session` (`id_session`),
  KEY `id_initiation` (`id_initiation`),
  KEY `etat` (`etat`)
) TYPE=MyISAM COMMENT='Parcous pdagogique de chaque usager.';
# --------------------------------------------------------

#
# Structure de la table `positionnement`
#

DROP TABLE IF EXISTS `positionnement`;
CREATE TABLE `positionnement` (
  `id_usager` int(11) NOT NULL default '0',
  `id_initiation` int(11) NOT NULL default '0',
  `niveau` enum('dbutant(e)','initi(e)','avanc(e)') NOT NULL default 'dbutant(e)',
  `valid` enum('oui','non') NOT NULL default 'non',
  KEY `id_usager` (`id_usager`),
  KEY `niveau` (`niveau`),
  KEY `id_initiation` (`id_initiation`)
) TYPE=MyISAM COMMENT='Niveau de comptence de chaque usager dans chaque thme.';
# --------------------------------------------------------

#
# Structure de la table `prets`
#

DROP TABLE IF EXISTS `prets`;
CREATE TABLE `prets` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `id_structure` int(11) NOT NULL default '0',
  `date_demande` date NOT NULL default '0000-00-00',
  `date_emprunt` date NOT NULL default '0000-00-00',
  `date_retour_prevu` date NOT NULL default '0000-00-00',
  `date_retour_effectif` date NOT NULL default '0000-00-00',
  `etat` enum('prpar','demand','prt','refus') NOT NULL default 'demand',
  `commentaires` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `id_structure` (`id_structure`),
  KEY `date_emprunt` (`date_emprunt`),
  KEY `date_retour_prevu` (`date_retour_prevu`),
  KEY `date_demande` (`date_demande`),
  KEY `date_retour_effectif` (`date_retour_effectif`),
  KEY `date_retour_effectif_2` (`date_retour_effectif`)
) TYPE=MyISAM COMMENT='Liste des prts (demandes, accords, retours)';
# --------------------------------------------------------

#
# Structure de la table `prets_contenu`
#

DROP TABLE IF EXISTS `prets_contenu`;
CREATE TABLE `prets_contenu` (
  `id_pret` int(11) NOT NULL default '0',
  `id_materiel` int(11) NOT NULL default '0',
  `id_logiciel` int(11) NOT NULL default '0',
  `etat` enum('prpar','demand','prt','refus') NOT NULL default 'demand',
  `commentaires` text NOT NULL,
  KEY `id_materiel` (`id_materiel`),
  KEY `id_structure` (`id_logiciel`),
  KEY `etat` (`etat`),
  KEY `id_pret` (`id_pret`)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Structure de la table `questions`
#

DROP TABLE IF EXISTS `questions`;
CREATE TABLE `questions` (
  `id` int(11) NOT NULL auto_increment,
  `id_initiation` int(11) NOT NULL default '0',
  `question` text NOT NULL,
  `url_aide` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `id_session` (`id_initiation`)
) TYPE=MyISAM COMMENT='Liste des questions pour le positionnement';
# --------------------------------------------------------

#
# Structure de la table `sessions`
#

DROP TABLE IF EXISTS `sessions`;
CREATE TABLE `sessions` (
  `id` int(11) NOT NULL auto_increment,
  `id_localisation` int(11) NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `debut` time NOT NULL default '00:00:00',
  `fin` time NOT NULL default '00:00:00',
  `id_initiation` int(11) default NULL,
  `nom_session` varchar(50) default NULL,
  `inscriptionauto` enum('oui','non') NOT NULL default 'oui',
  `nbparticipants` int(11) default NULL,
  `etat` enum('pr-rservation','rservation','annule') NOT NULL default 'pr-rservation',
  `id_animateur` int(10) unsigned default NULL,
  `animateur` varchar(50) NOT NULL default '',
  `id_structure` int(11) NOT NULL default '0',
  `commentaires` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `debut` (`debut`),
  KEY `id_initiation` (`id_initiation`),
  KEY `etat` (`etat`),
  KEY `id_structure` (`id_structure`),
  KEY `id_localisation` (`id_localisation`),
  KEY `date` (`date`),
  KEY `id_animateur` (`id_animateur`),
  KEY `debut_2` (`debut`),
  KEY `fin` (`fin`)
) TYPE=MyISAM COMMENT='Sessions programmes et ralises';
# --------------------------------------------------------

#
# Structure de la table `structures`
#

DROP TABLE IF EXISTS `structures`;
CREATE TABLE `structures` (
  `id` int(11) NOT NULL auto_increment,
  `structure` varchar(30) NOT NULL default '',
  `raison_sociale` varchar(50) default NULL,
  `nom_responsable` varchar(50) default NULL,
  `login` varchar(30) NOT NULL default '',
  `motdepasse` varchar(32) NOT NULL default '',
  `adresse` varchar(100) default NULL,
  `ville` varchar(50) NOT NULL default '',
  `courriel` varchar(50) default NULL,
  `siteweb` varchar(50) default NULL,
  `commentaires` text,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `structure` (`structure`),
  KEY `login` (`login`)
) TYPE=MyISAM COMMENT='Liste des structures partenaires de l''EPN';
# --------------------------------------------------------

#
# Structure de la table `tarifs`
#

DROP TABLE IF EXISTS `tarifs`;
CREATE TABLE `tarifs` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `tarif` varchar(64) NOT NULL default '',
  `couleur` varchar(6) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `tarif` (`tarif`)
) TYPE=MyISAM COMMENT='Liste des tarifs ou abonnements diffrents';
# --------------------------------------------------------

#
# Structure de la table `themes`
#

DROP TABLE IF EXISTS `themes`;
CREATE TABLE `themes` (
  `id` int(11) NOT NULL auto_increment,
  `theme` varchar(40) NOT NULL default '',
  `commentaire` text NOT NULL,
  `url_image` varchar(128) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `theme` (`theme`)
) TYPE=MyISAM COMMENT='Liste des thmes des initiations';
# --------------------------------------------------------

#
# Structure de la table `usagers`
#

DROP TABLE IF EXISTS `usagers`;
CREATE TABLE `usagers` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `nom` varchar(30) NOT NULL default '',
  `prenom` varchar(30) NOT NULL default '',
  `login` varchar(30) NOT NULL default '',
  `motdepasse` varchar(32) NOT NULL default '',
  `sexe` enum('m','f') default NULL,
  `naissance` date default NULL,
  `adresse` varchar(100) NOT NULL default '',
  `ville` varchar(50) NOT NULL default '',
  `telephone` varchar(50) default NULL,
  `courriel` varchar(50) default NULL,
  `siteweb` varchar(50) default NULL,
  `id_structure_provenance` int(11) unsigned default NULL,
  `commentaire` text,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `nom` (`nom`),
  KEY `login` (`login`),
  KEY `motdepasse` (`motdepasse`),
  KEY `id_structure_provenance` (`id_structure_provenance`)
) TYPE=MyISAM COMMENT='Renseignements sur les usagers';
# --------------------------------------------------------

#
# Structure de la table `usages`
#

DROP TABLE IF EXISTS `usages`;
CREATE TABLE `usages` (
  `id` int(11) NOT NULL auto_increment,
  `nom` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `nom` (`nom`)
) TYPE=MyISAM COMMENT='Liste des usages des ordinateurs';
# --------------------------------------------------------

#
# Structure de la table `utilisation_postes`
#

DROP TABLE IF EXISTS `utilisation_postes`;
CREATE TABLE `utilisation_postes` (
  `id` int(11) NOT NULL auto_increment,
  `id_materiel` int(11) NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `debut` time NOT NULL default '00:00:00',
  `fin` time NOT NULL default '00:00:00',
  `id_usager` int(11) NOT NULL default '0',
  `id_usager2` int(11) default NULL,
  `usager` varchar(255) default NULL,
  `id_usage` int(11) NOT NULL default '0',
  `etat` enum('rservation','impromptue','annule','non tenue') NOT NULL default 'rservation',
  PRIMARY KEY  (`id`),
  KEY `date` (`debut`),
  KEY `id_materiel` (`id_materiel`),
  KEY `id_usager` (`id_usager`),
  KEY `id_usage` (`id_usage`),
  KEY `debut` (`debut`),
  KEY `fin` (`fin`)
) TYPE=MyISAM COMMENT='Planning d''utilisation des postes individuels';