Logo
Explore Help
Sign In
mirror/librenms-librenms
1
0
Fork 0
You've already forked librenms-librenms
mirror of https://github.com/librenms/librenms.git synced 2024-10-07 16:52:45 +00:00
Code Issues Actions Packages Projects Releases Wiki Activity
Files
1.34
librenms-librenms/sql-schema/198.sql

5 lines
250 B
MySQL
Raw Permalink Normal View History

feature: Support fdb table on generic devices (#6902) * feature: support fdb table on generic devices refactored code to use snmpwalk_group refactored ajax table code to use joins and reduce extra queries add indexes for device_id and port_id, drop primary index Make all columns sortable Fix a few other small issues * Add index for vlan_id since that field can be searched by the user * fix whitespace * Rename 197.sql to 198.sql * set row count for table
2017-06-29 15:03:56 -05:00
ALTER TABLE `ports_fdb` DROP `ports_fdb_id`;
CREATE INDEX `ports_fdb_port_id_index` ON `ports_fdb` (`port_id`);
CREATE INDEX `ports_fdb_device_id_index` ON `ports_fdb` (`device_id`);
CREATE INDEX `ports_fdb_vlan_id_index` ON `ports_fdb` (`vlan_id`);
Reference in New Issue Copy Permalink
Powered by Gitea Page: 1315ms Template: 1ms
edge-auto
English
Bahasa Indonesia Deutsch English Español Français Gaeilge Italiano Latviešu Magyar nyelv Nederlands Polski Português de Portugal Português do Brasil Suomi Svenska Türkçe Čeština Ελληνικά Български Русский Українська فارسی മലയാളം 日本語 简体中文 繁體中文(台灣) 繁體中文(香港) 한국어
Licenses API