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