CREATE TABLE experts (
  id_expert tinyint(4) NOT NULL auto_increment,
  nom_expert text NOT NULL,
  PRIMARY KEY  (id_expert)
) TYPE=MyISAM;

#
# Contenu de la table `experts`
#

INSERT INTO experts VALUES (1,'James');
INSERT INTO experts VALUES (2,'Lars');
INSERT INTO experts VALUES (3,'Kirk');
INSERT INTO experts VALUES (4,'Jason');
INSERT INTO experts VALUES (5,'Peter');
INSERT INTO experts VALUES (6,'Jessie');


CREATE TABLE formations (
  id_formation tinyint(4) NOT NULL auto_increment,
  nom_formation text NOT NULL,
  id_expert tinyint(4) default '0',
  PRIMARY KEY  (id_formation)
) TYPE=MyISAM;

#
# Contenu de la table `formations`
#

INSERT INTO formations VALUES (1,'C#',2);
INSERT INTO formations VALUES (2,'Cold Fusion',3);
INSERT INTO formations VALUES (3,'Web Services',5);
INSERT INTO formations VALUES (4,'Php',6);
INSERT INTO formations VALUES (5,'ADO.NET',5);
INSERT INTO formations VALUES (6,'XML','');