File:
0.02.35a/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: freenats
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: PRIMARY KEY (`localtestid`)
120: );
121:
122: --
123: -- Table structure for table `fnlog`
124: --
125:
126: CREATE TABLE `fnlog` (
127: `logid` bigint(20) unsigned NOT NULL auto_increment,
128: `postedx` bigint(20) unsigned NOT NULL default '0',
129: `modid` varchar(32) NOT NULL default '',
130: `catid` varchar(32) NOT NULL default '',
131: `username` varchar(64) NOT NULL default '',
132: `loglevel` int(11) NOT NULL default '1',
133: `logevent` varchar(250) NOT NULL default '',
134: PRIMARY KEY (`logid`)
135: );
136:
137: --
138: -- Table structure for table `fnnalink`
139: --
140:
141: CREATE TABLE `fnnalink` (
142: `nalid` bigint(20) unsigned NOT NULL auto_increment,
143: `nodeid` varchar(64) NOT NULL default '',
144: `aaid` bigint(20) unsigned NOT NULL default '0',
145: PRIMARY KEY (`nalid`)
146: );
147:
148: --
149: -- Table structure for table `fnnode`
150: --
151:
152: CREATE TABLE `fnnode` (
153: `nodeid` varchar(64) NOT NULL default '',
154: `nodename` varchar(128) NOT NULL default '',
155: `nodedesc` varchar(254) NOT NULL default '',
156: `hostname` varchar(254) NOT NULL default '',
157: `nodeenabled` tinyint(1) NOT NULL default '0',
158: `pingtest` tinyint(1) NOT NULL default '0',
159: `pingfatal` tinyint(1) NOT NULL default '0',
160: `alertlevel` int(11) NOT NULL default '-1',
161: `nodeicon` varchar(64) NOT NULL default '',
162: `weight` int(10) unsigned NOT NULL default '0',
163: `nodealert` tinyint(1) NOT NULL default '1',
164: PRIMARY KEY (`nodeid`)
165: );
166:
167: --
168: -- Table structure for table `fnrecord`
169: --
170:
171: CREATE TABLE `fnrecord` (
172: `recordid` bigint(20) unsigned NOT NULL auto_increment,
173: `testid` varchar(128) NOT NULL default '',
174: `alertlevel` int(11) NOT NULL default '0',
175: `testvalue` float NOT NULL default '0',
176: `recordx` bigint(20) unsigned NOT NULL default '0',
177: `nodeid` varchar(64) NOT NULL default '',
178: PRIMARY KEY (`recordid`)
179: );
180:
181: --
182: -- Table structure for table `fnsession`
183: --
184:
185: CREATE TABLE `fnsession` (
186: `sessionid` bigint(20) unsigned NOT NULL auto_increment,
187: `sessionkey` varchar(128) NOT NULL default '',
188: `ipaddress` varchar(128) NOT NULL default '',
189: `username` varchar(64) NOT NULL default '',
190: `startx` bigint(20) unsigned NOT NULL default '0',
191: `updatex` bigint(20) unsigned NOT NULL default '0',
192: `userlevel` int(11) NOT NULL default '0',
193: PRIMARY KEY (`sessionid`)
194: );
195:
196: --
197: -- Table structure for table `fntestrun`
198: --
199:
200: CREATE TABLE `fntestrun` (
201: `trid` bigint(20) unsigned NOT NULL auto_increment,
202: `startx` bigint(20) unsigned NOT NULL default '0',
203: `finishx` bigint(20) unsigned NOT NULL default '0',
204: `routput` text NOT NULL,
205: `fnode` varchar(64) NOT NULL default '',
206: PRIMARY KEY (`trid`)
207: );
208:
209: --
210: -- Table structure for table `fnuser`
211: --
212:
213: CREATE TABLE `fnuser` (
214: `username` varchar(64) NOT NULL default '',
215: `password` varchar(64) NOT NULL default '',
216: `realname` varchar(128) NOT NULL default '',
217: `userlevel` int(11) NOT NULL default '1'
218: );
219:
220: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
221: /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
222: /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
223: /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
224:
225: