Index: trunk/ddl/ProcessManagement.sql
===================================================================
--- trunk/ddl/ProcessManagement.sql	(revision 405)
+++ trunk/ddl/ProcessManagement.sql	(revision 406)
@@ -1,5 +1,5 @@
 -- Project Name : noname
--- Date/Time    : 2018/08/06 8:37:19
+-- Date/Time    : 2018/09/20 10:20:05
 -- Author       : Horiuchi
 -- RDBMS Type   : MySQL
 -- Application  : A5:SQL Mk-2
@@ -516,25 +516,25 @@
 create index ComponentMaster_Index1
   on componentmaster(DisplayOrder);
 
--- �\�¬�HŽ–Ží•ÊŠÖ˜Aƒ}ƒXƒ^
+-- �HŽ–Ží•Ê�E�\�¬ƒŠƒ“ƒNƒ}ƒXƒ^
 --* BackupToTempTable
 drop table if exists componenttotypemaster cascade;
 
 --* RestoreFromTempTable
 create table componenttotypemaster (
-  ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
-  , TypeCode decimal(5,0) unsigned not null comment '�HŽ–Ží•ÊƒR�[ƒh'
-  , Dummy decimal(1,0) not null comment 'ƒ_ƒ~�[�€–Ú'
+  TypeCode decimal(5,0) unsigned not null comment '�HŽ–Ží•ÊƒR�[ƒh'
+  , ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
+  , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
   , EntryDate datetime not null comment '“o˜^“ú•t'
   , UpdateDate datetime not null comment '�X�V“ú•t'
-  , constraint componenttotypemaster_PKC primary key (ComponentCode,TypeCode)
-) comment '�\�¬�HŽ–Ží•ÊŠÖ˜Aƒ}ƒXƒ^' ;
+  , constraint componenttotypemaster_PKC primary key (TypeCode,ComponentCode)
+) comment '�HŽ–Ží•Ê�E�\�¬ƒŠƒ“ƒNƒ}ƒXƒ^' ;
 
 create index ComponentToTypeMaster_Index1
-  on componenttotypemaster(ComponentCode);
+  on componenttotypemaster(TypeCode);
 
 create index ComponentToTypeMaster_Index2
-  on componenttotypemaster(TypeCode);
+  on componenttotypemaster(ComponentCode);
 
 -- �HŽ–�Ú�×‘ä’ Œo”ïƒf�[ƒ^
 --* BackupToTempTable
@@ -949,16 +949,19 @@
 
 --* RestoreFromTempTable
 create table constructionspecunitprice (
-  ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
+  ConstructionTypeCode mediumint(8) unsigned not null comment '�HŽ–Ží•ÊƒR�[ƒh'
+  , ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
   , ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
   , SpecCode decimal(5,0) unsigned not null comment '�ì‹ÆƒL�['
-  , ConstructionTypeCode mediumint(8) unsigned not null comment '�HŽ–Ží•ÊƒR�[ƒh'
   , UnitPrice decimal(9,2) not null comment '’P‰¿'
   , EntryDate datetime not null comment '“o˜^“ú•t'
   , UpdateDate datetime not null comment '�X�V“ú•t'
-  , constraint constructionspecunitprice_PKC primary key (ComponentCode,ItemCode,SpecCode,ConstructionTypeCode)
+  , constraint constructionspecunitprice_PKC primary key (ConstructionTypeCode,ComponentCode,ItemCode,SpecCode)
 ) comment '�ì‹Æ’P‰¿ƒ}ƒXƒ^' ;
 
+create index constructionspecunitprice_Index1
+  on constructionspecunitprice(ConstructionTypeCode,ComponentCode,ItemCode);
+
 -- �HŽ–Ží•Êƒ}ƒXƒ^
 --* BackupToTempTable
 drop table if exists constructiontypemaster cascade;
@@ -1337,7 +1340,7 @@
   , REQUESTNO decimal(10,0) not null comment '�¿‹�No'
   , ORDERNO decimal(2,0) comment 'Žó•t”Ô�†'
   , DEPOSITAMOUNT decimal(10,0) comment '“ü‹à‹àŠz�i�Å”²‚«�j'
