CREATE TABLE numbering_plan_cache_staging (
    cns VARCHAR(400),
    country_code VARCHAR(400),
    national_significant_number VARCHAR(400),
    iso_3166_alpha_2 VARCHAR(400),
    iso_3166_alpha_3 VARCHAR(400),
    utc_min VARCHAR(400),
    utc_max VARCHAR(400),
    destination VARCHAR(400),
    type_id VARCHAR(400),
    description VARCHAR(400),
    location VARCHAR(400),
    registrar VARCHAR(400),
    area_code_length VARCHAR(400),
    min_subscr_nr_length VARCHAR(400),
    max_subscr_nr_length VARCHAR(400),
    range_activation VARCHAR(400),
    range_deactivation VARCHAR(400),
    range_status VARCHAR(400),
    mobile_country_code VARCHAR(400),
    mobile_network_code VARCHAR(400),
    operating_company_number VARCHAR(400),
	INDEX (mobile_country_code,mobile_network_code)
);

CREATE TABLE numbering_plan_cache (
    cns VARCHAR(400),
    country_code VARCHAR(400),
    national_significant_number VARCHAR(400),
    iso_3166_alpha_2 VARCHAR(400),
    iso_3166_alpha_3 VARCHAR(400),
    utc_min VARCHAR(400),
    utc_max VARCHAR(400),
    destination VARCHAR(400),
    type_id VARCHAR(400),
    description VARCHAR(400),
    location VARCHAR(400),
    registrar VARCHAR(400),
    area_code_length VARCHAR(400),
    min_subscr_nr_length VARCHAR(400),
    max_subscr_nr_length VARCHAR(400),
    range_activation VARCHAR(400),
    range_deactivation VARCHAR(400),
    range_status VARCHAR(400),
    mobile_country_code VARCHAR(400),
    mobile_network_code VARCHAR(400),
    operating_company_number VARCHAR(400),
	INDEX (mobile_country_code,mobile_network_code)
);

CREATE TABLE my_view_cache_staging (
    cns VARCHAR(400),
    country_code VARCHAR(400)
    );
    
CREATE TABLE my_view_cache (
    cns VARCHAR(400),
    country_code VARCHAR(400)
    )    ;