Index: branches/ddl/20180406_SQL.txt
===================================================================
--- branches/ddl/20180406_SQL.txt	(nonexistent)
+++ branches/ddl/20180406_SQL.txt	(revision 342)
@@ -0,0 +1,24 @@
+-- •”��–ˆ�o”[ƒf�[ƒ^
+drop table if exists DepartmentCostData cascade; 
+
+CREATE TABLE DepartmentCostData( 
+  DepartmentCode DECIMAL (5, 0) UNSIGNED NOT NULL COMMENT '•”��ƒR�[ƒh'
+  , DataYear SMALLINT (5) UNSIGNED NOT NULL COMMENT '�HŽ–Šú�”�E�HŽ–”N�”'
+  , DataCount DECIMAL (5, 0) UNSIGNED NOT NULL COMMENT 'ƒf�[ƒ^”Ô�†'
+  , EntryPersonCode DECIMAL (8, 0) UNSIGNED NOT NULL COMMENT '“ü—Í’S“–ŽÒƒR�[ƒh'
+  , SuppliersCode DECIMAL (5, 0) UNSIGNED NOT NULL COMMENT 'Žx•¥�æƒR�[ƒh'
+  , SuppliersName VARCHAR (120) COMMENT 'Žx•¥�æ–¼�Ì'
+  , PaymentContent VARCHAR (60) COMMENT 'Žx•¥“à—e'
+  , DateOfBilling DATE NOT NULL COMMENT '�¿‹�“ú'
+  , DateOfPayment DATE NOT NULL COMMENT 'Žx•¥“ú'
+  , EntryPrice DECIMAL (12, 0) NOT NULL COMMENT '‹àŠz�i�Å”²�j'
+  , EntryPriceInTax DECIMAL (12, 0) NOT NULL COMMENT '‹àŠz�i�Å�ž�j'
+  , SlipNumber VARCHAR (12) COMMENT '“`•[”Ô�†'
+  , ComplateFlg DECIMAL (1, 0) NOT NULL COMMENT 'ˆø�ž�Ï‚Ýƒtƒ‰ƒO'
+  , ApprovalFlg DECIMAL (1, 0) NOT NULL COMMENT '�³”Fƒtƒ‰ƒO'
+  , EntryDate DATETIME NOT NULL COMMENT '“o˜^“ú•t'
+  , UpdateDate DATETIME NOT NULL COMMENT '�X�V“ú•t'
+  , CONSTRAINT DepartmentCostData_PKC PRIMARY KEY (DepartmentCode, DataYear, DataCount)
+) COMMENT '•”��–ˆ�o”[ƒf�[ƒ^'; 
+
+
Index: branches/ddl/20180411_SQL.txt
===================================================================
--- branches/ddl/20180411_SQL.txt	(nonexistent)
+++ branches/ddl/20180411_SQL.txt	(revision 342)
@@ -0,0 +1,153 @@
+-- ˆÄŒ��i’»“ú•tƒf�[ƒ^
+DROP TABLE IF EXISTS constructionprogressdate_OLD; 
+
+CREATE TABLE constructionprogressdate_OLD As 
+Select
+  * 
+from
+  constructionprogressdate; 
+
+drop table if exists constructionprogressdate cascade; 
+
+create table constructionprogressdate( 
+  ConstructionCode decimal (10, 0) not null comment '�HŽ–”Ô�†'
+  , ConstructionStatusFlg decimal (2, 0) not null comment '�Ý’è�HŽ–�ó‘Ô'
+  , PreviousStatusFlg decimal (2, 0) comment '•Ï�X‘O�ó‘Ô'
+  , ChangeDate datetime not null comment '�Ý’è“ú•t'
+  , ChangePersonCode decimal (8, 0) not null comment '�Ý’è’S“–ŽÒ'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint constructionprogressdate_PKC primary key (ConstructionCode, ChangeDate)
+) comment 'ˆÄŒ��i’»“ú•tƒf�[ƒ^'; 
+
+create index ConstrProg_Index1 
+  on constructionprogressdate(ConstructionCode); 
+
+create index ConstrProg_Index2 
+  on constructionprogressdate(ConstructionStatusFlg); 
+
+create index ConstrProg_Index3 
+  on constructionprogressdate(ChangeDate); 
+
+Insert 
+INTO constructionprogressdate 
+Select
+  * 
+from
+  constructionprogressdate_OLD; 
+
+-- �HŽ–�Ú�×‘ä’ Œo”ïƒf�[ƒ^
+drop table if exists ConstrLedgerExpenses cascade;
+
+create table ConstrLedgerExpenses (
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , SeqNo decimal(5,0) not null comment 'Ž}”Ô'
+  , NameCode decimal(5,0) unsigned not null comment 'Œo”ïƒR�[ƒh'
+  , ExpensesRaito decimal(4,2) not null comment 'Œo”ï—¦'
+  , ExpensesValue decimal(10,0) not null comment 'Œo”ï‹àŠz'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint ConstrLedgerExpenses_PKC primary key (ConstructionCode, SeqNo, NameCode)
+) comment '�HŽ–�Ú�×‘ä’ Œo”ïƒf�[ƒ^' ;
+
+create index ConstrLedgerExpenses_Index1
+  on ConstrLedgerExpenses(ConstructionCode);
+
+create index ConstrLedgerExpenses_Index2
+  on ConstrLedgerExpenses(SeqNo);
+
+create index ConstrLedgerExpenses_Index3
+  on ConstrLedgerExpenses(NameCode);
+
+Insert 
+INTO constrledgerexpenses 
+select
+  A.ConstructionCode
+  , 1
+  , A.ComponentCode
+  , A.AmountConfigRate
+  , A.ExecutionAmount 
+  , A.EntryDate
+  , A.UpdateDate
+from
+  constructionledgerdetail As A 
+where
+  A.GroupCount = 1 
+  And A.ComponentCode = 3; 
+
+Insert 
+INTO constrledgerexpenses 
+select
+  A.ConstructionCode
+  , 2
+  , A.ComponentCode
+  , A.AmountConfigRate
+  , A.ExecutionAmount 
+  , A.EntryDate
+  , A.UpdateDate
+from
+  constructionledgerdetail As A 
+where
+  A.GroupCount = 1 
+  And A.ComponentCode = 1; 
+
+Insert 
+INTO constrledgerexpenses 
+select
+  A.ConstructionCode
+  , 3
+  , A.ComponentCode
+  , A.AmountConfigRate
+  , A.ExecutionAmount 
+  , A.EntryDate
+  , A.UpdateDate
+from
+  constructionledgerdetail As A 
+where
+  A.GroupCount = 1 
+  And A.ComponentCode = 2; 
+
+
+-- •”��Œo”ï—¦ƒ}ƒXƒ^
+DROP TABLE IF EXISTS departmentexpensesmaster_OLD; 
+
+CREATE TABLE departmentexpensesmaster_OLD As 
+Select
+  * 
+from
+  departmentexpensesmaster; 
+
+drop table if exists departmentexpensesmaster cascade;
+
+create table departmentexpensesmaster (
+  DepartmentCode decimal(5,0) unsigned not null comment '•”��ƒR�[ƒh'
+  , ExpensesPeriod smallint(6) not null comment 'Ž–‹ÆŠú'
+  , NameCode decimal(5,0) unsigned not null comment 'Œo”ïƒR�[ƒh'
+  , NameString varchar(100) not null comment '–¼�Ì'
+  , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
+  , ExpensesRaito decimal(4,2) not null comment 'Œo”ï—¦'
+  , DeleteFlg decimal(1,0) not null comment '�í�œƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint departmentexpensesmaster_PKC primary key (DepartmentCode,ExpensesPeriod,NameCode)
+) comment '•”��Œo”ï—¦ƒ}ƒXƒ^' ;
+
+Insert 
+INTO departmentexpensesmaster 
+select
+  A.DepartmentCode
+  , A.ExpensesPeriod
+  , A.NameCode
+  , B.NameString
+  , A.DisplayOrder
+  , A.ExpensesRaito
+  , A.DeleteFlg
+  , A.EntryDate
+  , A.UpdateDate 
+from
+  departmentexpensesmaster_OLD As A 
+  LEFT JOIN divisionmaster AS B 
+    ON B.DivisionCode = 3 
+    And B.NameCode = A.NameCode; 
+
+commit;
Index: branches/ddl/ProcessManagement.sql
===================================================================
--- branches/ddl/ProcessManagement.sql	(revision 341)
+++ branches/ddl/ProcessManagement.sql	(revision 342)
@@ -1,5 +1,5 @@
 -- Project Name : noname
--- Date/Time    : 2018/04/06 11:54:53
+-- Date/Time    : 2018/04/12 9:06:32
 -- Author       : Horiuchi
 -- RDBMS Type   : MySQL
 -- Application  : A5:SQL Mk-2
@@ -462,6 +462,29 @@
   , constraint constrchgcharge_PKC primary key (ConstructionCode,Division,SeqNo)
 ) comment '�HŽ–’S“–—š—ðƒf�[ƒ^' ;
 
+-- �HŽ–�Ú�×‘ä’ Œo”ïƒf�[ƒ^
+drop table if exists constrledgerexpenses cascade;
+
+create table constrledgerexpenses (
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , SeqNo decimal(5,0) not null comment 'Ž}”Ô'
+  , NameCode decimal(5,0) unsigned not null comment 'Œo”ïƒR�[ƒh'
+  , ExpensesRaito decimal(4,2) not null comment 'Œo”ï—¦'
+  , ExpensesValue decimal(10,0) not null comment 'Œo”ï‹àŠz'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint constrledgerexpenses_PKC primary key (ConstructionCode,SeqNo,NameCode)
+) comment '�HŽ–�Ú�×‘ä’ Œo”ïƒf�[ƒ^' ;
+
+create index ConstrLedgerExpenses_Index1
+  on constrledgerexpenses(ConstructionCode);
+
+create index ConstrLedgerExpenses_Index2
+  on constrledgerexpenses(SeqNo);
+
+create index ConstrLedgerExpenses_Index3
+  on constrledgerexpenses(NameCode);
+
 -- �HŽ–Šî–{�î•ñ
 drop table if exists constructionbaseinfo cascade;
 
@@ -788,9 +811,18 @@
   , ChangePersonCode decimal(8,0) not null comment '�Ý’è’S“–ŽÒ'
   , EntryDate datetime not null comment '“o˜^“ú•t'
   , UpdateDate datetime not null comment '�X�V“ú•t'
-  , constraint constructionprogressdate_PKC primary key (ConstructionCode,ConstructionStatusFlg)
+  , constraint constructionprogressdate_PKC primary key (ConstructionCode,ChangeDate)
 ) comment 'ˆÄŒ��i’»“ú•tƒf�[ƒ^' ;
 
+create index ConstrProg_Index1
+  on constructionprogressdate(ConstructionCode);
+
+create index ConstrProg_Index2
+  on constructionprogressdate(ConstructionStatusFlg);
+
+create index ConstrProg_Index3
+  on constructionprogressdate(ChangeDate);
+
 -- �ì‹Æƒ}ƒXƒ^
 drop table if exists constructionspecmaster cascade;
 
@@ -1068,7 +1100,8 @@
 create table departmentexpensesmaster (
   DepartmentCode decimal(5,0) unsigned not null comment '•”��ƒR�[ƒh'
   , ExpensesPeriod smallint(6) not null comment 'Ž–‹ÆŠú'
-  , NameCode decimal(5,0) unsigned not null comment 'Œo”ï–¼�ÌƒR�[ƒh'
+  , NameCode decimal(5,0) unsigned not null comment 'Œo”ïƒR�[ƒh'
+  , NameString varchar(100) not null comment '–¼�Ì'
   , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
   , ExpensesRaito decimal(4,2) not null comment 'Œo”ï—¦'
   , DeleteFlg decimal(1,0) not null comment '�í�œƒtƒ‰ƒO'
@@ -1713,6 +1746,9 @@
 create index PersonSalaryMaster_Index2
   on personsalarymaster(StartDate);
 
+create index PersonSalaryMaster_Index3
+  on personsalarymaster(MonthlySalary);
+
 -- ŽwŽ¦Ž–�€ƒf�[ƒ^
 drop table if exists pointingoutcomment cascade;
 
Index: branches/ddl/ƒe�[ƒuƒ‹Žd—l�‘.xlsx
===================================================================
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
