|
Viewing File server/base/sql/schema.upgrade.sql of 0.02.76a
|
1: -- Both will generate many many errors - run with --force, ignore errors 2: -- dbupg.sh -- PurplePixie Systems 3: -- 4: -- SHOW TABLES LIKE "fn%" 5: -- Table: fnalert 6: -- DESCRIBE fnalert 7: ALTER TABLE `fnalert` CHANGE `alertid` `alertid` bigint(20) unsigned NOT NULL auto_increment; 8: ALTER TABLE `fnalert` ADD `alertid` bigint(20) unsigned NOT NULL auto_increment; 9: ALTER TABLE `fnalert` ADD PRIMARY KEY( `alertid` ); 10: ALTER TABLE `fnalert` CHANGE `nodeid` `nodeid` varchar(64) NOT NULL; 11: ALTER TABLE `fnalert` ADD `nodeid` varchar(64) NOT NULL; 12: ALTER TABLE `fnalert` CHANGE `alertlevel` `alertlevel` int(11) NOT NULL DEFAULT '0'; 13: ALTER TABLE `fnalert` ADD `alertlevel` int(11) NOT NULL DEFAULT '0'; 14: ALTER TABLE `fnalert` CHANGE `openedx` `openedx` bigint(20) unsigned NOT NULL DEFAULT '0'; 15: ALTER TABLE `fnalert` ADD `openedx` bigint(20) unsigned NOT NULL DEFAULT '0'; 16: ALTER TABLE `fnalert` CHANGE `closedx` `closedx` bigint(20) unsigned NOT NULL DEFAULT '0'; 17: ALTER TABLE `fnalert` ADD `closedx` bigint(20) unsigned NOT NULL DEFAULT '0'; 18: -- 19: -- Table: fnalertaction 20: -- DESCRIBE fnalertaction 21: ALTER TABLE `fnalertaction` CHANGE `aaid` `aaid` bigint(20) unsigned NOT NULL auto_increment; 22: ALTER TABLE `fnalertaction` ADD `aaid` bigint(20) unsigned NOT NULL auto_increment; 23: ALTER TABLE `fnalertaction` ADD PRIMARY KEY( `aaid` ); 24: ALTER TABLE `fnalertaction` CHANGE `atype` `atype` varchar(32) NOT NULL; 25: ALTER TABLE `fnalertaction` ADD `atype` varchar(32) NOT NULL; 26: ALTER TABLE `fnalertaction` CHANGE `efrom` `efrom` varchar(250) NOT NULL; 27: ALTER TABLE `fnalertaction` ADD `efrom` varchar(250) NOT NULL; 28: ALTER TABLE `fnalertaction` CHANGE `etolist` `etolist` text NOT NULL; 29: ALTER TABLE `fnalertaction` ADD `etolist` text NOT NULL; 30: ALTER TABLE `fnalertaction` CHANGE `esubject` `esubject` int(11) NOT NULL DEFAULT '0'; 31: ALTER TABLE `fnalertaction` ADD `esubject` int(11) NOT NULL DEFAULT '0'; 32: ALTER TABLE `fnalertaction` CHANGE `etype` `etype` int(11) NOT NULL DEFAULT '0'; 33: ALTER TABLE `fnalertaction` ADD `etype` int(11) NOT NULL DEFAULT '0'; 34: ALTER TABLE `fnalertaction` CHANGE `awarnings` `awarnings` tinyint(1) NOT NULL DEFAULT '0'; 35: ALTER TABLE `fnalertaction` ADD `awarnings` tinyint(1) NOT NULL DEFAULT '0'; 36: ALTER TABLE `fnalertaction` CHANGE `adecrease` `adecrease` tinyint(1) NOT NULL DEFAULT '0'; 37: ALTER TABLE `fnalertaction` ADD `adecrease` tinyint(1) NOT NULL DEFAULT '0'; 38: ALTER TABLE `fnalertaction` CHANGE `mdata` `mdata` text NOT NULL; 39: ALTER TABLE `fnalertaction` ADD `mdata` text NOT NULL; 40: ALTER TABLE `fnalertaction` CHANGE `aname` `aname` varchar(120) NOT NULL; 41: ALTER TABLE `fnalertaction` ADD `aname` varchar(120) NOT NULL; 42: ALTER TABLE `fnalertaction` CHANGE `ctrdate` `ctrdate` varchar(8) NOT NULL; 43: ALTER TABLE `fnalertaction` ADD `ctrdate` varchar(8) NOT NULL; 44: ALTER TABLE `fnalertaction` CHANGE `ctrlimit` `ctrlimit` int(10) unsigned NOT NULL DEFAULT '0'; 45: ALTER TABLE `fnalertaction` ADD `ctrlimit` int(10) unsigned NOT NULL DEFAULT '0'; 46: ALTER TABLE `fnalertaction` CHANGE `ctrtoday` `ctrtoday` int(10) unsigned NOT NULL DEFAULT '0'; 47: ALTER TABLE `fnalertaction` ADD `ctrtoday` int(10) unsigned NOT NULL DEFAULT '0'; 48: -- 49: -- Table: fnalertlog 50: -- DESCRIBE fnalertlog 51: ALTER TABLE `fnalertlog` CHANGE `alid` `alid` bigint(20) unsigned NOT NULL auto_increment; 52: ALTER TABLE `fnalertlog` ADD `alid` bigint(20) unsigned NOT NULL auto_increment; 53: ALTER TABLE `fnalertlog` ADD PRIMARY KEY( `alid` ); 54: ALTER TABLE `fnalertlog` CHANGE `alertid` `alertid` bigint(20) unsigned NOT NULL DEFAULT '0'; 55: ALTER TABLE `fnalertlog` ADD `alertid` bigint(20) unsigned NOT NULL DEFAULT '0'; 56: ALTER TABLE `fnalertlog` CHANGE `postedx` `postedx` bigint(20) unsigned NOT NULL DEFAULT '0'; 57: ALTER TABLE `fnalertlog` ADD `postedx` bigint(20) unsigned NOT NULL DEFAULT '0'; 58: ALTER TABLE `fnalertlog` CHANGE `logentry` `logentry` varchar(250) NOT NULL; 59: ALTER TABLE `fnalertlog` ADD `logentry` varchar(250) NOT NULL; 60: -- 61: -- Table: fnconfig 62: -- DESCRIBE fnconfig 63: ALTER TABLE `fnconfig` CHANGE `fnc_var` `fnc_var` varchar(64) NOT NULL; 64: ALTER TABLE `fnconfig` ADD `fnc_var` varchar(64) NOT NULL; 65: ALTER TABLE `fnconfig` ADD PRIMARY KEY( `fnc_var` ); 66: ALTER TABLE `fnconfig` CHANGE `fnc_val` `fnc_val` varchar(64) NOT NULL; 67: ALTER TABLE `fnconfig` ADD `fnc_val` varchar(64) NOT NULL; 68: -- 69: -- Table: fneval 70: -- DESCRIBE fneval 71: ALTER TABLE `fneval` CHANGE `evalid` `evalid` bigint(20) unsigned NOT NULL auto_increment; 72: ALTER TABLE `fneval` ADD `evalid` bigint(20) unsigned NOT NULL auto_increment; 73: ALTER TABLE `fneval` ADD PRIMARY KEY( `evalid` ); 74: ALTER TABLE `fneval` CHANGE `testid` `testid` varchar(128) NOT NULL; 75: ALTER TABLE `fneval` ADD `testid` varchar(128) NOT NULL; 76: ALTER TABLE `fneval` CHANGE `weight` `weight` int(11) NOT NULL DEFAULT '0'; 77: ALTER TABLE `fneval` ADD `weight` int(11) NOT NULL DEFAULT '0'; 78: ALTER TABLE `fneval` CHANGE `eoperator` `eoperator` varchar(32) NOT NULL; 79: ALTER TABLE `fneval` ADD `eoperator` varchar(32) NOT NULL; 80: ALTER TABLE `fneval` CHANGE `evalue` `evalue` varchar(128) NOT NULL; 81: ALTER TABLE `fneval` ADD `evalue` varchar(128) NOT NULL; 82: ALTER TABLE `fneval` CHANGE `eoutcome` `eoutcome` int(11) NOT NULL DEFAULT '0'; 83: ALTER TABLE `fneval` ADD `eoutcome` int(11) NOT NULL DEFAULT '0'; 84: -- 85: -- Table: fngroup 86: -- DESCRIBE fngroup 87: ALTER TABLE `fngroup` CHANGE `groupid` `groupid` bigint(20) unsigned NOT NULL auto_increment; 88: ALTER TABLE `fngroup` ADD `groupid` bigint(20) unsigned NOT NULL auto_increment; 89: ALTER TABLE `fngroup` ADD PRIMARY KEY( `groupid` ); 90: ALTER TABLE `fngroup` CHANGE `groupname` `groupname` varchar(128) NOT NULL; 91: ALTER TABLE `fngroup` ADD `groupname` varchar(128) NOT NULL; 92: ALTER TABLE `fngroup` CHANGE `groupdesc` `groupdesc` varchar(250) NOT NULL; 93: ALTER TABLE `fngroup` ADD `groupdesc` varchar(250) NOT NULL; 94: ALTER TABLE `fngroup` CHANGE `groupicon` `groupicon` varchar(64) NOT NULL; 95: ALTER TABLE `fngroup` ADD `groupicon` varchar(64) NOT NULL; 96: ALTER TABLE `fngroup` CHANGE `weight` `weight` int(10) unsigned NOT NULL DEFAULT '0'; 97: ALTER TABLE `fngroup` ADD `weight` int(10) unsigned NOT NULL DEFAULT '0'; 98: -- 99: -- Table: fngrouplink 100: -- DESCRIBE fngrouplink 101: ALTER TABLE `fngrouplink` CHANGE `glid` `glid` bigint(20) unsigned NOT NULL auto_increment; 102: ALTER TABLE `fngrouplink` ADD `glid` bigint(20) unsigned NOT NULL auto_increment; 103: ALTER TABLE `fngrouplink` ADD PRIMARY KEY( `glid` ); 104: ALTER TABLE `fngrouplink` CHANGE `groupid` `groupid` bigint(20) unsigned NOT NULL DEFAULT '0'; 105: ALTER TABLE `fngrouplink` ADD `groupid` bigint(20) unsigned NOT NULL DEFAULT '0'; 106: ALTER TABLE `fngrouplink` CHANGE `nodeid` `nodeid` varchar(64) NOT NULL; 107: ALTER TABLE `fngrouplink` ADD `nodeid` varchar(64) NOT NULL; 108: -- 109: -- Table: fnlocaltest 110: -- DESCRIBE fnlocaltest 111: ALTER TABLE `fnlocaltest` CHANGE `localtestid` `localtestid` bigint(20) unsigned NOT NULL auto_increment; 112: ALTER TABLE `fnlocaltest` ADD `localtestid` bigint(20) unsigned NOT NULL auto_increment; 113: ALTER TABLE `fnlocaltest` ADD PRIMARY KEY( `localtestid` ); 114: ALTER TABLE `fnlocaltest` CHANGE `nodeid` `nodeid` varchar(64) NOT NULL; 115: ALTER TABLE `fnlocaltest` ADD `nodeid` varchar(64) NOT NULL; 116: CREATE INDEX `nodeid` ON `fnlocaltest` ( `nodeid` ); 117: ALTER TABLE `fnlocaltest` CHANGE `alertlevel` `alertlevel` int(11) NOT NULL DEFAULT '-1'; 118: ALTER TABLE `fnlocaltest` ADD `alertlevel` int(11) NOT NULL DEFAULT '-1'; 119: ALTER TABLE `fnlocaltest` CHANGE `lastrunx` `lastrunx` bigint(20) unsigned NOT NULL DEFAULT '0'; 120: ALTER TABLE `fnlocaltest` ADD `lastrunx` bigint(20) unsigned NOT NULL DEFAULT '0'; 121: ALTER TABLE `fnlocaltest` CHANGE `testtype` `testtype` varchar(128) NOT NULL; 122: ALTER TABLE `fnlocaltest` ADD `testtype` varchar(128) NOT NULL; 123: ALTER TABLE `fnlocaltest` CHANGE `testparam` `testparam` varchar(250); 124: ALTER TABLE `fnlocaltest` ADD `testparam` varchar(250); 125: ALTER TABLE `fnlocaltest` CHANGE `testrecord` `testrecord` tinyint(1) NOT NULL DEFAULT '0'; 126: ALTER TABLE `fnlocaltest` ADD `testrecord` tinyint(1) NOT NULL DEFAULT '0'; 127: ALTER TABLE `fnlocaltest` CHANGE `simpleeval` `simpleeval` tinyint(1) NOT NULL DEFAULT '1'; 128: ALTER TABLE `fnlocaltest` ADD `simpleeval` tinyint(1) NOT NULL DEFAULT '1'; 129: ALTER TABLE `fnlocaltest` CHANGE `testname` `testname` varchar(64) NOT NULL; 130: ALTER TABLE `fnlocaltest` ADD `testname` varchar(64) NOT NULL; 131: ALTER TABLE `fnlocaltest` CHANGE `attempts` `attempts` int(11) NOT NULL DEFAULT '0'; 132: ALTER TABLE `fnlocaltest` ADD `attempts` int(11) NOT NULL DEFAULT '0'; 133: ALTER TABLE `fnlocaltest` CHANGE `timeout` `timeout` int(11) NOT NULL DEFAULT '0'; 134: ALTER TABLE `fnlocaltest` ADD `timeout` int(11) NOT NULL DEFAULT '0'; 135: -- 136: -- Table: fnlog 137: -- DESCRIBE fnlog 138: ALTER TABLE `fnlog` CHANGE `logid` `logid` bigint(20) unsigned NOT NULL auto_increment; 139: ALTER TABLE `fnlog` ADD `logid` bigint(20) unsigned NOT NULL auto_increment; 140: ALTER TABLE `fnlog` ADD PRIMARY KEY( `logid` ); 141: ALTER TABLE `fnlog` CHANGE `postedx` `postedx` bigint(20) unsigned NOT NULL DEFAULT '0'; 142: ALTER TABLE `fnlog` ADD `postedx` bigint(20) unsigned NOT NULL DEFAULT '0'; 143: ALTER TABLE `fnlog` CHANGE `modid` `modid` varchar(32) NOT NULL; 144: ALTER TABLE `fnlog` ADD `modid` varchar(32) NOT NULL; 145: ALTER TABLE `fnlog` CHANGE `catid` `catid` varchar(32) NOT NULL; 146: ALTER TABLE `fnlog` ADD `catid` varchar(32) NOT NULL; 147: ALTER TABLE `fnlog` CHANGE `username` `username` varchar(64) NOT NULL; 148: ALTER TABLE `fnlog` ADD `username` varchar(64) NOT NULL; 149: ALTER TABLE `fnlog` CHANGE `loglevel` `loglevel` int(11) NOT NULL DEFAULT '1'; 150: ALTER TABLE `fnlog` ADD `loglevel` int(11) NOT NULL DEFAULT '1'; 151: ALTER TABLE `fnlog` CHANGE `logevent` `logevent` varchar(250) NOT NULL; 152: ALTER TABLE `fnlog` ADD `logevent` varchar(250) NOT NULL; 153: -- 154: -- Table: fnnalink 155: -- DESCRIBE fnnalink 156: ALTER TABLE `fnnalink` CHANGE `nalid` `nalid` bigint(20) unsigned NOT NULL auto_increment; 157: ALTER TABLE `fnnalink` ADD `nalid` bigint(20) unsigned NOT NULL auto_increment; 158: ALTER TABLE `fnnalink` ADD PRIMARY KEY( `nalid` ); 159: ALTER TABLE `fnnalink` CHANGE `nodeid` `nodeid` varchar(64) NOT NULL; 160: ALTER TABLE `fnnalink` ADD `nodeid` varchar(64) NOT NULL; 161: ALTER TABLE `fnnalink` CHANGE `aaid` `aaid` bigint(20) unsigned NOT NULL DEFAULT '0'; 162: ALTER TABLE `fnnalink` ADD `aaid` bigint(20) unsigned NOT NULL DEFAULT '0'; 163: -- 164: -- Table: fnnode 165: -- DESCRIBE fnnode 166: ALTER TABLE `fnnode` CHANGE `nodeid` `nodeid` varchar(64) NOT NULL; 167: ALTER TABLE `fnnode` ADD `nodeid` varchar(64) NOT NULL; 168: ALTER TABLE `fnnode` ADD PRIMARY KEY( `nodeid` ); 169: ALTER TABLE `fnnode` CHANGE `nodename` `nodename` varchar(128) NOT NULL; 170: ALTER TABLE `fnnode` ADD `nodename` varchar(128) NOT NULL; 171: ALTER TABLE `fnnode` CHANGE `nodedesc` `nodedesc` varchar(254) NOT NULL; 172: ALTER TABLE `fnnode` ADD `nodedesc` varchar(254) NOT NULL; 173: ALTER TABLE `fnnode` CHANGE `hostname` `hostname` varchar(254) NOT NULL; 174: ALTER TABLE `fnnode` ADD `hostname` varchar(254) NOT NULL; 175: ALTER TABLE `fnnode` CHANGE `nodeenabled` `nodeenabled` tinyint(1) NOT NULL DEFAULT '0'; 176: ALTER TABLE `fnnode` ADD `nodeenabled` tinyint(1) NOT NULL DEFAULT '0'; 177: ALTER TABLE `fnnode` CHANGE `pingtest` `pingtest` tinyint(1) NOT NULL DEFAULT '0'; 178: ALTER TABLE `fnnode` ADD `pingtest` tinyint(1) NOT NULL DEFAULT '0'; 179: ALTER TABLE `fnnode` CHANGE `pingfatal` `pingfatal` tinyint(1) NOT NULL DEFAULT '0'; 180: ALTER TABLE `fnnode` ADD `pingfatal` tinyint(1) NOT NULL DEFAULT '0'; 181: ALTER TABLE `fnnode` CHANGE `alertlevel` `alertlevel` int(11) NOT NULL DEFAULT '-1'; 182: ALTER TABLE `fnnode` ADD `alertlevel` int(11) NOT NULL DEFAULT '-1'; 183: ALTER TABLE `fnnode` CHANGE `nodeicon` `nodeicon` varchar(64) NOT NULL; 184: ALTER TABLE `fnnode` ADD `nodeicon` varchar(64) NOT NULL; 185: ALTER TABLE `fnnode` CHANGE `weight` `weight` int(10) unsigned NOT NULL DEFAULT '0'; 186: ALTER TABLE `fnnode` ADD `weight` int(10) unsigned NOT NULL DEFAULT '0'; 187: ALTER TABLE `fnnode` CHANGE `nodealert` `nodealert` tinyint(1) NOT NULL DEFAULT '1'; 188: ALTER TABLE `fnnode` ADD `nodealert` tinyint(1) NOT NULL DEFAULT '1'; 189: ALTER TABLE `fnnode` CHANGE `scheduleid` `scheduleid` bigint(20) unsigned NOT NULL DEFAULT '0'; 190: ALTER TABLE `fnnode` ADD `scheduleid` bigint(20) unsigned NOT NULL DEFAULT '0'; 191: -- 192: -- Table: fnrecord 193: -- DESCRIBE fnrecord 194: ALTER TABLE `fnrecord` CHANGE `recordid` `recordid` bigint(20) unsigned NOT NULL auto_increment; 195: ALTER TABLE `fnrecord` ADD `recordid` bigint(20) unsigned NOT NULL auto_increment; 196: ALTER TABLE `fnrecord` ADD PRIMARY KEY( `recordid` ); 197: ALTER TABLE `fnrecord` CHANGE `testid` `testid` varchar(128) NOT NULL; 198: ALTER TABLE `fnrecord` ADD `testid` varchar(128) NOT NULL; 199: CREATE INDEX `testid` ON `fnrecord` ( `testid` ); 200: ALTER TABLE `fnrecord` CHANGE `alertlevel` `alertlevel` int(11) NOT NULL DEFAULT '0'; 201: ALTER TABLE `fnrecord` ADD `alertlevel` int(11) NOT NULL DEFAULT '0'; 202: ALTER TABLE `fnrecord` CHANGE `testvalue` `testvalue` float NOT NULL DEFAULT '0'; 203: ALTER TABLE `fnrecord` ADD `testvalue` float NOT NULL DEFAULT '0'; 204: ALTER TABLE `fnrecord` CHANGE `recordx` `recordx` bigint(20) unsigned NOT NULL DEFAULT '0'; 205: ALTER TABLE `fnrecord` ADD `recordx` bigint(20) unsigned NOT NULL DEFAULT '0'; 206: CREATE INDEX `recordx` ON `fnrecord` ( `recordx` ); 207: ALTER TABLE `fnrecord` CHANGE `nodeid` `nodeid` varchar(64) NOT NULL; 208: ALTER TABLE `fnrecord` ADD `nodeid` varchar(64) NOT NULL; 209: -- 210: -- Table: fnscheditem 211: -- DESCRIBE fnscheditem 212: ALTER TABLE `fnscheditem` CHANGE `scheditemid` `scheditemid` bigint(20) NOT NULL auto_increment; 213: ALTER TABLE `fnscheditem` ADD `scheditemid` bigint(20) NOT NULL auto_increment; 214: ALTER TABLE `fnscheditem` ADD PRIMARY KEY( `scheditemid` ); 215: ALTER TABLE `fnscheditem` CHANGE `scheduleid` `scheduleid` bigint(20) NOT NULL DEFAULT '0'; 216: ALTER TABLE `fnscheditem` ADD `scheduleid` bigint(20) NOT NULL DEFAULT '0'; 217: ALTER TABLE `fnscheditem` CHANGE `dayofweek` `dayofweek` varchar(8) NOT NULL; 218: ALTER TABLE `fnscheditem` ADD `dayofweek` varchar(8) NOT NULL; 219: ALTER TABLE `fnscheditem` CHANGE `dayofmonth` `dayofmonth` int(11) NOT NULL DEFAULT '0'; 220: ALTER TABLE `fnscheditem` ADD `dayofmonth` int(11) NOT NULL DEFAULT '0'; 221: ALTER TABLE `fnscheditem` CHANGE `monthofyear` `monthofyear` int(11) NOT NULL DEFAULT '0'; 222: ALTER TABLE `fnscheditem` ADD `monthofyear` int(11) NOT NULL DEFAULT '0'; 223: ALTER TABLE `fnscheditem` CHANGE `year` `year` int(11) NOT NULL DEFAULT '0'; 224: ALTER TABLE `fnscheditem` ADD `year` int(11) NOT NULL DEFAULT '0'; 225: ALTER TABLE `fnscheditem` CHANGE `starthour` `starthour` int(11) NOT NULL DEFAULT '0'; 226: ALTER TABLE `fnscheditem` ADD `starthour` int(11) NOT NULL DEFAULT '0'; 227: ALTER TABLE `fnscheditem` CHANGE `startmin` `startmin` int(11) NOT NULL DEFAULT '0'; 228: ALTER TABLE `fnscheditem` ADD `startmin` int(11) NOT NULL DEFAULT '0'; 229: ALTER TABLE `fnscheditem` CHANGE `finishhour` `finishhour` int(11) NOT NULL DEFAULT '23'; 230: ALTER TABLE `fnscheditem` ADD `finishhour` int(11) NOT NULL DEFAULT '23'; 231: ALTER TABLE `fnscheditem` CHANGE `finishmin` `finishmin` int(11) NOT NULL DEFAULT '59'; 232: ALTER TABLE `fnscheditem` ADD `finishmin` int(11) NOT NULL DEFAULT '59'; 233: -- 234: -- Table: fnschedule 235: -- DESCRIBE fnschedule 236: ALTER TABLE `fnschedule` CHANGE `scheduleid` `scheduleid` bigint(20) unsigned NOT NULL auto_increment; 237: ALTER TABLE `fnschedule` ADD `scheduleid` bigint(20) unsigned NOT NULL auto_increment; 238: ALTER TABLE `fnschedule` ADD PRIMARY KEY( `scheduleid` ); 239: ALTER TABLE `fnschedule` CHANGE `schedulename` `schedulename` varchar(128) NOT NULL; 240: ALTER TABLE `fnschedule` ADD `schedulename` varchar(128) NOT NULL; 241: ALTER TABLE `fnschedule` CHANGE `defaultaction` `defaultaction` tinyint(1) NOT NULL DEFAULT '1'; 242: ALTER TABLE `fnschedule` ADD `defaultaction` tinyint(1) NOT NULL DEFAULT '1'; 243: -- 244: -- Table: fnsession 245: -- DESCRIBE fnsession 246: ALTER TABLE `fnsession` CHANGE `sessionid` `sessionid` bigint(20) unsigned NOT NULL auto_increment; 247: ALTER TABLE `fnsession` ADD `sessionid` bigint(20) unsigned NOT NULL auto_increment; 248: ALTER TABLE `fnsession` ADD PRIMARY KEY( `sessionid` ); 249: ALTER TABLE `fnsession` CHANGE `sessionkey` `sessionkey` varchar(128) NOT NULL; 250: ALTER TABLE `fnsession` ADD `sessionkey` varchar(128) NOT NULL; 251: ALTER TABLE `fnsession` CHANGE `ipaddress` `ipaddress` varchar(128) NOT NULL; 252: ALTER TABLE `fnsession` ADD `ipaddress` varchar(128) NOT NULL; 253: ALTER TABLE `fnsession` CHANGE `username` `username` varchar(64) NOT NULL; 254: ALTER TABLE `fnsession` ADD `username` varchar(64) NOT NULL; 255: ALTER TABLE `fnsession` CHANGE `startx` `startx` bigint(20) unsigned NOT NULL DEFAULT '0'; 256: ALTER TABLE `fnsession` ADD `startx` bigint(20) unsigned NOT NULL DEFAULT '0'; 257: ALTER TABLE `fnsession` CHANGE `updatex` `updatex` bigint(20) unsigned NOT NULL DEFAULT '0'; 258: ALTER TABLE `fnsession` ADD `updatex` bigint(20) unsigned NOT NULL DEFAULT '0'; 259: ALTER TABLE `fnsession` CHANGE `userlevel` `userlevel` int(11) NOT NULL DEFAULT '0'; 260: ALTER TABLE `fnsession` ADD `userlevel` int(11) NOT NULL DEFAULT '0'; 261: -- 262: -- Table: fntestrun 263: -- DESCRIBE fntestrun 264: ALTER TABLE `fntestrun` CHANGE `trid` `trid` bigint(20) unsigned NOT NULL auto_increment; 265: ALTER TABLE `fntestrun` ADD `trid` bigint(20) unsigned NOT NULL auto_increment; 266: ALTER TABLE `fntestrun` ADD PRIMARY KEY( `trid` ); 267: ALTER TABLE `fntestrun` CHANGE `startx` `startx` bigint(20) unsigned NOT NULL DEFAULT '0'; 268: ALTER TABLE `fntestrun` ADD `startx` bigint(20) unsigned NOT NULL DEFAULT '0'; 269: ALTER TABLE `fntestrun` CHANGE `finishx` `finishx` bigint(20) unsigned NOT NULL DEFAULT '0'; 270: ALTER TABLE `fntestrun` ADD `finishx` bigint(20) unsigned NOT NULL DEFAULT '0'; 271: ALTER TABLE `fntestrun` CHANGE `routput` `routput` text NOT NULL; 272: ALTER TABLE `fntestrun` ADD `routput` text NOT NULL; 273: ALTER TABLE `fntestrun` CHANGE `fnode` `fnode` varchar(64) NOT NULL; 274: ALTER TABLE `fntestrun` ADD `fnode` varchar(64) NOT NULL; 275: CREATE INDEX `fnode` ON `fntestrun` ( `fnode` ); 276: -- 277: -- Table: fnuser 278: -- DESCRIBE fnuser 279: ALTER TABLE `fnuser` CHANGE `username` `username` varchar(64) NOT NULL; 280: ALTER TABLE `fnuser` ADD `username` varchar(64) NOT NULL; 281: ALTER TABLE `fnuser` ADD PRIMARY KEY( `username` ); 282: ALTER TABLE `fnuser` CHANGE `password` `password` varchar(64) NOT NULL; 283: ALTER TABLE `fnuser` ADD `password` varchar(64) NOT NULL; 284: ALTER TABLE `fnuser` CHANGE `realname` `realname` varchar(128) NOT NULL; 285: ALTER TABLE `fnuser` ADD `realname` varchar(128) NOT NULL; 286: ALTER TABLE `fnuser` CHANGE `userlevel` `userlevel` int(11) NOT NULL DEFAULT '1'; 287: ALTER TABLE `fnuser` ADD `userlevel` int(11) NOT NULL DEFAULT '1'; 288: -- 289: -- Table: fnview 290: -- DESCRIBE fnview 291: ALTER TABLE `fnview` CHANGE `viewid` `viewid` bigint(20) unsigned NOT NULL auto_increment; 292: ALTER TABLE `fnview` ADD `viewid` bigint(20) unsigned NOT NULL auto_increment; 293: ALTER TABLE `fnview` ADD PRIMARY KEY( `viewid` ); 294: ALTER TABLE `fnview` CHANGE `vtitle` `vtitle` varchar(128) NOT NULL; 295: ALTER TABLE `fnview` ADD `vtitle` varchar(128) NOT NULL; 296: ALTER TABLE `fnview` CHANGE `vstyle` `vstyle` varchar(32) NOT NULL; 297: ALTER TABLE `fnview` ADD `vstyle` varchar(32) NOT NULL; 298: ALTER TABLE `fnview` CHANGE `vpublic` `vpublic` tinyint(1) NOT NULL DEFAULT '0'; 299: ALTER TABLE `fnview` ADD `vpublic` tinyint(1) NOT NULL DEFAULT '0'; 300: ALTER TABLE `fnview` CHANGE `vclick` `vclick` varchar(32) NOT NULL; 301: ALTER TABLE `fnview` ADD `vclick` varchar(32) NOT NULL; 302: ALTER TABLE `fnview` CHANGE `vrefresh` `vrefresh` int(11) NOT NULL DEFAULT '0'; 303: ALTER TABLE `fnview` ADD `vrefresh` int(11) NOT NULL DEFAULT '0'; 304: ALTER TABLE `fnview` CHANGE `vlinkv` `vlinkv` bigint(20) unsigned NOT NULL DEFAULT '0'; 305: ALTER TABLE `fnview` ADD `vlinkv` bigint(20) unsigned NOT NULL DEFAULT '0'; 306: ALTER TABLE `fnview` CHANGE `vcolumns` `vcolumns` smallint(6) NOT NULL DEFAULT '0'; 307: ALTER TABLE `fnview` ADD `vcolumns` smallint(6) NOT NULL DEFAULT '0'; 308: ALTER TABLE `fnview` CHANGE `vcolon` `vcolon` tinyint(1) NOT NULL DEFAULT '1'; 309: ALTER TABLE `fnview` ADD `vcolon` tinyint(1) NOT NULL DEFAULT '1'; 310: ALTER TABLE `fnview` CHANGE `vdashes` `vdashes` tinyint(1) NOT NULL DEFAULT '1'; 311: ALTER TABLE `fnview` ADD `vdashes` tinyint(1) NOT NULL DEFAULT '1'; 312: ALTER TABLE `fnview` CHANGE `vtimeago` `vtimeago` tinyint(1) NOT NULL DEFAULT '1'; 313: ALTER TABLE `fnview` ADD `vtimeago` tinyint(1) NOT NULL DEFAULT '1'; 314: -- 315: -- Table: fnviewitem 316: -- DESCRIBE fnviewitem 317: ALTER TABLE `fnviewitem` CHANGE `viewitemid` `viewitemid` bigint(20) unsigned NOT NULL auto_increment; 318: ALTER TABLE `fnviewitem` ADD `viewitemid` bigint(20) unsigned NOT NULL auto_increment; 319: ALTER TABLE `fnviewitem` ADD PRIMARY KEY( `viewitemid` ); 320: ALTER TABLE `fnviewitem` CHANGE `viewid` `viewid` bigint(20) unsigned NOT NULL DEFAULT '0'; 321: ALTER TABLE `fnviewitem` ADD `viewid` bigint(20) unsigned NOT NULL DEFAULT '0'; 322: CREATE INDEX `viewid` ON `fnviewitem` ( `viewid` ); 323: ALTER TABLE `fnviewitem` CHANGE `itype` `itype` varchar(128) NOT NULL; 324: ALTER TABLE `fnviewitem` ADD `itype` varchar(128) NOT NULL; 325: ALTER TABLE `fnviewitem` CHANGE `ioption` `ioption` varchar(250) NOT NULL; 326: ALTER TABLE `fnviewitem` ADD `ioption` varchar(250) NOT NULL; 327: ALTER TABLE `fnviewitem` CHANGE `icolour` `icolour` tinyint(1) NOT NULL DEFAULT '1'; 328: ALTER TABLE `fnviewitem` ADD `icolour` tinyint(1) NOT NULL DEFAULT '1'; 329: ALTER TABLE `fnviewitem` CHANGE `itextstatus` `itextstatus` tinyint(1) NOT NULL DEFAULT '0'; 330: ALTER TABLE `fnviewitem` ADD `itextstatus` tinyint(1) NOT NULL DEFAULT '0'; 331: ALTER TABLE `fnviewitem` CHANGE `idetail` `idetail` smallint(5) unsigned NOT NULL DEFAULT '0'; 332: ALTER TABLE `fnviewitem` ADD `idetail` smallint(5) unsigned NOT NULL DEFAULT '0'; 333: ALTER TABLE `fnviewitem` CHANGE `iweight` `iweight` int(10) unsigned NOT NULL DEFAULT '0'; 334: ALTER TABLE `fnviewitem` ADD `iweight` int(10) unsigned NOT NULL DEFAULT '0'; 335: ALTER TABLE `fnviewitem` CHANGE `isize` `isize` smallint(6) NOT NULL DEFAULT '0'; 336: ALTER TABLE `fnviewitem` ADD `isize` smallint(6) NOT NULL DEFAULT '0'; 337: ALTER TABLE `fnviewitem` CHANGE `igraphic` `igraphic` smallint(6) NOT NULL DEFAULT '0'; 338: ALTER TABLE `fnviewitem` ADD `igraphic` smallint(6) NOT NULL DEFAULT '0'; 339: ALTER TABLE `fnviewitem` CHANGE `iname` `iname` varchar(64) NOT NULL; 340: ALTER TABLE `fnviewitem` ADD `iname` varchar(64) NOT NULL; 341: -- 342: