-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathcreate_database.js
224 lines (197 loc) · 76.8 KB
/
create_database.js
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
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
var mysql = require('mysql');
db_config = {
host: "remotemysql.com",
user: "lHyGk3wWaK",
password: "IAahckiJYJ",
database: "lHyGk3wWaK",
multipleStatements: true
}
function runQuery(callback, query) {
console.log("Query Run/ :"+query);
result = con.query(query, function (err, result) {
if (err)
{
console.log(err);
callback(null);
return;
} else {
// console.log(result);
// console.log(callback);
if(callback!=null)
callback(result);
}
});
}
function handleDisconnect() {
con = mysql.createConnection(db_config); // Recreate the connection, since
// the old one cannot be reused.
con.connect(function(err) { // The server is either down
if(err) { // or restarting (takes a while sometimes).
console.log('error when connecting to db:', err);
setTimeout(handleDisconnect, 2000); // We introduce a delay before attempting to reconnect,
} // to avoid a hot loop, and to allow our node script to
}); // process asynchronous requests in the meantime.
// If you're also serving http, display a 503 error.
con.on('error', function(err) {
console.log('db error', err);
if(err.code == 'PROTOCOL_CONNECTION_LOST' || err.code == 'ECONNRESET') { // Connection to the MySQL server is usually
handleDisconnect(); // lost due to either server restart, or a
} else { // connnection idle timeout (the wait_timeout
throw err; // server variable configures this)
}
});
}
queryRun=0;
callback = function(result) {
queryRun++;
console.log("done"+queryRun);
}
function createDatabase() {
runQuery(callback, 'drop table if exists visited;')
runQuery(callback, 'drop table if exists wishlist;')
runQuery(callback, 'drop table if exists query;')
runQuery(callback, 'drop table if exists service_request;')
runQuery(callback, 'drop table if exists trip;')
runQuery(callback, 'drop table if exists guide;')
runQuery(callback, 'drop table if exists tourist_spot;')
runQuery(callback, 'drop table if exists route;')
runQuery(callback, 'drop table if exists bus;')
runQuery(callback, 'drop table if exists train;')
runQuery(callback, 'drop table if exists taxi;')
runQuery(callback, 'drop table if exists flight;')
runQuery(callback, 'drop table if exists food_Item;')
runQuery(callback, 'drop table if exists food_item;')
runQuery(callback, 'drop table if exists restaurant;')
runQuery(callback, 'drop table if exists room;')
runQuery(callback, 'drop table if exists hotel;')
runQuery(callback, 'drop table if exists service;')
runQuery(callback, 'drop table if exists service_provider;')
runQuery(callback, 'drop table if exists administrator;')
runQuery(callback, 'drop table if exists user;')
runQuery(callback, 'drop table if exists location;')
runQuery(callback, 'create table if not exists location (location_id char(8) primary key,locality varchar(100) not null,city varchar(100) not null,state varchar(100) not null,country varchar(100) not null,check (location_id like \"LOC%\"));')
runQuery(callback, 'create table if not exists user(user_id char(8) primary key,name varchar(100) not null,email varchar(100) not null,password varchar(100) not null,address varchar(100),phone_no char(10),location_id char(8),active char(1),foreign key(location_id) references location(location_id),check (user_id like \"USR%\"),check(active in (\"Y\", \"N\")));')
runQuery(callback, 'create table if not exists administrator(admin_id char(8) primary key,name varchar(100) not null, role varchar(100) not null,email varchar(100) not null,password varchar(100),check(admin_id like \"ADM%\"));')
runQuery(callback, 'create table if not exists service_provider(approved char(1),service_provider_id char(8) primary key,name varchar(100),password varchar(20),domain varchar(20),active char(1),check ((service_provider_id like \"HOT%\" and domain like \"hotel\") or (service_provider_id like \"RES%\" and domain like \"restaurant\") or(service_provider_id like \"AIR%\" and domain like \"airline\") or (service_provider_id like \"TAP%\" and domain like \"taxi provider\") or (service_provider_id like \"BPR%\" and domain like \"bus provider\") or (service_provider_id like \"TRP%\" and domain like \"train provider\") or (service_provider_id like \"GUP%\" and domain like \"guide provider\")),check(active in (\"Y\", \"N\")), check(approved in (\"Y\",\"N\")) );')
runQuery(callback, 'create table if not exists service(service_id char(8) primary key,service_provider_id char(8),price float,discount int,foreign key (service_provider_id) references service_provider(service_provider_id),check (discount >= 0 and discount <= 100),check ((service_provider_id like \"HOT%\" and service_id like \"ROO%\") or (service_provider_id like \"RES%\" and service_id like \"FOO%\") or(service_provider_id like \"AIR%\" and service_id like \"FLI%\") or (service_provider_id like \"TAP%\" and service_id like \"TAX%\") or (service_provider_id like \"BPR%\" and service_id like \"BUS%\") or (service_provider_id like \"TRP%\" and service_id like \"TRA%\") or (service_provider_id like \"GUP%\" and service_id like \"GUI%\") ));')
runQuery(callback, 'create table if not exists hotel(service_provider_id char(8) primary key,location_id char(8),wifi_facility char(1),star int,foreign key (service_provider_id) references service_provider(service_provider_id),foreign key(location_id) references location(location_id),check (service_provider_id like \"HOT%\"),check (wifi_facility in (\"Y\", \"N\")),check (star >= 0 and star <= 5));')
runQuery(callback, 'create table if not exists room(service_id char(8) primary key,room_type varchar(100),capacity int,ac char(1),check(service_id like \"ROO%\"),foreign key(service_id) references service(service_id),check (capacity >= 1),check (ac in (\"Y\", \"N\")));')
runQuery(callback, 'create table if not exists restaurant(service_provider_id char(8) primary key,location_id char(8),delivers char(1),cuisine varchar(100),foreign key (service_provider_id) references service_provider(service_provider_id),check (service_provider_id like \"RES%\"),foreign key(location_id) references location(location_id),check (delivers in (\"Y\", \"N\")));')
runQuery(callback, 'create table if not exists food_item(service_id char(8) primary key,name varchar(100),cuisine varchar(100),foreign key(service_id) references service(service_id),check (service_id like \"FOO%\"));')
runQuery(callback, 'create table if not exists flight(service_id char(8) primary key,from_city varchar(100),to_city varchar(100),departure_time time,arrival_time time,foreign key(service_id) references service(service_id),check (service_id like \"FLI%\"),check (departure_time < arrival_time));')
runQuery(callback, 'create table if not exists taxi(service_id char(8) primary key,car_name varchar(100),capacity int,AC char(1),foreign key(service_id) references service(service_id),check (service_id like \"TAX%\"),check (capacity >= 0),check (AC in (\"Y\", \"N\")));')
runQuery(callback, 'create table if not exists bus(service_id char(8) primary key,from_location_id char(8),to_location_id char(8),active_days char(7),AC char(1),foreign key(service_id) references service(service_id),check (service_id like \"BUS%\"),foreign key(from_location_id) references location(location_id),foreign key(to_location_id) references location(location_id),check (active_days like \"[YN][YN][YN][YN][YN][YN][YN]\"),check (AC in (\"Y\", \"N\")));')
runQuery(callback, 'create table if not exists train(service_id char(8) primary key,from_location_id char(8),to_location_id char(8),active_days char(7),AC char(1),foreign key(service_id) references service(service_id),check (service_id like \"BUS%\"),foreign key(from_location_id) references location(location_id),foreign key(to_location_id) references location(location_id),check (active_days like \"[YN][YN][YN][YN][YN][YN][YN]\"),check (AC in (\"Y\", \"N\")));')
runQuery(callback, 'create table if not exists route (service_id char(8),location_id char(8),arrival_time time,primary key (service_id, location_id),foreign key(service_id) references service(service_id),foreign key(location_id) references location(location_id));')
runQuery(callback, 'create table if not exists tourist_spot (tourist_spot_id char(8) primary key,name varchar(100),location_id char(8),type varchar(100),entry_fee float,foreign key(location_id) references location(location_id));')
runQuery(callback, 'create table if not exists guide (service_id char(8) primary key,name varchar(100),tourist_spot_id char(8),foreign key(service_id) references service(service_id),check (service_id like \"GUI%\"),foreign key(tourist_spot_id) references tourist_spot(tourist_spot_id));')
runQuery(callback, 'create table if not exists trip (trip_id char(8) primary key,user_id char(8),departure_date date,return_date date,destination_city varchar(100),foreign key(user_id) references user(user_id));')
runQuery(callback, 'create table if not exists service_request (request_id char(8) primary key,trip_id char(8),service_id char(8) not null,request_timestamp datetime,quantity int not null,cost int not null,status varchar(15) not null,user_rating int,service_rating int,comments varchar(1000),service_required_date date,number_days int,completion_date datetime,foreign key(trip_id) references trip(trip_id),foreign key(service_id) references service(service_id),check (status in (\"Pending\", \"Accepted\", \"Rejected\", \"Completed\", \"Paid\")),check (user_rating >= 0 and user_rating <= 5),check (service_rating >= 0 and service_rating <= 5));')
runQuery(callback, 'create table if not exists query (query_id char(8), user_id char(8), service_provider_id char(8), timestamp datetime, query varchar(100), side char(1), foreign key(user_id) references user(user_id), foreign key(service_provider_id) references service_provider(service_provider_id), check (side in (\"S\", \"U\")));')
runQuery(callback, 'create table if not exists wishlist (user_id char(8), tourist_spot_id char(8), primary key(user_id, tourist_spot_id), foreign key(user_id) references user(user_id), foreign key(tourist_spot_id) references tourist_spot(tourist_spot_id))');
runQuery(callback, 'create table if not exists visited (trip_id char(8), tourist_spot_id char(8), primary key(trip_id, tourist_spot_id), foreign key(trip_id) references trip(trip_id), foreign key(tourist_spot_id) references tourist_spot(tourist_spot_id))');
runQuery(callback,'INSERT INTO location VALUES(\'LOC00000\',\'pangong lake\',\'ladakh\',\'J&K\',\'India\'),(\'LOC00001\',\'Zanskar Valley\',\'ladakh\',\'J&K\',\'India\'),(\'LOC00002\',\'Tso Moriri\',\'ladakh\',\'J&K\',\'India\'),(\'LOC00003\',\'Ladakh\',\'ladakh\',\'J&K\',\'India\'),(\'LOC00004\',\'Leh\',\'Leh\',\'J&K\',\'India\'),(\'LOC00005\',\'Srinagar\',\'Srinagar\',\'J&K\',\'India\'),(\'LOC00006\',\'Dal Lake\',\'Srinagar\',\'J&K\',\'India\'),(\'LOC00007\',\'Shalimar Bagh\',\'Srinagar\',\'J&K\',\'India\'),(\'LOC00008\',\'Shimla\',\'Shimla\',\'Himachal Pradesh\',\'India\'),(\'LOC00009\',\'Rishikesh\',\'Dehradun\',\'Uttrakhand\',\'India\'),(\'LOC00010\',\'Badrinath\',\'Chamoli\',\'Uttrakhand\',\'India\'),(\'LOC00011\',\'Haridwar\',\'Haridwar\',\'Uttrakhand\',\'India\'),(\'LOC00012\',\'Amritsar\',\'Amritsar\',\'Punjab\',\'India\'),(\'LOC00013\',\'Golden Temple\',\'Amritsar\',\'Punjab\',\'India\'),(\'LOC00014\',\'Wagah Border\',\'Amritsar\',\'Punjab\',\'India\'),(\'LOC00015\',\'Delhi\',\'Delhi \',\'Delhi\',\'India\'),(\'LOC00016\',\'Red Fort\',\'Delhi \',\'Delhi\',\'India\'),(\'LOC00017\',\'Qutub Minar\',\'Delhi \',\'Delhi\',\'India\'),(\'LOC00018\',\'India Gate\',\'Delhi \',\'Delhi\',\'India\'),(\'LOC00019\',\'Jodhpur\',\'Jodhpur\',\'Rajasthan\',\'India\'),(\'LOC00020\',\'Agra\',\'Agra \',\'Uttar Pradesh\',\'India\'),(\'LOC00021\',\'Fatehpur Sikri\',\'Agra \',\'Uttar Pradesh\',\'India\'),(\'LOC00022\',\'Agra Fort\',\'Agra \',\'Uttar Pradesh\',\'India\'),(\'LOC00023\',\'Shivpui\',\'Shivpuri\',\'Madhya Pradesh\',\'India\'),(\'LOC00024\',\'Sanchi \',\'Raisen\',\'Madhya Pradesh\',\'India\'),(\'LOC00025\',\'Kanha National Park\',\'Balaghat\',\'Madhya Pradesh\',\'India\'),(\'LOC00026\',\'Mount Abu\',\'Sirohi\',\'Rajasthan\',\'India\'),(\'LOC00027\',\'Abu Road\',\'Sirohi\',\'Rajasthan\',\'India\'),(\'LOC00028\',\'Gir National Park\',\'Junagadh\',\'Gujrat\',\'India\'),(\'LOC00029\',\'Mumbai\',\'Mumbai\',\'Maharashtra\',\'India\'),(\'LOC00030\',\'Navi Mumbai\',\'Thane\',\'Maharashtra\',\'India\'),(\'LOC00031\',\'Marine Drive\',\'Mumbai\',\'Maharashtra\',\'India\'),(\'LOC00032\',\'Ellora Caves\',\'Aurangabad\',\'Maharashtra\',\'India\'),(\'LOC00033\',\'Ajanta Caves\',\'Aurangabad\',\'Maharashtra\',\'India\'),(\'LOC00034\',\'Panjim\',\'Goa\',\'Goa\',\'India\'),(\'LOC00035\',\'Calangute\',\'North Panji\',\'Goa\',\'India\'),(\'LOC00036\',\'Vijaypura\',\'Bijapur\',\'Karnataka\',\'India\'),(\'LOC00037\',\'Hampi\',\'Ballari\',\'Karnataka\',\'India\'),(\'LOC00038\',\'Hydrabad\',\'Hydrabad\',\'Telangana\',\'India\'),(\'LOC00039\',\'Vishakhapatnam\',\'Vishakhapatnam\',\'Andhra Pradesh\',\'India\'),(\'LOC00040\',\'Shillong\',\'Shillong\',\'Meghalaya\',\'India\'),(\'LOC00041\',\'Kaziranga\',\'Karbi Anglong\',\'Assam\',\'India\'),(\'LOC00042\',\'Chennai\',\'Chennai\',\'Tamil Nadu\',\'India\'),(\'LOC00043\',\'Vadodara\',\'Vadodara\',\'Gujarat\',\'India\'),(\'LOC00044\',\'Ahmedabad\',\'Ahmedabad\',\'Gujarat\',\'India\'),(\'LOC00045\',\'Bangalore\',\'Bangalore\',\'Karnataka\',\'India\'),(\'LOC00046\',\'Kolkata\',\'Kolkata\',\'West Bengal\',\'India\'),(\'LOC00047\',\'Pune\',\'Pune\',\'Maharashtra\',\'India\'),(\'LOC00048\',\'Hydrabad\',\'Hyderabad\',\'Telangana\',\'India\'),(\'LOC00049\',\'dadar\',\'Mumbai\',\'Maharashtra\',\'India\'),(\'LOC00050\',\'ambala\',\'haryana\',\'Haryana\',\'India\'),(\'LOC00051\',\'jalandahar\',\'punjab\',\'punjab\',\'India\'),(\'LOC00052\',\'kashi\',\'Varanasi\',\'Uttar Pradesh\',\'India\'),(\'LOC00053\',\'Udhagamandalam\',\'Nilgri\',\'Tamil Nadu\',\'India\'),(\'LOC00054\',\'Tirumala Tirupati Balaji Temple\',\'Tirupati\',\'Andhra Pradesh\',\'India\'),(\'LOC00055\',\'Munar\',\'Madhurai\',\'kerala\',\'India\'),(\'LOC00056\',\'shirdi\',\'Mumbai\',\'Maharashtra\',\'India\'),(\'LOC00057\',\'Alleppey\',\'kerala\',\'kerala\',\'India\'),(\'LOC00058\',\'Darjeeling\',\'Bengal\',\'Bengal\',\'India\'),(\'LOC00059\',\'Rameshwaram\',\'Tamil Nadu\',\'Tamil Nadu\',\'India\'),(\'LOC00060\',\'Pondicherry \',\'Chennai\',\'Chennai\',\'India\'),(\'LOC00061\',\'Puri\',\'Bay of Bengal\',\'odisha\',\'India\'),(\'LOC00062\',\'kovalam\',\'kerala\',\'kerala\',\'India\'),(\'LOC00063\',\'Kodaikanal\',\'Tamil Nadu\',\'Tamil Nadu\',\'India\'),(\'LOC00064\',\'Thekaddy\',\'kerala\',\'kerala\',\'India\'),(\'LOC00065\',\'Khajuraho \',\'Madhya Pradesh\',\'Madhya Paradesh\',\'India\'),(\'LOC00066\',\'Kaziranga \',\'Assam\',\'Assam\',\'India\'),(\'LOC00067\',\'Chikmagalur\',\'Karnataka\',\'Karnataka\',\'India\'),(\'LOC00068\',\'Sabarimala\',\'kerala\',\'kerala\',\'India\'),(\'LOC00069\',\'konark\',\'Bay of Bengal\',\'odisha\',\'India\'),(\'LOC00070\',\'Dharmshala\',\'Himachal Pradesh\',\'Himachal Pradesh\',\'India\');')
runQuery(callback,'INSERT INTO user VALUES(\'USR00000\',\'Neeraf \',\'[email protected]\',\'Nera333\',\'138, Angappa Naicken St, Parrys Chennai, Tamil Nadu, 600001\',4425229885,\'LOC00042\',\'Y\'),(\'USR00001\',\'Ekambar \',\'[email protected]\',\'pyasf3333\',\'M 9, Part 1, Greater Kailash Delhi, Delhi, 110048\',1129234950,\'LOC00015\',\'Y\'),(\'USR00002\',\'Sankalpa \',\'[email protected]\',\'pfasdre3333\',\'18/19, Alkapuri, 18/19, Alkapuri Vadodara, Gujarat, 390007\',2652337966,\'LOC00043\',\'Y\'),(\'USR00003\',\'Fatik \',\'[email protected]\',\'pyarsdfae33\',\'136, Narayan Dhuru Street, Masjid Bunder Mumbai, Maharashtra, 400003\',2223450058,\'LOC00029\',\'Y\'),(\'USR00004\',\'Shashimohan \',\'[email protected]\',\'pyargf3333\',\'Shop No 9, Stn, Nr Silky, Santacruz (west) Mumbai, Maharashtra, 400054\',2226052751,\'LOC00029\',\'Y\'),(\'USR00005\',\'Bhuvanesh\',\'[email protected]\',\'pyare33dsf33\',\'Shop No 6, D/14, Yogi Nagar, Eksar Road, Borivali (west) Mumbai, Maharashtra, 400091\',3222898524,\'LOC00029\',\'Y\'),(\'USR00006\',\'Tripurari \',\'[email protected]\',\'pyare333dfs3\',\'21c, Pkt-3, Mig Flat, Mayur Vihar Delhi, Delhi, 110096\',1122615327,\'LOC00015\',\'Y\'),(\'USR00007\',\'Mangal \',\'[email protected]\',\'pyare3fdsa333\',\'173, Sarvoday Comm Centre, Salapose Road, Nr Gpo, Ahmedabad, Gujarat, 380001\',7925504021,\'LOC00044\',\'Y\'),(\'USR00008\',\'Raghupati \',\'[email protected]\',\'pyare3fd333\',\'36, 16th Cross C M H Road, Lakshmipuram, Ulsoor Bangalore, Karnataka, 560008\',4425575389,\'LOC00045\',\'Y\'),(\'USR00009\',\'Daiwik \',\'[email protected]\',\'pyare33df33\',\'Prasad Heights, 43 Somnath Nagar, Vadgaonsheri, Pune, Maharashtra, 411014\',9242703174,\'LOC00047\',\'Y\'),(\'USR00010\',\'Gagan\',\'[email protected]\',\'pyare3df333\',\'167- P, Rashbehari Avenue, Ballygunj, Kolkata, West Bengal, 700019\',8489245681,\'LOC00046\',\'Y\'),(\'USR00011\',\'Jagadbandu \',\'[email protected]\',\'jagaasasda\',\'84, Devloped Indl Estate, Perungudi, Chennai, Tamil Nadu, 600096\',2684405124,\'LOC00042\',\'Y\'),(\'USR00012\',\'Uday\',\'[email protected]\',\'uda234\',\'27, Heavy Water Colony, Chhani Jakat Naka, Vadodara, Gujarat, 390002\',3424961708,\'LOC00043\',\'Y\'),(\'USR00013\',\'Viswas \',\'[email protected]\',\'viswasasdadada\',\'24 Temple Road, Agaram Chennai, Tamil Nadu, 600082\',3525378703,\'LOC00042\',\'Y\'),(\'USR00014\',\'Saket \',\'[email protected]\',\'saket67787777\',\'15 & 16, Richmond Town, Bangalore, Karnataka, 560025\',8022220296,\'LOC00045\',\'Y\'),(\'USR00015\',\'Jusal \',\'[email protected]\',\'jusal1231231\',\'5, 100 Ft Rd, Vysys Bank Colony, B T M Bangalore, Karnataka, 560076\',8726687005,\'LOC00045\',\'Y\'),(\'USR00016\',\'Kunjabihari \',\'[email protected]\',\'kunjklklklasdf\',\'22, Royapettah High Road, Royapettah, Chennai, Tamil Nadu, 600014\',9721623577,\'LOC00042\',\'Y\'),(\'USR00017\',\'Ottakoothan \',\'[email protected]\',\'ottak1113\',\'1-8-303/69/3, S P Road, Hyderabad, Telangana, 500003\',4428114197,\'LOC00048\',\'Y\'),(\'USR00018\',\'Naval \',\'[email protected]\',\'naval1111\',\'1a Chirag Mansion, Khetwadi Back Rd, Khetwadi, Mumbai, Maharashtra, 400004\',4027849319,\'LOC00029\',\'Y\'),(\'USR00019\',\'Pyaremohan \',\'[email protected]\',\'pyare3333\',\'420, Shri Ram Bhawan, Chandni Chowk Delhi, Delhi, 110006\',1123928452,\'LOC00015\',\'Y\');')
runQuery(callback,'INSERT INTO administrator VALUES(\'ADM00000\',\'vekine\',\'Admin\',\'[email protected]\',\'vekine123\'),(\'ADM00001\',\'Quest\',\'Service providers communications\',\'[email protected]\',\'quet123\'),(\'ADM00002\',\'koneu\',\'Service providers communications\',\'[email protected]\',\'koeneu123\'),(\'ADM00003\',\'beqone\',\'Service providers communications\',\'[email protected]\',\'bequone123\'),(\'ADM00004\',\'Keao\',\'Statistician\',\'[email protected]\',\'keao123\'),(\'ADM00005\',\'heotin\',\'Official Paperwork\',\'[email protected]\',\'heotin123\'),(\'ADM00006\',\'Joegit\',\'User Information handling\',\'[email protected]\',\'joegit123\'),(\'ADM00007\',\'vibege\',\'User Information handling\',\'[email protected]\',\'vubege123\'),(\'ADM00008\',\'lenyber\',\'Suggestions Implementation\',\'[email protected]\',\'lenyber123\'),(\'ADM00009\',\'niceher\',\'Respondent for user queries\',\'[email protected]\',\'niceher123\'),(\'ADM00010\',\'sivepec\',\'Respondent for user queries\',\'[email protected]\',\'sivepec123\'),(\'ADM00011\',\'jesotun\',\'Verification of guides\',\'[email protected]\',\'jesotn123\'),(\'ADM00012\',\'pedakij\',\'Tourist Spots Verification\',\'[email protected]\',\'pedakij123\'),(\'ADM00013\',\'zedart\',\'Tourist Spots Verification\',\'[email protected]\',\'zedart0123\'),(\'ADM00014\',\'bali\',\'Editor\',\'[email protected]\',\'bali123\'),(\'ADM00015\',\'baljik\',\'Editor\',\'[email protected]\',\'baljik123\'),(\'ADM00016\',\'hamy\',\'Verification of guides\',\'[email protected]\',\'hamy123\'),(\'ADM00017\',\'jamy\',\'Official Paperwork\',\'[email protected]\',\'jamy123\'),(\'ADM00018\',\'tomi\',\'Statistician\',\'[email protected]\',\'tomi123\'),(\'ADM00019\',\'gujak\',\'Statistician\',\'[email protected]\',\'gujak123\'),(\'ADM00020\',\'harmion\',\'Official Paperwork\',\'[email protected]\',\'harmion123\');')
runQuery(callback,'INSERT INTO service_provider VALUES(\'Y\',\'BPR00000\',\'kat\',\'kat345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00001\',\'tak\',\'tak345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00002\',\'sohail\',\'sohail345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00003\',\'mohan\',\'mohan345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00004\',\'sohan\',\'sohan345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00005\',\'rohan\',\'rohan345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00006\',\'bhol\',\'bhol345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00007\',\'dol\',\'dhol345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00008\',\'gol\',\'gol345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00009\',\'bol\',\'bol345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00010\',\'sop\',\'sop345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00011\',\'cop\',\'cop345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00012\',\'hanry\',\'hanry345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00013\',\'tom\',\'tom345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00014\',\'jerry\',\'jerry345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00015\',\'spider\',\'spider345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00016\',\'map\',\'map345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00017\',\'bat\',\'bat345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00018\',\'darry\',\'darry345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00019\',\'darfy\',\'darfy345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00020\',\'goryf\',\'goryf345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00021\',\'jokey\',\'jokey345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00022\',\'holli\',\'holli345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00023\',\'follo\',\'follo345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00024\',\'bonu\',\'bonu345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00025\',\'goldu\',\'goldu345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00026\',\'loadu\',\'loadu345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00027\',\'mogai\',\'mogai345\',\'Bus Provider\',\'Y\'),(\'Y\',\'BPR00028\',\'jobin\',\'jobin345\',\'Bus Provider\',\'Y\');')
runQuery(callback,'INSERT INTO service_provider VALUES(\'Y\',\'AIR00000\',\'fog\',\'fog456\',\'Airline\',\'Y\'),(\'Y\',\'AIR00001\',\'gol\',\'gol456\',\'Airline\',\'Y\'),(\'Y\',\'AIR00002\',\'sonu\',\'sonu456\',\'Airline\',\'Y\'),(\'Y\',\'AIR00003\',\'farry\',\'farry456\',\'Airline\',\'Y\'),(\'Y\',\'AIR00004\',\'hanti\',\'hanti456\',\'Airline\',\'Y\'),(\'Y\',\'AIR00005\',\'sot\',\'sot456\',\'Airline\',\'Y\'),(\'Y\',\'AIR00006\',\'ewi\',\'ewi456\',\'Airline\',\'Y\'),(\'Y\',\'AIR00007\',\'ftgf\',\'ftgf456\',\'Airline\',\'Y\'),(\'Y\',\'AIR00008\',\'goli\',\'goli456\',\'Airline\',\'Y\'),(\'Y\',\'AIR00009\',\'roli\',\'roli456\',\'Airline\',\'Y\'),(\'Y\',\'AIR00010\',\'doop\',\'doop456\',\'Airline\',\'Y\'),(\'Y\',\'AIR00011\',\'Vivanta\',\'Vivanta456\',\'Airline\',\'Y\'),(\'Y\',\'AIR00012\',\'oogy\',\'oogy456\',\'Airline\',\'Y\'),(\'Y\',\'AIR00013\',\'mooood\',\'mooood456\',\'Airline\',\'Y\'),(\'Y\',\'AIR00014\',\'vood\',\'vood456\',\'Airline\',\'Y\'),(\'Y\',\'AIR00015\',\'joof\',\'joof456\',\'Airline\',\'Y\'),(\'Y\',\'AIR00016\',\'gooj\',\'gooj456\',\'Airline\',\'Y\'),(\'Y\',\'AIR00017\',\'look\',\'look456\',\'Airline\',\'Y\'),(\'Y\',\'AIR00018\',\'goldy\',\'goldy456\',\'Airline\',\'Y\'),(\'Y\',\'AIR00019\',\'golden\',\'golden456\',\'Airline\',\'Y\'),(\'Y\',\'AIR00020\',\'hjkio\',\'hjkio456\',\'Airline\',\'Y\'),(\'Y\',\'AIR00021\',\'bhj\',\'bhj456\',\'Airline\',\'Y\'),(\'Y\',\'AIR00022\',\'bjka\',\'bjka456\',\'Airline\',\'Y\'),(\'Y\',\'AIR00023\',\'kkl\',\'kkl456\',\'Airline\',\'Y\');')
runQuery(callback,'INSERT INTO service_provider VALUES(\'Y\',\'TAP00000\',\'fsadf\',\'fsadf234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00001\',\'asdf\',\'asdf234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00002\',\'asdfe\',\'asdfe234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00003\',\'ffd\',\'ffd234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00004\',\'hgs\',\'hgs234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00005\',\'fe\',\'fe234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00006\',\'asdfg\',\'asdfg234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00007\',\'sdfg\',\'sdfg234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00008\',\'fdgds\',\'fdgds234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00009\',\'daby\',\'daby234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00010\',\'daiy\',\'daby234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00011\',\'abs\',\'abs234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00012\',\'bcd\',\'bcd234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00013\',\'cde\',\'cde234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00014\',\'def\',\'def234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00015\',\'efg\',\'efg234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00016\',\'fgh\',\'fgh234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00017\',\'ghi\',\'ghi234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00018\',\'hij\',\'hij234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00019\',\'ijk\',\'ijk234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00020\',\'jkl\',\'jkl234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00021\',\'klm\',\'klm234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00022\',\'lmn\',\'lmn234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00023\',\'mno\',\'mno234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00024\',\'nop\',\'nop234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00025\',\'opq\',\'opq234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00026\',\'pqr\',\'pqr234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00027\',\'qrs\',\'qrs234\',\'Taxi Provider\',\'Y\'),(\'Y\',\'TAP00028\',\'rst\',\'rst234\',\'Taxi Provider\',\'Y\');')
runQuery(callback,'INSERT INTO service_provider VALUES(\'Y\',\'TRP00000\',\'dgy\',\'dgy567\',\'Train Provider\',\'Y\'),(\'Y\',\'TRP00001\',\'bruno\',\'bruno567\',\'Train Provider\',\'Y\'),(\'Y\',\'TRP00002\',\'hanrr\',\'hanrr567\',\'Train Provider\',\'Y\'),(\'Y\',\'TRP00003\',\'jacck\',\'jacck567\',\'Train Provider\',\'Y\'),(\'Y\',\'TRP00004\',\'kaf\',\'kaf567\',\'Train Provider\',\'Y\'),(\'Y\',\'TRP00005\',\'jaf\',\'jaf567\',\'Train Provider\',\'Y\'),(\'Y\',\'TRP00006\',\'daf\',\'daf567\',\'Train Provider\',\'Y\'),(\'Y\',\'TRP00007\',\'gah\',\'gah567\',\'Train Provider\',\'Y\'),(\'Y\',\'TRP00008\',\'hui\',\'hui567\',\'Train Provider\',\'Y\'),(\'Y\',\'TRP00009\',\'noody\',\'noody567\',\'Train Provider\',\'Y\'),(\'Y\',\'TRP00010\',\'truc\',\'truc567\',\'Train Provider\',\'Y\'),(\'Y\',\'TRP00011\',\'banc\',\'banc567\',\'Train Provider\',\'Y\'),(\'Y\',\'TRP00012\',\'hju\',\'hju567\',\'Train Provider\',\'Y\'),(\'Y\',\'TRP00013\',\'dfy\',\'dfy567\',\'Train Provider\',\'Y\'),(\'Y\',\'TRP00014\',\'dcv\',\'dcv567\',\'Train Provider\',\'Y\'),(\'Y\',\'TRP00015\',\'rty\',\'rty567\',\'Train Provider\',\'Y\'),(\'Y\',\'TRP00016\',\'kopp\',\'kopp567\',\'Train Provider\',\'Y\'),(\'Y\',\'TRP00017\',\'koppy\',\'koppy567\',\'Train Provider\',\'Y\'),(\'Y\',\'TRP00018\',\'kapu\',\'kapu567\',\'Train Provider\',\'Y\'),(\'Y\',\'TRP00019\',\'klop\',\'klop567\',\'Train Provider\',\'Y\');')
runQuery(callback,'INSERT INTO service_provider VALUES(\'Y\',\'RES00000\',\'gooby\',\'gooby789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00001\',\'comb\',\'comb789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00002\',\'bom\',\'bom789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00003\',\'tooop\',\'tooop789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00004\',\'gooory\',\'gooory789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00005\',\'suri\',\'suri789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00006\',\'sudi\',\'sudi789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00007\',\'gooku\',\'gooku789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00008\',\'dooku\',\'dooku789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00009\',\'rummy\',\'rummy789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00010\',\'bunny\',\'bunny789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00011\',\'goosy\',\'goosy789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00012\',\'sory\',\'sory789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00013\',\'dee\',\'dee789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00014\',\'bee\',\'bee789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00015\',\'gee\',\'gee789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00016\',\'gelu\',\'gelu789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00017\',\'abus\',\'abus789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00018\',\'smil\',\'smil789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00019\',\'adbdul\',\'adbdul789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00020\',\'vohn\',\'vohn789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00021\',\'vohmu\',\'vohmu789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00022\',\'choi\',\'vhoi789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00023\',\'fooky\',\'fooky789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00024\',\'gluudy\',\'gluudy789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00025\',\'hine\',\'hine789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00026\',\'bonyyy\',\'bonyyy789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00027\',\'dasyyyy\',\'dasyyyy789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00028\',\'chittt\',\'chittt789\',\'Restaurant\',\'Y\'),(\'Y\',\'RES00029\',\'loagyui\',\'loagyui789\',\'Restaurant\',\'Y\');')
runQuery(callback,'INSERT INTO service_provider VALUES(\'Y\',\'GUP00000\',\'aquamann\',\'aquamann44\',\'Guide Provider\',\'Y\'),(\'Y\',\'GUP00001\',\'joks\',\'joks44\',\'Guide Provider\',\'Y\'),(\'Y\',\'GUP00002\',\'manup\',\'manup44\',\'Guide Provider\',\'Y\'),(\'Y\',\'GUP00003\',\'scuuby\',\'scuuby44\',\'Guide Provider\',\'Y\'),(\'Y\',\'GUP00004\',\'boof\',\'boof44\',\'Guide Provider\',\'Y\'),(\'Y\',\'GUP00005\',\'hell2\',\'hell244\',\'Guide Provider\',\'Y\'),(\'Y\',\'GUP00006\',\'hell1\',\'hell144\',\'Guide Provider\',\'Y\'),(\'Y\',\'GUP00007\',\'goog\',\'goog44\',\'Guide Provider\',\'Y\'),(\'Y\',\'GUP00008\',\'joffy\',\'joffy44\',\'Guide Provider\',\'Y\'),(\'Y\',\'GUP00009\',\'juney\',\'juney44\',\'Guide Provider\',\'Y\'),(\'Y\',\'GUP00010\',\'buney\',\'buney44\',\'Guide Provider\',\'Y\'),(\'Y\',\'GUP00011\',\'foggggggy\',\'foggggggy44\',\'Guide Provider\',\'Y\'),(\'Y\',\'GUP00012\',\'rabbit\',\'rabbit44\',\'Guide Provider\',\'Y\'),(\'Y\',\'GUP00013\',\'fooooogg\',\'fooooogg44\',\'Guide Provider\',\'Y\'),(\'Y\',\'GUP00014\',\'toyyyyy\',\'toyyyyy44\',\'Guide Provider\',\'Y\'),(\'Y\',\'GUP00015\',\'boooolu\',\'boooolu44\',\'Guide Provider\',\'Y\'),(\'Y\',\'GUP00016\',\'aqua\',\'aqua44\',\'Guide Provider\',\'Y\'),(\'Y\',\'GUP00017\',\'asfsaa\',\'asfsaa44\',\'Guide Provider\',\'Y\'),(\'Y\',\'GUP00018\',\'voif\',\'voif44\',\'Guide Provider\',\'Y\'),(\'Y\',\'GUP00019\',\'hojiji\',\'hojiji44\',\'Guide Provider\',\'Y\'),(\'Y\',\'GUP00020\',\'qubek\',\'qubek44\',\'Guide Provider\',\'Y\'),(\'Y\',\'GUP00021\',\'ebi\',\'ebi44\',\'Guide Provider\',\'Y\'),(\'Y\',\'GUP00022\',\'usiiii\',\'usiiii44\',\'Guide Provider\',\'Y\');')
runQuery(callback,'INSERT INTO service VALUES(\'BUS00000\',\'BPR00000\',4000,5),(\'BUS00001\',\'BPR00001\',2000,10),(\'BUS00002\',\'BPR00002\',6000,15),(\'BUS00003\',\'BPR00003\',7000,20),(\'BUS00004\',\'BPR00004\',3000,40),(\'BUS00005\',\'BPR00005\',4000,20),(\'BUS00006\',\'BPR00006\',8000,5),(\'BUS00007\',\'BPR00007\',5000,10),(\'BUS00008\',\'BPR00008\',4000,15),(\'BUS00009\',\'BPR00009\',5000,20),(\'BUS00010\',\'BPR00010\',6000,5),(\'BUS00011\',\'BPR00011\',5000,10),(\'BUS00012\',\'BPR00012\',4000,0),(\'BUS00013\',\'BPR00013\',8000,5),(\'BUS00014\',\'BPR00014\',2000,0),(\'BUS00015\',\'BPR00015\',2000,40),(\'BUS00016\',\'BPR00016\',2000,20),(\'BUS00017\',\'BPR00017\',2000,20),(\'BUS00018\',\'BPR00018\',5000,5),(\'BUS00019\',\'BPR00019\',4000,10),(\'BUS00020\',\'BPR00020\',3000,10),(\'BUS00021\',\'BPR00021\',3000,10),(\'BUS00022\',\'BPR00022\',3000,10),(\'BUS00023\',\'BPR00023\',3000,10),(\'BUS00024\',\'BPR00024\',3000,10),(\'BUS00025\',\'BPR00025\',3000,10),(\'BUS00026\',\'BPR00026\',3000,10),(\'BUS00027\',\'BPR00027\',3000,10),(\'BUS00028\',\'BPR00028\',3000,10);')
runQuery(callback,'INSERT INTO service VALUES(\'TAX00000\',\'TAP00000\',1500,5),(\'TAX00001\',\'TAP00001\',1200,0),(\'TAX00002\',\'TAP00002\',3000,10),(\'TAX00003\',\'TAP00003\',1500,10),(\'TAX00004\',\'TAP00004\',1600,5),(\'TAX00005\',\'TAP00005\',2200,10),(\'TAX00006\',\'TAP00006\',2000,10),(\'TAX00007\',\'TAP00007\',1800,5),(\'TAX00008\',\'TAP00008\',1200,0),(\'TAX00009\',\'TAP00009\',1500,10);')
runQuery(callback,'INSERT INTO service VALUES(\'TRA00000\',\'TRP00000\',8000,5),(\'TRA00001\',\'TRP00001\',4000,10),(\'TRA00002\',\'TRP00002\',5000,0),(\'TRA00003\',\'TRP00003\',6000,10),(\'TRA00004\',\'TRP00004\',7000,5),(\'TRA00005\',\'TRP00005\',4500,10),(\'TRA00006\',\'TRP00006\',5000,15),(\'TRA00007\',\'TRP00007\',6000,0),(\'TRA00008\',\'TRP00008\',8000,50),(\'TRA00009\',\'TRP00009\',7000,20),(\'TRA00010\',\'TRP00010\',6000,30),(\'TRA00011\',\'TRP00011\',4000,20),(\'TRA00012\',\'TRP00012\',8000,40),(\'TRA00013\',\'TRP00013\',9000,20),(\'TRA00014\',\'TRP00014\',10000,20),(\'TRA00015\',\'TRP00015\',5000,10);')
runQuery(callback,'INSERT INTO service VALUES(\'FOO00000\',\'RES00001\',200,0),(\'FOO00001\',\'RES00002\',40,0),(\'FOO00002\',\'RES00003\',250,5),(\'FOO00003\',\'RES00004\',180,10),(\'FOO00004\',\'RES00005\',350,0),(\'FOO00005\',\'RES00006\',50,0),(\'FOO00006\',\'RES00007\',80,5),(\'FOO00007\',\'RES00008\',320,15),(\'FOO00008\',\'RES00009\',60,20),(\'FOO00009\',\'RES00010\',80,0),(\'FOO00010\',\'RES00011\',300,0),(\'FOO00011\',\'RES00012\',250,0),(\'FOO00012\',\'RES00013\',180,0),(\'FOO00013\',\'RES00014\',120,5),(\'FOO00014\',\'RES00015\',300,10),(\'FOO00015\',\'RES00016\',350,10),(\'FOO00016\',\'RES00017\',400,15),(\'FOO00017\',\'RES00018\',200,5),(\'FOO00018\',\'RES00019\',60,5),(\'FOO00019\',\'RES00020\',45,0),(\'FOO00020\',\'RES00021\',70,5),(\'FOO00021\',\'RES00022\',140,0),(\'FOO00022\',\'RES00023\',220,10),(\'FOO00023\',\'RES00024\',200,0),(\'FOO00024\',\'RES00025\',150,0),(\'FOO00025\',\'RES00026\',120,5),(\'FOO00026\',\'RES00027\',40,0),(\'FOO00027\',\'RES00028\',200,10),(\'FOO00028\',\'RES00000\',1000,5),(\'FOO00029\',\'RES00001\',250,5),(\'FOO00030\',\'RES00012\',500,5),(\'FOO00031\',\'RES00013\',400,5),(\'FOO00032\',\'RES00017\',700,5),(\'FOO00033\',\'RES00018\',300,5),(\'FOO00034\',\'RES00021\',400,5),(\'FOO00035\',\'RES00022\',500,5),(\'FOO00036\',\'RES00025\',600,5),(\'FOO00037\',\'RES00001\',700,5),(\'FOO00038\',\'RES00012\',70,5),(\'FOO00039\',\'RES00013\',800,5),(\'FOO00040\',\'RES00017\',100,5),(\'FOO00041\',\'RES00018\',700,5),(\'FOO00042\',\'RES00021\',70,5),(\'FOO00043\',\'RES00022\',80,5),(\'FOO00044\',\'RES00025\',400,5),(\'FOO00045\',\'RES00001\',90,5),(\'FOO00046\',\'RES00012\',900,5),(\'FOO00047\',\'RES00013\',750,5),(\'FOO00048\',\'RES00017\',740,5),(\'FOO00049\',\'RES00018\',730,5),(\'FOO00050\',\'RES00002\',720,5),(\'FOO00051\',\'RES00011\',700,5),(\'FOO00052\',\'RES00016\',80,5),(\'FOO00053\',\'RES00002\',80,5),(\'FOO00054\',\'RES00011\',800,5),(\'FOO00055\',\'RES00016\',787,5),(\'FOO00056\',\'RES00002\',460,5),(\'FOO00057\',\'RES00011\',705,5),(\'FOO00058\',\'RES00016\',701,5),(\'FOO00059\',\'RES00002\',75,5),(\'FOO00060\',\'RES00011\',700,5),(\'FOO00061\',\'RES00016\',710,5),(\'FOO00062\',\'RES00002\',720,5),(\'FOO00063\',\'RES00011\',730,5),(\'FOO00064\',\'RES00016\',740,5),(\'FOO00065\',\'RES00002\',75,5),(\'FOO00066\',\'RES00011\',760,5),(\'FOO00067\',\'RES00016\',770,5),(\'FOO00068\',\'RES00002\',780,5),(\'FOO00069\',\'RES00003\',710,5),(\'FOO00070\',\'RES00014\',720,5),(\'FOO00071\',\'RES00027\',730,5),(\'FOO00072\',\'RES00003\',740,5),(\'FOO00073\',\'RES00014\',750,5),(\'FOO00074\',\'RES00027\',760,5),(\'FOO00075\',\'RES00003\',770,5),(\'FOO00076\',\'RES00014\',780,5),(\'FOO00077\',\'RES00027\',790,5),(\'FOO00078\',\'RES00003\',710,5),(\'FOO00079\',\'RES00014\',80,5),(\'FOO00080\',\'RES00027\',810,5),(\'FOO00081\',\'RES00003\',820,5),(\'FOO00082\',\'RES00014\',830,5),(\'FOO00083\',\'RES00003\',710,5),(\'FOO00084\',\'RES00014\',700,5),(\'FOO00085\',\'RES00027\',750,5),(\'FOO00086\',\'RES00003\',710,5),(\'FOO00087\',\'RES00014\',720,5),(\'FOO00088\',\'RES00027\',730,5),(\'FOO00089\',\'RES00003\',740,5),(\'FOO00090\',\'RES00014\',750,5),(\'FOO00091\',\'RES00004\',760,5),(\'FOO00092\',\'RES00015\',770,5),(\'FOO00093\',\'RES00028\',780,5),(\'FOO00094\',\'RES00004\',790,5),(\'FOO00095\',\'RES00015\',700,5),(\'FOO00096\',\'RES00028\',700,5),(\'FOO00097\',\'RES00004\',70,5),(\'FOO00098\',\'RES00015\',700,5),(\'FOO00099\',\'RES00028\',70,5),(\'FOO00100\',\'RES00004\',700,5),(\'FOO00101\',\'RES00015\',701,5),(\'FOO00102\',\'RES00028\',702,5),(\'FOO00103\',\'RES00004\',740,5),(\'FOO00104\',\'RES00015\',750,5),(\'FOO00105\',\'RES00028\',70,5),(\'FOO00106\',\'RES00004\',80,5),(\'FOO00107\',\'RES00015\',90,5),(\'FOO00108\',\'RES00028\',50,5),(\'FOO00109\',\'RES00005\',60,5),(\'FOO00110\',\'RES00019\',20,5),(\'FOO00111\',\'RES00000\',200,5),(\'FOO00112\',\'RES00005\',720,5),(\'FOO00113\',\'RES00019\',60,5),(\'FOO00114\',\'RES00000\',40,5),(\'FOO00115\',\'RES00005\',30,5),(\'FOO00116\',\'RES00019\',90,5),(\'FOO00117\',\'RES00000\',30,5),(\'FOO00118\',\'RES00005\',20,5),(\'FOO00119\',\'RES00019\',70,5),(\'FOO00120\',\'RES00029\',820,5),(\'FOO00121\',\'RES00005\',720,5),(\'FOO00122\',\'RES00019\',750,5),(\'FOO00123\',\'RES00000\',40,5),(\'FOO00124\',\'RES00005\',770,5),(\'FOO00125\',\'RES00019\',550,5),(\'FOO00126\',\'RES00006\',660,5),(\'FOO00127\',\'RES00020\',590,5),(\'FOO00128\',\'RES00006\',100,5),(\'FOO00129\',\'RES00020\',700,5),(\'FOO00130\',\'RES00006\',70,5),(\'FOO00131\',\'RES00020\',700,5),(\'FOO00132\',\'RES00006\',700,5),(\'FOO00133\',\'RES00020\',100,5),(\'FOO00134\',\'RES00006\',50,5),(\'FOO00135\',\'RES00020\',720,5),(\'FOO00136\',\'RES00006\',730,5),(\'FOO00137\',\'RES00020\',740,5),(\'FOO00138\',\'RES00006\',750,5),(\'FOO00139\',\'RES00020\',760,5),(\'FOO00140\',\'RES00006\',770,5),(\'FOO00141\',\'RES00020\',780,5),(\'FOO00142\',\'RES00006\',790,5),(\'FOO00143\',\'RES00020\',800,5),(\'FOO00144\',\'RES00006\',810,5),(\'FOO00145\',\'RES00020\',610,5),(\'FOO00146\',\'RES00006\',670,5),(\'FOO00147\',\'RES00020\',670,5),(\'FOO00148\',\'RES00006\',570,5),(\'FOO00149\',\'RES00020\',570,5),(\'FOO00150\',\'RES00007\',470,5),(\'FOO00151\',\'RES00023\',470,5),(\'FOO00152\',\'RES00007\',570,5),(\'FOO00153\',\'RES00023\',370,5),(\'FOO00154\',\'RES00007\',370,5),(\'FOO00155\',\'RES00023\',270,5),(\'FOO00156\',\'RES00007\',270,5),(\'FOO00157\',\'RES00023\',170,5),(\'FOO00158\',\'RES00007\',170,5),(\'FOO00159\',\'RES00023\',70,5),(\'FOO00160\',\'RES00007\',970,5),(\'FOO00161\',\'RES00023\',970,5),(\'FOO00162\',\'RES00007\',870,5),(\'FOO00163\',\'RES00023\',870,5),(\'FOO00164\',\'RES00007\',770,5),(\'FOO00165\',\'RES00023\',770,5),(\'FOO00166\',\'RES00007\',770,5),(\'FOO00167\',\'RES00023\',760,5),(\'FOO00168\',\'RES00007\',706,5),(\'FOO00169\',\'RES00023\',706,5),(\'FOO00170\',\'RES00007\',570,5),(\'FOO00171\',\'RES00023\',470,5),(\'FOO00172\',\'RES00007\',370,5),(\'FOO00173\',\'RES00023\',270,5),(\'FOO00174\',\'RES00007\',170,5),(\'FOO00175\',\'RES00023\',70,5),(\'FOO00176\',\'RES00007\',170,5),(\'FOO00177\',\'RES00008\',1170,5),(\'FOO00178\',\'RES00024\',1070,5),(\'FOO00179\',\'RES00008\',470,5),(\'FOO00180\',\'RES00024\',970,5),(\'FOO00181\',\'RES00008\',170,5),(\'FOO00182\',\'RES00024\',270,5),(\'FOO00183\',\'RES00008\',370,5),(\'FOO00184\',\'RES00024\',470,5),(\'FOO00185\',\'RES00008\',570,5),(\'FOO00186\',\'RES00024\',670,5),(\'FOO00187\',\'RES00008\',770,5),(\'FOO00188\',\'RES00024\',870,5),(\'FOO00189\',\'RES00008\',970,5),(\'FOO00190\',\'RES00009\',170,5),(\'FOO00191\',\'RES00009\',270,5),(\'FOO00192\',\'RES00009\',370,5),(\'FOO00193\',\'RES00009\',740,5),(\'FOO00194\',\'RES00009\',750,5),(\'FOO00195\',\'RES00009\',760,5),(\'FOO00196\',\'RES00009\',770,5),(\'FOO00197\',\'RES00009\',780,5),(\'FOO00198\',\'RES00009\',790,5),(\'FOO00199\',\'RES00009\',710,5),(\'FOO00200\',\'RES00010\',720,5),(\'FOO00201\',\'RES00026\',720,5),(\'FOO00202\',\'RES00010\',730,5),(\'FOO00203\',\'RES00026\',710,5),(\'FOO00204\',\'RES00010\',790,5),(\'FOO00205\',\'RES00026\',70,5),(\'FOO00206\',\'RES00010\',750,5),(\'FOO00207\',\'RES00026\',740,5),(\'FOO00208\',\'RES00010\',70,5),(\'FOO00209\',\'RES00026\',20,5);')
runQuery(callback,'INSERT INTO service VALUES(\'GUI00000\',\'GUP00001\',1000,10),(\'GUI00001\',\'GUP00002\',1700,5),(\'GUI00002\',\'GUP00003\',2700,15),(\'GUI00003\',\'GUP00004\',1000,5),(\'GUI00004\',\'GUP00005\',2000,10),(\'GUI00005\',\'GUP00006\',1800,5),(\'GUI00006\',\'GUP00007\',1700,0),(\'GUI00007\',\'GUP00008\',1560,15),(\'GUI00008\',\'GUP00009\',1300,10),(\'GUI00009\',\'GUP00010\',1200,10),(\'GUI00010\',\'GUP00011\',1200,5),(\'GUI00011\',\'GUP00012\',1100,20),(\'GUI00012\',\'GUP00013\',1300,10),(\'GUI00013\',\'GUP00014\',1600,0),(\'GUI00014\',\'GUP00015\',7700,5),(\'GUI00015\',\'GUP00016\',6700,10),(\'GUI00016\',\'GUP00017\',4000,5),(\'GUI00017\',\'GUP00018\',3500,10),(\'GUI00018\',\'GUP00019\',5700,10),(\'GUI00019\',\'GUP00020\',5100,5),(\'GUI00020\',\'GUP00021\',500,10),(\'GUI00021\',\'GUP00022\',590,10);')
runQuery(callback,'INSERT INTO tourist_spot VALUES(\'TOR00000\',\'pangong lake\',\'LOC00000\',\'lake\',300),(\'TOR00001\',\'Zanskar Valley\',\'LOC00001\',\'Valley\',400),(\'TOR00002\',\'Tso Moriri\',\'LOC00002\',\'lake\',400),(\'TOR00003\',\'Ladakh\',\'LOC00003\',\'trekking snow\',500),(\'TOR00004\',\'Leh\',\'LOC00004\',\'trekking,snow\',500),(\'TOR00005\',\'Srinagar\',\'LOC00005\',\'trekking snow\',500),(\'TOR00006\',\'Dal Lake\',\'LOC00006\',\'Lake\',500),(\'TOR00007\',\'Shalimar Bagh\',\'LOC00007\',\'shopping\',400),(\'TOR00008\',\'Shimla\',\'LOC00008\',\'side seeing, snowfall\',400),(\'TOR00009\',\'Rishikesh\',\'LOC00019\',\'center for studying yoga and meditation\',400),(\'TOR00010\',\'Badrinath\',\'LOC00010\',\'religious place\',400),(\'TOR00011\',\'Haridwar\',\'LOC00011\',\'river junction and visiting ganga\',300),(\'TOR00012\',\'Amritsar\',\'LOC00012\',\'visiting various gurdwaras\',400),(\'TOR00013\',\'Golden Temple\',\'LOC00013\',\'sikhs gurudwara religious \',500),(\'TOR00014\',\'Wagah Border\',\'LOC00014\',\'Border\',400),(\'TOR00015\',\'Delhi\',\'LOC00015\',\'visiting various monuments and fast life\',500),(\'TOR00016\',\'Red Fort\',\'LOC00016\',\'Fort\',400),(\'TOR00017\',\'Qutub Minar\',\'LOC00017\',\'Minar\',300),(\'TOR00018\',\'India Gate\',\'LOC00018\',\'Gate\',400),(\'TOR00019\',\'Jodhpur\',\'LOC00019\',\'museum for paintings, old historical guns\',300),(\'TOR00020\',\'Agra\',\'LOC00020\',\'museums and monuments\',400),(\'TOR00021\',\'Fatehpur Sikri\',\'LOC00021\',\'Sikri\',300),(\'TOR00022\',\'Agra Fort\',\'LOC00022\',\'Fort\',300),(\'TOR00023\',\'Shivpui\',\'LOC00023\',\'monuments\',200),(\'TOR00024\',\'Sanchi \',\'LOC00024\',\'budha sculptures\',300),(\'TOR00025\',\'Kanha National Park\',\'LOC00025\',\'park\',400),(\'TOR00026\',\'Mount Abu\',\'LOC00026\',\'hill station\',300),(\'TOR00027\',\'Abu Road\',\'LOC00027\',\'Road\',100),(\'TOR00028\',\'Gir National Park\',\'LOC00028\',\'park\',400),(\'TOR00029\',\'Mumbai\',\'LOC00029\',\'gateway of india\',500),(\'TOR00030\',\'Navi Mumbai\',\'LOC00030\',\'fast life and beach\',400),(\'TOR00031\',\'Marine Drive\',\'LOC00031\',\'beach\',500),(\'TOR00032\',\'Ellora Caves\',\'LOC00032\',\'Caves\',400),(\'TOR00033\',\'Ajanta Caves\',\'LOC00033\',\'Caves\',400),(\'TOR00034\',\'Panjim\',\'LOC00034\',\'beach\',400),(\'TOR00035\',\'Calangute\',\'LOC00035\',\'beach\',500),(\'TOR00036\',\'Vijaypura\',\'LOC00036\',\'food binge city\',400),(\'TOR00037\',\'Hampi\',\'LOC00037\',\'group of monuments\',300),(\'TOR00038\',\'Hydrabad\',\'LOC00038\',\'fort and palace\',200),(\'TOR00039\',\'Vishakhapatnam\',\'LOC00039\',\'indian coastal services\',300),(\'TOR00040\',\'Shillong\',\'LOC00040\',\'hill station\',400),(\'TOR00041\',\'Kaziranga\',\'LOC00041\',\'park\',100);')
runQuery(callback,'INSERT INTO restaurant VALUES(\'RES00000\',\'LOC00004\',\'Y\',\'north indian\'),(\'RES00001\',\'LOC00003\',\'Y\',\'south indian\'),(\'RES00002\',\'LOC00005\',\'Y\',\'chinese\'),(\'RES00003\',\'LOC00008\',\'Y\',\'mughlai\'),(\'RES00004\',\'LOC00011\',\'Y\',\'italian\'),(\'RES00005\',\'LOC00008\',\'Y\',\'continental\'),(\'RES00006\',\'LOC00012\',\'Y\',\'american\'),(\'RES00007\',\'LOC00015\',\'Y\',\'greek\'),(\'RES00008\',\'LOC00019\',\'N\',\'british\'),(\'RES00009\',\'LOC00020\',\'N\',\'french\'),(\'RES00010\',\'LOC00019\',\'Y\',\'south indian\'),(\'RES00011\',\'LOC00023\',\'Y\',\'north indian\'),(\'RES00012\',\'LOC00029\',\'N\',\'north indian\'),(\'RES00013\',\'LOC00038\',\'Y\',\'chinese\'),(\'RES00014\',\'LOC00039\',\'N\',\'mughlai\'),(\'RES00015\',\'LOC00040\',\'N\',\'south indian\'),(\'RES00016\',\'LOC00020\',\'Y\',\'north indian\'),(\'RES00017\',\'LOC00015\',\'N\',\'north indian\'),(\'RES00018\',\'LOC00020\',\'Y\',\'italian\'),(\'RES00019\',\'LOC00008\',\'Y\',\'continental\'),(\'RES00020\',\'LOC00019\',\'Y\',\'north indian\'),(\'RES00021\',\'LOC00038\',\'Y\',\'north indian\'),(\'RES00022\',\'LOC00003\',\'Y\',\'american\'),(\'RES00023\',\'LOC00012\',\'Y\',\'greek\'),(\'RES00024\',\'LOC00004\',\'Y\',\'north indian\'),(\'RES00025\',\'LOC00005\',\'Y\',\'french\'),(\'RES00026\',\'LOC00003\',\'Y\',\'chinese\'),(\'RES00027\',\'LOC00020\',\'Y\',\'mughlai\'),(\'RES00028\',\'LOC00040\',\'Y\',\'italian\');')
runQuery(callback,'INSERT INTO food_item VALUES(\'FOO00000\',\'Dal Makhni\',\'north indian\'),(\'FOO00001\',\'Dosa\',\'south indian\'),(\'FOO00002\',\'Hakka Noodles\',\'chinese\'),(\'FOO00003\',\'Butter Chicken\',\'mughlai\'),(\'FOO00004\',\'Cheese Pizza\',\'italian\'),(\'FOO00005\',\'Bagels\',\'continental\'),(\'FOO00006\',\'French Toast\',\'american\'),(\'FOO00007\',\'Amygdalota\',\'greek\'),(\'FOO00008\',\'Bread\',\'british\'),(\'FOO00009\',\'French Toast\',\'french\'),(\'FOO00010\',\'Masala Dosa\',\'south indian\'),(\'FOO00011\',\'Malai Kofta\',\'north indian\'),(\'FOO00012\',\'Malai Kofta\',\'north indian\'),(\'FOO00013\',\'Tomato Soup\',\'chinese\'),(\'FOO00014\',\'Tandoori Chicken\',\'mughlai\'),(\'FOO00015\',\'Idli\',\'south indian\'),(\'FOO00016\',\'Aloo Gobhi\',\'north indian\'),(\'FOO00017\',\'Aloo Matar\',\'north indian\'),(\'FOO00018\',\'Margherita\',\'italian\'),(\'FOO00019\',\'Aloo Tikki Burger\',\'continental\'),(\'FOO00020\',\'Bhindi\',\'north indian\'),(\'FOO00021\',\'Ghiya\',\'north indian\'),(\'FOO00022\',\'Waffle\',\'american\'),(\'FOO00023\',\'Baklava\',\'greek\'),(\'FOO00024\',\'Malai Kofta\',\'north indian\'),(\'FOO00025\',\'Croissant\',\'french\'),(\'FOO00026\',\'Momos\',\'chinese\'),(\'FOO00027\',\'Butter chicken\',\'mughlai\'),(\'FOO00028\',\'Farmhouse Pizza\',\'italian\'),(\'FOO00029\',\'Awadhi Biryani\',\'north indian\'),(\'FOO00030\',\'chole Bhature\',\'north indian\'),(\'FOO00031\',\'Naan/rumali roti\',\'north indian\'),(\'FOO00032\',\'chicken butter Masala\',\'north indian\'),(\'FOO00033\',\'Murg Makhni\',\'north indian\'),(\'FOO00034\',\'Liti chokha\',\'north indian\'),(\'FOO00035\',\'Baigan Bhartha\',\'north indian\'),(\'FOO00036\',\'Kashmiri dam allo\',\'north indian\'),(\'FOO00037\',\'tikka masala\',\'north indian\'),(\'FOO00038\',\'tandhori chicken\',\'north indian\'),(\'FOO00039\',\'parathe\',\'north indian\'),(\'FOO00040\',\'Rajma chawal\',\'north indian\'),(\'FOO00041\',\'papad ki sabji\',\'north indian\'),(\'FOO00042\',\'sarso ka saag or makki ki roti\',\'north indian\'), (\'FOO00043\',\'Rogan Josh/Laal Maans\',\'north indian\'),(\'FOO00044\',\'dahi vadha\',\'north indian\'),(\'FOO00045\',\'kadhi\',\'north indian\'),(\'FOO00046\',\'rabhri\',\'north indian\'),(\'FOO00047\',\'Aam ka murabha\',\'north indian\'),(\'FOO00048\',\'ghewar\',\'north indian\'),(\'FOO00049\',\'lassi\',\'north indian\'),(\'FOO00050\',\'masala vadha\',\'south indian\'),(\'FOO00051\',\'keerai vadhai\',\'south indian\'),(\'FOO00052\',\'APPAM WITH TANGA PAL/KURMA\',\'south indian\'),(\'FOO00053\',\'PUTTU\',\'south indian\'),(\'FOO00054\',\'PESARATTU\',\'south indian\'),(\'FOO00055\',\'RASAM RICE\',\'south indian\'),(\'FOO00056\',\'BISIBELEBHATH\',\'south indian\'),(\'FOO00057\',\'PULIYOGARE\',\'south indian\'),(\'FOO00058\',\'PAZHAM PORI\',\'south indian\'),(\'FOO00059\',\' VATHA KUZHAMBU\',\'south indian\'),(\'FOO00060\',\'PESARAPAPPU PAYASAM\',\'south indian\'),(\'FOO00061\',\'UTTAPPAM\',\'south indian\'),(\'FOO00062\',\' RAVA IDLY\',\'south indian\'),(\'FOO00063\',\'ONION RAVA DOSA\',\'south indian\'),(\'FOO00064\',\'ADIRASAM\',\'south indian\'),(\'FOO00065\',\'VANGI BATH\',\'south indian\'),(\'FOO00066\',\'BIRIYANI\',\'south indian\'),(\'FOO00067\',\'GONGKURA\',\'south indian\'),(\'FOO00068\',\'MYSORE BONDA\',\'south indian\'),(\'FOO00069\',\'stuffed Eggplant with schezwan Sauce\',\'chinese\'),(\'FOO00070\',\'almond and chicken momos\',\'chinese\'),(\'FOO00071\',\'peri peri chicken satay\',\'chinese\'),(\'FOO00072\',\'veg fried rice\',\'chinese\'),(\'FOO00073\',\' honey chilli potato\',\'chinese\'),(\'FOO00074\',\'garlic soya chicken \',\'chinese\'),(\'FOO00075\',\'Mapo tofu with Spring ONion and black beans\',\'chinese\'),(\'FOO00076\',\'Stir fried mushroom\',\'chinese\'),(\'FOO00077\',\'vegetable manchow soup\',\'chinese\'),(\'FOO00078\',\'quick Noodles\',\'chinese\'),(\'FOO00079\',\'chilli fish\',\'chinese\'),(\'FOO00080\',\'Cantonese chiken Soup\',\'chinese\'),(\'FOO00081\',\'Stir fried Tofu with rice\',\'chinese\'),(\'FOO00082\',\'garlic and egg fried RICE\',\'chinese\'),(\'FOO00083\',\'hot and Sour Soup\',\'chinese\'),(\'FOO00084\',\'Asian BBQ chicken\',\'chinese\'),(\'FOO00085\',\'chilli soya Nugets\',\'chinese\'),(\'FOO00086\',\'gDate pancakes\',\'chinese\'),(\'FOO00087\',\'Mushroom Fried rice\',\'chinese\'),(\'FOO00088\',\'chilli Gobhi\',\'chinese\'),(\'FOO00089\',\'okra with baby corn\',\'chinese\'),(\'FOO00090\',\'vegetable chowmein\',\'chinese\'),(\'FOO00091\',\'mughlai parathe\',\'mughlai\'),(\'FOO00092\',\'haleem\',\'mughlai\'),(\'FOO00093\',\'kachri keema\',\'mughlai\'),(\'FOO00094\',\'keema Matar\',\'mughlai\'),(\'FOO00095\',\'Murg Mussalaam\',\'mughlai\'),(\'FOO00096\',\'Murg kali Mirch\',\'mughlai\'),(\'FOO00097\',\'margisi kofta\',\'mughlai\'),(\'FOO00098\',\'reshmi kebab\',\'mughlai\'),(\'FOO00099\',\'murg pasanda\',\'mughlai\'),(\'FOO00100\',\'Muton Rezala\',\'mughlai\'),(\'FOO00101\',\'Mutton rogan josh\',\'mughlai\'),(\'FOO00102\',\'Boti kebab\',\'mughlai\'),(\'FOO00103\',\'kofta Shorba\',\'mughlai\'),(\'FOO00104\',\'Shahi tukra\',\'mughlai\'),(\'FOO00105\',\'anjeer halwa\',\'mughlai\'),(\'FOO00106\',\'sheer khurma\',\'mughlai\'),(\'FOO00107\',\'Shahi kaju aloo\',\'mughlai\'),(\'FOO00108\',\'Murg Noorjehani\',\'mughlai\'),(\'FOO00109\',\'garlic Pizza\',\'italian\'),(\'FOO00110\',\'Bottarga\',\'italian\'),(\'FOO00111\',\'lasagna\',\'italian\'),(\'FOO00112\',\'fiorenrina Steak\',\'italian\'),(\'FOO00113\',\'Ribollita\',\'italian\'),(\'FOO00114\',\'Polenta\',\'italian\'),(\'FOO00115\',\'Ossobuco\',\'italian\'),(\'FOO00116\',\'Risotto\',\'italian\'),(\'FOO00117\',\'Carbonara\',\'italian\'),(\'FOO00118\',\'Truffles\',\'italian\'),(\'FOO00119\',\'Focaccia\',\'italian\'),(\'FOO00120\',\'Araancini\',\'italian\'),(\'FOO00121\',\'Suppli\',\'italian\'),(\'FOO00122\',\'Coffee\',\'italian\'),(\'FOO00123\',\'gelato\',\'italian\'),(\'FOO00124\',\'Tiramisu\',\'italian\'),(\'FOO00125\',\'Digestivo\',\'italian\'),(\'FOO00126\',\'crispy calamari Rings\',\'continental\'),(\'FOO00127\',\'Quick salteed Caramel Pie\',\'continental\'),(\'FOO00128\',\'Sweet Potato Pie\',\'continental\'),(\'FOO00129\',\'Prawn Pie\',\'continental\'),(\'FOO00130\',\'Sticky Toffee Pudding\',\'continental\'),(\'FOO00131\',\'yorkshire Lamb Patties\',\'continental\'),(\'FOO00132\',\'Poached Pear Salad\',\'continental\'),(\'FOO00133\',\'Chicken and cheese salad\',\'continental\'),(\'FOO00134\',\'Sausage and potato casserole\',\'continental\'),(\'FOO00135\',\'Roast lamb salad\',\'continental\'),(\'FOO00136\',\'Stuffed jacket Potatoes\',\'continental\'),(\'FOO00137\',\'The trio of Tomatoes\',\'continental\'),(\'FOO00138\',\'paneer steak\',\'continental\'),(\'FOO00139\',\'Butter fried fish with cheese Sauce\',\'continental\'),(\'FOO00140\',\'BLT eggy bread\',\'continental\'),(\'FOO00141\',\'Batter Fish\',\'continental\'),(\'FOO00142\',\'Baked Vegetables\',\'continental\'),(\'FOO00143\',\'Baked Mushrooms and capsicum\',\'continental\'),(\'FOO00144\',\'East west spring roll\',\'continental\'),(\'FOO00145\',\'Panko crusted cottage cheese\',\'continental\'),(\'FOO00146\',\'chickpea Soup\',\'continental\'),(\'FOO00147\',\'glazed ham\',\'continental\'),(\'FOO00148\',\'Roast turkey with cranberry Sauce\',\'continental\'),(\'FOO00149\',\'Honey roast chicken\',\'continental\'),(\'FOO00150\',\'Bacon Wrapped Dates \',\'american\'),(\'FOO00151\',\'leafy salad with walnuts\',\'american\'),(\'FOO00152\',\'chicken Piccata with Bread salad\',\'american\'),(\'FOO00153\',\'smoked kidney bean salad\',\'american\'),(\'FOO00154\',\'sausage pepper burger\',\'american\'),(\'FOO00155\',\'pineapple cheese and ham salad\',\'american\'),(\'FOO00156\',\'fish mayonnaise\',\'american\'),(\'FOO00157\',\'apple sauce\',\'american\'),(\'FOO00158\',\'date and walnut pie\',\'american\'),(\'FOO00159\',\'Roast leg of ham\',\'american\'),(\'FOO00160\',\'grilled citrus fish\',\'american\'),(\'FOO00161\',\'scotch eggs\',\'american\'),(\'FOO00162\',\'Bacon and herb scones\',\'american\'),(\'FOO00163\',\'hot cross Buns\',\'american\'),(\'FOO00164\',\'grilled lobster eith wine sauce\',\'american\'),(\'FOO00165\',\'chiken pie\',\'american\'),(\'FOO00166\',\'Microwave chicken Steak\',\'american\'),(\'FOO00167\',\'filled cucumber cases\',\'american\'),(\'FOO00168\',\'grilled chicken with shallot sauce\',\'american\'),(\'FOO00169\',\'chicken salad\',\'american\'),(\'FOO00170\',\'Mutton stew\',\'american\'),(\'FOO00171\',\'grilled vegetable capachio\',\'american\'),(\'FOO00172\',\'Mushroom and herb filled tomatoes\',\'american\'),(\'FOO00173\',\'cheese steaks\',\'american\'),(\'FOO00174\',\'lamb steaks\',\'american\'),(\'FOO00175\',\'chicken steak\',\'american\'),(\'FOO00176\',\'bougatsa\',\'greek\'),(\'FOO00177\',\'courgette balls\',\'greek\'),(\'FOO00178\',\'dolmadakia\',\'greek\'),(\'FOO00179\',\'tomatokeftedes\',\'greek\'),(\'FOO00180\',\'ellinikos\',\'greek\'),(\'FOO00181\',\'greek fava dip\',\'greek\'),(\'FOO00182\',\'feta me meli\',\'greek\'),(\'FOO00183\',\'frappe\',\'greek\'),(\'FOO00184\',\'galaktoboureko\',\'greek\'),(\'FOO00185\',\'greek Salad\',\'greek\'),(\'FOO00186\',\'gyros\',\'greek\'),(\'FOO00187\',\'halvas\',\'greek\'),(\'FOO00188\',\'kataifi\',\'greek\'),(\'FOO00189\',\'fish and chips\',\'british\'),(\'FOO00190\',\'the great english Sunday Roast\',\'british\'),(\'FOO00191\',\'Bangers and mash\',\'british\'),(\'FOO00192\',\'yorkshire tea\',\'british\'),(\'FOO00193\',\'toad in the hole\',\'british\'),(\'FOO00194\',\'steak and kideny pie\',\'british\'),(\'FOO00195\',\'spotted dish\',\'british\'),(\'FOO00196\',\'shepherds Pie\',\'british\'),(\'FOO00197\',\'cottage Pie\',\'british\'),(\'FOO00198\',\'bubble and squeaks\',\'british\'),(\'FOO00199\',\'baguette\',\'french\'),(\'FOO00200\',\'beignet\',\'french\'),(\'FOO00201\',\'blanquette\',\'french\'),(\'FOO00202\',\'Bouef Bourguignon\',\'french\'),(\'FOO00203\',\'Bouillabasse\',\'french\'),(\'FOO00204\',\'Brioche\',\'french\'),(\'FOO00205\',\'cassoulet\',\'french\'),(\'FOO00206\',\'champagne\',\'french\'),(\'FOO00207\',\'charcuterie\',\'french\'),(\'FOO00208\',\'chausson aux pommes\',\'french\');')
runQuery(callback,'INSERT INTO taxi VALUES(\'TAX00000\',\'ciaz\',4,\'Y\'),(\'TAX00001\',\'ritz\',4,\'N\'),(\'TAX00002\',\'bmw\',4,\'Y\'),(\'TAX00003\',\'swift\',4,\'Y\'),(\'TAX00004\',\'ciaz\',4,\'Y\'),(\'TAX00005\',\'scorpio\',7,\'Y\'),(\'TAX00006\',\'ertiga\',7,\'Y\'),(\'TAX00007\',\'maruti Eeco\',6,\'N\'),(\'TAX00008\',\'i10\',4,\'Y\'),(\'TAX00009\',\'xuv\',4,\'Y\');')
runQuery(callback,'INSERT INTO route VALUES(\'BUS00000\',\'LOC00031\',\'04:00:00\'),(\'BUS00000\',\'LOC00049\',\'12:00:00\'),(\'BUS00000\',\'LOC00041\',\'20:00:00\'),(\'BUS00000\',\'LOC00018\',\'01:30:00\'),(\'BUS00000\',\'LOC00008\',\'10:30:00\'),(\'BUS00001\',\'LOC00032\',\'01:00:00\'),(\'BUS00001\',\'LOC00018\',\'05:00:00\'),(\'BUS00001\',\'LOC00050\',\'09:00:00\'),(\'BUS00001\',\'LOC00007\',\'14:30:00\'),(\'BUS00001\',\'LOC00035\',\'06:00:00\'),(\'BUS00002\',\'LOC00019\',\'12:00:00\'),(\'BUS00002\',\'LOC00018\',\'16:00:00\'),(\'BUS00002\',\'LOC00005\',\'20:00:00\'),(\'BUS00003\',\'LOC00015\',\'08:00:00\'),(\'BUS00003\',\'LOC00027\',\'12:00:00\'),(\'BUS00003\',\'LOC00030\',\'16:00:00\'),(\'BUS00004\',\'LOC00015\',\'01:00:00\'),(\'BUS00004\',\'LOC00017\',\'02:00:00\'),(\'BUS00004\',\'LOC00018\',\'03:00:00\'),(\'BUS00004\',\'LOC00026\',\'08:00:00\'),(\'BUS00005\',\'LOC00019\',\'21:00:00\'),(\'BUS00005\',\'LOC00044\',\'24:00:00\'),(\'BUS00005\',\'LOC00030\',\'06:00:00\'),(\'BUS00006\',\'LOC00029\',\'05:00:00\'),(\'BUS00006\',\'LOC00044\',\'10:00:00\'),(\'BUS00006\',\'LOC00046\',\'15:00:00\'),(\'BUS00006\',\'LOC00033\',\'23:00:00\'),(\'BUS00007\',\'LOC00001\',\'09:00:00\'),(\'BUS00007\',\'LOC00002\',\'10:00:00\'),(\'BUS00007\',\'LOC00004\',\'14:00:00\'),(\'BUS00007\',\'LOC00008\',\'16:00:00\'),(\'BUS00008\',\'LOC00018\',\'07:00:00\'),(\'BUS00008\',\'LOC00020\',\'11:00:00\'),(\'BUS00008\',\'LOC00023\',\'14:00:00\'),(\'BUS00009\',\'LOC00015\',\'01:00:00\'),(\'BUS00009\',\'LOC00050\',\'04:00:00\'),(\'BUS00009\',\'LOC00008\',\'10:00:00\'),(\'BUS00009\',\'LOC00001\',\'14:00:00\'),(\'BUS00010\',\'LOC00016\',\'04:00:00\'),(\'BUS00010\',\'LOC00050\',\'08:00:00\'),(\'BUS00010\',\'LOC00008\',\'12:00:00\'),(\'BUS00011\',\'LOC00017\',\'05:00:00\'),(\'BUS00011\',\'LOC00011\',\'10:00:00\'),(\'BUS00012\',\'LOC00018\',\'02:00:00\'),(\'BUS00012\',\'LOC00050\',\'04:00:00\'),(\'BUS00012\',\'LOC00008\',\'10:00:00\'),(\'BUS00012\',\'LOC00001\',\'14:00:00\'),(\'BUS00013\',\'LOC00018\',\'06:00:00\'),(\'BUS00013\',\'LOC00050\',\'10:00:00\'),(\'BUS00013\',\'LOC00008\',\'14:00:00\'),(\'BUS00014\',\'LOC00018\',\'01:00:00\'),(\'BUS00014\',\'LOC00050\',\'04:00:00\'),(\'BUS00014\',\'LOC00008\',\'10:00:00\'),(\'BUS00014\',\'LOC00001\',\'15:00:00\'),(\'BUS00015\',\'LOC00033\',\'04:00:00\'),(\'BUS00015\',\'LOC00018\',\'08:00:00\'),(\'BUS00015\',\'LOC00050\',\'12:00:00\'),(\'BUS00015\',\'LOC00008\',\'18:00:00\'),(\'BUS00015\',\'LOC00001\',\'23:00:00\'),(\'BUS00016\',\'LOC00029\',\'02:00:00\'),(\'BUS00016\',\'LOC00018\',\'01:00:00\'),(\'BUS00016\',\'LOC00050\',\'04:00:00\'),(\'BUS00016\',\'LOC00008\',\'10:00:00\'),(\'BUS00017\',\'LOC00008\',\'03:00:00\'),(\'BUS00017\',\'LOC00050\',\'09:00:00\'),(\'BUS00017\',\'LOC00018\',\'13:00:00\'),(\'BUS00017\',\'LOC00036\',\'16:00:00\'),(\'BUS00018\',\'LOC00015\',\'09:00:00\'),(\'BUS00018\',\'LOC00018\',\'10:00:00\'),(\'BUS00018\',\'LOC00050\',\'14:00:00\'),(\'BUS00018\',\'LOC00008\',\'24:00:00\'),(\'BUS00018\',\'LOC00005\',\'02:00:00\'),(\'BUS00019\',\'LOC00003\',\'07:00:00\'),(\'BUS00019\',\'LOC00018\',\'10:00:00\'),(\'BUS00019\',\'LOC00050\',\'14:00:00\'),(\'BUS00019\',\'LOC00008\',\'24:00:00\'),(\'BUS00019\',\'LOC00037\',\'10:00:00\'),(\'BUS00020\',\'LOC00009\',\'02:00:00\'),(\'BUS00020\',\'LOC00037\',\'08:00:00\'),(\'BUS00020\',\'LOC00038\',\'12:00:00\'),(\'TRA00000\',\'LOC00005\',\'01:00:00\'),(\'TRA00000\',\'LOC00008\',\'16:00:00\'),(\'TRA00000\',\'LOC00031\',\'18:00:00\'),(\'TRA00000\',\'LOC00036\',\'01:00:00\'),(\'TRA00001\',\'LOC00009\',\'12:00:00\'),(\'TRA00001\',\'LOC00050\',\'24:00:00\'),(\'TRA00001\',\'LOC00005\',\'23:00:00\'),(\'TRA00001\',\'LOC00019\',\'12:00:00\'),(\'TRA00001\',\'LOC00032\',\'01:00:00\'),(\'TRA00002\',\'LOC00004\',\'12:00:00\'),(\'TRA00002\',\'LOC00001\',\'14:00:00\'),(\'TRA00002\',\'LOC00050\',\'16:00:00\'),(\'TRA00002\',\'LOC00008\',\'18:00:00\'),(\'TRA00003\',\'LOC00011\',\'20:00:00\'),(\'TRA00003\',\'LOC00051\',\'24:00:00\'),(\'TRA00003\',\'LOC00001\',\'23:00:00\'),(\'TRA00004\',\'LOC00021\',\'01:00:00\'),(\'TRA00004\',\'LOC00008\',\'09:00:00\'),(\'TRA00004\',\'LOC00050\',\'13:00:00\'),(\'TRA00004\',\'LOC00051\',\'18:00:00\'),(\'TRA00004\',\'LOC00001\',\'23:00:00\'),(\'TRA00005\',\'LOC00022\',\'01:00:00\'),(\'TRA00005\',\'LOC00048\',\'05:00:00\'),(\'TRA00005\',\'LOC00033\',\'08:00:00\'),(\'TRA00006\',\'LOC00025\',\'09:00:00\'),(\'TRA00006\',\'LOC00015\',\'16:00:00\'),(\'TRA00006\',\'LOC00050\',\'21:00:00\'),(\'TRA00006\',\'LOC00051\',\'12:00:00\'),(\'TRA00006\',\'LOC00002\',\'18:00:00\'),(\'TRA00007\',\'LOC00035\',\'16:00:00\'),(\'TRA00007\',\'LOC00021\',\'21:00:00\'),(\'TRA00007\',\'LOC00015\',\'24:00:00\'),(\'TRA00008\',\'LOC00036\',\'02:00:00\'),(\'TRA00008\',\'LOC00019\',\'12:00:00\'),(\'TRA00008\',\'LOC00018\',\'13:00:00\'),(\'TRA00008\',\'LOC00015\',\'19:00:00\'),(\'TRA00009\',\'LOC00037\',\'23:00:00\'),(\'TRA00009\',\'LOC00036\',\'12:00:00\'),(\'TRA00009\',\'LOC00019\',\'21:00:00\'),(\'TRA00009\',\'LOC00018\',\'05:00:00\'),(\'TRA00009\',\'LOC00015\',\'08:00:00\'),(\'TRA00010\',\'LOC00001\',\'12:00:00\'),(\'TRA00010\',\'LOC00051\',\'01:00:00\'),(\'TRA00010\',\'LOC00050\',\'12:00:00\'),(\'TRA00010\',\'LOC00015\',\'16:00:00\'),(\'TRA00010\',\'LOC00021\',\'18:00:00\'),(\'TRA00010\',\'LOC00033\',\'20:00:00\'),(\'TRA00011\',\'LOC00001\',\'22:00:00\'),(\'TRA00011\',\'LOC00017\',\'08:00:00\'),(\'TRA00011\',\'LOC00021\',\'05:00:00\'),(\'TRA00011\',\'LOC00025\',\'12:00:00\'),(\'TRA00012\',\'LOC00001\',\'04:00:00\'),(\'TRA00012\',\'LOC00051\',\'06:00:00\'),(\'TRA00012\',\'LOC00050\',\'10:00:00\'),(\'TRA00012\',\'LOC00015\',\'15:00:00\'),(\'TRA00012\',\'LOC00021\',\'18:00:00\'),(\'TRA00012\',\'LOC00025\',\'19:00:00\'),(\'TRA00013\',\'LOC00002\',\'04:00:00\'),(\'TRA00013\',\'LOC00011\',\'12:00:00\'),(\'TRA00013\',\'LOC00021\',\'21:00:00\'),(\'TRA00013\',\'LOC00022\',\'03:00:00\'),(\'TRA00013\',\'LOC00034\',\'12:00:00\'),(\'TRA00014\',\'LOC00025\',\'24:00:00\'),(\'TRA00014\',\'LOC00050\',\'01:00:00\'),(\'TRA00014\',\'LOC00051\',\'11:00:00\'),(\'TRA00014\',\'LOC00001\',\'13:00:00\'),(\'TRA00014\',\'LOC00004\',\'20:00:00\'),(\'TRA00015\',\'LOC00015\',\'02:00:00\'),(\'TRA00015\',\'LOC00022\',\'12:00:00\'),(\'TRA00015\',\'LOC00021\',\'20:00:00\'),(\'TRA00015\',\'LOC00023\',\'04:00:00\');')
runQuery(callback,'INSERT INTO guide VALUES(\'GUI00000\',\'jam\',\'TOR00001\'),(\'GUI00001\',\'rocky\',\'TOR00002\'),(\'GUI00002\',\'heggy\',\'TOR00003\'),(\'GUI00003\',\'kal\',\'TOR00004\'),(\'GUI00004\',\'kailash\',\'TOR00005\'),(\'GUI00005\',\'brack\',\'TOR00006\'),(\'GUI00006\',\'work\',\'TOR00007\'),(\'GUI00007\',\'kat\',\'TOR00008\'),(\'GUI00008\',\'henry\',\'TOR00009\'),(\'GUI00009\',\'goldy\',\'TOR00010\'),(\'GUI00010\',\'boldy\',\'TOR00011\'),(\'GUI00011\',\'koli\',\'TOR00012\'),(\'GUI00012\',\'oxford\',\'TOR00013\'),(\'GUI00013\',\'shabi\',\'TOR00014\'),(\'GUI00014\',\'happy\',\'TOR00015\'),(\'GUI00015\',\'tom\',\'TOR00016\'),(\'GUI00016\',\'rom\',\'TOR00017\'),(\'GUI00017\',\'black\',\'TOR00018\'),(\'GUI00018\',\'jack\',\'TOR00019\'),(\'GUI00019\',\'rahul\',\'TOR00020\'),(\'GUI00020\',\'raj\',\'TOR00021\'),(\'GUI00021\',\'oxford\',\'TOR00022\');')
runQuery(callback,'INSERT INTO trip VALUES(\'TRP00000\',\'USR00000\',\'2020-1-1\',\'2020-1-1\',\'J&K\'),(\'TRP00001\',\'USR00001\',\'2020-1-1\',\'2020-1-2\',\'J&K\'),(\'TRP00002\',\'USR00002\',\'2020-1-2\',\'2020-1-2\',\'J&K\'),(\'TRP00003\',\'USR00003\',\'2020-1-2\',\'2020-1-2\',\'J&K\'),(\'TRP00004\',\'USR00004\',\'2020-1-5\',\'2020-1-5\',\'J&K\'),(\'TRP00005\',\'USR00005\',\'2020-1-5\',\'2020-1-5\',\'J&K\'),(\'TRP00006\',\'USR00006\',\'2020-2-6\',\'2020-2-7\',\'J&K\'),(\'TRP00007\',\'USR00007\',\'2020-2-7\',\'2020-2-7\',\'Shimla\'),(\'TRP00008\',\'USR00008\',\'2020-2-8\',\'2020-2-8\',\'Haridwar\'),(\'TRP00009\',\'USR00009\',\'2020-2-3\',\'2020-2-3\',\'Dehradun\'),(\'TRP00010\',\'USR00010\',\'2020-2-2\',\'2020-2-2\',\'Delhi\'),(\'TRP00011\',\'USR00011\',\'2020-3-2\',\'2020-3-2\',\'Jodhpur\'),(\'TRP00012\',\'USR00012\',\'2020-3-8\',\'2020-3-8\',\'Agra\'),(\'TRP00013\',\'USR00013\',\'2020-3-9\',\'2020-3-9\',\'Shivpui\'),(\'TRP00014\',\'USR00014\',\'2020-3-10\',\'2020-3-10\',\'Mumbai\'),(\'TRP00015\',\'USR00015\',\'2020-3-23\',\'2020-3-24\',\'Hydrabad\'),(\'TRP00016\',\'USR00016\',\'2020-3-10\',\'2020-3-12\',\'Shillong\'),(\'TRP00017\',\'USR00017\',\'2020-4-11\',\'2020-4-12\',\'Agra\'),(\'TRP00018\',\'USR00018\',\'2020-4-15\',\'2020-4-16\',\'Delhi\'),(\'TRP00019\',\'USR00001\',\'2020-4-17\',\'2020-4-18\',\'Agra\'),(\'TRP00020\',\'USR00002\',\'2020-4-17\',\'2020-4-18\',\'Mumbai\'),(\'TRP00021\',\'USR00003\',\'2020-4-3\',\'2020-4-4\',\'Mumbai\'),(\'TRP00022\',\'USR00004\',\'2020-4-14\',\'2020-4-15\',\'Delhi\'),(\'TRP00023\',\'USR00005\',\'2020-5-17\',\'2020-5-19\',\'Shivpui\'),(\'TRP00024\',\'USR00006\',\'2020-5-19\',\'2020-5-19\',\'Delhi\'),(\'TRP00025\',\'USR00007\',\'2020-5-16\',\'2020-5-16\',\'Amritsar\'),(\'TRP00026\',\'USR00008\',\'2020-5-14\',\'2020-5-14\',\'Delhi\'),(\'TRP00027\',\'USR00009\',\'2020-5-12\',\'2020-5-12\',\'Mumbai\'),(\'TRP00028\',\'USR00010\',\'2020-5-11\',\'2020-5-11\',\'Goa\'),(\'TRP00029\',\'USR00011\',\'2020-6-22\',\'2020-6-22\',\'Delhi\'),(\'TRP00030\',\'USR00012\',\'2020-6-21\',\'2020-6-22\',\'Delhi\'),(\'TRP00031\',\'USR00013\',\'2020-6-29\',\'2020-6-30\',\'Agra\'),(\'TRP00032\',\'USR00014\',\'2020-6-28\',\'2020-6-28\',\'Delhi\'),(\'TRP00033\',\'USR00014\',\'2020-7-27\',\'2020-7-27\',\'Haridwar\'),(\'TRP00034\',\'USR00014\',\'2020-7-26\',\'2020-7-26\',\'Mumbai\'),(\'TRP00035\',\'USR00014\',\'2020-7-25\',\'2020-7-26\',\'Aurangabad\'),(\'TRP00036\',\'USR00014\',\'2020-7-22\',\'2020-7-22\',\'Delhi\'),(\'TRP00037\',\'USR00001\',\'2020-8-24\',\'2020-8-24\',\'Goa\'),(\'TRP00038\',\'USR00002\',\'2020-8-23\',\'2020-8-23\',\'Aurangabad\'),(\'TRP00039\',\'USR00003\',\'2020-8-2\',\'2020-8-3\',\'Amritsar\'),(\'TRP00040\',\'USR00004\',\'2020-8-3\',\'2020-8-4\',\'Mumbai\');')
// runQuery(callback,'INSERT INTO service_request VALUES(\'RST00000\',\'TRP00000\',\'ROO00000\',\'2020-01-01 10:10:10\',8,8000,\"Pending\",null,null,null,\'2019-7-1\',1,null),(\'RST00001\',\'TRP00001\',\'ROO00001\',\'2020-01-01 10:10:10\',4,4000,\"Accepted\",null,null,null,\'2019-7-1\',2,null),(\'RST00002\',\'TRP00002\',\'ROO00002\',\'2020-01-01 10:10:10\',5,5000,\"Completed\",4,3,\'excelent service\',\'2019-7-1\',4,\'2020-01-01 10:10:10\'),(\'RST00003\',\'TRP00003\',\'ROO00003\',\'2020-01-01 10:10:10\',4,4000,\"Paid\",4,3,\'Butifull location\',\'2019-7-1\',5,\'2019-08-08 10:10:10\'),(\'RST00004\',\'TRP00004\',\'ROO00004\',\'2020-01-01 10:10:10\',5,5000,\"Completed\",4,3,\'excelent service\',\'2019-7-1\',7,\'2019-07-02 10:10:10\'),(\'RST00005\',\'TRP00005\',\'ROO00005\',\'2020-01-01 10:10:10\',4,3000,\"Completed\",4,3,\'excelent service\',\'2019-7-1\',8,\'2019-07-03 10:10:10\'),(\'RST00006\',\'TRP00006\',\'ROO00006\',\'2020-02-01 10:10:10\',4,2500,\"Completed\",4,3,\'Butifull location\',\'2019-7-1\',4,\'2019-08-04 10:10:10\'),(\'RST00007\',\'TRP00007\',\'ROO00007\',\'2020-02-01 10:10:10\',4,5000,\"Paid\",4,4,\'Butifull location\',\'2019-7-1\',5,\'2020-01-01 10:10:10\'),(\'RST00008\',\'TRP00008\',\'ROO00008\',\'2020-02-01 10:10:10\',1,2000,\"Completed\",4,3,\'excelent service\',\'2019-7-1\',2,\'2019-07-05 10:10:10\'),(\'RST00009\',\'TRP00009\',\'ROO00009\',\'2020-02-01 10:10:10\',2,2500,\"Completed\",4,3,\'excelent service\',\'2019-7-1\',1,\'2020-01-06 10:10:10\'),(\'RST00010\',\'TRP00010\',\'ROO00010\',\'2020-02-01 10:10:10\',7,8000,\"Completed\",3,4,\'Butifull location\',\'2019-7-1\',4,\'2020-01-07 10:10:10\'),(\'RST00011\',\'TRP00011\',\'ROO00011\',\'2020-03-01 10:10:10\',4,4000,\"Paid\",4,4,\'good service\',\'2019-7-1\',9,\'2020-01-08 10:10:10\'),(\'RST00012\',\'TRP00012\',\'ROO00012\',\'2020-03-01 10:10:10\',4,4000,\"Completed\",4,3,\'excelent service\',\'2019-7-1\',1,\'2020-01-09 10:10:10\'),(\'RST00013\',\'TRP00013\',\'ROO00013\',\'2020-03-01 10:10:10\',4,5000,\"Completed\",4,3,\'excelent service\',\'2019-7-1\',2,\'2020-01-10 10:10:10\'),(\'RST00014\',\'TRP00014\',\'ROO00014\',\'2020-03-01 10:10:10\',4,6000,\"Accepted\",null,null,null,\'2019-7-1\',1,null),(\'RST00015\',\'TRP00015\',\'ROO00015\',\'2020-03-01 10:10:10\',4,7000,\"Completed\",2,3,\'good service\',\'2019-7-1\',1,\'2020-01-11 10:10:10\'),(\'RST00016\',\'TRP00016\',\'ROO00016\',\'2020-03-01 10:10:10\',4,1000,\"Rejected\",null,null,null,\'2019-7-1\',2,null),(\'RST00017\',\'TRP00017\',\'ROO00017\',\'2020-04-01 10:10:10\',4,2000,\"Completed\",4,3,\'excelent service\',\'2019-7-1\',3,\'2020-01-11 10:10:10\'),(\'RST00018\',\'TRP00018\',\'ROO00018\',\'2020-04-01 10:10:10\',4,3000,\"Completed\",4,3,\'excelent service\',\'2019-7-1\',2,\'2020-01-13 10:10:10\'),(\'RST00019\',\'TRP00019\',\'ROO00019\',\'2020-04-01 10:10:10\',4,4000,\"Completed\",2,2,\'good service\',\'2019-7-1\',2,\'2020-01-12 10:10:10\'),(\'RST00020\',\'TRP00020\',\'ROO00020\',\'2020-04-01 10:10:10\',4,4000,\"Completed\",4,3,\'excelent service\',\'2019-7-1\',3,\'2020-01-01 10:10:10\'),(\'RST00021\',\'TRP00021\',\'FLI00000\',\'2020-04-01 10:10:10\',4,5000,\"Completed\",4,4,\'good service\',\'2019-7-1\',1,\'2020-01-02 10:10:10\'),(\'RST00022\',\'TRP00022\',\'FLI00001\',\'2020-04-01 10:10:10\',4,6000,\"Completed\",3,3,\'good service\',\'2019-9-1\',2,\'2020-01-03 10:10:10\'),(\'RST00023\',\'TRP00023\',\'FLI00002\',\'2020-05-01 10:10:10\',4,7000,\"Completed\",4,4,\'nice hotel\',\'2019-7-1\',3,\'2020-01-04 10:10:10\'),(\'RST00024\',\'TRP00024\',\'FLI00003\',\'2020-05-01 10:10:10\',4,8000,\"Completed\",4,4,\'nice hotel\',\'2019-7-1\',4,\'2020-01-05 10:10:10\'),(\'RST00025\',\'TRP00025\',\'FLI00004\',\'2020-05-01 10:10:10\',4,9000,\"Completed\",2,3,\'excelent service\',\'2019-7-1\',4,\'2020-01-06 10:10:10\'),(\'RST00026\',\'TRP00026\',\'FLI00005\',\'2020-05-01 10:10:10\',4,1000,\"Completed\",2,4,\'excelent service\',\'2019-7-1\',3,\'2020-01-07 10:10:10\'),(\'RST00027\',\'TRP00027\',\'FLI00006\',\'2020-05-01 10:10:10\',4,2000,\"Completed\",4,3,\'nice hotel\',\'2019-7-1\',4,\'2020-01-03 10:10:10\'),(\'RST00028\',\'TRP00028\',\'FLI00007\',\'2020-06-01 10:10:10\',4,3000,\"Paid\",4,3,\'good service\',\'2019-7-1\',2,\'2020-01-04 10:10:10\'),(\'RST00029\',\'TRP00029\',\'FLI00008\',\'2020-06-01 10:10:10\',4,4000,\"Paid\",3,3,\'excelent service\',\'2019-7-1\',4,\'2020-01-05 10:10:10\'),(\'RST00030\',\'TRP00030\',\'FLI00009\',\'2020-06-01 10:10:10\',4,5000,\"Paid\",3,4,\'excelent service\',\'2019-7-1\',3,\'2020-01-06 10:10:10\'),(\'RST00031\',\'TRP00031\',\'FLI00010\',\'2020-06-01 10:10:10\',4,7000,\"Paid\",3,2,\'nice hotel\',\'2019-7-1\',1,\'2020-01-07 10:10:10\'),(\'RST00032\',\'TRP00032\',\'FLI00011\',\'2020-07-01 10:10:10\',4,8600,\"Paid\",2,3,\'good service\',\'2019-7-1\',5,\'2020-01-02 10:10:10\'),(\'RST00033\',\'TRP00033\',\'FLI00012\',\'2020-07-01 10:10:10\',4,4500,\"Paid\",4,4,\'excelent service\',\'2019-7-1\',4,\'2020-01-02 10:10:10\'),(\'RST00034\',\'TRP00034\',\'FLI00014\',\'2020-07-01 10:10:10\',4,4600,\"Paid\",4,3,\'excelent service\',\'2019-7-1\',3,\'2020-01-03 10:10:10\'),(\'RST00035\',\'TRP00035\',\'FLI00014\',\'2020-07-01 10:10:10\',4,4700,\"Paid\",3,3,\'excelent service\',\'2019-7-1\',2,\'2020-01-02 10:10:10\'),(\'RST00036\',\'TRP00036\',\'FLI00015\',\'2020-07-01 10:10:10\',4,4800,\"Paid\",3,4,\'good service\',\'2019-7-1\',7,\'2020-01-01 10:10:10\'),(\'RST00037\',\'TRP00037\',\'FLI00016\',\'2020-08-01 10:10:10\',4,4900,\"Paid\",4,3,\'excelent service\',\'2019-7-1\',1,\'2020-02-01 10:10:10\'),(\'RST00038\',\'TRP00038\',\'FLI00017\',\'2020-08-01 10:10:10\',4,5000,\"Paid\",3,4,\'nice hotel\',\'2019-7-1\',4,\'2020-03-01 10:10:10\'),(\'RST00039\',\'TRP00039\',\'FLI00018\',\'2020-08-01 10:10:10\',4,2300,\"Paid\",3,4,\'nice hotel\',\'2019-7-1\',2,\'2020-04-01 10:10:10\'),(\'RST00040\',\'TRP00040\',\'FLI00019\',\'2020-08-01 10:10:10\',4,4900,\"Paid\",3,4,\'good service\',\'2020-7-1\',4,\'2020-02-01 10:10:10\'),(\'RST00041\',\'TRP00040\',\'FLI00019\',\'2020-08-01 10:10:10\',4,4900,\"Paid\",3,4,\'good service\',\'2020-7-1\',4,\'2020-01-01 10:10:10\'),(\'RST00042\',\'TRP00040\',\'TAX00001\',\'2020-08-01 10:10:10\',4,4900,\"Completed\",3,4,\'good service\',\'2020-7-1\',4,\'2020-01-04 10:10:10\'),(\'RST00043\',\'TRP00040\',\'TAX00002\',\'2020-08-01 10:10:10\',4,4900,\"Completed\",3,4,\'good service\',\'2020-7-1\',4,\'2020-01-05 10:10:10\'),(\'RST00044\',\'TRP00040\',\'TAX00003\',\'2020-08-01 10:10:10\',4,4900,\"Completed\",3,4,\'good service\',\'2020-7-1\',4,\'2020-01-01 10:10:10\'),(\'RST00045\',\'TRP00040\',\'TAX00004\',\'2020-08-01 10:10:10\',4,4900,\"Completed\",3,4,\'good service\',\'2020-7-1\',4,\'2020-01-02 10:10:10\'),(\'RST00046\',\'TRP00040\',\'TAX00005\',\'2020-08-01 10:10:10\',4,4900,\"Completed\",3,4,\'good service\',\'2020-7-1\',4,\'2020-01-03 10:10:10\'),(\'RST00047\',\'TRP00040\',\'TAX00006\',\'2020-08-01 10:10:10\',4,4900,\"Completed\",3,4,\'good service\',\'2020-7-1\',4,\'2020-01-04 10:10:10\'),(\'RST00048\',\'TRP00040\',\'TAX00007\',\'2020-08-01 10:10:10\',4,4900,\"Completed\",3,4,\'good service\',\'2020-7-1\',4,\'2020-01-05 10:10:10\'),(\'RST00049\',\'TRP00040\',\'TAX00008\',\'2020-08-01 10:10:10\',4,4900,\"Completed\",3,4,\'good service\',\'2020-7-1\',4,\'2020-01-06 10:10:10\');')
runQuery(callback,'INSERT INTO train VALUES(\'TRA00000\',\'LOC00005\',\'LOC00036\',\'YNYYNYY\',\'Y\'),(\'TRA00001\',\'LOC00009\',\'LOC00032\',\'YYNNYYY\',\'Y\'),(\'TRA00002\',\'LOC00004\',\'LOC00015\',\'YNYYNYY\',\'Y\'),(\'TRA00003\',\'LOC00011\',\'LOC00001\',\'YNYNYNY\',\'N\'),(\'TRA00004\',\'LOC00021\',\'LOC00002\',\'YNYNYNY\',\'Y\'),(\'TRA00005\',\'LOC00022\',\'LOC00033\',\'YNYNYNY\',\'Y\'),(\'TRA00006\',\'LOC00025\',\'LOC00002\',\'YNYNYNY\',\'N\'),(\'TRA00007\',\'LOC00035\',\'LOC00001\',\'YNYNYNY\',\'N\'), (\'TRA00008\',\'LOC00036\',\'LOC00015\',\'YNYNYNY\',\'N\'),(\'TRA00009\',\'LOC00037\',\'LOC00016\',\'YNYNYNY\',\'Y\'),(\'TRA00010\',\'LOC00001\',\'LOC00033\',\'YNYNYNY\',\'N\'),(\'TRA00011\',\'LOC00011\',\'LOC00020\',\'YNYNYNY\',\'N\'),(\'TRA00012\',\'LOC00001\',\'LOC00025\',\'YNYNYNY\',\'N\'),(\'TRA00013\',\'LOC00002\',\'LOC00034\',\'YNYNYNY\',\'N\'),(\'TRA00014\',\'LOC00025\',\'LOC00004\',\'YNYNYNY\',\'Y\'),(\'TRA00015\',\'LOC00015\',\'LOC00023\',\'YNYNYNY\',\'Y\');')
runQuery(callback,'INSERT INTO bus VALUES(\'BUS00000\',\'LOC00031\',\'LOC00008\',\'YNYNYNY\',\'Y\'),(\'BUS00001\',\'LOC00032\',\'LOC00007\',\'YYYNYNY\',\'Y\'),(\'BUS00002\',\'LOC00035\',\'LOC00005\',\'YNNNYNY\',\'Y\'),(\'BUS00003\',\'LOC00015\',\'LOC00030\',\'YNYYYNY\',\'Y\'),(\'BUS00004\',\'LOC00015\',\'LOC00026\',\'YNYNNNY\',\'Y\'),(\'BUS00005\',\'LOC00019\',\'LOC00030\',\'YNYNNYY\',\'Y\'),(\'BUS00006\',\'LOC00029\',\'LOC00033\',\'YNYNYNY\',\'Y\'),(\'BUS00007\',\'LOC00001\',\'LOC00008\',\'YNYNYNY\',\'Y\'),(\'BUS00008\',\'LOC00018\',\'LOC00023\',\'YNYNYNY\',\'N\'),(\'BUS00009\',\'LOC00015\',\'LOC00001\',\'YNYNYNY\',\'Y\'),(\'BUS00010\',\'LOC00016\',\'LOC00008\',\'YNYNYNY\',\'Y\'),(\'BUS00011\',\'LOC00017\',\'LOC00011\',\'YNYNYNY\',\'Y\'),(\'BUS00012\',\'LOC00018\',\'LOC00003\',\'YNYNYNY\',\'N\'),(\'BUS00013\',\'LOC00015\',\'LOC00008\',\'YNYNYNY\',\'Y\'),(\'BUS00014\',\'LOC00018\',\'LOC00001\',\'YNYNYNY\',\'Y\'),(\'BUS00015\',\'LOC00033\',\'LOC00001\',\'YNYNYNY\',\'Y\'),(\'BUS00016\',\'LOC00029\',\'LOC00008\',\'YNYNYNY\',\'Y\'),(\'BUS00017\',\'LOC00008\',\'LOC00036\',\'YNYNYNY\',\'N\'),(\'BUS00018\',\'LOC00015\',\'LOC00005\',\'YNYNYNY\',\'Y\'),(\'BUS00019\',\'LOC00003\',\'LOC00037\',\'YNYNYNY\',\'N\'),(\'BUS00020\',\'LOC00009\',\'LOC00038\',\'YNYNYNY\',\'Y\');')
runQuery(callback, 'CREATE INDEX a1 ON location(city ASC);')
runQuery(callback, 'CREATE INDEX a2 ON service_provider(domain ASC);')
runQuery(callback, 'CREATE INDEX a3 ON service(service_provider_id ASC);')
runQuery(callback, 'CREATE INDEX a4 ON hotel(location_id ASC);')
runQuery(callback, 'CREATE INDEX a5 ON room(room_type ASC);')
runQuery(callback, 'CREATE INDEX a6 ON restaurant(location_id ASC);')
runQuery(callback, 'CREATE INDEX a7 ON food_item(name ASC);')
runQuery(callback, 'CREATE INDEX a8 ON flight(from_city,to_city ASC);')
runQuery(callback, 'CREATE INDEX a9 ON taxi(car_name ASC);')
runQuery(callback, 'CREATE INDEX a10 ON tourist_spot(name,location_id ASC);')
runQuery(callback, 'CREATE INDEX a11 ON guide(tourist_spot_id ASC);')
runQuery(callback, 'CREATE INDEX a12 ON trip(user_id ASC);')
runQuery(callback, 'CREATE INDEX a13 ON service_request(trip_id ASC);')
}
async function main() {
await handleDisconnect();
// createDatabase();
}
main();
var fs = require('fs');
var readline = require('readline');
// var rl = readline.createInterface({
// input: fs.createReadStream('./locations.txt'),
// terminal: false
// });
// rl.on('line', function(chunk){
// con.query(chunk.toString('ascii'), function(err, sets, fields){
// if(err) console.log(err);
// else console.log("finished locations")
// });
// });
// var rl = readline.createInterface({
// input: fs.createReadStream('./service_providers.txt'),
// terminal: false
// });
// rl.on('line', function(chunk){
// con.query(chunk.toString('ascii'), function(err, sets, fields){
// if(err) console.log(err);
// else console.log("finished service providers")
// });
// });
// var rl = readline.createInterface({
// input: fs.createReadStream('./services.txt'),
// terminal: false
// });
// rl.on('line', function(chunk){
// con.query(chunk.toString('ascii'), function(err, sets, fields){
// if(err) console.log(err);
// else console.log("finished services")
// });
// });
// var rl = readline.createInterface({
// input: fs.createReadStream('./hotels.txt'),
// terminal: false
// });
// rl.on('line', function(chunk){
// con.query(chunk.toString('ascii'), function(err, sets, fields){
// if(err) console.log(err);
// else console.log("finished hotels")
// });
// });
// var rl = readline.createInterface({
// input: fs.createReadStream('./rooms.txt'),
// terminal: false
// });
// rl.on('line', function(chunk){
// con.query(chunk.toString('ascii'), function(err, sets, fields){
// if(err) console.log(err);
// else console.log("finished rooms")
// });
// });
// var rl = readline.createInterface({
// input: fs.createReadStream('./flights.txt'),
// terminal: false
// });
// rl.on('line', function(chunk){
// con.query(chunk.toString('ascii'), function(err, sets, fields){
// if(err) console.log(err);
// else console.log("finished flights")
// });
// });