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