|
Viewing File server/base/sql/schema.upgrade.sql of 1.19.3a
|
1: -- FreeNATS freenats-1.19.3a Schema 2: -- Experimental Upgrade SQL - run after schema.sql (not drop!) 3: -- Both will generate many many errors - run with --force, ignore errors 4: -- myrug -- PurplePixie Systems 5: -- http://www.purplepixie.org/myrug 6: -- 7: -- SHOW TABLES 8: -- Table: fnalert 9: -- DESCRIBE fnalert 10: ALTER TABLE `fnalert` CHANGE `alertid` `alertid` bigint(20) unsigned NOT NULL auto_increment; 11: ALTER TABLE `fnalert` ADD `alertid` bigint(20) unsigned NOT NULL auto_increment; 12: ALTER TABLE `fnalert` ADD PRIMARY KEY( `alertid` ); 13: ALTER TABLE `fnalert` CHANGE `nodeid` `nodeid` varchar(64) NOT NULL; 14: ALTER TABLE `fnalert` ADD `nodeid` varchar(64) NOT NULL; 15: CREATE INDEX `nodeid` ON `fnalert` ( `nodeid` ); 16: ALTER TABLE `fnalert` CHANGE `alertlevel` `alertlevel` int(11) NOT NULL DEFAULT '0'; 17: ALTER TABLE `fnalert` ADD `alertlevel` int(11) NOT NULL DEFAULT '0'; 18: ALTER TABLE `fnalert` CHANGE `openedx` `openedx` bigint(20) unsigned NOT NULL DEFAULT '0'; 19: ALTER TABLE `fnalert` ADD `openedx` bigint(20) unsigned NOT NULL DEFAULT '0'; 20: ALTER TABLE `fnalert` CHANGE `closedx` `closedx` bigint(20) unsigned NOT NULL DEFAULT '0'; 21: ALTER TABLE `fnalert` ADD `closedx` bigint(20) unsigned NOT NULL DEFAULT '0'; 22: CREATE INDEX `closedx` ON `fnalert` ( `closedx` ); 23: -- 24: -- Table: fnalertaction 25: -- DESCRIBE fnalertaction 26: ALTER TABLE `fnalertaction` CHANGE `aaid` `aaid` bigint(20) unsigned NOT NULL auto_increment; 27: ALTER TABLE `fnalertaction` ADD `aaid` bigint(20) unsigned NOT NULL auto_increment; 28: ALTER TABLE `fnalertaction` ADD PRIMARY KEY( `aaid` ); 29: ALTER TABLE `fnalertaction` CHANGE `atype` `atype` varchar(32) NOT NULL; 30: ALTER TABLE `fnalertaction` ADD `atype` varchar(32) NOT NULL; 31: ALTER TABLE `fnalertaction` CHANGE `efrom` `efrom` varchar(250) NOT NULL; 32: ALTER TABLE `fnalertaction` ADD `efrom` varchar(250) NOT NULL; 33: ALTER TABLE `fnalertaction` CHANGE `etolist` `etolist` text; 34: ALTER TABLE `fnalertaction` ADD `etolist` text; 35: ALTER TABLE `fnalertaction` CHANGE `esubject` `esubject` int(11) NOT NULL DEFAULT '0'; 36: ALTER TABLE `fnalertaction` ADD `esubject` int(11) NOT NULL DEFAULT '0'; 37: ALTER TABLE `fnalertaction` CHANGE `etype` `etype` int(11) NOT NULL DEFAULT '0'; 38: ALTER TABLE `fnalertaction` ADD `etype` int(11) NOT NULL DEFAULT '0'; 39: ALTER TABLE `fnalertaction` CHANGE `awarnings` `awarnings` tinyint(1) NOT NULL DEFAULT '0'; 40: ALTER TABLE `fnalertaction` ADD `awarnings` tinyint(1) NOT NULL DEFAULT '0'; 41: ALTER TABLE `fnalertaction` CHANGE `adecrease` `adecrease` tinyint(1) NOT NULL DEFAULT '0'; 42: ALTER TABLE `fnalertaction` ADD `adecrease` tinyint(1) NOT NULL DEFAULT '0'; 43: ALTER TABLE `fnalertaction` CHANGE `mdata` `mdata` text; 44: ALTER TABLE `fnalertaction` ADD `mdata` text; 45: ALTER TABLE `fnalertaction` CHANGE `aname` `aname` varchar(120) NOT NULL; 46: ALTER TABLE `fnalertaction` ADD `aname` varchar(120) NOT NULL; 47: ALTER TABLE `fnalertaction` CHANGE `ctrdate` `ctrdate` varchar(8); 48: ALTER TABLE `fnalertaction` ADD `ctrdate` varchar(8); 49: ALTER TABLE `fnalertaction` CHANGE `ctrlimit` `ctrlimit` int(10) unsigned NOT NULL DEFAULT '0'; 50: ALTER TABLE `fnalertaction` ADD `ctrlimit` int(10) unsigned NOT NULL DEFAULT '0'; 51: ALTER TABLE `fnalertaction` CHANGE `ctrtoday` `ctrtoday` int(10) unsigned NOT NULL DEFAULT '0'; 52: ALTER TABLE `fnalertaction` ADD `ctrtoday` int(10) unsigned NOT NULL DEFAULT '0'; 53: ALTER TABLE `fnalertaction` CHANGE `scheduleid` `scheduleid` bigint(20) unsigned NOT NULL DEFAULT '0'; 54: ALTER TABLE `fnalertaction` ADD `scheduleid` bigint(20) unsigned NOT NULL DEFAULT '0'; 55: -- 56: -- Table: fnalertlog 57: -- DESCRIBE fnalertlog 58: ALTER TABLE `fnalertlog` CHANGE `alid` `alid` bigint(20) unsigned NOT NULL auto_increment; 59: ALTER TABLE `fnalertlog` ADD `alid` bigint(20) unsigned NOT NULL auto_increment; 60: ALTER TABLE `fnalertlog` ADD PRIMARY KEY( `alid` ); 61: ALTER TABLE `fnalertlog` CHANGE `alertid` `alertid` bigint(20) unsigned NOT NULL DEFAULT '0'; 62: ALTER TABLE `fnalertlog` ADD `alertid` bigint(20) unsigned NOT NULL DEFAULT '0'; 63: CREATE INDEX `alertid` ON `fnalertlog` ( `alertid` ); 64: ALTER TABLE `fnalertlog` CHANGE `postedx` `postedx` bigint(20) unsigned NOT NULL DEFAULT '0'; 65: ALTER TABLE `fnalertlog` ADD `postedx` bigint(20) unsigned NOT NULL DEFAULT '0'; 66: ALTER TABLE `fnalertlog` CHANGE `logentry` `logentry` varchar(250); 67: ALTER TABLE `fnalertlog` ADD `logentry` varchar(250); 68: -- 69: -- Table: fnconfig 70: -- DESCRIBE fnconfig 71: ALTER TABLE `fnconfig` CHANGE `fnc_var` `fnc_var` varchar(64) NOT NULL; 72: ALTER TABLE `fnconfig` ADD `fnc_var` varchar(64) NOT NULL; 73: ALTER TABLE `fnconfig` ADD PRIMARY KEY( `fnc_var` ); 74: ALTER TABLE `fnconfig` CHANGE `fnc_val` `fnc_val` varchar(64) NOT NULL; 75: ALTER TABLE `fnconfig` ADD `fnc_val` varchar(64) NOT NULL; 76: -- 77: -- Table: fneval 78: -- DESCRIBE fneval 79: ALTER TABLE `fneval` CHANGE `evalid` `evalid` bigint(20) unsigned NOT NULL auto_increment; 80: ALTER TABLE `fneval` ADD `evalid` bigint(20) unsigned NOT NULL auto_increment; 81: ALTER TABLE `fneval` ADD PRIMARY KEY( `evalid` ); 82: ALTER TABLE `fneval` CHANGE `testid` `testid` varchar(128) NOT NULL; 83: ALTER TABLE `fneval` ADD `testid` varchar(128) NOT NULL; 84: CREATE INDEX `testid` ON `fneval` ( `testid` ); 85: ALTER TABLE `fneval` CHANGE `weight` `weight` int(11) NOT NULL DEFAULT '0'; 86: ALTER TABLE `fneval` ADD `weight` int(11) NOT NULL DEFAULT '0'; 87: ALTER TABLE `fneval` CHANGE `eoperator` `eoperator` varchar(32) NOT NULL; 88: ALTER TABLE `fneval` ADD `eoperator` varchar(32) NOT NULL; 89: ALTER TABLE `fneval` CHANGE `evalue` `evalue` varchar(128) NOT NULL; 90: ALTER TABLE `fneval` ADD `evalue` varchar(128) NOT NULL; 91: ALTER TABLE `fneval` CHANGE `eoutcome` `eoutcome` int(11) NOT NULL DEFAULT '0'; 92: ALTER TABLE `fneval` ADD `eoutcome` int(11) NOT NULL DEFAULT '0'; 93: -- 94: -- Table: fngroup 95: -- DESCRIBE fngroup 96: ALTER TABLE `fngroup` CHANGE `groupid` `groupid` bigint(20) unsigned NOT NULL auto_increment; 97: ALTER TABLE `fngroup` ADD `groupid` bigint(20) unsigned NOT NULL auto_increment; 98: ALTER TABLE `fngroup` ADD PRIMARY KEY( `groupid` ); 99: ALTER TABLE `fngroup` CHANGE `groupname` `groupname` varchar(128) NOT NULL; 100: ALTER TABLE `fngroup` ADD `groupname` varchar(128) NOT NULL; 101: ALTER TABLE `fngroup` CHANGE `groupdesc` `groupdesc` varchar(250) NOT NULL; 102: ALTER TABLE `fngroup` ADD `groupdesc` varchar(250) NOT NULL; 103: ALTER TABLE `fngroup` CHANGE `groupicon` `groupicon` varchar(64) NOT NULL; 104: ALTER TABLE `fngroup` ADD `groupicon` varchar(64) NOT NULL; 105: ALTER TABLE `fngroup` CHANGE `weight` `weight` int(10) unsigned NOT NULL DEFAULT '0'; 106: ALTER TABLE `fngroup` ADD `weight` int(10) unsigned NOT NULL DEFAULT '0'; 107: -- 108: -- Table: fngrouplink 109: -- DESCRIBE fngrouplink 110: ALTER TABLE `fngrouplink` CHANGE `glid` `glid` bigint(20) unsigned NOT NULL auto_increment; 111: ALTER TABLE `fngrouplink` ADD `glid` bigint(20) unsigned NOT NULL auto_increment; 112: ALTER TABLE `fngrouplink` ADD PRIMARY KEY( `glid` ); 113: ALTER TABLE `fngrouplink` CHANGE `groupid` `groupid` bigint(20) unsigned NOT NULL DEFAULT '0'; 114: ALTER TABLE `fngrouplink` ADD `groupid` bigint(20) unsigned NOT NULL DEFAULT '0'; 115: CREATE INDEX `groupid` ON `fngrouplink` ( `groupid` ); 116: ALTER TABLE `fngrouplink` CHANGE `nodeid` `nodeid` varchar(64) NOT NULL; 117: ALTER TABLE `fngrouplink` ADD `nodeid` varchar(64) NOT NULL; 118: -- 119: -- Table: fngrouplock 120: -- DESCRIBE fngrouplock 121: ALTER TABLE `fngrouplock` CHANGE `glid` `glid` bigint(20) unsigned NOT NULL auto_increment; 122: ALTER TABLE `fngrouplock` ADD `glid` bigint(20) unsigned NOT NULL auto_increment; 123: ALTER TABLE `fngrouplock` ADD PRIMARY KEY( `glid` ); 124: ALTER TABLE `fngrouplock` CHANGE `username` `username` varchar(64) NOT NULL; 125: ALTER TABLE `fngrouplock` ADD `username` varchar(64) NOT NULL; 126: ALTER TABLE `fngrouplock` CHANGE `groupid` `groupid` bigint(20) NOT NULL DEFAULT '0'; 127: ALTER TABLE `fngrouplock` ADD `groupid` bigint(20) NOT NULL DEFAULT '0'; 128: -- 129: -- Table: fnlocaltest 130: -- DESCRIBE fnlocaltest 131: ALTER TABLE `fnlocaltest` CHANGE `localtestid` `localtestid` bigint(20) unsigned NOT NULL auto_increment; 132: ALTER TABLE `fnlocaltest` ADD `localtestid` bigint(20) unsigned NOT NULL auto_increment; 133: ALTER TABLE `fnlocaltest` ADD PRIMARY KEY( `localtestid` ); 134: ALTER TABLE `fnlocaltest` CHANGE `nodeid` `nodeid` varchar(64) NOT NULL; 135: ALTER TABLE `fnlocaltest` ADD `nodeid` varchar(64) NOT NULL; 136: CREATE INDEX `nodeid` ON `fnlocaltest` ( `nodeid` ); 137: ALTER TABLE `fnlocaltest` CHANGE `alertlevel` `alertlevel` int(11) NOT NULL DEFAULT '-1'; 138: ALTER TABLE `fnlocaltest` ADD `alertlevel` int(11) NOT NULL DEFAULT '-1'; 139: ALTER TABLE `fnlocaltest` CHANGE `lastrunx` `lastrunx` bigint(20) unsigned NOT NULL DEFAULT '0'; 140: ALTER TABLE `fnlocaltest` ADD `lastrunx` bigint(20) unsigned NOT NULL DEFAULT '0'; 141: ALTER TABLE `fnlocaltest` CHANGE `testtype` `testtype` varchar(128) NOT NULL; 142: ALTER TABLE `fnlocaltest` ADD `testtype` varchar(128) NOT NULL; 143: ALTER TABLE `fnlocaltest` CHANGE `testparam` `testparam` varchar(250); 144: ALTER TABLE `fnlocaltest` ADD `testparam` varchar(250); 145: ALTER TABLE `fnlocaltest` CHANGE `testrecord` `testrecord` tinyint(1) NOT NULL DEFAULT '0'; 146: ALTER TABLE `fnlocaltest` ADD `testrecord` tinyint(1) NOT NULL DEFAULT '0'; 147: ALTER TABLE `fnlocaltest` CHANGE `simpleeval` `simpleeval` tinyint(1) NOT NULL DEFAULT '1'; 148: ALTER TABLE `fnlocaltest` ADD `simpleeval` tinyint(1) NOT NULL DEFAULT '1'; 149: ALTER TABLE `fnlocaltest` CHANGE `testname` `testname` varchar(64) NOT NULL; 150: ALTER TABLE `fnlocaltest` ADD `testname` varchar(64) NOT NULL; 151: ALTER TABLE `fnlocaltest` CHANGE `attempts` `attempts` int(11) NOT NULL DEFAULT '0'; 152: ALTER TABLE `fnlocaltest` ADD `attempts` int(11) NOT NULL DEFAULT '0'; 153: ALTER TABLE `fnlocaltest` CHANGE `timeout` `timeout` int(11) NOT NULL DEFAULT '0'; 154: ALTER TABLE `fnlocaltest` ADD `timeout` int(11) NOT NULL DEFAULT '0'; 155: ALTER TABLE `fnlocaltest` CHANGE `testenabled` `testenabled` tinyint(1) NOT NULL DEFAULT '1'; 156: ALTER TABLE `fnlocaltest` ADD `testenabled` tinyint(1) NOT NULL DEFAULT '1'; 157: ALTER TABLE `fnlocaltest` CHANGE `testparam1` `testparam1` varchar(250); 158: ALTER TABLE `fnlocaltest` ADD `testparam1` varchar(250); 159: ALTER TABLE `fnlocaltest` CHANGE `testparam2` `testparam2` varchar(250); 160: ALTER TABLE `fnlocaltest` ADD `testparam2` varchar(250); 161: ALTER TABLE `fnlocaltest` CHANGE `testparam3` `testparam3` varchar(250); 162: ALTER TABLE `fnlocaltest` ADD `testparam3` varchar(250); 163: ALTER TABLE `fnlocaltest` CHANGE `testparam4` `testparam4` varchar(250); 164: ALTER TABLE `fnlocaltest` ADD `testparam4` varchar(250); 165: ALTER TABLE `fnlocaltest` CHANGE `testparam5` `testparam5` varchar(250); 166: ALTER TABLE `fnlocaltest` ADD `testparam5` varchar(250); 167: ALTER TABLE `fnlocaltest` CHANGE `testparam6` `testparam6` varchar(250); 168: ALTER TABLE `fnlocaltest` ADD `testparam6` varchar(250); 169: ALTER TABLE `fnlocaltest` CHANGE `testparam7` `testparam7` varchar(250); 170: ALTER TABLE `fnlocaltest` ADD `testparam7` varchar(250); 171: ALTER TABLE `fnlocaltest` CHANGE `testparam8` `testparam8` varchar(250); 172: ALTER TABLE `fnlocaltest` ADD `testparam8` varchar(250); 173: ALTER TABLE `fnlocaltest` CHANGE `testparam9` `testparam9` varchar(250); 174: ALTER TABLE `fnlocaltest` ADD `testparam9` varchar(250); 175: ALTER TABLE `fnlocaltest` CHANGE `lastvalue` `lastvalue` float NOT NULL DEFAULT '0'; 176: ALTER TABLE `fnlocaltest` ADD `lastvalue` float NOT NULL DEFAULT '0'; 177: ALTER TABLE `fnlocaltest` CHANGE `testinterval` `testinterval` int(10) unsigned NOT NULL DEFAULT '0'; 178: ALTER TABLE `fnlocaltest` ADD `testinterval` int(10) unsigned NOT NULL DEFAULT '0'; 179: ALTER TABLE `fnlocaltest` CHANGE `nextrunx` `nextrunx` bigint(20) unsigned NOT NULL DEFAULT '0'; 180: ALTER TABLE `fnlocaltest` ADD `nextrunx` bigint(20) unsigned NOT NULL DEFAULT '0'; 181: -- 182: -- Table: fnlog 183: -- DESCRIBE fnlog 184: ALTER TABLE `fnlog` CHANGE `logid` `logid` bigint(20) unsigned NOT NULL auto_increment; 185: ALTER TABLE `fnlog` ADD `logid` bigint(20) unsigned NOT NULL auto_increment; 186: ALTER TABLE `fnlog` ADD PRIMARY KEY( `logid` ); 187: ALTER TABLE `fnlog` CHANGE `postedx` `postedx` bigint(20) unsigned NOT NULL DEFAULT '0'; 188: ALTER TABLE `fnlog` ADD `postedx` bigint(20) unsigned NOT NULL DEFAULT '0'; 189: ALTER TABLE `fnlog` CHANGE `modid` `modid` varchar(32) NOT NULL; 190: ALTER TABLE `fnlog` ADD `modid` varchar(32) NOT NULL; 191: ALTER TABLE `fnlog` CHANGE `catid` `catid` varchar(32) NOT NULL; 192: ALTER TABLE `fnlog` ADD `catid` varchar(32) NOT NULL; 193: ALTER TABLE `fnlog` CHANGE `username` `username` varchar(64) NOT NULL; 194: ALTER TABLE `fnlog` ADD `username` varchar(64) NOT NULL; 195: ALTER TABLE `fnlog` CHANGE `loglevel` `loglevel` int(11) NOT NULL DEFAULT '1'; 196: ALTER TABLE `fnlog` ADD `loglevel` int(11) NOT NULL DEFAULT '1'; 197: ALTER TABLE `fnlog` CHANGE `logevent` `logevent` varchar(250) NOT NULL; 198: ALTER TABLE `fnlog` ADD `logevent` varchar(250) NOT NULL; 199: -- 200: -- Table: fnnalink 201: -- DESCRIBE fnnalink 202: ALTER TABLE `fnnalink` CHANGE `nalid` `nalid` bigint(20) unsigned NOT NULL auto_increment; 203: ALTER TABLE `fnnalink` ADD `nalid` bigint(20) unsigned NOT NULL auto_increment; 204: ALTER TABLE `fnnalink` ADD PRIMARY KEY( `nalid` ); 205: ALTER TABLE `fnnalink` CHANGE `nodeid` `nodeid` varchar(64) NOT NULL; 206: ALTER TABLE `fnnalink` ADD `nodeid` varchar(64) NOT NULL; 207: ALTER TABLE `fnnalink` CHANGE `aaid` `aaid` bigint(20) unsigned NOT NULL DEFAULT '0'; 208: ALTER TABLE `fnnalink` ADD `aaid` bigint(20) unsigned NOT NULL DEFAULT '0'; 209: -- 210: -- Table: fnnode 211: -- DESCRIBE fnnode 212: ALTER TABLE `fnnode` CHANGE `nodeid` `nodeid` varchar(64) NOT NULL; 213: ALTER TABLE `fnnode` ADD `nodeid` varchar(64) NOT NULL; 214: ALTER TABLE `fnnode` ADD PRIMARY KEY( `nodeid` ); 215: ALTER TABLE `fnnode` CHANGE `nodename` `nodename` varchar(128) NOT NULL; 216: ALTER TABLE `fnnode` ADD `nodename` varchar(128) NOT NULL; 217: ALTER TABLE `fnnode` CHANGE `nodedesc` `nodedesc` varchar(254) NOT NULL; 218: ALTER TABLE `fnnode` ADD `nodedesc` varchar(254) NOT NULL; 219: ALTER TABLE `fnnode` CHANGE `hostname` `hostname` varchar(254) NOT NULL; 220: ALTER TABLE `fnnode` ADD `hostname` varchar(254) NOT NULL; 221: ALTER TABLE `fnnode` CHANGE `nodeenabled` `nodeenabled` tinyint(1) NOT NULL DEFAULT '0'; 222: ALTER TABLE `fnnode` ADD `nodeenabled` tinyint(1) NOT NULL DEFAULT '0'; 223: ALTER TABLE `fnnode` CHANGE `pingtest` `pingtest` tinyint(1) NOT NULL DEFAULT '0'; 224: ALTER TABLE `fnnode` ADD `pingtest` tinyint(1) NOT NULL DEFAULT '0'; 225: ALTER TABLE `fnnode` CHANGE `pingfatal` `pingfatal` tinyint(1) NOT NULL DEFAULT '0'; 226: ALTER TABLE `fnnode` ADD `pingfatal` tinyint(1) NOT NULL DEFAULT '0'; 227: ALTER TABLE `fnnode` CHANGE `alertlevel` `alertlevel` int(11) NOT NULL DEFAULT '-1'; 228: ALTER TABLE `fnnode` ADD `alertlevel` int(11) NOT NULL DEFAULT '-1'; 229: ALTER TABLE `fnnode` CHANGE `nodeicon` `nodeicon` varchar(64) NOT NULL; 230: ALTER TABLE `fnnode` ADD `nodeicon` varchar(64) NOT NULL; 231: ALTER TABLE `fnnode` CHANGE `weight` `weight` int(10) unsigned NOT NULL DEFAULT '0'; 232: ALTER TABLE `fnnode` ADD `weight` int(10) unsigned NOT NULL DEFAULT '0'; 233: ALTER TABLE `fnnode` CHANGE `nodealert` `nodealert` tinyint(1) NOT NULL DEFAULT '1'; 234: ALTER TABLE `fnnode` ADD `nodealert` tinyint(1) NOT NULL DEFAULT '1'; 235: ALTER TABLE `fnnode` CHANGE `scheduleid` `scheduleid` bigint(20) NOT NULL DEFAULT '0'; 236: ALTER TABLE `fnnode` ADD `scheduleid` bigint(20) NOT NULL DEFAULT '0'; 237: ALTER TABLE `fnnode` CHANGE `lastrunx` `lastrunx` bigint(20) unsigned NOT NULL DEFAULT '0'; 238: ALTER TABLE `fnnode` ADD `lastrunx` bigint(20) unsigned NOT NULL DEFAULT '0'; 239: ALTER TABLE `fnnode` CHANGE `testinterval` `testinterval` int(10) unsigned NOT NULL DEFAULT '5'; 240: ALTER TABLE `fnnode` ADD `testinterval` int(10) unsigned NOT NULL DEFAULT '5'; 241: ALTER TABLE `fnnode` CHANGE `nextrunx` `nextrunx` bigint(20) unsigned NOT NULL DEFAULT '0'; 242: ALTER TABLE `fnnode` ADD `nextrunx` bigint(20) unsigned NOT NULL DEFAULT '0'; 243: ALTER TABLE `fnnode` CHANGE `nsenabled` `nsenabled` tinyint(1) NOT NULL DEFAULT '0'; 244: ALTER TABLE `fnnode` ADD `nsenabled` tinyint(1) NOT NULL DEFAULT '0'; 245: ALTER TABLE `fnnode` CHANGE `nsurl` `nsurl` varchar(254) NOT NULL; 246: ALTER TABLE `fnnode` ADD `nsurl` varchar(254) NOT NULL; 247: ALTER TABLE `fnnode` CHANGE `nskey` `nskey` varchar(250) NOT NULL; 248: ALTER TABLE `fnnode` ADD `nskey` varchar(250) NOT NULL; 249: ALTER TABLE `fnnode` CHANGE `nspullenabled` `nspullenabled` tinyint(1) NOT NULL DEFAULT '0'; 250: ALTER TABLE `fnnode` ADD `nspullenabled` tinyint(1) NOT NULL DEFAULT '0'; 251: ALTER TABLE `fnnode` CHANGE `nspushenabled` `nspushenabled` tinyint(1) NOT NULL DEFAULT '0'; 252: ALTER TABLE `fnnode` ADD `nspushenabled` tinyint(1) NOT NULL DEFAULT '0'; 253: ALTER TABLE `fnnode` CHANGE `nspuship` `nspuship` varchar(128) NOT NULL; 254: ALTER TABLE `fnnode` ADD `nspuship` varchar(128) NOT NULL; 255: ALTER TABLE `fnnode` CHANGE `nsinterval` `nsinterval` int(10) unsigned NOT NULL DEFAULT '15'; 256: ALTER TABLE `fnnode` ADD `nsinterval` int(10) unsigned NOT NULL DEFAULT '15'; 257: ALTER TABLE `fnnode` CHANGE `nslastx` `nslastx` bigint(20) unsigned NOT NULL DEFAULT '0'; 258: ALTER TABLE `fnnode` ADD `nslastx` bigint(20) unsigned NOT NULL DEFAULT '0'; 259: ALTER TABLE `fnnode` CHANGE `nsnextx` `nsnextx` bigint(20) unsigned NOT NULL DEFAULT '0'; 260: ALTER TABLE `fnnode` ADD `nsnextx` bigint(20) unsigned NOT NULL DEFAULT '0'; 261: ALTER TABLE `fnnode` CHANGE `nspullalert` `nspullalert` tinyint(1) NOT NULL DEFAULT '0'; 262: ALTER TABLE `fnnode` ADD `nspullalert` tinyint(1) NOT NULL DEFAULT '0'; 263: ALTER TABLE `fnnode` CHANGE `nsfreshpush` `nsfreshpush` tinyint(1) NOT NULL DEFAULT '0'; 264: ALTER TABLE `fnnode` ADD `nsfreshpush` tinyint(1) NOT NULL DEFAULT '0'; 265: ALTER TABLE `fnnode` CHANGE `masterid` `masterid` varchar(64) NOT NULL; 266: ALTER TABLE `fnnode` ADD `masterid` varchar(64) NOT NULL; 267: CREATE INDEX `masterid` ON `fnnode` ( `masterid` ); 268: ALTER TABLE `fnnode` CHANGE `masterjustping` `masterjustping` tinyint(1) NOT NULL DEFAULT '1'; 269: ALTER TABLE `fnnode` ADD `masterjustping` tinyint(1) NOT NULL DEFAULT '1'; 270: ALTER TABLE `fnnode` CHANGE `ulink0` `ulink0` tinyint(1) NOT NULL DEFAULT '0'; 271: ALTER TABLE `fnnode` ADD `ulink0` tinyint(1) NOT NULL DEFAULT '0'; 272: ALTER TABLE `fnnode` CHANGE `ulink0_title` `ulink0_title` varchar(254) NOT NULL DEFAULT 'VNC'; 273: ALTER TABLE `fnnode` ADD `ulink0_title` varchar(254) NOT NULL DEFAULT 'VNC'; 274: ALTER TABLE `fnnode` CHANGE `ulink0_url` `ulink0_url` varchar(254) NOT NULL DEFAULT 'http://{HOSTNAME}:5800/'; 275: ALTER TABLE `fnnode` ADD `ulink0_url` varchar(254) NOT NULL DEFAULT 'http://{HOSTNAME}:5800/'; 276: ALTER TABLE `fnnode` CHANGE `ulink1` `ulink1` tinyint(1) NOT NULL DEFAULT '0'; 277: ALTER TABLE `fnnode` ADD `ulink1` tinyint(1) NOT NULL DEFAULT '0'; 278: ALTER TABLE `fnnode` CHANGE `ulink1_title` `ulink1_title` varchar(254) NOT NULL DEFAULT 'SSH'; 279: ALTER TABLE `fnnode` ADD `ulink1_title` varchar(254) NOT NULL DEFAULT 'SSH'; 280: ALTER TABLE `fnnode` CHANGE `ulink1_url` `ulink1_url` varchar(254) NOT NULL DEFAULT 'ssh://{HOSTNAME}'; 281: ALTER TABLE `fnnode` ADD `ulink1_url` varchar(254) NOT NULL DEFAULT 'ssh://{HOSTNAME}'; 282: ALTER TABLE `fnnode` CHANGE `ulink2` `ulink2` tinyint(1) NOT NULL DEFAULT '0'; 283: ALTER TABLE `fnnode` ADD `ulink2` tinyint(1) NOT NULL DEFAULT '0'; 284: ALTER TABLE `fnnode` CHANGE `ulink2_title` `ulink2_title` varchar(254) NOT NULL DEFAULT 'Web'; 285: ALTER TABLE `fnnode` ADD `ulink2_title` varchar(254) NOT NULL DEFAULT 'Web'; 286: ALTER TABLE `fnnode` CHANGE `ulink2_url` `ulink2_url` varchar(254) NOT NULL DEFAULT 'http://{HOSTNAME}'; 287: ALTER TABLE `fnnode` ADD `ulink2_url` varchar(254) NOT NULL DEFAULT 'http://{HOSTNAME}'; 288: -- 289: -- Table: fnnstest 290: -- DESCRIBE fnnstest 291: ALTER TABLE `fnnstest` CHANGE `nstestid` `nstestid` bigint(20) unsigned NOT NULL auto_increment; 292: ALTER TABLE `fnnstest` ADD `nstestid` bigint(20) unsigned NOT NULL auto_increment; 293: ALTER TABLE `fnnstest` ADD PRIMARY KEY( `nstestid` ); 294: ALTER TABLE `fnnstest` CHANGE `nodeid` `nodeid` varchar(64) NOT NULL; 295: ALTER TABLE `fnnstest` ADD `nodeid` varchar(64) NOT NULL; 296: CREATE INDEX `nodeid` ON `fnnstest` ( `nodeid` ); 297: ALTER TABLE `fnnstest` CHANGE `alertlevel` `alertlevel` int(11) NOT NULL DEFAULT '-1'; 298: ALTER TABLE `fnnstest` ADD `alertlevel` int(11) NOT NULL DEFAULT '-1'; 299: ALTER TABLE `fnnstest` CHANGE `lastrunx` `lastrunx` bigint(20) unsigned NOT NULL DEFAULT '0'; 300: ALTER TABLE `fnnstest` ADD `lastrunx` bigint(20) unsigned NOT NULL DEFAULT '0'; 301: ALTER TABLE `fnnstest` CHANGE `testtype` `testtype` varchar(128) NOT NULL; 302: ALTER TABLE `fnnstest` ADD `testtype` varchar(128) NOT NULL; 303: ALTER TABLE `fnnstest` CHANGE `testdesc` `testdesc` varchar(250); 304: ALTER TABLE `fnnstest` ADD `testdesc` varchar(250); 305: ALTER TABLE `fnnstest` CHANGE `testrecord` `testrecord` tinyint(1) NOT NULL DEFAULT '0'; 306: ALTER TABLE `fnnstest` ADD `testrecord` tinyint(1) NOT NULL DEFAULT '0'; 307: ALTER TABLE `fnnstest` CHANGE `simpleeval` `simpleeval` tinyint(1) NOT NULL DEFAULT '1'; 308: ALTER TABLE `fnnstest` ADD `simpleeval` tinyint(1) NOT NULL DEFAULT '1'; 309: ALTER TABLE `fnnstest` CHANGE `testname` `testname` varchar(64) NOT NULL; 310: ALTER TABLE `fnnstest` ADD `testname` varchar(64) NOT NULL; 311: ALTER TABLE `fnnstest` CHANGE `testenabled` `testenabled` tinyint(1) NOT NULL DEFAULT '0'; 312: ALTER TABLE `fnnstest` ADD `testenabled` tinyint(1) NOT NULL DEFAULT '0'; 313: ALTER TABLE `fnnstest` CHANGE `lastvalue` `lastvalue` varchar(128) NOT NULL; 314: ALTER TABLE `fnnstest` ADD `lastvalue` varchar(128) NOT NULL; 315: ALTER TABLE `fnnstest` CHANGE `testalerts` `testalerts` tinyint(1) NOT NULL DEFAULT '1'; 316: ALTER TABLE `fnnstest` ADD `testalerts` tinyint(1) NOT NULL DEFAULT '1'; 317: -- 318: -- Table: fnrecord 319: -- DESCRIBE fnrecord 320: ALTER TABLE `fnrecord` CHANGE `recordid` `recordid` bigint(20) unsigned NOT NULL auto_increment; 321: ALTER TABLE `fnrecord` ADD `recordid` bigint(20) unsigned NOT NULL auto_increment; 322: ALTER TABLE `fnrecord` ADD PRIMARY KEY( `recordid` ); 323: ALTER TABLE `fnrecord` CHANGE `testid` `testid` varchar(128) NOT NULL; 324: ALTER TABLE `fnrecord` ADD `testid` varchar(128) NOT NULL; 325: CREATE INDEX `testid` ON `fnrecord` ( `testid` ); 326: ALTER TABLE `fnrecord` CHANGE `alertlevel` `alertlevel` int(11) NOT NULL DEFAULT '0'; 327: ALTER TABLE `fnrecord` ADD `alertlevel` int(11) NOT NULL DEFAULT '0'; 328: ALTER TABLE `fnrecord` CHANGE `testvalue` `testvalue` float NOT NULL DEFAULT '0'; 329: ALTER TABLE `fnrecord` ADD `testvalue` float NOT NULL DEFAULT '0'; 330: ALTER TABLE `fnrecord` CHANGE `recordx` `recordx` bigint(20) unsigned NOT NULL DEFAULT '0'; 331: ALTER TABLE `fnrecord` ADD `recordx` bigint(20) unsigned NOT NULL DEFAULT '0'; 332: CREATE INDEX `recordx` ON `fnrecord` ( `recordx` ); 333: ALTER TABLE `fnrecord` CHANGE `nodeid` `nodeid` varchar(64) NOT NULL; 334: ALTER TABLE `fnrecord` ADD `nodeid` varchar(64) NOT NULL; 335: -- 336: -- Table: fnreport 337: -- DESCRIBE fnreport 338: ALTER TABLE `fnreport` CHANGE `reportid` `reportid` bigint(20) unsigned NOT NULL auto_increment; 339: ALTER TABLE `fnreport` ADD `reportid` bigint(20) unsigned NOT NULL auto_increment; 340: ALTER TABLE `fnreport` ADD PRIMARY KEY( `reportid` ); 341: ALTER TABLE `fnreport` CHANGE `reportname` `reportname` varchar(128) NOT NULL; 342: ALTER TABLE `fnreport` ADD `reportname` varchar(128) NOT NULL; 343: ALTER TABLE `fnreport` CHANGE `reporttests` `reporttests` text; 344: ALTER TABLE `fnreport` ADD `reporttests` text; 345: -- 346: -- Table: fnrssfeed 347: -- DESCRIBE fnrssfeed 348: ALTER TABLE `fnrssfeed` CHANGE `feedid` `feedid` bigint(20) unsigned NOT NULL auto_increment; 349: ALTER TABLE `fnrssfeed` ADD `feedid` bigint(20) unsigned NOT NULL auto_increment; 350: ALTER TABLE `fnrssfeed` ADD PRIMARY KEY( `feedid` ); 351: ALTER TABLE `fnrssfeed` CHANGE `feedkey` `feedkey` varchar(254) NOT NULL; 352: ALTER TABLE `fnrssfeed` ADD `feedkey` varchar(254) NOT NULL; 353: ALTER TABLE `fnrssfeed` CHANGE `feedname` `feedname` varchar(254) NOT NULL; 354: ALTER TABLE `fnrssfeed` ADD `feedname` varchar(254) NOT NULL; 355: ALTER TABLE `fnrssfeed` CHANGE `feedtype` `feedtype` varchar(254) NOT NULL; 356: ALTER TABLE `fnrssfeed` ADD `feedtype` varchar(254) NOT NULL; 357: ALTER TABLE `fnrssfeed` CHANGE `typeopt` `typeopt` varchar(254) NOT NULL; 358: ALTER TABLE `fnrssfeed` ADD `typeopt` varchar(254) NOT NULL; 359: ALTER TABLE `fnrssfeed` CHANGE `feedrange` `feedrange` varchar(32) NOT NULL; 360: ALTER TABLE `fnrssfeed` ADD `feedrange` varchar(32) NOT NULL; 361: ALTER TABLE `fnrssfeed` CHANGE `rangeopt` `rangeopt` varchar(254) NOT NULL; 362: ALTER TABLE `fnrssfeed` ADD `rangeopt` varchar(254) NOT NULL; 363: -- 364: -- Table: fnscheditem 365: -- DESCRIBE fnscheditem 366: ALTER TABLE `fnscheditem` CHANGE `scheditemid` `scheditemid` bigint(20) NOT NULL auto_increment; 367: ALTER TABLE `fnscheditem` ADD `scheditemid` bigint(20) NOT NULL auto_increment; 368: ALTER TABLE `fnscheditem` ADD PRIMARY KEY( `scheditemid` ); 369: ALTER TABLE `fnscheditem` CHANGE `scheduleid` `scheduleid` bigint(20) NOT NULL DEFAULT '0'; 370: ALTER TABLE `fnscheditem` ADD `scheduleid` bigint(20) NOT NULL DEFAULT '0'; 371: ALTER TABLE `fnscheditem` CHANGE `dayofweek` `dayofweek` varchar(8) NOT NULL; 372: ALTER TABLE `fnscheditem` ADD `dayofweek` varchar(8) NOT NULL; 373: ALTER TABLE `fnscheditem` CHANGE `dayofmonth` `dayofmonth` int(11) NOT NULL DEFAULT '0'; 374: ALTER TABLE `fnscheditem` ADD `dayofmonth` int(11) NOT NULL DEFAULT '0'; 375: ALTER TABLE `fnscheditem` CHANGE `monthofyear` `monthofyear` int(11) NOT NULL DEFAULT '0'; 376: ALTER TABLE `fnscheditem` ADD `monthofyear` int(11) NOT NULL DEFAULT '0'; 377: ALTER TABLE `fnscheditem` CHANGE `year` `year` int(11) NOT NULL DEFAULT '0'; 378: ALTER TABLE `fnscheditem` ADD `year` int(11) NOT NULL DEFAULT '0'; 379: ALTER TABLE `fnscheditem` CHANGE `starthour` `starthour` int(11) NOT NULL DEFAULT '0'; 380: ALTER TABLE `fnscheditem` ADD `starthour` int(11) NOT NULL DEFAULT '0'; 381: ALTER TABLE `fnscheditem` CHANGE `startmin` `startmin` int(11) NOT NULL DEFAULT '0'; 382: ALTER TABLE `fnscheditem` ADD `startmin` int(11) NOT NULL DEFAULT '0'; 383: ALTER TABLE `fnscheditem` CHANGE `finishhour` `finishhour` int(11) NOT NULL DEFAULT '23'; 384: ALTER TABLE `fnscheditem` ADD `finishhour` int(11) NOT NULL DEFAULT '23'; 385: ALTER TABLE `fnscheditem` CHANGE `finishmin` `finishmin` int(11) NOT NULL DEFAULT '59'; 386: ALTER TABLE `fnscheditem` ADD `finishmin` int(11) NOT NULL DEFAULT '59'; 387: -- 388: -- Table: fnschedule 389: -- DESCRIBE fnschedule 390: ALTER TABLE `fnschedule` CHANGE `scheduleid` `scheduleid` bigint(20) unsigned NOT NULL auto_increment; 391: ALTER TABLE `fnschedule` ADD `scheduleid` bigint(20) unsigned NOT NULL auto_increment; 392: ALTER TABLE `fnschedule` ADD PRIMARY KEY( `scheduleid` ); 393: ALTER TABLE `fnschedule` CHANGE `schedulename` `schedulename` varchar(128) NOT NULL; 394: ALTER TABLE `fnschedule` ADD `schedulename` varchar(128) NOT NULL; 395: ALTER TABLE `fnschedule` CHANGE `defaultaction` `defaultaction` tinyint(1) NOT NULL DEFAULT '1'; 396: ALTER TABLE `fnschedule` ADD `defaultaction` tinyint(1) NOT NULL DEFAULT '1'; 397: -- 398: -- Table: fnsession 399: -- DESCRIBE fnsession 400: ALTER TABLE `fnsession` CHANGE `sessionid` `sessionid` bigint(20) unsigned NOT NULL auto_increment; 401: ALTER TABLE `fnsession` ADD `sessionid` bigint(20) unsigned NOT NULL auto_increment; 402: ALTER TABLE `fnsession` ADD PRIMARY KEY( `sessionid` ); 403: ALTER TABLE `fnsession` CHANGE `sessionkey` `sessionkey` varchar(128) NOT NULL; 404: ALTER TABLE `fnsession` ADD `sessionkey` varchar(128) NOT NULL; 405: ALTER TABLE `fnsession` CHANGE `ipaddress` `ipaddress` varchar(128) NOT NULL; 406: ALTER TABLE `fnsession` ADD `ipaddress` varchar(128) NOT NULL; 407: ALTER TABLE `fnsession` CHANGE `username` `username` varchar(64) NOT NULL; 408: ALTER TABLE `fnsession` ADD `username` varchar(64) NOT NULL; 409: ALTER TABLE `fnsession` CHANGE `startx` `startx` bigint(20) unsigned NOT NULL DEFAULT '0'; 410: ALTER TABLE `fnsession` ADD `startx` bigint(20) unsigned NOT NULL DEFAULT '0'; 411: ALTER TABLE `fnsession` CHANGE `updatex` `updatex` bigint(20) unsigned NOT NULL DEFAULT '0'; 412: ALTER TABLE `fnsession` ADD `updatex` bigint(20) unsigned NOT NULL DEFAULT '0'; 413: ALTER TABLE `fnsession` CHANGE `userlevel` `userlevel` int(11) NOT NULL DEFAULT '0'; 414: ALTER TABLE `fnsession` ADD `userlevel` int(11) NOT NULL DEFAULT '0'; 415: -- 416: -- Table: fntestrun 417: -- DESCRIBE fntestrun 418: ALTER TABLE `fntestrun` CHANGE `trid` `trid` bigint(20) unsigned NOT NULL auto_increment; 419: ALTER TABLE `fntestrun` ADD `trid` bigint(20) unsigned NOT NULL auto_increment; 420: ALTER TABLE `fntestrun` ADD PRIMARY KEY( `trid` ); 421: ALTER TABLE `fntestrun` CHANGE `startx` `startx` bigint(20) unsigned NOT NULL DEFAULT '0'; 422: ALTER TABLE `fntestrun` ADD `startx` bigint(20) unsigned NOT NULL DEFAULT '0'; 423: ALTER TABLE `fntestrun` CHANGE `finishx` `finishx` bigint(20) unsigned NOT NULL DEFAULT '0'; 424: ALTER TABLE `fntestrun` ADD `finishx` bigint(20) unsigned NOT NULL DEFAULT '0'; 425: CREATE INDEX `finishx` ON `fntestrun` ( `finishx` ); 426: ALTER TABLE `fntestrun` CHANGE `routput` `routput` text; 427: ALTER TABLE `fntestrun` ADD `routput` text; 428: ALTER TABLE `fntestrun` CHANGE `fnode` `fnode` varchar(64) NOT NULL; 429: ALTER TABLE `fntestrun` ADD `fnode` varchar(64) NOT NULL; 430: CREATE INDEX `fnode` ON `fntestrun` ( `fnode` ); 431: -- 432: -- Table: fnuser 433: -- DESCRIBE fnuser 434: ALTER TABLE `fnuser` CHANGE `username` `username` varchar(64) NOT NULL; 435: ALTER TABLE `fnuser` ADD `username` varchar(64) NOT NULL; 436: ALTER TABLE `fnuser` ADD PRIMARY KEY( `username` ); 437: ALTER TABLE `fnuser` CHANGE `password` `password` varchar(64) NOT NULL; 438: ALTER TABLE `fnuser` ADD `password` varchar(64) NOT NULL; 439: ALTER TABLE `fnuser` CHANGE `realname` `realname` varchar(128) NOT NULL; 440: ALTER TABLE `fnuser` ADD `realname` varchar(128) NOT NULL; 441: ALTER TABLE `fnuser` CHANGE `userlevel` `userlevel` int(11) NOT NULL DEFAULT '1'; 442: ALTER TABLE `fnuser` ADD `userlevel` int(11) NOT NULL DEFAULT '1'; 443: ALTER TABLE `fnuser` CHANGE `grouplock` `grouplock` tinyint(4) NOT NULL DEFAULT '0'; 444: ALTER TABLE `fnuser` ADD `grouplock` tinyint(4) NOT NULL DEFAULT '0'; 445: -- 446: -- Table: fnview 447: -- DESCRIBE fnview 448: ALTER TABLE `fnview` CHANGE `viewid` `viewid` bigint(20) unsigned NOT NULL auto_increment; 449: ALTER TABLE `fnview` ADD `viewid` bigint(20) unsigned NOT NULL auto_increment; 450: ALTER TABLE `fnview` ADD PRIMARY KEY( `viewid` ); 451: ALTER TABLE `fnview` CHANGE `vtitle` `vtitle` varchar(128) NOT NULL; 452: ALTER TABLE `fnview` ADD `vtitle` varchar(128) NOT NULL; 453: ALTER TABLE `fnview` CHANGE `vstyle` `vstyle` varchar(32) NOT NULL; 454: ALTER TABLE `fnview` ADD `vstyle` varchar(32) NOT NULL; 455: ALTER TABLE `fnview` CHANGE `vpublic` `vpublic` tinyint(1) NOT NULL DEFAULT '0'; 456: ALTER TABLE `fnview` ADD `vpublic` tinyint(1) NOT NULL DEFAULT '0'; 457: ALTER TABLE `fnview` CHANGE `vclick` `vclick` varchar(32) NOT NULL; 458: ALTER TABLE `fnview` ADD `vclick` varchar(32) NOT NULL; 459: ALTER TABLE `fnview` CHANGE `vrefresh` `vrefresh` int(11) NOT NULL DEFAULT '0'; 460: ALTER TABLE `fnview` ADD `vrefresh` int(11) NOT NULL DEFAULT '0'; 461: ALTER TABLE `fnview` CHANGE `vlinkv` `vlinkv` bigint(20) unsigned NOT NULL DEFAULT '0'; 462: ALTER TABLE `fnview` ADD `vlinkv` bigint(20) unsigned NOT NULL DEFAULT '0'; 463: ALTER TABLE `fnview` CHANGE `vcolumns` `vcolumns` smallint(6) NOT NULL DEFAULT '0'; 464: ALTER TABLE `fnview` ADD `vcolumns` smallint(6) NOT NULL DEFAULT '0'; 465: ALTER TABLE `fnview` CHANGE `vcolon` `vcolon` tinyint(1) NOT NULL DEFAULT '1'; 466: ALTER TABLE `fnview` ADD `vcolon` tinyint(1) NOT NULL DEFAULT '1'; 467: ALTER TABLE `fnview` CHANGE `vdashes` `vdashes` tinyint(1) NOT NULL DEFAULT '1'; 468: ALTER TABLE `fnview` ADD `vdashes` tinyint(1) NOT NULL DEFAULT '1'; 469: ALTER TABLE `fnview` CHANGE `vtimeago` `vtimeago` tinyint(1) NOT NULL DEFAULT '1'; 470: ALTER TABLE `fnview` ADD `vtimeago` tinyint(1) NOT NULL DEFAULT '1'; 471: -- 472: -- Table: fnviewitem 473: -- DESCRIBE fnviewitem 474: ALTER TABLE `fnviewitem` CHANGE `viewitemid` `viewitemid` bigint(20) unsigned NOT NULL auto_increment; 475: ALTER TABLE `fnviewitem` ADD `viewitemid` bigint(20) unsigned NOT NULL auto_increment; 476: ALTER TABLE `fnviewitem` ADD PRIMARY KEY( `viewitemid` ); 477: ALTER TABLE `fnviewitem` CHANGE `viewid` `viewid` bigint(20) unsigned NOT NULL DEFAULT '0'; 478: ALTER TABLE `fnviewitem` ADD `viewid` bigint(20) unsigned NOT NULL DEFAULT '0'; 479: CREATE INDEX `viewid` ON `fnviewitem` ( `viewid` ); 480: ALTER TABLE `fnviewitem` CHANGE `itype` `itype` varchar(128) NOT NULL; 481: ALTER TABLE `fnviewitem` ADD `itype` varchar(128) NOT NULL; 482: ALTER TABLE `fnviewitem` CHANGE `ioption` `ioption` varchar(250) NOT NULL; 483: ALTER TABLE `fnviewitem` ADD `ioption` varchar(250) NOT NULL; 484: ALTER TABLE `fnviewitem` CHANGE `icolour` `icolour` tinyint(1) NOT NULL DEFAULT '1'; 485: ALTER TABLE `fnviewitem` ADD `icolour` tinyint(1) NOT NULL DEFAULT '1'; 486: ALTER TABLE `fnviewitem` CHANGE `itextstatus` `itextstatus` tinyint(1) NOT NULL DEFAULT '0'; 487: ALTER TABLE `fnviewitem` ADD `itextstatus` tinyint(1) NOT NULL DEFAULT '0'; 488: ALTER TABLE `fnviewitem` CHANGE `idetail` `idetail` smallint(5) unsigned NOT NULL DEFAULT '0'; 489: ALTER TABLE `fnviewitem` ADD `idetail` smallint(5) unsigned NOT NULL DEFAULT '0'; 490: ALTER TABLE `fnviewitem` CHANGE `iweight` `iweight` int(10) unsigned NOT NULL DEFAULT '0'; 491: ALTER TABLE `fnviewitem` ADD `iweight` int(10) unsigned NOT NULL DEFAULT '0'; 492: ALTER TABLE `fnviewitem` CHANGE `isize` `isize` smallint(6) NOT NULL DEFAULT '0'; 493: ALTER TABLE `fnviewitem` ADD `isize` smallint(6) NOT NULL DEFAULT '0'; 494: ALTER TABLE `fnviewitem` CHANGE `igraphic` `igraphic` smallint(6) NOT NULL DEFAULT '0'; 495: ALTER TABLE `fnviewitem` ADD `igraphic` smallint(6) NOT NULL DEFAULT '0'; 496: ALTER TABLE `fnviewitem` CHANGE `iname` `iname` varchar(64) NOT NULL; 497: ALTER TABLE `fnviewitem` ADD `iname` varchar(64) NOT NULL; 498: -- 499: