File: 0.02.49a/server/base/sql/schema.upgrade.sql (View as HTML)

  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: ALTER TABLE `fnlocaltest` CHANGE `alertlevel` `alertlevel` int(11) NOT NULL DEFAULT '-1';
117: ALTER TABLE `fnlocaltest` ADD `alertlevel` int(11) NOT NULL DEFAULT '-1';
118: ALTER TABLE `fnlocaltest` CHANGE `lastrunx` `lastrunx` bigint(20) unsigned NOT NULL DEFAULT '0';
119: ALTER TABLE `fnlocaltest` ADD `lastrunx` bigint(20) unsigned NOT NULL DEFAULT '0';
120: ALTER TABLE `fnlocaltest` CHANGE `testtype` `testtype` varchar(128) NOT NULL;
121: ALTER TABLE `fnlocaltest` ADD `testtype` varchar(128) NOT NULL;
122: ALTER TABLE `fnlocaltest` CHANGE `testparam` `testparam` varchar(250);
123: ALTER TABLE `fnlocaltest` ADD `testparam` varchar(250);
124: ALTER TABLE `fnlocaltest` CHANGE `testrecord` `testrecord` tinyint(1) NOT NULL DEFAULT '0';
125: ALTER TABLE `fnlocaltest` ADD `testrecord` tinyint(1) NOT NULL DEFAULT '0';
126: ALTER TABLE `fnlocaltest` CHANGE `simpleeval` `simpleeval` tinyint(1) NOT NULL DEFAULT '1';
127: ALTER TABLE `fnlocaltest` ADD `simpleeval` tinyint(1) NOT NULL DEFAULT '1';
128: -- 
129: -- Table: fnlog
130: -- DESCRIBE fnlog
131: ALTER TABLE `fnlog` CHANGE `logid` `logid` bigint(20) unsigned NOT NULL auto_increment;
132: ALTER TABLE `fnlog` ADD `logid` bigint(20) unsigned NOT NULL auto_increment;
133: ALTER TABLE `fnlog` ADD PRIMARY KEY( `logid` );
134: ALTER TABLE `fnlog` CHANGE `postedx` `postedx` bigint(20) unsigned NOT NULL DEFAULT '0';
135: ALTER TABLE `fnlog` ADD `postedx` bigint(20) unsigned NOT NULL DEFAULT '0';
136: ALTER TABLE `fnlog` CHANGE `modid` `modid` varchar(32) NOT NULL;
137: ALTER TABLE `fnlog` ADD `modid` varchar(32) NOT NULL;
138: ALTER TABLE `fnlog` CHANGE `catid` `catid` varchar(32) NOT NULL;
139: ALTER TABLE `fnlog` ADD `catid` varchar(32) NOT NULL;
140: ALTER TABLE `fnlog` CHANGE `username` `username` varchar(64) NOT NULL;
141: ALTER TABLE `fnlog` ADD `username` varchar(64) NOT NULL;
142: ALTER TABLE `fnlog` CHANGE `loglevel` `loglevel` int(11) NOT NULL DEFAULT '1';
143: ALTER TABLE `fnlog` ADD `loglevel` int(11) NOT NULL DEFAULT '1';
144: ALTER TABLE `fnlog` CHANGE `logevent` `logevent` varchar(250) NOT NULL;
145: ALTER TABLE `fnlog` ADD `logevent` varchar(250) NOT NULL;
146: -- 
147: -- Table: fnnalink
148: -- DESCRIBE fnnalink
149: ALTER TABLE `fnnalink` CHANGE `nalid` `nalid` bigint(20) unsigned NOT NULL auto_increment;
150: ALTER TABLE `fnnalink` ADD `nalid` bigint(20) unsigned NOT NULL auto_increment;
151: ALTER TABLE `fnnalink` ADD PRIMARY KEY( `nalid` );
152: ALTER TABLE `fnnalink` CHANGE `nodeid` `nodeid` varchar(64) NOT NULL;
153: ALTER TABLE `fnnalink` ADD `nodeid` varchar(64) NOT NULL;
154: ALTER TABLE `fnnalink` CHANGE `aaid` `aaid` bigint(20) unsigned NOT NULL DEFAULT '0';
155: ALTER TABLE `fnnalink` ADD `aaid` bigint(20) unsigned NOT NULL DEFAULT '0';
156: -- 
157: -- Table: fnnode
158: -- DESCRIBE fnnode
159: ALTER TABLE `fnnode` CHANGE `nodeid` `nodeid` varchar(64) NOT NULL;
160: ALTER TABLE `fnnode` ADD `nodeid` varchar(64) NOT NULL;
161: ALTER TABLE `fnnode` ADD PRIMARY KEY( `nodeid` );
162: ALTER TABLE `fnnode` CHANGE `nodename` `nodename` varchar(128) NOT NULL;
163: ALTER TABLE `fnnode` ADD `nodename` varchar(128) NOT NULL;
164: ALTER TABLE `fnnode` CHANGE `nodedesc` `nodedesc` varchar(254) NOT NULL;
165: ALTER TABLE `fnnode` ADD `nodedesc` varchar(254) NOT NULL;
166: ALTER TABLE `fnnode` CHANGE `hostname` `hostname` varchar(254) NOT NULL;
167: ALTER TABLE `fnnode` ADD `hostname` varchar(254) NOT NULL;
168: ALTER TABLE `fnnode` CHANGE `nodeenabled` `nodeenabled` tinyint(1) NOT NULL DEFAULT '0';
169: ALTER TABLE `fnnode` ADD `nodeenabled` tinyint(1) NOT NULL DEFAULT '0';
170: ALTER TABLE `fnnode` CHANGE `pingtest` `pingtest` tinyint(1) NOT NULL DEFAULT '0';
171: ALTER TABLE `fnnode` ADD `pingtest` tinyint(1) NOT NULL DEFAULT '0';
172: ALTER TABLE `fnnode` CHANGE `pingfatal` `pingfatal` tinyint(1) NOT NULL DEFAULT '0';
173: ALTER TABLE `fnnode` ADD `pingfatal` tinyint(1) NOT NULL DEFAULT '0';
174: ALTER TABLE `fnnode` CHANGE `alertlevel` `alertlevel` int(11) NOT NULL DEFAULT '-1';
175: ALTER TABLE `fnnode` ADD `alertlevel` int(11) NOT NULL DEFAULT '-1';
176: ALTER TABLE `fnnode` CHANGE `nodeicon` `nodeicon` varchar(64) NOT NULL;
177: ALTER TABLE `fnnode` ADD `nodeicon` varchar(64) NOT NULL;
178: ALTER TABLE `fnnode` CHANGE `weight` `weight` int(10) unsigned NOT NULL DEFAULT '0';
179: ALTER TABLE `fnnode` ADD `weight` int(10) unsigned NOT NULL DEFAULT '0';
180: ALTER TABLE `fnnode` CHANGE `nodealert` `nodealert` tinyint(1) NOT NULL DEFAULT '1';
181: ALTER TABLE `fnnode` ADD `nodealert` tinyint(1) NOT NULL DEFAULT '1';
182: -- 
183: -- Table: fnrecord
184: -- DESCRIBE fnrecord
185: ALTER TABLE `fnrecord` CHANGE `recordid` `recordid` bigint(20) unsigned NOT NULL auto_increment;
186: ALTER TABLE `fnrecord` ADD `recordid` bigint(20) unsigned NOT NULL auto_increment;
187: ALTER TABLE `fnrecord` ADD PRIMARY KEY( `recordid` );
188: ALTER TABLE `fnrecord` CHANGE `testid` `testid` varchar(128) NOT NULL;
189: ALTER TABLE `fnrecord` ADD `testid` varchar(128) NOT NULL;
190: ALTER TABLE `fnrecord` CHANGE `alertlevel` `alertlevel` int(11) NOT NULL DEFAULT '0';
191: ALTER TABLE `fnrecord` ADD `alertlevel` int(11) NOT NULL DEFAULT '0';
192: ALTER TABLE `fnrecord` CHANGE `testvalue` `testvalue` float NOT NULL DEFAULT '0';
193: ALTER TABLE `fnrecord` ADD `testvalue` float NOT NULL DEFAULT '0';
194: ALTER TABLE `fnrecord` CHANGE `recordx` `recordx` bigint(20) unsigned NOT NULL DEFAULT '0';
195: ALTER TABLE `fnrecord` ADD `recordx` bigint(20) unsigned NOT NULL DEFAULT '0';
196: ALTER TABLE `fnrecord` CHANGE `nodeid` `nodeid` varchar(64) NOT NULL;
197: ALTER TABLE `fnrecord` ADD `nodeid` varchar(64) NOT NULL;
198: -- 
199: -- Table: fnsession
200: -- DESCRIBE fnsession
201: ALTER TABLE `fnsession` CHANGE `sessionid` `sessionid` bigint(20) unsigned NOT NULL auto_increment;
202: ALTER TABLE `fnsession` ADD `sessionid` bigint(20) unsigned NOT NULL auto_increment;
203: ALTER TABLE `fnsession` ADD PRIMARY KEY( `sessionid` );
204: ALTER TABLE `fnsession` CHANGE `sessionkey` `sessionkey` varchar(128) NOT NULL;
205: ALTER TABLE `fnsession` ADD `sessionkey` varchar(128) NOT NULL;
206: ALTER TABLE `fnsession` CHANGE `ipaddress` `ipaddress` varchar(128) NOT NULL;
207: ALTER TABLE `fnsession` ADD `ipaddress` varchar(128) NOT NULL;
208: ALTER TABLE `fnsession` CHANGE `username` `username` varchar(64) NOT NULL;
209: ALTER TABLE `fnsession` ADD `username` varchar(64) NOT NULL;
210: ALTER TABLE `fnsession` CHANGE `startx` `startx` bigint(20) unsigned NOT NULL DEFAULT '0';
211: ALTER TABLE `fnsession` ADD `startx` bigint(20) unsigned NOT NULL DEFAULT '0';
212: ALTER TABLE `fnsession` CHANGE `updatex` `updatex` bigint(20) unsigned NOT NULL DEFAULT '0';
213: ALTER TABLE `fnsession` ADD `updatex` bigint(20) unsigned NOT NULL DEFAULT '0';
214: ALTER TABLE `fnsession` CHANGE `userlevel` `userlevel` int(11) NOT NULL DEFAULT '0';
215: ALTER TABLE `fnsession` ADD `userlevel` int(11) NOT NULL DEFAULT '0';
216: -- 
217: -- Table: fntestrun
218: -- DESCRIBE fntestrun
219: ALTER TABLE `fntestrun` CHANGE `trid` `trid` bigint(20) unsigned NOT NULL auto_increment;
220: ALTER TABLE `fntestrun` ADD `trid` bigint(20) unsigned NOT NULL auto_increment;
221: ALTER TABLE `fntestrun` ADD PRIMARY KEY( `trid` );
222: ALTER TABLE `fntestrun` CHANGE `startx` `startx` bigint(20) unsigned NOT NULL DEFAULT '0';
223: ALTER TABLE `fntestrun` ADD `startx` bigint(20) unsigned NOT NULL DEFAULT '0';
224: ALTER TABLE `fntestrun` CHANGE `finishx` `finishx` bigint(20) unsigned NOT NULL DEFAULT '0';
225: ALTER TABLE `fntestrun` ADD `finishx` bigint(20) unsigned NOT NULL DEFAULT '0';
226: ALTER TABLE `fntestrun` CHANGE `routput` `routput` text NOT NULL;
227: ALTER TABLE `fntestrun` ADD `routput` text NOT NULL;
228: ALTER TABLE `fntestrun` CHANGE `fnode` `fnode` varchar(64) NOT NULL;
229: ALTER TABLE `fntestrun` ADD `fnode` varchar(64) NOT NULL;
230: -- 
231: -- Table: fnuser
232: -- DESCRIBE fnuser
233: ALTER TABLE `fnuser` CHANGE `username` `username` varchar(64) NOT NULL;
234: ALTER TABLE `fnuser` ADD `username` varchar(64) NOT NULL;
235: ALTER TABLE `fnuser` ADD PRIMARY KEY( `username` );
236: ALTER TABLE `fnuser` CHANGE `password` `password` varchar(64) NOT NULL;
237: ALTER TABLE `fnuser` ADD `password` varchar(64) NOT NULL;
238: ALTER TABLE `fnuser` CHANGE `realname` `realname` varchar(128) NOT NULL;
239: ALTER TABLE `fnuser` ADD `realname` varchar(128) NOT NULL;
240: ALTER TABLE `fnuser` CHANGE `userlevel` `userlevel` int(11) NOT NULL DEFAULT '1';
241: ALTER TABLE `fnuser` ADD `userlevel` int(11) NOT NULL DEFAULT '1';
242: -- 
243: -- Table: fnview
244: -- DESCRIBE fnview
245: ALTER TABLE `fnview` CHANGE `viewid` `viewid` bigint(20) unsigned NOT NULL auto_increment;
246: ALTER TABLE `fnview` ADD `viewid` bigint(20) unsigned NOT NULL auto_increment;
247: ALTER TABLE `fnview` ADD PRIMARY KEY( `viewid` );
248: ALTER TABLE `fnview` CHANGE `vtitle` `vtitle` varchar(128) NOT NULL;
249: ALTER TABLE `fnview` ADD `vtitle` varchar(128) NOT NULL;
250: ALTER TABLE `fnview` CHANGE `vstyle` `vstyle` varchar(32) NOT NULL;
251: ALTER TABLE `fnview` ADD `vstyle` varchar(32) NOT NULL;
252: ALTER TABLE `fnview` CHANGE `vpublic` `vpublic` tinyint(1) NOT NULL DEFAULT '0';
253: ALTER TABLE `fnview` ADD `vpublic` tinyint(1) NOT NULL DEFAULT '0';
254: ALTER TABLE `fnview` CHANGE `vclick` `vclick` varchar(32) NOT NULL;
255: ALTER TABLE `fnview` ADD `vclick` varchar(32) NOT NULL;
256: ALTER TABLE `fnview` CHANGE `vrefresh` `vrefresh` int(11) NOT NULL DEFAULT '0';
257: ALTER TABLE `fnview` ADD `vrefresh` int(11) NOT NULL DEFAULT '0';
258: -- 
259: