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