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