types.sql

Network Administration Visualized 网络管理可视化源码

-- This SQL script inserts initial equipment vendors and types in the NAV
-- manage database.
--
-- It is not necessary to run this script in a transaction.  If executed on a
-- running installation, types and vendors that already exist will generate
-- errors, while the rest will be inserted as new records.


-- First, vendors
INSERT INTO vendor (vendorid) VALUES ('alcatel');
INSERT INTO vendor (vendorid) VALUES ('allied');
INSERT INTO vendor (vendorid) VALUES ('avaya');
INSERT INTO vendor (vendorid) VALUES ('breezecom');
INSERT INTO vendor (vendorid) VALUES ('cisco');
INSERT INTO vendor (vendorid) VALUES ('dlink');
INSERT INTO vendor (vendorid) VALUES ('hp');
INSERT INTO vendor (vendorid) VALUES ('symbol');
INSERT INTO vendor (vendorid) VALUES ('3com');
INSERT INTO vendor (vendorid) VALUES ('nortel');


-- Then types
INSERT INTO "type" (vendorid, typename, sysobjectid, cdp, tftp, cs_at_vlan, chassis, frequency, descr) VALUES ('3com', 'PS40', '1.3.6.1.4.1.43.10.27.4.1', false, false, false, true, 3600, 'Portstack 40 hub');
INSERT INTO "type" (vendorid, typename, sysobjectid, cdp, tftp, cs_at_vlan, chassis, frequency, descr) VALUES ('3com', 'SW1100', '1.3.6.1.4.1.43.10.27.4.1.2.1', NULL, NULL, false, true, 3600, 'Portswitch 1100');
INSERT INTO "type" (vendorid, typename, sysobjectid, cdp, tftp, cs_at_vlan, chassis, frequency, descr) VALUES ('3com', 'SW3300', '1.3.6.1.4.1.43.10.27.4.1.2.2', NULL, NULL, false, true, 3600, 'Portswitch 3300');
INSERT INTO "type" (vendorid, typename, sysobjectid, cdp, tftp, cs_at_vlan, chassis, frequency, descr) VALUES ('3com', 'SW9300', '1.3.6.1.4.1.43.1.16.2.2.2.1', NULL, NULL, false, true, 3600, 'Portswitch 9300');
INSERT INTO "type" (vendorid, typename, sysobjectid, cdp, tftp, cs_at_vlan, chassis, frequency, descr) VALUES ('alcatel', 'alcatel6800', '1.3.6.1.4.1.6486.800.1.1.2.1.6.1.1', NULL, NULL, false, false, 3600, 'Alcatel Omniswitch 6800');
INSERT INTO "type" (vendorid, typename, sysobjectid, cdp, tftp, cs_at_vlan, chassis, frequency, descr) VALUES ('cisco', 'catalyst2924XL', '1.3.6.1.4.1.9.1.183', true, true, true, true, 3600, 'Catalyst 2924 XL switch');
INSERT INTO "type" (vendorid, typename, sysobjectid, cdp, tftp, cs_at_vlan, chassis, frequency, descr) VALUES ('cisco', 'catalyst2924XLv', '1.3.6.1.4.1.9.1.217', true, true, true, false, 3600, 'Catalyst 2924 XLv switch');
INSERT INTO "type" (vendorid, typename, sysobjectid, cdp, tftp, cs_at_vlan, chassis, frequency, descr) VALUES ('cisco', 'catalyst295024', '1.3.6.1.4.1.9.1.324', true, true, NULL, true, 3600, 'Catalyst 2950-24');
INSERT INTO "type" (vendorid, typename, sysobjectid, cdp, tftp, cs_at_vlan, chassis, frequency, descr) VALUES ('cisco', 'catalyst295024G', '1.3.6.1.4.1.9.1.428', true, true, true, false, 3600, 'Catalyst 2950G-24-E1 switch');
INSERT INTO "type" (vendorid, typename, sysobjectid, cdp, tftp, cs_at_vlan, chassis, frequency, descr) VALUES ('cisco', 'catalyst295048G', '1.3.6.1.4.1.9.1.429', true, true, true, false, 3600, 'Catalyst 295048G');
INSERT INTO "type" (vendorid, typename, sysobjectid, cdp, tftp, cs_at_vlan, chassis, frequency, descr) VALUES ('cisco', 'catalyst297024TS', '1.3.6.1.4.1.9.1.561', true, true, true, true, 3600, 'Catalyst 2970');
INSERT INTO "type" (vendorid, typename, sysobjectid, cdp, tftp, cs_at_vlan, chassis, frequency, descr) VALUES ('cisco', 'catalyst3508GXL', '1.3.6.1.4.1.9.1.246', true, true, true, true, 3600, 'Catalyst 3508 GXL switch');
INSERT INTO "type" (vendorid, typename, sysobjectid, cdp, tftp, cs_at_vlan, chassis, frequency, descr) VALUES ('cisco', 'catalyst3524XL', '1.3.6.1.4.1.9.1.248', true, true, true, true, 3600, 'Catalyst 3524 XL switch');
INSERT INTO "type" (vendorid, typename, sysobjectid, cdp, tftp, cs_at_vlan, chassis, frequency, descr) VALUES ('cisco', 'catalyst3524tXLEn', '1.3.6.1.4.1.9.1.287', true, true, true, false, 3600, 'Catalyst 3524tXLEn');
INSERT INTO "type" (vendorid, typename, sysobjectid, cdp, tftp, cs_at_vlan, chassis, frequency, descr) VALUES ('cisco', 'catalyst375024ME', '1.3.6.1.4.1.9.1.574', true, true, true, false, 3600, 'Catalyst 3750 Metro');
INSERT INTO "type" (vendorid, typename, sysobjectid, cdp, tftp, cs_at_vlan, chassis, frequency, descr) VALUES ('cisco', 'catalyst37xxStack', '1.3.6.1.4.1.9.1.516', true, true, true, true, 3600, 'Catalyst 3750');
INSERT INTO "type" (vendorid, typename, sysobjectid, cdp, tftp, cs_at_vlan, chassis, frequency, descr) VALUES ('cisco', 'catalyst4003', '1.3.6.1.4.1.9.5.40', true, true, true, true, 3600, 'Catalyst 4003');
INSERT INTO "type" (vendorid, typename, sysobjectid, cdp, tftp, cs_at_vlan, chassis, frequency, descr) VALUES ('cisco', 'catalyst4006', '1.3.6.1.4.1.9.1.448', true, true, true, true, 3600, 'Catalyst 4006 sup 2 L3 switch');
INSERT INTO "type" (vendorid, typename, sysobjectid, cdp, tftp, cs_at_vlan, chassis, frequency, descr) VALUES ('cisco', 'catalyst4506', '1.3.6.1.4.1.9.1.502', true, true, true, true, 3600, 'Catalyst 4506 sup4 L3 switch');
INSERT INTO "type" (vendorid, typename, sysobjectid, cdp, tftp, cs_at_vlan, chassis, frequency, descr) VALUES ('cisco', 'catalyst4510', '1.3.6.1.4.1.9.1.537', true, true, NULL, true, 3600, 'Catalyst 4510');
INSERT INTO "type" (vendorid, typename, sysobjectid, cdp, tftp, cs_at_vlan, chassis, frequency, descr) VALUES ('cisco', 'catalyst6509', '1.3.6.1.4.1.9.1.283', true, true, true, true, 3600, 'Catalyst 6509');
INSERT INTO "type" (vendorid, typename, sysobjectid, cdp, tftp, cs_at_vlan, chassis, frequency, descr) VALUES ('cisco', 'cisco1000', '1.3.6.1.4.1.9.1.40', true, true, NULL, true, 3600, 'Cisco 1000 Router');
INSERT INTO "type" (vendorid, typename, sysobjectid, cdp, tftp, cs_at_vlan, chassis, frequency, descr) VALUES ('cisco', 'cisco1003', '1.3.6.1.4.1.9.1.41', true, true, NULL, true, 3600, 'Cisco 1003 Router');
INSERT INTO "type" (vendorid, typename, sysobjectid, cdp, tftp, cs_at_vlan, chassis, frequency, descr) VALUES ('cisco', 'cisco1005', '1.3.6.1.4.1.9.1.49', true, true, false, true, 3600, 'Cisco 1005 Router');
INSERT INTO "type" (vendorid, typename, sysobjectid, cdp, tftp, cs_at_vlan, chassis, frequency, descr) VALUES ('cisco', 'cisco10720', '1.3.6.1.4.1.9.1.397', true, true, true, true, 3600, 'Cisco 10720 (YB) Router');
INSERT INTO "type" (vendorid, typename, sysobjectid, cdp, tftp, cs_at_vlan, chassis, frequency, descr) VALUES ('cisco', 'cisco12016', '1.3.6.1.4.1.9.1.273', true, true, true, true, 3600, 'Cisco 12016 (GSR) Router');