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