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