text: ALTER TABLE B_TERRAFORM_IF_INFO ADD COLUMN NULL_DATA_HANDLING_FLG INT AFTER TERRAFORM_TAILLOG_LINES;
  ALTER TABLE B_TERRAFORM_IF_INFO ADD COLUMN ACCESS_AUTH TEXT AFTER DISP_SEQ;
  
  ALTER TABLE B_TERRAFORM_IF_INFO_JNL ADD COLUMN NULL_DATA_HANDLING_FLG INT AFTER TERRAFORM_TAILLOG_LINES;
  ALTER TABLE B_TERRAFORM_IF_INFO_JNL ADD COLUMN ACCESS_AUTH TEXT AFTER DISP_SEQ;
  
  -- ----更新系テーブル作成----
  -- HCLフラグ
  CREATE TABLE B_TERRAFORM_HCL_FLAG
  (
  HCL_FLAG                          INT                              ,
  HCL_FLAG_SELECT                   VARCHAR (32)                     ,
  DISP_SEQ                          INT                              , -- 表示順序
  ACCESS_AUTH                       TEXT                             ,
  NOTE                              VARCHAR (4000)                   , -- 備考
  DISUSE_FLAG                       VARCHAR (1)                      , -- 廃止フラグ
  LAST_UPDATE_TIMESTAMP             DATETIME(6)                      , -- 最終更新日時
  LAST_UPDATE_USER                  INT                              , -- 最終更新ユーザ
  PRIMARY KEY (HCL_FLAG)
  )ENGINE = InnoDB, CHARSET = utf8, COLLATE = utf8_bin, ROW_FORMAT=COMPRESSED ,KEY_BLOCK_SIZE=8;
  -- 更新系テーブル作成----
  
  -- ----履歴系テーブル作成----
  -- HCLフラグ(履歴)
  CREATE TABLE B_TERRAFORM_HCL_FLAG_JNL
  (
  JOURNAL_SEQ_NO                    INT                              , -- 履歴用シーケンス
  JOURNAL_REG_DATETIME              DATETIME(6)                      , -- 履歴用変更日時
  JOURNAL_ACTION_CLASS              VARCHAR (8)                      , -- 履歴用変更種別
  HCL_FLAG                          INT                              ,
  HCL_FLAG_SELECT                   VARCHAR (32)                     ,
  DISP_SEQ                          INT                              , -- 表示順序
  ACCESS_AUTH                       TEXT                             ,
  NOTE                              VARCHAR (4000)                   , -- 備考
  DISUSE_FLAG                       VARCHAR (1)                      , -- 廃止フラグ
  LAST_UPDATE_TIMESTAMP             DATETIME(6)                      , -- 最終更新日時
  LAST_UPDATE_USER                  INT                              , -- 最終更新ユーザ
  PRIMARY KEY(JOURNAL_SEQ_NO)
  )ENGINE = InnoDB, CHARSET = utf8, COLLATE = utf8_bin, ROW_FORMAT=COMPRESSED ,KEY_BLOCK_SIZE=8;
  -- 履歴系テーブル作成----
  
  
  ALTER TABLE B_TERRAFORM_ORGANIZATIONS ADD COLUMN ACCESS_AUTH TEXT AFTER DISP_SEQ;
  
  ALTER TABLE B_TERRAFORM_ORGANIZATIONS_JNL ADD COLUMN ACCESS_AUTH TEXT AFTER DISP_SEQ;
  
  ALTER TABLE B_TERRAFORM_WORKSPACES DROP COLUMN APPLY_METHOD;
  ALTER TABLE B_TERRAFORM_WORKSPACES ADD COLUMN ACCESS_AUTH TEXT AFTER DISP_SEQ;
  
  ALTER TABLE B_TERRAFORM_WORKSPACES_JNL DROP COLUMN APPLY_METHOD;
  ALTER TABLE B_TERRAFORM_WORKSPACES_JNL ADD COLUMN ACCESS_AUTH TEXT AFTER DISP_SEQ;
  
  ALTER TABLE B_TERRAFORM_MODULE ADD COLUMN ACCESS_AUTH TEXT AFTER DISP_SEQ;
  
  ALTER TABLE B_TERRAFORM_MODULE_JNL ADD COLUMN ACCESS_AUTH TEXT AFTER DISP_SEQ;
  
  ALTER TABLE B_TERRAFORM_POLICY ADD COLUMN ACCESS_AUTH TEXT AFTER DISP_SEQ;
  
  ALTER TABLE B_TERRAFORM_POLICY_JNL ADD COLUMN ACCESS_AUTH TEXT AFTER DISP_SEQ;
  
  ALTER TABLE B_TERRAFORM_POLICY_SETS ADD COLUMN ACCESS_AUTH TEXT AFTER DISP_SEQ;
  
  ALTER TABLE B_TERRAFORM_POLICY_SETS_JNL ADD COLUMN ACCESS_AUTH TEXT AFTER DISP_SEQ;
  
  ALTER TABLE B_TERRAFORM_POLICYSET_POLICY_LINK ADD COLUMN ACCESS_AUTH TEXT AFTER DISP_SEQ;
  
  ALTER TABLE B_TERRAFORM_POLICYSET_POLICY_LINK_JNL ADD COLUMN ACCESS_AUTH TEXT AFTER DISP_SEQ;
  
  ALTER TABLE B_TERRAFORM_POLICYSET_WORKSPACE_LINK ADD COLUMN ACCESS_AUTH TEXT AFTER DISP_SEQ;
  
  ALTER TABLE B_TERRAFORM_POLICYSET_WORKSPACE_LINK_JNL ADD COLUMN ACCESS_AUTH TEXT AFTER DISP_SEQ;
  
  ALTER TABLE B_TERRAFORM_PATTERN_LINK ADD COLUMN ACCESS_AUTH TEXT AFTER DISP_SEQ;
  
  ALTER TABLE B_TERRAFORM_PATTERN_LINK_JNL ADD COLUMN ACCESS_AUTH TEXT AFTER DISP_SEQ;
  
  ALTER TABLE C_TERRAFORM_EXE_INS_MNG ADD COLUMN ACCESS_AUTH TEXT AFTER DISP_SEQ;
  
  ALTER TABLE C_TERRAFORM_EXE_INS_MNG_JNL ADD COLUMN ACCESS_AUTH TEXT AFTER DISP_SEQ;
  
  ALTER TABLE B_TERRAFORM_VARS_ASSIGN MODIFY COLUMN VARS_ENTRY TEXT;
  ALTER TABLE B_TERRAFORM_VARS_ASSIGN ADD COLUMN HCL_FLAG VARCHAR(1) AFTER VARS_ENTRY;
  ALTER TABLE B_TERRAFORM_VARS_ASSIGN ADD COLUMN ACCESS_AUTH TEXT AFTER DISP_SEQ;
  UPDATE B_TERRAFORM_VARS_ASSIGN SET HCL_FLAG='1';
  
  ALTER TABLE B_TERRAFORM_VARS_ASSIGN_JNL MODIFY COLUMN VARS_ENTRY TEXT;
  ALTER TABLE B_TERRAFORM_VARS_ASSIGN_JNL ADD COLUMN HCL_FLAG VARCHAR(1) AFTER VARS_ENTRY;
  ALTER TABLE B_TERRAFORM_VARS_ASSIGN_JNL ADD COLUMN ACCESS_AUTH TEXT AFTER DISP_SEQ;
  UPDATE B_TERRAFORM_VARS_ASSIGN_JNL SET HCL_FLAG='1';
  
  DROP TABLE B_TERRAFORM_VARS_SENSITIVE;
  
  DROP TABLE B_TERRAFORM_VARS_SENSITIVE_JNL;
  
  -- ----更新系テーブル作成
  --代入値自動登録設定
  CREATE TABLE B_TERRAFORM_VAL_ASSIGN (
  COLUMN_ID                         INT                     , -- 識別シーケンス
  MENU_ID                           INT                     , -- メニューID
  COLUMN_LIST_ID                    INT                     , -- CMDB処理対象メニューカラム一覧の識別シーケンス
  COL_TYPE                          INT                     , -- カラムタイプ　1/空白:Value型　2:Key-Value型　
  PATTERN_ID                        INT                     , -- 作業パターンID
  VAL_VARS_LINK_ID                  INT                     , -- Value値　作業パターン変数紐付
  KEY_VARS_LINK_ID                  INT                     , -- Key値　作業パターン変数紐付
  HCL_FLAG                          VARCHAR (1)             , -- HCL設定
  NULL_DATA_HANDLING_FLG            INT                     , -- Null値の連携
  DISP_SEQ                          INT                     , -- 表示順序
  ACCESS_AUTH                       TEXT                    ,
  NOTE                              VARCHAR (4000)          , -- 備考
  DISUSE_FLAG                       VARCHAR (1)             , -- 廃止フラグ
  LAST_UPDATE_TIMESTAMP             DATETIME(6)             , -- 最終更新日時
  LAST_UPDATE_USER                  INT                     , -- 最終更新ユーザ
  PRIMARY KEY(COLUMN_ID)
  )ENGINE = InnoDB, CHARSET = utf8, COLLATE = utf8_bin, ROW_FORMAT=COMPRESSED ,KEY_BLOCK_SIZE=8;
  -- 更新系テーブル作成----
  
  -- ----履歴系テーブル作成
  --代入値自動登録設定(履歴)
  CREATE TABLE B_TERRAFORM_VAL_ASSIGN_JNL
  (
  JOURNAL_SEQ_NO                    INT                     , -- 履歴用シーケンス
  JOURNAL_REG_DATETIME              DATETIME(6)             , -- 履歴用変更日時
  JOURNAL_ACTION_CLASS              VARCHAR (8)             , -- 履歴用変更種別
  COLUMN_ID                         INT                     , -- 識別シーケンス
  MENU_ID                           INT                     , -- メニューID
  COLUMN_LIST_ID                    INT                     , -- CMDB処理対象メニューカラム一覧の識別シーケンス
  COL_TYPE                          INT                     , -- カラムタイプ　1/空白:Value型　2:Key-Value型　
  PATTERN_ID                        INT                     , -- 作業パターンID
  VAL_VARS_LINK_ID                  INT                     , -- Value値　作業パターン変数紐付
  KEY_VARS_LINK_ID                  INT                     , -- Key値　作業パターン変数紐付
  HCL_FLAG                          VARCHAR (1)             , -- HCL設定
  NULL_DATA_HANDLING_FLG            INT                     , -- Null値の連携
  DISP_SEQ                          INT                     , -- 表示順序
  ACCESS_AUTH                       TEXT                    ,
  NOTE                              VARCHAR (4000)          , -- 備考
  DISUSE_FLAG                       VARCHAR (1)             , -- 廃止フラグ
  LAST_UPDATE_TIMESTAMP             DATETIME(6)             , -- 最終更新日時
  LAST_UPDATE_USER                  INT                     , -- 最終更新ユーザ
  PRIMARY KEY(JOURNAL_SEQ_NO)
  )ENGINE = InnoDB, CHARSET = utf8, COLLATE = utf8_bin, ROW_FORMAT=COMPRESSED ,KEY_BLOCK_SIZE=8;
  -- 履歴系テーブル作成----
  
  ALTER TABLE B_TERRAFORM_MODULE_VARS_LINK ADD COLUMN ACCESS_AUTH TEXT AFTER DISP_SEQ;
  
  ALTER TABLE B_TERRAFORM_MODULE_VARS_LINK_JNL ADD COLUMN ACCESS_AUTH TEXT AFTER DISP_SEQ;
  
  DROP TABLE B_TERRAFORM_WORKSPACE_APPLY_METHOD;
  
  DROP TABLE B_TERRAFORM_WORKSPACE_APPLY_METHOD_JNL;
  
  CREATE OR REPLACE VIEW D_TERRAFORM_IF_INFO AS 
  SELECT * 
  FROM B_TERRAFORM_IF_INFO;
  
  CREATE OR REPLACE VIEW D_TERRAFORM_IF_INFO_JNL AS 
  SELECT * 
  FROM B_TERRAFORM_IF_INFO_JNL;
  
  -- ステータス VIEW
  CREATE OR REPLACE VIEW D_TERRAFORM_INS_STATUS AS 
  SELECT * 
  FROM B_TERRAFORM_STATUS;
  
  CREATE OR REPLACE VIEW D_TERRAFORM_INS_STATUS_JNL AS 
  SELECT * 
  FROM B_TERRAFORM_STATUS_JNL;
  
  --実行モード情報 VIEW
  CREATE OR REPLACE VIEW D_TERRAFORM_INS_RUN_MODE AS 
  SELECT * 
  FROM B_TERRAFORM_RUN_MODE;
  
  CREATE OR REPLACE VIEW D_TERRAFORM_INS_RUN_MODE_JNL AS 
  SELECT * 
  FROM B_TERRAFORM_RUN_MODE_JNL;
  
  CREATE OR REPLACE VIEW D_TERRAFORM_ORGANIZATION_WORKSPACE_LINK AS
  SELECT
          TAB_B.ORGANIZATION_ID         ,
          TAB_B.ORGANIZATION_NAME ORGANIZATION_NAME       ,
          TAB_A.WORKSPACE_ID            ,
          TAB_A.WORKSPACE_NAME WORKSPACE_NAME          ,
          CONCAT(ORGANIZATION_NAME,':',WORKSPACE_NAME) ORGANIZATION_WORKSPACE,
          TAB_A.DISP_SEQ             ,
          TAB_A.ACCESS_AUTH          ,
          TAB_A.NOTE                 ,
          TAB_A.DISUSE_FLAG          ,
          TAB_A.LAST_UPDATE_TIMESTAMP,
          TAB_A.LAST_UPDATE_USER
  FROM B_TERRAFORM_WORKSPACES TAB_A
  LEFT JOIN B_TERRAFORM_ORGANIZATIONS TAB_B ON ( TAB_A.ORGANIZATION_ID = TAB_B.ORGANIZATION_ID )
  ;
  
  CREATE OR REPLACE VIEW D_TERRAFORM_ORGANIZATION_WORKSPACE_LINK_JNL AS
  SELECT 
          TAB_A.JOURNAL_SEQ_NO                ,
          TAB_A.JOURNAL_REG_DATETIME          ,
          TAB_A.JOURNAL_ACTION_CLASS          ,
          TAB_B.ORGANIZATION_ID         ,
          TAB_B.ORGANIZATION_NAME ORGANIZATION_NAME       ,
          TAB_A.WORKSPACE_ID            ,
          TAB_A.WORKSPACE_NAME WORKSPACE_NAME          ,
          CONCAT(ORGANIZATION_NAME,':',WORKSPACE_NAME) ORGANIZATION_WORKSPACE,
          TAB_A.DISP_SEQ             ,
          TAB_A.ACCESS_AUTH          ,
          TAB_A.NOTE                 ,
          TAB_A.DISUSE_FLAG          ,
          TAB_A.LAST_UPDATE_TIMESTAMP,
          TAB_A.LAST_UPDATE_USER
  FROM B_TERRAFORM_WORKSPACES_JNL TAB_A
  LEFT JOIN B_TERRAFORM_ORGANIZATIONS_JNL TAB_B ON ( TAB_A.ORGANIZATION_ID = TAB_B.ORGANIZATION_ID )
  ;
  
  CREATE OR REPLACE VIEW E_TERRAFORM_PATTERN AS 
  SELECT 
          PATTERN_ID                    ,
          PATTERN_NAME                  ,
          CONCAT(PATTERN_ID,':',PATTERN_NAME) PATTERN,
          ITA_EXT_STM_ID                ,
          TERRAFORM_WORKSPACE_ID        ,
          TIME_LIMIT                    ,
          DISP_SEQ                      ,
          ACCESS_AUTH                   ,
          NOTE                          ,
          DISUSE_FLAG                   ,
          LAST_UPDATE_TIMESTAMP         ,
          LAST_UPDATE_USER
  FROM C_PATTERN_PER_ORCH TAB_A
  WHERE TAB_A.ITA_EXT_STM_ID = 10;
  
  CREATE OR REPLACE VIEW E_TERRAFORM_PATTERN_JNL AS 
  SELECT 
          JOURNAL_SEQ_NO                ,
          JOURNAL_REG_DATETIME          ,
          JOURNAL_ACTION_CLASS          ,
          PATTERN_ID                    ,
          PATTERN_NAME                  ,
          CONCAT(PATTERN_ID,':',PATTERN_NAME) PATTERN,
          ITA_EXT_STM_ID                ,
          TERRAFORM_WORKSPACE_ID        ,
          TIME_LIMIT                    ,
          DISP_SEQ                      ,
          ACCESS_AUTH                   ,
          NOTE                          ,
          DISUSE_FLAG                   ,
          LAST_UPDATE_TIMESTAMP         ,
          LAST_UPDATE_USER
  FROM C_PATTERN_PER_ORCH_JNL TAB_A
  WHERE TAB_A.ITA_EXT_STM_ID = 10;
  
  CREATE OR REPLACE VIEW E_TERRAFORM_EXE_INS_MNG AS
  SELECT 
           TAB_A.EXECUTION_NO              ,
           TAB_A.STATUS_ID                 ,
           TAB_C.STATUS_NAME               ,
           TAB_A.SYMPHONY_NAME             ,
           TAB_A.EXECUTION_USER            ,
           TAB_A.SYMPHONY_INSTANCE_NO      , -- Symphonyインスタンス番号
           TAB_A.PATTERN_ID                ,
           TAB_A.I_PATTERN_NAME            ,
           TAB_A.I_TIME_LIMIT              ,
           TAB_A.I_TERRAFORM_RUN_ID        ,
           TAB_A.I_TERRAFORM_WORKSPACE_ID  ,
           TAB_A.OPERATION_NO_UAPK         ,
           TAB_A.I_OPERATION_NAME          ,
           TAB_A.I_OPERATION_NO_IDBH       ,
           TAB_A.CONDUCTOR_NAME            ,
           TAB_A.CONDUCTOR_INSTANCE_NO     ,
           TAB_A.TIME_BOOK                 ,
           TAB_A.TIME_START                ,
           TAB_A.TIME_END                  ,
           TAB_A.FILE_INPUT                ,
           TAB_A.FILE_RESULT               ,
           TAB_A.RUN_MODE                  ,
           TAB_D.RUN_MODE_NAME             ,
           TAB_A.DISP_SEQ                  ,
           TAB_A.ACCESS_AUTH               ,
           TAB_A.NOTE                      ,
           TAB_A.DISUSE_FLAG               ,
           TAB_A.LAST_UPDATE_TIMESTAMP     ,
           TAB_A.LAST_UPDATE_USER
  FROM C_TERRAFORM_EXE_INS_MNG       TAB_A
  LEFT JOIN E_TERRAFORM_PATTERN      TAB_B ON ( TAB_B.PATTERN_ID = TAB_A.PATTERN_ID )
  LEFT JOIN D_TERRAFORM_INS_STATUS   TAB_C ON ( TAB_A.STATUS_ID = TAB_C.STATUS_ID )
  LEFT JOIN D_TERRAFORM_INS_RUN_MODE TAB_D ON ( TAB_A.RUN_MODE = TAB_D.RUN_MODE_ID )
  ;
  
  CREATE OR REPLACE VIEW E_TERRAFORM_EXE_INS_MNG_JNL AS 
  SELECT 
           TAB_A.JOURNAL_SEQ_NO            ,
           TAB_A.JOURNAL_REG_DATETIME      ,
           TAB_A.JOURNAL_ACTION_CLASS      ,
           TAB_A.EXECUTION_NO              ,
           TAB_A.STATUS_ID                 ,
           TAB_C.STATUS_NAME               ,
           TAB_A.SYMPHONY_NAME             ,
           TAB_A.EXECUTION_USER            ,
           TAB_A.SYMPHONY_INSTANCE_NO      , -- Symphonyインスタンス番号
           TAB_A.PATTERN_ID                ,
           TAB_A.I_PATTERN_NAME            ,
           TAB_A.I_TIME_LIMIT              ,
           TAB_A.I_TERRAFORM_RUN_ID        ,
           TAB_A.I_TERRAFORM_WORKSPACE_ID  ,
           TAB_A.OPERATION_NO_UAPK         ,
           TAB_A.I_OPERATION_NAME          ,
           TAB_A.I_OPERATION_NO_IDBH       ,
           TAB_A.CONDUCTOR_NAME            ,
           TAB_A.CONDUCTOR_INSTANCE_NO     ,
           TAB_A.TIME_BOOK                 ,
           TAB_A.TIME_START                ,
           TAB_A.TIME_END                  ,
           TAB_A.FILE_INPUT                ,
           TAB_A.FILE_RESULT               ,
           TAB_A.RUN_MODE                  ,
           TAB_D.RUN_MODE_NAME             ,
           TAB_A.DISP_SEQ                  ,
           TAB_A.ACCESS_AUTH               ,
           TAB_A.NOTE                      ,
           TAB_A.DISUSE_FLAG               ,
           TAB_A.LAST_UPDATE_TIMESTAMP     ,
           TAB_A.LAST_UPDATE_USER           
  FROM C_TERRAFORM_EXE_INS_MNG_JNL   TAB_A
  LEFT JOIN E_TERRAFORM_PATTERN      TAB_B ON ( TAB_B.PATTERN_ID = TAB_A.PATTERN_ID )
  LEFT JOIN D_TERRAFORM_INS_STATUS   TAB_C ON ( TAB_A.STATUS_ID = TAB_C.STATUS_ID )
  LEFT JOIN D_TERRAFORM_INS_RUN_MODE TAB_D ON ( TAB_A.RUN_MODE = TAB_D.RUN_MODE_ID )
  ;
  
  CREATE OR REPLACE VIEW D_TERRAFORM_VARS_ASSIGN AS
  SELECT
    TAB_A.*,
    TAB_A.MODULE_VARS_LINK_ID            REST_MODULE_VARS_LINK_ID
  FROM
    B_TERRAFORM_VARS_ASSIGN TAB_A
  ;
  
  CREATE OR REPLACE VIEW D_TERRAFORM_VARS_ASSIGN_JNL AS
  SELECT
    TAB_A.*,
    TAB_A.MODULE_VARS_LINK_ID            REST_MODULE_VARS_LINK_ID
  FROM
    B_TERRAFORM_VARS_ASSIGN_JNL TAB_A
  ;
  
  CREATE OR REPLACE VIEW D_TERRAFORM_VAL_ASSIGN AS 
  SELECT 
         TAB_A.COLUMN_ID                      , -- 識別シーケンス
         TAB_A.MENU_ID                        , -- メニューID
         TAB_A.COLUMN_LIST_ID                 , -- CMDB処理対象メニューカラム一覧の識別シーケンス
         TAB_A.COL_TYPE                       , -- カラムタイプ　1/空白:Value型　2:Key-Value型　
         TAB_A.PATTERN_ID                     , -- 作業パターンID
         TAB_A.VAL_VARS_LINK_ID               , -- Value値　作業パターン変数紐付
         TAB_A.KEY_VARS_LINK_ID               , -- Key値　作業パターン変数紐付
         TAB_A.HCL_FLAG                       , -- HCL設定
         TAB_A.NULL_DATA_HANDLING_FLG         , -- Null値の連携
         TAB_B.MENU_GROUP_ID                  ,
         TAB_C.MENU_GROUP_NAME                ,
         TAB_A.MENU_ID           MENU_ID_CLONE,
         TAB_B.MENU_NAME                      ,
         TAB_A.COLUMN_LIST_ID    REST_COLUMN_LIST_ID,      -- REST/EXCEL/CSV用　CMDB処理対象メニューグループ+メニュー+カラム一覧の識別シーケンス
         TAB_A.VAL_VARS_LINK_ID  REST_VAL_VARS_LINK_ID,    -- REST/EXCEL/CSV用　Value値　作業パターン+変数名(作業パターン変数紐付)
         TAB_A.KEY_VARS_LINK_ID  REST_KEY_VARS_LINK_ID,    -- REST/EXCEL/CSV用　Key値　作業パターン+変数名(作業パターン変数紐付)
         TAB_A.DISP_SEQ                       ,
         TAB_A.ACCESS_AUTH                    ,
         TAB_A.NOTE                           ,
         TAB_A.DISUSE_FLAG                    ,
         TAB_A.LAST_UPDATE_TIMESTAMP          ,
         TAB_A.LAST_UPDATE_USER 
  FROM B_TERRAFORM_VAL_ASSIGN TAB_A
  LEFT JOIN A_MENU_LIST TAB_B ON (TAB_A.MENU_ID = TAB_B.MENU_ID)
  LEFT JOIN A_MENU_GROUP_LIST TAB_C ON (TAB_B.MENU_GROUP_ID = TAB_C.MENU_GROUP_ID);
  
  CREATE OR REPLACE VIEW D_TERRAFORM_VAL_ASSIGN_JNL AS 
  SELECT TAB_A.JOURNAL_SEQ_NO                 ,
         TAB_A.JOURNAL_REG_DATETIME           ,
         TAB_A.JOURNAL_ACTION_CLASS           ,
         TAB_A.COLUMN_ID                      , -- 識別シーケンス
         TAB_A.MENU_ID                        , -- メニューID
         TAB_A.COLUMN_LIST_ID                 , -- CMDB処理対象メニューカラム一覧の識別シーケンス
         TAB_A.COL_TYPE                       , -- カラムタイプ　1/空白:Value型　2:Key-Value型　
         TAB_A.PATTERN_ID                     , -- 作業パターンID
         TAB_A.VAL_VARS_LINK_ID               , -- Value値　作業パターン変数紐付
         TAB_A.KEY_VARS_LINK_ID               , -- Key値　作業パターン変数紐付
         TAB_A.HCL_FLAG                       , -- HCL設定
         TAB_A.NULL_DATA_HANDLING_FLG         , -- Null値の連携
         TAB_B.MENU_GROUP_ID                  ,
         TAB_C.MENU_GROUP_NAME                ,
         TAB_A.MENU_ID           MENU_ID_CLONE,
         TAB_B.MENU_NAME                      ,
         TAB_A.COLUMN_LIST_ID    REST_COLUMN_LIST_ID,      -- REST/EXCEL/CSV用　CMDB処理対象メニューグループ+メニュー+カラム一覧の識別シーケンス
         TAB_A.VAL_VARS_LINK_ID  REST_VAL_VARS_LINK_ID,    -- REST/EXCEL/CSV用　Value値　作業パターン+変数名(作業パターン変数紐付)
         TAB_A.KEY_VARS_LINK_ID  REST_KEY_VARS_LINK_ID,    -- REST/EXCEL/CSV用　Key値　作業パターン+変数名(作業パターン変数紐付)
         TAB_A.DISP_SEQ                       ,
         TAB_A.ACCESS_AUTH                    ,
         TAB_A.NOTE                           ,
         TAB_A.DISUSE_FLAG                    ,
         TAB_A.LAST_UPDATE_TIMESTAMP          ,
         TAB_A.LAST_UPDATE_USER 
  FROM B_TERRAFORM_VAL_ASSIGN_JNL TAB_A
  LEFT JOIN A_MENU_LIST TAB_B ON (TAB_A.MENU_ID = TAB_B.MENU_ID)
  LEFT JOIN A_MENU_GROUP_LIST TAB_C ON (TAB_B.MENU_GROUP_ID = TAB_C.MENU_GROUP_ID);
  
  CREATE OR REPLACE VIEW D_TERRAFORM_PTN_VARS_LINK AS 
  SELECT 
          TAB_A.MODULE_VARS_LINK_ID      ,
          TAB_B.PATTERN_ID              ,
          TAB_C.PATTERN_NAME            ,
          TAB_A.VARS_NAME               ,
          CONCAT(TAB_A.MODULE_VARS_LINK_ID,':',TAB_A.VARS_NAME) VARS_LINK_PULLDOWN,
          TAB_A.DISP_SEQ                ,
          TAB_A.ACCESS_AUTH             ,
          TAB_A.NOTE                    ,
          TAB_A.DISUSE_FLAG             ,
          TAB_A.LAST_UPDATE_TIMESTAMP   ,
          TAB_A.LAST_UPDATE_USER
  FROM B_TERRAFORM_MODULE_VARS_LINK     TAB_A
  LEFT JOIN B_TERRAFORM_PATTERN_LINK  TAB_B ON ( TAB_A.MODULE_MATTER_ID = TAB_B.MODULE_MATTER_ID )
  LEFT JOIN E_TERRAFORM_PATTERN       TAB_C ON ( TAB_B.PATTERN_ID = TAB_C.PATTERN_ID )
  ;
  
  CREATE OR REPLACE VIEW D_TERRAFORM_PTN_VARS_LINK_JNL AS 
  SELECT
          JOURNAL_SEQ_NO                ,
          JOURNAL_REG_DATETIME          ,
          JOURNAL_ACTION_CLASS          ,
          TAB_A.MODULE_VARS_LINK_ID      ,
          TAB_B.PATTERN_ID              ,
          TAB_C.PATTERN_NAME            ,
          TAB_A.VARS_NAME               ,
          CONCAT(TAB_A.MODULE_VARS_LINK_ID,':',TAB_A.VARS_NAME) VARS_LINK_PULLDOWN,
          TAB_A.DISP_SEQ                ,
          TAB_A.ACCESS_AUTH             ,
          TAB_A.NOTE                    ,
          TAB_A.DISUSE_FLAG             ,
          TAB_A.LAST_UPDATE_TIMESTAMP   ,
          TAB_A.LAST_UPDATE_USER
  FROM B_TERRAFORM_MODULE_VARS_LINK_JNL     TAB_A
  LEFT JOIN B_TERRAFORM_PATTERN_LINK  TAB_B ON ( TAB_A.MODULE_MATTER_ID = TAB_B.MODULE_MATTER_ID )
  LEFT JOIN E_TERRAFORM_PATTERN       TAB_C ON ( TAB_B.PATTERN_ID = TAB_C.PATTERN_ID )
  ;
  
  CREATE OR REPLACE VIEW D_TERRAFORM_PTN_VARS_LINK_VFP AS 
  SELECT 
          TAB_A.MODULE_VARS_LINK_ID      ,
          TAB_B.PATTERN_ID              ,
          TAB_C.PATTERN_NAME            ,
          TAB_A.VARS_NAME               ,
          CONCAT(TAB_A.MODULE_VARS_LINK_ID,':',TAB_A.VARS_NAME) VARS_LINK_PULLDOWN,
          TAB_A.DISP_SEQ                ,
          TAB_A.ACCESS_AUTH             ,
          TAB_A.NOTE                    ,
          TAB_A.DISUSE_FLAG             ,
          TAB_A.LAST_UPDATE_TIMESTAMP   ,
          TAB_A.LAST_UPDATE_USER
  FROM B_TERRAFORM_MODULE_VARS_LINK     TAB_A
  LEFT JOIN B_TERRAFORM_PATTERN_LINK  TAB_B ON ( TAB_A.MODULE_MATTER_ID = TAB_B.MODULE_MATTER_ID )
  LEFT JOIN E_TERRAFORM_PATTERN       TAB_C ON ( TAB_B.PATTERN_ID = TAB_C.PATTERN_ID )
  WHERE TAB_A.DISUSE_FLAG = '0'
  AND TAB_B.DISUSE_FLAG = '0'
  AND TAB_C.DISUSE_FLAG = '0'
  ;
  
  CREATE OR REPLACE VIEW D_TERRAFORM_VARS_DATA AS
  SELECT 
           TAB_A.ASSIGN_ID                 ,
           TAB_A.OPERATION_NO_UAPK         ,
           TAB_A.PATTERN_ID                ,
           TAB_A.MODULE_VARS_LINK_ID       ,
           TAB_B.VARS_NAME                 ,
           TAB_A.VARS_ENTRY                ,
           TAB_A.HCL_FLAG                  ,
           TAB_A.SENSITIVE_FLAG            ,
           TAB_A.DISP_SEQ                  ,
           TAB_A.ACCESS_AUTH               ,
           TAB_A.NOTE                      ,
           TAB_A.DISUSE_FLAG               ,
           TAB_A.LAST_UPDATE_TIMESTAMP     ,
           TAB_A.LAST_UPDATE_USER
  FROM B_TERRAFORM_VARS_ASSIGN         TAB_A
  LEFT JOIN D_TERRAFORM_PTN_VARS_LINK  TAB_B ON ( TAB_B.PATTERN_ID = TAB_A.PATTERN_ID AND TAB_B.MODULE_VARS_LINK_ID = TAB_A.MODULE_VARS_LINK_ID )
  ;
  
  CREATE OR REPLACE VIEW E_OPE_FOR_PULLDOWN_TERRAFORM
  AS 
  SELECT TAB_A.OPERATION_NO_UAPK    ,
         TAB_A.OPERATION_NAME       ,
         TAB_A.OPERATION_DATE       ,
         TAB_A.OPERATION_NO_IDBH    ,
         TAB_A.OPERATION            ,
         TAB_A.DISP_SEQ             ,
         TAB_A.ACCESS_AUTH          ,
         TAB_A.NOTE                 ,
         TAB_A.DISUSE_FLAG          ,
         TAB_A.LAST_UPDATE_TIMESTAMP,
         TAB_A.LAST_UPDATE_USER
  FROM 
      E_OPERATION_LIST TAB_A
  WHERE
      TAB_A.DISUSE_FLAG IN ('0') 
  ;
  
  CREATE OR REPLACE VIEW E_TERRAFORM_PTN_VAR_LIST AS
  SELECT DISTINCT
    TAB_A.MODULE_VARS_LINK_ID,
    TAB_A.PATTERN_ID,
    TAB_A.PATTERN_NAME,
    TAB_A.VARS_NAME,
    TAB_A.VARS_LINK_PULLDOWN,
    TAB_A.DISP_SEQ,
    TAB_C.ACCESS_AUTH,
    TAB_A.NOTE,
    TAB_A.DISUSE_FLAG,
    TAB_A.LAST_UPDATE_TIMESTAMP,
    TAB_A.LAST_UPDATE_USER,
    CONCAT(TAB_A.PATTERN_ID,':',TAB_C.PATTERN_NAME,':',TAB_A.MODULE_VARS_LINK_ID,':',TAB_B.VARS_NAME) PTN_VAR_PULLDOWN
  FROM
    D_TERRAFORM_PTN_VARS_LINK          TAB_A
    LEFT JOIN B_TERRAFORM_MODULE_VARS_LINK TAB_B ON ( TAB_A.MODULE_VARS_LINK_ID = TAB_B.MODULE_VARS_LINK_ID )
    LEFT JOIN C_PATTERN_PER_ORCH           TAB_C ON ( TAB_A.PATTERN_ID   = TAB_C.PATTERN_ID )
  WHERE
    TAB_A.DISUSE_FLAG = '0' AND
    TAB_B.DISUSE_FLAG = '0' AND
    TAB_C.DISUSE_FLAG = '0';
  
  CREATE OR REPLACE VIEW E_TERRAFORM_PTN_VAR_LIST_JNL AS
  SELECT DISTINCT
    TAB_A.MODULE_VARS_LINK_ID,
    TAB_A.PATTERN_ID,
    TAB_A.PATTERN_NAME,
    TAB_A.VARS_NAME,
    TAB_A.VARS_LINK_PULLDOWN,
    TAB_A.DISP_SEQ,
    TAB_C.ACCESS_AUTH,
    TAB_A.NOTE,
    TAB_A.DISUSE_FLAG,
    TAB_A.LAST_UPDATE_TIMESTAMP,
    TAB_A.LAST_UPDATE_USER,
    CONCAT(TAB_A.PATTERN_ID,':',TAB_C.PATTERN_NAME,':',TAB_A.MODULE_VARS_LINK_ID,':',TAB_B.VARS_NAME) PTN_VAR_PULLDOWN
  FROM
    D_TERRAFORM_PTN_VARS_LINK_JNL     TAB_A
    LEFT JOIN B_TERRAFORM_MODULE_VARS_LINK_JNL TAB_B ON ( TAB_A.MODULE_VARS_LINK_ID = TAB_B.MODULE_VARS_LINK_ID )
    LEFT JOIN C_PATTERN_PER_ORCH_JNL      TAB_C ON ( TAB_A.PATTERN_ID   = TAB_C.PATTERN_ID )
  WHERE
    TAB_A.DISUSE_FLAG = '0' AND
    TAB_B.DISUSE_FLAG = '0' AND
    TAB_C.DISUSE_FLAG = '0';
  
  CREATE OR REPLACE VIEW D_TERRAFORM_MODULE AS
  SELECT  MODULE_MATTER_ID      ,
          MODULE_MATTER_NAME    ,
          CONCAT(MODULE_MATTER_ID,':',MODULE_MATTER_NAME) MODULE,
          MODULE_MATTER_FILE    ,
          DISP_SEQ              ,
          ACCESS_AUTH           ,
          NOTE                  ,
          DISUSE_FLAG           ,
          LAST_UPDATE_TIMESTAMP ,
          LAST_UPDATE_USER
  FROM    B_TERRAFORM_MODULE;
  
  CREATE OR REPLACE VIEW D_TERRAFORM_MODULE_JNL AS
  SELECT  JOURNAL_SEQ_NO          ,
          JOURNAL_REG_DATETIME    ,
          JOURNAL_ACTION_CLASS    ,
          MODULE_MATTER_ID      ,
          MODULE_MATTER_NAME    ,
          CONCAT(MODULE_MATTER_ID,':',MODULE_MATTER_NAME) MODULE,
          MODULE_MATTER_FILE    ,
          DISP_SEQ              ,
          ACCESS_AUTH           ,
          NOTE                  ,
          DISUSE_FLAG           ,
          LAST_UPDATE_TIMESTAMP ,
          LAST_UPDATE_USER
  FROM    B_TERRAFORM_MODULE_JNL;
  
  CREATE OR REPLACE VIEW D_TERRAFORM_POLICY AS
  SELECT  POLICY_ID      ,
          POLICY_NAME    ,
          CONCAT(POLICY_ID,':',POLICY_NAME) POLICY,
          POLICY_MATTER_FILE    ,
          DISP_SEQ              ,
          ACCESS_AUTH           ,
          NOTE                  ,
          DISUSE_FLAG           ,
          LAST_UPDATE_TIMESTAMP ,
          LAST_UPDATE_USER
  FROM    B_TERRAFORM_POLICY;
  
  CREATE OR REPLACE VIEW D_TERRAFORM_POLICY_JNL AS
  SELECT  JOURNAL_SEQ_NO          ,
          JOURNAL_REG_DATETIME    ,
          JOURNAL_ACTION_CLASS    ,
          POLICY_ID             ,
          POLICY_NAME           ,
          CONCAT(POLICY_ID,':',POLICY_NAME) POLICY,
          POLICY_MATTER_FILE    ,
          DISP_SEQ              ,
          ACCESS_AUTH           ,
          NOTE                  ,
          DISUSE_FLAG           ,
          LAST_UPDATE_TIMESTAMP ,
          LAST_UPDATE_USER
  FROM    B_TERRAFORM_POLICY_JNL;
  
  CREATE OR REPLACE VIEW D_TERRAFORM_POLICY_SETS AS
  SELECT  POLICY_SET_ID      ,
          POLICY_SET_NAME    ,
          CONCAT(POLICY_SET_ID,':',POLICY_SET_NAME) POLICY_SET,
          DISP_SEQ              ,
          ACCESS_AUTH           ,
          NOTE                  ,
          DISUSE_FLAG           ,
          LAST_UPDATE_TIMESTAMP ,
          LAST_UPDATE_USER
  FROM    B_TERRAFORM_POLICY_SETS;
  
  CREATE OR REPLACE VIEW D_TERRAFORM_POLICY_SETS_JNL AS
  SELECT  JOURNAL_SEQ_NO          ,
          JOURNAL_REG_DATETIME    ,
          JOURNAL_ACTION_CLASS    ,
          POLICY_SET_ID             ,
          POLICY_SET_NAME           ,
          CONCAT(POLICY_SET_ID,':',POLICY_SET_NAME) POLICY_SET,
          DISP_SEQ              ,
          ACCESS_AUTH           ,
          NOTE                  ,
          DISUSE_FLAG           ,
          LAST_UPDATE_TIMESTAMP ,
          LAST_UPDATE_USER
  FROM    B_TERRAFORM_POLICY_SETS_JNL;
  
  
  
  INSERT INTO A_SEQUENCE (NAME,VALUE,MENU_ID,DISP_SEQ,NOTE,LAST_UPDATE_TIMESTAMP) VALUES('B_TERRAFORM_VAL_ASSIGN_RIC',1,'2100080015',2100810021,NULL,STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'));
  INSERT INTO A_SEQUENCE (NAME,VALUE,MENU_ID,DISP_SEQ,NOTE,LAST_UPDATE_TIMESTAMP) VALUES('B_TERRAFORM_VAL_ASSIGN_JSQ',1,'2100080015',2100810022,'for the history table.',STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'));
  
  UPDATE A_SEQUENCE SET MENU_ID=2100080001, DISP_SEQ=2100810001, NOTE=NULL, LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='B_TERRAFORM_IF_INFO_RIC';
  UPDATE A_SEQUENCE SET MENU_ID=2100080001, DISP_SEQ=2100810002, NOTE='for the history table.', LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='B_TERRAFORM_IF_INFO_JSQ';
  UPDATE A_SEQUENCE SET MENU_ID=2100080002, DISP_SEQ=2100810003, NOTE=NULL, LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='B_TERRAFORM_ORGANIZATIONS_RIC';
  UPDATE A_SEQUENCE SET MENU_ID=2100080002, DISP_SEQ=2100810004, NOTE='for the history table.', LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='B_TERRAFORM_ORGANIZATIONS_JSQ';
  UPDATE A_SEQUENCE SET MENU_ID=2100080003, DISP_SEQ=2100810005, NOTE=NULL, LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='B_TERRAFORM_WORKSPACES_RIC';
  UPDATE A_SEQUENCE SET MENU_ID=2100080003, DISP_SEQ=2100810006, NOTE='for the history table.', LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='B_TERRAFORM_WORKSPACES_JSQ';
  UPDATE A_SEQUENCE SET MENU_ID=2100080005, DISP_SEQ=2100810007, NOTE=NULL, LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='B_TERRAFORM_MODULE_RIC';
  UPDATE A_SEQUENCE SET MENU_ID=2100080005, DISP_SEQ=2100810008, NOTE='for the history table.', LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='B_TERRAFORM_MODULE_JSQ';
  UPDATE A_SEQUENCE SET MENU_ID=2100080007, DISP_SEQ=2100810009, NOTE=NULL, LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='B_TERRAFORM_PATTERN_LINK_RIC';
  UPDATE A_SEQUENCE SET MENU_ID=2100080007, DISP_SEQ=2100810010, NOTE='for the history table.', LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='B_TERRAFORM_PATTERN_LINK_JSQ';
  UPDATE A_SEQUENCE SET MENU_ID=2100080011, DISP_SEQ=2100810011, NOTE=NULL, LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='C_TERRAFORM_EXE_INS_MNG_RIC';
  UPDATE A_SEQUENCE SET MENU_ID=2100080011, DISP_SEQ=2100810012, NOTE='for the history table.', LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='C_TERRAFORM_EXE_INS_MNG_JSQ';
  UPDATE A_SEQUENCE SET MENU_ID=2100080006, DISP_SEQ=2100810013, NOTE=NULL, LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='B_TERRAFORM_POLICY_RIC';
  UPDATE A_SEQUENCE SET MENU_ID=2100080006, DISP_SEQ=2100810014, NOTE='for the history table.', LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='B_TERRAFORM_POLICY_JSQ';
  UPDATE A_SEQUENCE SET MENU_ID=2100080012, DISP_SEQ=2100810015, NOTE=NULL, LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='B_TERRAFORM_POLICY_SETS_RIC';
  UPDATE A_SEQUENCE SET MENU_ID=2100080012, DISP_SEQ=2100810016, NOTE='for the history table.', LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='B_TERRAFORM_POLICY_SETS_JSQ';
  UPDATE A_SEQUENCE SET MENU_ID=2100080013, DISP_SEQ=2100810017, NOTE=NULL, LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='B_TERRAFORM_POLICYSET_POLICY_LINK_RIC';
  UPDATE A_SEQUENCE SET MENU_ID=2100080013, DISP_SEQ=2100810018, NOTE='for the history table.', LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='B_TERRAFORM_POLICYSET_POLICY_LINK_JSQ';
  UPDATE A_SEQUENCE SET MENU_ID=2100080014, DISP_SEQ=2100810019, NOTE=NULL, LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='B_TERRAFORM_POLICYSET_WORKSPACE_LINK_RIC';
  UPDATE A_SEQUENCE SET MENU_ID=2100080014, DISP_SEQ=2100810020, NOTE='for the history table.', LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='B_TERRAFORM_POLICYSET_WORKSPACE_LINK_JSQ';
  UPDATE A_SEQUENCE SET MENU_ID=2100080008, DISP_SEQ=2100810023, NOTE=NULL, LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='B_TERRAFORM_VARS_ASSIGN_RIC';
  UPDATE A_SEQUENCE SET MENU_ID=2100080008, DISP_SEQ=2100810024, NOTE='for the history table.', LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='B_TERRAFORM_VARS_ASSIGN_JSQ';
  UPDATE A_SEQUENCE SET MENU_ID=2100080016, DISP_SEQ=2100810025, NOTE=NULL, LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='B_TERRAFORM_MODULE_VARS_LINK_RIC';
  UPDATE A_SEQUENCE SET MENU_ID=2100080016, DISP_SEQ=2100810026, NOTE='for the history table.', LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='B_TERRAFORM_MODULE_VARS_LINK_JSQ';
  UPDATE A_SEQUENCE SET MENU_ID=NULL, DISP_SEQ=2100890001, NOTE=NULL, LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='B_TERRAFORM_STATUS_RIC';
  UPDATE A_SEQUENCE SET MENU_ID=NULL, DISP_SEQ=2100890002, NOTE='for the history table.', LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='B_TERRAFORM_STATUS_JSQ';
  UPDATE A_SEQUENCE SET MENU_ID=NULL, DISP_SEQ=2100890003, NOTE=NULL, LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='B_TERRAFORM_RUN_MODE_RIC';
  UPDATE A_SEQUENCE SET MENU_ID=NULL, DISP_SEQ=2100890004, NOTE='for the history table.', LAST_UPDATE_TIMESTAMP=STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f') WHERE NAME='B_TERRAFORM_RUN_MODE_JSQ';
  
  
  
  INSERT INTO A_MENU_LIST (MENU_ID,MENU_GROUP_ID,MENU_NAME,WEB_PRINT_LIMIT,WEB_PRINT_CONFIRM,XLS_PRINT_LIMIT,LOGIN_NECESSITY,SERVICE_STATUS,AUTOFILTER_FLG,INITIAL_FILTER_FLG,DISP_SEQ,NOTE,DISUSE_FLAG,LAST_UPDATE_TIMESTAMP,LAST_UPDATE_USER) VALUES(2100080015,2100080001,'Substitution value auto-registration setting',NULL,NULL,NULL,1,0,1,2,105,'col_vars_assign_master','0',STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'),1);
  INSERT INTO A_MENU_LIST_JNL (JOURNAL_SEQ_NO,JOURNAL_REG_DATETIME,JOURNAL_ACTION_CLASS,MENU_ID,MENU_GROUP_ID,MENU_NAME,WEB_PRINT_LIMIT,WEB_PRINT_CONFIRM,XLS_PRINT_LIMIT,LOGIN_NECESSITY,SERVICE_STATUS,AUTOFILTER_FLG,INITIAL_FILTER_FLG,DISP_SEQ,NOTE,DISUSE_FLAG,LAST_UPDATE_TIMESTAMP,LAST_UPDATE_USER) VALUES(-80015,STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'),'INSERT',2100080015,2100080001,'Substitution value auto-registration setting',NULL,NULL,NULL,1,0,1,2,105,'col_vars_assign_master','0',STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'),1);
  
  INSERT INTO A_MENU_LIST (MENU_ID,MENU_GROUP_ID,MENU_NAME,WEB_PRINT_LIMIT,WEB_PRINT_CONFIRM,XLS_PRINT_LIMIT,LOGIN_NECESSITY,SERVICE_STATUS,AUTOFILTER_FLG,INITIAL_FILTER_FLG,DISP_SEQ,NOTE,DISUSE_FLAG,LAST_UPDATE_TIMESTAMP,LAST_UPDATE_USER) VALUES(2100080017,2100080001,'Terraform Enterprise master',NULL,NULL,NULL,1,0,2,2,250,'terraform_enterprise_master','0',STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'),1);
  INSERT INTO A_MENU_LIST_JNL (JOURNAL_SEQ_NO,JOURNAL_REG_DATETIME,JOURNAL_ACTION_CLASS,MENU_ID,MENU_GROUP_ID,MENU_NAME,WEB_PRINT_LIMIT,WEB_PRINT_CONFIRM,XLS_PRINT_LIMIT,LOGIN_NECESSITY,SERVICE_STATUS,AUTOFILTER_FLG,INITIAL_FILTER_FLG,DISP_SEQ,NOTE,DISUSE_FLAG,LAST_UPDATE_TIMESTAMP,LAST_UPDATE_USER) VALUES(-80017,STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'),'INSERT',2100080017,2100080001,'Terraform Enterprise master',NULL,NULL,NULL,1,0,2,2,250,'terraform_enterprise_master','0',STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'),1);
  
  INSERT INTO A_ACCOUNT_LIST (USER_ID,USERNAME,PASSWORD,USERNAME_JP,MAIL_ADDRESS,AUTH_TYPE,NOTE,DISUSE_FLAG,LAST_UPDATE_TIMESTAMP,LAST_UPDATE_USER) VALUES(-101804,'t1b','5ebbc37e034d6874a2af59eb04beaa52','Terraform substitution value auto-registration setting procedure','sample@xxx.bbb.ccc',NULL,'Terraform substitution value auto-registration setting procedure','H',STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'),1);
  INSERT INTO A_ACCOUNT_LIST_JNL (JOURNAL_SEQ_NO,JOURNAL_REG_DATETIME,JOURNAL_ACTION_CLASS,USER_ID,USERNAME,PASSWORD,USERNAME_JP,MAIL_ADDRESS,AUTH_TYPE,NOTE,DISUSE_FLAG,LAST_UPDATE_TIMESTAMP,LAST_UPDATE_USER) VALUES(-101804,STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'),'INSERT',-101804,'t1b','5ebbc37e034d6874a2af59eb04beaa52','Terraform substitution value auto-registration setting procedure','sample@xxx.bbb.ccc',NULL,'Terraform substitution value auto-registration setting procedure','H',STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'),1);
  
  INSERT INTO A_ROLE_MENU_LINK_LIST (LINK_ID,ROLE_ID,MENU_ID,PRIVILEGE,NOTE,DISUSE_FLAG,LAST_UPDATE_TIMESTAMP,LAST_UPDATE_USER) VALUES(2100080015,1,2100080015,1,'System Administrator','0',STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'),1);
  INSERT INTO A_ROLE_MENU_LINK_LIST_JNL (JOURNAL_SEQ_NO,JOURNAL_REG_DATETIME,JOURNAL_ACTION_CLASS,LINK_ID,ROLE_ID,MENU_ID,PRIVILEGE,NOTE,DISUSE_FLAG,LAST_UPDATE_TIMESTAMP,LAST_UPDATE_USER) VALUES(-180015,STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'),'INSERT',2100080015,1,2100080015,1,'System Administrator','0',STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'),1);
  
  INSERT INTO A_ROLE_MENU_LINK_LIST (LINK_ID,ROLE_ID,MENU_ID,PRIVILEGE,NOTE,DISUSE_FLAG,LAST_UPDATE_TIMESTAMP,LAST_UPDATE_USER) VALUES(2100080017,1,2100080017,1,'System Administrator','0',STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'),1);
  INSERT INTO A_ROLE_MENU_LINK_LIST_JNL (JOURNAL_SEQ_NO,JOURNAL_REG_DATETIME,JOURNAL_ACTION_CLASS,LINK_ID,ROLE_ID,MENU_ID,PRIVILEGE,NOTE,DISUSE_FLAG,LAST_UPDATE_TIMESTAMP,LAST_UPDATE_USER) VALUES(-180017,STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'),'INSERT',2100080017,1,2100080017,1,'System Administrator','0',STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'),1);
  
  INSERT INTO A_PROC_LOADED_LIST (ROW_ID,PROC_NAME,LOADED_FLG,LAST_UPDATE_TIMESTAMP) VALUES(2100080001,'ky_terraform_varsautolistup-workflow','0',STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'));
  
  INSERT INTO A_PROC_LOADED_LIST (ROW_ID,PROC_NAME,LOADED_FLG,LAST_UPDATE_TIMESTAMP) VALUES(2100080002,'ky_terraform_valautosetup-workflow','0',STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'));
  
  UPDATE B_TERRAFORM_RUN_MODE SET RUN_MODE_NAME='Plan check' WHERE RUN_MODE_ID=2;
  UPDATE B_TERRAFORM_RUN_MODE_JNL SET RUN_MODE_NAME='Plan check' WHERE RUN_MODE_ID=2;
  
  UPDATE B_TERRAFORM_IF_INFO SET NULL_DATA_HANDLING_FLG='2' WHERE TERRAFORM_IF_INFO_ID=1;
  UPDATE B_TERRAFORM_IF_INFO_JNL SET NULL_DATA_HANDLING_FLG='2' WHERE TERRAFORM_IF_INFO_ID=1;
  
  INSERT INTO B_TERRAFORM_HCL_FLAG (HCL_FLAG,HCL_FLAG_SELECT,DISP_SEQ,NOTE,DISUSE_FLAG,LAST_UPDATE_TIMESTAMP,LAST_UPDATE_USER) VALUES(1,'OFF',1,NULL,'0',STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'),1);
  INSERT INTO B_TERRAFORM_HCL_FLAG_JNL (JOURNAL_SEQ_NO,JOURNAL_REG_DATETIME,JOURNAL_ACTION_CLASS,HCL_FLAG,HCL_FLAG_SELECT,DISP_SEQ,NOTE,DISUSE_FLAG,LAST_UPDATE_TIMESTAMP,LAST_UPDATE_USER) VALUES(1,STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'),'INSERT',1,'OFF',1,NULL,'0',STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'),1);
  INSERT INTO B_TERRAFORM_HCL_FLAG (HCL_FLAG,HCL_FLAG_SELECT,DISP_SEQ,NOTE,DISUSE_FLAG,LAST_UPDATE_TIMESTAMP,LAST_UPDATE_USER) VALUES(2,'ON',1,NULL,'0',STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'),1);
  INSERT INTO B_TERRAFORM_HCL_FLAG_JNL (JOURNAL_SEQ_NO,JOURNAL_REG_DATETIME,JOURNAL_ACTION_CLASS,HCL_FLAG,HCL_FLAG_SELECT,DISP_SEQ,NOTE,DISUSE_FLAG,LAST_UPDATE_TIMESTAMP,LAST_UPDATE_USER) VALUES(2,STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'),'INSERT',2,'ON',1,NULL,'0',STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'),1);
  