1: -- With DROP TABLES - will clean database
  2: -- MySQL dump 10.13  Distrib 5.6.35, for osx10.9 (x86_64)
  3: --
  4: -- Host: localhost    Database: freenats
  5: -- ------------------------------------------------------
  6: -- Server version	5.6.35
  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: /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
 13: /*!40103 SET TIME_ZONE='+00:00' */;
 14: /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
 15: /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
 16: /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
 17: /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 18: 
 19: --
 20: -- Table structure for table `fnalert`
 21: --
 22: 
 23: DROP TABLE IF EXISTS `fnalert`;
 24: /*!40101 SET @saved_cs_client     = @@character_set_client */;
 25: /*!40101 SET character_set_client = utf8 */;
 26: CREATE TABLE `fnalert` (
 27:   `alertid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 28:   `nodeid` varchar(64) NOT NULL,
 29:   `alertlevel` int(11) NOT NULL DEFAULT '0',
 30:   `openedx` bigint(20) unsigned NOT NULL DEFAULT '0',
 31:   `closedx` bigint(20) unsigned NOT NULL DEFAULT '0',
 32:   PRIMARY KEY (`alertid`),
 33:   KEY `nodeid` (`nodeid`),
 34:   KEY `closedx` (`closedx`)
 35: ) ENGINE=MyISAM AUTO_INCREMENT=2301 DEFAULT CHARSET=latin1;
 36: /*!40101 SET character_set_client = @saved_cs_client */;
 37: 
 38: --
 39: -- Table structure for table `fnalertaction`
 40: --
 41: 
 42: DROP TABLE IF EXISTS `fnalertaction`;
 43: /*!40101 SET @saved_cs_client     = @@character_set_client */;
 44: /*!40101 SET character_set_client = utf8 */;
 45: CREATE TABLE `fnalertaction` (
 46:   `aaid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 47:   `atype` varchar(32) NOT NULL,
 48:   `efrom` varchar(250) NOT NULL DEFAULT '',
 49:   `etolist` text,
 50:   `esubject` int(11) NOT NULL DEFAULT '0',
 51:   `etype` int(11) NOT NULL DEFAULT '0',
 52:   `awarnings` tinyint(1) NOT NULL DEFAULT '0',
 53:   `adecrease` tinyint(1) NOT NULL DEFAULT '0',
 54:   `mdata` text,
 55:   `aname` varchar(120) NOT NULL DEFAULT '',
 56:   `ctrdate` varchar(8) DEFAULT NULL,
 57:   `ctrlimit` int(10) unsigned NOT NULL DEFAULT '0',
 58:   `ctrtoday` int(10) unsigned NOT NULL DEFAULT '0',
 59:   `scheduleid` bigint(20) unsigned NOT NULL DEFAULT '0',
 60:   PRIMARY KEY (`aaid`)
 61: ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
 62: /*!40101 SET character_set_client = @saved_cs_client */;
 63: 
 64: --
 65: -- Table structure for table `fnalertlog`
 66: --
 67: 
 68: DROP TABLE IF EXISTS `fnalertlog`;
 69: /*!40101 SET @saved_cs_client     = @@character_set_client */;
 70: /*!40101 SET character_set_client = utf8 */;
 71: CREATE TABLE `fnalertlog` (
 72:   `alid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 73:   `alertid` bigint(20) unsigned NOT NULL DEFAULT '0',
 74:   `postedx` bigint(20) unsigned NOT NULL DEFAULT '0',
 75:   `logentry` varchar(250) DEFAULT NULL,
 76:   PRIMARY KEY (`alid`),
 77:   KEY `alertid` (`alertid`)
 78: ) ENGINE=MyISAM AUTO_INCREMENT=49767 DEFAULT CHARSET=latin1;
 79: /*!40101 SET character_set_client = @saved_cs_client */;
 80: 
 81: --
 82: -- Table structure for table `fnconfig`
 83: --
 84: 
 85: DROP TABLE IF EXISTS `fnconfig`;
 86: /*!40101 SET @saved_cs_client     = @@character_set_client */;
 87: /*!40101 SET character_set_client = utf8 */;
 88: CREATE TABLE `fnconfig` (
 89:   `fnc_var` varchar(64) NOT NULL,
 90:   `fnc_val` varchar(64) NOT NULL DEFAULT '',
 91:   PRIMARY KEY (`fnc_var`)
 92: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 93: /*!40101 SET character_set_client = @saved_cs_client */;
 94: 
 95: --
 96: -- Table structure for table `fneval`
 97: --
 98: 
 99: DROP TABLE IF EXISTS `fneval`;
100: /*!40101 SET @saved_cs_client     = @@character_set_client */;
101: /*!40101 SET character_set_client = utf8 */;
102: CREATE TABLE `fneval` (
103:   `evalid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
104:   `testid` varchar(128) NOT NULL,
105:   `weight` int(11) NOT NULL DEFAULT '0',
106:   `eoperator` varchar(32) NOT NULL DEFAULT '',
107:   `evalue` varchar(128) NOT NULL DEFAULT '',
108:   `eoutcome` int(11) NOT NULL DEFAULT '0',
109:   PRIMARY KEY (`evalid`),
110:   KEY `testid` (`testid`)
111: ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
112: /*!40101 SET character_set_client = @saved_cs_client */;
113: 
114: --
115: -- Table structure for table `fngroup`
116: --
117: 
118: DROP TABLE IF EXISTS `fngroup`;
119: /*!40101 SET @saved_cs_client     = @@character_set_client */;
120: /*!40101 SET character_set_client = utf8 */;
121: CREATE TABLE `fngroup` (
122:   `groupid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
123:   `groupname` varchar(128) NOT NULL DEFAULT '',
124:   `groupdesc` varchar(250) NOT NULL,
125:   `groupicon` varchar(64) NOT NULL,
126:   `weight` int(10) unsigned NOT NULL DEFAULT '0',
127:   PRIMARY KEY (`groupid`)
128: ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
129: /*!40101 SET character_set_client = @saved_cs_client */;
130: 
131: --
132: -- Table structure for table `fngrouplink`
133: --
134: 
135: DROP TABLE IF EXISTS `fngrouplink`;
136: /*!40101 SET @saved_cs_client     = @@character_set_client */;
137: /*!40101 SET character_set_client = utf8 */;
138: CREATE TABLE `fngrouplink` (
139:   `glid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
140:   `groupid` bigint(20) unsigned NOT NULL DEFAULT '0',
141:   `nodeid` varchar(64) NOT NULL DEFAULT '',
142:   PRIMARY KEY (`glid`),
143:   KEY `groupid` (`groupid`)
144: ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
145: /*!40101 SET character_set_client = @saved_cs_client */;
146: 
147: --
148: -- Table structure for table `fngrouplock`
149: --
150: 
151: DROP TABLE IF EXISTS `fngrouplock`;
152: /*!40101 SET @saved_cs_client     = @@character_set_client */;
153: /*!40101 SET character_set_client = utf8 */;
154: CREATE TABLE `fngrouplock` (
155:   `glid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
156:   `username` varchar(64) NOT NULL,
157:   `groupid` bigint(20) NOT NULL DEFAULT '0',
158:   PRIMARY KEY (`glid`)
159: ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
160: /*!40101 SET character_set_client = @saved_cs_client */;
161: 
162: --
163: -- Table structure for table `fnlocaltest`
164: --
165: 
166: DROP TABLE IF EXISTS `fnlocaltest`;
167: /*!40101 SET @saved_cs_client     = @@character_set_client */;
168: /*!40101 SET character_set_client = utf8 */;
169: CREATE TABLE `fnlocaltest` (
170:   `localtestid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
171:   `nodeid` varchar(64) NOT NULL,
172:   `alertlevel` int(11) NOT NULL DEFAULT '-1',
173:   `lastrunx` bigint(20) unsigned NOT NULL DEFAULT '0',
174:   `testtype` varchar(128) NOT NULL DEFAULT '',
175:   `testparam` varchar(250) DEFAULT '',
176:   `testrecord` tinyint(1) NOT NULL DEFAULT '0',
177:   `simpleeval` tinyint(1) NOT NULL DEFAULT '1',
178:   `testname` varchar(64) NOT NULL DEFAULT '',
179:   `attempts` int(11) NOT NULL DEFAULT '0',
180:   `timeout` int(11) NOT NULL DEFAULT '0',
181:   `testenabled` tinyint(1) NOT NULL DEFAULT '1',
182:   `testparam1` varchar(250) DEFAULT '',
183:   `testparam2` varchar(250) DEFAULT '',
184:   `testparam3` varchar(250) DEFAULT '',
185:   `testparam4` varchar(250) DEFAULT '',
186:   `testparam5` varchar(250) DEFAULT '',
187:   `testparam6` varchar(250) DEFAULT '',
188:   `testparam7` varchar(250) DEFAULT '',
189:   `testparam8` varchar(250) DEFAULT '',
190:   `testparam9` varchar(250) DEFAULT '',
191:   `lastvalue` float NOT NULL DEFAULT '0',
192:   `testinterval` int(10) unsigned NOT NULL DEFAULT '0',
193:   `nextrunx` bigint(20) unsigned NOT NULL DEFAULT '0',
194:   PRIMARY KEY (`localtestid`),
195:   KEY `nodeid` (`nodeid`)
196: ) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=latin1;
197: /*!40101 SET character_set_client = @saved_cs_client */;
198: 
199: --
200: -- Table structure for table `fnlog`
201: --
202: 
203: DROP TABLE IF EXISTS `fnlog`;
204: /*!40101 SET @saved_cs_client     = @@character_set_client */;
205: /*!40101 SET character_set_client = utf8 */;
206: CREATE TABLE `fnlog` (
207:   `logid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
208:   `postedx` bigint(20) unsigned NOT NULL DEFAULT '0',
209:   `modid` varchar(32) NOT NULL DEFAULT '',
210:   `catid` varchar(32) NOT NULL DEFAULT '',
211:   `username` varchar(64) NOT NULL DEFAULT '',
212:   `loglevel` int(11) NOT NULL DEFAULT '1',
213:   `logevent` varchar(250) NOT NULL DEFAULT '',
214:   PRIMARY KEY (`logid`)
215: ) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=latin1;
216: /*!40101 SET character_set_client = @saved_cs_client */;
217: 
218: --
219: -- Table structure for table `fnnalink`
220: --
221: 
222: DROP TABLE IF EXISTS `fnnalink`;
223: /*!40101 SET @saved_cs_client     = @@character_set_client */;
224: /*!40101 SET character_set_client = utf8 */;
225: CREATE TABLE `fnnalink` (
226:   `nalid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
227:   `nodeid` varchar(64) NOT NULL,
228:   `aaid` bigint(20) unsigned NOT NULL DEFAULT '0',
229:   PRIMARY KEY (`nalid`)
230: ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
231: /*!40101 SET character_set_client = @saved_cs_client */;
232: 
233: --
234: -- Table structure for table `fnnode`
235: --
236: 
237: DROP TABLE IF EXISTS `fnnode`;
238: /*!40101 SET @saved_cs_client     = @@character_set_client */;
239: /*!40101 SET character_set_client = utf8 */;
240: CREATE TABLE `fnnode` (
241:   `nodeid` varchar(64) NOT NULL,
242:   `nodename` varchar(128) NOT NULL DEFAULT '',
243:   `nodedesc` varchar(254) NOT NULL DEFAULT '',
244:   `hostname` varchar(254) NOT NULL DEFAULT '',
245:   `nodeenabled` tinyint(1) NOT NULL DEFAULT '0',
246:   `pingtest` tinyint(1) NOT NULL DEFAULT '0',
247:   `pingfatal` tinyint(1) NOT NULL DEFAULT '0',
248:   `alertlevel` int(11) NOT NULL DEFAULT '-1',
249:   `nodeicon` varchar(64) NOT NULL DEFAULT '',
250:   `weight` int(10) unsigned NOT NULL DEFAULT '0',
251:   `nodealert` tinyint(1) NOT NULL DEFAULT '1',
252:   `scheduleid` bigint(20) NOT NULL DEFAULT '0',
253:   `lastrunx` bigint(20) unsigned NOT NULL DEFAULT '0',
254:   `testinterval` int(10) unsigned NOT NULL DEFAULT '5',
255:   `nextrunx` bigint(20) unsigned NOT NULL DEFAULT '0',
256:   `nsenabled` tinyint(1) NOT NULL DEFAULT '0',
257:   `nsurl` varchar(254) NOT NULL DEFAULT '',
258:   `nskey` varchar(250) NOT NULL DEFAULT '',
259:   `nspullenabled` tinyint(1) NOT NULL DEFAULT '0',
260:   `nspushenabled` tinyint(1) NOT NULL DEFAULT '0',
261:   `nspuship` varchar(128) NOT NULL DEFAULT '',
262:   `nsinterval` int(10) unsigned NOT NULL DEFAULT '15',
263:   `nslastx` bigint(20) unsigned NOT NULL DEFAULT '0',
264:   `nsnextx` bigint(20) unsigned NOT NULL DEFAULT '0',
265:   `nspullalert` tinyint(1) NOT NULL DEFAULT '0',
266:   `nsfreshpush` tinyint(1) NOT NULL DEFAULT '0',
267:   `masterid` varchar(64) NOT NULL DEFAULT '',
268:   `masterjustping` tinyint(1) NOT NULL DEFAULT '1',
269:   `ulink0` tinyint(1) NOT NULL DEFAULT '0',
270:   `ulink0_title` varchar(254) NOT NULL DEFAULT 'VNC',
271:   `ulink0_url` varchar(254) NOT NULL DEFAULT 'http://{HOSTNAME}:5800/',
272:   `ulink1` tinyint(1) NOT NULL DEFAULT '0',
273:   `ulink1_title` varchar(254) NOT NULL DEFAULT 'SSH',
274:   `ulink1_url` varchar(254) NOT NULL DEFAULT 'ssh://{HOSTNAME}',
275:   `ulink2` tinyint(1) NOT NULL DEFAULT '0',
276:   `ulink2_title` varchar(254) NOT NULL DEFAULT 'Web',
277:   `ulink2_url` varchar(254) NOT NULL DEFAULT 'http://{HOSTNAME}',
278:   PRIMARY KEY (`nodeid`),
279:   KEY `masterid` (`masterid`)
280: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
281: /*!40101 SET character_set_client = @saved_cs_client */;
282: 
283: --
284: -- Table structure for table `fnnstest`
285: --
286: 
287: DROP TABLE IF EXISTS `fnnstest`;
288: /*!40101 SET @saved_cs_client     = @@character_set_client */;
289: /*!40101 SET character_set_client = utf8 */;
290: CREATE TABLE `fnnstest` (
291:   `nstestid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
292:   `nodeid` varchar(64) NOT NULL DEFAULT '',
293:   `alertlevel` int(11) NOT NULL DEFAULT '-1',
294:   `lastrunx` bigint(20) unsigned NOT NULL DEFAULT '0',
295:   `testtype` varchar(128) NOT NULL DEFAULT '',
296:   `testdesc` varchar(250) DEFAULT NULL,
297:   `testrecord` tinyint(1) NOT NULL DEFAULT '0',
298:   `simpleeval` tinyint(1) NOT NULL DEFAULT '1',
299:   `testname` varchar(64) NOT NULL DEFAULT '',
300:   `testenabled` tinyint(1) NOT NULL DEFAULT '0',
301:   `lastvalue` varchar(128) NOT NULL DEFAULT '',
302:   `testalerts` tinyint(1) NOT NULL DEFAULT '1',
303:   PRIMARY KEY (`nstestid`),
304:   KEY `nodeid` (`nodeid`)
305: ) ENGINE=MyISAM AUTO_INCREMENT=43486 DEFAULT CHARSET=latin1;
306: /*!40101 SET character_set_client = @saved_cs_client */;
307: 
308: --
309: -- Table structure for table `fnrecord`
310: --
311: 
312: DROP TABLE IF EXISTS `fnrecord`;
313: /*!40101 SET @saved_cs_client     = @@character_set_client */;
314: /*!40101 SET character_set_client = utf8 */;
315: CREATE TABLE `fnrecord` (
316:   `recordid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
317:   `testid` varchar(128) NOT NULL DEFAULT '',
318:   `alertlevel` int(11) NOT NULL DEFAULT '0',
319:   `testvalue` float NOT NULL DEFAULT '0',
320:   `recordx` bigint(20) unsigned NOT NULL DEFAULT '0',
321:   `nodeid` varchar(64) NOT NULL DEFAULT '',
322:   PRIMARY KEY (`recordid`),
323:   KEY `testid` (`testid`),
324:   KEY `recordx` (`recordx`)
325: ) ENGINE=MyISAM AUTO_INCREMENT=4768915 DEFAULT CHARSET=latin1;
326: /*!40101 SET character_set_client = @saved_cs_client */;
327: 
328: --
329: -- Table structure for table `fnreport`
330: --
331: 
332: DROP TABLE IF EXISTS `fnreport`;
333: /*!40101 SET @saved_cs_client     = @@character_set_client */;
334: /*!40101 SET character_set_client = utf8 */;
335: CREATE TABLE `fnreport` (
336:   `reportid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
337:   `reportname` varchar(128) NOT NULL DEFAULT '',
338:   `reporttests` text,
339:   PRIMARY KEY (`reportid`)
340: ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
341: /*!40101 SET character_set_client = @saved_cs_client */;
342: 
343: --
344: -- Table structure for table `fnrssfeed`
345: --
346: 
347: DROP TABLE IF EXISTS `fnrssfeed`;
348: /*!40101 SET @saved_cs_client     = @@character_set_client */;
349: /*!40101 SET character_set_client = utf8 */;
350: CREATE TABLE `fnrssfeed` (
351:   `feedid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
352:   `feedkey` varchar(254) NOT NULL DEFAULT '',
353:   `feedname` varchar(254) NOT NULL DEFAULT '',
354:   `feedtype` varchar(254) NOT NULL DEFAULT '',
355:   `typeopt` varchar(254) NOT NULL DEFAULT '',
356:   `feedrange` varchar(32) NOT NULL DEFAULT '',
357:   `rangeopt` varchar(254) NOT NULL DEFAULT '',
358:   PRIMARY KEY (`feedid`)
359: ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
360: /*!40101 SET character_set_client = @saved_cs_client */;
361: 
362: --
363: -- Table structure for table `fnscheditem`
364: --
365: 
366: DROP TABLE IF EXISTS `fnscheditem`;
367: /*!40101 SET @saved_cs_client     = @@character_set_client */;
368: /*!40101 SET character_set_client = utf8 */;
369: CREATE TABLE `fnscheditem` (
370:   `scheditemid` bigint(20) NOT NULL AUTO_INCREMENT,
371:   `scheduleid` bigint(20) NOT NULL DEFAULT '0',
372:   `dayofweek` varchar(8) NOT NULL DEFAULT '',
373:   `dayofmonth` int(11) NOT NULL DEFAULT '0',
374:   `monthofyear` int(11) NOT NULL DEFAULT '0',
375:   `year` int(11) NOT NULL DEFAULT '0',
376:   `starthour` int(11) NOT NULL DEFAULT '0',
377:   `startmin` int(11) NOT NULL DEFAULT '0',
378:   `finishhour` int(11) NOT NULL DEFAULT '23',
379:   `finishmin` int(11) NOT NULL DEFAULT '59',
380:   PRIMARY KEY (`scheditemid`)
381: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
382: /*!40101 SET character_set_client = @saved_cs_client */;
383: 
384: --
385: -- Table structure for table `fnschedule`
386: --
387: 
388: DROP TABLE IF EXISTS `fnschedule`;
389: /*!40101 SET @saved_cs_client     = @@character_set_client */;
390: /*!40101 SET character_set_client = utf8 */;
391: CREATE TABLE `fnschedule` (
392:   `scheduleid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
393:   `schedulename` varchar(128) NOT NULL DEFAULT '',
394:   `defaultaction` tinyint(1) NOT NULL DEFAULT '1',
395:   PRIMARY KEY (`scheduleid`)
396: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
397: /*!40101 SET character_set_client = @saved_cs_client */;
398: 
399: --
400: -- Table structure for table `fnsession`
401: --
402: 
403: DROP TABLE IF EXISTS `fnsession`;
404: /*!40101 SET @saved_cs_client     = @@character_set_client */;
405: /*!40101 SET character_set_client = utf8 */;
406: CREATE TABLE `fnsession` (
407:   `sessionid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
408:   `sessionkey` varchar(128) NOT NULL DEFAULT '',
409:   `ipaddress` varchar(128) NOT NULL DEFAULT '',
410:   `username` varchar(64) NOT NULL DEFAULT '',
411:   `startx` bigint(20) unsigned NOT NULL DEFAULT '0',
412:   `updatex` bigint(20) unsigned NOT NULL DEFAULT '0',
413:   `userlevel` int(11) NOT NULL DEFAULT '0',
414:   PRIMARY KEY (`sessionid`)
415: ) ENGINE=MyISAM AUTO_INCREMENT=173 DEFAULT CHARSET=latin1;
416: /*!40101 SET character_set_client = @saved_cs_client */;
417: 
418: --
419: -- Table structure for table `fntestrun`
420: --
421: 
422: DROP TABLE IF EXISTS `fntestrun`;
423: /*!40101 SET @saved_cs_client     = @@character_set_client */;
424: /*!40101 SET character_set_client = utf8 */;
425: CREATE TABLE `fntestrun` (
426:   `trid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
427:   `startx` bigint(20) unsigned NOT NULL DEFAULT '0',
428:   `finishx` bigint(20) unsigned NOT NULL DEFAULT '0',
429:   `routput` text,
430:   `fnode` varchar(64) NOT NULL DEFAULT '',
431:   PRIMARY KEY (`trid`),
432:   KEY `finishx` (`finishx`),
433:   KEY `fnode` (`fnode`)
434: ) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=latin1;
435: /*!40101 SET character_set_client = @saved_cs_client */;
436: 
437: --
438: -- Table structure for table `fnuser`
439: --
440: 
441: DROP TABLE IF EXISTS `fnuser`;
442: /*!40101 SET @saved_cs_client     = @@character_set_client */;
443: /*!40101 SET character_set_client = utf8 */;
444: CREATE TABLE `fnuser` (
445:   `username` varchar(64) NOT NULL,
446:   `password` varchar(64) NOT NULL,
447:   `realname` varchar(128) NOT NULL DEFAULT '',
448:   `userlevel` int(11) NOT NULL DEFAULT '1',
449:   `grouplock` tinyint(4) NOT NULL DEFAULT '0',
450:   PRIMARY KEY (`username`)
451: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
452: /*!40101 SET character_set_client = @saved_cs_client */;
453: 
454: --
455: -- Table structure for table `fnview`
456: --
457: 
458: DROP TABLE IF EXISTS `fnview`;
459: /*!40101 SET @saved_cs_client     = @@character_set_client */;
460: /*!40101 SET character_set_client = utf8 */;
461: CREATE TABLE `fnview` (
462:   `viewid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
463:   `vtitle` varchar(128) NOT NULL DEFAULT '',
464:   `vstyle` varchar(32) NOT NULL DEFAULT '',
465:   `vpublic` tinyint(1) NOT NULL DEFAULT '0',
466:   `vclick` varchar(32) NOT NULL DEFAULT '',
467:   `vrefresh` int(11) NOT NULL DEFAULT '0',
468:   `vlinkv` bigint(20) unsigned NOT NULL DEFAULT '0',
469:   `vcolumns` smallint(6) NOT NULL DEFAULT '0',
470:   `vcolon` tinyint(1) NOT NULL DEFAULT '1',
471:   `vdashes` tinyint(1) NOT NULL DEFAULT '1',
472:   `vtimeago` tinyint(1) NOT NULL DEFAULT '1',
473:   PRIMARY KEY (`viewid`)
474: ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
475: /*!40101 SET character_set_client = @saved_cs_client */;
476: 
477: --
478: -- Table structure for table `fnviewitem`
479: --
480: 
481: DROP TABLE IF EXISTS `fnviewitem`;
482: /*!40101 SET @saved_cs_client     = @@character_set_client */;
483: /*!40101 SET character_set_client = utf8 */;
484: CREATE TABLE `fnviewitem` (
485:   `viewitemid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
486:   `viewid` bigint(20) unsigned NOT NULL DEFAULT '0',
487:   `itype` varchar(128) NOT NULL DEFAULT '',
488:   `ioption` varchar(250) NOT NULL DEFAULT '',
489:   `icolour` tinyint(1) NOT NULL DEFAULT '1',
490:   `itextstatus` tinyint(1) NOT NULL DEFAULT '0',
491:   `idetail` smallint(5) unsigned NOT NULL DEFAULT '0',
492:   `iweight` int(10) unsigned NOT NULL DEFAULT '0',
493:   `isize` smallint(6) NOT NULL DEFAULT '0',
494:   `igraphic` smallint(6) NOT NULL DEFAULT '0',
495:   `iname` varchar(64) NOT NULL DEFAULT '',
496:   PRIMARY KEY (`viewitemid`),
497:   KEY `viewid` (`viewid`)
498: ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
499: /*!40101 SET character_set_client = @saved_cs_client */;
500: /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
501: 
502: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
503: /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
504: /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
505: /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
506: /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
507: /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
508: /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
509: 
510: -- Dump completed on 2017-09-01 15:09:48
511: