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