工事管理システム製品化対応

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;