-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathinsert_time_table_for_stations.sql
111 lines (109 loc) · 11.1 KB
/
insert_time_table_for_stations.sql
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
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
delimiter $$
create trigger for_time_table_for_station before insert on time_table_for_station
for each row
begin
if new.station_id = '' then
signal sqlstate '45000';
end if;
end;$$
delimiter ;
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (3,"06:44:12",6);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (4,"06:24:11",6);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (4,"09:36:58",6);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (7,"20:56:15",8);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (8,"04:10:16",1);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (2,"19:31:06",2);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (9,"00:45:34",4);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (3,"02:23:08",1);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (5,"06:53:13",2);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (1,"11:46:17",3);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (4,"20:56:39",4);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (4,"12:46:00",8);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (7,"13:35:29",3);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (9,"18:38:38",10);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (9,"19:23:44",2);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (5,"10:52:11",6);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (8,"21:06:32",4);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (2,"07:36:54",3);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (3,"08:01:06",3);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (10,"14:48:28",9);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (5,"08:27:48",9);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (5,"07:25:07",4);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (8,"17:13:23",4);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (9,"20:16:47",10);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (10,"02:46:52",9);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (1,"09:30:40",8);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (3,"07:26:52",5);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (6,"13:45:42",6);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (3,"13:01:55",4);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (2,"07:07:33",10);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (2,"23:23:29",2);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (5,"22:03:40",6);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (5,"21:46:41",1);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (5,"18:51:23",7);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (1,"23:03:48",9);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (8,"16:36:23",7);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (1,"07:57:04",8);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (3,"19:00:09",3);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (10,"00:37:00",7);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (4,"11:36:48",2);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (3,"03:07:34",2);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (4,"07:14:22",7);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (2,"19:54:48",10);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (5,"02:55:00",3);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (9,"22:29:41",3);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (8,"18:17:32",10);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (7,"19:24:49",2);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (6,"02:37:41",7);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (1,"21:16:59",4);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (3,"03:34:52",8);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (4,"20:52:37",10);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (1,"08:46:25",7);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (3,"12:25:09",5);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (6,"09:55:41",8);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (6,"07:30:51",3);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (7,"13:53:46",10);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (7,"11:13:21",3);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (1,"14:51:15",2);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (10,"08:24:01",7);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (7,"02:25:30",4);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (5,"23:01:01",10);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (3,"10:59:48",10);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (9,"20:27:50",2);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (7,"04:02:02",10);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (2,"22:05:05",2);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (7,"01:12:39",3);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (8,"03:05:26",10);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (10,"06:50:44",4);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (6,"09:11:26",3);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (3,"00:49:10",7);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (7,"09:43:31",9);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (2,"16:20:37",3);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (1,"14:56:55",4);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (10,"13:11:10",5);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (2,"03:08:58",1);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (7,"20:36:27",7);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (9,"04:36:12",10);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (5,"09:44:07",6);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (7,"08:41:25",9);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (7,"21:15:45",2);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (4,"19:14:20",3);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (6,"04:24:53",7);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (10,"19:05:34",8);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (6,"03:19:24",7);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (1,"11:14:40",5);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (8,"19:25:10",2);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (2,"22:54:57",10);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (2,"06:15:31",10);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (5,"18:33:52",10);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (4,"07:52:47",7);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (1,"08:51:05",1);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (7,"02:13:52",1);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (2,"09:50:00",9);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (9,"23:44:38",8);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (10,"14:45:36",8);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (3,"11:43:58",9);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (7,"07:16:00",9);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (8,"10:46:48",6);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (1,"19:01:27",2);
INSERT IGNORE INTO time_table_for_station (train_id,train_timings,station_station_id) VALUES (5,"07:22:22",5);