File:
1.00.10a/server/base/sql/schema.sql (
View as Code)
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) 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 `fnreport`
238: --
239:
240: CREATE TABLE `fnreport` (
241: `reportid` bigint(20) unsigned NOT NULL auto_increment,
242: `reportname` varchar(128) NOT NULL default '',
243: `reporttests` text NOT NULL,
244: PRIMARY KEY (`reportid`)
245: );
246:
247: --
248: -- Table structure for table `fnscheditem`
249: --
250:
251: CREATE TABLE `fnscheditem` (
252: `scheditemid` bigint(20) NOT NULL auto_increment,
253: `scheduleid` bigint(20) NOT NULL default '0',
254: `dayofweek` varchar(8) NOT NULL default '',
255: `dayofmonth` int(11) NOT NULL default '0',
256: `monthofyear` int(11) NOT NULL default '0',
257: `year` int(11) NOT NULL default '0',
258: `starthour` int(11) NOT NULL default '0',
259: `startmin` int(11) NOT NULL default '0',
260: `finishhour` int(11) NOT NULL default '23',
261: `finishmin` int(11) NOT NULL default '59',
262: PRIMARY KEY (`scheditemid`)
263: );
264:
265: --
266: -- Table structure for table `fnschedule`
267: --
268:
269: CREATE TABLE `fnschedule` (
270: `scheduleid` bigint(20) unsigned NOT NULL auto_increment,
271: `schedulename` varchar(128) NOT NULL default '',
272: `defaultaction` tinyint(1) NOT NULL default '1',
273: PRIMARY KEY (`scheduleid`)
274: );
275:
276: --
277: -- Table structure for table `fnsession`
278: --
279:
280: CREATE TABLE `fnsession` (
281: `sessionid` bigint(20) unsigned NOT NULL auto_increment,
282: `sessionkey` varchar(128) NOT NULL default '',
283: `ipaddress` varchar(128) NOT NULL default '',
284: `username` varchar(64) NOT NULL default '',
285: `startx` bigint(20) unsigned NOT NULL default '0',
286: `updatex` bigint(20) unsigned NOT NULL default '0',
287: `userlevel` int(11) NOT NULL default '0',
288: PRIMARY KEY (`sessionid`)
289: );
290:
291: --
292: -- Table structure for table `fntestrun`
293: --
294:
295: CREATE TABLE `fntestrun` (
296: `trid` bigint(20) unsigned NOT NULL auto_increment,
297: `startx` bigint(20) unsigned NOT NULL default '0',
298: `finishx` bigint(20) unsigned NOT NULL default '0',
299: `routput` text NOT NULL,
300: `fnode` varchar(64) NOT NULL default '',
301: PRIMARY KEY (`trid`),
302: KEY `fnode` (`fnode`)
303: );
304:
305: --
306: -- Table structure for table `fnuser`
307: --
308:
309: CREATE TABLE `fnuser` (
310: `username` varchar(64) NOT NULL default '',
311: `password` varchar(64) NOT NULL default '',
312: `realname` varchar(128) NOT NULL default '',
313: `userlevel` int(11) NOT NULL default '1',
314: PRIMARY KEY (`username`)
315: );
316:
317: --
318: -- Table structure for table `fnview`
319: --
320:
321: CREATE TABLE `fnview` (
322: `viewid` bigint(20) unsigned NOT NULL auto_increment,
323: `vtitle` varchar(128) NOT NULL default '',
324: `vstyle` varchar(32) NOT NULL default '',
325: `vpublic` tinyint(1) NOT NULL default '0',
326: `vclick` varchar(32) NOT NULL default '',
327: `vrefresh` int(11) NOT NULL default '0',
328: `vlinkv` bigint(20) unsigned NOT NULL default '0',
329: `vcolumns` smallint(6) NOT NULL default '0',
330: `vcolon` tinyint(1) NOT NULL default '1',
331: `vdashes` tinyint(1) NOT NULL default '1',
332: `vtimeago` tinyint(1) NOT NULL default '1',
333: PRIMARY KEY (`viewid`)
334: );
335:
336: --
337: -- Table structure for table `fnviewitem`
338: --
339:
340: CREATE TABLE `fnviewitem` (
341: `viewitemid` bigint(20) unsigned NOT NULL auto_increment,
342: `viewid` bigint(20) unsigned NOT NULL default '0',
343: `itype` varchar(128) NOT NULL default '',
344: `ioption` varchar(250) NOT NULL default '',
345: `icolour` tinyint(1) NOT NULL default '1',
346: `itextstatus` tinyint(1) NOT NULL default '0',
347: `idetail` smallint(5) unsigned NOT NULL default '0',
348: `iweight` int(10) unsigned NOT NULL default '0',
349: `isize` smallint(6) NOT NULL default '0',
350: `igraphic` smallint(6) NOT NULL default '0',
351: `iname` varchar(64) NOT NULL default '',
352: PRIMARY KEY (`viewitemid`),
353: KEY `viewid` (`viewid`)
354: );
355:
356: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
357: /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
358: /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
359: /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
360:
361: