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