# Ajout des tables type de ticket

--
-- Structure de la table `type_ticket`
--

CREATE TABLE IF NOT EXISTS `type_ticket` (
  `id` int(11) NOT NULL COMMENT 'Identifiant',
  `nom` varchar(64) NOT NULL COMMENT 'Nom',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Type de tickets';

--
-- Structure de la table `sections`
--

CREATE TABLE IF NOT EXISTS `sections` (
  `name` varchar(32) NOT NULL COMMENT 'Nom',
  `description` varchar(64) DEFAULT NULL COMMENT 'Description',
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Structure de la table `membership`
--

CREATE TABLE IF NOT EXISTS `membership` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Identifiant',
  `mlogin` varchar(32) NOT NULL COMMENT 'Identifiant de connexion',
  `section` varchar(32) NOT NULL COMMENT 'Section',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

