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