1: -- No DROP TABLES - suitable for upgrade
  2: -- MySQL dump 10.10
  3: --
  4: -- Host: localhost    Database: freenats
  5: -- ------------------------------------------------------
  6: -- Server version	5.0.22
  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: /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
 13: /*!40103 SET TIME_ZONE='+00:00' */;
 14: /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
 15: /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
 16: /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
 17: /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 18: 
 19: --
 20: -- Table structure for table `fnalert`
 21: --
 22: 
 23: CREATE TABLE `fnalert` (
 24:   `alertid` bigint(20) unsigned NOT NULL auto_increment,
 25:   `nodeid` varchar(64) NOT NULL,
 26:   `alertlevel` int(11) NOT NULL default '0',
 27:   `openedx` bigint(20) unsigned NOT NULL default '0',
 28:   `closedx` bigint(20) unsigned NOT NULL default '0',
 29:   PRIMARY KEY  (`alertid`),
 30:   KEY `nodeid` (`nodeid`),
 31:   KEY `closedx` (`closedx`)
 32: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 33: 
 34: --
 35: -- Table structure for table `fnalertaction`
 36: --
 37: 
 38: CREATE TABLE `fnalertaction` (
 39:   `aaid` bigint(20) unsigned NOT NULL auto_increment,
 40:   `atype` varchar(32) NOT NULL,
 41:   `efrom` varchar(250) NOT NULL,
 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,
 49:   `ctrdate` varchar(8) NOT NULL,
 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: CREATE TABLE `fnalertlog` (
 61:   `alid` bigint(20) unsigned NOT NULL auto_increment,
 62:   `alertid` bigint(20) unsigned NOT NULL default '0',
 63:   `postedx` bigint(20) unsigned NOT NULL default '0',
 64:   `logentry` varchar(250) NOT NULL,
 65:   PRIMARY KEY  (`alid`),
 66:   KEY `alertid` (`alertid`)
 67: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 68: 
 69: --
 70: -- Table structure for table `fnconfig`
 71: --
 72: 
 73: CREATE TABLE `fnconfig` (
 74:   `fnc_var` varchar(64) NOT NULL,
 75:   `fnc_val` varchar(64) NOT NULL,
 76:   PRIMARY KEY  (`fnc_var`)
 77: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 78: 
 79: --
 80: -- Table structure for table `fneval`
 81: --
 82: 
 83: CREATE TABLE `fneval` (
 84:   `evalid` bigint(20) unsigned NOT NULL auto_increment,
 85:   `testid` varchar(128) NOT NULL,
 86:   `weight` int(11) NOT NULL default '0',
 87:   `eoperator` varchar(32) NOT NULL,
 88:   `evalue` varchar(128) NOT NULL,
 89:   `eoutcome` int(11) NOT NULL default '0',
 90:   PRIMARY KEY  (`evalid`),
 91:   KEY `testid` (`testid`)
 92: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 93: 
 94: --
 95: -- Table structure for table `fngroup`
 96: --
 97: 
 98: CREATE TABLE `fngroup` (
 99:   `groupid` bigint(20) unsigned NOT NULL auto_increment,
100:   `groupname` varchar(128) NOT NULL,
101:   `groupdesc` varchar(250) NOT NULL,
102:   `groupicon` varchar(64) NOT NULL,
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: 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,
115:   PRIMARY KEY  (`glid`),
116:   KEY `groupid` (`groupid`)
117: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
118: 
119: --
120: -- Table structure for table `fnlocaltest`
121: --
122: 
123: CREATE TABLE `fnlocaltest` (
124:   `localtestid` bigint(20) unsigned NOT NULL auto_increment,
125:   `nodeid` varchar(64) NOT NULL,
126:   `alertlevel` int(11) NOT NULL default '-1',
127:   `lastrunx` bigint(20) unsigned NOT NULL default '0',
128:   `testtype` varchar(128) NOT NULL,
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,
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,
137:   `testparam2` varchar(250) NOT NULL,
138:   `testparam3` varchar(250) NOT NULL,
139:   `testparam4` varchar(250) NOT NULL,
140:   `testparam5` varchar(250) NOT NULL,
141:   `testparam6` varchar(250) NOT NULL,
142:   `testparam7` varchar(250) NOT NULL,
143:   `testparam8` varchar(250) NOT NULL,
144:   `testparam9` varchar(250) NOT NULL,
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: CREATE TABLE `fnlog` (
157:   `logid` bigint(20) unsigned NOT NULL auto_increment,
158:   `postedx` bigint(20) unsigned NOT NULL default '0',
159:   `modid` varchar(32) NOT NULL,
160:   `catid` varchar(32) NOT NULL,
161:   `username` varchar(64) NOT NULL,
162:   `loglevel` int(11) NOT NULL default '1',
163:   `logevent` varchar(250) NOT NULL,
164:   PRIMARY KEY  (`logid`)
165: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
166: 
167: --
168: -- Table structure for table `fnnalink`
169: --
170: 
171: CREATE TABLE `fnnalink` (
172:   `nalid` bigint(20) unsigned NOT NULL auto_increment,
173:   `nodeid` varchar(64) NOT NULL,
174:   `aaid` bigint(20) unsigned NOT NULL default '0',
175:   PRIMARY KEY  (`nalid`)
176: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
177: 
178: --
179: -- Table structure for table `fnnode`
180: --
181: 
182: CREATE TABLE `fnnode` (
183:   `nodeid` varchar(64) NOT NULL,
184:   `nodename` varchar(128) NOT NULL,
185:   `nodedesc` varchar(254) NOT NULL,
186:   `hostname` varchar(254) NOT NULL,
187:   `nodeenabled` tinyint(1) NOT NULL default '0',
188:   `pingtest` tinyint(1) NOT NULL default '0',
189:   `pingfatal` tinyint(1) NOT NULL default '0',
190:   `alertlevel` int(11) NOT NULL default '-1',
191:   `nodeicon` varchar(64) NOT NULL,
192:   `weight` int(10) unsigned NOT NULL default '0',
193:   `nodealert` tinyint(1) NOT NULL default '1',
194:   `scheduleid` bigint(20) NOT NULL default '0',
195:   `lastrunx` bigint(20) unsigned NOT NULL default '0',
196:   `testinterval` int(10) unsigned NOT NULL default '5',
197:   `nextrunx` bigint(20) unsigned NOT NULL default '0',
198:   `nsenabled` tinyint(1) NOT NULL default '0',
199:   `nsurl` varchar(254) NOT NULL,
200:   `nskey` varchar(128) NOT NULL,
201:   `nspullenabled` tinyint(1) NOT NULL default '0',
202:   `nspushenabled` tinyint(1) NOT NULL default '0',
203:   `nspuship` varchar(128) NOT NULL,
204:   `nsinterval` int(10) unsigned NOT NULL default '15',
205:   `nslastx` bigint(20) unsigned NOT NULL default '0',
206:   `nsnextx` bigint(20) unsigned NOT NULL default '0',
207:   `nspullalert` tinyint(1) NOT NULL default '0',
208:   `nsfreshpush` tinyint(1) NOT NULL default '0',
209:   `masterid` varchar(64) NOT NULL,
210:   `masterjustping` tinyint(1) NOT NULL default '1',
211:   `ulink0` tinyint(1) NOT NULL default '0',
212:   `ulink0_title` varchar(254) NOT NULL default 'VNC',
213:   `ulink0_url` varchar(254) NOT NULL default 'http://{HOSTNAME}:5800/',
214:   `ulink1` tinyint(1) NOT NULL default '0',
215:   `ulink1_title` varchar(254) NOT NULL default 'SSH',
216:   `ulink1_url` varchar(254) NOT NULL default 'ssh://{HOSTNAME}',
217:   `ulink2` tinyint(1) NOT NULL default '0',
218:   `ulink2_title` varchar(254) NOT NULL default 'Web',
219:   `ulink2_url` varchar(254) NOT NULL default 'http://{HOSTNAME}',
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: CREATE TABLE `fnnstest` (
229:   `nstestid` bigint(20) unsigned NOT NULL auto_increment,
230:   `nodeid` varchar(64) NOT NULL default '',
231:   `alertlevel` int(11) NOT NULL default '-1',
232:   `lastrunx` bigint(20) unsigned NOT NULL default '0',
233:   `testtype` varchar(128) NOT NULL default '',
234:   `testdesc` varchar(250) default NULL,
235:   `testrecord` tinyint(1) NOT NULL default '0',
236:   `simpleeval` tinyint(1) NOT NULL default '1',
237:   `testname` varchar(64) NOT NULL default '',
238:   `testenabled` tinyint(1) NOT NULL default '0',
239:   `lastvalue` varchar(128) NOT NULL default '',
240:   `testalerts` tinyint(1) NOT NULL default '1',
241:   PRIMARY KEY  (`nstestid`),
242:   KEY `nodeid` (`nodeid`)
243: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
244: 
245: --
246: -- Table structure for table `fnrecord`
247: --
248: 
249: CREATE TABLE `fnrecord` (
250:   `recordid` bigint(20) unsigned NOT NULL auto_increment,
251:   `testid` varchar(128) NOT NULL,
252:   `alertlevel` int(11) NOT NULL default '0',
253:   `testvalue` float NOT NULL default '0',
254:   `recordx` bigint(20) unsigned NOT NULL default '0',
255:   `nodeid` varchar(64) NOT NULL,
256:   PRIMARY KEY  (`recordid`),
257:   KEY `testid` (`testid`),
258:   KEY `recordx` (`recordx`)
259: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
260: 
261: --
262: -- Table structure for table `fnreport`
263: --
264: 
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: CREATE TABLE `fnscheditem` (
277:   `scheditemid` bigint(20) NOT NULL auto_increment,
278:   `scheduleid` bigint(20) NOT NULL default '0',
279:   `dayofweek` varchar(8) NOT NULL default '',
280:   `dayofmonth` int(11) NOT NULL default '0',
281:   `monthofyear` int(11) NOT NULL default '0',
282:   `year` int(11) NOT NULL default '0',
283:   `starthour` int(11) NOT NULL default '0',
284:   `startmin` int(11) NOT NULL default '0',
285:   `finishhour` int(11) NOT NULL default '23',
286:   `finishmin` int(11) NOT NULL default '59',
287:   PRIMARY KEY  (`scheditemid`)
288: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
289: 
290: --
291: -- Table structure for table `fnschedule`
292: --
293: 
294: CREATE TABLE `fnschedule` (
295:   `scheduleid` bigint(20) unsigned NOT NULL auto_increment,
296:   `schedulename` varchar(128) NOT NULL default '',
297:   `defaultaction` tinyint(1) NOT NULL default '1',
298:   PRIMARY KEY  (`scheduleid`)
299: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
300: 
301: --
302: -- Table structure for table `fnsession`
303: --
304: 
305: CREATE TABLE `fnsession` (
306:   `sessionid` bigint(20) unsigned NOT NULL auto_increment,
307:   `sessionkey` varchar(128) NOT NULL,
308:   `ipaddress` varchar(128) NOT NULL,
309:   `username` varchar(64) NOT NULL,
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: CREATE TABLE `fntestrun` (
321:   `trid` bigint(20) unsigned NOT NULL auto_increment,
322:   `startx` bigint(20) unsigned NOT NULL default '0',
323:   `finishx` bigint(20) unsigned NOT NULL default '0',
324:   `routput` text NOT NULL,
325:   `fnode` varchar(64) NOT NULL,
326:   PRIMARY KEY  (`trid`),
327:   KEY `finishx` (`finishx`),
328:   KEY `fnode` (`fnode`)
329: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
330: 
331: --
332: -- Table structure for table `fnuser`
333: --
334: 
335: CREATE TABLE `fnuser` (
336:   `username` varchar(64) NOT NULL,
337:   `password` varchar(64) NOT NULL,
338:   `realname` varchar(128) NOT NULL,
339:   `userlevel` int(11) NOT NULL default '1',
340:   PRIMARY KEY  (`username`)
341: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
342: 
343: --
344: -- Table structure for table `fnview`
345: --
346: 
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: 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: /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
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: