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