drop table IF EXISTS all_master;
create table all_master(
    ID    integer    primary key    auto_increment    comment 'ID',
    is_alive    integer    comment '有効フラグ',
    renew_date    datetime    comment '更新日',
    CATEGORY1    varchar(255)    not null    comment '大業種',
    CATEGORY2    varchar(255)    not null    comment '中業種',
    CATEGORY3    varchar(255)    not null    comment '小業種',
    START_WORD    varchar(5)    not null    comment 'あいうえお',
    SHOP_NAME    varchar(255)    not null    comment '事業所名',
    TEL_NUM    varchar(30)    not null    comment '電話番号',
    POST_NUM    varchar(7)    not null    comment '郵便番号',
    PREFECTURE    varchar(30)    not null    comment '都道府県',
    CITY    varchar(30)    not null    comment '市区町村',
    ADDRESS    varchar(255)    not null    comment '全住所',
    URL    varchar(255)    not null    comment 'URL',
    LATITUDE    varchar(30)    not null    comment '緯度',
    LONGITUDE    varchar(30)    not null    comment '経度',
    LINE1    varchar(30)    not null    comment '沿線名1',
    STATION1    varchar(30)    not null    comment '駅名1',
    LINE2    varchar(30)    not null    comment '沿線名2',
    STATION2    varchar(30)    not null    comment '駅名2',
    LINE3    varchar(30)    not null    comment '沿線名3',
    STATION3    varchar(30)    not null    comment '駅名3',
    LINE4    varchar(30)    not null    comment '沿線名4',
    STATION4    varchar(30)    not null    comment '駅名4',
    CLIENT_ID    integer    comment 'クライアントID',
    PHOTO1_ID    integer    comment '写真1ID',
    PHOTO2_ID    integer    comment '写真2ID',
    PHOTO3_ID    integer    comment '写真3ID',
    MESSAGE    varchar(255)    not null    comment 'メッセージ',
    REMARK    varchar(255)    not null    comment '備考'
) type=MyISAM;
create index IDX_all_master_CATEGORY1 on all_master(CATEGORY1);
create index IDX_all_master_CATEGORY2 on all_master(CATEGORY2);
create index IDX_all_master_CATEGORY3 on all_master(CATEGORY3);
create index IDX_all_master_START_WORD on all_master(START_WORD);
create index IDX_all_master_SHOP_NAME on all_master(SHOP_NAME);
create index IDX_all_master_PREFECTURE on all_master(PREFECTURE);
create index IDX_all_master_CITY on all_master(CITY);
create index IDX_all_master_LINE1 on all_master(LINE1);
create index IDX_all_master_STATION1 on all_master(STATION1);
create index IDX_all_master_LINE2 on all_master(LINE2);
create index IDX_all_master_STATION2 on all_master(STATION2);
create index IDX_all_master_LINE3 on all_master(LINE3);
create index IDX_all_master_STATION3 on all_master(STATION3);
create index IDX_all_master_LINE4 on all_master(LINE4);
create index IDX_all_master_STATION4 on all_master(STATION4);

drop table IF EXISTS zip_master;
create table zip_master(
    ID    integer    primary key    auto_increment    comment 'ID',
    is_alive    integer    comment '有効フラグ',
    renew_date    datetime    comment '更新日',
    POST_NUM    varchar(7)    not null    comment '郵便番号',
    ADDRESS    varchar(255)    not null    comment '住所',
    NUM_MIN    integer    not null    comment '住所()内数字小',
    NUM_MAX    integer    not null    comment '住所()内数字大',
    NUM_UNIT    varchar(10)    not null    comment '住所()内数字単位'
) type=MyISAM;