DROP TABLE IF EXISTS SystemMaster_OLD;
CREATE TABLE SystemMaster_OLD As Select * from SystemMaster;
DROP TABLE IF EXISTS SystemMaster;

-- ŠÇ—�ƒ}ƒXƒ^
CREATE TABLE SystemMaster
(
	SystemCode decimal(3,0) unsigned NOT NULL COMMENT '‰ïŽÐƒR�[ƒh',
	CompanyName1 varchar(60) DEFAULT '' NOT NULL COMMENT '‰ïŽÐ–¼‚P',
	CompanyName2 varchar(60) DEFAULT '' COMMENT '‰ïŽÐ–¼‚Q',
	CEOName varchar(60) DEFAULT '' NOT NULL COMMENT '‘ã•\ŽÒŽ�–¼',
	CEOPositionName varchar(60) DEFAULT '' COMMENT '‘ã•\ŽÒ–ð�E–¼',
	ZipCode varchar(8) NOT NULL COMMENT '—X•Ö”Ô�†',
	Address1 varchar(60) NOT NULL COMMENT '�Z�Š‚P',
	Address2 varchar(60) DEFAULT '' COMMENT '�Z�Š2',
	Address3 varchar(60) COMMENT '�Z�Š3',
	PhoneNumber varchar(13) DEFAULT '' NOT NULL COMMENT '“d˜b”Ô�†',
	FaxNumber varchar(13) DEFAULT '' COMMENT 'FAX”Ô�†',
	HomePageURL varchar(120) DEFAULT '' COMMENT 'ƒz�[ƒ€ƒy�[ƒWURL',
	ConstructionExpenses decimal(4,2) NOT NULL COMMENT '�HŽ–•”Œo”ï',
	OfficeExpenses decimal(4,2) NOT NULL COMMENT 'Ž––±�ŠŒo”ï',
	OperatingExpenses decimal(4,2) NOT NULL COMMENT '‰c‹ÆŒo”ï',
	ConsumptionTax decimal(4,2) NOT NULL COMMENT '�Á”ï�Å',
	CooperationRate decimal(4,2) NOT NULL COMMENT '‹¦—Í‹à”ä—¦',
	StatutoryWelfareRate decimal(4,2) NOT NULL COMMENT '–@’è•Ÿ—˜”ï”ä—¦',
	ExcelSavePath varchar(120) COMMENT 'Excel•Û‘¶ƒpƒX',
	BusinessPeriod smallint NOT NULL COMMENT 'Œ»�݉c‹ÆŠú�”',
	ConstructionYear smallint NOT NULL COMMENT 'Œ»�Ý�HŽ–”N“x',
	BusinessBeginningDate varchar(5) NOT NULL COMMENT '‰c‹ÆŠúŠúŽñ“ú',
	ConstructionBeginningDate varchar(5) NOT NULL COMMENT '�HŽ–”N“xŠúŽñ“ú',
	ConstructionNoBase decimal(1) NOT NULL COMMENT '�HŽ–”Ô�†Šî�€’l',
	SloganString1 varchar(100) COMMENT '•WŒê1',
	SloganString2 varchar(100) COMMENT '•WŒê2',
	SloganString3 varchar(100) COMMENT '•WŒê3',
	EntryDate datetime NOT NULL COMMENT '“o˜^“ú•t',
	UpdateDate datetime NOT NULL COMMENT '�X�V“ú•t',
	PRIMARY KEY (SystemCode)
) COMMENT = 'ŠÇ—�ƒ}ƒXƒ^';

Insert INTO SystemMaster
SELECT
	SystemCode,
	CompanyName1,
	CompanyName2,
	CEOName,
	CEOPositionName,
	ZipCode,
	Address1,
	Address2,
	Address3,
	PhoneNumber,
	FaxNumber,
	'',
	ConstructionExpenses,
	OfficeExpenses,
	OperatingExpenses,
	ConsumptionTax,
	CooperationRate,
	8.0,
	ExcelSavePath,
	BusinessPeriod,
	ConstructionYear,
	BusinessBeginningDate,
	ConstructionBeginningDate,
	ConstructionNoBase,
	SloganString1,
	SloganString2,
	SloganString3,
	EntryDate,
	UpdateDate
FROM SystemMaster_OLD
;
commit;