|
Viewing File server/base/sql/schema.sql of 0.02.56a
|
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: ); 124: 125: -- 126: -- Table structure for table `fnlog` 127: -- 128: 129: CREATE TABLE `fnlog` ( 130: `logid` bigint(20) unsigned NOT NULL auto_increment, 131: `postedx` bigint(20) unsigned NOT NULL default '0', 132: `modid` varchar(32) NOT NULL default '', 133: `catid` varchar(32) NOT NULL default '', 134: `username` varchar(64) NOT NULL default '', 135: `loglevel` int(11) NOT NULL default '1', 136: `logevent` varchar(250) NOT NULL default '', 137: PRIMARY KEY (`logid`) 138: ); 139: 140: -- 141: -- Table structure for table `fnnalink` 142: -- 143: 144: CREATE TABLE `fnnalink` ( 145: `nalid` bigint(20) unsigned NOT NULL auto_increment, 146: `nodeid` varchar(64) NOT NULL default '', 147: `aaid` bigint(20) unsigned NOT NULL default '0', 148: PRIMARY KEY (`nalid`) 149: ); 150: 151: -- 152: -- Table structure for table `fnnode` 153: -- 154: 155: CREATE TABLE `fnnode` ( 156: `nodeid` varchar(64) NOT NULL default '', 157: `nodename` varchar(128) NOT NULL default '', 158: `nodedesc` varchar(254) NOT NULL default '', 159: `hostname` varchar(254) NOT NULL default '', 160: `nodeenabled` tinyint(1) NOT NULL default '0', 161: `pingtest` tinyint(1) NOT NULL default '0', 162: `pingfatal` tinyint(1) NOT NULL default '0', 163: `alertlevel` int(11) NOT NULL default '-1', 164: `nodeicon` varchar(64) NOT NULL default '', 165: `weight` int(10) unsigned NOT NULL default '0', 166: `nodealert` tinyint(1) NOT NULL default '1', 167: PRIMARY KEY (`nodeid`) 168: ); 169: 170: -- 171: -- Table structure for table `fnrecord` 172: -- 173: 174: CREATE TABLE `fnrecord` ( 175: `recordid` bigint(20) unsigned NOT NULL auto_increment, 176: `testid` varchar(128) NOT NULL default '', 177: `alertlevel` int(11) NOT NULL default '0', 178: `testvalue` float NOT NULL default '0', 179: `recordx` bigint(20) unsigned NOT NULL default '0', 180: `nodeid` varchar(64) NOT NULL default '', 181: PRIMARY KEY (`recordid`) 182: ); 183: 184: -- 185: -- Table structure for table `fnsession` 186: -- 187: 188: CREATE TABLE `fnsession` ( 189: `sessionid` bigint(20) unsigned NOT NULL auto_increment, 190: `sessionkey` varchar(128) NOT NULL default '', 191: `ipaddress` varchar(128) NOT NULL default '', 192: `username` varchar(64) NOT NULL default '', 193: `startx` bigint(20) unsigned NOT NULL default '0', 194: `updatex` bigint(20) unsigned NOT NULL default '0', 195: `userlevel` int(11) NOT NULL default '0', 196: PRIMARY KEY (`sessionid`) 197: ); 198: 199: -- 200: -- Table structure for table `fntestrun` 201: -- 202: 203: CREATE TABLE `fntestrun` ( 204: `trid` bigint(20) unsigned NOT NULL auto_increment, 205: `startx` bigint(20) unsigned NOT NULL default '0', 206: `finishx` bigint(20) unsigned NOT NULL default '0', 207: `routput` text NOT NULL, 208: `fnode` varchar(64) NOT NULL default '', 209: PRIMARY KEY (`trid`) 210: ); 211: 212: -- 213: -- Table structure for table `fnuser` 214: -- 215: 216: CREATE TABLE `fnuser` ( 217: `username` varchar(64) NOT NULL default '', 218: `password` varchar(64) NOT NULL default '', 219: `realname` varchar(128) NOT NULL default '', 220: `userlevel` int(11) NOT NULL default '1', 221: PRIMARY KEY (`username`) 222: ); 223: 224: -- 225: -- Table structure for table `fnview` 226: -- 227: 228: CREATE TABLE `fnview` ( 229: `viewid` bigint(20) unsigned NOT NULL auto_increment, 230: `vtitle` varchar(128) NOT NULL default '', 231: `vstyle` varchar(32) NOT NULL default '', 232: `vpublic` tinyint(1) NOT NULL default '0', 233: `vclick` varchar(32) NOT NULL default '', 234: `vrefresh` int(11) NOT NULL default '0', 235: `vlinkv` bigint(20) unsigned NOT NULL default '0', 236: PRIMARY KEY (`viewid`) 237: ); 238: 239: -- 240: -- Table structure for table `fnviewitem` 241: -- 242: 243: CREATE TABLE `fnviewitem` ( 244: `viewitemid` bigint(20) unsigned NOT NULL auto_increment, 245: `viewid` bigint(20) unsigned NOT NULL default '0', 246: `itype` varchar(128) NOT NULL default '', 247: `ioption` varchar(250) NOT NULL default '', 248: `icolour` tinyint(1) NOT NULL default '1', 249: `itextstatus` tinyint(1) NOT NULL default '0', 250: `idetail` smallint(5) unsigned NOT NULL default '0', 251: `iweight` int(10) unsigned NOT NULL default '0', 252: `isize` smallint(6) NOT NULL default '0', 253: `igraphic` smallint(6) NOT NULL default '0', 254: PRIMARY KEY (`viewitemid`) 255: ); 256: 257: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; 258: /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; 259: /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; 260: /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; 261: 262: