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