/*
 * @(#)Create_NSM_Extra.ddl	1.16 03/03/26
 *
 * Warning: This file was generated programmatically by mof2ddl.
 *          Do not make changes to this file or they will be lost!
 *
 * Copyright 2001-2003 Sun Microsystems, Inc. All Rights Reserved.
 *
 * This software is the confidential and proprietary information of Sun
 * Microsystems, Inc. ("Confidential Information").  You shall not
 * disclose such Confidential Information and shall use it only in
 * accordance with the terms of the license agreement you entered into
 * with Sun.
 *
 * SUN MAKES NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY OF
 * THE SOFTWARE, EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED
 * TO THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A
 * PARTICULAR PURPOSE, OR NON-INFRINGEMENT. SUN SHALL NOT BE LIABLE FOR
 * ANY DAMAGES SUFFERED BY LICENSEE AS A RESULT OF USING, MODIFYING OR
 * DISTRIBUTING THIS SOFTWARE OR ITS DERIVATIVES.
 */

-- DiscoveryTimestamp Table
CREATE TABLE DiscoveryTimestamp (
    passNumber INTEGER default 0,
    beginTimestamp TIMESTAMP,
    endTimestamp TIMESTAMP,
    status  VARCHAR default 'Unknown' -- It'll be safe to use enumeration for this
);

-- Topology caching info table
CREATE TABLE TopoGuiTimestamp (
    entry  INT,
    modelLastUpdate TIMESTAMP,
    topoRendering TIMESTAMP,
    guiRendering TIMESTAMP
);

INSERT INTO TopoGuiTimestamp (entry) VALUES (1);
-- This annotation may not be efficient at this time because
-- it may have null values. But this is inevitable due to referrence
-- to potential views instead of tables.
CREATE TABLE Annotation ( --- No key, duplicates are allowed.
    text SMALLINT[],
    ipaddr VARCHAR,
    ipeditable BOOLEAN default TRUE,
    StorageHostKey VARCHAR, -- may be NULL,This will be pointing to actual
    HBAKey VARCHAR, -- may be NULL          physical table.
    StorageSubSystemKey VARCHAR, -- may be NULL
    SwitchKey VARCHAR -- may be NULL
);
-- Users table for GUI
CREATE TABLE UserPO (
    auser VARCHAR PRIMARY KEY,
    role VARCHAR
);
-- Attribute table for GUI - they'll use this to store miscellaneous
-- attributes
CREATE TABLE GUIAttribute (
    akey VARCHAR PRIMARY KEY,
    value VARCHAR
);

-- ModelNode are retrieved by Topology Peresistence Manager
-- to build the topology graph
CREATE TABLE ModelNode
        (key            VARCHAR,
         type           VARCHAR,
         name           VARCHAR,
         vendor         VARCHAR,
         model          VARCHAR,
         parent         VARCHAR,
         status         VARCHAR,
         state          VARCHAR,
         wwn            VARCHAR,
         number         VARCHAR,
         attachedids    VARCHAR[],
         childids       VARCHAR[]
        )
;

/*
 * The following 2 tables are used during Porsche Discovery
 */
CREATE TABLE tmp_Volume
             (key                 VARCHAR,
              removable           BOOLEAN,
              deviceid            VARCHAR,
              capacity            NUMERIC,
              storagesubsystemkey VARCHAR)
;

CREATE TABLE tmp_LogicalDevice
             (key                 VARCHAR,
              removable           BOOLEAN,
              deviceid            VARCHAR,
              storagesubsystemkey VARCHAR)
;


/*----------------------------------------------------------------------------*
 *                                Alarm                                       *
 *----------------------------------------------------------------------------*/

CREATE TABLE Alarm (
              Subject VARCHAR
            , Source VARCHAR
            , SubjectTime BIGINT
            , SourceTime BIGINT
            , SourceSequenceNumber BIGINT
            , PostSequenceNumber VARCHAR
            , Topic VARCHAR
            , Severity INTEGER
            , Type VARCHAR
            , AgentType VARCHAR
            , AgentUrl VARCHAR
            , TTL BIGINT
            , SerializedEvent TEXT
            , PRIMARY KEY (Source, SourceSequenceNumber)
    );



/*
 * The following ddl are for performance tuning.
 */

CREATE INDEX CIM_SystemDevice_PartComponent 
       ON CIM_SystemDevice (PartComponent)
;
CREATE INDEX CIM_SystemDevice_GroupComponent 
       ON CIM_SystemDevice (GroupComponent)
;


CREATE INDEX CIM_Realizes_Antecedent
       ON CIM_Realizes (Antecedent)
;
CREATE INDEX CIM_Realizes_Dependent
       ON CIM_Realizes (Dependent)
;

CREATE INDEX cim_devicesoftware_Antecedent
       ON cim_devicesoftware (Antecedent)
;
CREATE INDEX cim_devicesoftware_Dependent
       ON cim_devicesoftware (Dependent)
;
CREATE INDEX cim_deviceidentity_systemelement
       ON cim_deviceidentity (systemelement)
;
CREATE INDEX cim_deviceidentity_sameelement 
       ON cim_deviceidentity (sameelement)
;


--
--  Look up tables for Enumeration types
--

-- until these are generated, put lookup tables in here for integer to
-- English values.  There's an internationalization issue here.

-- device_state_lookup; taken from mof for CIM_LogicalDevice.Availability
CREATE TABLE device_state_lookup (
	      IntValue INTEGER PRIMARY KEY
            , ToEnglish VARCHAR
    );
INSERT INTO device_state_lookup (IntValue, ToEnglish) VALUES (
	1, 'Other'
    );
INSERT INTO device_state_lookup (IntValue, ToEnglish) VALUES (
	2, 'Unknown'
    );
INSERT INTO device_state_lookup (IntValue, ToEnglish) VALUES (
	3, 'Running/Full Power'
    );
INSERT INTO device_state_lookup (IntValue, ToEnglish) VALUES (
	4, 'Warning'
    );
INSERT INTO device_state_lookup (IntValue, ToEnglish) VALUES (
	5, 'In Test'
    );
INSERT INTO device_state_lookup (IntValue, ToEnglish) VALUES (
	6, 'Not Applicable'
    );
INSERT INTO device_state_lookup (IntValue, ToEnglish) VALUES (
	7, 'Power Off'
    );
INSERT INTO device_state_lookup (IntValue, ToEnglish) VALUES (
	8, 'Off Line'
    );
INSERT INTO device_state_lookup (IntValue, ToEnglish) VALUES (
	9, 'Off Duty'
    );
INSERT INTO device_state_lookup (IntValue, ToEnglish) VALUES (
	10, 'Degraded'
    );
INSERT INTO device_state_lookup (IntValue, ToEnglish) VALUES (
	11, 'Not Installed'
    );
INSERT INTO device_state_lookup (IntValue, ToEnglish) VALUES (
	12, 'Install Error'
    );
INSERT INTO device_state_lookup (IntValue, ToEnglish) VALUES (
	13, 'Power Save - Unknown'
    );
INSERT INTO device_state_lookup (IntValue, ToEnglish) VALUES (
	14, 'Power Save - Low Power Mode'
    );
INSERT INTO device_state_lookup (IntValue, ToEnglish) VALUES (
	15, 'Power Save - Standby'
    );
INSERT INTO device_state_lookup (IntValue, ToEnglish) VALUES (
	16, 'Power Cycle'
    );
INSERT INTO device_state_lookup (IntValue, ToEnglish) VALUES (
	17, 'Power Save - Warning'
    );
INSERT INTO device_state_lookup (IntValue, ToEnglish) VALUES (
	18, 'Paused'
    );
INSERT INTO device_state_lookup (IntValue, ToEnglish) VALUES (
	19, 'Not Ready'
    );
INSERT INTO device_state_lookup (IntValue, ToEnglish) VALUES (
	20, 'Not Configured'
    );
INSERT INTO device_state_lookup (IntValue, ToEnglish) VALUES (
	21, 'Quiesced'
    );

-- gbic_type_lookup; taken from mof for CIM_PhysicalConnector.ConnectorType
CREATE TABLE gbic_type_lookup (
	      IntValue INTEGER PRIMARY KEY
            , ToEnglish VARCHAR
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	0, 'Unknown'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	1, 'Other'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	2, 'Male'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	3, 'Female'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	4, 'Shielded'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	5, 'Unshielded'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	6, 'SCSI (A) High-Density (50 pins)'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	7, 'SCSI (A) Low-Density (50 pins)'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	8, 'SCSI (P) High-Density (68 pins)'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	9, 'SCSI SCA-I (80 pins)'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	10, 'SCSI SCA-II (80 pins)'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	11, 'Fibre Channel (DB-9, Copper)'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	12, 'Fibre Channel (Optical Fibre)'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	13, 'Fibre Channel SCA-II (40 pins)'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	14, 'Fibre Channel SCA-II (20 pins)'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	15, 'Fibre Channel BNC'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	16, 'ATA 3-1/2 Inch (40 pins)'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	17, 'ATA 2-1/2 Inch (44 pins)'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	18, 'ATA-2'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	19, 'ATA-3'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	20, 'ATA/66'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	21, 'DB-9'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	22, 'DB-15'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	23, 'DB-25'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	24, 'DB-36'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	25, 'RS-232C'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	26, 'RS-422'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	27, 'RS-423'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	28, 'RS-485'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	29, 'RS-449'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	30, 'V.35'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	31, 'X.21'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	32, 'IEEE-488'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	33, 'AUI'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	34, 'UPT Category 3'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	35, 'UPT Category 4'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	36, 'UPT Category 5'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	37, 'BNC'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	38, 'RJ11'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	39, 'RJ45'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	40, 'Fiber MIC'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	41, 'Apple AUI'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	42, 'Apple GeoPort'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	43, 'PCI'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	44, 'ISA'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	45, 'EISA'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	46, 'VESA'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	47, 'PCMCIA'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	48, 'PCMCIA Type I'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	49, 'PCMCIA Type II'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	50, 'PCMCIA Type III'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	51, 'ZV Port'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	52, 'CardBus'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	53, 'USB'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	54, 'IEEE 1394'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	55, 'HIPPI'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	56, 'HSSDC (6 pins)'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	57, 'GBIC'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	58, 'DIN'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	59, 'Mini-DIN'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	60, 'Micro-DIN'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	61, 'PS/2'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	62, 'Infrared'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	63, 'HP-HIL'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	64, 'Access.bus'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	65, 'NuBus'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	66, 'Centronics'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	67, 'Mini-Centronics'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	68, 'Mini-Centronics Type-14'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	69, 'Mini-Centronics Type-20'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	70, 'Mini-Centronics Type-26'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	71, 'Bus Mouse'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	72, 'ADB'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	73, 'AGP'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	74, 'VME Bus'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	75, 'VME64'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	76, 'Proprietary'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	77, 'Proprietary Processor Card Slot'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	78, 'Proprietary Memory Card Slot'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	79, 'Proprietary I/O Riser Slot'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	80, 'PCI-66MHZ'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	81, 'AGP2X'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	82, 'AGP4X'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	83, 'PC-98'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	84, 'PC-98-Hireso'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	85, 'PC-H98'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	86, 'PC-98Note'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	87, 'PC-98Full'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	88, 'SSA SCSI'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	89, 'Circular'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	90, 'On Board IDE Connector'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	91, 'On Board Floppy Connector'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	92, '9 Pin Dual Inline'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	93, '25 Pin Dual Inline'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	94, '50 Pin Dual Inline'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	95, '68 Pin Dual Inline'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	96, 'On Board Sound Connector'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	97, 'Mini-jack'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	98, 'PCI-X'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	99, 'Sbus IEEE 1396-1993 32 bit'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	100, 'Sbus IEEE 1396-1993 64 bit'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	101, 'MCA'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	102, 'GIO'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	103, 'XIO'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	104, 'HIO'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	105, 'NGIO'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	106, 'PMC'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	107, 'MTRJ'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	108, 'VF-45'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	109, 'Future I/O'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	110, 'SC'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	111, 'SG'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	112, 'Electrical'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	113, 'Optical'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	114, 'Ribbon'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	115, 'GLM'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	116, '1x9'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	117, 'Mini SG'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	118, 'LC'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	119, 'HSSC'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	120, 'VHDCI Shielded (68 pins)'
    );
INSERT INTO gbic_type_lookup (IntValue, ToEnglish) VALUES (
	121, 'InfiniBand'
    );



-- zone_type_lookup; taken from mof for CIM_Zone.ZoneType
CREATE TABLE zone_type_lookup (
	      IntValue INTEGER PRIMARY KEY
            , ToEnglish VARCHAR
    );
INSERT INTO zone_type_lookup (IntValue, ToEnglish) VALUES (
	0, 'Unknown'
    );
INSERT INTO zone_type_lookup (IntValue, ToEnglish) VALUES (
	1, 'Other'
    );
INSERT INTO zone_type_lookup (IntValue, ToEnglish) VALUES (
	2, 'FCP'
    );
INSERT INTO zone_type_lookup (IntValue, ToEnglish) VALUES (
	3, 'VI'
    );
INSERT INTO zone_type_lookup (IntValue, ToEnglish) VALUES (
	4, 'IP'
    );

-- port_type_lookup; taken from mof for CIM_FCPort.PortType
CREATE TABLE port_type_lookup (
	      IntValue INTEGER PRIMARY KEY
            , ToEnglish VARCHAR
    );
INSERT INTO port_type_lookup (IntValue, ToEnglish) VALUES (
	0, 'Unknown'
    );
INSERT INTO port_type_lookup (IntValue, ToEnglish) VALUES (
	1, 'Other'
    );
INSERT INTO port_type_lookup (IntValue, ToEnglish) VALUES (
	300, 'N'
    );
INSERT INTO port_type_lookup (IntValue, ToEnglish) VALUES (
	301, 'NL'
    );
INSERT INTO port_type_lookup (IntValue, ToEnglish) VALUES (
	302, 'F/NL'
    );
INSERT INTO port_type_lookup (IntValue, ToEnglish) VALUES (
	303, 'Nx'
    );
INSERT INTO port_type_lookup (IntValue, ToEnglish) VALUES (
	304, 'E'
    );
INSERT INTO port_type_lookup (IntValue, ToEnglish) VALUES (
	305, 'F'
    );
INSERT INTO port_type_lookup (IntValue, ToEnglish) VALUES (
	306, 'FL'
    );
INSERT INTO port_type_lookup (IntValue, ToEnglish) VALUES (
	307, 'B'
    );
