-- data01.sql

set 
echo on


INSERT INTO Ville VALUES ( 1, 'Strasbourg', '67000');

INSERT INTO Ville VALUES ( 2, 'Lyon', '69000');

INSERT INTO Ville VALUES ( 3, 'Grenoble', '38000');

INSERT INTO Ville VALUES ( 4, 'Paris', '75000');

INSERT INTO Ville VALUES ( 5, 'Marseille', '13000');

INSERT INTO Ville VALUES ( 6, 'Brumath', '67170');

INSERT INTO Ville VALUES ( 7, 'Souffelweyersheim', '67460');

INSERT INTO Ville VALUES ( 8, 'Poitiers', '86000');

INSERT INTO Ville VALUES ( 9, 'Limoges', '87000');

INSERT INTO Ville VALUES (10, 'Nice', '06000');

INSERT INTO Ville VALUES (11, 'Toulon', '83000');



INSERT INTO Train VALUES ( 1, 1, 2, 10, 15, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES ( 2, 1, 2, 12, 17, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES ( 3, 1, 2, 15, 20, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES ( 4, 1, 2, 18, 23, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES ( 5, 2, 1, 10, 15, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES ( 6, 2, 1, 12, 17, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES ( 7, 2, 1, 15, 20, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES ( 8, 2, 1, 18, 23, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES ( 9, 1, 4, 6, 10, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (10, 1, 4, 7, 11, TO_DATE('9/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (11, 1, 4, 10, 14, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (12, 1, 4, 16, 20, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (13, 4, 1, 6, 10, TO_DATE('12/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (14, 4, 1, 7, 11, TO_DATE('15/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (15, 4, 1, 10, 14, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (16, 4, 1, 16, 20, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (17, 2, 3, 7, 8, TO_DATE('3/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (18, 2, 3, 8, 9, TO_DATE('3/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (19, 2, 3, 9, 10, TO_DATE('3/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (20, 2, 3, 10, 11, TO_DATE('3/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (21, 2, 3, 11, 12, TO_DATE('3/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (22, 2, 3, 12, 13, TO_DATE('3/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (23, 3, 2, 7, 8, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (24, 3, 2, 8, 9, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (25, 3, 2, 9, 10, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (26, 3, 2, 10, 11, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (27, 3, 2, 11, 12, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (28, 3, 2, 12, 13, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (29, 2, 5, 14, 16, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (30, 2, 5, 15, 17, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (31, 2, 5, 20, 22, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (32, 5, 2, 14, 16, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (33, 5, 2, 15, 17, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (34, 5, 2, 20, 22, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (35, 1, 5, 8, 16, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (36, 1, 5, 14, 22, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (37, 5, 1, 8, 16, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (38, 5, 1, 15, 23, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (39, 1, 8, 8, 16, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (40, 1, 8, 14, 22, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (41, 8, 1, 8, 16, TO_DATE('8/3/2006', 'dd/mm/YYYY'));

INSERT INTO Train VALUES (42, 8, 1, 15, 23, TO_DATE('8/3/2006', 'dd/mm/YYYY'));



INSERT INTO Passager VALUES ( 1, 'Robert', 12, 1);

INSERT INTO Passager VALUES ( 2, 'Dupont', 18, 1);

INSERT INTO Passager VALUES ( 3, 'Sylvain', 35, 2);

INSERT INTO Passager VALUES ( 4, 'Sylvain', 35, 9);

INSERT INTO Passager VALUES ( 5, 'Arnaud', 66, 2);

INSERT INTO Passager VALUES ( 6, 'Arnaud', 66, 9);

INSERT INTO Passager VALUES ( 7, 'Claude', 28, 6);

INSERT INTO Passager VALUES ( 8, 'Claude', 28, 20);

INSERT INTO Passager VALUES ( 9, 'Claude', 28,24);

INSERT INTO Passager VALUES (10, 'Claude', 28, 28);

INSERT INTO Passager VALUES (11, 'Claude', 28, 33);

