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