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