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