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