File:
1.19.0a/server/base/sql/schema.upgrade.sql (
View as Code)
1: -- FreeNATS freenats-1.19.0a 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 NOT NULL;
34: ALTER TABLE `fnalertaction` ADD `etolist` text NOT NULL;
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 NOT NULL;
44: ALTER TABLE `fnalertaction` ADD `mdata` text NOT NULL;
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) NOT NULL;
48: ALTER TABLE `fnalertaction` ADD `ctrdate` varchar(8) NOT NULL;
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) NOT NULL;
67: ALTER TABLE `fnalertlog` ADD `logentry` varchar(250) NOT NULL;
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;
127: ALTER TABLE `fngrouplock` ADD `groupid` bigint(20) NOT NULL;
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) NOT NULL;
158: ALTER TABLE `fnlocaltest` ADD `testparam1` varchar(250) NOT NULL;
159: ALTER TABLE `fnlocaltest` CHANGE `testparam2` `testparam2` varchar(250) NOT NULL;
160: ALTER TABLE `fnlocaltest` ADD `testparam2` varchar(250) NOT NULL;
161: ALTER TABLE `fnlocaltest` CHANGE `testparam3` `testparam3` varchar(250) NOT NULL;
162: ALTER TABLE `fnlocaltest` ADD `testparam3` varchar(250) NOT NULL;
163: ALTER TABLE `fnlocaltest` CHANGE `testparam4` `testparam4` varchar(250) NOT NULL;
164: ALTER TABLE `fnlocaltest` ADD `testparam4` varchar(250) NOT NULL;
165: ALTER TABLE `fnlocaltest` CHANGE `testparam5` `testparam5` varchar(250) NOT NULL;
166: ALTER TABLE `fnlocaltest` ADD `testparam5` varchar(250) NOT NULL;
167: ALTER TABLE `fnlocaltest` CHANGE `testparam6` `testparam6` varchar(250) NOT NULL;
168: ALTER TABLE `fnlocaltest` ADD `testparam6` varchar(250) NOT NULL;
169: ALTER TABLE `fnlocaltest` CHANGE `testparam7` `testparam7` varchar(250) NOT NULL;
170: ALTER TABLE `fnlocaltest` ADD `testparam7` varchar(250) NOT NULL;
171: ALTER TABLE `fnlocaltest` CHANGE `testparam8` `testparam8` varchar(250) NOT NULL;
172: ALTER TABLE `fnlocaltest` ADD `testparam8` varchar(250) NOT NULL;
173: ALTER TABLE `fnlocaltest` CHANGE `testparam9` `testparam9` varchar(250) NOT NULL;
174: ALTER TABLE `fnlocaltest` ADD `testparam9` varchar(250) NOT NULL;
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(128) NOT NULL;
248: ALTER TABLE `fnnode` ADD `nskey` varchar(128) 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 NOT NULL;
344: ALTER TABLE `fnreport` ADD `reporttests` text NOT NULL;
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(32) NOT NULL;
356: ALTER TABLE `fnrssfeed` ADD `feedtype` varchar(32) 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 NOT NULL;
427: ALTER TABLE `fntestrun` ADD `routput` text NOT NULL;
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;
444: ALTER TABLE `fnuser` ADD `grouplock` tinyint(4) NOT NULL;
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: