Index: ProcessManagement.sql
===================================================================
--- ProcessManagement.sql	(revision 369)
+++ ProcessManagement.sql	(revision 370)
@@ -1,12 +1,20 @@
 -- Project Name : noname
--- Date/Time    : 2018/07/24 8:34:39
+-- Date/Time    : 2018/08/06 8:37:19
 -- Author       : Horiuchi
 -- RDBMS Type   : MySQL
 -- Application  : A5:SQL Mk-2
 
+/*
+  BackupToTempTable, RestoreFromTempTable‹^Ž—–½—ß‚ª•t‰Á‚³‚ê‚Ä‚¢‚Ü‚·�B
+  ‚±‚ê‚É‚æ‚è�Adrop table, create table Œã‚àƒf�[ƒ^‚ªŽc‚è‚Ü‚·�B
+  ‚±‚Ì‹@”\‚ÍˆêŽž“I‚É $$TableName ‚Ì‚æ‚¤‚ÈˆêŽžƒe�[ƒuƒ‹‚ð�ì�¬‚µ‚Ü‚·�B
+*/
+
 -- ’S“–ŽÒ�s“®—\’èƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists actionscheduledata cascade;
 
+--* RestoreFromTempTable
 create table actionscheduledata (
   TargetDate date not null comment '‘Î�Û“ú'
   , PersonCode decimal(8,0) not null comment '’S“–ŽÒƒR�[ƒh'
@@ -29,8 +37,10 @@
   on actionscheduledata(TargetDay);
 
 -- �³”FŒo˜Hƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists approvalmaster cascade;
 
+--* RestoreFromTempTable
 create table approvalmaster (
   ApprovalCode decimal(3,0) unsigned not null comment '�³”F‹@”\”Ô�†'
   , DepartmentCode decimal(5,0) unsigned not null comment '•”��ƒR�[ƒh'
@@ -44,8 +54,10 @@
 ) comment '�³”FŒo˜Hƒ}ƒXƒ^' ;
 
 -- �o‹Î“ú•ñƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists attendancedailydata cascade;
 
+--* RestoreFromTempTable
 create table attendancedailydata (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
   , AttendanceDate date not null comment '“ú•ñ�ì�¬“ú'
@@ -69,8 +81,10 @@
   on attendancedailydata(AttendanceDate);
 
 -- �o‹ÎŠÇ—�ƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists attendancedata cascade;
 
+--* RestoreFromTempTable
 create table attendancedata (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
   , AttendanceMonth date not null comment '�o‹ÎŠÇ—�”NŒŽ'
@@ -85,8 +99,10 @@
 ) comment '�o‹ÎŠÇ—�ƒf�[ƒ^' ;
 
 -- ‹â�s‰c‹Æ“úƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists bankbusinessdaymaster cascade;
 
+--* RestoreFromTempTable
 create table bankbusinessdaymaster (
   YEARMONTH decimal(6,0) default '0' not null comment '”NŒŽ'
   , BANKBUSINESSDAY decimal(2,0) default '0' not null comment '‹â�s‰c‹Æ“ú'
@@ -98,8 +114,10 @@
 ) comment '‹â�s‰c‹Æ“úƒ}ƒXƒ^' ;
 
 -- ‹ÆŽÒ�¿‹�ƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists billingdata cascade;
 
+--* RestoreFromTempTable
 create table billingdata (
   COMPANYCODE decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
   , TARGETDATE decimal(6,0) default '0' not null comment '‘Î�Û”NŒŽ'
@@ -111,8 +129,10 @@
 ) comment '‹ÆŽÒ�¿‹�ƒf�[ƒ^' ;
 
 -- ‹ÆŽÒ�¿‹�–¾�×ƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists billingdatadetail cascade;
 
+--* RestoreFromTempTable
 create table billingdatadetail (
   COMPANYCODE decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
   , TARGETDATE decimal(6,0) default '0' not null comment '‘Î�Û”NŒŽ'
@@ -133,8 +153,10 @@
 ) comment '‹ÆŽÒ�¿‹�–¾�×ƒf�[ƒ^' ;
 
 -- ‹ÆŽÒ�¿‹�Žx•¥ƒTƒ}ƒŠ�[ƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists billingpaymentsummary cascade;
 
+--* RestoreFromTempTable
 create table billingpaymentsummary (
   COMPANYCODE decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
   , TARGETDATE decimal(6,0) default '0' not null comment '‘Î�Û”NŒŽ'
@@ -155,8 +177,10 @@
 ) comment '‹ÆŽÒ�¿‹�Žx•¥ƒTƒ}ƒŠ�[ƒf�[ƒ^' ;
 
 -- ‰^‰cŠú—š—ð�î•ñ
+--* BackupToTempTable
 drop table if exists bizperiodhistory cascade;
 
+--* RestoreFromTempTable
 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'
@@ -168,8 +192,10 @@
 ) comment '‰^‰cŠú—š—ð�î•ñ' ;
 
 -- �HŽ–�Ú�×‘ä’ ƒf�[ƒ^�y‘Þ”ð—p�z
+--* BackupToTempTable
 drop table if exists bk_constructionledger cascade;
 
+--* RestoreFromTempTable
 create table bk_constructionledger (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , ConstructionPeriod decimal(4,0) unsigned not null comment 'Ž–‹ÆŠú'
@@ -195,8 +221,10 @@
 ) comment '�HŽ–�Ú�×‘ä’ ƒf�[ƒ^�y‘Þ”ð—p�z' ;
 
 -- �HŽ–�Ú�×‘ä’ –¾�×ƒf�[ƒ^�y‘Þ”ð—p�z
+--* BackupToTempTable
 drop table if exists bk_constructionledgerdetail cascade;
 
+--* RestoreFromTempTable
 create table bk_constructionledgerdetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , GroupCount decimal(2,0) unsigned not null comment 'ƒOƒ‹�[ƒv”Ô�†'
@@ -228,8 +256,10 @@
 ) comment '�HŽ–�Ú�×‘ä’ –¾�×ƒf�[ƒ^�y‘Þ”ð—p�z' ;
 
 -- �HŽ–�Ú�×‘ä’ ŽÀ�sƒf�[ƒ^�y‘Þ”ð—p�z
+--* BackupToTempTable
 drop table if exists bk_constructionledgerexcute cascade;
 
+--* RestoreFromTempTable
 create table bk_constructionledgerexcute (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , GroupCount decimal(2,0) unsigned not null comment 'ƒOƒ‹�[ƒv”Ô�†'
@@ -243,8 +273,10 @@
 ) comment '�HŽ–�Ú�×‘ä’ ŽÀ�sƒf�[ƒ^�y‘Þ”ð—p�z' ;
 
 -- �ÏŽZŒ©�Ïƒf�[ƒ^�y‘Þ”ð—p�z
+--* BackupToTempTable
 drop table if exists bk_estimatedata cascade;
 
+--* RestoreFromTempTable
 create table bk_estimatedata (
   SaveDate datetime not null comment '‘Þ”ð“ú•t'
   , ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -263,8 +295,10 @@
 ) comment '�ÏŽZŒ©�Ïƒf�[ƒ^�y‘Þ”ð—p�z' ;
 
 -- �ÏŽZŒ©�Ïƒy�[ƒWƒf�[ƒ^�y‘Þ”ð—p�z
+--* BackupToTempTable
 drop table if exists bk_estimatedatabody cascade;
 
+--* RestoreFromTempTable
 create table bk_estimatedatabody (
   SaveDate datetime not null comment '‘Þ”ð“ú•t'
   , ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -282,8 +316,10 @@
 ) comment '�ÏŽZŒ©�Ïƒy�[ƒWƒf�[ƒ^�y‘Þ”ð—p�z' ;
 
 -- �ÏŽZŒ©�Ïƒf�[ƒ^–¾�×�y‘Þ”ð—p�z
+--* BackupToTempTable
 drop table if exists bk_estimatedatadetail cascade;
 
+--* RestoreFromTempTable
 create table bk_estimatedatadetail (
   SaveDate datetime not null comment '‘Þ”ð“ú•t'
   , ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -309,8 +345,10 @@
 ) comment '�ÏŽZŒ©�Ïƒf�[ƒ^–¾�×�y‘Þ”ð—p�z' ;
 
 -- —\ŽZ�‘�WŒvƒR�[ƒhƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists budgetsumcode cascade;
 
+--* RestoreFromTempTable
 create table budgetsumcode (
   BlockCode decimal(2,0) unsigned not null comment 'ƒuƒ�ƒbƒN”Ô�†'
   , GroupCode decimal(2,0) unsigned not null comment 'ƒOƒ‹�[ƒv”Ô�†'
@@ -323,8 +361,10 @@
 ) comment '—\ŽZ�‘�WŒvƒR�[ƒhƒ}ƒXƒ^' ;
 
 -- –@�lŠiƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists businesstypemaster cascade;
 
+--* RestoreFromTempTable
 create table businesstypemaster (
   BusinessTypeCode decimal(5,0) unsigned not null comment '–@�lŠiƒR�[ƒh'
   , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
@@ -338,8 +378,10 @@
   on businesstypemaster(DisplayOrder);
 
 -- ’S“–ŽÒ•”��—š—ðƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists chgchargedep cascade;
 
+--* RestoreFromTempTable
 create table chgchargedep (
   PersonCode decimal(8,0) not null comment '’S“–ŽÒƒR�[ƒh'
   , StartDate date not null comment 'ŠJŽn”NŒŽ“ú'
@@ -352,8 +394,10 @@
 ) comment '’S“–ŽÒ•”��—š—ðƒf�[ƒ^' ;
 
 -- �HŽ–’S“–•Ï�X—š—ðƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists chgconstrcharge cascade;
 
+--* RestoreFromTempTable
 create table chgconstrcharge (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , Division decimal(1,0) not null comment '�Ý’è‹æ•ª'
@@ -370,8 +414,10 @@
 ) comment '�HŽ–’S“–•Ï�X—š—ðƒf�[ƒ^' ;
 
 -- ‹¤’Ê”ï‘å�€–Úƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists commoncostlarge cascade;
 
+--* RestoreFromTempTable
 create table commoncostlarge (
   LargeCode decimal(5,0) unsigned not null comment '‘å�€–ÚƒL�['
   , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
@@ -384,8 +430,10 @@
 ) comment '‹¤’Ê”ï‘å�€–Úƒ}ƒXƒ^' ;
 
 -- ‹¤’Ê”ï�HŽíŠÖ˜Aƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists commoncostlinkms cascade;
 
+--* RestoreFromTempTable
 create table commoncostlinkms (
   LargeCode decimal(5,0) unsigned not null comment '‘å�€–ÚƒL�['
   , MiddleCode decimal(5,0) unsigned not null comment '’†�€–ÚƒL�['
@@ -396,8 +444,10 @@
 ) comment '‹¤’Ê”ï�HŽíŠÖ˜Aƒ}ƒXƒ^' ;
 
 -- ‹¤’Ê”ï’†�€–Úƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists commoncostmiddle cascade;
 
+--* RestoreFromTempTable
 create table commoncostmiddle (
   LargeCode decimal(5,0) unsigned not null comment '‘å�€–ÚƒL�['
   , MiddleCode decimal(5,0) unsigned not null comment '’†�€–ÚƒL�['
@@ -411,8 +461,10 @@
 ) comment '‹¤’Ê”ï’†�€–Úƒ}ƒXƒ^' ;
 
 -- ‹¤’Ê”ï’†�€–ÚƒL�[ƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists commoncostmiddlesearchword cascade;
 
+--* RestoreFromTempTable
 create table commoncostmiddlesearchword (
   LargeCode decimal(5,0) unsigned not null comment '‘å�€–ÚƒL�['
   , MiddleCode decimal(5,0) unsigned not null comment '’†�€–ÚƒL�['
@@ -424,8 +476,10 @@
 ) comment '‹¤’Ê”ï’†�€–ÚƒL�[ƒ}ƒXƒ^' ;
 
 -- �\�¬�HŽíŠÖ˜Aƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists componentlinkmaster cascade;
 
+--* RestoreFromTempTable
 create table componentlinkmaster (
   ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
   , ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
@@ -442,8 +496,10 @@
   on componentlinkmaster(ItemCode);
 
 -- �\�¬ƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists componentmaster cascade;
 
+--* RestoreFromTempTable
 create table componentmaster (
   ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
   , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
@@ -461,8 +517,10 @@
   on componentmaster(DisplayOrder);
 
 -- �\�¬�HŽ–Ží•ÊŠÖ˜Aƒ}ƒ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'
@@ -479,8 +537,10 @@
   on componenttotypemaster(TypeCode);
 
 -- �HŽ–�Ú�×‘ä’ Œo”ïƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists constrledgerexpenses cascade;
 
+--* RestoreFromTempTable
 create table constrledgerexpenses (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , SeqNo decimal(5,0) not null comment 'Ž}”Ô'
@@ -502,8 +562,10 @@
   on constrledgerexpenses(NameCode);
 
 -- �HŽ–Šî–{�î•ñ
+--* BackupToTempTable
 drop table if exists constructionbaseinfo cascade;
 
+--* RestoreFromTempTable
 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'
@@ -585,8 +647,10 @@
   on constructionbaseinfo(ConstructionPeriod);
 
 -- �HŽ–Šî–{�î•ñ–¾�×
+--* BackupToTempTable
 drop table if exists constructionbaseinfodetail cascade;
 
+--* RestoreFromTempTable
 create table constructionbaseinfodetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , DetailNo decimal(3,0) not null comment '–¾�×”Ô�†'
@@ -603,8 +667,10 @@
   on constructionbaseinfodetail(DetailNo);
 
 -- �HŽ–Ž{�H—\ŽZƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists constructionbudget cascade;
 
+--* RestoreFromTempTable
 create table constructionbudget (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , CreatorCode decimal(8,0) not null comment '�ì�¬ŽÒƒR�[ƒh'
@@ -634,8 +700,10 @@
 ) comment '�HŽ–Ž{�H—\ŽZƒf�[ƒ^' ;
 
 -- �HŽ–Ž{�H—\ŽZƒf�[ƒ^–¾�×
+--* BackupToTempTable
 drop table if exists constructionbudgetdetail cascade;
 
+--* RestoreFromTempTable
 create table constructionbudgetdetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , GroupCount decimal(2,0) unsigned not null comment 'ƒOƒ‹�[ƒv”Ô�†'
@@ -659,8 +727,10 @@
 ) comment '�HŽ–Ž{�H—\ŽZƒf�[ƒ^–¾�×' ;
 
 -- �HŽíƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists constructionitemmaster cascade;
 
+--* RestoreFromTempTable
 create table constructionitemmaster (
   ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
   , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
@@ -674,8 +744,10 @@
 ) comment '�HŽíƒ}ƒXƒ^' ;
 
 -- �HŽ–�Ú�×‘ä’ ƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists constructionledger cascade;
 
+--* RestoreFromTempTable
 create table constructionledger (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , ConstructionPeriod decimal(4,0) unsigned not null comment 'Ž–‹ÆŠú'
@@ -707,8 +779,10 @@
   on constructionledger(ConstructionEnd);
 
 -- �HŽ–�Ú�×‘ä’ –¾�×ƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists constructionledgerdetail cascade;
 
+--* RestoreFromTempTable
 create table constructionledgerdetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , GroupCount decimal(2,0) unsigned not null comment 'ƒOƒ‹�[ƒv”Ô�†'
@@ -762,8 +836,10 @@
   on constructionledgerdetail(CompanyCode);
 
 -- �HŽ–�Ú�×‘ä’ ŽÀ�sƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists constructionledgerexcute cascade;
 
+--* RestoreFromTempTable
 create table constructionledgerexcute (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , GroupCount decimal(2,0) unsigned not null comment 'ƒOƒ‹�[ƒv”Ô�†'
@@ -780,8 +856,10 @@
   on constructionledgerexcute(ConstructionCode,TargetMonth,GroupCount,LineCount);
 
 -- �HŽ–ƒŠƒ“ƒN�î•ñ
+--* BackupToTempTable
 drop table if exists constructionlink cascade;
 
+--* RestoreFromTempTable
 create table constructionlink (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , FluctuationCode decimal(10,0) not null comment 'Žq�HŽ–”Ô�†'
@@ -801,8 +879,10 @@
   on constructionlink(LinkType);
 
 -- �HŽ–Ž‘�Þ�î•ñ
+--* BackupToTempTable
 drop table if exists constructionmaterialinfo cascade;
 
+--* RestoreFromTempTable
 create table constructionmaterialinfo (
   CONSTRUCTIONCODE int(10) unsigned default 0 not null comment '�HŽ–”Ô�†'
   , MATERIALITEMCODE smallint(5) unsigned default 0 not null comment 'Ž‘�Þ•i–ÚƒR�[ƒh'
@@ -817,8 +897,10 @@
 ) comment '�HŽ–Ž‘�Þ�î•ñ' ;
 
 -- ˆÄŒ��i’»“ú•tƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists constructionprogressdate cascade;
 
+--* RestoreFromTempTable
 create table constructionprogressdate (
   ConstructionCode decimal(10,0) not null comment '�HŽ–”Ô�†'
   , ConstructionStatusFlg decimal(2,0) not null comment '�Ý’è�HŽ–�ó‘Ô'
@@ -840,8 +922,10 @@
   on constructionprogressdate(ChangeDate);
 
 -- �ì‹Æƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists constructionspecmaster cascade;
 
+--* RestoreFromTempTable
 create table constructionspecmaster (
   ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
   , SpecCode decimal(5,0) unsigned not null comment '�ì‹ÆƒL�['
@@ -860,8 +944,10 @@
   on constructionspecmaster(DisplayOrder);
 
 -- �ì‹Æ’P‰¿ƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists constructionspecunitprice cascade;
 
+--* RestoreFromTempTable
 create table constructionspecunitprice (
   ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
   , ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
@@ -874,8 +960,10 @@
 ) comment '�ì‹Æ’P‰¿ƒ}ƒXƒ^' ;
 
 -- �HŽ–Ží•Êƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists constructiontypemaster cascade;
 
+--* RestoreFromTempTable
 create table constructiontypemaster (
   TypeCode decimal(5,0) unsigned not null comment '�HŽ–Ží•ÊƒR�[ƒh'
   , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
@@ -891,8 +979,10 @@
 ) comment '�HŽ–Ží•Êƒ}ƒXƒ^' ;
 
 -- •”���o”[ƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists costdataofdepartment cascade;
 
+--* RestoreFromTempTable
 create table costdataofdepartment (
   DepartmentCode decimal(5,0) unsigned not null comment '•”��ƒR�[ƒh'
   , ConstrYear smallint(5) unsigned not null comment '�HŽ–Šú�”�E”N�”'
@@ -912,8 +1002,10 @@
 ) comment '•”���o”[ƒf�[ƒ^' ;
 
 -- ’S“–ŽÒ–ˆŒo”ïƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists costdataofperson cascade;
 
+--* RestoreFromTempTable
 create table costdataofperson (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
   , ActionDate date not null comment '‘Î�Û“ú•t'
@@ -942,8 +1034,10 @@
   on costdataofperson(ConstructionCode);
 
 -- ”­’�ŽÒ“o˜^�\�¿ƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists costomerregist cascade;
 
+--* RestoreFromTempTable
 create table costomerregist (
   CreatePersonCode decimal(8,0) unsigned not null comment '�\�¿ŽÒ”Ô�†'
   , CreateDate date not null comment '�ì�¬“ú'
@@ -987,8 +1081,10 @@
   on costomerregist(CreateDepartmentCode);
 
 -- “ú•ñƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists dailydataconstruction cascade;
 
+--* RestoreFromTempTable
 create table dailydataconstruction (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
   , DailyDataDate date not null comment '“ú•ñ�ì�¬“ú'
@@ -1009,8 +1105,10 @@
   on dailydataconstruction(ConstructionCode);
 
 -- “ú•ñƒf�[ƒ^ (–¾�×)
+--* BackupToTempTable
 drop table if exists dailydatadetail cascade;
 
+--* RestoreFromTempTable
 create table dailydatadetail (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
   , DailyDataDate date not null comment '“ú•ñ�ì�¬“ú'
@@ -1032,8 +1130,10 @@
   on dailydatadetail(PersonCode,DailyDataDate,ConstructionCode);
 
 -- “ú•ñƒf�[ƒ^ (Œ»�ê�„‰ñ)
+--* BackupToTempTable
 drop table if exists dailydatafield cascade;
 
+--* RestoreFromTempTable
 create table dailydatafield (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
   , DailyDataDate date not null comment '“ú•ñ�ì�¬“ú'
@@ -1050,8 +1150,10 @@
   on dailydatafield(PersonCode,DailyDataDate,ConstructionCode);
 
 -- “ú•ñƒf�[ƒ^ (Ž‘�Þ)
+--* BackupToTempTable
 drop table if exists dailydatamaterials cascade;
 
+--* RestoreFromTempTable
 create table dailydatamaterials (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
   , DailyDataDate date not null comment '“ú•ñ�ì�¬“ú'
@@ -1071,8 +1173,10 @@
   on dailydatamaterials(PersonCode,DailyDataDate,ConstructionCode);
 
 -- “ú•ñƒf�[ƒ^ (‹¦—Í‹ÆŽÒŽwŽ¦)
+--* BackupToTempTable
 drop table if exists dailydatasubcontractors cascade;
 
+--* RestoreFromTempTable
 create table dailydatasubcontractors (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
   , DailyDataDate date not null comment '“ú•ñ�ì�¬“ú'
@@ -1089,8 +1193,10 @@
   on dailydatasubcontractors(PersonCode,DailyDataDate,ConstructionCode);
 
 -- “ú•ñƒf�[ƒ^ (ŽÔ—¼)
+--* BackupToTempTable
 drop table if exists dailydatavehicles cascade;
 
+--* RestoreFromTempTable
 create table dailydatavehicles (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
   , DailyDataDate date not null comment '“ú•ñ�ì�¬“ú'
@@ -1111,8 +1217,10 @@
   on dailydatavehicles(PersonCode,DailyDataDate,ConstructionCode);
 
 -- “úƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists daymaster cascade;
 
+--* RestoreFromTempTable
 create table daymaster (
   days smallint(6) not null comment '“ú'
   , constraint daymaster_PKC primary key (days)
@@ -1119,8 +1227,10 @@
 ) comment '“úƒ}ƒXƒ^' ;
 
 -- ’÷“úƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists deadlinemaster cascade;
 
+--* RestoreFromTempTable
 create table deadlinemaster (
   LABOURKIND decimal(1,0) default '0' not null comment 'ŽèŠÔ‹ÆŽÒ‹æ•ª'
   , DEADLINE decimal(2,0) comment '’÷“ú'
@@ -1133,8 +1243,10 @@
 ) comment '’÷“úƒ}ƒXƒ^' ;
 
 -- •”��Œo”ï—¦ƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists departmentexpensesmaster cascade;
 
+--* RestoreFromTempTable
 create table departmentexpensesmaster (
   DepartmentCode decimal(5,0) unsigned not null comment '•”��ƒR�[ƒh'
   , ExpensesPeriod smallint(6) not null comment 'Ž–‹ÆŠú'
@@ -1149,8 +1261,10 @@
 ) comment '•”��Œo”ï—¦ƒ}ƒXƒ^' ;
 
 -- •”��ƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists departmentmaster cascade;
 
+--* RestoreFromTempTable
 create table departmentmaster (
   DepartmentCode decimal(5,0) unsigned not null comment '•”��ƒR�[ƒh'
   , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
@@ -1169,8 +1283,10 @@
   on departmentmaster(DisplayOrder);
 
 -- “ü‹àŠm”F�³”Fƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists depositapprovalinfo cascade;
 
+--* RestoreFromTempTable
 create table depositapprovalinfo (
   ORDERERSDIVISION decimal(5,0) not null comment '”­’�ŽÒ‹æ•ª'
   , ORDERERSCODE decimal(5,0) not null comment '”­’�ŽÒƒR�[ƒh'
@@ -1188,8 +1304,10 @@
 ) comment '“ü‹àŠm”F�³”Fƒf�[ƒ^' ;
 
 -- “ü‹àƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists depositdata cascade;
 
+--* RestoreFromTempTable
 create table depositdata (
   ORDERERSDIVISION decimal(5,0) not null comment '”­’�ŽÒ‹æ•ª'
   , ORDERERSCODE decimal(5,0) not null comment '”­’�ŽÒƒR�[ƒh'
@@ -1208,8 +1326,10 @@
 ) comment '“ü‹àƒf�[ƒ^' ;
 
 -- “ü‹à–¾�×ƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists depositdatadetail cascade;
 
+--* RestoreFromTempTable
 create table depositdatadetail (
   ORDERERSDIVISION decimal(5,0) not null comment '”­’�ŽÒ‹æ•ª'
   , ORDERERSCODE decimal(5,0) not null comment '”­’�ŽÒƒR�[ƒh'
@@ -1232,8 +1352,10 @@
 ) comment '“ü‹à–¾�×ƒf�[ƒ^' ;
 
 -- ‹æ•ªƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists divisionmaster cascade;
 
+--* RestoreFromTempTable
 create table divisionmaster (
   DivisionCode decimal(5,0) unsigned not null comment '‹æ•ªƒR�[ƒh'
   , NameCode decimal(5,0) unsigned not null comment '–¼�ÌƒR�[ƒh'
@@ -1246,8 +1368,10 @@
 ) comment '‹æ•ªƒ}ƒXƒ^' ;
 
 -- �ÏŽZ—\ŽZ�‘ƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists estimatebudget cascade;
 
+--* RestoreFromTempTable
 create table estimatebudget (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , ConstructionTime decimal(5,2) unsigned not null comment '�HŠú'
@@ -1264,8 +1388,10 @@
 ) comment '�ÏŽZ—\ŽZ�‘ƒf�[ƒ^' ;
 
 -- �ÏŽZ—\ŽZ“à–óƒf�[ƒ^–¾�×
+--* BackupToTempTable
 drop table if exists estimatebudgetdetail cascade;
 
+--* RestoreFromTempTable
 create table estimatebudgetdetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , GroupCount decimal(2,0) unsigned not null comment 'ƒOƒ‹�[ƒv”Ô�†'
@@ -1285,8 +1411,10 @@
 ) comment '�ÏŽZ—\ŽZ“à–óƒf�[ƒ^–¾�×' ;
 
 -- �ÏŽZŒ©�Ïƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists estimatedata cascade;
 
+--* RestoreFromTempTable
 create table estimatedata (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , LineCount decimal(3,0) unsigned not null comment '�s”Ô�†'
@@ -1307,8 +1435,10 @@
   on estimatedata(ConstructionCode,FixedItemCode);
 
 -- �ÏŽZŒ©�Ïƒy�[ƒWƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists estimatedatabody cascade;
 
+--* RestoreFromTempTable
 create table estimatedatabody (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , PageCount decimal(4,0) unsigned not null comment 'ƒy�[ƒW”Ô�†'
@@ -1328,8 +1458,10 @@
   on estimatedatabody(ConstructionCode,ComponentCode,ItemCode);
 
 -- �ÏŽZŒ©�Ïƒf�[ƒ^–¾�×
+--* BackupToTempTable
 drop table if exists estimatedatadetail cascade;
 
+--* RestoreFromTempTable
 create table estimatedatadetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , PageCount decimal(4,0) unsigned not null comment 'ƒy�[ƒW”Ô�†'
@@ -1357,8 +1489,10 @@
   on estimatedatadetail(ConstructionCode,PageCount);
 
 -- Œo”ï—¦ƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists expensesmaster cascade;
 
+--* RestoreFromTempTable
 create table expensesmaster (
   DivisionCode smallint(6) not null comment '�HŽ–Ží•ÊƒR�[ƒh'
   , NameCode smallint(6) not null comment 'Œo”ï–¼�ÌƒR�[ƒh'
@@ -1371,8 +1505,10 @@
 ) comment 'Œo”ï—¦ƒ}ƒXƒ^' ;
 
 -- ‰ïŽÐ‹x“úƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists holidaycalendermaster cascade;
 
+--* RestoreFromTempTable
 create table holidaycalendermaster (
   Holiday date not null comment '‹x“ú'
   , BusinessYear smallint(5) unsigned not null comment '‰c‹Æ”N“x'
@@ -1391,8 +1527,10 @@
   on holidaycalendermaster(TargetDay);
 
 -- “ü—ÍŽžŒŸ�õ—š—ð
+--* BackupToTempTable
 drop table if exists inputsearchlogdata cascade;
 
+--* RestoreFromTempTable
 create table inputsearchlogdata (
   ConstructionCode decimal(10,0) not null comment '�HŽ–ƒR�[ƒh'
   , UsedProcessNo decimal(4,0) not null comment 'Žg—p‹@”\”Ô�†'
@@ -1406,8 +1544,10 @@
   on inputsearchlogdata(ConstructionCode,UsedProcessNo,InputCode);
 
 -- �¿‹��‘ƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists invoicedata cascade;
 
+--* RestoreFromTempTable
 create table invoicedata (
   INVOICENO decimal(9,0) not null comment '�¿‹��‘No'
   , ORDERERSDIVISION decimal(5,0) not null comment '”­’�ŽÒ‹æ•ª'
@@ -1433,8 +1573,10 @@
 alter table invoicedata add unique ORDERERSDIVISION (ORDERERSDIVISION,ORDERERSCODE,REQUESTMONTH,SEQNO) ;
 
 -- Ž‘�Þ�î•ñ
+--* BackupToTempTable
 drop table if exists materialinfo cascade;
 
+--* RestoreFromTempTable
 create table materialinfo (
   MATERIALITEMCODE smallint(5) unsigned default 0 not null comment 'Ž‘�Þ•i–ÚƒR�[ƒh'
   , MATERIALCOUNT smallint(5) unsigned comment 'Ž‘�Þ�”'
@@ -1446,8 +1588,10 @@
 ) comment 'Ž‘�Þ�î•ñ' ;
 
 -- Ž‘�Þ•i–Úƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists materialitemmaster cascade;
 
+--* RestoreFromTempTable
 create table materialitemmaster (
   MATERIALITEMCODE smallint(5) unsigned default 0 not null comment 'Ž‘�Þ•i–ÚƒR�[ƒh'
   , MATERIALKINDCODE smallint(5) unsigned comment 'Ž‘�ÞŽí—ÞƒR�[ƒh'
@@ -1461,8 +1605,10 @@
 ) comment 'Ž‘�Þ•i–Úƒ}ƒXƒ^' ;
 
 -- Ž‘�ÞŽí—Þƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists materialkindmaster cascade;
 
+--* RestoreFromTempTable
 create table materialkindmaster (
   MATERIALKINDCODE smallint(5) unsigned default 0 not null comment 'Ž‘�ÞŽí—ÞƒR�[ƒh'
   , MATERIALKINDNAME varchar(40) comment 'Ž‘�ÞŽí—Þ–¼�Ì'
@@ -1474,8 +1620,10 @@
 ) comment 'Ž‘�ÞŽí—Þƒ}ƒXƒ^' ;
 
 -- Ž‘�Þ—š—ð�î•ñ
+--* BackupToTempTable
 drop table if exists materialrecordinfo cascade;
 
+--* RestoreFromTempTable
 create table materialrecordinfo (
   MATERIALITEMCODE smallint(5) unsigned default 0 not null comment 'Ž‘�Þ•i–ÚƒR�[ƒh'
   , PROCESSDATE date default '0000-00-00' not null comment '�ˆ—�”NŒŽ“ú'
@@ -1492,8 +1640,10 @@
 ) comment 'Ž‘�Þ—š—ð�î•ñ' ;
 
 -- ŒfŽ¦”Âƒ�ƒbƒZ�[ƒW
+--* BackupToTempTable
 drop table if exists messageboarddata cascade;
 
+--* RestoreFromTempTable
 create table messageboarddata (
   RecordNumber decimal(6,0) unsigned not null comment 'ƒŒƒR�[ƒh”Ô�†'
   , BranchNumber decimal(3,0) unsigned not null comment 'ƒŒƒR�[ƒhŽ}”Ô'
@@ -1522,8 +1672,10 @@
   on messageboarddata(MessageFlag);
 
 -- ŒfŽ¦”Â‘Î�ÛŽÒƒe�[ƒuƒ‹
+--* BackupToTempTable
 drop table if exists messageboardterget cascade;
 
+--* RestoreFromTempTable
 create table messageboardterget (
   RecordNumber decimal(6,0) unsigned not null comment 'ƒŒƒR�[ƒh”Ô�†'
   , BranchNumber decimal(3,0) unsigned not null comment 'ƒŒƒR�[ƒhŽ}”Ô'
@@ -1539,8 +1691,10 @@
   on messageboardterget(RecordNumber,BranchNumber);
 
 -- ŒfŽ¦”Âƒ�ƒbƒZ�[ƒW‰{———š—ð
+--* BackupToTempTable
 drop table if exists messagebrowsinghistory cascade;
 
+--* RestoreFromTempTable
 create table messagebrowsinghistory (
   RecordNumber decimal(6,0) unsigned not null comment 'ƒŒƒR�[ƒh”Ô�†'
   , BranchNumber decimal(3,0) unsigned not null comment 'ƒŒƒR�[ƒhŽ}”Ô'
@@ -1553,8 +1707,10 @@
 ) comment 'ŒfŽ¦”Âƒ�ƒbƒZ�[ƒW‰{———š—ð' ;
 
 -- ŒŽƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists monthmaster cascade;
 
+--* RestoreFromTempTable
 create table monthmaster (
   month smallint(6) not null comment 'ŒŽ'
   , constraint monthmaster_PKC primary key (month)
@@ -1561,8 +1717,10 @@
 ) comment 'ŒŽƒ}ƒXƒ^' ;
 
 -- ”­’�ŽÒƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists orderersmaster cascade;
 
+--* RestoreFromTempTable
 create table orderersmaster (
   OrderCotegory decimal(5,0) unsigned not null comment '”­’�ŽÒ‹æ•ª'
   , OrderersCode decimal(5,0) unsigned not null comment '”­’�ŽÒƒR�[ƒh'
@@ -1589,8 +1747,10 @@
 ) comment '”­’�ŽÒƒ}ƒXƒ^' ;
 
 -- Žó’�‹àŠzƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists orderspricedata cascade;
 
+--* RestoreFromTempTable
 create table orderspricedata (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , ChangeNo decimal(3,0) unsigned not null comment '•Ï�X”Ô�†'
@@ -1608,8 +1768,10 @@
 ) comment 'Žó’�‹àŠzƒf�[ƒ^' ;
 
 -- Žx•¥�³”F�î•ñƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists paymentapprovalinfo cascade;
 
+--* RestoreFromTempTable
 create table paymentapprovalinfo (
   COMPANYCODE decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
   , TARGETDATE decimal(6,0) default '0' not null comment '‘Î�Û”NŒŽ'
@@ -1626,8 +1788,10 @@
 ) comment 'Žx•¥�³”F�î•ñƒf�[ƒ^' ;
 
 -- Žx•¥–¾�×ƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists paymentdatadetail cascade;
 
+--* RestoreFromTempTable
 create table paymentdatadetail (
   COMPANYCODE decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
   , TARGETDATE decimal(6,0) default '0' not null comment '‘Î�Û”NŒŽ'
@@ -1657,8 +1821,10 @@
   on paymentdatadetail(APPROVALPERSONCODE);
 
 -- �HŽ–ŠúŒÀ‰ñ”ðƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists periodavoidance cascade;
 
+--* RestoreFromTempTable
 create table periodavoidance (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , ConstructionStatusFlg decimal(2,0) not null comment '�HŽ–�ó‘Ôƒtƒ‰ƒO'
@@ -1678,8 +1844,10 @@
   on periodavoidance(FieldNo);
 
 -- ’S“–ŽÒ�³”Fƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists personapproval cascade;
 
+--* RestoreFromTempTable
 create table personapproval (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
   , ApprovalCode decimal(3,0) unsigned not null comment '�³”F‹@”\”Ô�†'
@@ -1697,8 +1865,10 @@
 ) comment '’S“–ŽÒ�³”Fƒf�[ƒ^' ;
 
 -- ’S“–ŽÒ�³”FƒRƒ�ƒ“ƒgƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists personapprovalcomment cascade;
 
+--* RestoreFromTempTable
 create table personapprovalcomment (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
   , ApprovalCode decimal(3,0) unsigned not null comment '�³”F‹@”\”Ô�†'
@@ -1713,8 +1883,10 @@
 ) comment '’S“–ŽÒ�³”FƒRƒ�ƒ“ƒgƒf�[ƒ^' ;
 
 -- ’S“–ŽÒ‘Î�Û•”��ƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists persondepartmentmaster cascade;
 
+--* RestoreFromTempTable
 create table persondepartmentmaster (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
   , DepartmentCode decimal(5,0) unsigned not null comment '•”��ƒR�[ƒh'
@@ -1731,8 +1903,10 @@
   on persondepartmentmaster(DepartmentCode);
 
 -- ’S“–ŽÒƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists personinchargemaster cascade;
 
+--* RestoreFromTempTable
 create table personinchargemaster (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
   , DisplayOrder decimal(8,0) unsigned not null comment '•\Ž¦�‡'
@@ -1766,8 +1940,10 @@
   on personinchargemaster(DepartmentCode);
 
 -- ’S“–ŽÒ‹‹—^ƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists personsalarymaster cascade;
 
+--* RestoreFromTempTable
 create table personsalarymaster (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
   , StartDate date not null comment 'Žg—pŠJŽn”NŒŽ“ú'
@@ -1788,8 +1964,10 @@
   on personsalarymaster(MonthlySalary);
 
 -- ŽwŽ¦Ž–�€ƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists pointingoutcomment cascade;
 
+--* RestoreFromTempTable
 create table pointingoutcomment (
   ConstructionCode decimal(10,0) not null comment '�HŽ–ƒR�[ƒh'
   , ProcessNo smallint(6) not null comment '�ˆ—�”Ô�†�i‰æ–Ê”Ô�†�j'
@@ -1810,8 +1988,10 @@
 ) comment 'ŽwŽ¦Ž–�€ƒf�[ƒ^' ;
 
 -- ”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists proceedingsdata cascade;
 
+--* RestoreFromTempTable
 create table proceedingsdata (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , ProceedingsDataDate date not null comment '‹cŽ–˜^�ì�¬“ú'
@@ -1826,8 +2006,10 @@
 ) comment '”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^' ;
 
 -- ”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^�i�o�ÈŽÒ�j
+--* BackupToTempTable
 drop table if exists proceedingsdataattend cascade;
 
+--* RestoreFromTempTable
 create table proceedingsdataattend (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , ProceedingsDataDate date not null comment '‹cŽ–˜^�ì�¬“ú'
@@ -1841,8 +2023,10 @@
 ) comment '”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^�i�o�ÈŽÒ�j' ;
 
 -- ”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^�i–¾�×�j
+--* BackupToTempTable
 drop table if exists proceedingsdatadetail cascade;
 
+--* RestoreFromTempTable
 create table proceedingsdatadetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , ProceedingsDataDate date not null comment '‹cŽ–˜^�ì�¬“ú'
@@ -1857,8 +2041,10 @@
 ) comment '”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^�i–¾�×�j' ;
 
 -- �³”Fƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists processapproval cascade;
 
+--* RestoreFromTempTable
 create table processapproval (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , ApprovalCode decimal(3,0) unsigned not null comment '�³”F‹@”\”Ô�†'
@@ -1875,8 +2061,10 @@
 ) comment '�³”Fƒf�[ƒ^' ;
 
 -- �³”FƒRƒ�ƒ“ƒgƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists processapprovalcomment cascade;
 
+--* RestoreFromTempTable
 create table processapprovalcomment (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , ApprovalCode decimal(3,0) unsigned not null comment '�³”F‹@”\”Ô�†'
@@ -1890,8 +2078,10 @@
 ) comment '�³”FƒRƒ�ƒ“ƒgƒf�[ƒ^' ;
 
 -- �³”F–¾�×ƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists processapprovaldetail cascade;
 
+--* RestoreFromTempTable
 create table processapprovaldetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , ApprovalCode decimal(3,0) unsigned not null comment '�³”F‹@”\”Ô�†'
@@ -1904,8 +2094,10 @@
 ) comment '�³”F–¾�×ƒf�[ƒ^' ;
 
 -- ‹N“®‘Î�Ûƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists processexcutemaster cascade;
 
+--* RestoreFromTempTable
 create table processexcutemaster (
   SecCode decimal(2,0) unsigned not null comment '•ÛŒì‹æ•ª”Ô�†'
   , ExecCode decimal(4,0) unsigned not null comment '‹N“®�ˆ—�”Ô�†'
@@ -1922,8 +2114,10 @@
   on processexcutemaster(ExecCode);
 
 -- ’�•¶�‘ƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists purchaseorder cascade;
 
+--* RestoreFromTempTable
 create table purchaseorder (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , SeqNo decimal(3,0) unsigned not null comment '’�•¶�‘Ž}”Ô'
@@ -1958,8 +2152,10 @@
 ) comment '’�•¶�‘ƒf�[ƒ^' ;
 
 -- ’�•¶�‘“ú•tƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists purchaseorderdate cascade;
 
+--* RestoreFromTempTable
 create table purchaseorderdate (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , SeqNo decimal(3,0) unsigned not null comment '’�•¶�‘Ž}”Ô'
@@ -1973,8 +2169,10 @@
 ) comment '’�•¶�‘“ú•tƒf�[ƒ^' ;
 
 -- ’�•¶�‘–¾�×ƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists purchaseorderdetail cascade;
 
+--* RestoreFromTempTable
 create table purchaseorderdetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , SeqNo decimal(3,0) unsigned not null comment '’�•¶�‘Ž}”Ô'
@@ -2001,8 +2199,10 @@
   on purchaseorderdetail(SourceCode);
 
 -- ƒŒƒR�[ƒh”Ô�†ŠÇ—�
+--* BackupToTempTable
 drop table if exists recordkey cascade;
 
+--* RestoreFromTempTable
 create table recordkey (
   KeyNo decimal(2,0) unsigned not null comment 'ƒL�[ƒR�[ƒh'
   , RecordNumber decimal(6,0) unsigned not null comment 'ƒŒƒR�[ƒh”Ô�†'
@@ -2011,9 +2211,40 @@
   , constraint recordkey_PKC primary key (KeyNo,RecordNumber)
 ) comment 'ƒŒƒR�[ƒh”Ô�†ŠÇ—�' ;
 
+-- �¿‹��‘�í�œƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists reminvoicedata cascade;
+
+--* RestoreFromTempTable
+create table reminvoicedata (
+  InvoiceNo decimal(9,0) not null comment '�¿‹��‘No'
+  , RemPerson decimal(8,0) not null comment '�í�œ’S“–ŽÒƒR�[ƒh'
+  , RemDate date not null comment '�í�œ“ú•t'
+  , RemComment varchar(300) comment '�í�œ—�—R'
+  , EntryDate datetime not null comment '“o˜^”NŒŽ“ú'
+  , UpdateDate datetime not null comment '�X�V”NŒŽ“ú'
+  , constraint reminvoicedata_PKC primary key (InvoiceNo)
+) comment '�¿‹��‘�í�œƒf�[ƒ^' ;
+
+-- �¿‹��‘�í�œ–¾�×ƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists reminvoicedatadetail cascade;
+
+--* RestoreFromTempTable
+create table reminvoicedatadetail (
+  InvoiceNo decimal(9,0) not null comment '�¿‹��‘No'
+  , SeqNo smallint(5) unsigned not null comment '˜A”Ô'
+  , RequestNo decimal(9,0) not null comment '�¿‹�No'
+  , EntryDate datetime not null comment '“o˜^”NŒŽ“ú'
+  , UpdateDate datetime not null comment '�X�V”NŒŽ“ú'
+  , constraint reminvoicedatadetail_PKC primary key (InvoiceNo,SeqNo)
+) comment '�¿‹��‘�í�œ–¾�×ƒf�[ƒ^' ;
+
 -- �¿‹�ƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists requestdata cascade;
 
+--* RestoreFromTempTable
 create table requestdata (
   REQUESTNO decimal(9,0) not null comment '�¿‹�No'
   , MAINCONSTRUCTIONCODE decimal(10,0) not null comment '–{�HŽ–”Ô�†'
@@ -2037,8 +2268,10 @@
 ) comment '�¿‹�ƒf�[ƒ^' ;
 
 -- �¿‹�ƒf�[ƒ^–¾�×
+--* BackupToTempTable
 drop table if exists requestdatadetail cascade;
 
+--* RestoreFromTempTable
 create table requestdatadetail (
   REQUESTNO decimal(9,0) not null comment '�¿‹�No'
   , MAINCONSTRUCTIONCODE decimal(10,0) not null comment '–{�HŽ–”Ô�†'
@@ -2052,8 +2285,10 @@
 ) comment '�¿‹�ƒf�[ƒ^–¾�×' ;
 
 -- �¿‹�ƒwƒbƒ_
+--* BackupToTempTable
 drop table if exists requesthead cascade;
 
+--* RestoreFromTempTable
 create table requesthead (
   REQUESTNO decimal(9,0) not null comment '�¿‹�No'
   , REQCONSTRUCTIONCODE decimal(10,0) not null comment '�¿‹��HŽ–”Ô�†'
@@ -2078,8 +2313,10 @@
 alter table requesthead add unique REQCONSTRUCTIONCODE (REQCONSTRUCTIONCODE,ORDERNO) ;
 
 -- �¿‹��‘“ú•tƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists requestorderdate cascade;
 
+--* RestoreFromTempTable
 create table requestorderdate (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , InvoiceNo decimal(9,0) not null comment '�¿‹��‘No'
@@ -2090,8 +2327,10 @@
 ) comment '�¿‹��‘“ú•tƒf�[ƒ^' ;
 
 -- ”„�ãƒOƒ‰ƒtƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists salesgraphdata cascade;
 
+--* RestoreFromTempTable
 create table salesgraphdata (
   GraphDataCode decimal(8,0) not null comment 'ƒOƒ‰ƒtƒf�[ƒ^ƒR�[ƒh'
   , ConstructionPeriod decimal(4,0) unsigned not null comment 'Ž–‹ÆŠú'
@@ -2114,8 +2353,10 @@
   on salesgraphdata(ConstructionPeriod);
 
 -- •ÛŒì‹æ•ªƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists securitymaster cascade;
 
+--* RestoreFromTempTable
 create table securitymaster (
   SecCode decimal(2,0) unsigned not null comment '•ÛŒì‹æ•ª”Ô�†'
   , DisplayOrder decimal(2,0) not null comment '•\Ž¦�‡'
@@ -2139,8 +2380,10 @@
   on securitymaster(SecRange);
 
 -- ˆÀ‘Sƒpƒgƒ��[ƒ‹ƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists sfpdata cascade;
 
+--* RestoreFromTempTable
 create table sfpdata (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , DataCount decimal(2,0) unsigned not null comment 'ƒpƒgƒ��[ƒ‹‰ñ�”'
@@ -2157,8 +2400,10 @@
   on sfpdata(RequestDate);
 
 -- ˆÀ‘Sƒpƒgƒ��[ƒ‹–¾�×ƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists sfpdatadetail cascade;
 
+--* RestoreFromTempTable
 create table sfpdatadetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , DataCount decimal(2,0) unsigned not null comment 'ƒpƒgƒ��[ƒ‹‰ñ�”'
@@ -2170,8 +2415,10 @@
 ) comment 'ˆÀ‘Sƒpƒgƒ��[ƒ‹–¾�×ƒf�[ƒ^' ;
 
 -- ‹¦—Í‹ÆŽÒŽ{�H�HŽí“o˜^�\�¿ƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists subconstrjobitemregist cascade;
 
+--* RestoreFromTempTable
 create table subconstrjobitemregist (
   PersonCode decimal(8,0) unsigned not null comment '�\�¿ŽÒ”Ô�†'
   , CreateDate date not null comment '�ì�¬“ú'
@@ -2184,8 +2431,10 @@
 ) comment '‹¦—Í‹ÆŽÒŽ{�H�HŽí“o˜^�\�¿ƒf�[ƒ^' ;
 
 -- ‹¦—Í‹ÆŽÒ�EŽíƒŠƒ“ƒN“o˜^�\�¿ƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists subconstrjoblinkregist cascade;
 
+--* RestoreFromTempTable
 create table subconstrjoblinkregist (
   PersonCode decimal(8,0) unsigned not null comment '�\�¿ŽÒ”Ô�†'
   , CreateDate date not null comment '�ì�¬“ú'
@@ -2198,8 +2447,10 @@
 ) comment '‹¦—Í‹ÆŽÒ�EŽíƒŠƒ“ƒN“o˜^�\�¿ƒf�[ƒ^' ;
 
 -- ‹¦—Í‹ÆŽÒ“o˜^�\�¿ƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists subconstrregist cascade;
 
+--* RestoreFromTempTable
 create table subconstrregist (
   PersonCode decimal(8,0) unsigned not null comment '�\�¿ŽÒ”Ô�†'
   , CreateDate date not null comment '�ì�¬“ú'
@@ -2233,8 +2484,10 @@
 ) comment '‹¦—Í‹ÆŽÒ“o˜^�\�¿ƒf�[ƒ^' ;
 
 -- ‹¦—Í‰ïŽÐ�HŽíƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists subcontractoritemmaster cascade;
 
+--* RestoreFromTempTable
 create table subcontractoritemmaster (
   ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
   , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
@@ -2246,8 +2499,10 @@
 ) comment '‹¦—Í‰ïŽÐ�HŽíƒ}ƒXƒ^' ;
 
 -- ‹¦—Í‰ïŽÐ�EŽíƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists subcontractorjobcategory cascade;
 
+--* RestoreFromTempTable
 create table subcontractorjobcategory (
   JobCategoryCode decimal(5,0) not null comment '�EŽíƒL�['
   , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
@@ -2259,8 +2514,10 @@
 ) comment '‹¦—Í‰ïŽÐ�EŽíƒ}ƒXƒ^' ;
 
 -- ‹¦—Í‰ïŽÐŽ{�H�HŽíƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists subcontractorjobitem cascade;
 
+--* RestoreFromTempTable
 create table subcontractorjobitem (
   CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
   , ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
@@ -2277,8 +2534,10 @@
   on subcontractorjobitem(ItemCode);
 
 -- ‹¦—Í‰ïŽÐ�EŽíƒŠƒ“ƒNƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists subcontractorjoblink cascade;
 
+--* RestoreFromTempTable
 create table subcontractorjoblink (
   CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
   , JobCategoryCode decimal(5,0) not null comment '�EŽíƒL�['
@@ -2295,8 +2554,10 @@
   on subcontractorjoblink(JobCategoryCode);
 
 -- ‹¦—Í‰ïŽÐƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists subcontractormaster cascade;
 
+--* RestoreFromTempTable
 create table subcontractormaster (
   CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
   , DisplayOrder decimal(8,0) unsigned not null comment '•\Ž¦�‡'
@@ -2328,8 +2589,10 @@
   on subcontractormaster(JapaneseSyllabary);
 
 -- Žd“ü�æƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists suppliersmaster cascade;
 
+--* RestoreFromTempTable
 create table suppliersmaster (
   SuppliersCode decimal(5,0) unsigned not null comment 'Žd“ü�æƒR�[ƒh'
   , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
@@ -2349,8 +2612,10 @@
 ) comment 'Žd“ü�æƒ}ƒXƒ^' ;
 
 -- ƒVƒXƒeƒ€‹N“®Šm”Fƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists systemexecute cascade;
 
+--* RestoreFromTempTable
 create table systemexecute (
   PrimaryCode tinyint(4) not null comment 'ƒL�[�€–Ú'
   , TargetDate date not null comment '‹N“®“ú•t'
@@ -2362,8 +2627,10 @@
 ) comment 'ƒVƒXƒeƒ€‹N“®Šm”Fƒf�[ƒ^' ;
 
 -- ŠÇ—�ƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists systemmaster cascade;
 
+--* RestoreFromTempTable
 create table systemmaster (
   SystemCode decimal(3,0) unsigned not null comment '‰ïŽÐƒR�[ƒh'
   , CompanyName1 varchar(60) not null comment '‰ïŽÐ–¼‚P'
@@ -2399,8 +2666,10 @@
 ) comment 'ŠÇ—�ƒ}ƒXƒ^' ;
 
 -- ŠúŒÀƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists termmaster cascade;
 
+--* RestoreFromTempTable
 create table termmaster (
   ConstructionStatusFlg decimal(2,0) not null comment '�HŽ–�ó‘Ôƒtƒ‰ƒO'
   , FieldNo decimal(2,0) not null comment 'ƒ`ƒFƒbƒN‘Î�ÛƒtƒB�[ƒ‹ƒh”Ô�†'
@@ -2421,8 +2690,10 @@
   on termmaster(DisplayOrder);
 
 -- �o‹ÎŒð’Ê”ïƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists tranceportdailydata cascade;
 
+--* RestoreFromTempTable
 create table tranceportdailydata (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
   , AttendanceDate date not null comment '“ú•ñ�ì�¬“ú'
@@ -2443,8 +2714,10 @@
   on tranceportdailydata(AttendanceDate);
 
 -- �HŽ–Ží•ÊŒo”ï—¦ƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists typeexpensesmaster cascade;
 
+--* RestoreFromTempTable
 create table typeexpensesmaster (
   TypeCode decimal(5,0) unsigned not null comment '�HŽ–Ží•ÊƒR�[ƒh'
   , ExpensesPeriod smallint(6) not null comment 'Ž–‹ÆŠú'
@@ -2457,8 +2730,10 @@
 ) comment '�HŽ–Ží•ÊŒo”ï—¦ƒ}ƒXƒ^' ;
 
 -- ’PˆÊƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists unitmaster cascade;
 
+--* RestoreFromTempTable
 create table unitmaster (
   UnitKey decimal(5,0) unsigned not null comment '’PˆÊƒL�['
   , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
@@ -2472,8 +2747,10 @@
   on unitmaster(DisplayOrder);
 
 -- ŽÔ—¼ƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists vehiclemaster cascade;
 
+--* RestoreFromTempTable
 create table vehiclemaster (
   VehicleCode decimal(5,0) unsigned not null comment 'ŽÔ—¼ƒR�[ƒh'
   , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
@@ -2501,8 +2778,10 @@
 ) comment 'ŽÔ—¼ƒ}ƒXƒ^' ;
 
 -- ŽÔ—¼‹L˜^ƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists vehiclerecorddata cascade;
 
+--* RestoreFromTempTable
 create table vehiclerecorddata (
   VehicleCode decimal(5,0) unsigned not null comment 'ŽÔ—¼ƒR�[ƒh'
   , DivisionCode decimal(2,0) unsigned not null comment 'ƒf�[ƒ^‹æ•ª'
@@ -2517,8 +2796,10 @@
 ) comment 'ŽÔ—¼‹L˜^ƒf�[ƒ^' ;
 
 -- ŽÔ—¼—\–ñƒf�[ƒ^
+--* BackupToTempTable
 drop table if exists vehiclescheduledata cascade;
 
+--* RestoreFromTempTable
 create table vehiclescheduledata (
   TargetDate date not null comment '‘Î�Û“ú'
   , VehicleCode decimal(5,0) unsigned not null comment 'ŽÔ—¼ƒR�[ƒh'
@@ -2542,8 +2823,10 @@
   on vehiclescheduledata(TargetDay);
 
 -- ”Nƒ}ƒXƒ^
+--* BackupToTempTable
 drop table if exists yearmaster cascade;
 
+--* RestoreFromTempTable
 create table yearmaster (
   years smallint(6) not null comment '”N'
   , constraint yearmaster_PKC primary key (years)
