Rem
Rem $Header: ecm_aru_data.sql 20-nov-2006.02:57:14 mningomb Exp $
Rem
Rem ecm_aru_data.sql
Rem
Rem Copyright (c) 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      ecm_aru_data.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    mningomb    11/20/06 - Migrating Platforms information to
Rem                           ecm_aru_info_load.sql
Rem    rrawat      09/25/06 - bug-5546644
Rem    rrawat      09/25/06 - Created
Rem

SET ECHO ON
SET FEEDBACK 1
SET NUMWIDTH 10
SET LINESIZE 80
SET TRIMSPOOL ON
SET TAB OFF
SET PAGESIZE 100


-- insert platforms information

-- Note: section for platforms has been removed from this file, insert into MGMT_ARU_PLATFORMS is already being done in file ecm_aru_info_load.sql



-- Correct entries in MGMT_ECM_ARU_MAP

DELETE from MGMT_ECM_ARU_MAP WHERE ARU_ID IN (197,162,601,226,38,89);

BEGIN
INSERT into MGMT_ECM_ARU_MAP
    (ARU_ID, DISPLAY_STRING, EM_NAME, EM_BITLENGTH, CATEGORY)
  VALUES (197,'HP-UX Itanium','HP-UX','64','platform');
INSERT into MGMT_ECM_ARU_MAP
    (ARU_ID, DISPLAY_STRING, EM_NAME, EM_BITLENGTH, CATEGORY)
  VALUES (162, 'Data General AViiON M88K DG', 'DG/UX', '64','platform');
INSERT into MGMT_ECM_ARU_MAP
    (ARU_ID, DISPLAY_STRING, EM_NAME, EM_BITLENGTH, CATEGORY)
   VALUES (601, 'HP Alpha Windows NT', 'Windows NT', '64','platform');
INSERT into MGMT_ECM_ARU_MAP
    (ARU_ID, DISPLAY_STRING, EM_NAME, EM_BITLENGTH, CATEGORY)
  VALUES (226, 'Linux x86-64 (AMD64/EM64T)', 'Linux', '64','platform');
INSERT into MGMT_ECM_ARU_MAP
    (ARU_ID, DISPLAY_STRING, EM_NAME, EM_BITLENGTH, CATEGORY)  
  VALUES (38, 'AIX 4.3 Based Systems (64-bit)', 'Unknown', '64','platform');
INSERT into MGMT_ECM_ARU_MAP
    (ARU_ID, DISPLAY_STRING, EM_NAME, EM_BITLENGTH, CATEGORY)  
  VALUES (89, 'HP OpenVMS Alpha', 'OpenVMS', '64','platform');

COMMIT;
END;
/
-- Populate the MGMT_OUI_ARU_MAP table 
DELETE FROM MGMT_OUI_ARU_MAP;
BEGIN
INSERT INTO MGMT_OUI_ARU_MAP (OUI_ID, ARU_ID) VALUES (912,912);
INSERT INTO MGMT_OUI_ARU_MAP (OUI_ID, ARU_ID) VALUES (208,208);
INSERT INTO MGMT_OUI_ARU_MAP (OUI_ID, ARU_ID) VALUES (233,233);
INSERT INTO MGMT_OUI_ARU_MAP (OUI_ID, ARU_ID) VALUES (615,615);
INSERT INTO MGMT_OUI_ARU_MAP (OUI_ID, ARU_ID) VALUES (50,50);
INSERT INTO MGMT_OUI_ARU_MAP (OUI_ID, ARU_ID) VALUES (46,46);
INSERT INTO MGMT_OUI_ARU_MAP (OUI_ID, ARU_ID) VALUES (211,209);
INSERT INTO MGMT_OUI_ARU_MAP (OUI_ID, ARU_ID) VALUES (197,197);
INSERT INTO MGMT_OUI_ARU_MAP (OUI_ID, ARU_ID) VALUES (110,214);
INSERT INTO MGMT_OUI_ARU_MAP (OUI_ID, ARU_ID) VALUES (453,453);
INSERT INTO MGMT_OUI_ARU_MAP (OUI_ID, ARU_ID) VALUES (601,601);
INSERT INTO MGMT_OUI_ARU_MAP (OUI_ID, ARU_ID) VALUES (173,173);
INSERT INTO MGMT_OUI_ARU_MAP (OUI_ID, ARU_ID) VALUES (295,295);
INSERT INTO MGMT_OUI_ARU_MAP (OUI_ID, ARU_ID) VALUES (87,87);
INSERT INTO MGMT_OUI_ARU_MAP (OUI_ID, ARU_ID) VALUES (610,212);
INSERT INTO MGMT_OUI_ARU_MAP (OUI_ID, ARU_ID) VALUES (198,198);
INSERT INTO MGMT_OUI_ARU_MAP (OUI_ID, ARU_ID) VALUES (918,501);
INSERT INTO MGMT_OUI_ARU_MAP (OUI_ID, ARU_ID) VALUES (913,89);
INSERT INTO MGMT_OUI_ARU_MAP (OUI_ID, ARU_ID) VALUES (162,162);
INSERT INTO MGMT_OUI_ARU_MAP (OUI_ID, ARU_ID) VALUES (2,59);
INSERT INTO MGMT_OUI_ARU_MAP (OUI_ID, ARU_ID) VALUES (30,30);
INSERT INTO MGMT_OUI_ARU_MAP (OUI_ID, ARU_ID) VALUES (21,21);
INSERT INTO MGMT_OUI_ARU_MAP (OUI_ID, ARU_ID) VALUES (111,476);
INSERT INTO MGMT_OUI_ARU_MAP (OUI_ID, ARU_ID) VALUES (168,168);
INSERT INTO MGMT_OUI_ARU_MAP (OUI_ID, ARU_ID) VALUES (888,888);
INSERT INTO MGMT_OUI_ARU_MAP (OUI_ID, ARU_ID) VALUES (23,23);
INSERT INTO MGMT_OUI_ARU_MAP (OUI_ID, ARU_ID) VALUES (38,28);
COMMIT;
END;
/