-  , TAXAMOUNT decimal(10,0) DEFAULT NULL COMMENT '�Á”ï�Å'
+  , TAXAMOUNT decimal(10,0) comment '�Á”ï�Å'
   , DISCOUNTAMOUNT decimal(10,0) comment '’lˆø‚«‹àŠz'
   , CNSTRPRICE decimal(10,0) comment '‹¦—Í‹à'
   , FEES decimal(10,0) comment 'Žè�”—¿'
@@ -2661,6 +2664,7 @@
   , 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)
Index: trunk/ddl/ƒe�[ƒuƒ‹Žd—l�‘.xlsx
===================================================================
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
Index: trunk/ddl/�HŽ–Ží•Ê�E�\�¬ƒŠƒ“ƒNƒ}ƒXƒ^•Ï�X.sql
===================================================================
--- trunk/ddl/�HŽ–Ží•Ê�E�\�¬ƒŠƒ“ƒNƒ}ƒXƒ^•Ï�X.sql	(nonexistent)
+++ trunk/ddl/�HŽ–Ží•Ê�E�\�¬ƒŠƒ“ƒNƒ}ƒXƒ^•Ï�X.sql	(revision 406)
@@ -0,0 +1,17 @@
+-- �HŽ–Ží•Ê�E�\�¬ƒŠƒ“ƒNƒ}ƒXƒ^
+drop table if exists componenttotypemaster cascade;
+
+create table componenttotypemaster (
+  TypeCode decimal(5,0) unsigned not null comment '�HŽ–Ží•ÊƒR�[ƒh'
+  , ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
+  , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint componenttotypemaster_PKC primary key (TypeCode, ComponentCode)
+) comment '�HŽ–Ží•Ê�E�\�¬ƒŠƒ“ƒNƒ}ƒXƒ^' ;
+
+create index ComponentToTypeMaster_Index1
+  on componenttotypemaster(TypeCode);
+
+create index ComponentToTypeMaster_Index2
+  on componenttotypemaster(ComponentCode);
Index: trunk/ddl/�HŽ–Ží•Ê�ì‹Æ’P‰¿ƒ}ƒXƒ^•Ï�X.sql
===================================================================
--- trunk/ddl/�HŽ–Ží•Ê�ì‹Æ’P‰¿ƒ}ƒXƒ^•Ï�X.sql	(nonexistent)
+++ trunk/ddl/�HŽ–Ží•Ê�ì‹Æ’P‰¿ƒ}ƒXƒ^•Ï�X.sql	(revision 406)
@@ -0,0 +1,35 @@
+-- �ì‹Æ’P‰¿ƒ}ƒXƒ^
+drop table if exists constructionspecunitprice_OLD cascade;
+CREATE TABLE constructionspecunitprice_OLD As Select * from constructionspecunitprice;
+
+drop table if exists constructionspecunitprice cascade;
+
+create table constructionspecunitprice (
+  ConstructionTypeCode mediumint(8) unsigned not null comment '�HŽ–Ží•ÊƒR�[ƒh'
+  , ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
+  , ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
+  , SpecCode decimal(5,0) unsigned not null comment '�ì‹ÆƒL�['
+  , UnitPrice decimal(9,2) not null comment '’P‰¿'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint constructionspecunitprice_PKC primary key (ConstructionTypeCode,ComponentCode,ItemCode,SpecCode)
+) comment '�ì‹Æ’P‰¿ƒ}ƒXƒ^' ;
+
+create index constructionspecunitprice_Index1
+  on constructionspecunitprice(ConstructionTypeCode,ComponentCode,ItemCode);
+
+create index constructionspecunitprice_Index2
+  on constructionspecunitprice(ItemCode,SpecCode);
+
+Insert INTO constructionspecunitprice
+SELECT
+  ConstructionTypeCode
+  , ComponentCode
+  , ItemCode
+  , SpecCode
+  , UnitPrice
+  , EntryDate
+  , UpdateDate
+FROM constructionspecunitprice_OLD
+;
+commit;
Index: trunk/ddl/ŠÇ—�ƒ}ƒXƒ^•Ï�X.sql
===================================================================
--- trunk/ddl/ŠÇ—�ƒ}ƒXƒ^•Ï�X.sql	(nonexistent)
+++ trunk/ddl/ŠÇ—�ƒ}ƒXƒ^•Ï�X.sql	(revision 406)
@@ -0,0 +1,77 @@
+-- ŠÇ—�ƒ}ƒ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;
