File:
1.14.0a/server/base/sql/schema.drop.sql (
View as Code)
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: