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