CREATE TABLE IF NOT EXISTS `risoluto_m_zipcode`
(
      `ctime`              datetime       NOT NULL
    , `cuser`              varchar(255)   NOT NULL
    , `mtime`              datetime       NOT NULL
    , `muser`              varchar(255)   NOT NULL
    , `zipcd_1`            varchar(3)
    , `zipcd_2`            varchar(4)
    , `prefcd`             varchar(5)
    , `prefname`           varchar(10)
    , `cityname`           varchar(255)
    , `cityname_kn`        varchar(255)
    , `areaname`           varchar(255)
    , `areaname_kn`        varchar(255)
    , `active_flg`         varchar(1)
    ,  PRIMARY KEY  (
                      `zipcd_1`
                    , `zipcd_2`
                    )
) ENGINE=InnoDB CHARACTER SET utf8;
