Index: branches/ddl/ProcessManagement.sql
===================================================================
--- branches/ddl/ProcessManagement.sql	(revision 323)
+++ branches/ddl/ProcessManagement.sql	(revision 324)
@@ -1,11 +1,11 @@
 -- Project Name : noname
--- Date/Time    : 2018/02/27 8:14:07
+-- Date/Time    : 2018/03/01 9:30:55
 -- Author       : Horiuchi
 -- RDBMS Type   : MySQL
 -- Application  : A5:SQL Mk-2
 
 -- ’S“–ŽÒ�s“®—\’èƒf�[ƒ^
-drop table if exists actionscheduledata cascade;
+drop table actionscheduledata cascade;
 
 create table actionscheduledata (
   TargetDate date not null comment '‘Î�Û“ú'
@@ -29,7 +29,7 @@
   on actionscheduledata(TargetDay);
 
 -- �³”FŒo˜Hƒ}ƒXƒ^
-drop table if exists approvalmaster cascade;
+drop table approvalmaster cascade;
 
 create table approvalmaster (
   ApprovalCode decimal(3,0) unsigned not null comment '�³”F‹@”\”Ô�†'
@@ -44,7 +44,7 @@
 ) comment '�³”FŒo˜Hƒ}ƒXƒ^' ;
 
 -- �o‹Î“ú•ñƒf�[ƒ^
-drop table if exists attendancedailydata cascade;
+drop table attendancedailydata cascade;
 
 create table attendancedailydata (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
@@ -69,7 +69,7 @@
   on attendancedailydata(AttendanceDate);
 
 -- �o‹ÎŠÇ—�ƒf�[ƒ^
-drop table if exists attendancedata cascade;
+drop table attendancedata cascade;
 
 create table attendancedata (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
@@ -85,7 +85,7 @@
 ) comment '�o‹ÎŠÇ—�ƒf�[ƒ^' ;
 
 -- ‹â�s‰c‹Æ“úƒ}ƒXƒ^
-drop table if exists bankbusinessdaymaster cascade;
+drop table bankbusinessdaymaster cascade;
 
 create table bankbusinessdaymaster (
   YEARMONTH decimal(6,0) default '0' not null comment '”NŒŽ'
@@ -98,7 +98,7 @@
 ) comment '‹â�s‰c‹Æ“úƒ}ƒXƒ^' ;
 
 -- ‹ÆŽÒ�¿‹�ƒf�[ƒ^
-drop table if exists billingdata cascade;
+drop table billingdata cascade;
 
 create table billingdata (
   COMPANYCODE decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
@@ -111,7 +111,7 @@
 ) comment '‹ÆŽÒ�¿‹�ƒf�[ƒ^' ;
 
 -- ‹ÆŽÒ�¿‹�–¾�×ƒf�[ƒ^
-drop table if exists billingdatadetail cascade;
+drop table billingdatadetail cascade;
 
 create table billingdatadetail (
   COMPANYCODE decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
@@ -133,7 +133,7 @@
 ) comment '‹ÆŽÒ�¿‹�–¾�×ƒf�[ƒ^' ;
 
 -- ‹ÆŽÒ�¿‹�Žx•¥ƒTƒ}ƒŠ�[ƒf�[ƒ^
-drop table if exists billingpaymentsummary cascade;
+drop table billingpaymentsummary cascade;
 
 create table billingpaymentsummary (
   COMPANYCODE decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
@@ -154,8 +154,21 @@
   , constraint billingpaymentsummary_PKC primary key (COMPANYCODE,TARGETDATE,CHARGEPAYMENTKIND)
 ) comment '‹ÆŽÒ�¿‹�Žx•¥ƒTƒ}ƒŠ�[ƒf�[ƒ^' ;
 
+-- ‰^‰cŠú—š—ð�î•ñ
+drop table bizperiodhistory cascade;
+
+create table bizperiodhistory (
+  PeriodYear smallint(6) not null comment '‰c‹ÆŠú�”�E�HŽ–”N“x'
+  , PeriodFlag smallint(1) not null comment '‰c‹ÆŠú�”�E�HŽ–”N“xƒtƒ‰ƒO'
+  , BeginDate datetime not null comment 'ŠúŽñ“ú'
+  , CompleteDate datetime not null comment 'Šú––“ú'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint bizperiodhistory_PKC primary key (PeriodYear,PeriodFlag)
+) comment '‰^‰cŠú—š—ð�î•ñ' ;
+
 -- �HŽ–�Ú�×‘ä’ ƒf�[ƒ^�y‘Þ”ð—p�z
-drop table if exists bk_constructionledger cascade;
+drop table bk_constructionledger cascade;
 
 create table bk_constructionledger (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -182,7 +195,7 @@
 ) comment '�HŽ–�Ú�×‘ä’ ƒf�[ƒ^�y‘Þ”ð—p�z' ;
 
 -- �HŽ–�Ú�×‘ä’ –¾�×ƒf�[ƒ^�y‘Þ”ð—p�z
-drop table if exists bk_constructionledgerdetail cascade;
+drop table bk_constructionledgerdetail cascade;
 
 create table bk_constructionledgerdetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -215,7 +228,7 @@
 ) comment '�HŽ–�Ú�×‘ä’ –¾�×ƒf�[ƒ^�y‘Þ”ð—p�z' ;
 
 -- �HŽ–�Ú�×‘ä’ ŽÀ�sƒf�[ƒ^�y‘Þ”ð—p�z
-drop table if exists bk_constructionledgerexcute cascade;
+drop table bk_constructionledgerexcute cascade;
 
 create table bk_constructionledgerexcute (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -230,7 +243,7 @@
 ) comment '�HŽ–�Ú�×‘ä’ ŽÀ�sƒf�[ƒ^�y‘Þ”ð—p�z' ;
 
 -- �ÏŽZŒ©�Ïƒf�[ƒ^�y‘Þ”ð—p�z
-drop table if exists bk_estimatedata cascade;
+drop table bk_estimatedata cascade;
 
 create table bk_estimatedata (
   SaveDate datetime not null comment '‘Þ”ð“ú•t'
@@ -250,7 +263,7 @@
 ) comment '�ÏŽZŒ©�Ïƒf�[ƒ^�y‘Þ”ð—p�z' ;
 
 -- �ÏŽZŒ©�Ïƒy�[ƒWƒf�[ƒ^�y‘Þ”ð—p�z
-drop table if exists bk_estimatedatabody cascade;
+drop table bk_estimatedatabody cascade;
 
 create table bk_estimatedatabody (
   SaveDate datetime not null comment '‘Þ”ð“ú•t'
@@ -269,7 +282,7 @@
 ) comment '�ÏŽZŒ©�Ïƒy�[ƒWƒf�[ƒ^�y‘Þ”ð—p�z' ;
 
 -- �ÏŽZŒ©�Ïƒf�[ƒ^–¾�×�y‘Þ”ð—p�z
-drop table if exists bk_estimatedatadetail cascade;
+drop table bk_estimatedatadetail cascade;
 
 create table bk_estimatedatadetail (
   SaveDate datetime not null comment '‘Þ”ð“ú•t'
@@ -296,7 +309,7 @@
 ) comment '�ÏŽZŒ©�Ïƒf�[ƒ^–¾�×�y‘Þ”ð—p�z' ;
 
 -- –@�lŠiƒ}ƒXƒ^
-drop table if exists businesstypemaster cascade;
+drop table businesstypemaster cascade;
 
 create table businesstypemaster (
   BusinessTypeCode decimal(5,0) unsigned not null comment '–@�lŠiƒR�[ƒh'
@@ -311,7 +324,7 @@
   on businesstypemaster(DisplayOrder);
 
 -- ‹¤’Ê”ï‘å�€–Úƒ}ƒXƒ^
-drop table if exists commoncostlarge cascade;
+drop table commoncostlarge cascade;
 
 create table commoncostlarge (
   LargeCode decimal(5,0) unsigned not null comment '‘å�€–ÚƒL�['
@@ -325,7 +338,7 @@
 ) comment '‹¤’Ê”ï‘å�€–Úƒ}ƒXƒ^' ;
 
 -- ‹¤’Ê”ï�HŽíŠÖ˜Aƒ}ƒXƒ^
-drop table if exists commoncostlinkms cascade;
+drop table commoncostlinkms cascade;
 
 create table commoncostlinkms (
   LargeCode decimal(5,0) unsigned not null comment '‘å�€–ÚƒL�['
@@ -337,7 +350,7 @@
 ) comment '‹¤’Ê”ï�HŽíŠÖ˜Aƒ}ƒXƒ^' ;
 
 -- ‹¤’Ê”ï’†�€–Úƒ}ƒXƒ^
-drop table if exists commoncostmiddle cascade;
+drop table commoncostmiddle cascade;
 
 create table commoncostmiddle (
   LargeCode decimal(5,0) unsigned not null comment '‘å�€–ÚƒL�['
@@ -352,7 +365,7 @@
 ) comment '‹¤’Ê”ï’†�€–Úƒ}ƒXƒ^' ;
 
 -- ‹¤’Ê”ï’†�€–ÚƒL�[ƒ}ƒXƒ^
-drop table if exists commoncostmiddlesearchword cascade;
+drop table commoncostmiddlesearchword cascade;
 
 create table commoncostmiddlesearchword (
   LargeCode decimal(5,0) unsigned not null comment '‘å�€–ÚƒL�['
@@ -365,7 +378,7 @@
 ) comment '‹¤’Ê”ï’†�€–ÚƒL�[ƒ}ƒXƒ^' ;
 
 -- �\�¬�HŽíŠÖ˜Aƒ}ƒXƒ^
-drop table if exists componentlinkmaster cascade;
+drop table componentlinkmaster cascade;
 
 create table componentlinkmaster (
   ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
@@ -383,7 +396,7 @@
   on componentlinkmaster(ItemCode);
 
 -- �\�¬ƒ}ƒXƒ^
-drop table if exists componentmaster cascade;
+drop table componentmaster cascade;
 
 create table componentmaster (
   ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
@@ -402,7 +415,7 @@
   on componentmaster(DisplayOrder);
 
 -- �\�¬�HŽ–Ží•ÊŠÖ˜Aƒ}ƒXƒ^
-drop table if exists componenttotypemaster cascade;
+drop table componenttotypemaster cascade;
 
 create table componenttotypemaster (
   ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
@@ -420,7 +433,7 @@
   on componenttotypemaster(TypeCode);
 
 -- �HŽ–Šî–{�î•ñ
-drop table if exists constructionbaseinfo cascade;
+drop table constructionbaseinfo cascade;
 
 create table constructionbaseinfo (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -497,7 +510,7 @@
   on constructionbaseinfo(ConstructionPeriod);
 
 -- �HŽ–Šî–{�î•ñ–¾�×
-drop table if exists constructionbaseinfodetail cascade;
+drop table constructionbaseinfodetail cascade;
 
 create table constructionbaseinfodetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -515,7 +528,7 @@
   on constructionbaseinfodetail(DetailNo);
 
 -- �HŽ–Ž{�H—\ŽZƒf�[ƒ^
-drop table if exists constructionbudget cascade;
+drop table constructionbudget cascade;
 
 create table constructionbudget (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -546,7 +559,7 @@
 ) comment '�HŽ–Ž{�H—\ŽZƒf�[ƒ^' ;
 
 -- �HŽ–Ž{�H—\ŽZƒf�[ƒ^–¾�×
-drop table if exists constructionbudgetdetail cascade;
+drop table constructionbudgetdetail cascade;
 
 create table constructionbudgetdetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -571,7 +584,7 @@
 ) comment '�HŽ–Ž{�H—\ŽZƒf�[ƒ^–¾�×' ;
 
 -- �HŽíƒ}ƒXƒ^
-drop table if exists constructionitemmaster cascade;
+drop table constructionitemmaster cascade;
 
 create table constructionitemmaster (
   ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
@@ -586,7 +599,7 @@
 ) comment '�HŽíƒ}ƒXƒ^' ;
 
 -- �HŽ–�Ú�×‘ä’ ƒf�[ƒ^
-drop table if exists constructionledger cascade;
+drop table constructionledger cascade;
 
 create table constructionledger (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -613,7 +626,7 @@
 ) comment '�HŽ–�Ú�×‘ä’ ƒf�[ƒ^' ;
 
 -- �HŽ–�Ú�×‘ä’ –¾�×ƒf�[ƒ^
-drop table if exists constructionledgerdetail cascade;
+drop table constructionledgerdetail cascade;
 
 create table constructionledgerdetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -662,7 +675,7 @@
   on constructionledgerdetail(DetailCount);
 
 -- �HŽ–�Ú�×‘ä’ ŽÀ�sƒf�[ƒ^
-drop table if exists constructionledgerexcute cascade;
+drop table constructionledgerexcute cascade;
 
 create table constructionledgerexcute (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -680,7 +693,7 @@
   on constructionledgerexcute(ConstructionCode,TargetMonth,GroupCount,LineCount);
 
 -- �HŽ–ƒŠƒ“ƒN�î•ñ
-drop table if exists constructionlink cascade;
+drop table constructionlink cascade;
 
 create table constructionlink (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -701,7 +714,7 @@
   on constructionlink(LinkType);
 
 -- �HŽ–Ž‘�Þ�î•ñ
-drop table if exists constructionmaterialinfo cascade;
+drop table constructionmaterialinfo cascade;
 
 create table constructionmaterialinfo (
   CONSTRUCTIONCODE int(10) unsigned default 0 not null comment '�HŽ–”Ô�†'
@@ -717,7 +730,7 @@
 ) comment '�HŽ–Ž‘�Þ�î•ñ' ;
 
 -- ˆÄŒ��i’»“ú•tƒf�[ƒ^
-drop table if exists constructionprogressdate cascade;
+drop table constructionprogressdate cascade;
 
 create table constructionprogressdate (
   ConstructionCode decimal(10,0) not null comment '�HŽ–”Ô�†'
@@ -731,7 +744,7 @@
 ) comment 'ˆÄŒ��i’»“ú•tƒf�[ƒ^' ;
 
 -- �ì‹Æƒ}ƒXƒ^
-drop table if exists constructionspecmaster cascade;
+drop table constructionspecmaster cascade;
 
 create table constructionspecmaster (
   ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
@@ -751,7 +764,7 @@
   on constructionspecmaster(DisplayOrder);
 
 -- �ì‹Æ’P‰¿ƒ}ƒXƒ^
-drop table if exists constructionspecunitprice cascade;
+drop table constructionspecunitprice cascade;
 
 create table constructionspecunitprice (
   ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
@@ -765,7 +778,7 @@
 ) comment '�ì‹Æ’P‰¿ƒ}ƒXƒ^' ;
 
 -- �HŽ–Ží•Êƒ}ƒXƒ^
-drop table if exists constructiontypemaster cascade;
+drop table constructiontypemaster cascade;
 
 create table constructiontypemaster (
   TypeCode decimal(5,0) unsigned not null comment '�HŽ–Ží•ÊƒR�[ƒh'
@@ -781,7 +794,7 @@
 ) comment '�HŽ–Ží•Êƒ}ƒXƒ^' ;
 
 -- ’S“–ŽÒ–ˆŒo”ïƒf�[ƒ^
-drop table if exists costdataofperson cascade;
+drop table costdataofperson cascade;
 
 create table costdataofperson (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
@@ -811,7 +824,7 @@
   on costdataofperson(ConstructionCode);
 
 -- ”­’�ŽÒ“o˜^�\�¿ƒf�[ƒ^
-drop table if exists costomerregist cascade;
+drop table costomerregist cascade;
 
 create table costomerregist (
   PersonCode decimal(8,0) unsigned not null comment '�\�¿ŽÒ”Ô�†'
@@ -848,7 +861,7 @@
   on costomerregist(PetitionPeriod);
 
 -- “ú•ñƒf�[ƒ^
-drop table if exists dailydataconstruction cascade;
+drop table dailydataconstruction cascade;
 
 create table dailydataconstruction (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
@@ -870,7 +883,7 @@
   on dailydataconstruction(ConstructionCode);
 
 -- “ú•ñƒf�[ƒ^ (–¾�×)
-drop table if exists dailydatadetail cascade;
+drop table dailydatadetail cascade;
 
 create table dailydatadetail (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
@@ -893,7 +906,7 @@
   on dailydatadetail(PersonCode,DailyDataDate,ConstructionCode);
 
 -- “ú•ñƒf�[ƒ^ (Œ»�ê�„‰ñ)
-drop table if exists dailydatafield cascade;
+drop table dailydatafield cascade;
 
 create table dailydatafield (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
@@ -911,7 +924,7 @@
   on dailydatafield(PersonCode,DailyDataDate,ConstructionCode);
 
 -- “ú•ñƒf�[ƒ^ (Ž‘�Þ)
-drop table if exists dailydatamaterials cascade;
+drop table dailydatamaterials cascade;
 
 create table dailydatamaterials (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
@@ -932,7 +945,7 @@
   on dailydatamaterials(PersonCode,DailyDataDate,ConstructionCode);
 
 -- “ú•ñƒf�[ƒ^ (‹¦—Í‹ÆŽÒŽwŽ¦)
-drop table if exists dailydatasubcontractors cascade;
+drop table dailydatasubcontractors cascade;
 
 create table dailydatasubcontractors (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
@@ -950,7 +963,7 @@
   on dailydatasubcontractors(PersonCode,DailyDataDate,ConstructionCode);
 
 -- “ú•ñƒf�[ƒ^ (ŽÔ—¼)
-drop table if exists dailydatavehicles cascade;
+drop table dailydatavehicles cascade;
 
 create table dailydatavehicles (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
@@ -972,7 +985,7 @@
   on dailydatavehicles(PersonCode,DailyDataDate,ConstructionCode);
 
 -- “úƒ}ƒXƒ^
-drop table if exists daymaster cascade;
+drop table daymaster cascade;
 
 create table daymaster (
   days smallint(6) not null comment '“ú'
@@ -982,7 +995,7 @@
   on daymaster(days);
 
 -- ’÷“úƒ}ƒXƒ^
-drop table if exists deadlinemaster cascade;
+drop table deadlinemaster cascade;
 
 create table deadlinemaster (
   LABOURKIND decimal(1,0) default '0' not null comment 'ŽèŠÔ‹ÆŽÒ‹æ•ª'
@@ -996,7 +1009,7 @@
 ) comment '’÷“úƒ}ƒXƒ^' ;
 
 -- •”��Œo”ï—¦ƒ}ƒXƒ^
-drop table if exists departmentexpensesmaster cascade;
+drop table departmentexpensesmaster cascade;
 
 create table departmentexpensesmaster (
   DepartmentCode decimal(5,0) unsigned not null comment '•”��ƒR�[ƒh'
@@ -1011,7 +1024,7 @@
 ) comment '•”��Œo”ï—¦ƒ}ƒXƒ^' ;
 
 -- •”��ƒ}ƒXƒ^
-drop table if exists departmentmaster cascade;
+drop table departmentmaster cascade;
 
 create table departmentmaster (
   DepartmentCode decimal(5,0) unsigned not null comment '•”��ƒR�[ƒh'
@@ -1029,7 +1042,7 @@
   on departmentmaster(DisplayOrder);
 
 -- “ü‹àŠm”F�³”Fƒf�[ƒ^
-drop table if exists depositapprovalinfo cascade;
+drop table depositapprovalinfo cascade;
 
 create table depositapprovalinfo (
   ORDERERSDIVISION decimal(5,0) not null comment '”­’�ŽÒ‹æ•ª'
@@ -1048,7 +1061,7 @@
 ) comment '“ü‹àŠm”F�³”Fƒf�[ƒ^' ;
 
 -- “ü‹àƒf�[ƒ^
-drop table if exists depositdata cascade;
+drop table depositdata cascade;
 
 create table depositdata (
   ORDERERSDIVISION decimal(5,0) not null comment '”­’�ŽÒ‹æ•ª'
@@ -1068,7 +1081,7 @@
 ) comment '“ü‹àƒf�[ƒ^' ;
 
 -- “ü‹à–¾�×ƒf�[ƒ^
-drop table if exists depositdatadetail cascade;
+drop table depositdatadetail cascade;
 
 create table depositdatadetail (
   ORDERERSDIVISION decimal(5,0) not null comment '”­’�ŽÒ‹æ•ª'
@@ -1092,7 +1105,7 @@
 ) comment '“ü‹à–¾�×ƒf�[ƒ^' ;
 
 -- ‹æ•ªƒ}ƒXƒ^
-drop table if exists divisionmaster cascade;
+drop table divisionmaster cascade;
 
 create table divisionmaster (
   DivisionCode decimal(5,0) unsigned not null comment '‹æ•ªƒR�[ƒh'
@@ -1106,7 +1119,7 @@
 ) comment '‹æ•ªƒ}ƒXƒ^' ;
 
 -- �ÏŽZ—\ŽZ�‘ƒf�[ƒ^
-drop table if exists estimatebudget cascade;
+drop table estimatebudget cascade;
 
 create table estimatebudget (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1124,7 +1137,7 @@
 ) comment '�ÏŽZ—\ŽZ�‘ƒf�[ƒ^' ;
 
 -- �ÏŽZ—\ŽZ“à–óƒf�[ƒ^–¾�×
-drop table if exists estimatebudgetdetail cascade;
+drop table estimatebudgetdetail cascade;
 
 create table estimatebudgetdetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1145,7 +1158,7 @@
 ) comment '�ÏŽZ—\ŽZ“à–óƒf�[ƒ^–¾�×' ;
 
 -- �ÏŽZŒ©�Ïƒf�[ƒ^
-drop table if exists estimatedata cascade;
+drop table estimatedata cascade;
 
 create table estimatedata (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1167,7 +1180,7 @@
   on estimatedata(ConstructionCode,FixedItemCode);
 
 -- �ÏŽZŒ©�Ïƒy�[ƒWƒf�[ƒ^
-drop table if exists estimatedatabody cascade;
+drop table estimatedatabody cascade;
 
 create table estimatedatabody (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1188,7 +1201,7 @@
   on estimatedatabody(ConstructionCode,ComponentCode,ItemCode);
 
 -- �ÏŽZŒ©�Ïƒf�[ƒ^–¾�×
-drop table if exists estimatedatadetail cascade;
+drop table estimatedatadetail cascade;
 
 create table estimatedatadetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1217,7 +1230,7 @@
   on estimatedatadetail(ConstructionCode,PageCount);
 
 -- Œo”ï—¦ƒ}ƒXƒ^
-drop table if exists expensesmaster cascade;
+drop table expensesmaster cascade;
 
 create table expensesmaster (
   DivisionCode smallint(6) not null comment '�HŽ–Ží•ÊƒR�[ƒh'
@@ -1231,7 +1244,7 @@
 ) comment 'Œo”ï—¦ƒ}ƒXƒ^' ;
 
 -- ‰ïŽÐ‹x“úƒ}ƒXƒ^
-drop table if exists holidaycalendermaster cascade;
+drop table holidaycalendermaster cascade;
 
 create table holidaycalendermaster (
   Holiday date not null comment '‹x“ú'
@@ -1251,7 +1264,7 @@
   on holidaycalendermaster(TargetDay);
 
 -- “ü—ÍŽžŒŸ�õ—š—ð
-drop table if exists inputsearchlogdata cascade;
+drop table inputsearchlogdata cascade;
 
 create table inputsearchlogdata (
   ConstructionCode decimal(10,0) not null comment '�HŽ–ƒR�[ƒh'
@@ -1266,7 +1279,7 @@
   on inputsearchlogdata(ConstructionCode,UsedProcessNo,InputCode);
 
 -- �¿‹��‘ƒf�[ƒ^
-drop table if exists invoicedata cascade;
+drop table invoicedata cascade;
 
 create table invoicedata (
   INVOICENO decimal(9,0) not null comment '�¿‹��‘No'
@@ -1293,7 +1306,7 @@
 alter table invoicedata add unique ORDERERSDIVISION (ORDERERSDIVISION,ORDERERSCODE,REQUESTMONTH,SEQNO) ;
 
 -- Ž‘�Þ�î•ñ
-drop table if exists materialinfo cascade;
+drop table materialinfo cascade;
 
 create table materialinfo (
   MATERIALITEMCODE smallint(5) unsigned default 0 not null comment 'Ž‘�Þ•i–ÚƒR�[ƒh'
@@ -1306,7 +1319,7 @@
 ) comment 'Ž‘�Þ�î•ñ' ;
 
 -- Ž‘�Þ•i–Úƒ}ƒXƒ^
-drop table if exists materialitemmaster cascade;
+drop table materialitemmaster cascade;
 
 create table materialitemmaster (
   MATERIALITEMCODE smallint(5) unsigned default 0 not null comment 'Ž‘�Þ•i–ÚƒR�[ƒh'
@@ -1321,7 +1334,7 @@
 ) comment 'Ž‘�Þ•i–Úƒ}ƒXƒ^' ;
 
 -- Ž‘�ÞŽí—Þƒ}ƒXƒ^
-drop table if exists materialkindmaster cascade;
+drop table materialkindmaster cascade;
 
 create table materialkindmaster (
   MATERIALKINDCODE smallint(5) unsigned default 0 not null comment 'Ž‘�ÞŽí—ÞƒR�[ƒh'
@@ -1334,7 +1347,7 @@
 ) comment 'Ž‘�ÞŽí—Þƒ}ƒXƒ^' ;
 
 -- Ž‘�Þ—š—ð�î•ñ
-drop table if exists materialrecordinfo cascade;
+drop table materialrecordinfo cascade;
 
 create table materialrecordinfo (
   MATERIALITEMCODE smallint(5) unsigned default 0 not null comment 'Ž‘�Þ•i–ÚƒR�[ƒh'
@@ -1352,7 +1365,7 @@
 ) comment 'Ž‘�Þ—š—ð�î•ñ' ;
 
 -- ŒfŽ¦”Âƒ�ƒbƒZ�[ƒW
-drop table if exists messageboarddata cascade;
+drop table messageboarddata cascade;
 
 create table messageboarddata (
   RecordNumber decimal(6,0) unsigned not null comment 'ƒŒƒR�[ƒh”Ô�†'
@@ -1382,7 +1395,7 @@
   on messageboarddata(MessageFlag);
 
 -- ŒfŽ¦”Â‘Î�ÛŽÒƒe�[ƒuƒ‹
-drop table if exists messageboardterget cascade;
+drop table messageboardterget cascade;
 
 create table messageboardterget (
   RecordNumber decimal(6,0) unsigned not null comment 'ƒŒƒR�[ƒh”Ô�†'
@@ -1399,7 +1412,7 @@
   on messageboardterget(RecordNumber,BranchNumber);
 
 -- ŒfŽ¦”Âƒ�ƒbƒZ�[ƒW‰{———š—ð
-drop table if exists messagebrowsinghistory cascade;
+drop table messagebrowsinghistory cascade;
 
 create table messagebrowsinghistory (
   RecordNumber decimal(6,0) unsigned not null comment 'ƒŒƒR�[ƒh”Ô�†'
@@ -1413,7 +1426,7 @@
 ) comment 'ŒfŽ¦”Âƒ�ƒbƒZ�[ƒW‰{———š—ð' ;
 
 -- ŒŽƒ}ƒXƒ^
-drop table if exists monthmaster cascade;
+drop table monthmaster cascade;
 
 create table monthmaster (
   month smallint(6) not null comment 'ŒŽ'
@@ -1423,7 +1436,7 @@
   on monthmaster(month);
 
 -- ”­’�ŽÒƒ}ƒXƒ^
-drop table if exists orderersmaster cascade;
+drop table orderersmaster cascade;
 
 create table orderersmaster (
   OrderCotegory decimal(5,0) unsigned not null comment '”­’�ŽÒ‹æ•ª'
@@ -1451,7 +1464,7 @@
 ) comment '”­’�ŽÒƒ}ƒXƒ^' ;
 
 -- Žó’�‹àŠzƒf�[ƒ^
-drop table if exists orderspricedata cascade;
+drop table orderspricedata cascade;
 
 create table orderspricedata (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1470,7 +1483,7 @@
 ) comment 'Žó’�‹àŠzƒf�[ƒ^' ;
 
 -- Žx•¥�³”F�î•ñƒf�[ƒ^
-drop table if exists paymentapprovalinfo cascade;
+drop table paymentapprovalinfo cascade;
 
 create table paymentapprovalinfo (
   COMPANYCODE decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
@@ -1488,7 +1501,7 @@
 ) comment 'Žx•¥�³”F�î•ñƒf�[ƒ^' ;
 
 -- Žx•¥–¾�×ƒf�[ƒ^
-drop table if exists paymentdatadetail cascade;
+drop table paymentdatadetail cascade;
 
 create table paymentdatadetail (
   COMPANYCODE decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
@@ -1519,7 +1532,7 @@
   on paymentdatadetail(APPROVALPERSONCODE);
 
 -- �HŽ–ŠúŒÀ‰ñ”ðƒf�[ƒ^
-drop table if exists periodavoidance cascade;
+drop table periodavoidance cascade;
 
 create table periodavoidance (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1540,7 +1553,7 @@
   on periodavoidance(FieldNo);
 
 -- ’S“–ŽÒ�³”Fƒf�[ƒ^
-drop table if exists personapproval cascade;
+drop table personapproval cascade;
 
 create table personapproval (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
@@ -1559,7 +1572,7 @@
 ) comment '’S“–ŽÒ�³”Fƒf�[ƒ^' ;
 
 -- ’S“–ŽÒ�³”FƒRƒ�ƒ“ƒgƒf�[ƒ^
-drop table if exists personapprovalcomment cascade;
+drop table personapprovalcomment cascade;
 
 create table personapprovalcomment (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
@@ -1575,7 +1588,7 @@
 ) comment '’S“–ŽÒ�³”FƒRƒ�ƒ“ƒgƒf�[ƒ^' ;
 
 -- ’S“–ŽÒ‘Î�Û•”��ƒ}ƒXƒ^
-drop table if exists persondepartmentmaster cascade;
+drop table persondepartmentmaster cascade;
 
 create table persondepartmentmaster (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
@@ -1593,7 +1606,7 @@
   on persondepartmentmaster(DepartmentCode);
 
 -- ’S“–ŽÒƒ}ƒXƒ^
-drop table if exists personinchargemaster cascade;
+drop table personinchargemaster cascade;
 
 create table personinchargemaster (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
@@ -1628,7 +1641,7 @@
   on personinchargemaster(DepartmentCode);
 
 -- ’S“–ŽÒ‹‹—^ƒ}ƒXƒ^
-drop table if exists personsalarymaster cascade;
+drop table personsalarymaster cascade;
 
 create table personsalarymaster (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
@@ -1647,7 +1660,7 @@
   on personsalarymaster(StartDate);
 
 -- ŽwŽ¦Ž–�€ƒf�[ƒ^
-drop table if exists pointingoutcomment cascade;
+drop table pointingoutcomment cascade;
 
 create table pointingoutcomment (
   ConstructionCode decimal(10,0) not null comment '�HŽ–ƒR�[ƒh'
@@ -1669,7 +1682,7 @@
 ) comment 'ŽwŽ¦Ž–�€ƒf�[ƒ^' ;
 
 -- ”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^
-drop table if exists proceedingsdata cascade;
+drop table proceedingsdata cascade;
 
 create table proceedingsdata (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1685,7 +1698,7 @@
 ) comment '”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^' ;
 
 -- ”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^�i�o�ÈŽÒ�j
-drop table if exists proceedingsdataattend cascade;
+drop table proceedingsdataattend cascade;
 
 create table proceedingsdataattend (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1700,7 +1713,7 @@
 ) comment '”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^�i�o�ÈŽÒ�j' ;
 
 -- ”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^�i–¾�×�j
-drop table if exists proceedingsdatadetail cascade;
+drop table proceedingsdatadetail cascade;
 
 create table proceedingsdatadetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1716,7 +1729,7 @@
 ) comment '”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^�i–¾�×�j' ;
 
 -- �³”Fƒf�[ƒ^
-drop table if exists processapproval cascade;
+drop table processapproval cascade;
 
 create table processapproval (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1734,7 +1747,7 @@
 ) comment '�³”Fƒf�[ƒ^' ;
 
 -- �³”FƒRƒ�ƒ“ƒgƒf�[ƒ^
-drop table if exists processapprovalcomment cascade;
+drop table processapprovalcomment cascade;
 
 create table processapprovalcomment (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1749,7 +1762,7 @@
 ) comment '�³”FƒRƒ�ƒ“ƒgƒf�[ƒ^' ;
 
 -- �³”F–¾�×ƒf�[ƒ^
-drop table if exists processapprovaldetail cascade;
+drop table processapprovaldetail cascade;
 
 create table processapprovaldetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1763,7 +1776,7 @@
 ) comment '�³”F–¾�×ƒf�[ƒ^' ;
 
 -- ‹N“®‘Î�Ûƒ}ƒXƒ^
-drop table if exists processexcutemaster cascade;
+drop table processexcutemaster cascade;
 
 create table processexcutemaster (
   SecCode decimal(2,0) unsigned not null comment '•ÛŒì‹æ•ª”Ô�†'
@@ -1781,7 +1794,7 @@
   on processexcutemaster(ExecCode);
 
 -- ’�•¶�‘ƒf�[ƒ^
-drop table if exists purchaseorder cascade;
+drop table purchaseorder cascade;
 
 create table purchaseorder (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1817,7 +1830,7 @@
 ) comment '’�•¶�‘ƒf�[ƒ^' ;
 
 -- ’�•¶�‘“ú•tƒf�[ƒ^
-drop table if exists purchaseorderdate cascade;
+drop table purchaseorderdate cascade;
 
 create table purchaseorderdate (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1832,7 +1845,7 @@
 ) comment '’�•¶�‘“ú•tƒf�[ƒ^' ;
 
 -- ’�•¶�‘–¾�×ƒf�[ƒ^
-drop table if exists purchaseorderdetail cascade;
+drop table purchaseorderdetail cascade;
 
 create table purchaseorderdetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1859,7 +1872,7 @@
   on purchaseorderdetail(SourceCode);
 
 -- �¿‹�ƒf�[ƒ^
-drop table if exists requestdata cascade;
+drop table requestdata cascade;
 
 create table requestdata (
   REQUESTNO decimal(9,0) not null comment '�¿‹�No'
@@ -1884,7 +1897,7 @@
 ) comment '�¿‹�ƒf�[ƒ^' ;
 
 -- �¿‹�ƒf�[ƒ^–¾�×
-drop table if exists requestdatadetail cascade;
+drop table requestdatadetail cascade;
 
 create table requestdatadetail (
   REQUESTNO decimal(9,0) not null comment '�¿‹�No'
@@ -1899,7 +1912,7 @@
 ) comment '�¿‹�ƒf�[ƒ^–¾�×' ;
 
 -- �¿‹�ƒwƒbƒ_
-drop table if exists requesthead cascade;
+drop table requesthead cascade;
 
 create table requesthead (
   REQUESTNO decimal(9,0) not null comment '�¿‹�No'
@@ -1925,7 +1938,7 @@
 alter table requesthead add unique REQCONSTRUCTIONCODE (REQCONSTRUCTIONCODE,ORDERNO) ;
 
 -- �¿‹��‘“ú•tƒf�[ƒ^
-drop table if exists requestorderdate cascade;
+drop table requestorderdate cascade;
 
 create table requestorderdate (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1937,7 +1950,7 @@
 ) comment '�¿‹��‘“ú•tƒf�[ƒ^' ;
 
 -- ”„�ãƒOƒ‰ƒtƒf�[ƒ^
-drop table if exists salesgraphdata cascade;
+drop table salesgraphdata cascade;
 
 create table salesgraphdata (
   GraphDataCode decimal(8,0) not null comment 'ƒOƒ‰ƒtƒf�[ƒ^ƒR�[ƒh'
@@ -1961,7 +1974,7 @@
   on salesgraphdata(ConstructionPeriod);
 
 -- •ÛŒì‹æ•ªƒ}ƒXƒ^
-drop table if exists securitymaster cascade;
+drop table securitymaster cascade;
 
 create table securitymaster (
   SecCode decimal(2,0) unsigned not null comment '•ÛŒì‹æ•ª”Ô�†'
@@ -1986,7 +1999,7 @@
   on securitymaster(SecRange);
 
 -- ˆÀ‘Sƒpƒgƒ��[ƒ‹ƒf�[ƒ^
-drop table if exists sfpdata cascade;
+drop table sfpdata cascade;
 
 create table sfpdata (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -2004,7 +2017,7 @@
   on sfpdata(RequestDate);
 
 -- ˆÀ‘Sƒpƒgƒ��[ƒ‹–¾�×ƒf�[ƒ^
-drop table if exists sfpdatadetail cascade;
+drop table sfpdatadetail cascade;
 
 create table sfpdatadetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -2017,7 +2030,7 @@
 ) comment 'ˆÀ‘Sƒpƒgƒ��[ƒ‹–¾�×ƒf�[ƒ^' ;
 
 -- ‹¦—Í‹ÆŽÒŽ{�H�HŽí“o˜^�\�¿ƒf�[ƒ^
-drop table if exists subconstrjobitemregist cascade;
+drop table subconstrjobitemregist cascade;
 
 create table subconstrjobitemregist (
   PersonCode decimal(8,0) unsigned not null comment '�\�¿ŽÒ”Ô�†'
@@ -2031,7 +2044,7 @@
 ) comment '‹¦—Í‹ÆŽÒŽ{�H�HŽí“o˜^�\�¿ƒf�[ƒ^' ;
 
 -- ‹¦—Í‹ÆŽÒ�EŽíƒŠƒ“ƒN“o˜^�\�¿ƒf�[ƒ^
-drop table if exists subconstrjoblinkregist cascade;
+drop table subconstrjoblinkregist cascade;
 
 create table subconstrjoblinkregist (
   PersonCode decimal(8,0) unsigned not null comment '�\�¿ŽÒ”Ô�†'
@@ -2045,7 +2058,7 @@
 ) comment '‹¦—Í‹ÆŽÒ�EŽíƒŠƒ“ƒN“o˜^�\�¿ƒf�[ƒ^' ;
 
 -- ‹¦—Í‹ÆŽÒ“o˜^�\�¿ƒf�[ƒ^
-drop table if exists subconstrregist cascade;
+drop table subconstrregist cascade;
 
 create table subconstrregist (
   PersonCode decimal(8,0) unsigned not null comment '�\�¿ŽÒ”Ô�†'
@@ -2080,7 +2093,7 @@
 ) comment '‹¦—Í‹ÆŽÒ“o˜^�\�¿ƒf�[ƒ^' ;
 
 -- ‹¦—Í‰ïŽÐ�HŽíƒ}ƒXƒ^
-drop table if exists subcontractoritemmaster cascade;
+drop table subcontractoritemmaster cascade;
 
 create table subcontractoritemmaster (
   ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
@@ -2093,7 +2106,7 @@
 ) comment '‹¦—Í‰ïŽÐ�HŽíƒ}ƒXƒ^' ;
 
 -- ‹¦—Í‰ïŽÐ�EŽíƒ}ƒXƒ^
-drop table if exists subcontractorjobcategory cascade;
+drop table subcontractorjobcategory cascade;
 
 create table subcontractorjobcategory (
   JobCategoryCode decimal(5,0) not null comment '�EŽíƒL�['
@@ -2106,7 +2119,7 @@
 ) comment '‹¦—Í‰ïŽÐ�EŽíƒ}ƒXƒ^' ;
 
 -- ‹¦—Í‰ïŽÐŽ{�H�HŽíƒf�[ƒ^
-drop table if exists subcontractorjobitem cascade;
+drop table subcontractorjobitem cascade;
 
 create table subcontractorjobitem (
   CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
@@ -2124,7 +2137,7 @@
   on subcontractorjobitem(ItemCode);
 
 -- ‹¦—Í‰ïŽÐ�EŽíƒŠƒ“ƒNƒ}ƒXƒ^
-drop table if exists subcontractorjoblink cascade;
+drop table subcontractorjoblink cascade;
 
 create table subcontractorjoblink (
   CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
@@ -2142,7 +2155,7 @@
   on subcontractorjoblink(JobCategoryCode);
 
 -- ‹¦—Í‰ïŽÐƒ}ƒXƒ^
-drop table if exists subcontractormaster cascade;
+drop table subcontractormaster cascade;
 
 create table subcontractormaster (
   CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
@@ -2175,7 +2188,7 @@
   on subcontractormaster(JapaneseSyllabary);
 
 -- Žd“ü�æƒ}ƒXƒ^
-drop table if exists suppliersmaster cascade;
+drop table suppliersmaster cascade;
 
 create table suppliersmaster (
   SuppliersCode decimal(5,0) unsigned not null comment 'Žd“ü�æƒR�[ƒh'
@@ -2196,7 +2209,7 @@
 ) comment 'Žd“ü�æƒ}ƒXƒ^' ;
 
 -- ƒVƒXƒeƒ€‹N“®Šm”Fƒf�[ƒ^
-drop table if exists systemexecute cascade;
+drop table systemexecute cascade;
 
 create table systemexecute (
   PrimaryCode tinyint(4) not null comment 'ƒL�[�€–Ú'
@@ -2209,7 +2222,7 @@
 ) comment 'ƒVƒXƒeƒ€‹N“®Šm”Fƒf�[ƒ^' ;
 
 -- ŠÇ—�ƒ}ƒXƒ^
-drop table if exists systemmaster cascade;
+drop table systemmaster cascade;
 
 create table systemmaster (
   SystemCode decimal(3,0) unsigned not null comment '‰ïŽÐƒR�[ƒh'
@@ -2224,9 +2237,6 @@
   , PhoneNumber varchar(13) not null comment '“d˜b”Ô�†'
   , FaxNumber varchar(13) comment 'FAX”Ô�†'
   , HomePageURL varchar(120) 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 '–@’è•Ÿ—˜”ï”ä—¦'
@@ -2234,9 +2244,11 @@
   , AreaDistance decimal(5,2) not null comment 'Ž‘�Þ’u�êˆÚ“®‹——£'
   , ExcelSavePath varchar(120) comment 'Excel•Û‘¶ƒpƒX'
   , BusinessPeriod smallint(6) not null comment 'Œ»�Ý‰c‹ÆŠú�”'
-  , ConstructionYear smallint(6) not null comment 'Œ»�Ý�HŽ–”N“x'
-  , BusinessBeginningDate varchar(5) not null comment '‰c‹ÆŠúŠúŽñ“ú'
-  , ConstructionBeginningDate varchar(5) not null comment '�HŽ–”N“xŠúŽñ“ú'
+  , 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'
@@ -2247,7 +2259,7 @@
 ) comment 'ŠÇ—�ƒ}ƒXƒ^' ;
 
 -- ŠúŒÀƒ}ƒXƒ^
-drop table if exists termmaster cascade;
+drop table termmaster cascade;
 
 create table termmaster (
   ConstructionStatusFlg decimal(2,0) not null comment '�HŽ–�ó‘Ôƒtƒ‰ƒO'
@@ -2269,7 +2281,7 @@
   on termmaster(DisplayOrder);
 
 -- �o‹ÎŒð’Ê”ïƒf�[ƒ^
-drop table if exists tranceportdailydata cascade;
+drop table tranceportdailydata cascade;
 
 create table tranceportdailydata (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
@@ -2291,7 +2303,7 @@
   on tranceportdailydata(AttendanceDate);
 
 -- �HŽ–Ží•ÊŒo”ï—¦ƒ}ƒXƒ^
-drop table if exists typeexpensesmaster cascade;
+drop table typeexpensesmaster cascade;
 
 create table typeexpensesmaster (
   TypeCode decimal(5,0) unsigned not null comment '�HŽ–Ží•ÊƒR�[ƒh'
@@ -2305,7 +2317,7 @@
 ) comment '�HŽ–Ží•ÊŒo”ï—¦ƒ}ƒXƒ^' ;
 
 -- ’PˆÊƒ}ƒXƒ^
-drop table if exists unitmaster cascade;
+drop table unitmaster cascade;
 
 create table unitmaster (
   UnitKey decimal(5,0) unsigned not null comment '’PˆÊƒL�['
@@ -2320,7 +2332,7 @@
   on unitmaster(DisplayOrder);
 
 -- ŽÔ—¼ƒ}ƒXƒ^
-drop table if exists vehiclemaster cascade;
+drop table vehiclemaster cascade;
 
 create table vehiclemaster (
   VehicleCode decimal(5,0) unsigned not null comment 'ŽÔ—¼ƒR�[ƒh'
@@ -2349,7 +2361,7 @@
 ) comment 'ŽÔ—¼ƒ}ƒXƒ^' ;
 
 -- ŽÔ—¼‹L˜^ƒf�[ƒ^
-drop table if exists vehiclerecorddata cascade;
+drop table vehiclerecorddata cascade;
 
 create table vehiclerecorddata (
   VehicleCode decimal(5,0) unsigned not null comment 'ŽÔ—¼ƒR�[ƒh'
@@ -2365,7 +2377,7 @@
 ) comment 'ŽÔ—¼‹L˜^ƒf�[ƒ^' ;
 
 -- ŽÔ—¼—\–ñƒf�[ƒ^
-drop table if exists vehiclescheduledata cascade;
+drop table vehiclescheduledata cascade;
 
 create table vehiclescheduledata (
   TargetDate date not null comment '‘Î�Û“ú'
@@ -2390,7 +2402,7 @@
   on vehiclescheduledata(TargetDay);
 
 -- ”Nƒ}ƒXƒ^
-drop table if exists yearmaster cascade;
+drop table yearmaster cascade;
 
 create table yearmaster (
   years smallint(6) not null comment '”N'
Index: branches/ddl/ƒe�[ƒuƒ‹Žd—l�‘.xlsx
===================================================================
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
Index: branches/ddl/ƒe�[ƒuƒ‹Žd—l�‘.xlsx
===================================================================
--- branches/ddl/ƒe�[ƒuƒ‹Žd—l�‘.xlsx	(nonexistent)
+++ branches/ddl/ƒe�[ƒuƒ‹Žd—l�‘.xlsx	(revision 324)

Property changes on: branches/ddl/ƒe�[ƒuƒ‹Žd—l�‘.xlsx
___________________________________________________________________
Added: svn:mime-type
## -0,0 +1 ##
+application/octet-stream
\ No newline at end of property
