File:
0.02.35a/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: freenats
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: PRIMARY KEY (`localtestid`)
133: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
134:
135: --
136: -- Table structure for table `fnlog`
137: --
138:
139: DROP TABLE IF EXISTS `fnlog`;
140: CREATE TABLE `fnlog` (
141: `logid` bigint(20) unsigned NOT NULL auto_increment,
142: `postedx` bigint(20) unsigned NOT NULL default '0',
143: `modid` varchar(32) NOT NULL default '',
144: `catid` varchar(32) NOT NULL default '',
145: `username` varchar(64) NOT NULL default '',
146: `loglevel` int(11) NOT NULL default '1',
147: `logevent` varchar(250) NOT NULL default '',
148: PRIMARY KEY (`logid`)
149: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
150:
151: --
152: -- Table structure for table `fnnalink`
153: --
154:
155: DROP TABLE IF EXISTS `fnnalink`;
156: CREATE TABLE `fnnalink` (
157: `nalid` bigint(20) unsigned NOT NULL auto_increment,
158: `nodeid` varchar(64) NOT NULL default '',
159: `aaid` bigint(20) unsigned NOT NULL default '0',
160: PRIMARY KEY (`nalid`)
161: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
162:
163: --
164: -- Table structure for table `fnnode`
165: --
166:
167: DROP TABLE IF EXISTS `fnnode`;
168: CREATE TABLE `fnnode` (
169: `nodeid` varchar(64) NOT NULL default '',
170: `nodename` varchar(128) NOT NULL default '',
171: `nodedesc` varchar(254) NOT NULL default '',
172: `hostname` varchar(254) NOT NULL default '',
173: `nodeenabled` tinyint(1) NOT NULL default '0',
174: `pingtest` tinyint(1) NOT NULL default '0',
175: `pingfatal` tinyint(1) NOT NULL default '0',
176: `alertlevel` int(11) NOT NULL default '-1',
177: `nodeicon` varchar(64) NOT NULL default '',
178: `weight` int(10) unsigned NOT NULL default '0',
179: `nodealert` tinyint(1) NOT NULL default '1',
180: PRIMARY KEY (`nodeid`)
181: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
182:
183: --
184: -- Table structure for table `fnrecord`
185: --
186:
187: DROP TABLE IF EXISTS `fnrecord`;
188: CREATE TABLE `fnrecord` (
189: `recordid` bigint(20) unsigned NOT NULL auto_increment,
190: `testid` varchar(128) NOT NULL default '',
191: `alertlevel` int(11) NOT NULL default '0',
192: `testvalue` float NOT NULL default '0',
193: `recordx` bigint(20) unsigned NOT NULL default '0',
194: `nodeid` varchar(64) NOT NULL default '',
195: PRIMARY KEY (`recordid`)
196: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
197:
198: --
199: -- Table structure for table `fnsession`
200: --
201:
202: DROP TABLE IF EXISTS `fnsession`;
203: CREATE TABLE `fnsession` (
204: `sessionid` bigint(20) unsigned NOT NULL auto_increment,
205: `sessionkey` varchar(128) NOT NULL default '',
206: `ipaddress` varchar(128) NOT NULL default '',
207: `username` varchar(64) NOT NULL default '',
208: `startx` bigint(20) unsigned NOT NULL default '0',
209: `updatex` bigint(20) unsigned NOT NULL default '0',
210: `userlevel` int(11) NOT NULL default '0',
211: PRIMARY KEY (`sessionid`)
212: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
213:
214: --
215: -- Table structure for table `fntestrun`
216: --
217:
218: DROP TABLE IF EXISTS `fntestrun`;
219: CREATE TABLE `fntestrun` (
220: `trid` bigint(20) unsigned NOT NULL auto_increment,
221: `startx` bigint(20) unsigned NOT NULL default '0',
222: `finishx` bigint(20) unsigned NOT NULL default '0',
223: `routput` text NOT NULL,
224: `fnode` varchar(64) NOT NULL default '',
225: PRIMARY KEY (`trid`)
226: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
227:
228: --
229: -- Table structure for table `fnuser`
230: --
231:
232: DROP TABLE IF EXISTS `fnuser`;
233: CREATE TABLE `fnuser` (
234: `username` varchar(64) NOT NULL default '',
235: `password` varchar(64) NOT NULL default '',
236: `realname` varchar(128) NOT NULL default '',
237: `userlevel` int(11) NOT NULL default '1'
238: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
239:
240: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
241: /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
242: /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
243: /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
244: /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
245: /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
246: /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
247:
248: