File:
1.04.3a/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: PRIMARY KEY (`nodeid`),
212: KEY `masterid` (`masterid`)
213: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
214:
215: --
216: -- Table structure for table `fnnstest`
217: --
218:
219: CREATE TABLE `fnnstest` (
220: `nstestid` bigint(20) unsigned NOT NULL auto_increment,
221: `nodeid` varchar(64) NOT NULL default '',
222: `alertlevel` int(11) NOT NULL default '-1',
223: `lastrunx` bigint(20) unsigned NOT NULL default '0',
224: `testtype` varchar(128) NOT NULL default '',
225: `testdesc` varchar(250) default NULL,
226: `testrecord` tinyint(1) NOT NULL default '0',
227: `simpleeval` tinyint(1) NOT NULL default '1',
228: `testname` varchar(64) NOT NULL default '',
229: `testenabled` tinyint(1) NOT NULL default '0',
230: `lastvalue` varchar(128) NOT NULL default '',
231: `testalerts` tinyint(1) NOT NULL default '1',
232: PRIMARY KEY (`nstestid`),
233: KEY `nodeid` (`nodeid`)
234: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
235:
236: --
237: -- Table structure for table `fnrecord`
238: --
239:
240: CREATE TABLE `fnrecord` (
241: `recordid` bigint(20) unsigned NOT NULL auto_increment,
242: `testid` varchar(128) NOT NULL,
243: `alertlevel` int(11) NOT NULL default '0',
244: `testvalue` float NOT NULL default '0',
245: `recordx` bigint(20) unsigned NOT NULL default '0',
246: `nodeid` varchar(64) NOT NULL,
247: PRIMARY KEY (`recordid`),
248: KEY `testid` (`testid`),
249: KEY `recordx` (`recordx`)
250: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
251:
252: --
253: -- Table structure for table `fnreport`
254: --
255:
256: CREATE TABLE `fnreport` (
257: `reportid` bigint(20) unsigned NOT NULL auto_increment,
258: `reportname` varchar(128) NOT NULL default '',
259: `reporttests` text NOT NULL,
260: PRIMARY KEY (`reportid`)
261: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
262:
263: --
264: -- Table structure for table `fnscheditem`
265: --
266:
267: CREATE TABLE `fnscheditem` (
268: `scheditemid` bigint(20) NOT NULL auto_increment,
269: `scheduleid` bigint(20) NOT NULL default '0',
270: `dayofweek` varchar(8) NOT NULL default '',
271: `dayofmonth` int(11) NOT NULL default '0',
272: `monthofyear` int(11) NOT NULL default '0',
273: `year` int(11) NOT NULL default '0',
274: `starthour` int(11) NOT NULL default '0',
275: `startmin` int(11) NOT NULL default '0',
276: `finishhour` int(11) NOT NULL default '23',
277: `finishmin` int(11) NOT NULL default '59',
278: PRIMARY KEY (`scheditemid`)
279: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
280:
281: --
282: -- Table structure for table `fnschedule`
283: --
284:
285: CREATE TABLE `fnschedule` (
286: `scheduleid` bigint(20) unsigned NOT NULL auto_increment,
287: `schedulename` varchar(128) NOT NULL default '',
288: `defaultaction` tinyint(1) NOT NULL default '1',
289: PRIMARY KEY (`scheduleid`)
290: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
291:
292: --
293: -- Table structure for table `fnsession`
294: --
295:
296: CREATE TABLE `fnsession` (
297: `sessionid` bigint(20) unsigned NOT NULL auto_increment,
298: `sessionkey` varchar(128) NOT NULL,
299: `ipaddress` varchar(128) NOT NULL,
300: `username` varchar(64) NOT NULL,
301: `startx` bigint(20) unsigned NOT NULL default '0',
302: `updatex` bigint(20) unsigned NOT NULL default '0',
303: `userlevel` int(11) NOT NULL default '0',
304: PRIMARY KEY (`sessionid`)
305: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
306:
307: --
308: -- Table structure for table `fntestrun`
309: --
310:
311: CREATE TABLE `fntestrun` (
312: `trid` bigint(20) unsigned NOT NULL auto_increment,
313: `startx` bigint(20) unsigned NOT NULL default '0',
314: `finishx` bigint(20) unsigned NOT NULL default '0',
315: `routput` text NOT NULL,
316: `fnode` varchar(64) NOT NULL,
317: PRIMARY KEY (`trid`),
318: KEY `finishx` (`finishx`),
319: KEY `fnode` (`fnode`)
320: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
321:
322: --
323: -- Table structure for table `fnuser`
324: --
325:
326: CREATE TABLE `fnuser` (
327: `username` varchar(64) NOT NULL,
328: `password` varchar(64) NOT NULL,
329: `realname` varchar(128) NOT NULL,
330: `userlevel` int(11) NOT NULL default '1',
331: PRIMARY KEY (`username`)
332: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
333:
334: --
335: -- Table structure for table `fnview`
336: --
337:
338: CREATE TABLE `fnview` (
339: `viewid` bigint(20) unsigned NOT NULL auto_increment,
340: `vtitle` varchar(128) NOT NULL default '',
341: `vstyle` varchar(32) NOT NULL default '',
342: `vpublic` tinyint(1) NOT NULL default '0',
343: `vclick` varchar(32) NOT NULL default '',
344: `vrefresh` int(11) NOT NULL default '0',
345: `vlinkv` bigint(20) unsigned NOT NULL default '0',
346: `vcolumns` smallint(6) NOT NULL default '0',
347: `vcolon` tinyint(1) NOT NULL default '1',
348: `vdashes` tinyint(1) NOT NULL default '1',
349: `vtimeago` tinyint(1) NOT NULL default '1',
350: PRIMARY KEY (`viewid`)
351: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
352:
353: --
354: -- Table structure for table `fnviewitem`
355: --
356:
357: CREATE TABLE `fnviewitem` (
358: `viewitemid` bigint(20) unsigned NOT NULL auto_increment,
359: `viewid` bigint(20) unsigned NOT NULL default '0',
360: `itype` varchar(128) NOT NULL default '',
361: `ioption` varchar(250) NOT NULL default '',
362: `icolour` tinyint(1) NOT NULL default '1',
363: `itextstatus` tinyint(1) NOT NULL default '0',
364: `idetail` smallint(5) unsigned NOT NULL default '0',
365: `iweight` int(10) unsigned NOT NULL default '0',
366: `isize` smallint(6) NOT NULL default '0',
367: `igraphic` smallint(6) NOT NULL default '0',
368: `iname` varchar(64) NOT NULL default '',
369: PRIMARY KEY (`viewitemid`),
370: KEY `viewid` (`viewid`)
371: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
372: /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
373:
374: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
375: /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
376: /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
377: /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
378: /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
379: /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
380: /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
381:
382: