### structure of table `matiere` ###

DROP TABLE IF EXISTS `matiere`;

CREATE TABLE `matiere` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `matiere` varchar(25) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 AUTO_INCREMENT=6;


### data of table `matiere` ###

insert into `matiere` values ('10', 'Allemand');
insert into `matiere` values ('11', 'Anglais');
insert into `matiere` values ('12', 'Espagnal');

insert into `matiere` values ('13', 'Francais');
insert into `matiere` values ('14', 'Philo');
insert into `matiere` values ('15', 'Math');
insert into `matiere` values ('16', 'Hist-Geo');
insert into `matiere` values ('17', 'Phys-Chimie');
insert into `matiere` values ('18', 'SVT');
insert into `matiere` values ('19', 'SMS');
insert into `matiere` values ('20', 'STT');
insert into `matiere` values ('21', 'BTS');
insert into `matiere` values ('22', 'Sport');

insert into `matiere` values ('23', 'Etud-Secon');
insert into `matiere` values ('24', 'Etud-Prem');
insert into `matiere` values ('25', 'Etud-Term');
insert into `matiere` values ('26', 'Administratif');
insert into `matiere` values ('27', 'Autre');