lifesim/dutytrips.sql at master · Hotpirsch/lifesim · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
CREATE TABLE dutytrips(
   ID          INTEGER  NOT NULL PRIMARY KEY
  ,Destination VARCHAR(11) NOT NULL
);
INSERT INTO dutytrips(ID,Destination) VALUES (1,'Algier');
INSERT INTO dutytrips(ID,Destination) VALUES (2,'Amsterdam');
INSERT INTO dutytrips(ID,Destination) VALUES (3,'Berlin');
INSERT INTO dutytrips(ID,Destination) VALUES (4,'Brussels');
INSERT INTO dutytrips(ID,Destination) VALUES (5,'Budapest');
INSERT INTO dutytrips(ID,Destination) VALUES (6,'Dresden');
INSERT INTO dutytrips(ID,Destination) VALUES (7,'Gdansk');
INSERT INTO dutytrips(ID,Destination) VALUES (8,'Gothenburg');
INSERT INTO dutytrips(ID,Destination) VALUES (9,'Hamburg');
INSERT INTO dutytrips(ID,Destination) VALUES (10,'Helsinki');
INSERT INTO dutytrips(ID,Destination) VALUES (11,'Hongkong');
INSERT INTO dutytrips(ID,Destination) VALUES (12,'Honolulu');
INSERT INTO dutytrips(ID,Destination) VALUES (13,'Kigali');
INSERT INTO dutytrips(ID,Destination) VALUES (14,'Leipzig');
INSERT INTO dutytrips(ID,Destination) VALUES (15,'Minneapolis');
INSERT INTO dutytrips(ID,Destination) VALUES (16,'Munich');
INSERT INTO dutytrips(ID,Destination) VALUES (17,'New Delhi');
INSERT INTO dutytrips(ID,Destination) VALUES (18,'Paris');
INSERT INTO dutytrips(ID,Destination) VALUES (19,'Seattle');
INSERT INTO dutytrips(ID,Destination) VALUES (20,'Shenzen');
INSERT INTO dutytrips(ID,Destination) VALUES (21,'Singapore');
INSERT INTO dutytrips(ID,Destination) VALUES (22,'Stuttgart');
INSERT INTO dutytrips(ID,Destination) VALUES (23,'Toronto');
INSERT INTO dutytrips(ID,Destination) VALUES (24,'Vevey');
INSERT INTO dutytrips(ID,Destination) VALUES (25,'Zagreb');