mirror/librenms-librenms
1
0
Fork 0
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
analysis-rrGdgx
librenms-librenms/sql-schema
History
…
..
001.sql
…
002.sql
feature: Add mysql failed query logging + fixed queries that break ONLY_FULL_GROUP_BY (#5327)
2017-01-07 11:32:38 -06:00
003.sql
…
004.sql
…
005.sql
…
006.sql
…
007.sql
…
008.sql
fix the fix
2012-03-20 16:11:31 +00:00
009.sql
fix the fix
2012-03-20 16:11:31 +00:00
010.sql
…
011.sql
add table to store packages data on package-managed hosts
2012-03-26 13:06:23 +00:00
012.sql
add IPSLA support
2012-04-09 12:53:44 +00:00
013.sql
tests: test each db schema file for proper format (#6580)
2017-05-04 21:14:14 +01:00
014.sql
additions to unix-agent. addition of basic munin-plugin support.
2012-04-26 11:57:52 +00:00
015.sql
add memcached application graphing support. move applications to <<<app-$name>>> for easier detection. add connection tracking to mysql application. move logout to /logout/ not
2012-04-27 17:18:26 +00:00
016.sql
more memcached
2012-05-02 15:06:12 +00:00
017.sql
tests: test each db schema file for proper format (#6580)
2017-05-04 21:14:14 +01:00
018.sql
updates to pseudowires table
2012-05-03 09:04:39 +00:00
019.sql
repoll toner capacity
2012-05-06 19:56:06 +00:00
020.sql
…
021.sql
db fixes (needed for snmpv3 sha fix)
2012-05-15 17:16:16 +00:00
022.sql
…
023.sql
some database updates (adding some _deleted fields) and fix links table.
2012-05-17 10:33:56 +00:00
024.sql
…
025.sql
…
026.sql
accesspoint support (probably) from ethan sommer (#50)
2012-05-21 18:17:23 +00:00
027.sql
…
028.sql
…
029.sql
Updated session / cookie support
2014-02-03 22:39:37 +00:00
030.sql
…
031.sql
Added new health admin page for thresholds
2014-06-14 23:10:53 +01:00
032.sql
Remove graph_types definitions from DB (#9618)
2019-01-08 13:46:45 -06:00
033.sql
More updates to api
2014-09-16 22:19:28 +01:00
034.sql
Increase API token length to allow for future growth
2014-09-27 14:49:33 +10:00
035.sql
Added sql schema update for ping graphs
2014-09-30 19:13:51 +01:00
036.sql
feature: Add mysql failed query logging + fixed queries that break ONLY_FULL_GROUP_BY (#5327)
2017-01-07 11:32:38 -06:00
037.sql
Added ability to name alert rules
2014-12-21 15:44:50 +00:00
038.sql
Added TwoFactor Authentication (RFC4226)
2014-12-28 15:40:40 +00:00
039.sql
Added:
2015-01-15 07:18:10 +00:00
040.sql
…
041.sql
…
042.sql
…
043.sql
Added support for managing poller groups and viewing poller stats
2015-03-15 21:44:35 +00:00
044.sql
…
045.sql
…
046.sql
…
047.sql
Added alter statement to add index to alert_log table
2015-04-12 14:57:51 +01:00
048.sql
…
049.sql
…
050.sql
Added a new db field to record when custom high/low limits are set and stop them being overwrote
2015-05-12 10:10:03 +01:00
051.sql
feature: Added new alert rule builder UI and rule mapping UI (#8293)
2018-03-14 20:25:19 +00:00
052.sql
tests: test each db schema file for proper format (#6580)
2017-05-04 21:14:14 +01:00
053.sql
tests: test each db schema file for proper format (#6580)
2017-05-04 21:14:14 +01:00
054.sql
Add missing SQL schema
2015-06-16 08:27:58 +10:00
055.sql
feature: Added new alert rule builder UI and rule mapping UI (#8293)
2018-03-14 20:25:19 +00:00
056.sql
feature: Added new alert rule builder UI and rule mapping UI (#8293)
2018-03-14 20:25:19 +00:00
057.sql
fix: add semicolons in build.sql schema file (#6284)
2017-03-28 16:15:17 +01:00
058.sql
Updated to use new table name
2015-07-23 18:41:41 +01:00
059.sql
Rebased
2015-07-26 11:09:46 +00:00
060.sql
Added Syslog, Eventlog and Globe Map widgets
2015-08-01 15:36:15 +00:00
061.sql
Added proper indexes to the device_perf table
2015-08-05 19:01:03 +00:00
062.sql
Fix #1670
2015-08-14 20:54:56 +02:00
063.sql
updated sql file #
2015-08-16 11:12:24 +00:00
064.sql
…
065.sql
index and limit
2015-08-25 11:35:22 -04:00
066.sql
…
067.sql
…
068.sql
Added generic graph widget (non-responsive sizing)
2015-09-05 16:32:38 +01:00
069.sql
…
070.sql
…
071.sql
…
072.sql
Add Device Notes Field
2015-09-17 16:19:48 +02:00
073.sql
Remove graph_types definitions from DB (#9618)
2019-01-08 13:46:45 -06:00
074.sql
Example for adding new dynamic config options for WebUI
2015-10-12 22:06:17 +00:00
075.sql
Added ability to globally disable sending alerts
2015-11-04 20:29:02 +00:00
076.sql
Added support for per device unix-agent port
2015-11-17 00:20:06 +00:00
077.sql
Automatically mark all news as read for new users
2015-11-21 11:40:24 +00:00
078.sql
…
079.sql
Rebased from upstream
2015-12-01 21:50:13 +00:00
080.sql
Added Notes widet
2015-12-08 20:34:32 +00:00
081.sql
Added lastupdate column which will always use NOW() when doing a dbUpdate
2015-12-09 19:31:28 +00:00
082.sql
…
083.sql
Added generic image widget
2015-12-13 18:24:26 +00:00
084.sql
…
085.sql
…
086.sql
Update 086.sql
2016-01-07 21:48:16 +01:00
087.sql
Added datetime to notifications + Fixed sticky/unsticky notifications disappearing
2016-01-10 22:22:13 +00:00
088.sql
Renamed file to stop conflict
2016-01-10 22:47:40 +00:00
089.sql
Added missing column to perf_times table
2016-01-17 15:46:33 +00:00
090.sql
…
091.sql
feature: Added new alert rule builder UI and rule mapping UI (#8293)
2018-03-14 20:25:19 +00:00
092.sql
…
093.sql
Tidy mess left by CISCO-AAA-SESSION-MIB bug
2016-01-21 08:54:00 +10:00
094.sql
Updated to check table exists
2016-01-24 23:38:30 +00:00
095.sql
…
096.sql
Update discovery and poller to allow stable interface mapping by ifName/ifDescr based port mapping.
2016-01-26 13:49:30 +01:00
097.sql
merging
2016-02-08 20:12:05 +01:00
098.sql
…
099.sql
Added ifOperStatus and ifAdminStatus _prev values to db.
2016-02-02 13:47:13 +00:00
100.sql
Merge branch 'issue-386-v3' of git://github.com/BarbarossaTM/librenms
2016-02-07 15:23:52 +00:00
101.sql
…
102.sql
…
103.sql
tests: test each db schema file for proper format (#6580)
2017-05-04 21:14:14 +01:00
104.sql
Modified schema to enlarge device's purpose field
2016-02-24 13:21:31 +01:00
105.sql
…
106.sql
…
107.sql
…
108.sql
…
109.sql
Set config_name as a unique index
2016-03-18 23:20:02 -05:00
110.sql
…
111.sql
…
112.sql
…
113.sql
…
114.sql
…
115.sql
…
116.sql
…
117.sql
Change SQL file name and add /alerts support for procedure
2016-06-09 15:07:02 +02:00
118.sql
…
119.sql
…
120.sql
…
121.sql
Rename sql to 121
2016-06-30 15:29:58 -05:00
122.sql
Actually add the sql content
2016-07-08 20:37:33 -05:00
123.sql
…
124.sql
Re-try two missing tables in mariadb
2016-07-17 21:12:52 +01:00
125.sql
Renamed 124.sql -> 125.sql
2016-07-17 21:25:21 +01:00
126.sql
Remove alert.macros from db schema again. (#8460)
2018-03-23 18:56:27 +00:00
127.sql
- Change the IPSLA feature to allow different metrics to be collected per type.
2016-08-09 06:59:17 +10:00
128.sql
…
129.sql
availability map updates (#4160)
2016-08-22 19:12:44 +01:00
130.sql
Config option for global default dashboard (#4080)
2016-08-23 19:37:12 +01:00
131.sql
…
132.sql
…
133.sql
Added schema 133 (#4426)
2016-09-13 22:30:06 +01:00
134.sql
…
135.sql
…
136.sql
feature: Add last changed, connected, and mtu to all ports data
2016-09-21 13:19:52 -05:00
137.sql
fix renumbering
2016-09-22 00:12:20 +03:00
138.sql
…
139.sql
…
140.sql
Remove graph_types definitions from DB (#9618)
2019-01-08 13:46:45 -06:00
141.sql
…
142.sql
fix: Raise version size for packages table to 255 char (#4656)
2016-10-06 12:01:32 +01:00
143.sql
refactor: Improve sensors polling for performance increase (#4725)
2016-10-11 19:34:09 +03:00
144.sql
…
145.sql
…
146.sql
Remove graph_types definitions from DB (#9618)
2019-01-08 13:46:45 -06:00
147.sql
refactor: schema updates (#6370)
2017-04-13 10:18:12 +01:00
148.sql
Remove graph_types definitions from DB (#9618)
2019-01-08 13:46:45 -06:00
149.sql
…
150.sql
refactor: limit perf array index length to 19 characters due to limitation in ds-name rrdtool (#4731)
2016-11-16 07:24:56 +00:00
151.sql
refactor: schema updates (#6370)
2017-04-13 10:18:12 +01:00
152.sql
Remove graph_types definitions from DB (#9618)
2019-01-08 13:46:45 -06:00
153.sql
…
154.sql
…
155.sql
…
156.sql
…
157.sql
tests: test each db schema file for proper format (#6580)
2017-05-04 21:14:14 +01:00
158.sql
feature: Added Cisco Spark Transport #3182
2017-02-02 23:10:39 +00:00
159.sql
…
160.sql
…
161.sql
allow interface names > 64 chars (#5847)
2017-02-09 18:12:25 +00:00
162.sql
changed ifLastChange to a bigint as we can hit the limits of a current signed int (#5835)
2017-02-10 19:28:12 -06:00
163.sql
…
164.sql
…
165.sql
fix: Added message column to component_statuslog table #5431 (#5929)
2017-02-17 18:04:04 -06:00
166.sql
…
167.sql
…
168.sql
tests: test each db schema file for proper format (#6580)
2017-05-04 21:14:14 +01:00
169.sql
…
170.sql
…
171.sql
…
172.sql
…
173.sql
…
174.sql
…
175.sql
…
176.sql
feature: Added app_state support for applications #5068 (#6061)
2017-03-11 08:39:32 -06:00
177.sql
…
178.sql
feature: Unit test to validate the db schema (#6367)
2017-04-07 15:07:44 +01:00
179.sql
…
180.sql
feature: Peeringdb integration to show the Exchanges and peers for your AS' (#6178)
2017-03-22 10:17:13 +00:00
181.sql
…
182.sql
…
183.sql
…
184.sql
…
185.sql
…
186.sql
Fix: Service filenames are snipped when longer than 16 characters (#6459)
2017-04-19 11:52:13 +01:00
187.sql
…
188.sql
…
189.sql
fix: Increased speed of loading syslog pages. (#6433)
2017-05-03 22:41:55 +01:00
190.sql
fix: issue with wireless sensors when there are too many oids (#6578)
2017-05-04 19:56:25 +01:00
191.sql
alerting: Added option to enable/disable option for sending alerts to normal users (#6590)
2017-05-15 23:35:26 +01:00
192.sql
newdevice: Added more health information for APC units (#6619)
2017-05-17 22:41:53 +01:00
193.sql
…
194.sql
…
195.sql
fix: Updated sysObjectId column in devices table to varchar(128) (#6832)
2017-06-13 18:37:21 -05:00
196.sql
feature: Added fdb discovery module (#6887)
2017-06-26 13:58:17 +01:00
197.sql
fix: perf_times cleanup (#6908)
2017-06-28 21:43:19 +01:00
198.sql
feature: Support fdb table on generic devices (#6902)
2017-06-29 21:03:56 +01:00
199.sql
fix: fdb tables multiple IPs and IPs from other devices adding extra rows (#6930)
2017-07-04 22:27:43 +01:00
200.sql
…
201.sql
feature: Added new alert rule builder UI and rule mapping UI (#8293)
2018-03-14 20:25:19 +00:00
202.sql
…
203.sql
…
204.sql
Attempt to fix repeated sql issue we come across (#7123)
2017-08-14 22:00:41 +01:00
205.sql
feature: Notify about failed updates, block detectable bad updates (#7188)
2017-08-26 21:35:39 +01:00
206.sql
…
207.sql
…
208.sql
…
209.sql
Extend username to varchar(255) (#7395)
2017-09-29 20:15:48 +01:00
210.sql
…
211.sql
…
212.sql
…
213.sql
feature: Support for up/down detection of ping only devices.
2017-10-27 22:59:25 -05:00
214.sql
fix: Improve poller validation (#7586)
2017-10-31 20:32:56 +00:00
215.sql
…
216.sql
Remove alert.macros from db schema again. (#8460)
2018-03-23 18:56:27 +00:00
217.sql
…
218.sql
…
219.sql
…
220.sql
feature: Added support Entity State polling (#7625)
2017-12-02 20:23:56 +00:00
221.sql
feature: Added new alert rule builder UI and rule mapping UI (#8293)
2018-03-14 20:25:19 +00:00
222.sql
refactor: Update all applications to store metrics (#7853)
2017-12-06 22:13:10 +00:00
223.sql
Junos dwdm interface sensor support (#7714)
2017-12-12 20:27:10 -06:00
224.sql
…
225.sql
feature: Added support for Host dependencies (#7332)
2017-12-20 14:17:52 +00:00
226.sql
webui: Added Single server details widget (#7923)
2017-12-21 22:17:02 +00:00
227.sql
…
228.sql
refactor: Updated discovery/poller to use numeric sysObjectID (#7922)
2018-01-06 23:00:47 -06:00
229.sql
Remove graph_types definitions from DB (#9618)
2019-01-08 13:46:45 -06:00
230.sql
…
231.sql
Remove graph_types definitions from DB (#9618)
2019-01-08 13:46:45 -06:00
232.sql
fix: Fixed arp-tables duplicate data (#8147)
2018-01-24 20:51:00 +00:00
233.sql
…
234.sql
feature: Copy all email alerts to default contact (#8178)
2018-02-05 08:25:24 +00:00
235.sql
…
236.sql
…
237.sql
Re-add index to ports_fdb table (#8267)
2018-02-21 09:23:00 +00:00
238.sql
…
239.sql
…
240.sql
feature: Added new alert rule builder UI and rule mapping UI (#8293)
2018-03-14 20:25:19 +00:00
241.sql
feature: Added new alert rule builder UI and rule mapping UI (#8293)
2018-03-14 20:25:19 +00:00
242.sql
feature: Added new alert rule builder UI and rule mapping UI (#8293)
2018-03-14 20:25:19 +00:00
243.sql
…
244.sql
…
245.sql
Delete invalid alert maps (#8390)
2018-03-15 14:44:47 +00:00
246.sql
fix: Change rootPort DB data type (#8404)
2018-03-20 14:01:08 +00:00
247.sql
Remove alert.macros from db schema again. (#8460)
2018-03-23 18:56:27 +00:00
248.sql
…
249.sql
Fix alerting
2018-04-26 11:11:59 -05:00
250.sql
…
251.sql
…
252.sql
…
253.sql
…
254.sql
Use Laravel authentication (#8702)
2018-09-11 07:51:35 -05:00
255.sql
…
256.sql
…
257.sql
…
258.sql
…
259.sql
…
260.sql
…
261.sql
Use Laravel authentication (#8702)
2018-09-11 07:51:35 -05:00
262.sql
Try to fix sql schema 278 (#9715)
2019-01-22 17:05:54 -06:00
263.sql
Database schema cleanup (#9064)
2018-09-05 07:34:50 -05:00
264.sql
Fixed PeeringDB module (#9158)
2018-09-05 19:26:18 +01:00
265.sql
Fixed latency over 1s causes db update to fail (#9157)
2018-09-06 23:11:28 +01:00
266.sql
Added BGP Peer Descriptions (#9165)
2018-09-10 22:54:46 -05:00
267.sql
Use Laravel authentication (#8702)
2018-09-11 07:51:35 -05:00
268.sql
…
269.sql
…
270.sql
Allow F5 APM graphs to display automatically (#9377)
2018-10-25 15:39:45 -05:00
271.sql
…
272.sql
…
273.sql
Add additional composite index to speed up display of pages where a device has a lot of syslogs. In our environment, this took page loads for some devices from over 60 seconds to nearly instant
2018-12-03 10:44:03 -06:00
274.sql
…
275.sql
Fix db schema oopsie (#9586)
2018-12-21 10:24:37 -06:00
276.sql
…
277.sql
Refactored Alert schedule (#9514)
2019-01-03 22:42:12 +00:00
278.sql
…
279.sql
…
280.sql
…
281.sql
Added support for grouping sensors (#9606)
2019-01-11 22:42:56 +00:00
1000.sql
Merge pull request #9761 from murrant/278-more
2019-01-30 16:56:05 +01:00