-- --------------------------------------------------------

--
-- Table structure for table `device_models`
--

CREATE TABLE `device_models` (
  `id` int(11) NOT NULL,
  `model_name` varchar(200) DEFAULT NULL,
  `vendor_id` int(11) DEFAULT 1,
  `nagios_template` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Truncate table before insert `device_models`
--

TRUNCATE TABLE `device_models`;
--
-- Dumping data for table `device_models`
--

INSERT INTO `device_models` (`id`, `model_name`, `vendor_id`, `nagios_template`) VALUES
(1, '2011LS', 9, NULL),
(2, '2011UAS-2HnD', 9, NULL),
(3, 'AT-8000S', 8, NULL),
(4, 'AT-8100S/48POE', 8, NULL),
(5, 'AT-9000/28', 8, NULL),
(6, 'AT-GS950/24', 8, NULL),
(7, 'CCR1009-7G-1C-1S+', 9, NULL),
(8, 'CCR1036-8G-2S+', 9, NULL),
(10, 'CRS317-1G-16S+', 9, NULL),
(11, 'CRS326-24S+2Q+', 9, NULL),
(12, 'CRS328-24P-4S+', 9, NULL),
(14, 'CRS328-4C-20S-4S+', 9, NULL),
(15, 'DGS-3120-48TC', 7, NULL),
(16, 'ES-2024', 4, NULL),
(17, 'ES-2024A', 4, NULL),
(18, 'ES-2108', 4, NULL),
(19, 'ES-2108-G', 4, NULL),
(20, 'ES-3124-4F', 4, NULL),
(21, 'GS110TP', 10, NULL),
(22, 'GS-4024', 4, NULL),
(23, 'HP 1910', 15, NULL),
(24, 'ISCOM2110A-MA', 5, NULL),
(25, 'ISCOM2110EA-MA', 5, NULL),
(26, 'ISCOM2126EA-MA', 5, NULL),
(27, 'ISCOM2128EA-MA', 5, NULL),
(28, 'Linux server', 1, NULL),
(29, 'MES2124F', 2, NULL),
(30, 'MES2124MB', 2, NULL),
(31, 'MES5248', 2, NULL),
(32, 'RB2011UAS', 9, NULL),
(33, 'RB3011UiAS', 9, NULL),
(34, 'RB960PGS', 9, NULL),
(35, 'RBD52G-5HacD2HnD', 9, NULL),
(36, 'S2940-8G-v2', 6, NULL),
(37, 'S2980G-24T', 6, NULL),
(38, 'S3750G-24S-E', 6, NULL),
(39, 'S5300-52P-LI-AC', 3, NULL),
(40, 'S5320-52X-PWR-SI-AC', 3, NULL),
(41, 'S5321-28X-SI-AC', 3, NULL),
(42, 'S5321-52X-SI-AC', 3, NULL),
(43, 'S6320-54C-EI-48S-AC', 3, NULL),
(44, 'SNR-S2980G-24T', 6, NULL),
(45, 'V1910-16G', 15, NULL),
(46, 'V1910-24G-PoE', 15, NULL),
(47, 'Windows server', 1, NULL),
(48, 'WS-C2960G-24TC-L', 16, NULL),
(49, 'WS-C3560G-24TS-S', 16, NULL),
(50, 'x210-16GT', 8, NULL),
(51, 'x210-24GT', 8, NULL),
(52, 'x610-24Ts/X', 8, NULL),
(53, 'x610-48Ts', 8, NULL),
(54, 'XGS-4728', 4, NULL),
(55, 'ZyWall 310', 4, NULL),
(56, 'APC Smart-UPS_3000', 20, 'ups.cfg'),
(57, 'APC Smart-UPS_5000', 20, 'ups.cfg'),
(58, 'Schneider Smart-UPS_3000', 27, 'ups.cfg'),
(59, 'SMG-1016M', 2, NULL),
(60, 'EATON 9PX 1500i RT 2U', 24, 'ups.cfg'),
(61, 'EATON 9PX3000i_RT_2U', 24, 'ups.cfg'),
(62, 'EATON 9PX_6000i', 24, 'ups.cfg'),
(63, 'EATON PW9130_3000', 24, 'ups.cfg'),
(64, 'EATON PW9130_3000VA-R', 24, 'ups.cfg'),
(65, 'Epson WF-5620 Series', 26, 'epson.cfg'),
(66, 'Epson WF-8590 Series', 26, 'epson.cfg'),
(67, 'HP Officejet-7000', 15, 'hp.cfg'),
(68, 'OKI C610', 22, 'oki.cfg'),
(69, 'OKI MB472', 22, 'oki.cfg'),
(70, 'OKI MB491', 22, 'oki.cfg'),
(71, 'OKI MC562', 22, 'oki.cfg'),
(72, 'OKI MC573', 22, 'oki.cfg'),
(73, 'OKI MC861', 22, 'oki.cfg'),
(74, 'KX-MB2000RU', 21, 'panasonic.cfg'),
(75, 'PT-MZ10KE', 21, ''),
(76, 'PT-VX41', 21, 'proj.cfg'),
(77, 'Rave 522AA', 33, NULL),
(78, 'DZ570E', 21, 'proj.cfg'),
(79, 'DZ6700', 21, 'proj.cfg'),
(80, 'Rcq80', 21, 'proj.cfg'),
(81, 'RZ12K', 21, 'proj.cfg'),
(82, 'RZ660', 21, 'proj.cfg'),
(83, 'RZ770', 21, 'proj.cfg'),
(84, 'RZ970', 21, 'proj.cfg'),
(85, 'XVR-5216', 32, NULL),
(86, 'HWg-STE', 30, ''),
(87, 'Computer', 1, NULL),
(88, 'Mobile Phone', 1, NULL),
(89, 'Switch', 1, NULL),
(90, 'F22 1080p', 34, ''),
(91, 'ipad', 25, 'ipad.cfg'),
(92, 'AP4050DN-E', 3, NULL),
(93, 'AP4050DN', 3, NULL),
(94, 'DS-2CD2332-I', 29, 'ipcam.cfg'),
(95, 'DS-2CD2347G1-L', 29, 'ipcam.cfg'),
(96, 'DS-2CD2347G1-LU', 29, 'ipcam.cfg'),
(97, 'DS-2CD2422FWD-IW', 29, 'ipcam.cfg'),
(98, 'DS-2CD2432F-I', 29, 'ipcam.cfg'),
(99, 'DS-2CD2432F-IW', 29, 'ipcam.cfg'),
(100, 'DS-2CD2643G0-IZS', 29, 'ipcam.cfg'),
(101, 'DS-2CD2942F', 29, 'ipcam.cfg'),
(102, 'mPort', 11, NULL),
(103, 'Galaxy-S8', 23, NULL);