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