File:
1.04.3a/server/base/sql/schema.drop.sql (
View as Code)
1: -- With DROP TABLES - will clean database
2: -- MySQL dump 10.10
3: --
4: -- Host: localhost Database: freenats
5: -- ------------------------------------------------------
6: -- Server version 5.0.22
7:
8: /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9: /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
10: /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
11: /*!40101 SET NAMES utf8 */;
12: /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
13: /*!40103 SET TIME_ZONE='+00:00' */;
14: /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
15: /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
16: /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
17: /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
18:
19: --
20: -- Table structure for table `fnalert`
21: --
22:
23: DROP TABLE IF EXISTS `fnalert`;
24: CREATE TABLE `fnalert` (
25: `alertid` bigint(20) unsigned NOT NULL auto_increment,
26: `nodeid` varchar(64) NOT NULL,
27: `alertlevel` int(11) NOT NULL default '0',
28: `openedx` bigint(20) unsigned NOT NULL default '0',
29: `closedx` bigint(20) unsigned NOT NULL default '0',
30: PRIMARY KEY (`alertid`),
31: KEY `nodeid` (`nodeid`),
32: KEY `closedx` (`closedx`)
33: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
34:
35: --
36: -- Table structure for table `fnalertaction`
37: --
38:
39: DROP TABLE IF EXISTS `fnalertaction`;
40: CREATE TABLE `fnalertaction` (
41: `aaid` bigint(20) unsigned NOT NULL auto_increment,
42: `atype` varchar(32) NOT NULL,
43: `efrom` varchar(250) NOT NULL,
44: `etolist` text NOT NULL,
45: `esubject` int(11) NOT NULL default '0',
46: `etype` int(11) NOT NULL default '0',
47: `awarnings` tinyint(1) NOT NULL default '0',
48: `adecrease` tinyint(1) NOT NULL default '0',
49: `mdata` text NOT NULL,
50: `aname` varchar(120) NOT NULL,
51: `ctrdate` varchar(8) NOT NULL,
52: `ctrlimit` int(10) unsigned NOT NULL default '0',
53: `ctrtoday` int(10) unsigned NOT NULL default '0',
54: `scheduleid` bigint(20) unsigned NOT NULL default '0',
55: PRIMARY KEY (`aaid`)
56: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
57:
58: --
59: -- Table structure for table `fnalertlog`
60: --
61:
62: DROP TABLE IF EXISTS `fnalertlog`;
63: CREATE TABLE `fnalertlog` (
64: `alid` bigint(20) unsigned NOT NULL auto_increment,
65: `alertid` bigint(20) unsigned NOT NULL default '0',
66: `postedx` bigint(20) unsigned NOT NULL default '0',
67: `logentry` varchar(250) NOT NULL,
68: PRIMARY KEY (`alid`),
69: KEY `alertid` (`alertid`)
70: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
71:
72: --
73: -- Table structure for table `fnconfig`
74: --
75:
76: DROP TABLE IF EXISTS `fnconfig`;
77: CREATE TABLE `fnconfig` (
78: `fnc_var` varchar(64) NOT NULL,
79: `fnc_val` varchar(64) NOT NULL,
80: PRIMARY KEY (`fnc_var`)
81: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
82:
83: --
84: -- Table structure for table `fneval`
85: --
86:
87: DROP TABLE IF EXISTS `fneval`;
88: CREATE TABLE `fneval` (
89: `evalid` bigint(20) unsigned NOT NULL auto_increment,
90: `testid` varchar(128) NOT NULL,
91: `weight` int(11) NOT NULL default '0',
92: `eoperator` varchar(32) NOT NULL,
93: `evalue` varchar(128) NOT NULL,
94: `eoutcome` int(11) NOT NULL default '0',
95: PRIMARY KEY (`evalid`),
96: KEY `testid` (`testid`)
97: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
98:
99: --
100: -- Table structure for table `fngroup`
101: --
102:
103: DROP TABLE IF EXISTS `fngroup`;
104: CREATE TABLE `fngroup` (
105: `groupid` bigint(20) unsigned NOT NULL auto_increment,
106: `groupname` varchar(128) NOT NULL,
107: `groupdesc` varchar(250) NOT NULL,
108: `groupicon` varchar(64) NOT NULL,
109: `weight` int(10) unsigned NOT NULL default '0',
110: PRIMARY KEY (`groupid`)
111: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
112:
113: --
114: -- Table structure for table `fngrouplink`
115: --
116:
117: DROP TABLE IF EXISTS `fngrouplink`;
118: CREATE TABLE `fngrouplink` (
119: `glid` bigint(20) unsigned NOT NULL auto_increment,
120: `groupid` bigint(20) unsigned NOT NULL default '0',
121: `nodeid` varchar(64) NOT NULL,
122: PRIMARY KEY (`glid`),
123: KEY `groupid` (`groupid`)
124: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
125:
126: --
127: -- Table structure for table `fnlocaltest`
128: --
129:
130: DROP TABLE IF EXISTS `fnlocaltest`;
131: CREATE TABLE `fnlocaltest` (
132: `localtestid` bigint(20) unsigned NOT NULL auto_increment,
133: `nodeid` varchar(64) NOT NULL,
134: `alertlevel` int(11) NOT NULL default '-1',
135: `lastrunx` bigint(20) unsigned NOT NULL default '0',
136: `testtype` varchar(128) NOT NULL,
137: `testparam` varchar(250) default NULL,
138: `testrecord` tinyint(1) NOT NULL default '0',
139: `simpleeval` tinyint(1) NOT NULL default '1',
140: `testname` varchar(64) NOT NULL,
141: `attempts` int(11) NOT NULL default '0',
142: `timeout` int(11) NOT NULL default '0',
143: `testenabled` tinyint(1) NOT NULL default '1',
144: `testparam1` varchar(250) NOT NULL,
145: `testparam2` varchar(250) NOT NULL,
146: `testparam3` varchar(250) NOT NULL,
147: `testparam4` varchar(250) NOT NULL,
148: `testparam5` varchar(250) NOT NULL,
149: `testparam6` varchar(250) NOT NULL,
150: `testparam7` varchar(250) NOT NULL,
151: `testparam8` varchar(250) NOT NULL,
152: `testparam9` varchar(250) NOT NULL,
153: `lastvalue` float NOT NULL default '0',
154: `testinterval` int(10) unsigned NOT NULL default '0',
155: `nextrunx` bigint(20) unsigned NOT NULL default '0',
156: PRIMARY KEY (`localtestid`),
157: KEY `nodeid` (`nodeid`)
158: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
159:
160: --
161: -- Table structure for table `fnlog`
162: --
163:
164: DROP TABLE IF EXISTS `fnlog`;
165: CREATE TABLE `fnlog` (
166: `logid` bigint(20) unsigned NOT NULL auto_increment,
167: `postedx` bigint(20) unsigned NOT NULL default '0',
168: `modid` varchar(32) NOT NULL,
169: `catid` varchar(32) NOT NULL,
170: `username` varchar(64) NOT NULL,
171: `loglevel` int(11) NOT NULL default '1',
172: `logevent` varchar(250) NOT NULL,
173: PRIMARY KEY (`logid`)
174: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
175:
176: --
177: -- Table structure for table `fnnalink`
178: --
179:
180: DROP TABLE IF EXISTS `fnnalink`;
181: CREATE TABLE `fnnalink` (
182: `nalid` bigint(20) unsigned NOT NULL auto_increment,
183: `nodeid` varchar(64) NOT NULL,
184: `aaid` bigint(20) unsigned NOT NULL default '0',
185: PRIMARY KEY (`nalid`)
186: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
187:
188: --
189: -- Table structure for table `fnnode`
190: --
191:
192: DROP TABLE IF EXISTS `fnnode`;
193: CREATE TABLE `fnnode` (
194: `nodeid` varchar(64) NOT NULL,
195: `nodename` varchar(128) NOT NULL,
196: `nodedesc` varchar(254) NOT NULL,
197: `hostname` varchar(254) NOT NULL,
198: `nodeenabled` tinyint(1) NOT NULL default '0',
199: `pingtest` tinyint(1) NOT NULL default '0',
200: `pingfatal` tinyint(1) NOT NULL default '0',
201: `alertlevel` int(11) NOT NULL default '-1',
202: `nodeicon` varchar(64) NOT NULL,
203: `weight` int(10) unsigned NOT NULL default '0',
204: `nodealert` tinyint(1) NOT NULL default '1',
205: `scheduleid` bigint(20) NOT NULL default '0',
206: `lastrunx` bigint(20) unsigned NOT NULL default '0',
207: `testinterval` int(10) unsigned NOT NULL default '5',
208: `nextrunx` bigint(20) unsigned NOT NULL default '0',
209: `nsenabled` tinyint(1) NOT NULL default '0',
210: `nsurl` varchar(254) NOT NULL,
211: `nskey` varchar(128) NOT NULL,
212: `nspullenabled` tinyint(1) NOT NULL default '0',
213: `nspushenabled` tinyint(1) NOT NULL default '0',
214: `nspuship` varchar(128) NOT NULL,
215: `nsinterval` int(10) unsigned NOT NULL default '15',
216: `nslastx` bigint(20) unsigned NOT NULL default '0',
217: `nsnextx` bigint(20) unsigned NOT NULL default '0',
218: `nspullalert` tinyint(1) NOT NULL default '0',
219: `nsfreshpush` tinyint(1) NOT NULL default '0',
220: `masterid` varchar(64) NOT NULL,
221: `masterjustping` tinyint(1) NOT NULL default '1',
222: PRIMARY KEY (`nodeid`),
223: KEY `masterid` (`masterid`)
224: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
225:
226: --
227: -- Table structure for table `fnnstest`
228: --
229:
230: DROP TABLE IF EXISTS `fnnstest`;
231: CREATE TABLE `fnnstest` (
232: `nstestid` bigint(20) unsigned NOT NULL auto_increment,
233: `nodeid` varchar(64) NOT NULL default '',
234: `alertlevel` int(11) NOT NULL default '-1',
235: `lastrunx` bigint(20) unsigned NOT NULL default '0',
236: `testtype` varchar(128) NOT NULL default '',
237: `testdesc` varchar(250) default NULL,
238: `testrecord` tinyint(1) NOT NULL default '0',
239: `simpleeval` tinyint(1) NOT NULL default '1',
240: `testname` varchar(64) NOT NULL default '',
241: `testenabled` tinyint(1) NOT NULL default '0',
242: `lastvalue` varchar(128) NOT NULL default '',
243: `testalerts` tinyint(1) NOT NULL default '1',
244: PRIMARY KEY (`nstestid`),
245: KEY `nodeid` (`nodeid`)
246: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
247:
248: --
249: -- Table structure for table `fnrecord`
250: --
251:
252: DROP TABLE IF EXISTS `fnrecord`;
253: CREATE TABLE `fnrecord` (
254: `recordid` bigint(20) unsigned NOT NULL auto_increment,
255: `testid` varchar(128) NOT NULL,
256: `alertlevel` int(11) NOT NULL default '0',
257: `testvalue` float NOT NULL default '0',
258: `recordx` bigint(20) unsigned NOT NULL default '0',
259: `nodeid` varchar(64) NOT NULL,
260: PRIMARY KEY (`recordid`),
261: KEY `testid` (`testid`),
262: KEY `recordx` (`recordx`)
263: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
264:
265: --
266: -- Table structure for table `fnreport`
267: --
268:
269: DROP TABLE IF EXISTS `fnreport`;
270: CREATE TABLE `fnreport` (
271: `reportid` bigint(20) unsigned NOT NULL auto_increment,
272: `reportname` varchar(128) NOT NULL default '',
273: `reporttests` text NOT NULL,
274: PRIMARY KEY (`reportid`)
275: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
276:
277: --
278: -- Table structure for table `fnscheditem`
279: --
280:
281: DROP TABLE IF EXISTS `fnscheditem`;
282: CREATE TABLE `fnscheditem` (
283: `scheditemid` bigint(20) NOT NULL auto_increment,
284: `scheduleid` bigint(20) NOT NULL default '0',
285: `dayofweek` varchar(8) NOT NULL default '',
286: `dayofmonth` int(11) NOT NULL default '0',
287: `monthofyear` int(11) NOT NULL default '0',
288: `year` int(11) NOT NULL default '0',
289: `starthour` int(11) NOT NULL default '0',
290: `startmin` int(11) NOT NULL default '0',
291: `finishhour` int(11) NOT NULL default '23',
292: `finishmin` int(11) NOT NULL default '59',
293: PRIMARY KEY (`scheditemid`)
294: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
295:
296: --
297: -- Table structure for table `fnschedule`
298: --
299:
300: DROP TABLE IF EXISTS `fnschedule`;
301: CREATE TABLE `fnschedule` (
302: `scheduleid` bigint(20) unsigned NOT NULL auto_increment,
303: `schedulename` varchar(128) NOT NULL default '',
304: `defaultaction` tinyint(1) NOT NULL default '1',
305: PRIMARY KEY (`scheduleid`)
306: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
307:
308: --
309: -- Table structure for table `fnsession`
310: --
311:
312: DROP TABLE IF EXISTS `fnsession`;
313: CREATE TABLE `fnsession` (
314: `sessionid` bigint(20) unsigned NOT NULL auto_increment,
315: `sessionkey` varchar(128) NOT NULL,
316: `ipaddress` varchar(128) NOT NULL,
317: `username` varchar(64) NOT NULL,
318: `startx` bigint(20) unsigned NOT NULL default '0',
319: `updatex` bigint(20) unsigned NOT NULL default '0',
320: `userlevel` int(11) NOT NULL default '0',
321: PRIMARY KEY (`sessionid`)
322: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
323:
324: --
325: -- Table structure for table `fntestrun`
326: --
327:
328: DROP TABLE IF EXISTS `fntestrun`;
329: CREATE TABLE `fntestrun` (
330: `trid` bigint(20) unsigned NOT NULL auto_increment,
331: `startx` bigint(20) unsigned NOT NULL default '0',
332: `finishx` bigint(20) unsigned NOT NULL default '0',
333: `routput` text NOT NULL,
334: `fnode` varchar(64) NOT NULL,
335: PRIMARY KEY (`trid`),
336: KEY `finishx` (`finishx`),
337: KEY `fnode` (`fnode`)
338: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
339:
340: --
341: -- Table structure for table `fnuser`
342: --
343:
344: DROP TABLE IF EXISTS `fnuser`;
345: CREATE TABLE `fnuser` (
346: `username` varchar(64) NOT NULL,
347: `password` varchar(64) NOT NULL,
348: `realname` varchar(128) NOT NULL,
349: `userlevel` int(11) NOT NULL default '1',
350: PRIMARY KEY (`username`)
351: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
352:
353: --
354: -- Table structure for table `fnview`
355: --
356:
357: DROP TABLE IF EXISTS `fnview`;
358: CREATE TABLE `fnview` (
359: `viewid` bigint(20) unsigned NOT NULL auto_increment,
360: `vtitle` varchar(128) NOT NULL default '',
361: `vstyle` varchar(32) NOT NULL default '',
362: `vpublic` tinyint(1) NOT NULL default '0',
363: `vclick` varchar(32) NOT NULL default '',
364: `vrefresh` int(11) NOT NULL default '0',
365: `vlinkv` bigint(20) unsigned NOT NULL default '0',
366: `vcolumns` smallint(6) NOT NULL default '0',
367: `vcolon` tinyint(1) NOT NULL default '1',
368: `vdashes` tinyint(1) NOT NULL default '1',
369: `vtimeago` tinyint(1) NOT NULL default '1',
370: PRIMARY KEY (`viewid`)
371: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
372:
373: --
374: -- Table structure for table `fnviewitem`
375: --
376:
377: DROP TABLE IF EXISTS `fnviewitem`;
378: CREATE TABLE `fnviewitem` (
379: `viewitemid` bigint(20) unsigned NOT NULL auto_increment,
380: `viewid` bigint(20) unsigned NOT NULL default '0',
381: `itype` varchar(128) NOT NULL default '',
382: `ioption` varchar(250) NOT NULL default '',
383: `icolour` tinyint(1) NOT NULL default '1',
384: `itextstatus` tinyint(1) NOT NULL default '0',
385: `idetail` smallint(5) unsigned NOT NULL default '0',
386: `iweight` int(10) unsigned NOT NULL default '0',
387: `isize` smallint(6) NOT NULL default '0',
388: `igraphic` smallint(6) NOT NULL default '0',
389: `iname` varchar(64) NOT NULL default '',
390: PRIMARY KEY (`viewitemid`),
391: KEY `viewid` (`viewid`)
392: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
393: /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
394:
395: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
396: /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
397: /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
398: /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
399: /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
400: /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
401: /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
402:
403: