1: -- No DROP TABLES - suitable for upgrade
  2: -- MySQL dump 10.10
  3: --
  4: -- Host: localhost    Database: freenats
  5: -- ------------------------------------------------------
  6: -- Server version	5.0.22
  7: 
  8: /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  9: /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
 10: /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
 11: /*!40101 SET NAMES utf8 */;
 12: /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
 13: /*!40103 SET TIME_ZONE='+00:00' */;
 14: /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
 15: /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
 16: /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
 17: /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 18: 
 19: --
 20: -- Table structure for table `fnalert`
 21: --
 22: 
 23: CREATE TABLE `fnalert` (
 24:   `alertid` bigint(20) unsigned NOT NULL auto_increment,
 25:   `nodeid` varchar(64) NOT NULL,
 26:   `alertlevel` int(11) NOT NULL default '0',
 27:   `openedx` bigint(20) unsigned NOT NULL default '0',
 28:   `closedx` bigint(20) unsigned NOT NULL default '0',
 29:   PRIMARY KEY  (`alertid`),
 30:   KEY `nodeid` (`nodeid`),
 31:   KEY `closedx` (`closedx`)
 32: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 33: 
 34: --
 35: -- Table structure for table `fnalertaction`
 36: --
 37: 
 38: CREATE TABLE `fnalertaction` (
 39:   `aaid` bigint(20) unsigned NOT NULL auto_increment,
 40:   `atype` varchar(32) NOT NULL,
 41:   `efrom` varchar(250) NOT NULL,
 42:   `etolist` text NOT NULL,
 43:   `esubject` int(11) NOT NULL default '0',
 44:   `etype` int(11) NOT NULL default '0',
 45:   `awarnings` tinyint(1) NOT NULL default '0',
 46:   `adecrease` tinyint(1) NOT NULL default '0',
 47:   `mdata` text NOT NULL,
 48:   `aname` varchar(120) NOT NULL,
 49:   `ctrdate` varchar(8) NOT NULL,
 50:   `ctrlimit` int(10) unsigned NOT NULL default '0',
 51:   `ctrtoday` int(10) unsigned NOT NULL default '0',
 52:   `scheduleid` bigint(20) unsigned NOT NULL default '0',
 53:   PRIMARY KEY  (`aaid`)
 54: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 55: 
 56: --
 57: -- Table structure for table `fnalertlog`
 58: --
 59: 
 60: CREATE TABLE `fnalertlog` (
 61:   `alid` bigint(20) unsigned NOT NULL auto_increment,
 62:   `alertid` bigint(20) unsigned NOT NULL default '0',
 63:   `postedx` bigint(20) unsigned NOT NULL default '0',
 64:   `logentry` varchar(250) NOT NULL,
 65:   PRIMARY KEY  (`alid`),
 66:   KEY `alertid` (`alertid`)
 67: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 68: 
 69: --
 70: -- Table structure for table `fnconfig`
 71: --
 72: 
 73: CREATE TABLE `fnconfig` (
 74:   `fnc_var` varchar(64) NOT NULL,
 75:   `fnc_val` varchar(64) NOT NULL,
 76:   PRIMARY KEY  (`fnc_var`)
 77: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 78: 
 79: --
 80: -- Table structure for table `fneval`
 81: --
 82: 
 83: CREATE TABLE `fneval` (
 84:   `evalid` bigint(20) unsigned NOT NULL auto_increment,
 85:   `testid` varchar(128) NOT NULL,
 86:   `weight` int(11) NOT NULL default '0',
 87:   `eoperator` varchar(32) NOT NULL,
 88:   `evalue` varchar(128) NOT NULL,
 89:   `eoutcome` int(11) NOT NULL default '0',
 90:   PRIMARY KEY  (`evalid`),
 91:   KEY `testid` (`testid`)
 92: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 93: 
 94: --
 95: -- Table structure for table `fngroup`
 96: --
 97: 
 98: CREATE TABLE `fngroup` (
 99:   `groupid` bigint(20) unsigned NOT NULL auto_increment,
100:   `groupname` varchar(128) NOT NULL,
101:   `groupdesc` varchar(250) NOT NULL,
102:   `groupicon` varchar(64) NOT NULL,
103:   `weight` int(10) unsigned NOT NULL default '0',
104:   PRIMARY KEY  (`groupid`)
105: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
106: 
107: --
108: -- Table structure for table `fngrouplink`
109: --
110: 
111: CREATE TABLE `fngrouplink` (
112:   `glid` bigint(20) unsigned NOT NULL auto_increment,
113:   `groupid` bigint(20) unsigned NOT NULL default '0',
114:   `nodeid` varchar(64) NOT NULL,
115:   PRIMARY KEY  (`glid`),
116:   KEY `groupid` (`groupid`)
117: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
118: 
119: --
120: -- Table structure for table `fnlocaltest`
121: --
122: 
123: CREATE TABLE `fnlocaltest` (
124:   `localtestid` bigint(20) unsigned NOT NULL auto_increment,
125:   `nodeid` varchar(64) NOT NULL,
126:   `alertlevel` int(11) NOT NULL default '-1',
127:   `lastrunx` bigint(20) unsigned NOT NULL default '0',
128:   `testtype` varchar(128) NOT NULL,
129:   `testparam` varchar(250) default NULL,
130:   `testrecord` tinyint(1) NOT NULL default '0',
131:   `simpleeval` tinyint(1) NOT NULL default '1',
132:   `testname` varchar(64) NOT NULL,
133:   `attempts` int(11) NOT NULL default '0',
134:   `timeout` int(11) NOT NULL default '0',
135:   `testenabled` tinyint(1) NOT NULL default '1',
136:   `testparam1` varchar(250) NOT NULL,
137:   `testparam2` varchar(250) NOT NULL,
138:   `testparam3` varchar(250) NOT NULL,
139:   `testparam4` varchar(250) NOT NULL,
140:   `testparam5` varchar(250) NOT NULL,
141:   `testparam6` varchar(250) NOT NULL,
142:   `testparam7` varchar(250) NOT NULL,
143:   `testparam8` varchar(250) NOT NULL,
144:   `testparam9` varchar(250) NOT NULL,
145:   `lastvalue` float NOT NULL default '0',
146:   `testinterval` int(10) unsigned NOT NULL default '0',
147:   `nextrunx` bigint(20) unsigned NOT NULL default '0',
148:   PRIMARY KEY  (`localtestid`),
149:   KEY `nodeid` (`nodeid`)
150: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
151: 
152: --
153: -- Table structure for table `fnlog`
154: --
155: 
156: CREATE TABLE `fnlog` (
157:   `logid` bigint(20) unsigned NOT NULL auto_increment,
158:   `postedx` bigint(20) unsigned NOT NULL default '0',
159:   `modid` varchar(32) NOT NULL,
160:   `catid` varchar(32) NOT NULL,
161:   `username` varchar(64) NOT NULL,
162:   `loglevel` int(11) NOT NULL default '1',
163:   `logevent` varchar(250) NOT NULL,
164:   PRIMARY KEY  (`logid`)
165: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
166: 
167: --
168: -- Table structure for table `fnnalink`
169: --
170: 
171: CREATE TABLE `fnnalink` (
172:   `nalid` bigint(20) unsigned NOT NULL auto_increment,
173:   `nodeid` varchar(64) NOT NULL,
174:   `aaid` bigint(20) unsigned NOT NULL default '0',
175:   PRIMARY KEY  (`nalid`)
176: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
177: 
178: --
179: -- Table structure for table `fnnode`
180: --
181: 
182: CREATE TABLE `fnnode` (
183:   `nodeid` varchar(64) NOT NULL,
184:   `nodename` varchar(128) NOT NULL,
185:   `nodedesc` varchar(254) NOT NULL,
186:   `hostname` varchar(254) NOT NULL,
187:   `nodeenabled` tinyint(1) NOT NULL default '0',
188:   `pingtest` tinyint(1) NOT NULL default '0',
189:   `pingfatal` tinyint(1) NOT NULL default '0',
190:   `alertlevel` int(11) NOT NULL default '-1',
191:   `nodeicon` varchar(64) NOT NULL,
192:   `weight` int(10) unsigned NOT NULL default '0',
193:   `nodealert` tinyint(1) NOT NULL default '1',
194:   `scheduleid` bigint(20) NOT NULL default '0',
195:   `lastrunx` bigint(20) unsigned NOT NULL default '0',
196:   `testinterval` int(10) unsigned NOT NULL default '5',
197:   `nextrunx` bigint(20) unsigned NOT NULL default '0',
198:   `nsenabled` tinyint(1) NOT NULL default '0',
199:   `nsurl` varchar(254) NOT NULL,
200:   `nskey` varchar(128) NOT NULL,
201:   `nspullenabled` tinyint(1) NOT NULL default '0',
202:   `nspushenabled` tinyint(1) NOT NULL default '0',
203:   `nspuship` varchar(128) NOT NULL,
204:   `nsinterval` int(10) unsigned NOT NULL default '15',
205:   `nslastx` bigint(20) unsigned NOT NULL default '0',
206:   `nsnextx` bigint(20) unsigned NOT NULL default '0',
207:   `nspullalert` tinyint(1) NOT NULL default '0',
208:   `nsfreshpush` tinyint(1) NOT NULL default '0',
209:   `masterid` varchar(64) NOT NULL,
210:   `masterjustping` tinyint(1) NOT NULL default '1',
211:   PRIMARY KEY  (`nodeid`),
212:   KEY `masterid` (`masterid`)
213: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
214: 
215: --
216: -- Table structure for table `fnnstest`
217: --
218: 
219: CREATE TABLE `fnnstest` (
220:   `nstestid` bigint(20) unsigned NOT NULL auto_increment,
221:   `nodeid` varchar(64) NOT NULL default '',
222:   `alertlevel` int(11) NOT NULL default '-1',
223:   `lastrunx` bigint(20) unsigned NOT NULL default '0',
224:   `testtype` varchar(128) NOT NULL default '',
225:   `testdesc` varchar(250) default NULL,
226:   `testrecord` tinyint(1) NOT NULL default '0',
227:   `simpleeval` tinyint(1) NOT NULL default '1',
228:   `testname` varchar(64) NOT NULL default '',
229:   `testenabled` tinyint(1) NOT NULL default '0',
230:   `lastvalue` varchar(128) NOT NULL default '',
231:   `testalerts` tinyint(1) NOT NULL default '1',
232:   PRIMARY KEY  (`nstestid`),
233:   KEY `nodeid` (`nodeid`)
234: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
235: 
236: --
237: -- Table structure for table `fnrecord`
238: --
239: 
240: CREATE TABLE `fnrecord` (
241:   `recordid` bigint(20) unsigned NOT NULL auto_increment,
242:   `testid` varchar(128) NOT NULL,
243:   `alertlevel` int(11) NOT NULL default '0',
244:   `testvalue` float NOT NULL default '0',
245:   `recordx` bigint(20) unsigned NOT NULL default '0',
246:   `nodeid` varchar(64) NOT NULL,
247:   PRIMARY KEY  (`recordid`),
248:   KEY `testid` (`testid`),
249:   KEY `recordx` (`recordx`)
250: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
251: 
252: --
253: -- Table structure for table `fnreport`
254: --
255: 
256: CREATE TABLE `fnreport` (
257:   `reportid` bigint(20) unsigned NOT NULL auto_increment,
258:   `reportname` varchar(128) NOT NULL default '',
259:   `reporttests` text NOT NULL,
260:   PRIMARY KEY  (`reportid`)
261: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
262: 
263: --
264: -- Table structure for table `fnscheditem`
265: --
266: 
267: CREATE TABLE `fnscheditem` (
268:   `scheditemid` bigint(20) NOT NULL auto_increment,
269:   `scheduleid` bigint(20) NOT NULL default '0',
270:   `dayofweek` varchar(8) NOT NULL default '',
271:   `dayofmonth` int(11) NOT NULL default '0',
272:   `monthofyear` int(11) NOT NULL default '0',
273:   `year` int(11) NOT NULL default '0',
274:   `starthour` int(11) NOT NULL default '0',
275:   `startmin` int(11) NOT NULL default '0',
276:   `finishhour` int(11) NOT NULL default '23',
277:   `finishmin` int(11) NOT NULL default '59',
278:   PRIMARY KEY  (`scheditemid`)
279: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
280: 
281: --
282: -- Table structure for table `fnschedule`
283: --
284: 
285: CREATE TABLE `fnschedule` (
286:   `scheduleid` bigint(20) unsigned NOT NULL auto_increment,
287:   `schedulename` varchar(128) NOT NULL default '',
288:   `defaultaction` tinyint(1) NOT NULL default '1',
289:   PRIMARY KEY  (`scheduleid`)
290: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
291: 
292: --
293: -- Table structure for table `fnsession`
294: --
295: 
296: CREATE TABLE `fnsession` (
297:   `sessionid` bigint(20) unsigned NOT NULL auto_increment,
298:   `sessionkey` varchar(128) NOT NULL,
299:   `ipaddress` varchar(128) NOT NULL,
300:   `username` varchar(64) NOT NULL,
301:   `startx` bigint(20) unsigned NOT NULL default '0',
302:   `updatex` bigint(20) unsigned NOT NULL default '0',
303:   `userlevel` int(11) NOT NULL default '0',
304:   PRIMARY KEY  (`sessionid`)
305: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
306: 
307: --
308: -- Table structure for table `fntestrun`
309: --
310: 
311: CREATE TABLE `fntestrun` (
312:   `trid` bigint(20) unsigned NOT NULL auto_increment,
313:   `startx` bigint(20) unsigned NOT NULL default '0',
314:   `finishx` bigint(20) unsigned NOT NULL default '0',
315:   `routput` text NOT NULL,
316:   `fnode` varchar(64) NOT NULL,
317:   PRIMARY KEY  (`trid`),
318:   KEY `finishx` (`finishx`),
319:   KEY `fnode` (`fnode`)
320: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
321: 
322: --
323: -- Table structure for table `fnuser`
324: --
325: 
326: CREATE TABLE `fnuser` (
327:   `username` varchar(64) NOT NULL,
328:   `password` varchar(64) NOT NULL,
329:   `realname` varchar(128) NOT NULL,
330:   `userlevel` int(11) NOT NULL default '1',
331:   PRIMARY KEY  (`username`)
332: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
333: 
334: --
335: -- Table structure for table `fnview`
336: --
337: 
338: CREATE TABLE `fnview` (
339:   `viewid` bigint(20) unsigned NOT NULL auto_increment,
340:   `vtitle` varchar(128) NOT NULL default '',
341:   `vstyle` varchar(32) NOT NULL default '',
342:   `vpublic` tinyint(1) NOT NULL default '0',
343:   `vclick` varchar(32) NOT NULL default '',
344:   `vrefresh` int(11) NOT NULL default '0',
345:   `vlinkv` bigint(20) unsigned NOT NULL default '0',
346:   `vcolumns` smallint(6) NOT NULL default '0',
347:   `vcolon` tinyint(1) NOT NULL default '1',
348:   `vdashes` tinyint(1) NOT NULL default '1',
349:   `vtimeago` tinyint(1) NOT NULL default '1',
350:   PRIMARY KEY  (`viewid`)
351: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
352: 
353: --
354: -- Table structure for table `fnviewitem`
355: --
356: 
357: CREATE TABLE `fnviewitem` (
358:   `viewitemid` bigint(20) unsigned NOT NULL auto_increment,
359:   `viewid` bigint(20) unsigned NOT NULL default '0',
360:   `itype` varchar(128) NOT NULL default '',
361:   `ioption` varchar(250) NOT NULL default '',
362:   `icolour` tinyint(1) NOT NULL default '1',
363:   `itextstatus` tinyint(1) NOT NULL default '0',
364:   `idetail` smallint(5) unsigned NOT NULL default '0',
365:   `iweight` int(10) unsigned NOT NULL default '0',
366:   `isize` smallint(6) NOT NULL default '0',
367:   `igraphic` smallint(6) NOT NULL default '0',
368:   `iname` varchar(64) NOT NULL default '',
369:   PRIMARY KEY  (`viewitemid`),
370:   KEY `viewid` (`viewid`)
371: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
372: /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
373: 
374: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
375: /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
376: /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
377: /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
378: /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
379: /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
380: /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
381: 
382: