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