Transcription
Cacti Database Schema (0.8.6)Table of contents1 cdef2 cdef items3 colors4 data input5 data input data6 data input fields7 data local8 data template9 data template data10 data template data rra11 data template rrd12 graph local13 graph templates14 graph templates graph15 graph templates item16 graph template input17 graph template input defs18 graph tree19 graph tree items20 host21 host snmp cache22 host snmp query23 host template24 host template graph25 poller26 poller command27 poller item28 poller output29 poller reindex30 poller time31 rra32 rra cf33 settings graphs34 settings tree35 snmp query36 snmp query graph37 snmp query graph rrd38 snmp query graph rrd sv39 snmp query graph sv40 user authPage number: 3Page number: 4Page number: 5Page number: 6Page number: 7Page number: 8Page number: 9Page number: 10Page number: 11Page number: 12Page number: 13Page number: 14Page number: 15Page number: 16Page number: 18Page number: 19Page number: 20Page number: 21Page number: 22Page number: 23Page number: 24Page number: 25Page number: 26Page number: 27Page number: 28Page number: 29Page number: 30Page number: 31Page number: 32Page number: 33Page number: 34Page number: 35Page number: 36Page number: 37Page number: 38Page number: 39Page number: 40Page number: 41Page number: 42Page number: 43Page number: 1/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)41 user auth perms42 user auth realm43 Relational schemaPage number: 44Page number: 45Page number: 46Page number: 2/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)1 cdefCreation: Oct 31, 2003 at 12:13 AMLast update: Nov 05, 2003 at 10:55 s toCommentsMIMEauto incrementPage number: 3/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)2 cdef itemsCreation: Oct 31, 2003 at 12:13 AMLast update: Nov 05, 2003 at 10:55 PMFieldidhashcdef xtraLinks toCommentsMIMEauto increment000cdef - idPage number: 4/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)3 colorsCreation: May 26, 2003 at 07:55 PMLast update: May 26, 2003 at 07:55 SIGNEDNullNoNoDefaultExtraLinks toCommentsMIMEauto incrementPage number: 5/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)4 data inputCreation: Nov 05, 2003 at 10:12 PMLast update: Jul 23, 2004 at 12:29 PMFieldidhashnameinput stringtype ultExtraLinks toCommentsMIMEauto incrementNULL0Page number: 6/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)5 data input dataCreation: May 26, 2003 at 07:55 PMLast update: Jul 23, 2004 at 03:15 PMFieldTypedata input field iddata template data idt valuevaluemediumint(8)UNSIGNEDNo0data input fields - idmediumint(8)UNSIGNEDNo0data template data - traLinks toPage number: 7/46CommentsMIMESep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)6 data input fieldsCreation: Oct 31, 2003 at 12:13 AMLast update: Jul 23, 2004 at 12:30 PMFieldidhashdata input idnamedata nameinput outputupdate rrasequencetype coderegexp matchallow llNoNoNoNoNoNoYesNoYesYesYesDefaultExtraLinks toCommentsMIMEauto increment0data input - id00NULLNULLNULLPage number: 8/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)7 data localCreation: May 26, 2003 at 08:32 PMLast update: Oct 02, 2003 at 11:30 PMLast check: May 26, 2003 at 08:32 PMFieldTypeiddata template idhost idsnmp query idsnmp llNoNoNoNoNoDefaultExtraLinks toCommentsMIMEauto increment000Page number: 9/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)8 data templateCreation: Oct 31, 2003 at 12:13 AMLast update: Jan 05, 2004 at 10:31 s toCommentsMIMEauto incrementPage number: 10/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)9 data template dataCreation: Jan 11, 2004 at 11:32 PMLast update: Jul 23, 2004 at 03:15 PMFieldTypeAttributesidlocal data template data idlocal data iddata template iddata input idt namenamename cachedata source patht activeactivet rrd steprrd stept rra NoYesYesYesYesNoYesUNSIGNEDNullDefaultExtraLinks toCommentsMIMEauto increment0data template data - id000NULLdata local - iddata template data - iddata input - idNULLNULLNULLNULL0NULLPage number: 11/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)10 data template data rraCreation: Aug 19, 2003 at 01:00 AMLast update: Jul 23, 2004 at 03:15 PMFieldTypedata template da mediumint(8)ta idrra idmediumint(8)AttributesNullDefaultExtraLinks toUNSIGNEDNo0data template data - idUNSIGNEDNo0rra - idPage number: 12/46CommentsMIMESep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)11 data template rrdCreation: Oct 31, 2003 at 12:13 AMLast update: Jan 05, 2004 at 10:31 PMFieldTypeAttributesidhashlocal data template rrd idlocal data iddata template idt rrd maximumrrd maximumt rrd minimumrrd minimumt rrd heartbeatrrd heartbeatt data source type iddata source typeidt data source namedata source namet data input fieldiddata input field efaultExtraLinks toNoNoNo0data template rrd - idNoNoYesNoYesNoYesNoYes00NULL0NULL0NULL0NULLdata local - iddata template - auto incrementPage number: 13/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)12 graph localTable comments : Creates a relationship for each item in a custom graph.Creation: May 26, 2003 at 08:32 PMLast update: Nov 05, 2003 at 10:27 PMLast check: May 26, 2003 at 08:32 PMFieldTypeAttributesNullidgraph template idhost idsnmp query idsnmp faultExtraLinks toCommentsMIMEauto increment000Page number: 14/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)13 graph templatesTable comments : Contains each graph template name.Creation: Oct 31, 2003 at 12:13 AMLast update: Jan 05, 2004 at 10:32 AttributesUNSIGNEDNullNoNoNoDefaultExtraLinks toCommentsMIMEauto incrementPage number: 15/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)14 graph templates graphTable comments : Stores the actual graph data.Creation: Dec 17, 2003 at 05:25 PMLast update: Jul 23, 2004 at 12:38 PMFieldTypeAttributesNullDefaultExtraLinks toidlocal graph template graph idlocal graph idgraph template idt image format idimage format idt titletitletitle cachet heightheightt widthwidtht upper limitupper limitt lower limitlower limitt vertical labelvertical labelt auto scaleauto scalet auto scale optsauto scale optst auto scale logauto scale logt auto scale rigidauto scale rigidt auto paddingauto paddingt base valuebase valuet No0graph templates graph - aph local - idgraph templates - esYesYesYesNoYes00CommentsMIMEauto e number: 16/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)groupingt exportexportt unit valueunit valuet unit exponentvalueunit exponent )NoYesYesYesYesYesvarchar(5)No0NULL0NULL0Page number: 17/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)15 graph templates itemTable comments : Stores the actual graph item data.Creation: Oct 31, 2003 at 12:13 AMLast update: Jan 05, 2004 at 10:33 PMLast check: Oct 31, 2003 at 12:13 AMFieldidhashlocal graph template item idlocal graph idgraph template idtask item idcolor idgraph type idcdef idconsolidation function idtext formatvaluehard returngprint NSIGNEDNullDefaultExtraLinks toUNSIGNEDNoNoNo0graph templates item - aph local - idgraph templates - nyint(2)UNSIGNEDUNSIGNEDNoNoNoNoNo00000data template rrd - idcolors - UNSIGNEDCommentsMIMEauto incrementcdef - idPage number: 18/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)16 graph template inputTable comments : Stores the names for graph item input groups.Creation: Oct 31, 2003 at 12:13 AMLast update: Jan 05, 2004 at 10:33 PMFieldTypeidhashgraph template idnamedescriptioncolumn NoNoYesNoDefaultExtraLinks toCommentsMIMEauto increment0data template - idNULLPage number: 19/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)17 graph template input defsTable comments : Stores the relationship for what graph iitems are associatedCreation: May 26, 2003 at 07:55 PMLast update: Jan 05, 2004 at 10:33 PMFieldTypegraph template i mediumint(8)nput idgraph template it int(12)em idAttributesNullDefaultExtraLinks toUNSIGNEDNo0graph template input - idUNSIGNEDNo0graph templates item - idPage number: 20/46CommentsMIMESep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)18 graph treeCreation: Aug 14, 2004 at 11:21 PMLast update: Aug 14, 2004 at 11:21 PMFieldidsort butesUNSIGNEDUNSIGNEDNullNoNoNoDefaultExtraLinks toCommentsMIMEauto increment1Page number: 21/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)19 graph tree itemsCreation: Jul 22, 2004 at 12:42 AMLast update: Jul 22, 2004 at 12:44 AMFieldTypeAttributesidgraph tree idlocal graph idrra idtitlehost idorder keyhost grouping typesort children EDExtraLinks toCommentsMIMEauto incrementgraph tree - idgraph local - idrra - idhost - idPage number: 22/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)20 hostCreation: Jul 22, 2004 at 12:42 AMLast update: Jul 22, 2004 at 12:42 AMFieldTypeAttributesidhost template iddescriptionhostnamesnmp communitysnmp versionsnmp usernamesnmp passwordsnmp portsnmp timeoutdisabledstatusstatus event countstatus fail atetimeNostatus rec datedatetimeNostatus last errormin timemax timecur timeavg timetotal pollsfailed esYesNoYesYesNoNoYesNoNoDefaultExtraLinks toCommentsMIMEauto 00000100.00000Page number: 23/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)21 host snmp cacheCreation: Sep 16, 2004 at 11:31 PMLast update: Sep 16, 2004 at 11:31 PMFieldhost idsnmp query idfield namefield valuesnmp UNSIGNEDNullNoNoNoYesNoNoDefault00ExtraLinks toCommentsMIMEhost - idsnmp query - idNULLPage number: 24/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)22 host snmp queryCreation: Jul 22, 2004 at 12:41 AMLast update: Jul 22, 2004 at 12:44 AMFieldhost idsnmp query idsort fieldtitle formatreindex NullNoNoNoNoNoDefault00ExtraLinks toCommentsMIMEhost - idsnmp query - id0Page number: 25/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)23 host templateCreation: Oct 31, 2003 at 12:13 AMLast update: Jan 19, 2004 at 02:54 s toCommentsMIMEauto incrementPage number: 26/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)24 host template graphCreation: May 26, 2003 at 07:55 PMLast update: Jan 31, 2004 at 01:01 PMFieldTypehost template idgraph template EDNullNoNoDefault00ExtraLinks toCommentsMIMEhost template - idgraph templates - idPage number: 27/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)25 pollerCreation: Jul 22, 2004 at 12:40 AMLast update: Jul 22, 2004 at 12:40 AMFieldidhostnameip addresslast nks toCommentsMIMEauto increment00000-00-0000:00:00Page number: 28/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)26 poller commandCreation: Jul 22, 2004 at 12:40 AMLast update: Jul 22, 2004 at 12:40 AMFieldTypeAttributesNullpoller 0000:00:000ExtraLinks toCommentsMIMEpoller - idPage number: 29/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)27 poller itemCreation: Sep 16, 2004 at 11:30 PMLast update: Sep 16, 2004 at 11:30 PMFieldTypelocal data idpoller idhost idactionhostnamesnmp communitysnmp versionsnmp usernamesnmp passwordsnmp portsnmp timeoutrrd namerrd pathrrd oNoNoNoYesYesYesDefault0001ExtraLinks toCommentsMIMEdata local - idpoller - idhost - id016100NULLNULLNULLPage number: 30/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)28 poller outputCreation: Jul 22, 2004 at 12:41 AMLast update: Jul 22, 2004 at 12:41 AMFieldTypelocal data idrrd ttributesUNSIGNEDNullNoNoNoDefault0ExtraLinks toCommentsMIMEdata local - id0000-00-0000:00:00NoPage number: 31/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)29 poller reindexCreation: Jul 22, 2004 at 12:41 AMLast update: Jul 22, 2004 at 12:41 AMFieldhost iddata query idactionopassert GNEDUNSIGNEDNullNoNoNoNoNoNoDefault000ExtraLinks toCommentsMIMEhost - idsnmp query - idPage number: 32/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)30 poller timeCreation: Jul 22, 2004 at 12:41 AMLast update: Jul 22, 2004 at 12:41 AMFieldTypeidpoller idstart timemediumint(8)smallint(5)datetimeend DefaultExtraLinks toCommentsMIMEauto er - idPage number: 33/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)31 rraCreation: Oct 31, 2003 at 12:17 AMLast update: Nov 05, 2003 at 10:55 PMFieldidhashnamex files aLinks toCommentsMIMEauto increment0.116000Page number: 34/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)32 rra cfCreation: May 26, 2003 at 07:55 PMLast update: May 26, 2003 at 07:55 PMFieldTyperra idconsolidation function DNullNoNoDefault00ExtraLinks toCommentsMIMErra - idPage number: 35/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)33 settings graphsCreation: Aug 27, 2003 at 11:24 PMLast update: Nov 06, 2003 at 07:05 PMFielduser ttributesUNSIGNEDNullNoNoNoDefault0ExtraLinks toCommentsMIMEuser auth - idPage number: 36/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)34 settings treeCreation: May 26, 2003 at 07:55 PMLast update: May 26, 2003 at 07:55 PMFieldTypeuser idmediumint(8)graph tree item i IGNEDNullDefaultNoNo00No0ExtraLinks toCommentsMIMEuser auth - idgraph tree items - idPage number: 37/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)35 snmp queryCreation: Oct 31, 2003 at 12:13 AMLast update: Jul 23, 2004 at 12:32 PMFieldTypeAttributesidhashxml pathnamedescriptiongraph template iddata input aultExtraLinks toUNSIGNEDNoNoNoNoYesNoNULL0graph templates - idUNSIGNEDNo0data input - idCommentsMIMEauto incrementPage number: 38/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)36 snmp query graphCreation: Oct 31, 2003 at 12:13 AMLast update: Nov 05, 2003 at 10:55 PMFieldTypeidhashsnmp query idnamegraph template oNoNoNoNoDefaultExtraLinks toCommentsMIMEauto increment0snmp query - id0graph templates - idPage number: 39/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)37 snmp query graph rrdCreation: May 26, 2003 at 07:55 PMLast update: Nov 05, 2003 at 10:29 PMFieldTypesnmp query graph iddata template iddata template rrdidsnmp field namemediumint(8)UNSIGNEDNo0snmp query graph - ta template - iddata template rrd - idNo0varchar(50)AttributesNullDefaultExtraLinks toPage number: 40/46CommentsMIMESep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)38 snmp query graph rrd svCreation: Oct 31, 2003 at 12:13 AMLast update: Jul 22, 2004 at 12:42 AMFieldTypeAttributesidhashsnmp query graph iddata template idsequencefield traLinks toCommentsMIMEauto increment0snmp query graph - id00data template - idPage number: 41/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)39 snmp query graph svCreation: Oct 31, 2003 at 12:13 AMLast update: Feb 01, 2004 at 08:44 PMFieldTypeAttributesidhashsnmp query graph idsequencefield NEDNullNoNoNoNoNoNoDefaultExtraLinks toCommentsMIMEauto increment0snmp query graph - id0Page number: 42/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)40 user authCreation: Jul 21, 2003 at 05:20 PMLast update: Nov 06, 2003 at 07:05 PMLast check: Jul 21, 2003 at 05:20 PMFieldTypeidusernamepasswordrealmfull namemust change passwordshow treeshow listshow previewgraph settingslogin optspolicy graphspolicy treespolicy hostspolicy graph NoNoNoonononNULL11111ExtraLinks toCommentsMIMEauto incrementPage number: 43/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)41 user auth permsCreation: Aug 17, 2003 at 03:14 PMLast update: Aug 17, 2003 at 03:14 PMFielduser iditem traLinks toCommentsMIMEuser auth - idPage number: 44/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)42 user auth realmCreation: May 26, 2003 at 07:55 PMLast update: Nov 06, 2003 at 07:05 PMFieldrealm iduser SIGNEDNullNoNoDefault00ExtraLinks toCommentsMIMEuser auth - idPage number: 45/46Sep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6)snmp queryidhashxml pathnamedescriptiongraph template iddata input idsnmp query graphidhashsnmp query idnamegraph template idsnmp query graph rrd svidhashsnmp query graph iddata template idsequencefield nametextsnmp query graph svcolorsidhexhost templateidhashnameidhashsnmp query graph idsequencefield nametextgraph localidgraph template idhost idsnmp query idsnmp indexgraph template inputidhashgraph template idnamedescriptioncolumn namegraph template input defsgraph template input idgraph template item idgraph treeidsort typenamegraph templates graphidlocal graph template graph idlocal graph idgraph template idt image format idimage format idt titletitletitle cachet heightheightt widthwidtht upper limitupper limitt lower limitlower limitt vertical labelvertical labelt auto scaleauto scalet auto scale optsauto scale optst auto scale logauto scale logt auto scale rigidauto scale rigidt auto paddingauto paddingt base valuebase valuet groupinggroupingt exportexportt unit valueunit valuet unit exponent valueunit exponent valuehost template graphhost template idgraph template idhost snmp queryhost idsnmp query idsort fieldtitle formatreindex methodsnmp query graph rrdsnmp query graph iddata template iddata template rrd idsnmp field namegraph templatesidhashnamehostidhost template iddescriptionhostnamesnmp communitysnmp versionsnmp usernamesnmp passwordsnmp portsnmp timeoutdisabledstatusstatus event counthost snmp cachestatus fail datehost idstatus rec datesnmp query idstatus last errorfield namemin timefield valuemax timesnmp indexcur timeoidavg timetotal pollsfailed pollsavailabilitydata templateidhashnamedata localiddata template idhost idsnmp query idsnmp indexdata template data rradata template data idrra idsettings graphsuser idnamevaluedata template dataidlocal data template data idlocal data iddata template iddata input idt namenamename cachedata source patht activeactivet rrd steprrd stept rra iddata template rrdidhashlocal data template rrd idlocal data iddata template idt rrd maximumrrd maximumt rrd minimumrrd minimumt rrd heartbeatrrd heartbeatt data source type iddata source type idt data source namedata source namet data input field iddata input field idsettings treeuser idgraph tree item idstatusdata inputidhashnameinput stringtype idpoller itemlocal data idpoller idhost idactionhostnamesnmp communitysnmp versionsnmp usernamesnmp passwordsnmp portsnmp timeoutrrd namerrd pathrrd numarg1arg2arg3graph templates itemgraph tree itemsidgraph tree idlocal graph idrra idtitlehost idorder keyhost grouping typesort children typeidhashlocal graph template item idlocal graph idgraph template idtask item idcolor idgraph type idcdef idconsolidation function idtext formatvaluehard returngprint idsequencecdefidhashnamecdef itemsidhashcdef idsequencetypevalueuser authidusernamepasswordrealmfull namemust change passwordshow treeshow listshow previewgraph settingslogin optspolicy graphspolicy treespolicy hostspolicy graph templatesPage number: 46/46poller reindexhost iddata query idactionopassert valuearg1data input fieldsidhashdata input idnamedata nameinput outputupdate rrasequencetype coderegexp matchallow nullsrraidhashnamex files factorstepsrowstimespanrra cfrra idconsolidation function iddata input datadata input field iddata template data idt valuevalueuser auth realmrealm iduser iduser auth permsuser iditem idtypepoller timeidpoller idstart timeend timepolleridhostnameip addresslast updatepoller commandpoller idtimeactioncommandpoller outputlocal data idrrd nametimeoutputSep 26, 2004 at 03:33 PM
Cacti Database Schema (0.8.6) Table of contents 1 cdef Page number: 3 2 cdef_items Page number: 4 3 colors Page number: 5 4 data_input Page number: 6 5 data_input_data Page number: 7 6 data_input_fields Page number: 8 7 data_local Page number: 9 8 data_template Page number: 10 9 data_template_data Page number: 11 10 data_template_data_rra Page .
