Rem Rem $Header: ecm_csa_metadata.sql 09-feb-2005.13:16:48 asaraswa Exp $ Rem Rem ecm_csa_metadata.sql Rem Rem Copyright (c) 2003, 2005, Oracle. All rights reserved. Rem Rem NAME Rem ecm_csa_metadata.sql - Rem Rem DESCRIPTION Rem Rem Rem NOTES Rem This is a *generated* file created from ecm_csa_metadata.xml. Rem DO NOT EDIT THIS FILE. First, change the XML metadata file and Rem then regenerate the contents of this file. Rem Rem MODIFIED (MM/DD/YY) Rem asaraswa 02/08/05 - adding new AUTO_CONFIG_URL and Rem BROWSER_PROXY_ENABLED columns Rem asaraswa 11/23/04 - adding new columns Rem asaraswa 09/14/04 - adding connection_type column to mgmt_ecm_csa Rem vkhizder 07/12/04 - more changes to CSA: rules, app id, etc Rem rpinnama 06/12/04 - Remove set ECHO Rem vkhizder 02/25/04 - various schema changes Rem mgoodric 09/25/03 - change csa_proxy and csa_client target types Rem vkhizder 08/08/03 - shortening os user name to for csa index to fit Rem into 2k blocksized db max index size of 1478 Rem vkhizder 08/07/03 - vkhizder_trans_jul21_03 Rem vkhizder 07/29/03 - changing target/snapshot types and Rem adding metadata for csa_proxy Rem vkhizder 06/26/03 - Created: move from ecm_csa.sql Rem -- Uncomment the following line to see the commands during the script execution -- SET ECHO ON -- Do not use substitution variables in this script so that there is no -- additional restrictions on the string values that are being inserted (such as ampersand -- being interpreted specially by SQLPlus). SET DEFINE OFF -------------------------------------------- -- Registering metadata for target type oracle_csa_collector and snapshot type oracle_csa -------------------------------------------- ALTER SESSION SET CONSTRAINTS = DEFERRED; DECLARE metadata_id RAW(16) := SYS_GUID(); BEGIN -- Remove loader metadata DELETE FROM MGMT_ECM_SNAPSHOT_MD_TABLES WHERE METADATA_ID IN (SELECT METADATA_ID FROM MGMT_ECM_SNAPSHOT_METADATA WHERE TARGET_TYPE = 'oracle_csa_collector' AND SNAPSHOT_TYPE = 'oracle_csa' AND KIND = 'L'); DELETE FROM MGMT_ECM_SNAPSHOT_METADATA WHERE TARGET_TYPE = 'oracle_csa_collector' AND SNAPSHOT_TYPE = 'oracle_csa' AND KIND = 'L'; -- Register metadata as loader metadata INSERT INTO MGMT_ECM_SNAPSHOT_METADATA (SNAPSHOT_TYPE, TARGET_TYPE, KIND, METADATA_ID, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, LINK_TABLE_NAME, AFTER_LOAD_PROC_NAME, AFTER_IMPORT_PROC_NAME, METADATA_VERSION, VIEW_URL, COMPARE_URL, HISTORY_URL, SAME_TARGET_COMPARE) VALUES ('oracle_csa', 'oracle_csa_collector', 'L', metadata_id, NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'MGMT_ECM_CSA_PKG.AFTER_LOAD', NULL, '1', NULL, NULL, NULL, 'H'); END; / ALTER SESSION SET CONSTRAINTS = IMMEDIATE; COMMIT; -- End of metadata registration -------------------------------------------- -- Registering metadata for target type oracle_csa_client and snapshot type oracle_csa_host -------------------------------------------- ALTER SESSION SET CONSTRAINTS = DEFERRED; DECLARE metadata_id RAW(16) := SYS_GUID(); BEGIN -- Remove loader metadata DELETE FROM MGMT_ECM_SNAPSHOT_MD_TABLES WHERE METADATA_ID IN (SELECT METADATA_ID FROM MGMT_ECM_SNAPSHOT_METADATA WHERE TARGET_TYPE = 'oracle_csa_client' AND SNAPSHOT_TYPE = 'oracle_csa_host' AND KIND = 'L'); DELETE FROM MGMT_ECM_SNAPSHOT_METADATA WHERE TARGET_TYPE = 'oracle_csa_client' AND SNAPSHOT_TYPE = 'oracle_csa_host' AND KIND = 'L'; -- Register metadata as loader metadata INSERT INTO MGMT_ECM_SNAPSHOT_METADATA (SNAPSHOT_TYPE, TARGET_TYPE, KIND, METADATA_ID, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, LINK_TABLE_NAME, AFTER_LOAD_PROC_NAME, AFTER_IMPORT_PROC_NAME, METADATA_VERSION, VIEW_URL, COMPARE_URL, HISTORY_URL, SAME_TARGET_COMPARE) VALUES ('oracle_csa_host', 'oracle_csa_client', 'L', metadata_id, NULL, 'N', 'N', 'N', 'N', 'N', NULL, NULL, NULL, '1', NULL, NULL, NULL, 'H'); -- Register metadata for table MGMT_ECM_CSA_SNAPSHOT_INFO INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_SNAPSHOT_INFO', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_SNAPSHOT_INFO', 'DISPLAY_TARGET_NAME', NULL, 'S', '256', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_SNAPSHOT_INFO', 'SNAPSHOT_TYPE', NULL, 'S', '64', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_SNAPSHOT_INFO', 'START_TIMESTAMP', NULL, 'D', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_SNAPSHOT_INFO', 'ELAPSED_TIME', NULL, 'N', '16', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 3); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_SNAPSHOT_INFO', 'STATUS', NULL, 'S', '1', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 4); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_SNAPSHOT_INFO', 'MESSAGE', NULL, 'S', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 5); -- Register metadata for table MGMT_ECM_CSA_GENERAL_INFO INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'APPLET_VERSION', NULL, 'S', '20', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'CUSTOM_CLASS', NULL, 'S', '1000', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'CUSTOM_CLASS_VERSION', NULL, 'S', '1000', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'TARGET_ID_METHOD', NULL, 'S', '100', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 3); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'OS_USER_NAME', NULL, 'S', '500', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 4); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'BOOT_DISK_VOLUME_SERIAL_NUM', NULL, 'S', '100', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 5); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'HOSTNAME', NULL, 'S', '128', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 6); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'DOMAIN', NULL, 'S', '500', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 7); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'APPID', NULL, 'S', '128', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 8); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'TARGET_KEY1', NULL, 'S', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 9); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'TARGET_KEY2', NULL, 'S', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 10); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'TARGET_KEY3', NULL, 'S', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 11); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'PROXY_TARGET_NAME', NULL, 'S', '256', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 12); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'PROXY_TARGET_DISPLAY_NAME', NULL, 'S', '256', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 13); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'PROXY_TARGET_ID', NULL, 'R', '16', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 14); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'WORST_RULE_STATUS', NULL, 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 15); -- Register metadata for table MGMT_ECM_CSA INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'NET_LATENCY_IN_MS', NULL, 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'NET_BANDWIDTH_IN_KBITPS', NULL, 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'NET_EFFECTIVE_IP', NULL, 'S', '20', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'NET_IP', NULL, 'S', '20', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 3); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'NET_SUBNET', NULL, 'S', '20', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 4); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'BROWSER_TYPE', NULL, 'S', '100', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 5); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'BROWSER_VERSION', NULL, 'S', '20', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 6); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'BROWSER_JVM_VENDOR', NULL, 'S', '100', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 7); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'BROWSER_JVM_VERSION', NULL, 'S', '20', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 8); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'BROWSER_PROXY_SERVER', NULL, 'S', '4000', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 9); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'BROWSER_PROXY_EXCEPTIONS', NULL, 'S', '4000', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 10); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'BROWSER_CACHE_SIZE_IN_MB', NULL, 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 11); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'BROWSER_CACHE_UPDATE_FRQ', NULL, 'S', '200', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 12); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'BROWSER_HTTP1_1_SUPPORT', NULL, 'S', '1', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 13); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'REFERRING_URL_HEADER', NULL, 'S', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 14); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'REFERRING_URL_PARAMS', NULL, 'S', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 15); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'CSA_URL_HEADER', NULL, 'S', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 16); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'CSA_URL_PARAMS', NULL, 'S', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 17); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'DESTINATION_URL_HEADER', NULL, 'S', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 18); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'DESTINATION_URL_PARAMS', NULL, 'S', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 19); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'CONNECTION_TYPE', NULL, 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 20); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'IS_WINDOWS_ADMIN', NULL, 'S', '1', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 21); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'WINDOWS_DOMAIN', NULL, 'S', '100', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 22); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'BROWSER_PROXY_ENABLED', NULL, 'S', '1', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 23); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'AUTO_CONFIG_URL', NULL, 'S', '4000', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 24); -- Register metadata for table MGMT_ECM_CSA_COOKIES INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_COOKIES', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'N', 3); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_COOKIES', 'NAME', NULL, 'S', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_COOKIES', 'VALUE', NULL, 'S', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 1); -- Register metadata for table MGMT_ECM_CSA_CUSTOM INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_CUSTOM', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'N', 4); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_CUSTOM', 'TYPE', NULL, 'S', '512', 'N', 'N', 'N', 'N', 'N', 'Y', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_CUSTOM', 'NAME', NULL, 'S', '512', 'N', 'N', 'N', 'N', 'N', 'Y', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_CUSTOM', 'TYPE_UI', NULL, 'S', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_CUSTOM', 'NAME_UI', NULL, 'S', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 3); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_CUSTOM', 'VALUE', NULL, 'S', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 4); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_CUSTOM', 'DISPLAY_UI', NULL, 'S', '1', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 5); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_CUSTOM', 'HISTORY_TRACKING', NULL, 'S', '1', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 6); -- Register metadata for table MGMT_ECM_HW INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 5); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'HOSTNAME', NULL, 'S', '128', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'DOMAIN', NULL, 'S', '500', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'VENDOR_NAME', NULL, 'S', '128', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'SYSTEM_CONFIG', NULL, 'S', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 3); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'MACHINE_ARCHITECTURE', NULL, 'S', '500', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 4); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'CLOCK_FREQ_IN_MHZ', NULL, 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 5); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'MEMORY_SIZE_IN_MB', NULL, 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 6); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'AVAIL_MEMORY_SIZE_IN_MB', NULL, 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 7); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'LOCAL_DISK_SPACE_IN_GB', NULL, 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 8); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'AVAIL_LOCAL_DISK_SPACE_IN_GB', NULL, 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 9); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'CPU_COUNT', NULL, 'N', '8', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 10); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'CPU_BOARD_COUNT', NULL, 'N', '8', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 11); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'IOCARD_COUNT', NULL, 'N', '8', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 12); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'FAN_COUNT', NULL, 'N', '8', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 13); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'POWER_SUPPLY_COUNT', NULL, 'N', '8', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 14); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'BOOT_DISK_VOLUME_SERIAL_NUM', NULL, 'S', '100', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 15); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'SYSTEM_BIOS', NULL, 'S', '100', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 16); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'SYSTEM_SERIAL_NUMBER', NULL, 'S', '100', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 17); -- Register metadata for table MGMT_ECM_HW_CPU INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW_CPU', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'N', 6); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW_CPU', 'VENDOR_NAME', NULL, 'S', '128', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW_CPU', 'FREQ_IN_MHZ', NULL, 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW_CPU', 'ECACHE_IN_MB', NULL, 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW_CPU', 'IMPL', NULL, 'S', '500', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 3); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW_CPU', 'REVISION', NULL, 'S', '2000', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 4); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW_CPU', 'MASK', NULL, 'S', '500', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 5); -- Register metadata for table MGMT_ECM_HW_IOCARD INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW_IOCARD', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'N', 7); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW_IOCARD', 'VENDOR_NAME', NULL, 'S', '128', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW_IOCARD', 'NAME', NULL, 'S', '128', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW_IOCARD', 'FREQ_IN_MHZ', NULL, 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW_IOCARD', 'BUS', NULL, 'S', '500', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 3); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW_IOCARD', 'REVISION', NULL, 'S', '2000', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 4); -- Register metadata for table MGMT_ECM_HW_NIC INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW_NIC', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'N', 8); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW_NIC', 'NAME', NULL, 'S', '128', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW_NIC', 'DESCRIPTION', NULL, 'S', '500', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW_NIC', 'FLAGS', NULL, 'S', '1024', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW_NIC', 'MAX_TRANSFER_UNIT', NULL, 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 3); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW_NIC', 'INET_ADDRESS', NULL, 'S', '20', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 4); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW_NIC', 'MASK', NULL, 'S', '20', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 5); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW_NIC', 'BROADCAST_ADDRESS', NULL, 'S', '20', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 6); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW_NIC', 'MAC_ADDRESS', NULL, 'S', '20', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 7); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW_NIC', 'HOSTNAME_ALIASES', NULL, 'S', '4000', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 8); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW_NIC', 'DEFAULT_GATEWAY', NULL, 'S', '20', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 9); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW_NIC', 'DHCP_ENABLED', NULL, 'S', '1', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 10); -- Register metadata for table MGMT_ECM_OS INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 9); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS', 'NAME', NULL, 'S', '128', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS', 'VENDOR_NAME', NULL, 'S', '128', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS', 'BASE_VERSION', NULL, 'S', '100', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS', 'UPDATE_LEVEL', NULL, 'S', '100', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 3); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS', 'DISTRIBUTOR_VERSION', NULL, 'S', '100', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 4); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS', 'MAX_SWAP_SPACE_IN_MB', NULL, 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 5); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS', 'ADDRESS_LENGTH_IN_BITS', NULL, 'S', '20', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 6); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS', 'MAX_PROCESS_VIRTUAL_MEMORY', NULL, 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 7); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS', 'TIMEZONE', NULL, 'S', '64', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 8); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS', 'TIMEZONE_REGION', NULL, 'S', '64', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 9); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS', 'TIMEZONE_DELTA', NULL, 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 10); -- Register metadata for table MGMT_ECM_OS_PROPERTY INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_PROPERTY', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'N', 10); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_PROPERTY', 'SOURCE', NULL, 'S', '128', 'N', 'N', 'N', 'N', 'N', 'Y', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_PROPERTY', 'NAME', NULL, 'S', '128', 'N', 'N', 'N', 'N', 'N', 'Y', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_PROPERTY', 'VALUE', NULL, 'S', '2000', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 2); -- Register metadata for table MGMT_ECM_OS_COMPONENT INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_COMPONENT', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'N', 11); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_COMPONENT', 'NAME', NULL, 'S', '128', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_COMPONENT', 'TYPE', NULL, 'S', '100', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_COMPONENT', 'VERSION', NULL, 'S', '100', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_COMPONENT', 'DESCRIPTION', NULL, 'S', '2000', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 3); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_COMPONENT', 'INSTALLATION_DATE', NULL, 'D', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 4); -- Register metadata for table MGMT_ECM_OS_FILESYSTEM INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_FILESYSTEM', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'N', 12); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_FILESYSTEM', 'RESOURCE_NAME', NULL, 'S', '128', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_FILESYSTEM', 'MOUNT_LOCATION', NULL, 'S', '1024', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_FILESYSTEM', 'TYPE', NULL, 'S', '100', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_FILESYSTEM', 'DISK_SPACE_IN_GB', NULL, 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 3); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_FILESYSTEM', 'AVAIL_DISK_SPACE_IN_GB', NULL, 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 4); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_FILESYSTEM', 'LOCAL_DRIVE', NULL, 'S', '1', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 5); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_FILESYSTEM', 'MOUNT_OPTIONS', NULL, 'S', '1024', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 6); -- Register metadata for table MGMT_ECM_OS_REGISTERED_SW INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_REGISTERED_SW', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'N', 13); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_REGISTERED_SW', 'ID', NULL, 'S', '500', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_REGISTERED_SW', 'NAME', NULL, 'S', '128', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_REGISTERED_SW', 'VENDOR_NAME', NULL, 'S', '128', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_REGISTERED_SW', 'VERSION', NULL, 'S', '100', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 3); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_REGISTERED_SW', 'INSTALLATION_DATE', NULL, 'D', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 4); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_REGISTERED_SW', 'INSTALLED_LOCATION', NULL, 'S', '1024', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 5); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_REGISTERED_SW', 'DESCRIPTION', NULL, 'S', '2000', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 6); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_REGISTERED_SW', 'VENDOR_SW_SPECIFIC_INFO', NULL, 'S', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 7); -- Register metadata for table MGMT_ECM_OS_REGISTERED_SW_COMP INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_REGISTERED_SW_COMP', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'N', 14); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_REGISTERED_SW_COMP', 'ID', NULL, 'S', '500', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_REGISTERED_SW_COMP', 'NAME', NULL, 'S', '128', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_REGISTERED_SW_COMP', 'TYPE', NULL, 'S', '100', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_REGISTERED_SW_COMP', 'VERSION', NULL, 'S', '100', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 3); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_REGISTERED_SW_COMP', 'DESCRIPTION', NULL, 'S', '2000', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 4); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_REGISTERED_SW_COMP', 'INSTALLATION_DATE', NULL, 'D', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 5); -- Register metadata for table MGMT_ECM_CSA_RULES INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_RULES', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'N', 15); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_RULES', 'NAME', NULL, 'S', '128', 'N', 'N', 'N', 'N', 'N', 'Y', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_RULES', 'DESCRIPTION', NULL, 'S', '256', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_RULES', 'STATUS', NULL, 'N', NULL, 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_RULES', 'MOREINFO', NULL, 'S', '1024', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, 3); END; / ALTER SESSION SET CONSTRAINTS = IMMEDIATE; COMMIT; -- End of metadata registration -------------------------------------------- -- Registering metadata for target type oracle_csa_client and snapshot type oracle_csa_host -------------------------------------------- ALTER SESSION SET CONSTRAINTS = DEFERRED; DECLARE metadata_id RAW(16) := SYS_GUID(); BEGIN -- Remove presentation metadata DELETE FROM MGMT_ECM_SNAPSHOT_MD_TABLES WHERE METADATA_ID IN (SELECT METADATA_ID FROM MGMT_ECM_SNAPSHOT_METADATA WHERE TARGET_TYPE = 'oracle_csa_client' AND SNAPSHOT_TYPE = 'oracle_csa_host' AND KIND = 'P'); DELETE FROM MGMT_ECM_SNAPSHOT_METADATA WHERE TARGET_TYPE = 'oracle_csa_client' AND SNAPSHOT_TYPE = 'oracle_csa_host' AND KIND = 'P'; -- Register metadata as presentation metadata INSERT INTO MGMT_ECM_SNAPSHOT_METADATA (SNAPSHOT_TYPE, TARGET_TYPE, KIND, METADATA_ID, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, LINK_TABLE_NAME, AFTER_LOAD_PROC_NAME, AFTER_IMPORT_PROC_NAME, METADATA_VERSION, VIEW_URL, COMPARE_URL, HISTORY_URL, SAME_TARGET_COMPARE) VALUES ('oracle_csa_host', 'oracle_csa_client', 'P', metadata_id, NULL, 'N', 'N', 'Y', 'N', 'Y', NULL, NULL, NULL, '1', NULL, NULL, NULL, 'H'); -- Register metadata for table MGMT_ECM_CSA_GENERAL_INFO INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', NULL, 'N', 'N', 'Y', 'N', 'Y', NULL, 'Y', 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'APPLET_VERSION', NULL, 'S', '20', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'CUSTOM_CLASS', NULL, 'S', '1000', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'CUSTOM_CLASS_VERSION', NULL, 'S', '1000', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'TARGET_ID_METHOD', NULL, 'S', '100', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 3); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'OS_USER_NAME', NULL, 'S', '500', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 4); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'BOOT_DISK_VOLUME_SERIAL_NUM', NULL, 'S', '100', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 5); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'HOSTNAME', NULL, 'S', '128', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 6); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'DOMAIN', NULL, 'S', '500', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 7); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'APPID', NULL, 'S', '128', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 8); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'TARGET_KEY1', NULL, 'S', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 9); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'TARGET_KEY2', NULL, 'S', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 10); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'TARGET_KEY3', NULL, 'S', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 11); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'PROXY_TARGET_NAME', NULL, 'S', '256', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 12); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'PROXY_TARGET_DISPLAY_NAME', NULL, 'S', '256', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 13); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'PROXY_TARGET_ID', NULL, 'R', '16', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 14); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_GENERAL_INFO', 'WORST_RULE_STATUS', NULL, 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 15); -- Register metadata for table MGMT_ECM_CSA INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', NULL, 'N', 'N', 'Y', 'N', 'Y', NULL, 'Y', 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'NET_LATENCY_IN_MS', NULL, 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'NET_BANDWIDTH_IN_KBITPS', NULL, 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'NET_EFFECTIVE_IP', NULL, 'S', '20', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'NET_IP', NULL, 'S', '20', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 3); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'NET_SUBNET', NULL, 'S', '20', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 4); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'BROWSER_TYPE', NULL, 'S', '100', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 5); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'BROWSER_VERSION', NULL, 'S', '20', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 6); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'BROWSER_JVM_VENDOR', NULL, 'S', '100', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 7); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'BROWSER_JVM_VERSION', NULL, 'S', '20', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 8); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'BROWSER_PROXY_SERVER', NULL, 'S', '4000', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 9); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'BROWSER_PROXY_EXCEPTIONS', NULL, 'S', '4000', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 10); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'BROWSER_CACHE_SIZE_IN_MB', NULL, 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 11); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'BROWSER_CACHE_UPDATE_FRQ', NULL, 'S', '200', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 12); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'BROWSER_HTTP1_1_SUPPORT', NULL, 'S', '1', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 13); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'REFERRING_URL_HEADER', NULL, 'S', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 14); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'REFERRING_URL_PARAMS', NULL, 'S', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 15); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'CSA_URL_HEADER', NULL, 'S', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 16); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'CSA_URL_PARAMS', NULL, 'S', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 17); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'DESTINATION_URL_HEADER', NULL, 'S', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 18); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'DESTINATION_URL_PARAMS', NULL, 'S', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 19); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'CONNECTION_TYPE', NULL, 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 20); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'IS_WINDOWS_ADMIN', NULL, 'S', '1', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 21); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'WINDOWS_DOMAIN', NULL, 'S', '100', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 22); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'BROWSER_PROXY_ENABLED', NULL, 'S', '1', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 23); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA', 'AUTO_CONFIG_URL', NULL, 'S', '4000', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 24); -- Register metadata for table EM$ECM_CSA_CUSTOM INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'EM$ECM_CSA_CUSTOM', NULL, 'N', 'N', 'Y', 'N', 'Y', NULL, 'N', 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_CSA_CUSTOM', 'TYPE', NULL, 'S', '512', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_CSA_CUSTOM', 'NAME', NULL, 'S', '512', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_CSA_CUSTOM', 'TYPE_UI', NULL, 'S', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_CSA_CUSTOM', 'NAME_UI', NULL, 'S', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 3); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_CSA_CUSTOM', 'VALUE', NULL, 'S', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 4); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_CSA_CUSTOM', 'DISPLAY_UI', NULL, 'S', '1', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 5); -- Register metadata for table MGMT_ECM_HW INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', NULL, 'N', 'N', 'Y', 'N', 'Y', NULL, 'Y', 3); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'HOSTNAME', NULL, 'S', '128', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'DOMAIN', NULL, 'S', '500', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'VENDOR_NAME', NULL, 'S', '128', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'SYSTEM_CONFIG', NULL, 'S', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 3); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'MACHINE_ARCHITECTURE', NULL, 'S', '500', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 4); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'CLOCK_FREQ_IN_MHZ', NULL, 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 5); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'MEMORY_SIZE_IN_MB', NULL, 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 6); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'AVAIL_MEMORY_SIZE_IN_MB', NULL, 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 7); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'LOCAL_DISK_SPACE_IN_GB', NULL, 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 8); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'AVAIL_LOCAL_DISK_SPACE_IN_GB', NULL, 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 9); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'CPU_COUNT', NULL, 'N', '8', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 10); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'CPU_BOARD_COUNT', NULL, 'N', '8', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 11); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'IOCARD_COUNT', NULL, 'N', '8', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 12); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'FAN_COUNT', NULL, 'N', '8', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 13); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'POWER_SUPPLY_COUNT', NULL, 'N', '8', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 14); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'BOOT_DISK_VOLUME_SERIAL_NUM', NULL, 'S', '100', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 15); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'SYSTEM_BIOS', NULL, 'S', '100', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 16); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_HW', 'SYSTEM_SERIAL_NUMBER', NULL, 'S', '100', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 17); -- Register metadata for table EM$ECM_HW_CPU INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_CPU', NULL, 'N', 'N', 'Y', 'N', 'Y', 'MGMT_ECM_HW', 'N', 4); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_CPU', 'VENDOR_NAME', NULL, 'S', '128', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_CPU', 'FREQ_IN_MHZ', NULL, 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_CPU', 'ECACHE_IN_MB', NULL, 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_CPU', 'IMPL', NULL, 'S', '500', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 3); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_CPU', 'REVISION', NULL, 'S', '2000', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 4); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_CPU', 'MASK', NULL, 'S', '500', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 5); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_CPU', 'COUNT', NULL, 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 6); -- Register metadata for table EM$ECM_HW_IOCARD INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_IOCARD', NULL, 'N', 'N', 'Y', 'N', 'Y', 'MGMT_ECM_HW', 'N', 5); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_IOCARD', 'VENDOR_NAME', NULL, 'S', '128', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_IOCARD', 'NAME', NULL, 'S', '128', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_IOCARD', 'FREQ_IN_MHZ', NULL, 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_IOCARD', 'BUS', NULL, 'S', '500', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 3); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_IOCARD', 'REVISION', NULL, 'S', '2000', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 4); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_IOCARD', 'COUNT', NULL, 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 5); -- Register metadata for table EM$ECM_HW_NIC INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_NIC', NULL, 'N', 'N', 'Y', 'N', 'Y', 'MGMT_ECM_HW', 'N', 6); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_NIC', 'NAME', NULL, 'S', '128', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_NIC', 'DESCRIPTION', NULL, 'S', '500', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_NIC', 'FLAGS', NULL, 'S', '1024', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_NIC', 'MAX_TRANSFER_UNIT', NULL, 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 3); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_NIC', 'INET_ADDRESS', NULL, 'S', '20', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 4); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_NIC', 'MASK', NULL, 'S', '20', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 5); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_NIC', 'BROADCAST_ADDRESS', NULL, 'S', '20', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 6); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_NIC', 'MAC_ADDRESS', NULL, 'S', '20', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 7); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_NIC', 'HOSTNAME_ALIASES', NULL, 'S', '4000', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 8); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_NIC', 'DEFAULT_GATEWAY', NULL, 'S', '20', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 9); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_NIC', 'DHCP_ENABLED', NULL, 'S', '1', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 10); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'EM$ECM_HW_NIC', 'COUNT', NULL, 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 11); -- Register metadata for table MGMT_ECM_OS INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS', NULL, 'N', 'N', 'Y', 'N', 'Y', NULL, 'Y', 7); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS', 'NAME', NULL, 'S', '128', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS', 'VENDOR_NAME', NULL, 'S', '128', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS', 'BASE_VERSION', NULL, 'S', '100', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS', 'UPDATE_LEVEL', NULL, 'S', '100', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 3); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS', 'DISTRIBUTOR_VERSION', NULL, 'S', '100', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 4); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS', 'MAX_SWAP_SPACE_IN_MB', NULL, 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 5); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS', 'ADDRESS_LENGTH_IN_BITS', NULL, 'S', '20', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 6); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS', 'MAX_PROCESS_VIRTUAL_MEMORY', NULL, 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 7); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS', 'TIMEZONE', NULL, 'S', '64', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 8); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS', 'TIMEZONE_REGION', NULL, 'S', '64', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 9); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS', 'TIMEZONE_DELTA', NULL, 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 10); -- Register metadata for table MGMT_ECM_OS_PROPERTY INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_PROPERTY', NULL, 'N', 'N', 'Y', 'N', 'Y', 'MGMT_ECM_OS', 'N', 8); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_PROPERTY', 'SOURCE', NULL, 'S', '128', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_PROPERTY', 'NAME', NULL, 'S', '128', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_PROPERTY', 'VALUE', NULL, 'S', '2000', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 2); -- Register metadata for table MGMT_ECM_OS_COMPONENT INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_COMPONENT', NULL, 'N', 'N', 'Y', 'N', 'Y', 'MGMT_ECM_OS', 'N', 9); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_COMPONENT', 'NAME', NULL, 'S', '128', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_COMPONENT', 'TYPE', NULL, 'S', '100', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_COMPONENT', 'VERSION', NULL, 'S', '100', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_COMPONENT', 'DESCRIPTION', NULL, 'S', '2000', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 3); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_COMPONENT', 'INSTALLATION_DATE', NULL, 'D', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 4); -- Register metadata for table MGMT_ECM_OS_FILESYSTEM INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_FILESYSTEM', NULL, 'N', 'N', 'Y', 'N', 'Y', 'MGMT_ECM_OS', 'N', 10); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_FILESYSTEM', 'RESOURCE_NAME', NULL, 'S', '128', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_FILESYSTEM', 'MOUNT_LOCATION', NULL, 'S', '1024', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_FILESYSTEM', 'TYPE', NULL, 'S', '100', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_FILESYSTEM', 'DISK_SPACE_IN_GB', NULL, 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 3); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_FILESYSTEM', 'AVAIL_DISK_SPACE_IN_GB', NULL, 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 4); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_FILESYSTEM', 'LOCAL_DRIVE', NULL, 'S', '1', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 5); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_FILESYSTEM', 'MOUNT_OPTIONS', NULL, 'S', '1024', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 6); -- Register metadata for table MGMT_ECM_OS_REGISTERED_SW INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_REGISTERED_SW', NULL, 'N', 'N', 'Y', 'N', 'Y', NULL, 'N', 11); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_REGISTERED_SW', 'ID', NULL, 'S', '500', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_REGISTERED_SW', 'NAME', NULL, 'S', '128', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_REGISTERED_SW', 'VENDOR_NAME', NULL, 'S', '128', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_REGISTERED_SW', 'VERSION', NULL, 'S', '100', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 3); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_REGISTERED_SW', 'INSTALLATION_DATE', NULL, 'D', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 4); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_REGISTERED_SW', 'INSTALLED_LOCATION', NULL, 'S', '1024', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 5); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_REGISTERED_SW', 'DESCRIPTION', NULL, 'S', '2000', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 6); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_OS_REGISTERED_SW', 'VENDOR_SW_SPECIFIC_INFO', NULL, 'S', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 7); -- Register metadata for table MGMT_ECM_CSA_RULES INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_RULES', NULL, 'N', 'N', 'Y', 'N', 'Y', NULL, 'N', 12); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_RULES', 'NAME', NULL, 'S', '128', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 0); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_RULES', 'DESCRIPTION', NULL, 'S', '256', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 1); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_RULES', 'STATUS', NULL, 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 2); INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER) VALUES (metadata_id, 'MGMT_ECM_CSA_RULES', 'MOREINFO', NULL, 'S', '1024', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 3); END; / ALTER SESSION SET CONSTRAINTS = IMMEDIATE; COMMIT; -- End of metadata registration SET DEFINE ON /