CREATE TABLE hm_all_stores (
"storecode" VARCHAR,
"storeclass" VARCHAR,
"name" VARCHAR,
"phone" VARCHAR,
"city" VARCHAR,
"country" VARCHAR,
"countrycode" VARCHAR,
"longitude" DOUBLE,
"latitude" DOUBLE,
"timezoneindex" DOUBLE,
"mon_open_hours" VARCHAR,
"tue_open_hours" VARCHAR,
"wed_open_hours" VARCHAR,
"thu_open_hours" VARCHAR,
"fri_open_hours" VARCHAR,
"sat_open_hours" VARCHAR,
"sun_open_hours" VARCHAR,
"streetname1" VARCHAR,
"streetname2" VARCHAR,
"state" VARCHAR,
"address_string" VARCHAR
);