1
0

stat_table_vendors.sql 921 B

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
  1. -- --------------------------------------------------------
  2. --
  3. -- Table structure for table `vendors`
  4. --
  5. CREATE TABLE `vendors` (
  6. `id` int(11) NOT NULL,
  7. `name` varchar(80) NOT NULL
  8. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  9. --
  10. -- Truncate table before insert `vendors`
  11. --
  12. TRUNCATE TABLE `vendors`;
  13. --
  14. -- Dumping data for table `vendors`
  15. --
  16. INSERT INTO `vendors` (`id`, `name`) VALUES
  17. (1, 'Unknown'),
  18. (2, 'Eltex'),
  19. (3, 'Huawei'),
  20. (4, 'Zyxel'),
  21. (5, 'Raisecom'),
  22. (6, 'SNR'),
  23. (7, 'Dlink'),
  24. (8, 'Allied Telesis'),
  25. (9, 'Mikrotik'),
  26. (10, 'NetGear'),
  27. (11, 'Ubiquiti'),
  28. (15, 'HP'),
  29. (16, 'Cisco'),
  30. (17, 'Maipu'),
  31. (18, 'Asus'),
  32. (19, 'Linux'),
  33. (20, 'APC'),
  34. (21, 'Panasonic'),
  35. (22, 'OKI'),
  36. (23, 'Samsung'),
  37. (24, 'EATON'),
  38. (25, 'Apple'),
  39. (26, 'Epson'),
  40. (27, 'Schneider'),
  41. (28, 'Avaya'),
  42. (29, 'Hikvision'),
  43. (30, 'HW-group'),
  44. (31, 'Netping'),
  45. (32, 'Trassir'),
  46. (33, 'QSC'),
  47. (34, 'Projectiondesign'),
  48. (35, 'Lenovo'),
  49. (36, 'SIPOWER');