drop table IF EXISTS all_master;
create table all_master(
    ID    integer    primary key    auto_increment    ,
    is_alive    integer    ,
    renew_date    datetime    ,
    CATEGORY1    varchar(255)    not null    ,
    CATEGORY2    varchar(255)    not null    ,
    CATEGORY3    varchar(255)    not null    ,
    START_WORD    varchar(5)    not null    ,
    SHOP_NAME    varchar(255)    not null    ,
    TEL_NUM    varchar(30)    not null    ,
    POST_NUM    varchar(7)    not null    ,
    PREFECTURE    varchar(30)    not null    ,
    CITY    varchar(30)    not null    ,
    ADDRESS    varchar(255)    not null    ,
    URL    varchar(255)    not null    ,
    LATITUDE    varchar(30)    not null    ,
    LONGITUDE    varchar(30)    not null    ,
    LINE1    varchar(30)    not null    ,
    STATION1    varchar(30)    not null    ,
    LINE2    varchar(30)    not null    ,
    STATION2    varchar(30)    not null    ,
    LINE3    varchar(30)    not null    ,
    STATION3    varchar(30)    not null    ,
    LINE4    varchar(30)    not null    ,
    STATION4    varchar(30)    not null    ,
    CLIENT_ID    integer    ,
    PHOTO1_ID    integer    ,
    PHOTO2_ID    integer    ,
    PHOTO3_ID    integer    ,
    MESSAGE    varchar(255)    not null    ,
    REMARK    varchar(255)    not null    
) 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);