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