|
Viewing File server/base/sql/schema.sql of 0.02.69a
|
1: -- No DROP TABLES - suitable for upgrade 2: -- MySQL dump 10.9 3: -- 4: -- Host: localhost Database: freenats 5: -- ------------------------------------------------------ 6: -- Server version 4.1.14 7: /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; 8: /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; 9: /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; 10: /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; 11: 12: -- 13: -- Table structure for table `fnalert` 14: -- 15: 16: CREATE TABLE `fnalert` ( 17: `alertid` bigint(20) unsigned NOT NULL auto_increment, 18: `nodeid` varchar(64) NOT NULL default '', 19: `alertlevel` int(11) NOT NULL default '0', 20: `openedx` bigint(20) unsigned NOT NULL default '0', 21: `closedx` bigint(20) unsigned NOT NULL default '0', 22: PRIMARY KEY (`alertid`) 23: ); 24: 25: -- 26: -- Table structure for table `fnalertaction` 27: -- 28: 29: CREATE TABLE `fnalertaction` ( 30: `aaid` bigint(20) unsigned NOT NULL auto_increment, 31: `atype` varchar(32) NOT NULL default '', 32: `efrom` varchar(250) NOT NULL default '', 33: `etolist` text NOT NULL, 34: `esubject` int(11) NOT NULL default '0', 35: `etype` int(11) NOT NULL default '0', 36: `awarnings` tinyint(1) NOT NULL default '0', 37: `adecrease` tinyint(1) NOT NULL default '0', 38: `mdata` text NOT NULL, 39: `aname` varchar(120) NOT NULL default '', 40: `ctrdate` varchar(8) NOT NULL default '', 41: `ctrlimit` int(10) unsigned NOT NULL default '0', 42: `ctrtoday` int(10) unsigned NOT NULL default '0', 43: PRIMARY KEY (`aaid`) 44: ); 45: 46: -- 47: -- Table structure for table `fnalertlog` 48: -- 49: 50: CREATE TABLE `fnalertlog` ( 51: `alid` bigint(20) unsigned NOT NULL auto_increment, 52: `alertid` bigint(20) unsigned NOT NULL default '0', 53: `postedx` bigint(20) unsigned NOT NULL default '0', 54: `logentry` varchar(250) NOT NULL default '', 55: PRIMARY KEY (`alid`) 56: ); 57: 58: -- 59: -- Table structure for table `fnconfig` 60: -- 61: 62: CREATE TABLE `fnconfig` ( 63: `fnc_var` varchar(64) NOT NULL default '', 64: `fnc_val` varchar(64) NOT NULL default '', 65: PRIMARY KEY (`fnc_var`) 66: ); 67: 68: -- 69: -- Table structure for table `fneval` 70: -- 71: 72: CREATE TABLE `fneval` ( 73: `evalid` bigint(20) unsigned NOT NULL auto_increment, 74: `testid` varchar(128) NOT NULL default '', 75: `weight` int(11) NOT NULL default '0', 76: `eoperator` varchar(32) NOT NULL default '', 77: `evalue` varchar(128) NOT NULL default '', 78: `eoutcome` int(11) NOT NULL default '0', 79: PRIMARY KEY (`evalid`) 80: ); 81: 82: -- 83: -- Table structure for table `fngroup` 84: -- 85: 86: CREATE TABLE `fngroup` ( 87: `groupid` bigint(20) unsigned NOT NULL auto_increment, 88: `groupname` varchar(128) NOT NULL default '', 89: `groupdesc` varchar(250) NOT NULL default '', 90: `groupicon` varchar(64) NOT NULL default '', 91: `weight` int(10) unsigned NOT NULL default '0', 92: PRIMARY KEY (`groupid`) 93: ); 94: 95: -- 96: -- Table structure for table `fngrouplink` 97: -- 98: 99: CREATE TABLE `fngrouplink` ( 100: `glid` bigint(20) unsigned NOT NULL auto_increment, 101: `groupid` bigint(20) unsigned NOT NULL default '0', 102: `nodeid` varchar(64) NOT NULL default '', 103: PRIMARY KEY (`glid`) 104: ); 105: 106: -- 107: -- Table structure for table `fnlocaltest` 108: -- 109: 110: CREATE TABLE `fnlocaltest` ( 111: `localtestid` bigint(20) unsigned NOT NULL auto_increment, 112: `nodeid` varchar(64) NOT NULL default '', 113: `alertlevel` int(11) NOT NULL default '-1', 114: `lastrunx` bigint(20) unsigned NOT NULL default '0', 115: `testtype` varchar(128) NOT NULL default '', 116: `testparam` varchar(250) default NULL, 117: `testrecord` tinyint(1) NOT NULL default '0', 118: `simpleeval` tinyint(1) NOT NULL default '1', 119: `testname` varchar(64) NOT NULL default '', 120: `attempts` int(11) NOT NULL default '0', 121: `timeout` int(11) NOT NULL default '0', 122: PRIMARY KEY (`localtestid`), 123: KEY `nodeid` (`nodeid`) 124: ); 125: 126: -- 127: -- Table structure for table `fnlog` 128: -- 129: 130: CREATE TABLE `fnlog` ( 131: `logid` bigint(20) unsigned NOT NULL auto_increment, 132: `postedx` bigint(20) unsigned NOT NULL default '0', 133: `modid` varchar(32) NOT NULL default '', 134: `catid` varchar(32) NOT NULL default '', 135: `username` varchar(64) NOT NULL default '', 136: `loglevel` int(11) NOT NULL default '1', 137: `logevent` varchar(250) NOT NULL default '', 138: PRIMARY KEY (`logid`) 139: ); 140: 141: -- 142: -- Table structure for table `fnnalink` 143: -- 144: 145: CREATE TABLE `fnnalink` ( 146: `nalid` bigint(20) unsigned NOT NULL auto_increment, 147: `nodeid` varchar(64) NOT NULL default '', 148: `aaid` bigint(20) unsigned NOT NULL default '0', 149: PRIMARY KEY (`nalid`) 150: ); 151: 152: -- 153: -- Table structure for table `fnnode` 154: -- 155: 156: CREATE TABLE `fnnode` ( 157: `nodeid` varchar(64) NOT NULL default '', 158: `nodename` varchar(128) NOT NULL default '', 159: `nodedesc` varchar(254) NOT NULL default '', 160: `hostname` varchar(254) NOT NULL default '', 161: `nodeenabled` tinyint(1) NOT NULL default '0', 162: `pingtest` tinyint(1) NOT NULL default '0', 163: `pingfatal` tinyint(1) NOT NULL default '0', 164: `alertlevel` int(11) NOT NULL default '-1', 165: `nodeicon` varchar(64) NOT NULL default '', 166: `weight` int(10) unsigned NOT NULL default '0', 167: `nodealert` tinyint(1) NOT NULL default '1', 168: PRIMARY KEY (`nodeid`) 169: ); 170: 171: -- 172: -- Table structure for table `fnrecord` 173: -- 174: 175: CREATE TABLE `fnrecord` ( 176: `recordid` bigint(20) unsigned NOT NULL auto_increment, 177: `testid` varchar(128) NOT NULL default '', 178: `alertlevel` int(11) NOT NULL default '0', 179: `testvalue` float NOT NULL default '0', 180: `recordx` bigint(20) unsigned NOT NULL default '0', 181: `nodeid` varchar(64) NOT NULL default '', 182: PRIMARY KEY (`recordid`), 183: KEY `testid` (`testid`), 184: KEY `recordx` (`recordx`) 185: ); 186: 187: -- 188: -- Table structure for table `fnsession` 189: -- 190: 191: CREATE TABLE `fnsession` ( 192: `sessionid` bigint(20) unsigned NOT NULL auto_increment, 193: `sessionkey` varchar(128) NOT NULL default '', 194: `ipaddress` varchar(128) NOT NULL default '', 195: `username` varchar(64) NOT NULL default '', 196: `startx` bigint(20) unsigned NOT NULL default '0', 197: `updatex` bigint(20) unsigned NOT NULL default '0', 198: `userlevel` int(11) NOT NULL default '0', 199: PRIMARY KEY (`sessionid`) 200: ); 201: 202: -- 203: -- Table structure for table `fntestrun` 204: -- 205: 206: CREATE TABLE `fntestrun` ( 207: `trid` bigint(20) unsigned NOT NULL auto_increment, 208: `startx` bigint(20) unsigned NOT NULL default '0', 209: `finishx` bigint(20) unsigned NOT NULL default '0', 210: `routput` text NOT NULL, 211: `fnode` varchar(64) NOT NULL default '', 212: PRIMARY KEY (`trid`), 213: KEY `fnode` (`fnode`) 214: ); 215: 216: -- 217: -- Table structure for table `fnuser` 218: -- 219: 220: CREATE TABLE `fnuser` ( 221: `username` varchar(64) NOT NULL default '', 222: `password` varchar(64) NOT NULL default '', 223: `realname` varchar(128) NOT NULL default '', 224: `userlevel` int(11) NOT NULL default '1', 225: PRIMARY KEY (`username`) 226: ); 227: 228: -- 229: -- Table structure for table `fnview` 230: -- 231: 232: CREATE TABLE `fnview` ( 233: `viewid` bigint(20) unsigned NOT NULL auto_increment, 234: `vtitle` varchar(128) NOT NULL default '', 235: `vstyle` varchar(32) NOT NULL default '', 236: `vpublic` tinyint(1) NOT NULL default '0', 237: `vclick` varchar(32) NOT NULL default '', 238: `vrefresh` int(11) NOT NULL default '0', 239: `vlinkv` bigint(20) unsigned NOT NULL default '0', 240: `vcolumns` smallint(6) NOT NULL default '0', 241: `vcolon` tinyint(1) NOT NULL default '1', 242: `vdashes` tinyint(1) NOT NULL default '1', 243: `vtimeago` tinyint(1) NOT NULL default '1', 244: PRIMARY KEY (`viewid`) 245: ); 246: 247: -- 248: -- Table structure for table `fnviewitem` 249: -- 250: 251: CREATE TABLE `fnviewitem` ( 252: `viewitemid` bigint(20) unsigned NOT NULL auto_increment, 253: `viewid` bigint(20) unsigned NOT NULL default '0', 254: `itype` varchar(128) NOT NULL default '', 255: `ioption` varchar(250) NOT NULL default '', 256: `icolour` tinyint(1) NOT NULL default '1', 257: `itextstatus` tinyint(1) NOT NULL default '0', 258: `idetail` smallint(5) unsigned NOT NULL default '0', 259: `iweight` int(10) unsigned NOT NULL default '0', 260: `isize` smallint(6) NOT NULL default '0', 261: `igraphic` smallint(6) NOT NULL default '0', 262: `iname` varchar(64) NOT NULL default '', 263: PRIMARY KEY (`viewitemid`), 264: KEY `viewid` (`viewid`) 265: ); 266: 267: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; 268: /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; 269: /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; 270: /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; 271: 272: