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