1: -- phpMyAdmin SQL Dump
  2: -- version 2.10.0.2
  3: -- http://www.phpmyadmin.net
  4: -- 
  5: -- Host: localhost
  6: -- Generation Time: Mar 02, 2008 at 07:54 PM
  7: -- Server version: 4.1.14
  8: -- PHP Version: 5.0.4
  9: 
 10: SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
 11: 
 12: -- 
 13: -- Database: `freenats`
 14: -- 
 15: 
 16: -- --------------------------------------------------------
 17: 
 18: -- 
 19: -- Table structure for table `fnalert`
 20: -- 
 21: 
 22: CREATE TABLE IF NOT EXISTS `fnalert` (
 23:   `alertid` bigint(20) unsigned NOT NULL auto_increment,
 24:   `nodeid` varchar(64) NOT NULL default '',
 25:   `alertlevel` int(11) NOT NULL default '0',
 26:   `openedx` bigint(20) unsigned NOT NULL default '0',
 27:   `closedx` bigint(20) unsigned NOT NULL default '0',
 28:   PRIMARY KEY  (`alertid`)
 29: ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=134 ;
 30: 
 31: -- --------------------------------------------------------
 32: 
 33: -- 
 34: -- Table structure for table `fnalertaction`
 35: -- 
 36: 
 37: CREATE TABLE IF NOT EXISTS `fnalertaction` (
 38:   `aaid` bigint(20) unsigned NOT NULL auto_increment,
 39:   `atype` varchar(32) NOT NULL default '',
 40:   `efrom` varchar(250) NOT NULL default '',
 41:   `etolist` text NOT NULL,
 42:   `esubject` int(11) NOT NULL default '0',
 43:   `etype` int(11) NOT NULL default '0',
 44:   `awarnings` tinyint(1) NOT NULL default '0',
 45:   `adecrease` tinyint(1) NOT NULL default '0',
 46:   `mdata` text NOT NULL,
 47:   `aname` varchar(120) NOT NULL default '',
 48:   PRIMARY KEY  (`aaid`)
 49: ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
 50: 
 51: -- --------------------------------------------------------
 52: 
 53: -- 
 54: -- Table structure for table `fnalertlog`
 55: -- 
 56: 
 57: CREATE TABLE IF NOT EXISTS `fnalertlog` (
 58:   `alid` bigint(20) unsigned NOT NULL auto_increment,
 59:   `alertid` bigint(20) unsigned NOT NULL default '0',
 60:   `postedx` bigint(20) unsigned NOT NULL default '0',
 61:   `logentry` varchar(250) NOT NULL default '',
 62:   PRIMARY KEY  (`alid`)
 63: ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=643 ;
 64: 
 65: -- --------------------------------------------------------
 66: 
 67: -- 
 68: -- Table structure for table `fnconfig`
 69: -- 
 70: 
 71: CREATE TABLE IF NOT EXISTS `fnconfig` (
 72:   `fnc_var` varchar(64) NOT NULL default '',
 73:   `fnc_val` varchar(64) NOT NULL default '',
 74:   PRIMARY KEY  (`fnc_var`)
 75: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 76: 
 77: -- --------------------------------------------------------
 78: 
 79: -- 
 80: -- Table structure for table `fneval`
 81: -- 
 82: 
 83: CREATE TABLE IF NOT EXISTS `fneval` (
 84:   `evalid` bigint(20) unsigned NOT NULL auto_increment,
 85:   `testid` varchar(128) NOT NULL default '',
 86:   `weight` int(11) NOT NULL default '0',
 87:   `eoperator` varchar(32) NOT NULL default '',
 88:   `evalue` varchar(128) NOT NULL default '',
 89:   `eoutcome` int(11) NOT NULL default '0',
 90:   PRIMARY KEY  (`evalid`)
 91: ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;
 92: 
 93: -- --------------------------------------------------------
 94: 
 95: -- 
 96: -- Table structure for table `fngroup`
 97: -- 
 98: 
 99: CREATE TABLE IF NOT EXISTS `fngroup` (
100:   `groupid` bigint(20) unsigned NOT NULL auto_increment,
101:   `groupname` varchar(128) NOT NULL default '',
102:   `groupdesc` varchar(250) NOT NULL default '',
103:   `groupicon` varchar(64) NOT NULL default '',
104:   `weight` int(10) unsigned NOT NULL default '0',
105:   PRIMARY KEY  (`groupid`)
106: ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
107: 
108: -- --------------------------------------------------------
109: 
110: -- 
111: -- Table structure for table `fngrouplink`
112: -- 
113: 
114: CREATE TABLE IF NOT EXISTS `fngrouplink` (
115:   `glid` bigint(20) unsigned NOT NULL auto_increment,
116:   `groupid` bigint(20) unsigned NOT NULL default '0',
117:   `nodeid` varchar(64) NOT NULL default '',
118:   PRIMARY KEY  (`glid`)
119: ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=53 ;
120: 
121: -- --------------------------------------------------------
122: 
123: -- 
124: -- Table structure for table `fnlocaltest`
125: -- 
126: 
127: CREATE TABLE IF NOT EXISTS `fnlocaltest` (
128:   `localtestid` bigint(20) unsigned NOT NULL auto_increment,
129:   `nodeid` varchar(64) NOT NULL default '',
130:   `alertlevel` int(11) NOT NULL default '-1',
131:   `lastrunx` bigint(20) unsigned NOT NULL default '0',
132:   `testtype` varchar(128) NOT NULL default '',
133:   `testparam` varchar(250) default NULL,
134:   `testrecord` tinyint(1) NOT NULL default '0',
135:   `simpleeval` tinyint(1) NOT NULL default '1',
136:   PRIMARY KEY  (`localtestid`)
137: ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;
138: 
139: -- --------------------------------------------------------
140: 
141: -- 
142: -- Table structure for table `fnlog`
143: -- 
144: 
145: CREATE TABLE IF NOT EXISTS `fnlog` (
146:   `logid` bigint(20) unsigned NOT NULL auto_increment,
147:   `postedx` bigint(20) unsigned NOT NULL default '0',
148:   `modid` varchar(32) NOT NULL default '',
149:   `catid` varchar(32) NOT NULL default '',
150:   `username` varchar(64) NOT NULL default '',
151:   `loglevel` int(11) NOT NULL default '1',
152:   `logevent` varchar(250) NOT NULL default '',
153:   PRIMARY KEY  (`logid`)
154: ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=90921 ;
155: 
156: -- --------------------------------------------------------
157: 
158: -- 
159: -- Table structure for table `fnnalink`
160: -- 
161: 
162: CREATE TABLE IF NOT EXISTS `fnnalink` (
163:   `nalid` bigint(20) unsigned NOT NULL auto_increment,
164:   `nodeid` varchar(64) NOT NULL default '',
165:   `aaid` bigint(20) unsigned NOT NULL default '0',
166:   PRIMARY KEY  (`nalid`)
167: ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
168: 
169: -- --------------------------------------------------------
170: 
171: -- 
172: -- Table structure for table `fnnode`
173: -- 
174: 
175: CREATE TABLE IF NOT EXISTS `fnnode` (
176:   `nodeid` varchar(64) NOT NULL default '',
177:   `nodename` varchar(128) NOT NULL default '',
178:   `nodedesc` varchar(254) NOT NULL default '',
179:   `hostname` varchar(254) NOT NULL default '',
180:   `nodeenabled` tinyint(1) NOT NULL default '0',
181:   `pingtest` tinyint(1) NOT NULL default '0',
182:   `pingfatal` tinyint(1) NOT NULL default '0',
183:   `alertlevel` int(11) NOT NULL default '-1',
184:   `nodeicon` varchar(64) NOT NULL default '',
185:   `weight` int(10) unsigned NOT NULL default '0',
186:   PRIMARY KEY  (`nodeid`)
187: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
188: 
189: -- --------------------------------------------------------
190: 
191: -- 
192: -- Table structure for table `fnrecord`
193: -- 
194: 
195: CREATE TABLE IF NOT EXISTS `fnrecord` (
196:   `recordid` bigint(20) unsigned NOT NULL auto_increment,
197:   `testid` varchar(128) NOT NULL default '',
198:   `alertlevel` int(11) NOT NULL default '0',
199:   `testvalue` float NOT NULL default '0',
200:   `recordx` bigint(20) unsigned NOT NULL default '0',
201:   `nodeid` varchar(64) NOT NULL default '',
202:   PRIMARY KEY  (`recordid`)
203: ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=22902 ;
204: 
205: -- --------------------------------------------------------
206: 
207: -- 
208: -- Table structure for table `fnsession`
209: -- 
210: 
211: CREATE TABLE IF NOT EXISTS `fnsession` (
212:   `sessionid` bigint(20) unsigned NOT NULL auto_increment,
213:   `sessionkey` varchar(128) NOT NULL default '',
214:   `ipaddress` varchar(128) NOT NULL default '',
215:   `username` varchar(64) NOT NULL default '',
216:   `startx` bigint(20) unsigned NOT NULL default '0',
217:   `updatex` bigint(20) unsigned NOT NULL default '0',
218:   `userlevel` int(11) NOT NULL default '0',
219:   PRIMARY KEY  (`sessionid`)
220: ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=45 ;
221: 
222: -- --------------------------------------------------------
223: 
224: -- 
225: -- Table structure for table `fntestrun`
226: -- 
227: 
228: CREATE TABLE IF NOT EXISTS `fntestrun` (
229:   `trid` bigint(20) unsigned NOT NULL auto_increment,
230:   `startx` bigint(20) unsigned NOT NULL default '0',
231:   `finishx` bigint(20) unsigned NOT NULL default '0',
232:   `routput` text NOT NULL,
233:   `fnode` varchar(64) NOT NULL default '',
234:   PRIMARY KEY  (`trid`)
235: ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2542 ;
236: 
237: -- --------------------------------------------------------
238: 
239: -- 
240: -- Table structure for table `fnuser`
241: -- 
242: 
243: CREATE TABLE IF NOT EXISTS `fnuser` (
244:   `username` varchar(64) NOT NULL default '',
245:   `password` varchar(64) NOT NULL default '',
246:   `realname` varchar(128) NOT NULL default '',
247:   `userlevel` int(11) NOT NULL default '1'
248: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
249: