1: -- With DROP TABLES - will clean database
  2: -- MySQL dump 10.13  Distrib 5.1.47, for pc-linux-gnu (i686)
  3: --
  4: -- Host: localhost    Database: freenats
  5: -- ------------------------------------------------------
  6: -- Server version	5.1.47
  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=26 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,
 49:   `etolist` text NOT NULL,
 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 NOT NULL,
 55:   `aname` varchar(120) NOT NULL,
 56:   `ctrdate` varchar(8) NOT 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) NOT NULL,
 76:   PRIMARY KEY (`alid`),
 77:   KEY `alertid` (`alertid`)
 78: ) ENGINE=MyISAM AUTO_INCREMENT=89 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,
 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,
107:   `evalue` varchar(128) NOT NULL,
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,
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=2 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,
142:   PRIMARY KEY (`glid`),
143:   KEY `groupid` (`groupid`)
144: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
145: /*!40101 SET character_set_client = @saved_cs_client */;
146: 
147: --
148: -- Table structure for table `fnlocaltest`
149: --
150: 
151: DROP TABLE IF EXISTS `fnlocaltest`;
152: /*!40101 SET @saved_cs_client     = @@character_set_client */;
153: /*!40101 SET character_set_client = utf8 */;
154: CREATE TABLE `fnlocaltest` (
155:   `localtestid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
156:   `nodeid` varchar(64) NOT NULL,
157:   `alertlevel` int(11) NOT NULL DEFAULT '-1',
158:   `lastrunx` bigint(20) unsigned NOT NULL DEFAULT '0',
159:   `testtype` varchar(128) NOT NULL,
160:   `testparam` varchar(250) DEFAULT NULL,
161:   `testrecord` tinyint(1) NOT NULL DEFAULT '0',
162:   `simpleeval` tinyint(1) NOT NULL DEFAULT '1',
163:   `testname` varchar(64) NOT NULL,
164:   `attempts` int(11) NOT NULL DEFAULT '0',
165:   `timeout` int(11) NOT NULL DEFAULT '0',
166:   `testenabled` tinyint(1) NOT NULL DEFAULT '1',
167:   `testparam1` varchar(250) NOT NULL,
168:   `testparam2` varchar(250) NOT NULL,
169:   `testparam3` varchar(250) NOT NULL,
170:   `testparam4` varchar(250) NOT NULL,
171:   `testparam5` varchar(250) NOT NULL,
172:   `testparam6` varchar(250) NOT NULL,
173:   `testparam7` varchar(250) NOT NULL,
174:   `testparam8` varchar(250) NOT NULL,
175:   `testparam9` varchar(250) NOT NULL,
176:   `lastvalue` float NOT NULL DEFAULT '0',
177:   `testinterval` int(10) unsigned NOT NULL DEFAULT '0',
178:   `nextrunx` bigint(20) unsigned NOT NULL DEFAULT '0',
179:   PRIMARY KEY (`localtestid`),
180:   KEY `nodeid` (`nodeid`)
181: ) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
182: /*!40101 SET character_set_client = @saved_cs_client */;
183: 
184: --
185: -- Table structure for table `fnlog`
186: --
187: 
188: DROP TABLE IF EXISTS `fnlog`;
189: /*!40101 SET @saved_cs_client     = @@character_set_client */;
190: /*!40101 SET character_set_client = utf8 */;
191: CREATE TABLE `fnlog` (
192:   `logid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
193:   `postedx` bigint(20) unsigned NOT NULL DEFAULT '0',
194:   `modid` varchar(32) NOT NULL,
195:   `catid` varchar(32) NOT NULL,
196:   `username` varchar(64) NOT NULL,
197:   `loglevel` int(11) NOT NULL DEFAULT '1',
198:   `logevent` varchar(250) NOT NULL,
199:   PRIMARY KEY (`logid`)
200: ) ENGINE=MyISAM AUTO_INCREMENT=289 DEFAULT CHARSET=latin1;
201: /*!40101 SET character_set_client = @saved_cs_client */;
202: 
203: --
204: -- Table structure for table `fnnalink`
205: --
206: 
207: DROP TABLE IF EXISTS `fnnalink`;
208: /*!40101 SET @saved_cs_client     = @@character_set_client */;
209: /*!40101 SET character_set_client = utf8 */;
210: CREATE TABLE `fnnalink` (
211:   `nalid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
212:   `nodeid` varchar(64) NOT NULL,
213:   `aaid` bigint(20) unsigned NOT NULL DEFAULT '0',
214:   PRIMARY KEY (`nalid`)
215: ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
216: /*!40101 SET character_set_client = @saved_cs_client */;
217: 
218: --
219: -- Table structure for table `fnnode`
220: --
221: 
222: DROP TABLE IF EXISTS `fnnode`;
223: /*!40101 SET @saved_cs_client     = @@character_set_client */;
224: /*!40101 SET character_set_client = utf8 */;
225: CREATE TABLE `fnnode` (
226:   `nodeid` varchar(64) NOT NULL,
227:   `nodename` varchar(128) NOT NULL,
228:   `nodedesc` varchar(254) NOT NULL,
229:   `hostname` varchar(254) NOT NULL,
230:   `nodeenabled` tinyint(1) NOT NULL DEFAULT '0',
231:   `pingtest` tinyint(1) NOT NULL DEFAULT '0',
232:   `pingfatal` tinyint(1) NOT NULL DEFAULT '0',
233:   `alertlevel` int(11) NOT NULL DEFAULT '-1',
234:   `nodeicon` varchar(64) NOT NULL,
235:   `weight` int(10) unsigned NOT NULL DEFAULT '0',
236:   `nodealert` tinyint(1) NOT NULL DEFAULT '1',
237:   `scheduleid` bigint(20) NOT NULL DEFAULT '0',
238:   `lastrunx` bigint(20) unsigned NOT NULL DEFAULT '0',
239:   `testinterval` int(10) unsigned NOT NULL DEFAULT '5',
240:   `nextrunx` bigint(20) unsigned NOT NULL DEFAULT '0',
241:   `nsenabled` tinyint(1) NOT NULL DEFAULT '0',
242:   `nsurl` varchar(254) NOT NULL,
243:   `nskey` varchar(128) NOT NULL,
244:   `nspullenabled` tinyint(1) NOT NULL DEFAULT '0',
245:   `nspushenabled` tinyint(1) NOT NULL DEFAULT '0',
246:   `nspuship` varchar(128) NOT NULL,
247:   `nsinterval` int(10) unsigned NOT NULL DEFAULT '15',
248:   `nslastx` bigint(20) unsigned NOT NULL DEFAULT '0',
249:   `nsnextx` bigint(20) unsigned NOT NULL DEFAULT '0',
250:   `nspullalert` tinyint(1) NOT NULL DEFAULT '0',
251:   `nsfreshpush` tinyint(1) NOT NULL DEFAULT '0',
252:   `masterid` varchar(64) NOT NULL,
253:   `masterjustping` tinyint(1) NOT NULL DEFAULT '1',
254:   `ulink0` tinyint(1) NOT NULL DEFAULT '0',
255:   `ulink0_title` varchar(254) NOT NULL DEFAULT 'VNC',
256:   `ulink0_url` varchar(254) NOT NULL DEFAULT 'http://{HOSTNAME}:5800/',
257:   `ulink1` tinyint(1) NOT NULL DEFAULT '0',
258:   `ulink1_title` varchar(254) NOT NULL DEFAULT 'SSH',
259:   `ulink1_url` varchar(254) NOT NULL DEFAULT 'ssh://{HOSTNAME}',
260:   `ulink2` tinyint(1) NOT NULL DEFAULT '0',
261:   `ulink2_title` varchar(254) NOT NULL DEFAULT 'Web',
262:   `ulink2_url` varchar(254) NOT NULL DEFAULT 'http://{HOSTNAME}',
263:   PRIMARY KEY (`nodeid`),
264:   KEY `masterid` (`masterid`)
265: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
266: /*!40101 SET character_set_client = @saved_cs_client */;
267: 
268: --
269: -- Table structure for table `fnnstest`
270: --
271: 
272: DROP TABLE IF EXISTS `fnnstest`;
273: /*!40101 SET @saved_cs_client     = @@character_set_client */;
274: /*!40101 SET character_set_client = utf8 */;
275: CREATE TABLE `fnnstest` (
276:   `nstestid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
277:   `nodeid` varchar(64) NOT NULL DEFAULT '',
278:   `alertlevel` int(11) NOT NULL DEFAULT '-1',
279:   `lastrunx` bigint(20) unsigned NOT NULL DEFAULT '0',
280:   `testtype` varchar(128) NOT NULL DEFAULT '',
281:   `testdesc` varchar(250) DEFAULT NULL,
282:   `testrecord` tinyint(1) NOT NULL DEFAULT '0',
283:   `simpleeval` tinyint(1) NOT NULL DEFAULT '1',
284:   `testname` varchar(64) NOT NULL DEFAULT '',
285:   `testenabled` tinyint(1) NOT NULL DEFAULT '0',
286:   `lastvalue` varchar(128) NOT NULL DEFAULT '',
287:   `testalerts` tinyint(1) NOT NULL DEFAULT '1',
288:   PRIMARY KEY (`nstestid`),
289:   KEY `nodeid` (`nodeid`)
290: ) ENGINE=MyISAM AUTO_INCREMENT=326 DEFAULT CHARSET=latin1;
291: /*!40101 SET character_set_client = @saved_cs_client */;
292: 
293: --
294: -- Table structure for table `fnrecord`
295: --
296: 
297: DROP TABLE IF EXISTS `fnrecord`;
298: /*!40101 SET @saved_cs_client     = @@character_set_client */;
299: /*!40101 SET character_set_client = utf8 */;
300: CREATE TABLE `fnrecord` (
301:   `recordid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
302:   `testid` varchar(128) NOT NULL,
303:   `alertlevel` int(11) NOT NULL DEFAULT '0',
304:   `testvalue` float NOT NULL DEFAULT '0',
305:   `recordx` bigint(20) unsigned NOT NULL DEFAULT '0',
306:   `nodeid` varchar(64) NOT NULL,
307:   PRIMARY KEY (`recordid`),
308:   KEY `testid` (`testid`),
309:   KEY `recordx` (`recordx`)
310: ) ENGINE=MyISAM AUTO_INCREMENT=278 DEFAULT CHARSET=latin1;
311: /*!40101 SET character_set_client = @saved_cs_client */;
312: 
313: --
314: -- Table structure for table `fnreport`
315: --
316: 
317: DROP TABLE IF EXISTS `fnreport`;
318: /*!40101 SET @saved_cs_client     = @@character_set_client */;
319: /*!40101 SET character_set_client = utf8 */;
320: CREATE TABLE `fnreport` (
321:   `reportid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
322:   `reportname` varchar(128) NOT NULL DEFAULT '',
323:   `reporttests` text NOT NULL,
324:   PRIMARY KEY (`reportid`)
325: ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
326: /*!40101 SET character_set_client = @saved_cs_client */;
327: 
328: --
329: -- Table structure for table `fnrssfeed`
330: --
331: 
332: DROP TABLE IF EXISTS `fnrssfeed`;
333: /*!40101 SET @saved_cs_client     = @@character_set_client */;
334: /*!40101 SET character_set_client = utf8 */;
335: CREATE TABLE `fnrssfeed` (
336:   `feedid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
337:   `feedkey` varchar(254) NOT NULL,
338:   `feedname` varchar(254) NOT NULL,
339:   `feedtype` varchar(32) NOT NULL,
340:   `typeopt` varchar(254) NOT NULL,
341:   `feedrange` varchar(32) NOT NULL,
342:   `rangeopt` varchar(254) NOT NULL,
343:   PRIMARY KEY (`feedid`)
344: ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
345: /*!40101 SET character_set_client = @saved_cs_client */;
346: 
347: --
348: -- Table structure for table `fnscheditem`
349: --
350: 
351: DROP TABLE IF EXISTS `fnscheditem`;
352: /*!40101 SET @saved_cs_client     = @@character_set_client */;
353: /*!40101 SET character_set_client = utf8 */;
354: CREATE TABLE `fnscheditem` (
355:   `scheditemid` bigint(20) NOT NULL AUTO_INCREMENT,
356:   `scheduleid` bigint(20) NOT NULL DEFAULT '0',
357:   `dayofweek` varchar(8) NOT NULL DEFAULT '',
358:   `dayofmonth` int(11) NOT NULL DEFAULT '0',
359:   `monthofyear` int(11) NOT NULL DEFAULT '0',
360:   `year` int(11) NOT NULL DEFAULT '0',
361:   `starthour` int(11) NOT NULL DEFAULT '0',
362:   `startmin` int(11) NOT NULL DEFAULT '0',
363:   `finishhour` int(11) NOT NULL DEFAULT '23',
364:   `finishmin` int(11) NOT NULL DEFAULT '59',
365:   PRIMARY KEY (`scheditemid`)
366: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
367: /*!40101 SET character_set_client = @saved_cs_client */;
368: 
369: --
370: -- Table structure for table `fnschedule`
371: --
372: 
373: DROP TABLE IF EXISTS `fnschedule`;
374: /*!40101 SET @saved_cs_client     = @@character_set_client */;
375: /*!40101 SET character_set_client = utf8 */;
376: CREATE TABLE `fnschedule` (
377:   `scheduleid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
378:   `schedulename` varchar(128) NOT NULL DEFAULT '',
379:   `defaultaction` tinyint(1) NOT NULL DEFAULT '1',
380:   PRIMARY KEY (`scheduleid`)
381: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
382: /*!40101 SET character_set_client = @saved_cs_client */;
383: 
384: --
385: -- Table structure for table `fnsession`
386: --
387: 
388: DROP TABLE IF EXISTS `fnsession`;
389: /*!40101 SET @saved_cs_client     = @@character_set_client */;
390: /*!40101 SET character_set_client = utf8 */;
391: CREATE TABLE `fnsession` (
392:   `sessionid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
393:   `sessionkey` varchar(128) NOT NULL,
394:   `ipaddress` varchar(128) NOT NULL,
395:   `username` varchar(64) NOT NULL,
396:   `startx` bigint(20) unsigned NOT NULL DEFAULT '0',
397:   `updatex` bigint(20) unsigned NOT NULL DEFAULT '0',
398:   `userlevel` int(11) NOT NULL DEFAULT '0',
399:   PRIMARY KEY (`sessionid`)
400: ) ENGINE=MyISAM AUTO_INCREMENT=130 DEFAULT CHARSET=latin1;
401: /*!40101 SET character_set_client = @saved_cs_client */;
402: 
403: --
404: -- Table structure for table `fntestrun`
405: --
406: 
407: DROP TABLE IF EXISTS `fntestrun`;
408: /*!40101 SET @saved_cs_client     = @@character_set_client */;
409: /*!40101 SET character_set_client = utf8 */;
410: CREATE TABLE `fntestrun` (
411:   `trid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
412:   `startx` bigint(20) unsigned NOT NULL DEFAULT '0',
413:   `finishx` bigint(20) unsigned NOT NULL DEFAULT '0',
414:   `routput` text NOT NULL,
415:   `fnode` varchar(64) NOT NULL,
416:   PRIMARY KEY (`trid`),
417:   KEY `finishx` (`finishx`),
418:   KEY `fnode` (`fnode`)
419: ) ENGINE=MyISAM AUTO_INCREMENT=121 DEFAULT CHARSET=latin1;
420: /*!40101 SET character_set_client = @saved_cs_client */;
421: 
422: --
423: -- Table structure for table `fnuser`
424: --
425: 
426: DROP TABLE IF EXISTS `fnuser`;
427: /*!40101 SET @saved_cs_client     = @@character_set_client */;
428: /*!40101 SET character_set_client = utf8 */;
429: CREATE TABLE `fnuser` (
430:   `username` varchar(64) NOT NULL,
431:   `password` varchar(64) NOT NULL,
432:   `realname` varchar(128) NOT NULL,
433:   `userlevel` int(11) NOT NULL DEFAULT '1',
434:   PRIMARY KEY (`username`)
435: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
436: /*!40101 SET character_set_client = @saved_cs_client */;
437: 
438: --
439: -- Table structure for table `fnview`
440: --
441: 
442: DROP TABLE IF EXISTS `fnview`;
443: /*!40101 SET @saved_cs_client     = @@character_set_client */;
444: /*!40101 SET character_set_client = utf8 */;
445: CREATE TABLE `fnview` (
446:   `viewid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
447:   `vtitle` varchar(128) NOT NULL DEFAULT '',
448:   `vstyle` varchar(32) NOT NULL DEFAULT '',
449:   `vpublic` tinyint(1) NOT NULL DEFAULT '0',
450:   `vclick` varchar(32) NOT NULL DEFAULT '',
451:   `vrefresh` int(11) NOT NULL DEFAULT '0',
452:   `vlinkv` bigint(20) unsigned NOT NULL DEFAULT '0',
453:   `vcolumns` smallint(6) NOT NULL DEFAULT '0',
454:   `vcolon` tinyint(1) NOT NULL DEFAULT '1',
455:   `vdashes` tinyint(1) NOT NULL DEFAULT '1',
456:   `vtimeago` tinyint(1) NOT NULL DEFAULT '1',
457:   PRIMARY KEY (`viewid`)
458: ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
459: /*!40101 SET character_set_client = @saved_cs_client */;
460: 
461: --
462: -- Table structure for table `fnviewitem`
463: --
464: 
465: DROP TABLE IF EXISTS `fnviewitem`;
466: /*!40101 SET @saved_cs_client     = @@character_set_client */;
467: /*!40101 SET character_set_client = utf8 */;
468: CREATE TABLE `fnviewitem` (
469:   `viewitemid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
470:   `viewid` bigint(20) unsigned NOT NULL DEFAULT '0',
471:   `itype` varchar(128) NOT NULL DEFAULT '',
472:   `ioption` varchar(250) NOT NULL DEFAULT '',
473:   `icolour` tinyint(1) NOT NULL DEFAULT '1',
474:   `itextstatus` tinyint(1) NOT NULL DEFAULT '0',
475:   `idetail` smallint(5) unsigned NOT NULL DEFAULT '0',
476:   `iweight` int(10) unsigned NOT NULL DEFAULT '0',
477:   `isize` smallint(6) NOT NULL DEFAULT '0',
478:   `igraphic` smallint(6) NOT NULL DEFAULT '0',
479:   `iname` varchar(64) NOT NULL DEFAULT '',
480:   PRIMARY KEY (`viewitemid`),
481:   KEY `viewid` (`viewid`)
482: ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
483: /*!40101 SET character_set_client = @saved_cs_client */;
484: /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
485: 
486: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
487: /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
488: /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
489: /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
490: /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
491: /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
492: /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
493: 
494: -- Dump completed on 2011-11-11 19:46:18
495: