text: -- *****************************************************************************
  -- *** ***** CreateParameterMenu Tables                                      ***
  -- *****************************************************************************
  CREATE TABLE F_HG_VAR_LINK_LEGACY
  (
  ROW_ID                             INT                             , -- 識別シーケンス項番
  
  OPERATION_NO_UAPK                  INT                             ,
  PATTERN_ID                         INT                             ,
  SYSTEM_ID                          INT                             ,
  VARS_NAME                          VARCHAR (512)                   ,
  
  DISP_SEQ                           INT                             , -- 表示順序
  NOTE                               VARCHAR (4000)                  , -- 備考
  DISUSE_FLAG                        VARCHAR (1)                     , -- 廃止フラグ
  LAST_UPDATE_TIMESTAMP              DATETIME(6)                     , -- 最終更新日時
  LAST_UPDATE_USER                   INT                             , -- 最終更新ユーザ
  
  PRIMARY KEY (ROW_ID)
  )ENGINE = InnoDB, CHARSET = utf8, COLLATE = utf8_bin, ROW_FORMAT=COMPRESSED ,KEY_BLOCK_SIZE=8;
  
  CREATE TABLE F_HG_VAR_LINK_LEGACY_JNL
  (
  JOURNAL_SEQ_NO                     INT                             , -- 履歴用シーケンス
  JOURNAL_REG_DATETIME               DATETIME(6)                     , -- 履歴用変更日時
  JOURNAL_ACTION_CLASS               VARCHAR (8)                     , -- 履歴用変更種別
  
  ROW_ID                             INT                             , -- 識別シーケンス項番
  
  OPERATION_NO_UAPK                  INT                             ,
  PATTERN_ID                         INT                             ,
  SYSTEM_ID                          INT                             ,
  VARS_NAME                          VARCHAR (512)                   ,
  
  DISP_SEQ                           INT                             , -- 表示順序
  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;
  
  CREATE TABLE F_HG_VAR_LINK_LEGACYROLE
  (
  ROW_ID                             INT                             , -- 識別シーケンス項番
  
  OPERATION_NO_UAPK                  INT                             ,
  PATTERN_ID                         INT                             ,
  SYSTEM_ID                          INT                             ,
  VARS_NAME                          VARCHAR (512)                   ,
  
  DISP_SEQ                           INT                             , -- 表示順序
  NOTE                               VARCHAR (4000)                  , -- 備考
  DISUSE_FLAG                        VARCHAR (1)                     , -- 廃止フラグ
  LAST_UPDATE_TIMESTAMP              DATETIME(6)                     , -- 最終更新日時
  LAST_UPDATE_USER                   INT                             , -- 最終更新ユーザ
  
  PRIMARY KEY (ROW_ID)
  )ENGINE = InnoDB, CHARSET = utf8, COLLATE = utf8_bin, ROW_FORMAT=COMPRESSED ,KEY_BLOCK_SIZE=8;
  
  CREATE TABLE F_HG_VAR_LINK_LEGACYROLE_JNL
  (
  JOURNAL_SEQ_NO                     INT                             , -- 履歴用シーケンス
  JOURNAL_REG_DATETIME               DATETIME(6)                     , -- 履歴用変更日時
  JOURNAL_ACTION_CLASS               VARCHAR (8)                     , -- 履歴用変更種別
  
  ROW_ID                             INT                             , -- 識別シーケンス項番
  
  OPERATION_NO_UAPK                  INT                             ,
  PATTERN_ID                         INT                             ,
  SYSTEM_ID                          INT                             ,
  VARS_NAME                          VARCHAR (512)                   ,
  
  DISP_SEQ                           INT                             , -- 表示順序
  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;
  INSERT INTO A_SEQUENCE (NAME,VALUE) VALUES('F_HG_VAR_LINK_LEGACY_RIC',1);
  
  INSERT INTO A_SEQUENCE (NAME,VALUE) VALUES('F_HG_VAR_LINK_LEGACY_JSQ',1);
  
  INSERT INTO A_SEQUENCE (NAME,VALUE) VALUES('F_HG_VAR_LINK_LEGACYROLE_RIC',1);
  
  INSERT INTO A_SEQUENCE (NAME,VALUE) VALUES('F_HG_VAR_LINK_LEGACYROLE_JSQ',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(2100170006,2100011701,'HostGroupVariable link list (Ansible-Legacy)',NULL,NULL,NULL,1,0,1,2,6,'hostgroup_var_link_legacy','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(-170006,STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'),'INSERT',2100170006,2100011701,'HostGroupVariable link list (Ansible-Legacy)',NULL,NULL,NULL,1,0,1,2,6,'hostgroup_var_link_legacy','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(2100170007,2100011701,'HostGroupVariable link list (Ansible-LegacyRole)',NULL,NULL,NULL,1,0,1,2,7,'hostgroup_var_link_legacyrole','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(-170007,STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'),'INSERT',2100170007,2100011701,'HostGroupVariable link list (Ansible-LegacyRole)',NULL,NULL,NULL,1,0,1,2,7,'hostgroup_var_link_legacyrole','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(2100170006,1,2100170006,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(-170006,STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'),'INSERT',2100170006,1,2100170006,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(2100170007,1,2100170007,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(-170007,STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'),'INSERT',2100170007,1,2100170007,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(2100170006,'ky_hostgroup_regist_var_legacy','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(2100170007,'ky_hostgroup_regist_var_legacy_role','0',STR_TO_DATE('2015/04/01 10:00:00.000000','%Y/%m/%d %H:%i:%s.%f'));
  
  
  
  COMMIT;
  