-- ŠÇ—�ƒ}ƒXƒ^
drop table if exists systemmaster_OLD cascade;
CREATE TABLE systemmaster_OLD As Select * from systemmaster;

drop table if exists systemmaster cascade;

create table systemmaster (
  SystemCode decimal(3,0) unsigned not null comment '‰ïŽÐƒR�[ƒh'
  , CompanyName1 varchar(60) not null comment '‰ïŽÐ–¼‚P'
  , CompanyName2 varchar(60) comment '‰ïŽÐ–¼‚Q'
  , CEOName varchar(60) not null comment '‘ã•\ŽÒŽ�–¼'
  , CEOPositionName varchar(60) comment '‘ã•\ŽÒ–ð�E–¼'
  , ZipCode varchar(8) not null comment '—X•Ö”Ô�†'
  , Address1 varchar(60) not null comment '�Z�Š‚P'
  , Address2 varchar(60) comment '�Z�Š2'
  , Address3 varchar(60) comment '�Z�Š3'
  , PhoneNumber varchar(13) not null comment '“d˜b”Ô�†'
  , FaxNumber varchar(13) comment 'FAX”Ô�†'
  , HomePageURL varchar(120) comment 'ƒz�[ƒ€ƒy�[ƒWURL'
  , ConsumptionTax decimal(4,2) not null comment '�Á”ï�Å'
  , CooperationRate decimal(4,2) not null comment '‹¦—Í‹à”ä—¦'
  , StatutoryWelfareRate decimal(4,2) not null comment '–@’è•Ÿ—˜”ï”ä—¦'
  , FuelPrice decimal(5,2) not null comment '”R—¿ƒLƒ�’P‰¿'
  , AreaDistance decimal(5,2) not null comment 'Ž‘�Þ’u�êˆÚ“®‹——£'
  , ExcelSavePath varchar(120) comment 'Excel•Û‘¶ƒpƒX'
  , BusinessPeriod smallint(6) not null comment 'Œ»�݉c‹ÆŠú�”'
  , ConstrYear smallint(6) not null comment 'Œ»�Ý�HŽ–”N“x'
  , BusinessBeginDate datetime not null comment '‰c‹ÆŠúŠúŽñ“ú'
  , ConstrBeginDate datetime not null comment '�HŽ–”N“xŠúŽñ“ú'
  , BusinessCompDate datetime not null comment '‰c‹ÆŠúŠú––“ú'
  , ConstrCompDate datetime not null comment '�HŽ–”N“xŠú––“ú'
  , ConstructionNoBase decimal(1,0) not null comment '�HŽ–”Ô�†Šî�€’l'
  , SloganString1 varchar(100) comment '•WŒê1'
  , SloganString2 varchar(100) comment '•WŒê2'
  , SloganString3 varchar(100) comment '•WŒê3'
  , OperationFlg decimal(2,0) unsigned not null comment '�³”F‰^—pƒtƒ‰ƒO'
  , EntryDate datetime not null comment '“o˜^“ú•t'
  , UpdateDate datetime not null comment '�X�V“ú•t'
  , constraint systemmaster_PKC primary key (SystemCode)
) comment 'ŠÇ—�ƒ}ƒXƒ^' ;

Insert INTO systemmaster
SELECT
  SystemCode
  , CompanyName1
  , CompanyName2
  , CEOName
  , CEOPositionName
  , ZipCode
  , Address1
  , Address2
  , Address3
  , PhoneNumber
  , FaxNumber
  , HomePageURL
  , ConsumptionTax
  , CooperationRate
  , StatutoryWelfareRate
  , FuelPrice
  , AreaDistance
  , ExcelSavePath
  , BusinessPeriod
  , ConstrYear
  , BusinessBeginDate
  , ConstrBeginDate
  , BusinessCompDate
  , ConstrCompDate
  , ConstructionNoBase
  , SloganString1
  , SloganString2
  , SloganString3
  , 0
  , EntryDate
  , UpdateDate
FROM systemmaster_OLD
;
commit;