File:
1.10.1a/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: `ulink0` tinyint(1) NOT NULL default '0',
223: `ulink0_title` varchar(254) NOT NULL default 'VNC',
224: `ulink0_url` varchar(254) NOT NULL default 'http://{HOSTNAME}:5800/',
225: `ulink1` tinyint(1) NOT NULL default '0',
226: `ulink1_title` varchar(254) NOT NULL default 'SSH',
227: `ulink1_url` varchar(254) NOT NULL default 'ssh://{HOSTNAME}',
228: `ulink2` tinyint(1) NOT NULL default '0',
229: `ulink2_title` varchar(254) NOT NULL default 'Web',
230: `ulink2_url` varchar(254) NOT NULL default 'http://{HOSTNAME}',
231: PRIMARY KEY (`nodeid`),
232: KEY `masterid` (`masterid`)
233: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
234:
235: --
236: -- Table structure for table `fnnstest`
237: --
238:
239: DROP TABLE IF EXISTS `fnnstest`;
240: CREATE TABLE `fnnstest` (
241: `nstestid` bigint(20) unsigned NOT NULL auto_increment,
242: `nodeid` varchar(64) NOT NULL default '',
243: `alertlevel` int(11) NOT NULL default '-1',
244: `lastrunx` bigint(20) unsigned NOT NULL default '0',
245: `testtype` varchar(128) NOT NULL default '',
246: `testdesc` varchar(250) default NULL,
247: `testrecord` tinyint(1) NOT NULL default '0',
248: `simpleeval` tinyint(1) NOT NULL default '1',
249: `testname` varchar(64) NOT NULL default '',
250: `testenabled` tinyint(1) NOT NULL default '0',
251: `lastvalue` varchar(128) NOT NULL default '',
252: `testalerts` tinyint(1) NOT NULL default '1',
253: PRIMARY KEY (`nstestid`),
254: KEY `nodeid` (`nodeid`)
255: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
256:
257: --
258: -- Table structure for table `fnrecord`
259: --
260:
261: DROP TABLE IF EXISTS `fnrecord`;
262: CREATE TABLE `fnrecord` (
263: `recordid` bigint(20) unsigned NOT NULL auto_increment,
264: `testid` varchar(128) NOT NULL,
265: `alertlevel` int(11) NOT NULL default '0',
266: `testvalue` float NOT NULL default '0',
267: `recordx` bigint(20) unsigned NOT NULL default '0',
268: `nodeid` varchar(64) NOT NULL,
269: PRIMARY KEY (`recordid`),
270: KEY `testid` (`testid`),
271: KEY `recordx` (`recordx`)
272: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
273:
274: --
275: -- Table structure for table `fnreport`
276: --
277:
278: DROP TABLE IF EXISTS `fnreport`;
279: CREATE TABLE `fnreport` (
280: `reportid` bigint(20) unsigned NOT NULL auto_increment,
281: `reportname` varchar(128) NOT NULL default '',
282: `reporttests` text NOT NULL,
283: PRIMARY KEY (`reportid`)
284: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
285:
286: --
287: -- Table structure for table `fnscheditem`
288: --
289:
290: DROP TABLE IF EXISTS `fnscheditem`;
291: CREATE TABLE `fnscheditem` (
292: `scheditemid` bigint(20) NOT NULL auto_increment,
293: `scheduleid` bigint(20) NOT NULL default '0',
294: `dayofweek` varchar(8) NOT NULL default '',
295: `dayofmonth` int(11) NOT NULL default '0',
296: `monthofyear` int(11) NOT NULL default '0',
297: `year` int(11) NOT NULL default '0',
298: `starthour` int(11) NOT NULL default '0',
299: `startmin` int(11) NOT NULL default '0',
300: `finishhour` int(11) NOT NULL default '23',
301: `finishmin` int(11) NOT NULL default '59',
302: PRIMARY KEY (`scheditemid`)
303: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
304:
305: --
306: -- Table structure for table `fnschedule`
307: --
308:
309: DROP TABLE IF EXISTS `fnschedule`;
310: CREATE TABLE `fnschedule` (
311: `scheduleid` bigint(20) unsigned NOT NULL auto_increment,
312: `schedulename` varchar(128) NOT NULL default '',
313: `defaultaction` tinyint(1) NOT NULL default '1',
314: PRIMARY KEY (`scheduleid`)
315: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
316:
317: --
318: -- Table structure for table `fnsession`
319: --
320:
321: DROP TABLE IF EXISTS `fnsession`;
322: CREATE TABLE `fnsession` (
323: `sessionid` bigint(20) unsigned NOT NULL auto_increment,
324: `sessionkey` varchar(128) NOT NULL,
325: `ipaddress` varchar(128) NOT NULL,
326: `username` varchar(64) NOT NULL,
327: `startx` bigint(20) unsigned NOT NULL default '0',
328: `updatex` bigint(20) unsigned NOT NULL default '0',
329: `userlevel` int(11) NOT NULL default '0',
330: PRIMARY KEY (`sessionid`)
331: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
332:
333: --
334: -- Table structure for table `fntestrun`
335: --
336:
337: DROP TABLE IF EXISTS `fntestrun`;
338: CREATE TABLE `fntestrun` (
339: `trid` bigint(20) unsigned NOT NULL auto_increment,
340: `startx` bigint(20) unsigned NOT NULL default '0',
341: `finishx` bigint(20) unsigned NOT NULL default '0',
342: `routput` text NOT NULL,
343: `fnode` varchar(64) NOT NULL,
344: PRIMARY KEY (`trid`),
345: KEY `finishx` (`finishx`),
346: KEY `fnode` (`fnode`)
347: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
348:
349: --
350: -- Table structure for table `fnuser`
351: --
352:
353: DROP TABLE IF EXISTS `fnuser`;
354: CREATE TABLE `fnuser` (
355: `username` varchar(64) NOT NULL,
356: `password` varchar(64) NOT NULL,
357: `realname` varchar(128) NOT NULL,
358: `userlevel` int(11) NOT NULL default '1',
359: PRIMARY KEY (`username`)
360: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
361:
362: --
363: -- Table structure for table `fnview`
364: --
365:
366: DROP TABLE IF EXISTS `fnview`;
367: CREATE TABLE `fnview` (
368: `viewid` bigint(20) unsigned NOT NULL auto_increment,
369: `vtitle` varchar(128) NOT NULL default '',
370: `vstyle` varchar(32) NOT NULL default '',
371: `vpublic` tinyint(1) NOT NULL default '0',
372: `vclick` varchar(32) NOT NULL default '',
373: `vrefresh` int(11) NOT NULL default '0',
374: `vlinkv` bigint(20) unsigned NOT NULL default '0',
375: `vcolumns` smallint(6) NOT NULL default '0',
376: `vcolon` tinyint(1) NOT NULL default '1',
377: `vdashes` tinyint(1) NOT NULL default '1',
378: `vtimeago` tinyint(1) NOT NULL default '1',
379: PRIMARY KEY (`viewid`)
380: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
381:
382: --
383: -- Table structure for table `fnviewitem`
384: --
385:
386: DROP TABLE IF EXISTS `fnviewitem`;
387: CREATE TABLE `fnviewitem` (
388: `viewitemid` bigint(20) unsigned NOT NULL auto_increment,
389: `viewid` bigint(20) unsigned NOT NULL default '0',
390: `itype` varchar(128) NOT NULL default '',
391: `ioption` varchar(250) NOT NULL default '',
392: `icolour` tinyint(1) NOT NULL default '1',
393: `itextstatus` tinyint(1) NOT NULL default '0',
394: `idetail` smallint(5) unsigned NOT NULL default '0',
395: `iweight` int(10) unsigned NOT NULL default '0',
396: `isize` smallint(6) NOT NULL default '0',
397: `igraphic` smallint(6) NOT NULL default '0',
398: `iname` varchar(64) NOT NULL default '',
399: PRIMARY KEY (`viewitemid`),
400: KEY `viewid` (`viewid`)
401: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
402: /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
403:
404: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
405: /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
406: /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
407: /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
408: /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
409: /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
410: /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
411:
412: