CREATE TABLE moyentrans (
  numero INTEGER NOT NULL,
  nom varchar(20) NOT NULL,
  vitesse INTEGER NOT NULL,
  PRIMARY KEY  (numero)
);

INSERT INTO moyentrans (numero, nom, vitesse)
VALUES (1,'astronef',1);

INSERT INTO moyentrans (numero, nom, vitesse)
VALUES (2,'fusee a plasma',3);

INSERT INTO moyentrans (numero, nom, vitesse)
VALUES (3,'tachyon',10);

INSERT INTO moyentrans (numero, nom, vitesse)
VALUES (4,'teleportation',32);

INSERT INTO moyentrans (numero, nom, vitesse)
VALUES (5,'hyper espace',64);

CREATE TABLE planetes (
  numero INTEGER NOT NULL,
  nom varchar(20) NOT NULL,
  taille INTEGER NOT NULL,
  PRIMARY KEY  (numero)
);

INSERT INTO planetes (numero,nom,taille)
VALUES (1,'Terre',1);

INSERT INTO planetes (numero, nom, taille)
VALUES (2,'Pluton',1);

INSERT INTO planetes (numero, nom, taille)
VALUES (3,'Vega',25);

INSERT INTO planetes (numero, nom, taille)
VALUES (4,'Merion',54);

INSERT INTO planetes (numero, nom, taille)
VALUES (5,'Zollom',125);

INSERT INTO planetes (numero, nom, taille)
VALUES (6,'Elsinil',256);

INSERT INTO planetes (numero, nom, taille)
VALUES (7,'Aflolol',1024);

CREATE TABLE voyages (
  numero INTEGER NOT NULL,
  depart INTEGER NOT NULL,
  arrivee INTEGER NOT NULL,
  appareil INTEGER NOT NULL,
  duree time NOT NULL,
  PRIMARY KEY  (numero)
);

INSERT INTO voyages (numero, depart, arrivee, appareil, duree)
VALUES (1,1,2,1,'01:00:00');

INSERT INTO voyages (numero, depart, arrivee, appareil, duree)
VALUES (2,2,1,1,'01:00:00');

INSERT INTO voyages (numero, depart, arrivee, appareil, duree)
VALUES (3,1,3,2,'09:00:00');

INSERT INTO voyages (numero, depart, arrivee, appareil, duree)
VALUES (4,5,1,4,'04:10:00');

INSERT INTO voyages (numero, depart, arrivee, appareil, duree)
VALUES (5,3,5,3,'11:00:00');

INSERT INTO voyages (numero, depart, arrivee, appareil, duree)
VALUES (6,5,7,5,'15:00:00');

INSERT INTO voyages (numero, depart, arrivee, appareil, duree)
VALUES (7,2,4,3,'06:00:00');

INSERT INTO voyages (numero, depart, arrivee, appareil, duree)
VALUES (8,4,6,4,'07:00:00');

INSERT INTO voyages (numero, depart, arrivee, appareil, duree)
VALUES (9,6,2,5,'04:15:00');

INSERT INTO voyages (numero, depart, arrivee, appareil, duree)
VALUES (10,7,1,5,'16:15:00');
