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:   `ulink0` tinyint(1) NOT NULL default '0',
223:   `ulink0_title` varchar(254) NOT NULL default 'VNC',
224:   `ulink0_url` varchar(254) NOT NULL default 'http://{HOSTNAME}:5800/',
225:   `ulink1` tinyint(1) NOT NULL default '0',
226:   `ulink1_title` varchar(254) NOT NULL default 'SSH',
227:   `ulink1_url` varchar(254) NOT NULL default 'ssh://{HOSTNAME}',
228:   `ulink2` tinyint(1) NOT NULL default '0',
229:   `ulink2_title` varchar(254) NOT NULL default 'Web',
230:   `ulink2_url` varchar(254) NOT NULL default 'http://{HOSTNAME}',
231:   PRIMARY KEY  (`nodeid`),
232:   KEY `masterid` (`masterid`)
233: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
234: 
235: --
236: -- Table structure for table `fnnstest`
237: --
238: 
239: DROP TABLE IF EXISTS `fnnstest`;
240: CREATE TABLE `fnnstest` (
241:   `nstestid` bigint(20) unsigned NOT NULL auto_increment,
242:   `nodeid` varchar(64) NOT NULL default '',
243:   `alertlevel` int(11) NOT NULL default '-1',
244:   `lastrunx` bigint(20) unsigned NOT NULL default '0',
245:   `testtype` varchar(128) NOT NULL default '',
246:   `testdesc` varchar(250) default NULL,
247:   `testrecord` tinyint(1) NOT NULL default '0',
248:   `simpleeval` tinyint(1) NOT NULL default '1',
249:   `testname` varchar(64) NOT NULL default '',
250:   `testenabled` tinyint(1) NOT NULL default '0',
251:   `lastvalue` varchar(128) NOT NULL default '',
252:   `testalerts` tinyint(1) NOT NULL default '1',
253:   PRIMARY KEY  (`nstestid`),
254:   KEY `nodeid` (`nodeid`)
255: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
256: 
257: --
258: -- Table structure for table `fnrecord`
259: --
260: 
261: DROP TABLE IF EXISTS `fnrecord`;
262: CREATE TABLE `fnrecord` (
263:   `recordid` bigint(20) unsigned NOT NULL auto_increment,
264:   `testid` varchar(128) NOT NULL,
265:   `alertlevel` int(11) NOT NULL default '0',
266:   `testvalue` float NOT NULL default '0',
267:   `recordx` bigint(20) unsigned NOT NULL default '0',
268:   `nodeid` varchar(64) NOT NULL,
269:   PRIMARY KEY  (`recordid`),
270:   KEY `testid` (`testid`),
271:   KEY `recordx` (`recordx`)
272: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
273: 
274: --
275: -- Table structure for table `fnreport`
276: --
277: 
278: DROP TABLE IF EXISTS `fnreport`;
279: CREATE TABLE `fnreport` (
280:   `reportid` bigint(20) unsigned NOT NULL auto_increment,
281:   `reportname` varchar(128) NOT NULL default '',
282:   `reporttests` text NOT NULL,
283:   PRIMARY KEY  (`reportid`)
284: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
285: 
286: --
287: -- Table structure for table `fnscheditem`
288: --
289: 
290: DROP TABLE IF EXISTS `fnscheditem`;
291: CREATE TABLE `fnscheditem` (
292:   `scheditemid` bigint(20) NOT NULL auto_increment,
293:   `scheduleid` bigint(20) NOT NULL default '0',
294:   `dayofweek` varchar(8) NOT NULL default '',
295:   `dayofmonth` int(11) NOT NULL default '0',
296:   `monthofyear` int(11) NOT NULL default '0',
297:   `year` int(11) NOT NULL default '0',
298:   `starthour` int(11) NOT NULL default '0',
299:   `startmin` int(11) NOT NULL default '0',
300:   `finishhour` int(11) NOT NULL default '23',
301:   `finishmin` int(11) NOT NULL default '59',
302:   PRIMARY KEY  (`scheditemid`)
303: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
304: 
305: --
306: -- Table structure for table `fnschedule`
307: --
308: 
309: DROP TABLE IF EXISTS `fnschedule`;
310: CREATE TABLE `fnschedule` (
311:   `scheduleid` bigint(20) unsigned NOT NULL auto_increment,
312:   `schedulename` varchar(128) NOT NULL default '',
313:   `defaultaction` tinyint(1) NOT NULL default '1',
314:   PRIMARY KEY  (`scheduleid`)
315: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
316: 
317: --
318: -- Table structure for table `fnsession`
319: --
320: 
321: DROP TABLE IF EXISTS `fnsession`;
322: CREATE TABLE `fnsession` (
323:   `sessionid` bigint(20) unsigned NOT NULL auto_increment,
324:   `sessionkey` varchar(128) NOT NULL,
325:   `ipaddress` varchar(128) NOT NULL,
326:   `username` varchar(64) NOT NULL,
327:   `startx` bigint(20) unsigned NOT NULL default '0',
328:   `updatex` bigint(20) unsigned NOT NULL default '0',
329:   `userlevel` int(11) NOT NULL default '0',
330:   PRIMARY KEY  (`sessionid`)
331: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
332: 
333: --
334: -- Table structure for table `fntestrun`
335: --
336: 
337: DROP TABLE IF EXISTS `fntestrun`;
338: CREATE TABLE `fntestrun` (
339:   `trid` bigint(20) unsigned NOT NULL auto_increment,
340:   `startx` bigint(20) unsigned NOT NULL default '0',
341:   `finishx` bigint(20) unsigned NOT NULL default '0',
342:   `routput` text NOT NULL,
343:   `fnode` varchar(64) NOT NULL,
344:   PRIMARY KEY  (`trid`),
345:   KEY `finishx` (`finishx`),
346:   KEY `fnode` (`fnode`)
347: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
348: 
349: --
350: -- Table structure for table `fnuser`
351: --
352: 
353: DROP TABLE IF EXISTS `fnuser`;
354: CREATE TABLE `fnuser` (
355:   `username` varchar(64) NOT NULL,
356:   `password` varchar(64) NOT NULL,
357:   `realname` varchar(128) NOT NULL,
358:   `userlevel` int(11) NOT NULL default '1',
359:   PRIMARY KEY  (`username`)
360: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
361: 
362: --
363: -- Table structure for table `fnview`
364: --
365: 
366: DROP TABLE IF EXISTS `fnview`;
367: CREATE TABLE `fnview` (
368:   `viewid` bigint(20) unsigned NOT NULL auto_increment,
369:   `vtitle` varchar(128) NOT NULL default '',
370:   `vstyle` varchar(32) NOT NULL default '',
371:   `vpublic` tinyint(1) NOT NULL default '0',
372:   `vclick` varchar(32) NOT NULL default '',
373:   `vrefresh` int(11) NOT NULL default '0',
374:   `vlinkv` bigint(20) unsigned NOT NULL default '0',
375:   `vcolumns` smallint(6) NOT NULL default '0',
376:   `vcolon` tinyint(1) NOT NULL default '1',
377:   `vdashes` tinyint(1) NOT NULL default '1',
378:   `vtimeago` tinyint(1) NOT NULL default '1',
379:   PRIMARY KEY  (`viewid`)
380: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
381: 
382: --
383: -- Table structure for table `fnviewitem`
384: --
385: 
386: DROP TABLE IF EXISTS `fnviewitem`;
387: CREATE TABLE `fnviewitem` (
388:   `viewitemid` bigint(20) unsigned NOT NULL auto_increment,
389:   `viewid` bigint(20) unsigned NOT NULL default '0',
390:   `itype` varchar(128) NOT NULL default '',
391:   `ioption` varchar(250) NOT NULL default '',
392:   `icolour` tinyint(1) NOT NULL default '1',
393:   `itextstatus` tinyint(1) NOT NULL default '0',
394:   `idetail` smallint(5) unsigned NOT NULL default '0',
395:   `iweight` int(10) unsigned NOT NULL default '0',
396:   `isize` smallint(6) NOT NULL default '0',
397:   `igraphic` smallint(6) NOT NULL default '0',
398:   `iname` varchar(64) NOT NULL default '',
399:   PRIMARY KEY  (`viewitemid`),
400:   KEY `viewid` (`viewid`)
401: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
402: /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
403: 
404: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
405: /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
406: /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
407: /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
408: /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
409: /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
410: /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
411: 
412: