Index: ProcessManagement.sql
===================================================================
--- ProcessManagement.sql	(revision 324)
+++ ProcessManagement.sql	(revision 325)
@@ -1,11 +1,11 @@
 -- Project Name : noname
--- Date/Time    : 2018/03/01 9:30:55
+-- Date/Time    : 2018/03/01 9:40:48
 -- Author       : Horiuchi
 -- RDBMS Type   : MySQL
 -- Application  : A5:SQL Mk-2
 
 -- ’S“–ŽÒ�s“®—\’èƒf�[ƒ^
-drop table actionscheduledata cascade;
+drop table if exists actionscheduledata cascade;
 
 create table actionscheduledata (
   TargetDate date not null comment '‘Î�Û“ú'
@@ -29,7 +29,7 @@
   on actionscheduledata(TargetDay);
 
 -- �³”FŒo˜Hƒ}ƒXƒ^
-drop table approvalmaster cascade;
+drop table if exists 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 attendancedailydata cascade;
+drop table if exists 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 attendancedata cascade;
+drop table if exists 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 bankbusinessdaymaster cascade;
+drop table if exists 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 billingdata cascade;
+drop table if exists 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 billingdatadetail cascade;
+drop table if exists 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 billingpaymentsummary cascade;
+drop table if exists billingpaymentsummary cascade;
 
 create table billingpaymentsummary (
   COMPANYCODE decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
@@ -155,7 +155,7 @@
 ) comment '‹ÆŽÒ�¿‹�Žx•¥ƒTƒ}ƒŠ�[ƒf�[ƒ^' ;
 
 -- ‰^‰cŠú—š—ð�î•ñ
-drop table bizperiodhistory cascade;
+drop table if exists bizperiodhistory cascade;
 
 create table bizperiodhistory (
   PeriodYear smallint(6) not null comment '‰c‹ÆŠú�”�E�HŽ–”N“x'
@@ -168,7 +168,7 @@
 ) comment '‰^‰cŠú—š—ð�î•ñ' ;
 
 -- �HŽ–�Ú�×‘ä’ ƒf�[ƒ^�y‘Þ”ð—p�z
-drop table bk_constructionledger cascade;
+drop table if exists bk_constructionledger cascade;
 
 create table bk_constructionledger (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -195,7 +195,7 @@
 ) comment '�HŽ–�Ú�×‘ä’ ƒf�[ƒ^�y‘Þ”ð—p�z' ;
 
 -- �HŽ–�Ú�×‘ä’ –¾�×ƒf�[ƒ^�y‘Þ”ð—p�z
-drop table bk_constructionledgerdetail cascade;
+drop table if exists bk_constructionledgerdetail cascade;
 
 create table bk_constructionledgerdetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -228,7 +228,7 @@
 ) comment '�HŽ–�Ú�×‘ä’ –¾�×ƒf�[ƒ^�y‘Þ”ð—p�z' ;
 
 -- �HŽ–�Ú�×‘ä’ ŽÀ�sƒf�[ƒ^�y‘Þ”ð—p�z
-drop table bk_constructionledgerexcute cascade;
+drop table if exists bk_constructionledgerexcute cascade;
 
 create table bk_constructionledgerexcute (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -243,7 +243,7 @@
 ) comment '�HŽ–�Ú�×‘ä’ ŽÀ�sƒf�[ƒ^�y‘Þ”ð—p�z' ;
 
 -- �ÏŽZŒ©�Ïƒf�[ƒ^�y‘Þ”ð—p�z
-drop table bk_estimatedata cascade;
+drop table if exists bk_estimatedata cascade;
 
 create table bk_estimatedata (
   SaveDate datetime not null comment '‘Þ”ð“ú•t'
@@ -263,7 +263,7 @@
 ) comment '�ÏŽZŒ©�Ïƒf�[ƒ^�y‘Þ”ð—p�z' ;
 
 -- �ÏŽZŒ©�Ïƒy�[ƒWƒf�[ƒ^�y‘Þ”ð—p�z
-drop table bk_estimatedatabody cascade;
+drop table if exists bk_estimatedatabody cascade;
 
 create table bk_estimatedatabody (
   SaveDate datetime not null comment '‘Þ”ð“ú•t'
@@ -282,7 +282,7 @@
 ) comment '�ÏŽZŒ©�Ïƒy�[ƒWƒf�[ƒ^�y‘Þ”ð—p�z' ;
 
 -- �ÏŽZŒ©�Ïƒf�[ƒ^–¾�×�y‘Þ”ð—p�z
-drop table bk_estimatedatadetail cascade;
+drop table if exists bk_estimatedatadetail cascade;
 
 create table bk_estimatedatadetail (
   SaveDate datetime not null comment '‘Þ”ð“ú•t'
@@ -309,7 +309,7 @@
 ) comment '�ÏŽZŒ©�Ïƒf�[ƒ^–¾�×�y‘Þ”ð—p�z' ;
 
 -- –@�lŠiƒ}ƒXƒ^
-drop table businesstypemaster cascade;
+drop table if exists businesstypemaster cascade;
 
 create table businesstypemaster (
   BusinessTypeCode decimal(5,0) unsigned not null comment '–@�lŠiƒR�[ƒh'
@@ -324,7 +324,7 @@
   on businesstypemaster(DisplayOrder);
 
 -- ‹¤’Ê”ï‘å�€–Úƒ}ƒXƒ^
-drop table commoncostlarge cascade;
+drop table if exists commoncostlarge cascade;
 
 create table commoncostlarge (
   LargeCode decimal(5,0) unsigned not null comment '‘å�€–ÚƒL�['
@@ -338,7 +338,7 @@
 ) comment '‹¤’Ê”ï‘å�€–Úƒ}ƒXƒ^' ;
 
 -- ‹¤’Ê”ï�HŽíŠÖ˜Aƒ}ƒXƒ^
-drop table commoncostlinkms cascade;
+drop table if exists commoncostlinkms cascade;
 
 create table commoncostlinkms (
   LargeCode decimal(5,0) unsigned not null comment '‘å�€–ÚƒL�['
@@ -350,7 +350,7 @@
 ) comment '‹¤’Ê”ï�HŽíŠÖ˜Aƒ}ƒXƒ^' ;
 
 -- ‹¤’Ê”ï’†�€–Úƒ}ƒXƒ^
-drop table commoncostmiddle cascade;
+drop table if exists commoncostmiddle cascade;
 
 create table commoncostmiddle (
   LargeCode decimal(5,0) unsigned not null comment '‘å�€–ÚƒL�['
@@ -365,7 +365,7 @@
 ) comment '‹¤’Ê”ï’†�€–Úƒ}ƒXƒ^' ;
 
 -- ‹¤’Ê”ï’†�€–ÚƒL�[ƒ}ƒXƒ^
-drop table commoncostmiddlesearchword cascade;
+drop table if exists commoncostmiddlesearchword cascade;
 
 create table commoncostmiddlesearchword (
   LargeCode decimal(5,0) unsigned not null comment '‘å�€–ÚƒL�['
@@ -378,7 +378,7 @@
 ) comment '‹¤’Ê”ï’†�€–ÚƒL�[ƒ}ƒXƒ^' ;
 
 -- �\�¬�HŽíŠÖ˜Aƒ}ƒXƒ^
-drop table componentlinkmaster cascade;
+drop table if exists componentlinkmaster cascade;
 
 create table componentlinkmaster (
   ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
@@ -396,7 +396,7 @@
   on componentlinkmaster(ItemCode);
 
 -- �\�¬ƒ}ƒXƒ^
-drop table componentmaster cascade;
+drop table if exists componentmaster cascade;
 
 create table componentmaster (
   ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
@@ -415,7 +415,7 @@
   on componentmaster(DisplayOrder);
 
 -- �\�¬�HŽ–Ží•ÊŠÖ˜Aƒ}ƒXƒ^
-drop table componenttotypemaster cascade;
+drop table if exists componenttotypemaster cascade;
 
 create table componenttotypemaster (
   ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
@@ -433,7 +433,7 @@
   on componenttotypemaster(TypeCode);
 
 -- �HŽ–Šî–{�î•ñ
-drop table constructionbaseinfo cascade;
+drop table if exists constructionbaseinfo cascade;
 
 create table constructionbaseinfo (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -510,7 +510,7 @@
   on constructionbaseinfo(ConstructionPeriod);
 
 -- �HŽ–Šî–{�î•ñ–¾�×
-drop table constructionbaseinfodetail cascade;
+drop table if exists constructionbaseinfodetail cascade;
 
 create table constructionbaseinfodetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -528,7 +528,7 @@
   on constructionbaseinfodetail(DetailNo);
 
 -- �HŽ–Ž{�H—\ŽZƒf�[ƒ^
-drop table constructionbudget cascade;
+drop table if exists constructionbudget cascade;
 
 create table constructionbudget (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -559,7 +559,7 @@
 ) comment '�HŽ–Ž{�H—\ŽZƒf�[ƒ^' ;
 
 -- �HŽ–Ž{�H—\ŽZƒf�[ƒ^–¾�×
-drop table constructionbudgetdetail cascade;
+drop table if exists constructionbudgetdetail cascade;
 
 create table constructionbudgetdetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -584,7 +584,7 @@
 ) comment '�HŽ–Ž{�H—\ŽZƒf�[ƒ^–¾�×' ;
 
 -- �HŽíƒ}ƒXƒ^
-drop table constructionitemmaster cascade;
+drop table if exists constructionitemmaster cascade;
 
 create table constructionitemmaster (
   ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
@@ -599,7 +599,7 @@
 ) comment '�HŽíƒ}ƒXƒ^' ;
 
 -- �HŽ–�Ú�×‘ä’ ƒf�[ƒ^
-drop table constructionledger cascade;
+drop table if exists constructionledger cascade;
 
 create table constructionledger (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -626,7 +626,7 @@
 ) comment '�HŽ–�Ú�×‘ä’ ƒf�[ƒ^' ;
 
 -- �HŽ–�Ú�×‘ä’ –¾�×ƒf�[ƒ^
-drop table constructionledgerdetail cascade;
+drop table if exists constructionledgerdetail cascade;
 
 create table constructionledgerdetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -675,7 +675,7 @@
   on constructionledgerdetail(DetailCount);
 
 -- �HŽ–�Ú�×‘ä’ ŽÀ�sƒf�[ƒ^
-drop table constructionledgerexcute cascade;
+drop table if exists constructionledgerexcute cascade;
 
 create table constructionledgerexcute (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -693,7 +693,7 @@
   on constructionledgerexcute(ConstructionCode,TargetMonth,GroupCount,LineCount);
 
 -- �HŽ–ƒŠƒ“ƒN�î•ñ
-drop table constructionlink cascade;
+drop table if exists constructionlink cascade;
 
 create table constructionlink (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -714,7 +714,7 @@
   on constructionlink(LinkType);
 
 -- �HŽ–Ž‘�Þ�î•ñ
-drop table constructionmaterialinfo cascade;
+drop table if exists constructionmaterialinfo cascade;
 
 create table constructionmaterialinfo (
   CONSTRUCTIONCODE int(10) unsigned default 0 not null comment '�HŽ–”Ô�†'
@@ -730,7 +730,7 @@
 ) comment '�HŽ–Ž‘�Þ�î•ñ' ;
 
 -- ˆÄŒ��i’»“ú•tƒf�[ƒ^
-drop table constructionprogressdate cascade;
+drop table if exists constructionprogressdate cascade;
 
 create table constructionprogressdate (
   ConstructionCode decimal(10,0) not null comment '�HŽ–”Ô�†'
@@ -744,7 +744,7 @@
 ) comment 'ˆÄŒ��i’»“ú•tƒf�[ƒ^' ;
 
 -- �ì‹Æƒ}ƒXƒ^
-drop table constructionspecmaster cascade;
+drop table if exists constructionspecmaster cascade;
 
 create table constructionspecmaster (
   ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
@@ -764,7 +764,7 @@
   on constructionspecmaster(DisplayOrder);
 
 -- �ì‹Æ’P‰¿ƒ}ƒXƒ^
-drop table constructionspecunitprice cascade;
+drop table if exists constructionspecunitprice cascade;
 
 create table constructionspecunitprice (
   ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
@@ -778,7 +778,7 @@
 ) comment '�ì‹Æ’P‰¿ƒ}ƒXƒ^' ;
 
 -- �HŽ–Ží•Êƒ}ƒXƒ^
-drop table constructiontypemaster cascade;
+drop table if exists constructiontypemaster cascade;
 
 create table constructiontypemaster (
   TypeCode decimal(5,0) unsigned not null comment '�HŽ–Ží•ÊƒR�[ƒh'
@@ -794,7 +794,7 @@
 ) comment '�HŽ–Ží•Êƒ}ƒXƒ^' ;
 
 -- ’S“–ŽÒ–ˆŒo”ïƒf�[ƒ^
-drop table costdataofperson cascade;
+drop table if exists costdataofperson cascade;
 
 create table costdataofperson (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
@@ -824,7 +824,7 @@
   on costdataofperson(ConstructionCode);
 
 -- ”­’�ŽÒ“o˜^�\�¿ƒf�[ƒ^
-drop table costomerregist cascade;
+drop table if exists costomerregist cascade;
 
 create table costomerregist (
   PersonCode decimal(8,0) unsigned not null comment '�\�¿ŽÒ”Ô�†'
@@ -861,7 +861,7 @@
   on costomerregist(PetitionPeriod);
 
 -- “ú•ñƒf�[ƒ^
-drop table dailydataconstruction cascade;
+drop table if exists dailydataconstruction cascade;
 
 create table dailydataconstruction (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
@@ -883,7 +883,7 @@
   on dailydataconstruction(ConstructionCode);
 
 -- “ú•ñƒf�[ƒ^ (–¾�×)
-drop table dailydatadetail cascade;
+drop table if exists dailydatadetail cascade;
 
 create table dailydatadetail (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
@@ -906,7 +906,7 @@
   on dailydatadetail(PersonCode,DailyDataDate,ConstructionCode);
 
 -- “ú•ñƒf�[ƒ^ (Œ»�ê�„‰ñ)
-drop table dailydatafield cascade;
+drop table if exists dailydatafield cascade;
 
 create table dailydatafield (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
@@ -924,7 +924,7 @@
   on dailydatafield(PersonCode,DailyDataDate,ConstructionCode);
 
 -- “ú•ñƒf�[ƒ^ (Ž‘�Þ)
-drop table dailydatamaterials cascade;
+drop table if exists dailydatamaterials cascade;
 
 create table dailydatamaterials (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
@@ -945,7 +945,7 @@
   on dailydatamaterials(PersonCode,DailyDataDate,ConstructionCode);
 
 -- “ú•ñƒf�[ƒ^ (‹¦—Í‹ÆŽÒŽwŽ¦)
-drop table dailydatasubcontractors cascade;
+drop table if exists dailydatasubcontractors cascade;
 
 create table dailydatasubcontractors (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
@@ -963,7 +963,7 @@
   on dailydatasubcontractors(PersonCode,DailyDataDate,ConstructionCode);
 
 -- “ú•ñƒf�[ƒ^ (ŽÔ—¼)
-drop table dailydatavehicles cascade;
+drop table if exists dailydatavehicles cascade;
 
 create table dailydatavehicles (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
@@ -985,7 +985,7 @@
   on dailydatavehicles(PersonCode,DailyDataDate,ConstructionCode);
 
 -- “úƒ}ƒXƒ^
-drop table daymaster cascade;
+drop table if exists daymaster cascade;
 
 create table daymaster (
   days smallint(6) not null comment '“ú'
@@ -995,7 +995,7 @@
   on daymaster(days);
 
 -- ’÷“úƒ}ƒXƒ^
-drop table deadlinemaster cascade;
+drop table if exists deadlinemaster cascade;
 
 create table deadlinemaster (
   LABOURKIND decimal(1,0) default '0' not null comment 'ŽèŠÔ‹ÆŽÒ‹æ•ª'
@@ -1009,7 +1009,7 @@
 ) comment '’÷“úƒ}ƒXƒ^' ;
 
 -- •”��Œo”ï—¦ƒ}ƒXƒ^
-drop table departmentexpensesmaster cascade;
+drop table if exists departmentexpensesmaster cascade;
 
 create table departmentexpensesmaster (
   DepartmentCode decimal(5,0) unsigned not null comment '•”��ƒR�[ƒh'
@@ -1024,7 +1024,7 @@
 ) comment '•”��Œo”ï—¦ƒ}ƒXƒ^' ;
 
 -- •”��ƒ}ƒXƒ^
-drop table departmentmaster cascade;
+drop table if exists departmentmaster cascade;
 
 create table departmentmaster (
   DepartmentCode decimal(5,0) unsigned not null comment '•”��ƒR�[ƒh'
@@ -1042,7 +1042,7 @@
   on departmentmaster(DisplayOrder);
 
 -- “ü‹àŠm”F�³”Fƒf�[ƒ^
-drop table depositapprovalinfo cascade;
+drop table if exists depositapprovalinfo cascade;
 
 create table depositapprovalinfo (
   ORDERERSDIVISION decimal(5,0) not null comment '”­’�ŽÒ‹æ•ª'
@@ -1061,7 +1061,7 @@
 ) comment '“ü‹àŠm”F�³”Fƒf�[ƒ^' ;
 
 -- “ü‹àƒf�[ƒ^
-drop table depositdata cascade;
+drop table if exists depositdata cascade;
 
 create table depositdata (
   ORDERERSDIVISION decimal(5,0) not null comment '”­’�ŽÒ‹æ•ª'
@@ -1081,7 +1081,7 @@
 ) comment '“ü‹àƒf�[ƒ^' ;
 
 -- “ü‹à–¾�×ƒf�[ƒ^
-drop table depositdatadetail cascade;
+drop table if exists depositdatadetail cascade;
 
 create table depositdatadetail (
   ORDERERSDIVISION decimal(5,0) not null comment '”­’�ŽÒ‹æ•ª'
@@ -1105,7 +1105,7 @@
 ) comment '“ü‹à–¾�×ƒf�[ƒ^' ;
 
 -- ‹æ•ªƒ}ƒXƒ^
-drop table divisionmaster cascade;
+drop table if exists divisionmaster cascade;
 
 create table divisionmaster (
   DivisionCode decimal(5,0) unsigned not null comment '‹æ•ªƒR�[ƒh'
@@ -1119,7 +1119,7 @@
 ) comment '‹æ•ªƒ}ƒXƒ^' ;
 
 -- �ÏŽZ—\ŽZ�‘ƒf�[ƒ^
-drop table estimatebudget cascade;
+drop table if exists estimatebudget cascade;
 
 create table estimatebudget (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1137,7 +1137,7 @@
 ) comment '�ÏŽZ—\ŽZ�‘ƒf�[ƒ^' ;
 
 -- �ÏŽZ—\ŽZ“à–óƒf�[ƒ^–¾�×
-drop table estimatebudgetdetail cascade;
+drop table if exists estimatebudgetdetail cascade;
 
 create table estimatebudgetdetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1158,7 +1158,7 @@
 ) comment '�ÏŽZ—\ŽZ“à–óƒf�[ƒ^–¾�×' ;
 
 -- �ÏŽZŒ©�Ïƒf�[ƒ^
-drop table estimatedata cascade;
+drop table if exists estimatedata cascade;
 
 create table estimatedata (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1180,7 +1180,7 @@
   on estimatedata(ConstructionCode,FixedItemCode);
 
 -- �ÏŽZŒ©�Ïƒy�[ƒWƒf�[ƒ^
-drop table estimatedatabody cascade;
+drop table if exists estimatedatabody cascade;
 
 create table estimatedatabody (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1201,7 +1201,7 @@
   on estimatedatabody(ConstructionCode,ComponentCode,ItemCode);
 
 -- �ÏŽZŒ©�Ïƒf�[ƒ^–¾�×
-drop table estimatedatadetail cascade;
+drop table if exists estimatedatadetail cascade;
 
 create table estimatedatadetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1230,7 +1230,7 @@
   on estimatedatadetail(ConstructionCode,PageCount);
 
 -- Œo”ï—¦ƒ}ƒXƒ^
-drop table expensesmaster cascade;
+drop table if exists expensesmaster cascade;
 
 create table expensesmaster (
   DivisionCode smallint(6) not null comment '�HŽ–Ží•ÊƒR�[ƒh'
@@ -1244,7 +1244,7 @@
 ) comment 'Œo”ï—¦ƒ}ƒXƒ^' ;
 
 -- ‰ïŽÐ‹x“úƒ}ƒXƒ^
-drop table holidaycalendermaster cascade;
+drop table if exists holidaycalendermaster cascade;
 
 create table holidaycalendermaster (
   Holiday date not null comment '‹x“ú'
@@ -1264,7 +1264,7 @@
   on holidaycalendermaster(TargetDay);
 
 -- “ü—ÍŽžŒŸ�õ—š—ð
-drop table inputsearchlogdata cascade;
+drop table if exists inputsearchlogdata cascade;
 
 create table inputsearchlogdata (
   ConstructionCode decimal(10,0) not null comment '�HŽ–ƒR�[ƒh'
@@ -1279,7 +1279,7 @@
   on inputsearchlogdata(ConstructionCode,UsedProcessNo,InputCode);
 
 -- �¿‹��‘ƒf�[ƒ^
-drop table invoicedata cascade;
+drop table if exists invoicedata cascade;
 
 create table invoicedata (
   INVOICENO decimal(9,0) not null comment '�¿‹��‘No'
@@ -1306,7 +1306,7 @@
 alter table invoicedata add unique ORDERERSDIVISION (ORDERERSDIVISION,ORDERERSCODE,REQUESTMONTH,SEQNO) ;
 
 -- Ž‘�Þ�î•ñ
-drop table materialinfo cascade;
+drop table if exists materialinfo cascade;
 
 create table materialinfo (
   MATERIALITEMCODE smallint(5) unsigned default 0 not null comment 'Ž‘�Þ•i–ÚƒR�[ƒh'
@@ -1319,7 +1319,7 @@
 ) comment 'Ž‘�Þ�î•ñ' ;
 
 -- Ž‘�Þ•i–Úƒ}ƒXƒ^
-drop table materialitemmaster cascade;
+drop table if exists materialitemmaster cascade;
 
 create table materialitemmaster (
   MATERIALITEMCODE smallint(5) unsigned default 0 not null comment 'Ž‘�Þ•i–ÚƒR�[ƒh'
@@ -1334,7 +1334,7 @@
 ) comment 'Ž‘�Þ•i–Úƒ}ƒXƒ^' ;
 
 -- Ž‘�ÞŽí—Þƒ}ƒXƒ^
-drop table materialkindmaster cascade;
+drop table if exists materialkindmaster cascade;
 
 create table materialkindmaster (
   MATERIALKINDCODE smallint(5) unsigned default 0 not null comment 'Ž‘�ÞŽí—ÞƒR�[ƒh'
@@ -1347,7 +1347,7 @@
 ) comment 'Ž‘�ÞŽí—Þƒ}ƒXƒ^' ;
 
 -- Ž‘�Þ—š—ð�î•ñ
-drop table materialrecordinfo cascade;
+drop table if exists materialrecordinfo cascade;
 
 create table materialrecordinfo (
   MATERIALITEMCODE smallint(5) unsigned default 0 not null comment 'Ž‘�Þ•i–ÚƒR�[ƒh'
@@ -1365,7 +1365,7 @@
 ) comment 'Ž‘�Þ—š—ð�î•ñ' ;
 
 -- ŒfŽ¦”Âƒ�ƒbƒZ�[ƒW
-drop table messageboarddata cascade;
+drop table if exists messageboarddata cascade;
 
 create table messageboarddata (
   RecordNumber decimal(6,0) unsigned not null comment 'ƒŒƒR�[ƒh”Ô�†'
@@ -1395,7 +1395,7 @@
   on messageboarddata(MessageFlag);
 
 -- ŒfŽ¦”Â‘Î�ÛŽÒƒe�[ƒuƒ‹
-drop table messageboardterget cascade;
+drop table if exists messageboardterget cascade;
 
 create table messageboardterget (
   RecordNumber decimal(6,0) unsigned not null comment 'ƒŒƒR�[ƒh”Ô�†'
@@ -1412,7 +1412,7 @@
   on messageboardterget(RecordNumber,BranchNumber);
 
 -- ŒfŽ¦”Âƒ�ƒbƒZ�[ƒW‰{———š—ð
-drop table messagebrowsinghistory cascade;
+drop table if exists messagebrowsinghistory cascade;
 
 create table messagebrowsinghistory (
   RecordNumber decimal(6,0) unsigned not null comment 'ƒŒƒR�[ƒh”Ô�†'
@@ -1426,7 +1426,7 @@
 ) comment 'ŒfŽ¦”Âƒ�ƒbƒZ�[ƒW‰{———š—ð' ;
 
 -- ŒŽƒ}ƒXƒ^
-drop table monthmaster cascade;
+drop table if exists monthmaster cascade;
 
 create table monthmaster (
   month smallint(6) not null comment 'ŒŽ'
@@ -1436,7 +1436,7 @@
   on monthmaster(month);
 
 -- ”­’�ŽÒƒ}ƒXƒ^
-drop table orderersmaster cascade;
+drop table if exists orderersmaster cascade;
 
 create table orderersmaster (
   OrderCotegory decimal(5,0) unsigned not null comment '”­’�ŽÒ‹æ•ª'
@@ -1464,7 +1464,7 @@
 ) comment '”­’�ŽÒƒ}ƒXƒ^' ;
 
 -- Žó’�‹àŠzƒf�[ƒ^
-drop table orderspricedata cascade;
+drop table if exists orderspricedata cascade;
 
 create table orderspricedata (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1483,7 +1483,7 @@
 ) comment 'Žó’�‹àŠzƒf�[ƒ^' ;
 
 -- Žx•¥�³”F�î•ñƒf�[ƒ^
-drop table paymentapprovalinfo cascade;
+drop table if exists paymentapprovalinfo cascade;
 
 create table paymentapprovalinfo (
   COMPANYCODE decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
@@ -1501,7 +1501,7 @@
 ) comment 'Žx•¥�³”F�î•ñƒf�[ƒ^' ;
 
 -- Žx•¥–¾�×ƒf�[ƒ^
-drop table paymentdatadetail cascade;
+drop table if exists paymentdatadetail cascade;
 
 create table paymentdatadetail (
   COMPANYCODE decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
@@ -1532,7 +1532,7 @@
   on paymentdatadetail(APPROVALPERSONCODE);
 
 -- �HŽ–ŠúŒÀ‰ñ”ðƒf�[ƒ^
-drop table periodavoidance cascade;
+drop table if exists periodavoidance cascade;
 
 create table periodavoidance (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1553,7 +1553,7 @@
   on periodavoidance(FieldNo);
 
 -- ’S“–ŽÒ�³”Fƒf�[ƒ^
-drop table personapproval cascade;
+drop table if exists personapproval cascade;
 
 create table personapproval (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
@@ -1572,7 +1572,7 @@
 ) comment '’S“–ŽÒ�³”Fƒf�[ƒ^' ;
 
 -- ’S“–ŽÒ�³”FƒRƒ�ƒ“ƒgƒf�[ƒ^
-drop table personapprovalcomment cascade;
+drop table if exists personapprovalcomment cascade;
 
 create table personapprovalcomment (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
@@ -1588,7 +1588,7 @@
 ) comment '’S“–ŽÒ�³”FƒRƒ�ƒ“ƒgƒf�[ƒ^' ;
 
 -- ’S“–ŽÒ‘Î�Û•”��ƒ}ƒXƒ^
-drop table persondepartmentmaster cascade;
+drop table if exists persondepartmentmaster cascade;
 
 create table persondepartmentmaster (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
@@ -1606,7 +1606,7 @@
   on persondepartmentmaster(DepartmentCode);
 
 -- ’S“–ŽÒƒ}ƒXƒ^
-drop table personinchargemaster cascade;
+drop table if exists personinchargemaster cascade;
 
 create table personinchargemaster (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
@@ -1641,7 +1641,7 @@
   on personinchargemaster(DepartmentCode);
 
 -- ’S“–ŽÒ‹‹—^ƒ}ƒXƒ^
-drop table personsalarymaster cascade;
+drop table if exists personsalarymaster cascade;
 
 create table personsalarymaster (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
@@ -1660,7 +1660,7 @@
   on personsalarymaster(StartDate);
 
 -- ŽwŽ¦Ž–�€ƒf�[ƒ^
-drop table pointingoutcomment cascade;
+drop table if exists pointingoutcomment cascade;
 
 create table pointingoutcomment (
   ConstructionCode decimal(10,0) not null comment '�HŽ–ƒR�[ƒh'
@@ -1682,7 +1682,7 @@
 ) comment 'ŽwŽ¦Ž–�€ƒf�[ƒ^' ;
 
 -- ”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^
-drop table proceedingsdata cascade;
+drop table if exists proceedingsdata cascade;
 
 create table proceedingsdata (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1698,7 +1698,7 @@
 ) comment '”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^' ;
 
 -- ”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^�i�o�ÈŽÒ�j
-drop table proceedingsdataattend cascade;
+drop table if exists proceedingsdataattend cascade;
 
 create table proceedingsdataattend (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1713,7 +1713,7 @@
 ) comment '”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^�i�o�ÈŽÒ�j' ;
 
 -- ”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^�i–¾�×�j
-drop table proceedingsdatadetail cascade;
+drop table if exists proceedingsdatadetail cascade;
 
 create table proceedingsdatadetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1729,7 +1729,7 @@
 ) comment '”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^�i–¾�×�j' ;
 
 -- �³”Fƒf�[ƒ^
-drop table processapproval cascade;
+drop table if exists processapproval cascade;
 
 create table processapproval (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1747,7 +1747,7 @@
 ) comment '�³”Fƒf�[ƒ^' ;
 
 -- �³”FƒRƒ�ƒ“ƒgƒf�[ƒ^
-drop table processapprovalcomment cascade;
+drop table if exists processapprovalcomment cascade;
 
 create table processapprovalcomment (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1762,7 +1762,7 @@
 ) comment '�³”FƒRƒ�ƒ“ƒgƒf�[ƒ^' ;
 
 -- �³”F–¾�×ƒf�[ƒ^
-drop table processapprovaldetail cascade;
+drop table if exists processapprovaldetail cascade;
 
 create table processapprovaldetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1776,7 +1776,7 @@
 ) comment '�³”F–¾�×ƒf�[ƒ^' ;
 
 -- ‹N“®‘Î�Ûƒ}ƒXƒ^
-drop table processexcutemaster cascade;
+drop table if exists processexcutemaster cascade;
 
 create table processexcutemaster (
   SecCode decimal(2,0) unsigned not null comment '•ÛŒì‹æ•ª”Ô�†'
@@ -1794,7 +1794,7 @@
   on processexcutemaster(ExecCode);
 
 -- ’�•¶�‘ƒf�[ƒ^
-drop table purchaseorder cascade;
+drop table if exists purchaseorder cascade;
 
 create table purchaseorder (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1830,7 +1830,7 @@
 ) comment '’�•¶�‘ƒf�[ƒ^' ;
 
 -- ’�•¶�‘“ú•tƒf�[ƒ^
-drop table purchaseorderdate cascade;
+drop table if exists purchaseorderdate cascade;
 
 create table purchaseorderdate (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1845,7 +1845,7 @@
 ) comment '’�•¶�‘“ú•tƒf�[ƒ^' ;
 
 -- ’�•¶�‘–¾�×ƒf�[ƒ^
-drop table purchaseorderdetail cascade;
+drop table if exists purchaseorderdetail cascade;
 
 create table purchaseorderdetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1872,7 +1872,7 @@
   on purchaseorderdetail(SourceCode);
 
 -- �¿‹�ƒf�[ƒ^
-drop table requestdata cascade;
+drop table if exists requestdata cascade;
 
 create table requestdata (
   REQUESTNO decimal(9,0) not null comment '�¿‹�No'
@@ -1897,7 +1897,7 @@
 ) comment '�¿‹�ƒf�[ƒ^' ;
 
 -- �¿‹�ƒf�[ƒ^–¾�×
-drop table requestdatadetail cascade;
+drop table if exists requestdatadetail cascade;
 
 create table requestdatadetail (
   REQUESTNO decimal(9,0) not null comment '�¿‹�No'
@@ -1912,7 +1912,7 @@
 ) comment '�¿‹�ƒf�[ƒ^–¾�×' ;
 
 -- �¿‹�ƒwƒbƒ_
-drop table requesthead cascade;
+drop table if exists requesthead cascade;
 
 create table requesthead (
   REQUESTNO decimal(9,0) not null comment '�¿‹�No'
@@ -1938,7 +1938,7 @@
 alter table requesthead add unique REQCONSTRUCTIONCODE (REQCONSTRUCTIONCODE,ORDERNO) ;
 
 -- �¿‹��‘“ú•tƒf�[ƒ^
-drop table requestorderdate cascade;
+drop table if exists requestorderdate cascade;
 
 create table requestorderdate (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -1950,7 +1950,7 @@
 ) comment '�¿‹��‘“ú•tƒf�[ƒ^' ;
 
 -- ”„�ãƒOƒ‰ƒtƒf�[ƒ^
-drop table salesgraphdata cascade;
+drop table if exists salesgraphdata cascade;
 
 create table salesgraphdata (
   GraphDataCode decimal(8,0) not null comment 'ƒOƒ‰ƒtƒf�[ƒ^ƒR�[ƒh'
@@ -1974,7 +1974,7 @@
   on salesgraphdata(ConstructionPeriod);
 
 -- •ÛŒì‹æ•ªƒ}ƒXƒ^
-drop table securitymaster cascade;
+drop table if exists securitymaster cascade;
 
 create table securitymaster (
   SecCode decimal(2,0) unsigned not null comment '•ÛŒì‹æ•ª”Ô�†'
@@ -1999,7 +1999,7 @@
   on securitymaster(SecRange);
 
 -- ˆÀ‘Sƒpƒgƒ��[ƒ‹ƒf�[ƒ^
-drop table sfpdata cascade;
+drop table if exists sfpdata cascade;
 
 create table sfpdata (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -2017,7 +2017,7 @@
   on sfpdata(RequestDate);
 
 -- ˆÀ‘Sƒpƒgƒ��[ƒ‹–¾�×ƒf�[ƒ^
-drop table sfpdatadetail cascade;
+drop table if exists sfpdatadetail cascade;
 
 create table sfpdatadetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -2030,7 +2030,7 @@
 ) comment 'ˆÀ‘Sƒpƒgƒ��[ƒ‹–¾�×ƒf�[ƒ^' ;
 
 -- ‹¦—Í‹ÆŽÒŽ{�H�HŽí“o˜^�\�¿ƒf�[ƒ^
-drop table subconstrjobitemregist cascade;
+drop table if exists subconstrjobitemregist cascade;
 
 create table subconstrjobitemregist (
   PersonCode decimal(8,0) unsigned not null comment '�\�¿ŽÒ”Ô�†'
@@ -2044,7 +2044,7 @@
 ) comment '‹¦—Í‹ÆŽÒŽ{�H�HŽí“o˜^�\�¿ƒf�[ƒ^' ;
 
 -- ‹¦—Í‹ÆŽÒ�EŽíƒŠƒ“ƒN“o˜^�\�¿ƒf�[ƒ^
-drop table subconstrjoblinkregist cascade;
+drop table if exists subconstrjoblinkregist cascade;
 
 create table subconstrjoblinkregist (
   PersonCode decimal(8,0) unsigned not null comment '�\�¿ŽÒ”Ô�†'
@@ -2058,7 +2058,7 @@
 ) comment '‹¦—Í‹ÆŽÒ�EŽíƒŠƒ“ƒN“o˜^�\�¿ƒf�[ƒ^' ;
 
 -- ‹¦—Í‹ÆŽÒ“o˜^�\�¿ƒf�[ƒ^
-drop table subconstrregist cascade;
+drop table if exists subconstrregist cascade;
 
 create table subconstrregist (
   PersonCode decimal(8,0) unsigned not null comment '�\�¿ŽÒ”Ô�†'
@@ -2093,7 +2093,7 @@
 ) comment '‹¦—Í‹ÆŽÒ“o˜^�\�¿ƒf�[ƒ^' ;
 
 -- ‹¦—Í‰ïŽÐ�HŽíƒ}ƒXƒ^
-drop table subcontractoritemmaster cascade;
+drop table if exists subcontractoritemmaster cascade;
 
 create table subcontractoritemmaster (
   ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
@@ -2106,7 +2106,7 @@
 ) comment '‹¦—Í‰ïŽÐ�HŽíƒ}ƒXƒ^' ;
 
 -- ‹¦—Í‰ïŽÐ�EŽíƒ}ƒXƒ^
-drop table subcontractorjobcategory cascade;
+drop table if exists subcontractorjobcategory cascade;
 
 create table subcontractorjobcategory (
   JobCategoryCode decimal(5,0) not null comment '�EŽíƒL�['
@@ -2119,7 +2119,7 @@
 ) comment '‹¦—Í‰ïŽÐ�EŽíƒ}ƒXƒ^' ;
 
 -- ‹¦—Í‰ïŽÐŽ{�H�HŽíƒf�[ƒ^
-drop table subcontractorjobitem cascade;
+drop table if exists subcontractorjobitem cascade;
 
 create table subcontractorjobitem (
   CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
@@ -2137,7 +2137,7 @@
   on subcontractorjobitem(ItemCode);
 
 -- ‹¦—Í‰ïŽÐ�EŽíƒŠƒ“ƒNƒ}ƒXƒ^
-drop table subcontractorjoblink cascade;
+drop table if exists subcontractorjoblink cascade;
 
 create table subcontractorjoblink (
   CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
@@ -2155,7 +2155,7 @@
   on subcontractorjoblink(JobCategoryCode);
 
 -- ‹¦—Í‰ïŽÐƒ}ƒXƒ^
-drop table subcontractormaster cascade;
+drop table if exists subcontractormaster cascade;
 
 create table subcontractormaster (
   CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
@@ -2188,7 +2188,7 @@
   on subcontractormaster(JapaneseSyllabary);
 
 -- Žd“ü�æƒ}ƒXƒ^
-drop table suppliersmaster cascade;
+drop table if exists suppliersmaster cascade;
 
 create table suppliersmaster (
   SuppliersCode decimal(5,0) unsigned not null comment 'Žd“ü�æƒR�[ƒh'
@@ -2209,7 +2209,7 @@
 ) comment 'Žd“ü�æƒ}ƒXƒ^' ;
 
 -- ƒVƒXƒeƒ€‹N“®Šm”Fƒf�[ƒ^
-drop table systemexecute cascade;
+drop table if exists systemexecute cascade;
 
 create table systemexecute (
   PrimaryCode tinyint(4) not null comment 'ƒL�[�€–Ú'
@@ -2222,7 +2222,7 @@
 ) comment 'ƒVƒXƒeƒ€‹N“®Šm”Fƒf�[ƒ^' ;
 
 -- ŠÇ—�ƒ}ƒXƒ^
-drop table systemmaster cascade;
+drop table if exists systemmaster cascade;
 
 create table systemmaster (
   SystemCode decimal(3,0) unsigned not null comment '‰ïŽÐƒR�[ƒh'
@@ -2259,7 +2259,7 @@
 ) comment 'ŠÇ—�ƒ}ƒXƒ^' ;
 
 -- ŠúŒÀƒ}ƒXƒ^
-drop table termmaster cascade;
+drop table if exists termmaster cascade;
 
 create table termmaster (
   ConstructionStatusFlg decimal(2,0) not null comment '�HŽ–�ó‘Ôƒtƒ‰ƒO'
@@ -2281,7 +2281,7 @@
   on termmaster(DisplayOrder);
 
 -- �o‹ÎŒð’Ê”ïƒf�[ƒ^
-drop table tranceportdailydata cascade;
+drop table if exists tranceportdailydata cascade;
 
 create table tranceportdailydata (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
@@ -2303,7 +2303,7 @@
   on tranceportdailydata(AttendanceDate);
 
 -- �HŽ–Ží•ÊŒo”ï—¦ƒ}ƒXƒ^
-drop table typeexpensesmaster cascade;
+drop table if exists typeexpensesmaster cascade;
 
 create table typeexpensesmaster (
   TypeCode decimal(5,0) unsigned not null comment '�HŽ–Ží•ÊƒR�[ƒh'
@@ -2317,7 +2317,7 @@
 ) comment '�HŽ–Ží•ÊŒo”ï—¦ƒ}ƒXƒ^' ;
 
 -- ’PˆÊƒ}ƒXƒ^
-drop table unitmaster cascade;
+drop table if exists unitmaster cascade;
 
 create table unitmaster (
   UnitKey decimal(5,0) unsigned not null comment '’PˆÊƒL�['
@@ -2332,7 +2332,7 @@
   on unitmaster(DisplayOrder);
 
 -- ŽÔ—¼ƒ}ƒXƒ^
-drop table vehiclemaster cascade;
+drop table if exists vehiclemaster cascade;
 
 create table vehiclemaster (
   VehicleCode decimal(5,0) unsigned not null comment 'ŽÔ—¼ƒR�[ƒh'
@@ -2361,7 +2361,7 @@
 ) comment 'ŽÔ—¼ƒ}ƒXƒ^' ;
 
 -- ŽÔ—¼‹L˜^ƒf�[ƒ^
-drop table vehiclerecorddata cascade;
+drop table if exists vehiclerecorddata cascade;
 
 create table vehiclerecorddata (
   VehicleCode decimal(5,0) unsigned not null comment 'ŽÔ—¼ƒR�[ƒh'
@@ -2377,7 +2377,7 @@
 ) comment 'ŽÔ—¼‹L˜^ƒf�[ƒ^' ;
 
 -- ŽÔ—¼—\–ñƒf�[ƒ^
-drop table vehiclescheduledata cascade;
+drop table if exists vehiclescheduledata cascade;
 
 create table vehiclescheduledata (
   TargetDate date not null comment '‘Î�Û“ú'
@@ -2402,7 +2402,7 @@
   on vehiclescheduledata(TargetDay);
 
 -- ”Nƒ}ƒXƒ^
-drop table yearmaster cascade;
+drop table if exists yearmaster cascade;
 
 create table yearmaster (
   years smallint(6) not null comment '”N'
