Index: branches/ddl/20171221_SQL.txt
===================================================================
--- branches/ddl/20171221_SQL.txt	(nonexistent)
+++ branches/ddl/20171221_SQL.txt	(revision 322)
@@ -0,0 +1,143 @@
+-- �HŽ–Šî–{�î•ñ
+DROP TABLE IF EXISTS constructionbaseinfo_OLD;
+CREATE TABLE constructionbaseinfo_OLD As Select * from constructionbaseinfo;
+
+drop table if exists constructionbaseinfo cascade;
+
+create table constructionbaseinfo (
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , TyingFlg decimal(1,0) not null comment '•R•tƒf�[ƒ^ƒtƒ‰ƒO'
+  , JoinFlg decimal(1,0) not null comment 'Œ‹�‡Œ_–ñ�HŽ–ƒtƒ‰ƒO'
+  , ConstructionYear smallint(5) unsigned not null comment '�HŽ–”N“x'
+  , ConstructionPeriod smallint(5) unsigned not null comment '�HŽ–Šú�”'
+  , RequestedDate date comment 'ˆË—ŠŽó‚¯“ú'
+  , EstimatesSubmitDeadline date comment 'Œ©�Ï’ñ�oŠúŒÀ'
+  , EstimatesSubmittedDate date comment 'Œ©�Ï’ñ�o“ú'
+  , ProvisionalOrderDate date comment '‰¼Žó’�“ú'
+  , OrderDate date comment 'Žó’�“ú'
+  , OrderStartingDate date comment 'ŠJŽn—\’è“ú'
+  , OrderCompletionDate date comment 'Š®—¹—\’è“ú'
+  , PreparationStartDate date comment 'Ž{�H�€”õŠJŽn“ú'
+  , ConstructionStartingDate date comment 'Ž{�HŠJŽn“ú'
+  , ConstructionCompletionDate date comment 'Ž{�HŠ®—¹“ú'
+  , NonOrderDate date comment '”ñŽó’�“ú'
+  , OrdersDecisionPrice decimal(12,0) not null comment '�Å”²Žó’�Œˆ’è‹àŠz'
+  , OrdersDecisionPriceInTax decimal(12,0) not null comment '�Å�žŽó’�Œˆ’è‹àŠz'
+  , SalesPersonCode decimal(8,0) comment '‰c‹Æ’S“–ŽÒ–¼'
+  , ConstructionPersonCode decimal(8,0) not null comment '�HŽ–’S“–ŽÒ'
+  , ConstrSubPersonCode decimal(8,0) not null comment '�HŽ–•›’S“–ŽÒ'
+  , ConstructionInstructor decimal(8,0) not null comment '�HŽ–Žw“±ˆõ'
+  , TransferConstruction decimal(8,0) not null comment '�HŽ–ˆÚŠÇ�æƒR�[ƒh'
+  , TransferConstructionDate date comment '�HŽ–ˆÚŠÇ“ú'
+  , OrderersDivision decimal(5,0) not null comment '”­’�ŽÒ‹æ•ª'
+  , OrderersCode decimal(5,0) unsigned not null comment '”­’�ŽÒƒR�[ƒh'
+  , EstimatesExpirationDate date comment 'Œ©�Ï—LŒøŠúŒÀ'
+  , ConstructionPeriodStart date comment 'Œ_–ñ�HŠúŠJŽn“ú'
+  , ConstructionPeriodEnd date comment 'Œ_–ñ�HŠúŠ®—¹'
+  , ConstructionPeriodStart2 date comment 'Œ_–ñ�HŠúŠJŽn�i‰„’·Žž�j'
+  , ConstructionPeriodEnd2 date comment 'Œ_–ñ�HŠúŠ®—¹�i‰„’·Žž�j'
+  , StartDate date comment '�HŽ–ŠJŽn“ú'
+  , EndDate date comment '�HŽ–�I—¹“ú'
+  , PurchaseOrderMailingDate date comment '’�•¶�‘—X‘—“ú'
+  , PurchaseOrderReturnDate date comment '’�•¶�‘•Ô‘—“ú'
+  , PurchaseOrderReturnCheckDate date comment '’�•¶�‘•Ô‘—Šm”F“ú'
+  , ConsumptionTaxFlg decimal(1,0) not null comment '�Á”ï�Åƒtƒ‰ƒO'
+  , PrimeContractorFlg decimal(1,0) not null comment 'Œ³�¿ƒtƒ‰ƒO'
+  , SalesCostFlg decimal(1,0) not null comment '‰c‹ÆŒo”ï”­�¶ƒtƒ‰ƒO'
+  , ConstructionStatusFlg decimal(2,0) not null comment '�HŽ–�ó‘Ôƒtƒ‰ƒO'
+  , ConstructionType decimal(5,0) not null comment '�HŽ–Ží•ÊƒR�[ƒh'
+  , EstimateType decimal(1,0) not null comment 'Œ©�ÏŽí•Ê'
+  , BillingStartDate date not null comment '�¿‹��€”õŠJŽn“ú'
+  , BillingDate date not null comment '�¿‹�“ú'
+  , BillingSplitFlg decimal(1,0) not null comment '�¿‹�‰ñ�”ƒtƒ‰ƒO'
+  , BillingSendDate date comment '�¿‹��‘—X‘—/Žè“n‚µ“ú'
+  , LedgerComplateDate date not null comment '�HŽ–�Ú�×‘ä’ “ü—ÍŠ®—¹“ú•t'
+  , InspectPlanningDate date not null comment 'ŒŸ�¸—\’è“ú'
+  , InspectExecuteDate date not null comment 'ŒŸ�¸ŽÀ�s“ú'
+  , RevCompleteDate date not null comment 'ŒŸ�¸�¥�³Š®—¹“ú'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint constructionbaseinfo_PKC primary key (ConstructionCode)
+) comment '�HŽ–Šî–{�î•ñ' ;
+
+create index BaseInfo_Index1
+  on constructionbaseinfo(ConstructionStatusFlg);
+
+create index BaseInfo_Index2
+  on constructionbaseinfo(EstimateType);
+
+create index BaseInfo_Index3
+  on constructionbaseinfo(SalesPersonCode);
+
+create index BaseInfo_Index4
+  on constructionbaseinfo(ConstructionPersonCode);
+
+create index BaseInfo_Index5
+  on constructionbaseinfo(ConstructionInstructor);
+
+create index BaseInfo_Index6
+  on constructionbaseinfo(ConstructionPeriod);
+
+Insert INTO constructionbaseinfo
+SELECT
+  ConstructionCode
+  , TyingFlg
+  , JoinFlg 
+  , ConstructionYear 
+  , ConstructionPeriod 
+  , RequestedDate 
+  , EstimatesSubmitDeadline 
+  , EstimatesSubmittedDate 
+  , ProvisionalOrderDate 
+  , OrderDate 
+  , OrderStartingDate 
+  , OrderCompletionDate 
+  , PreparationStartDate 
+  , ConstructionStartingDate 
+  , ConstructionCompletionDate 
+  , NonOrderDate 
+  , OrdersDecisionPrice 
+  , OrdersDecisionPriceInTax 
+  , SalesPersonCode 
+  , ConstructionPersonCode 
+  , ConstrSubPersonCode 
+  , ConstructionInstructor 
+  , TransferConstruction 
+  , TransferConstructionDate 
+  , OrderersDivision 
+  , OrderersCode 
+  , EstimatesExpirationDate 
+  , ConstructionPeriodStart 
+  , ConstructionPeriodEnd 
+  , ConstructionPeriodStart2 
+  , ConstructionPeriodEnd2 
+  , StartDate 
+  , EndDate 
+  , PurchaseOrderMailingDate 
+  , PurchaseOrderReturnDate 
+  , PurchaseOrderReturnCheckDate 
+  , ConsumptionTaxFlg 
+  , PrimeContractorFlg 
+  , SalesCostFlg 
+  , ConstructionStatusFlg 
+  , ConstructionType 
+  , EstimateType 
+  , BillingStartDate 
+  , BillingDate 
+  , BillingSplitFlg 
+  , BillingSendDate 
+  , LedgerComplateDate 
+  , STR_TO_DATE('0001/01/01', '%Y/%m/%d')
+  , STR_TO_DATE('0001/01/01', '%Y/%m/%d')
+  , STR_TO_DATE('0001/01/01', '%Y/%m/%d')
+  , EntryDate
+  , UpdateDate
+FROM constructionbaseinfo_OLD
+;
+
+-- �HŽ–Šî–{�î•ñ–¾�×
+ALTER TABLE constructionbaseinfodetail
+CHANGE DetailString DetailString 
+varchar(300)
+comment '–¾�×“à—e';
+commit;
Index: branches/ddl/20180118_SQL.txt
===================================================================
--- branches/ddl/20180118_SQL.txt	(nonexistent)
+++ branches/ddl/20180118_SQL.txt	(revision 322)
@@ -0,0 +1,143 @@
+-- �HŽ–Šî–{�î•ñ
+DROP TABLE IF EXISTS constructionbaseinfo_OLD;
+CREATE TABLE constructionbaseinfo_OLD As Select * from constructionbaseinfo;
+
+drop table if exists constructionbaseinfo cascade;
+
+create table constructionbaseinfo (
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , TyingFlg decimal(1,0) not null comment '•R•tƒf�[ƒ^ƒtƒ‰ƒO'
+  , JoinFlg decimal(1,0) not null comment 'Œ‹�‡Œ_–ñ�HŽ–ƒtƒ‰ƒO'
+  , ConstructionYear smallint(5) unsigned not null comment '�HŽ–”N“x'
+  , ConstructionPeriod smallint(5) unsigned not null comment '�HŽ–Šú�”'
+  , RequestedDate date comment 'ˆË—ŠŽó‚¯“ú'
+  , EstimatesSubmitDeadline date comment 'Œ©�Ï’ñ�oŠúŒÀ'
+  , EstimatesSubmittedDate date comment 'Œ©�Ï’ñ�o“ú'
+  , ProvisionalOrderDate date comment '‰¼Žó’�“ú'
+  , OrderDate date comment 'Žó’�“ú'
+  , OrderStartingDate date comment 'ŠJŽn—\’è“ú'
+  , OrderCompletionDate date comment 'Š®—¹—\’è“ú'
+  , PreparationStartDate date comment 'Ž{�H�€”õŠJŽn“ú'
+  , ConstructionStartingDate date comment 'Ž{�HŠJŽn“ú'
+  , ConstructionCompletionDate date comment 'Ž{�HŠ®—¹“ú'
+  , NonOrderDate date comment '”ñŽó’�“ú'
+  , OrdersDecisionPrice decimal(12,0) not null comment '�Å”²Žó’�Œˆ’è‹àŠz'
+  , OrdersDecisionPriceInTax decimal(12,0) not null comment '�Å�žŽó’�Œˆ’è‹àŠz'
+  , SalesPersonCode decimal(8,0) comment '‰c‹Æ’S“–ŽÒ–¼'
+  , ConstructionPersonCode decimal(8,0) not null comment '�HŽ–’S“–ŽÒ'
+  , ConstrSubPersonCode decimal(8,0) not null comment '�HŽ–•›’S“–ŽÒ'
+  , ConstructionInstructor decimal(8,0) not null comment '�HŽ–Žw“±ˆõ'
+  , TransferConstruction decimal(8,0) not null comment '�HŽ–ˆÚŠÇ�æƒR�[ƒh'
+  , TransferConstructionDate date comment '�HŽ–ˆÚŠÇ“ú'
+  , OrderersDivision decimal(5,0) not null comment '”­’�ŽÒ‹æ•ª'
+  , OrderersCode decimal(5,0) unsigned not null comment '”­’�ŽÒƒR�[ƒh'
+  , EstimatesExpirationDate date comment 'Œ©�Ï—LŒøŠúŒÀ'
+  , ConstructionPeriodStart date comment 'Œ_–ñ�HŠúŠJŽn“ú'
+  , ConstructionPeriodEnd date comment 'Œ_–ñ�HŠúŠ®—¹'
+  , ConstructionPeriodStart2 date comment 'Œ_–ñ�HŠúŠJŽn�i‰„’·Žž�j'
+  , ConstructionPeriodEnd2 date comment 'Œ_–ñ�HŠúŠ®—¹�i‰„’·Žž�j'
+  , StartDate date comment '�HŽ–ŠJŽn“ú'
+  , EndDate date comment '�HŽ–�I—¹“ú'
+  , PurchaseOrderMailingDate date comment '’�•¶�‘—X‘—“ú'
+  , PurchaseOrderReturnDate date comment '’�•¶�‘•Ô‘—“ú'
+  , PurchaseOrderReturnCheckDate date comment '’�•¶�‘•Ô‘—Šm”F“ú'
+  , ConsumptionTaxFlg decimal(1,0) not null comment '�Á”ï�Åƒtƒ‰ƒO'
+  , PrimeContractorFlg decimal(1,0) not null comment 'Œ³�¿ƒtƒ‰ƒO'
+  , SalesCostFlg decimal(1,0) not null comment '‰c‹ÆŒo”ï”­�¶ƒtƒ‰ƒO'
+  , ConstructionStatusFlg decimal(2,0) not null comment '�HŽ–�ó‘Ôƒtƒ‰ƒO'
+  , ConstructionType decimal(5,0) not null comment '�HŽ–Ží•ÊƒR�[ƒh'
+  , EstimateType decimal(1,0) not null comment 'Œ©�ÏŽí•Ê'
+  , BillingStartDate date not null comment '�¿‹��€”õŠJŽn“ú'
+  , BillingDate date not null comment '�¿‹�“ú'
+  , BillingSplitFlg decimal(1,0) not null comment '�¿‹�‰ñ�”ƒtƒ‰ƒO'
+  , BillingSendDate date comment '�¿‹��‘—X‘—/Žè“n‚µ“ú'
+  , LedgerComplateDate date not null comment '�HŽ–�Ú�×‘ä’ “ü—ÍŠ®—¹“ú•t'
+  , InspectPlanningDate date not null comment 'ŒŸ�¸—\’è“ú'
+  , InspectExecuteDate date not null comment 'ŒŸ�¸ŽÀ�s“ú'
+  , RevCompleteDate date not null comment 'ŒŸ�¸�¥�³Š®—¹“ú'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint constructionbaseinfo_PKC primary key (ConstructionCode)
+) comment '�HŽ–Šî–{�î•ñ' ;
+
+create index BaseInfo_Index1
+  on constructionbaseinfo(ConstructionStatusFlg);
+
+create index BaseInfo_Index2
+  on constructionbaseinfo(EstimateType);
+
+create index BaseInfo_Index3
+  on constructionbaseinfo(SalesPersonCode);
+
+create index BaseInfo_Index4
+  on constructionbaseinfo(ConstructionPersonCode);
+
+create index BaseInfo_Index5
+  on constructionbaseinfo(ConstructionInstructor);
+
+create index BaseInfo_Index6
+  on constructionbaseinfo(ConstructionPeriod);
+
+Insert INTO constructionbaseinfo
+SELECT
+  ConstructionCode
+  , TyingFlg
+  , JoinFlg 
+  , ConstructionYear 
+  , ConstructionPeriod 
+  , RequestedDate 
+  , EstimatesSubmitDeadline 
+  , EstimatesSubmittedDate 
+  , ProvisionalOrderDate 
+  , OrderDate 
+  , OrderStartingDate 
+  , OrderCompletionDate 
+  , PreparationStartDate 
+  , ConstructionStartingDate 
+  , ConstructionCompletionDate 
+  , NonOrderDate 
+  , OrdersDecisionPrice 
+  , OrdersDecisionPriceInTax 
+  , SalesPersonCode 
+  , ConstructionPersonCode 
+  , ConstrSubPersonCode 
+  , ConstructionInstructor 
+  , TransferConstruction 
+  , TransferConstructionDate 
+  , OrderersDivision 
+  , OrderersCode 
+  , EstimatesExpirationDate 
+  , ConstructionPeriodStart 
+  , ConstructionPeriodEnd 
+  , ConstructionPeriodStart2 
+  , ConstructionPeriodEnd2 
+  , StartDate 
+  , EndDate 
+  , PurchaseOrderMailingDate 
+  , PurchaseOrderReturnDate 
+  , PurchaseOrderReturnCheckDate 
+  , ConsumptionTaxFlg 
+  , PrimeContractorFlg 
+  , SalesCostFlg 
+  , ConstructionStatusFlg 
+  , ConstructionType 
+  , EstimateType 
+  , BillingStartDate 
+  , BillingDate 
+  , BillingSplitFlg 
+  , BillingSendDate 
+  , LedgerComplateDate 
+  , STR_TO_DATE('0001/01/01', '%Y/%m/%d')
+  , STR_TO_DATE('0001/01/01', '%Y/%m/%d')
+  , STR_TO_DATE('0001/01/01', '%Y/%m/%d')
+  , EntryDate
+  , UpdateDate
+FROM constructionbaseinfo_OLD
+;
+
+-- �HŽ–Šî–{�î•ñ–¾�×
+ALTER TABLE constructionbaseinfodetail
+CHANGE DetailString DetailString 
+varchar(300)
+comment '–¾�×“à—e';
+commit;
Index: branches/ddl/20180203_SQL.txt
===================================================================
--- branches/ddl/20180203_SQL.txt	(nonexistent)
+++ branches/ddl/20180203_SQL.txt	(revision 322)
@@ -0,0 +1,5 @@
+-- Žx•¥–¾�×ƒf�[ƒ^
+create index PayDataDetail_Index1
+  on paymentdatadetail(TARGETDATE);
+create index PayDataDetail_Index2
+  on paymentdatadetail(APPROVALPERSONCODE);
Index: branches/ddl/ProcessManagement.sql
===================================================================
--- branches/ddl/ProcessManagement.sql	(revision 321)
+++ branches/ddl/ProcessManagement.sql	(revision 322)
@@ -1,5 +1,5 @@
 -- Project Name : noname
--- Date/Time    : 2017/12/12 10:48:17
+-- Date/Time    : 2018/02/27 8:14:07
 -- Author       : Horiuchi
 -- RDBMS Type   : MySQL
 -- Application  : A5:SQL Mk-2
@@ -470,6 +470,9 @@
   , BillingSplitFlg decimal(1,0) not null comment '�¿‹�‰ñ�”ƒtƒ‰ƒO'
   , BillingSendDate date comment '�¿‹��‘—X‘—/Žè“n‚µ“ú'
   , LedgerComplateDate date not null comment '�HŽ–�Ú�×‘ä’ “ü—ÍŠ®—¹“ú•t'
+  , InspectPlanningDate date not null comment 'ŒŸ�¸—\’è“ú'
+  , InspectExecuteDate date not null comment 'ŒŸ�¸ŽÀ�s“ú'
+  , RevCompleteDate date not null comment 'ŒŸ�¸�¥�³Š®—¹“ú'
   , EntryDate datetime not null comment '“o˜^“ú•t'
   , UpdateDate datetime not null comment '�X�V“ú•t'
   , constraint constructionbaseinfo_PKC primary key (ConstructionCode)
@@ -499,7 +502,7 @@
 create table constructionbaseinfodetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , DetailNo decimal(2,0) not null comment '–¾�×”Ô�†'
-  , DetailString varchar(120) comment '–¾�×“à—e'
+  , DetailString varchar(300) comment '–¾�×“à—e'
   , EntryDate datetime not null comment '“o˜^“ú•t'
   , UpdateDate datetime not null comment '�X�V“ú•t'
   , constraint constructionbaseinfodetail_PKC primary key (ConstructionCode,DetailNo)
@@ -1509,6 +1512,12 @@
   , constraint paymentdatadetail_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT)
 ) comment 'Žx•¥–¾�×ƒf�[ƒ^' ;
 
+create index PayDataDetail_Index1
+  on paymentdatadetail(TARGETDATE);
+
+create index PayDataDetail_Index2
+  on paymentdatadetail(APPROVALPERSONCODE);
+
 -- �HŽ–ŠúŒÀ‰ñ”ðƒf�[ƒ^
 drop table if exists periodavoidance cascade;
 
