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