INSERT INTO city (name, state) VALUES
  ("Hampton",        "VA"),
  ("Newport News",   "VA"),
  ("Williamsburg",   "VA"),
  ("Portsmouth",     "VA"),
  ("Norfolk",        "VA"),
  ("Virginia Beach", "VA"),
  ("Richmond",       "VA"),
  ("Fredricksburg",  "VA"),
  ("Gloucester",     "VA"),
  ("Yorktown",       "VA"),
  ("Chesapeake",     "VA");

INSERT INTO station (id, name, city_name, city_state) VALUES
  (  1, "Williamson" , "Hampton" ,      "VA"),
  (  2, "Stonewall" ,  "Newport News" , "VA"),
  (  3, "Shale" ,      "Williamsburg" , "VA"),
  (  4, "Whitewall" ,  "Portsmouth" ,   "VA"),
  (  5, "Montgomery" , "Norfolk" ,      "VA"),
  (  6, "Blumont" ,    "Norfolk" ,      "VA"),
  (  7, "Ellis" ,      "Richmond" ,     "VA"),
  (  8, "Plantation" , "Yorktown" ,     "VA"),
  (  9, "Elm" ,        "Chesapeake" ,   "VA"),
  ( 10, "Mason" ,      "Williamsburg" , "VA"),
  ( 11, "Artisian" ,   "Norfolk" ,      "VA"),
  ( 12, "Tailor" ,     "Richmond" ,     "VA");

INSERT INTO track (id, length, sta_from, sta_to) VALUES
  ( 1, 100.5, 12, 11),
  ( 2,  45.9, 10, 11),
  ( 3,  12.1,  9, 10),
  ( 4,   5.0,  8,  9),
  ( 5,  26.0,  7,  8),
  ( 6,  15.0,  6,  7),
  ( 7,  13.0,  5,  6),
  ( 8,  15.0,  4,  5),
  ( 9,  57.3,  3,  4),
  (10,  31.0,  2,  3),
  (11,  10.0,  1,  2),
  (12,  19.0,  5,  8),
  (13,  24.7,  9, 11),
  (14,  33.0,  1,  3),
  (15,  32.0,  1, 10),
  (16,  48.0, 10,  7),
  (17,  50.0, 10, 12);

INSERT INTO locomotive (id, gross_weight, max_weight) VALUES
  ( 1, 5500, 20000),
  ( 2, 5500, 20000),
  ( 3, 5600, 30000),
  ( 4, 4500, 10000),
  ( 5, 5500, 20000),
  ( 6, 4900, 17000),
  ( 7, 5000, 19000),
  ( 8, 5600, 30000),
  ( 9, 4500, 10000),
  (10, 5000, 19000),
  (11, 5600, 30000);

INSERT INTO car (id, gross_weight) VALUES
  ( 1, 5000),
  ( 2, 5000),
  ( 3, 4500),
  ( 4, 5000),
  ( 5, 5500),
  ( 6, 4500),
  ( 7, 4500),
  ( 8, 5000),
  ( 9, 5500),
  (10, 5000),
  (11, 5000),
  (12, 4500),
  (13, 4500),
  (14, 4500),
  (15, 5000),
  (16, 5000),
  (17, 5000),
  (18, 5500),
  (19, 4500),
  (20, 5500),
  (21, 5000),
  (22, 4500),
  (23, 5000);

INSERT INTO seat (id, car_id) VALUES
  ( 1,  1),
  ( 2,  1),
  ( 1,  2),
  ( 2,  2),
  ( 3,  2),
  ( 4,  2),
  ( 1,  3),
  ( 2,  3),
  ( 1,  4),
  ( 2,  4),
  ( 3,  4),
  ( 4,  4),
  ( 1,  5),
  ( 1,  6),
  ( 2,  6),
  ( 3,  6),
  ( 1,  7),
  ( 2,  7),
  ( 1,  8),
  ( 1,  9),
  ( 1, 10),
  ( 2,  8),
  ( 2,  9),
  ( 2, 10);

INSERT INTO train (id, start, end, locomotive_id, track_id) VALUES
  (101, '2003-09-05 12:50:00', '2003-09-05 15:50:00', 1, 13),
  (102, '2003-10-05 09:50:00', '2003-10-05 11:50:00', 1, 12),
  (103, '2003-10-06 23:00:00', '2003-10-07 01:00:00', 2, 11),
  (301, '2003-08-13 08:00:00', '2003-08-13 14:00:00', 2, 10),
  (302, '2004-11-11 03:00:00', '2004-11-11 06:00:00', 3,  9),
  (303, '2003-04-13 16:30:00', '2003-04-13 18:30:00', 3,  8),
  (201, '2003-04-17 12:45:00', '2003-04-17 17:00:00', 4,  7),
  (202, '2003-04-21 08:15:00', '2003-04-21 11:05:00', 4,  6),
  (203, '2003-04-22 08:15:00', '2003-04-22 12:15:00', 5,  5),
  (409, '2003-06-27 17:00:00', '2003-06-27 17:01:00', 5,  4),
  (596, '2003-07-14 01:00:00', '2003-07-14 23:59:00', 6,  3),
  (875, '2003-07-14 11:00:00', '2003-07-14 19:00:00', 6,  2),
  (881, '2003-07-14 11:00:00', '2003-07-14 19:00:00', 1, 14),
  (882, '2003-07-14 19:20:00', '2003-07-14 19:50:00', 2, 15),
  (883, '2003-07-14 19:10:00', '2003-07-14 19:40:00', 3, 16),
  (884, '2003-07-14 20:10:00', '2003-07-14 20:40:00', 5, 17);

INSERT INTO composition (train_id, car_id) VALUES
  (101,  8),
  (102,  7),
  (301,  6),
  (303,  5),
  (875,  1),
  (875,  2),
  (409,  3),
  (409,  4),
  (202,  9),
  (203, 10);

INSERT INTO reservation (conf, train_id, seat_id, car_id, for_cust) VALUES
  (1001, 101, 1,  8, "3456789"),
  (1002, 102, 2,  7, "1234567"),
  (1003, 301, 3,  6, "8765432"),
  (1004, 303, 1,  5, "9876543"),
  (1005, 875, 2,  1, "0987654"),
  (1006, 875, 2,  2, "4567890"),
  (1007, 409, 3,  4, "3456789"),
  (1008, 202, 1,  9, "2345678"),
  (1009, 203, 2, 10, "1234567"),
  (1010, 883, 2, 10, "0987654"),
  (1011, 884, 2, 10, "0987654"),
  (1012, 884, 2, 11, "0987654");

INSERT INTO customer (name, phone) VALUES
  ("James", "1234567"),
  ("Jane",  "2345678"),
  ("Joe",   "3456789"),
  ("Mary",  "4567890"),
  ("Bob",   "0987654"),
  ("Bob",   "4326754"),
  ("Diane", "9876543"),
  ("Joey",  "8765432");