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