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