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