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