-
Notifications
You must be signed in to change notification settings - Fork 0
/
createMySQLTables.txt
230 lines (229 loc) · 10.6 KB
/
createMySQLTables.txt
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
223
224
225
226
227
228
229
230
CREATE TABLE CostOfLivingCountries(
ID int,
Country varchar (70),
Meal_Inexpensive_Restaurant_AVG float,
Meal_Inexpensive_Restaurant_Range varchar (30),
Meal_for_2_People_Midrange_Restaurant_Threecourse_AVG float,
Meal_for_2_People_Midrange_Restaurant_Threecourse_Range varchar (30),
McMeal_at_McDonalds_or_Equivalent_Combo_Meal_AVG float,
McMeal_at_McDonalds_or_Equivalent_Combo_Meal_Range varchar (30),
Domestic_Beer_1_pint_draught_restaurant_AVG float,
Domestic_Beer_1_pint_draught_restaurant_Range varchar (30),
Imported_Beer_12_oz_small_bottle_restaurant_AVG float,
Imported_Beer_12_oz_small_bottle_restaurant_Range varchar (30),
Cappuccino_regular_AVG float,
Cappuccino_regular_Range varchar (30),
Coke_or_Pepsi_12_oz_small_bottle_AVG float,
Coke_or_Pepsi_12_oz_small_bottle_Range varchar (30),
Water_12_oz_small_bottle_AVG float,
Water_12_oz_small_bottle_Range varchar (30),
Milk_regular_1_gallon_AVG float,
Milk_regular_1_gallon_Range varchar (30),
Loaf_of_Fresh_White_Bread_1_lb_AVG float,
Loaf_of_Fresh_White_Bread_1_lb_Range varchar (30),
Rice_white_1_lb_AVG float,
Rice_white_1_lb_Range varchar (30),
Eggs_regular_12_AVG float,
Eggs_regular_12_Range varchar (30),
Local_Cheese_1_lb_AVG float,
Local_Cheese_1_lb_Range varchar (30),
Chicken_Fillets_1_lb_AVG float,
Chicken_Fillets_1_lb_Range varchar (30),
Beef_Round_1_lb_or_Equivalent_Back_Leg_Red_Meat_AVG float,
Beef_Round_1_lb_or_Equivalent_Back_Leg_Red_Meat_Range varchar (30),
Apples_1_lb_AVG float,
Apples_1_lb_Range varchar (30),
Banana_1_lb_AVG float,
Banana_1_lb_Range varchar (30),
Oranges_1_lb_AVG float,
Oranges_1_lb_Range varchar (30),
Tomato_1_lb_AVG float,
Tomato_1_lb_Range varchar (30),
Potato_1_lb_AVG float,
Potato_1_lb_Range varchar (30),
Onion_1_lb_AVG float,
Onion_1_lb_Range varchar (30),
Lettuce_1_head_AVG float,
Lettuce_1_head_Range varchar (30),
Water_1_point_5_liter_bottle_AVG float,
Water_1_point_5_liter_bottle_Range varchar (30),
Bottle_of_Wine_MidRange_AVG float,
Bottle_of_Wine_MidRange_Range varchar (30),
Domestic_Beer_half_liter_bottle_grocery_AVG float,
Domestic_Beer_half_liter_bottle_grocery_Range varchar (30),
Imported_Beer_12_oz_small_bottle_grocery_AVG float,
Imported_Beer_12_oz_small_bottle_grocery_Range varchar (30),
Cigarettes_20_Pack_Marlboro_AVG float,
Cigarettes_20_Pack_Marlboro_Range varchar (30),
Oneway_Ticket_Local_Transport_AVG float,
Oneway_Ticket_Local_Transport_Range varchar (30),
Monthly_Pass_Regular_Price_AVG float,
Monthly_Pass_Regular_Price_Range varchar (30),
Taxi_Start_Normal_Tariff_AVG float,
Taxi_Start_Normal_Tariff_Range varchar (30),
Taxi_1_mile_Normal_Tariff_AVG float,
Taxi_1_mile_Normal_Tariff_Range varchar (30),
Taxi_1hour_Waiting_Normal_Tariff_AVG float,
Taxi_1hour_Waiting_Normal_Tariff_Range varchar (30),
Gasoline_1_gallon_AVG float,
Gasoline_1_gallon_Range varchar (30),
Volkswagen_Golf_Trendline_Or_Equivalent_New_Car_AVG float,
Volkswagen_Golf_Trendline_Or_Equivalent_New_Car_Range varchar (30),
Toyota_Corolla_Sedan_Comfort_Or_Equivalent_New_Car_AVG float,
Toyota_Corolla_Sedan_Comfort_Or_Equivalent_New_Car_Range varchar (30),
Electricity_AC_Water_Garbage_915_sq_ft_Apartment_AVG float,
Electricity_AC_Water_Garbage_915_sq_ft_Apartment_Range varchar (30),
min_of_Prepaid_Mobile_Tariff_Local_No_Discounts_or_Plans_AVG float,
min_of_Prepaid_Mobile_Tariff_Local_No_Discounts_or_Plans_Range varchar (30),
Internet_60_Mbps_or_More_Unlimited_Data_Cable_or_ADSL_AVG float,
Internet_60_Mbps_or_More_Unlimited_Data_Cable_or_ADSL_Range varchar (30),
Fitness_Club_Monthly_Fee_for_1_Adult_AVG float,
Fitness_Club_Monthly_Fee_for_1_Adult_Range varchar (30),
Tennis_Court_Rent_1_Hour_on_Weekend_AVG float,
Tennis_Court_Rent_1_Hour_on_Weekend_Range varchar (30),
Cinema_International_Release_1_Seat_AVG float,
Cinema_International_Release_1_Seat_Range varchar (30),
Kindergarten_Full_Day_Private_Monthly_for_1_Child_AVG float,
Kindergarten_Full_Day_Private_Monthly_for_1_Child_Range varchar (30),
International_Primary_School_Yearly_for_1_Child_AVG float,
International_Primary_School_Yearly_for_1_Child_Range varchar (30),
Pair_of_Jeans_Levis_501_Or_Similar_AVG float,
Pair_of_Jeans_Levis_501_Or_Similar_Range varchar (30),
Summer_Dress_in_a_Chain_Store_Zara_H_AND_M_AVG float,
Summer_Dress_in_a_Chain_Store_Zara_H_AND_M_Range varchar (30),
Pair_of_Nike_Running_Shoes_MidRange_AVG float,
Pair_of_Nike_Running_Shoes_MidRange_Range varchar (30),
Pair_of_Men_Leather_Business_Shoes_AVG float,
Pair_of_Men_Leather_Business_Shoes_Range varchar (30),
Apartment_1_bedroom_in_City_Centre_AVG float,
Apartment_1_bedroom_in_City_Centre_Range varchar (30),
Apartment_1_bedroom_Outside_of_Centre_AVG float,
Apartment_1_bedroom_Outside_of_Centre_Range varchar (30),
Apartment_3_bedrooms_in_City_Centre_AVG float,
Apartment_3_bedrooms_in_City_Centre_Range varchar (30),
Apartment_3_bedrooms_Outside_of_Centre_AVG float,
Apartment_3_bedrooms_Outside_of_Centre_Range varchar (30),
Price_per_Square_Feet_to_Buy_Apartment_in_City_Centre_AVG float,
Price_per_Square_Feet_to_Buy_Apartment_in_City_Centre_Range varchar (30),
Price_per_Square_Feet_to_Buy_Apartment_Outside_of_Centre_AVG float,
Price_per_Square_Feet_to_Buy_Apartment_Outside_of_Centre_Range varchar (30),
Average_Monthly_Net_Salary_After_Tax_AVG float,
Average_Monthly_Net_Salary_After_Tax_Range varchar (30),
Mtge_Interest_Rate_in_Percentages_Yearly_for_20_Yrs_Fixed_AVG float,
Mtge_Interest_Rate_in_Percentages_Yearly_for_20_Yrs_Fixed_Range varchar (30)
);
CREATE TABLE CostOfLivingCities(
ID int,
Country varchar (70),
City varchar (70),
Meal_Inexpensive_Restaurant_AVG float,
Meal_Inexpensive_Restaurant_Range varchar (30),
Meal_for_2_People_Midrange_Restaurant_Threecourse_AVG float,
Meal_for_2_People_Midrange_Restaurant_Threecourse_Range varchar (30),
McMeal_at_McDonalds_or_Equivalent_Combo_Meal_AVG float,
McMeal_at_McDonalds_or_Equivalent_Combo_Meal_Range varchar (30),
Domestic_Beer_1_pint_draught_restaurant_AVG float,
Domestic_Beer_1_pint_draught_restaurant_Range varchar (30),
Imported_Beer_12_oz_small_bottle_restaurant_AVG float,
Imported_Beer_12_oz_small_bottle_restaurant_Range varchar (30),
Cappuccino_regular_AVG float,
Cappuccino_regular_Range varchar (30),
Coke_or_Pepsi_12_oz_small_bottle_AVG float,
Coke_or_Pepsi_12_oz_small_bottle_Range varchar (30),
Water_12_oz_small_bottle_AVG float,
Water_12_oz_small_bottle_Range varchar (30),
Milk_regular_1_gallon_AVG float,
Milk_regular_1_gallon_Range varchar (30),
Loaf_of_Fresh_White_Bread_1_lb_AVG float,
Loaf_of_Fresh_White_Bread_1_lb_Range varchar (30),
Rice_white_1_lb_AVG float,
Rice_white_1_lb_Range varchar (30),
Eggs_regular_12_AVG float,
Eggs_regular_12_Range varchar (30),
Local_Cheese_1_lb_AVG float,
Local_Cheese_1_lb_Range varchar (30),
Chicken_Fillets_1_lb_AVG float,
Chicken_Fillets_1_lb_Range varchar (30),
Beef_Round_1_lb_or_Equivalent_Back_Leg_Red_Meat_AVG float,
Beef_Round_1_lb_or_Equivalent_Back_Leg_Red_Meat_Range varchar (30),
Apples_1_lb_AVG float,
Apples_1_lb_Range varchar (30),
Banana_1_lb_AVG float,
Banana_1_lb_Range varchar (30),
Oranges_1_lb_AVG float,
Oranges_1_lb_Range varchar (30),
Tomato_1_lb_AVG float,
Tomato_1_lb_Range varchar (30),
Potato_1_lb_AVG float,
Potato_1_lb_Range varchar (30),
Onion_1_lb_AVG float,
Onion_1_lb_Range varchar (30),
Lettuce_1_head_AVG float,
Lettuce_1_head_Range varchar (30),
Water_1_point_5_liter_bottle_AVG float,
Water_1_point_5_liter_bottle_Range varchar (30),
Bottle_of_Wine_MidRange_AVG float,
Bottle_of_Wine_MidRange_Range varchar (30),
Domestic_Beer_half_liter_bottle_grocery_AVG float,
Domestic_Beer_half_liter_bottle_grocery_Range varchar (30),
Imported_Beer_12_oz_small_bottle_grocery_AVG float,
Imported_Beer_12_oz_small_bottle_grocery_Range varchar (30),
Cigarettes_20_Pack_Marlboro_AVG float,
Cigarettes_20_Pack_Marlboro_Range varchar (30),
Oneway_Ticket_Local_Transport_AVG float,
Oneway_Ticket_Local_Transport_Range varchar (30),
Monthly_Pass_Regular_Price_AVG float,
Monthly_Pass_Regular_Price_Range varchar (30),
Taxi_Start_Normal_Tariff_AVG float,
Taxi_Start_Normal_Tariff_Range varchar (30),
Taxi_1_mile_Normal_Tariff_AVG float,
Taxi_1_mile_Normal_Tariff_Range varchar (30),
Taxi_1hour_Waiting_Normal_Tariff_AVG float,
Taxi_1hour_Waiting_Normal_Tariff_Range varchar (30),
Gasoline_1_gallon_AVG float,
Gasoline_1_gallon_Range varchar (30),
Volkswagen_Golf_Trendline_Or_Equivalent_New_Car_AVG float,
Volkswagen_Golf_Trendline_Or_Equivalent_New_Car_Range varchar (30),
Toyota_Corolla_Sedan_Comfort_Or_Equivalent_New_Car_AVG float,
Toyota_Corolla_Sedan_Comfort_Or_Equivalent_New_Car_Range varchar (30),
Electricity_AC_Water_Garbage_915_sq_ft_Apartment_AVG float,
Electricity_AC_Water_Garbage_915_sq_ft_Apartment_Range varchar (30),
min_of_Prepaid_Mobile_Tariff_Local_No_Discounts_or_Plans_AVG float,
min_of_Prepaid_Mobile_Tariff_Local_No_Discounts_or_Plans_Range varchar (30),
Internet_60_Mbps_or_More_Unlimited_Data_Cable_or_ADSL_AVG float,
Internet_60_Mbps_or_More_Unlimited_Data_Cable_or_ADSL_Range varchar (30),
Fitness_Club_Monthly_Fee_for_1_Adult_AVG float,
Fitness_Club_Monthly_Fee_for_1_Adult_Range varchar (30),
Tennis_Court_Rent_1_Hour_on_Weekend_AVG float,
Tennis_Court_Rent_1_Hour_on_Weekend_Range varchar (30),
Cinema_International_Release_1_Seat_AVG float,
Cinema_International_Release_1_Seat_Range varchar (30),
Kindergarten_Full_Day_Private_Monthly_for_1_Child_AVG float,
Kindergarten_Full_Day_Private_Monthly_for_1_Child_Range varchar (30),
International_Primary_School_Yearly_for_1_Child_AVG float,
International_Primary_School_Yearly_for_1_Child_Range varchar (30),
Pair_of_Jeans_Levis_501_Or_Similar_AVG float,
Pair_of_Jeans_Levis_501_Or_Similar_Range varchar (30),
Summer_Dress_in_a_Chain_Store_Zara_H_AND_M_AVG float,
Summer_Dress_in_a_Chain_Store_Zara_H_AND_M_Range varchar (30),
Pair_of_Nike_Running_Shoes_MidRange_AVG float,
Pair_of_Nike_Running_Shoes_MidRange_Range varchar (30),
Pair_of_Men_Leather_Business_Shoes_AVG float,
Pair_of_Men_Leather_Business_Shoes_Range varchar (30),
Apartment_1_bedroom_in_City_Centre_AVG float,
Apartment_1_bedroom_in_City_Centre_Range varchar (30),
Apartment_1_bedroom_Outside_of_Centre_AVG float,
Apartment_1_bedroom_Outside_of_Centre_Range varchar (30),
Apartment_3_bedrooms_in_City_Centre_AVG float,
Apartment_3_bedrooms_in_City_Centre_Range varchar (30),
Apartment_3_bedrooms_Outside_of_Centre_AVG float,
Apartment_3_bedrooms_Outside_of_Centre_Range varchar (30),
Price_per_Square_Feet_to_Buy_Apartment_in_City_Centre_AVG float,
Price_per_Square_Feet_to_Buy_Apartment_in_City_Centre_Range varchar (30),
Price_per_Square_Feet_to_Buy_Apartment_Outside_of_Centre_AVG float,
Price_per_Square_Feet_to_Buy_Apartment_Outside_of_Centre_Range varchar (30),
Average_Monthly_Net_Salary_After_Tax_AVG float,
Average_Monthly_Net_Salary_After_Tax_Range varchar (30),
Mtge_Interest_Rate_in_Percentages_Yearly_for_20_Yrs_Fixed_AVG float,
Mtge_Interest_Rate_in_Percentages_Yearly_for_20_Yrs_Fixed_Range varchar (30)
);