File:
0.02.19a/server/base/sql/schema.sql (
View as Code)
1: -- phpMyAdmin SQL Dump
2: -- version 2.10.0.2
3: -- http://www.phpmyadmin.net
4: --
5: -- Host: localhost
6: -- Generation Time: Mar 02, 2008 at 07:54 PM
7: -- Server version: 4.1.14
8: -- PHP Version: 5.0.4
9:
10: SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11:
12: --
13: -- Database: `freenats`
14: --
15:
16: -- --------------------------------------------------------
17:
18: --
19: -- Table structure for table `fnalert`
20: --
21:
22: CREATE TABLE IF NOT EXISTS `fnalert` (
23: `alertid` bigint(20) unsigned NOT NULL auto_increment,
24: `nodeid` varchar(64) NOT NULL default '',
25: `alertlevel` int(11) NOT NULL default '0',
26: `openedx` bigint(20) unsigned NOT NULL default '0',
27: `closedx` bigint(20) unsigned NOT NULL default '0',
28: PRIMARY KEY (`alertid`)
29: ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=134 ;
30:
31: -- --------------------------------------------------------
32:
33: --
34: -- Table structure for table `fnalertaction`
35: --
36:
37: CREATE TABLE IF NOT EXISTS `fnalertaction` (
38: `aaid` bigint(20) unsigned NOT NULL auto_increment,
39: `atype` varchar(32) NOT NULL default '',
40: `efrom` varchar(250) NOT NULL default '',
41: `etolist` text NOT NULL,
42: `esubject` int(11) NOT NULL default '0',
43: `etype` int(11) NOT NULL default '0',
44: `awarnings` tinyint(1) NOT NULL default '0',
45: `adecrease` tinyint(1) NOT NULL default '0',
46: `mdata` text NOT NULL,
47: `aname` varchar(120) NOT NULL default '',
48: PRIMARY KEY (`aaid`)
49: ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
50:
51: -- --------------------------------------------------------
52:
53: --
54: -- Table structure for table `fnalertlog`
55: --
56:
57: CREATE TABLE IF NOT EXISTS `fnalertlog` (
58: `alid` bigint(20) unsigned NOT NULL auto_increment,
59: `alertid` bigint(20) unsigned NOT NULL default '0',
60: `postedx` bigint(20) unsigned NOT NULL default '0',
61: `logentry` varchar(250) NOT NULL default '',
62: PRIMARY KEY (`alid`)
63: ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=643 ;
64:
65: -- --------------------------------------------------------
66:
67: --
68: -- Table structure for table `fnconfig`
69: --
70:
71: CREATE TABLE IF NOT EXISTS `fnconfig` (
72: `fnc_var` varchar(64) NOT NULL default '',
73: `fnc_val` varchar(64) NOT NULL default '',
74: PRIMARY KEY (`fnc_var`)
75: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
76:
77: -- --------------------------------------------------------
78:
79: --
80: -- Table structure for table `fneval`
81: --
82:
83: CREATE TABLE IF NOT EXISTS `fneval` (
84: `evalid` bigint(20) unsigned NOT NULL auto_increment,
85: `testid` varchar(128) NOT NULL default '',
86: `weight` int(11) NOT NULL default '0',
87: `eoperator` varchar(32) NOT NULL default '',
88: `evalue` varchar(128) NOT NULL default '',
89: `eoutcome` int(11) NOT NULL default '0',
90: PRIMARY KEY (`evalid`)
91: ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;
92:
93: -- --------------------------------------------------------
94:
95: --
96: -- Table structure for table `fngroup`
97: --
98:
99: CREATE TABLE IF NOT EXISTS `fngroup` (
100: `groupid` bigint(20) unsigned NOT NULL auto_increment,
101: `groupname` varchar(128) NOT NULL default '',
102: `groupdesc` varchar(250) NOT NULL default '',
103: `groupicon` varchar(64) NOT NULL default '',
104: `weight` int(10) unsigned NOT NULL default '0',
105: PRIMARY KEY (`groupid`)
106: ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
107:
108: -- --------------------------------------------------------
109:
110: --
111: -- Table structure for table `fngrouplink`
112: --
113:
114: CREATE TABLE IF NOT EXISTS `fngrouplink` (
115: `glid` bigint(20) unsigned NOT NULL auto_increment,
116: `groupid` bigint(20) unsigned NOT NULL default '0',
117: `nodeid` varchar(64) NOT NULL default '',
118: PRIMARY KEY (`glid`)
119: ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=53 ;
120:
121: -- --------------------------------------------------------
122:
123: --
124: -- Table structure for table `fnlocaltest`
125: --
126:
127: CREATE TABLE IF NOT EXISTS `fnlocaltest` (
128: `localtestid` bigint(20) unsigned NOT NULL auto_increment,
129: `nodeid` varchar(64) NOT NULL default '',
130: `alertlevel` int(11) NOT NULL default '-1',
131: `lastrunx` bigint(20) unsigned NOT NULL default '0',
132: `testtype` varchar(128) NOT NULL default '',
133: `testparam` varchar(250) default NULL,
134: `testrecord` tinyint(1) NOT NULL default '0',
135: `simpleeval` tinyint(1) NOT NULL default '1',
136: PRIMARY KEY (`localtestid`)
137: ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;
138:
139: -- --------------------------------------------------------
140:
141: --
142: -- Table structure for table `fnlog`
143: --
144:
145: CREATE TABLE IF NOT EXISTS `fnlog` (
146: `logid` bigint(20) unsigned NOT NULL auto_increment,
147: `postedx` bigint(20) unsigned NOT NULL default '0',
148: `modid` varchar(32) NOT NULL default '',
149: `catid` varchar(32) NOT NULL default '',
150: `username` varchar(64) NOT NULL default '',
151: `loglevel` int(11) NOT NULL default '1',
152: `logevent` varchar(250) NOT NULL default '',
153: PRIMARY KEY (`logid`)
154: ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=90921 ;
155:
156: -- --------------------------------------------------------
157:
158: --
159: -- Table structure for table `fnnalink`
160: --
161:
162: CREATE TABLE IF NOT EXISTS `fnnalink` (
163: `nalid` bigint(20) unsigned NOT NULL auto_increment,
164: `nodeid` varchar(64) NOT NULL default '',
165: `aaid` bigint(20) unsigned NOT NULL default '0',
166: PRIMARY KEY (`nalid`)
167: ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
168:
169: -- --------------------------------------------------------
170:
171: --
172: -- Table structure for table `fnnode`
173: --
174:
175: CREATE TABLE IF NOT EXISTS `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: PRIMARY KEY (`nodeid`)
187: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
188:
189: -- --------------------------------------------------------
190:
191: --
192: -- Table structure for table `fnrecord`
193: --
194:
195: CREATE TABLE IF NOT EXISTS `fnrecord` (
196: `recordid` bigint(20) unsigned NOT NULL auto_increment,
197: `testid` varchar(128) NOT NULL default '',
198: `alertlevel` int(11) NOT NULL default '0',
199: `testvalue` float NOT NULL default '0',
200: `recordx` bigint(20) unsigned NOT NULL default '0',
201: `nodeid` varchar(64) NOT NULL default '',
202: PRIMARY KEY (`recordid`)
203: ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=22902 ;
204:
205: -- --------------------------------------------------------
206:
207: --
208: -- Table structure for table `fnsession`
209: --
210:
211: CREATE TABLE IF NOT EXISTS `fnsession` (
212: `sessionid` bigint(20) unsigned NOT NULL auto_increment,
213: `sessionkey` varchar(128) NOT NULL default '',
214: `ipaddress` varchar(128) NOT NULL default '',
215: `username` varchar(64) NOT NULL default '',
216: `startx` bigint(20) unsigned NOT NULL default '0',
217: `updatex` bigint(20) unsigned NOT NULL default '0',
218: `userlevel` int(11) NOT NULL default '0',
219: PRIMARY KEY (`sessionid`)
220: ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=45 ;
221:
222: -- --------------------------------------------------------
223:
224: --
225: -- Table structure for table `fntestrun`
226: --
227:
228: CREATE TABLE IF NOT EXISTS `fntestrun` (
229: `trid` bigint(20) unsigned NOT NULL auto_increment,
230: `startx` bigint(20) unsigned NOT NULL default '0',
231: `finishx` bigint(20) unsigned NOT NULL default '0',
232: `routput` text NOT NULL,
233: `fnode` varchar(64) NOT NULL default '',
234: PRIMARY KEY (`trid`)
235: ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2542 ;
236:
237: -- --------------------------------------------------------
238:
239: --
240: -- Table structure for table `fnuser`
241: --
242:
243: CREATE TABLE IF NOT EXISTS `fnuser` (
244: `username` varchar(64) NOT NULL default '',
245: `password` varchar(64) NOT NULL default '',
246: `realname` varchar(128) NOT NULL default '',
247: `userlevel` int(11) NOT NULL default '1'
248: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
249: