forked from openemr/openemr
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path3_0_1-to-3_1_0_upgrade.sql
375 lines (346 loc) · 19.9 KB
/
3_0_1-to-3_1_0_upgrade.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
#IfMissingColumn pnotes deleted
ALTER TABLE `pnotes`
ADD `deleted` TINYINT DEFAULT '0' COMMENT 'flag indicates note is deleted';
#EndIf
#IfNotRow list_options list_id adjreason
INSERT INTO list_options VALUES ('lists' ,'adjreason' ,'Adjustment Reasons',1,0,0);
INSERT INTO list_options VALUES ('adjreason','Adm adjust' ,'Adm adjust' , 5,0,0);
INSERT INTO list_options VALUES ('adjreason','After hrs calls','After hrs calls',10,0,0);
INSERT INTO list_options VALUES ('adjreason','Bad check' ,'Bad check' ,15,0,0);
INSERT INTO list_options VALUES ('adjreason','Bad debt' ,'Bad debt' ,20,0,0);
INSERT INTO list_options VALUES ('adjreason','Coll w/o' ,'Coll w/o' ,25,0,0);
INSERT INTO list_options VALUES ('adjreason','Discount' ,'Discount' ,30,0,0);
INSERT INTO list_options VALUES ('adjreason','Hardship w/o' ,'Hardship w/o' ,35,0,0);
INSERT INTO list_options VALUES ('adjreason','Ins adjust' ,'Ins adjust' ,40,0,0);
INSERT INTO list_options VALUES ('adjreason','Ins bundling' ,'Ins bundling' ,45,0,0);
INSERT INTO list_options VALUES ('adjreason','Ins overpaid' ,'Ins overpaid' ,50,0,0);
INSERT INTO list_options VALUES ('adjreason','Ins refund' ,'Ins refund' ,55,0,0);
INSERT INTO list_options VALUES ('adjreason','Pt overpaid' ,'Pt overpaid' ,60,0,0);
INSERT INTO list_options VALUES ('adjreason','Pt refund' ,'Pt refund' ,65,0,0);
INSERT INTO list_options VALUES ('adjreason','Pt released' ,'Pt released' ,70,0,0);
INSERT INTO list_options VALUES ('adjreason','Sm debt w/o' ,'Sm debt w/o' ,75,0,0);
INSERT INTO list_options VALUES ('adjreason','To copay' ,'To copay' ,80,0,0);
INSERT INTO list_options VALUES ('adjreason','To ded\'ble' ,'To ded\'ble' ,85,0,0);
INSERT INTO list_options VALUES ('adjreason','Untimely filing','Untimely filing',90,0,0);
#EndIf
#IfNotRow list_options list_id sub_relation
INSERT INTO list_options VALUES ('lists' ,'sub_relation','Subscriber Relationship',18,0,0);
INSERT INTO list_options VALUES ('sub_relation','self' ,'Self' , 1,0,0);
INSERT INTO list_options VALUES ('sub_relation','spouse' ,'Spouse' , 2,0,0);
INSERT INTO list_options VALUES ('sub_relation','child' ,'Child' , 3,0,0);
INSERT INTO list_options VALUES ('sub_relation','other' ,'Other' , 4,0,0);
#EndIf
#IfNotRow list_options list_id occurrence
INSERT INTO list_options VALUES ('lists' ,'occurrence','Occurrence' ,10,0,0);
INSERT INTO list_options VALUES ('occurrence','0' ,'Unknown or N/A' , 5,0,0);
INSERT INTO list_options VALUES ('occurrence','1' ,'First' ,10,0,0);
INSERT INTO list_options VALUES ('occurrence','6' ,'Early Recurrence (<2 Mo)' ,15,0,0);
INSERT INTO list_options VALUES ('occurrence','7' ,'Late Recurrence (2-12 Mo)' ,20,0,0);
INSERT INTO list_options VALUES ('occurrence','8' ,'Delayed Recurrence (> 12 Mo)',25,0,0);
INSERT INTO list_options VALUES ('occurrence','4' ,'Chronic/Recurrent' ,30,0,0);
INSERT INTO list_options VALUES ('occurrence','5' ,'Acute on Chronic' ,35,0,0);
#EndIf
#IfNotRow list_options list_id outcome
INSERT INTO list_options VALUES ('lists' ,'outcome','Outcome' ,10,0,0);
INSERT INTO list_options VALUES ('outcome','0' ,'Unassigned' , 2,0,0);
INSERT INTO list_options VALUES ('outcome','1' ,'Resolved' , 5,0,0);
INSERT INTO list_options VALUES ('outcome','2' ,'Improved' ,10,0,0);
INSERT INTO list_options VALUES ('outcome','3' ,'Status quo' ,15,0,0);
INSERT INTO list_options VALUES ('outcome','4' ,'Worse' ,20,0,0);
INSERT INTO list_options VALUES ('outcome','5' ,'Pending followup',25,0,0);
#EndIf
#IfNotRow list_options list_id note_type
INSERT INTO list_options VALUES ('lists' ,'note_type' ,'Patient Note Types',10,0,0);
INSERT INTO list_options VALUES ('note_type','Unassigned' ,'Unassigned' , 1,0,0);
INSERT INTO list_options VALUES ('note_type','Chart Note' ,'Chart Note' , 2,0,0);
INSERT INTO list_options VALUES ('note_type','Insurance' ,'Insurance' , 3,0,0);
INSERT INTO list_options VALUES ('note_type','New Document' ,'New Document' , 4,0,0);
INSERT INTO list_options VALUES ('note_type','Pharmacy' ,'Pharmacy' , 5,0,0);
INSERT INTO list_options VALUES ('note_type','Prior Auth' ,'Prior Auth' , 6,0,0);
INSERT INTO list_options VALUES ('note_type','Referral' ,'Referral' , 7,0,0);
INSERT INTO list_options VALUES ('note_type','Test Scheduling','Test Scheduling' , 8,0,0);
INSERT INTO list_options VALUES ('note_type','Bill/Collect' ,'Bill/Collect' , 9,0,0);
INSERT INTO list_options VALUES ('note_type','Other' ,'Other' ,10,0,0);
#EndIf
#IfNotRow list_options list_id immunizations
INSERT INTO list_options VALUES ('lists','immunizations','Immunizations',8,0,0);
INSERT INTO list_options (list_id,option_id,title) SELECT 'immunizations',id,name FROM immunization ORDER BY name;
DROP TABLE immunization;
#EndIf
#IfNotRow2D list_options list_id drug_form option_id 0
INSERT INTO list_options VALUES ('drug_form' ,'0' ,'' , 0,0,0);
#EndIf
#IfNotRow2D list_options list_id drug_form option_id 10
INSERT INTO list_options VALUES ('drug_form' ,'10','cream' ,10,0,0);
#EndIf
#IfNotRow2D list_options list_id drug_form option_id 11
INSERT INTO list_options VALUES ('drug_form' ,'11','ointment' ,11,0,0);
#EndIf
#IfNotRow2D list_options list_id drug_units option_id 0
INSERT INTO list_options VALUES ('drug_units' ,'0' ,'' , 0,0,0);
#EndIf
#IfNotRow2D list_options list_id drug_route option_id 0
INSERT INTO list_options VALUES ('drug_route' ,'0' ,'' , 0,0,0);
#EndIf
#IfNotRow2D list_options list_id drug_route option_id 13
INSERT INTO list_options VALUES ('drug_route' ,'13','Both Ears',13,0,0);
#EndIf
#IfNotRow2D list_options list_id drug_route option_id 14
INSERT INTO list_options VALUES ('drug_route' ,'14','Left Ear' ,14,0,0);
#EndIf
#IfNotRow2D list_options list_id drug_route option_id 15
INSERT INTO list_options VALUES ('drug_route' ,'15','Right Ear',15,0,0);
#EndIf
#IfNotRow2D list_options list_id drug_interval option_id 0
INSERT INTO list_options VALUES ('drug_interval','0' ,'' , 0,0,0);
#EndIf
#IfNotRow2D list_options list_id drug_interval option_id 10
INSERT INTO list_options VALUES ('drug_interval','10','a.c.' ,10,0,0);
#EndIf
#IfNotRow2D list_options list_id drug_interval option_id 11
INSERT INTO list_options VALUES ('drug_interval','11','p.c.' ,11,0,0);
#EndIf
#IfNotRow2D list_options list_id drug_interval option_id 12
INSERT INTO list_options VALUES ('drug_interval','12','a.m.' ,12,0,0);
#EndIf
#IfNotRow2D list_options list_id drug_interval option_id 13
INSERT INTO list_options VALUES ('drug_interval','13','p.m.' ,13,0,0);
#EndIf
#IfNotRow2D list_options list_id drug_interval option_id 14
INSERT INTO list_options VALUES ('drug_interval','14','ante' ,14,0,0);
#EndIf
#IfNotRow2D list_options list_id drug_interval option_id 15
INSERT INTO list_options VALUES ('drug_interval','15','h' ,15,0,0);
#EndIf
#IfNotRow2D list_options list_id drug_interval option_id 16
INSERT INTO list_options VALUES ('drug_interval','16','h.s.' ,16,0,0);
#EndIf
#IfNotRow2D list_options list_id drug_interval option_id 17
INSERT INTO list_options VALUES ('drug_interval','17','p.r.n.' ,17,0,0);
#EndIf
#IfNotRow2D list_options list_id drug_interval option_id 18
INSERT INTO list_options VALUES ('drug_interval','18','stat' ,18,0,0);
#EndIf
UPDATE list_options
SET option_id = '6' WHERE option_id = ' 6' and list_id = 'drug_route';
UPDATE list_options
SET title = 'mcg' WHERE option_id = '7' and list_id = 'drug_units';
UPDATE list_options
SET title = 'grams' WHERE option_id = '8' and list_id = 'drug_units';
UPDATE `layout_options`
SET data_type = 26 WHERE form_id = 'DEM' and field_id = 'state';
UPDATE `layout_options`
SET data_type = 26 WHERE form_id = 'DEM' and field_id = 'country_code';
UPDATE `layout_options`
SET data_type = 26, list_id = 'state', fld_length = 0, max_length = 0, edit_options = '' WHERE form_id = 'DEM' and field_id = 'em_state';
UPDATE `layout_options`
SET data_type = 26, list_id = 'country', fld_length = 0, max_length = 0, edit_options = '' WHERE form_id = 'DEM' and field_id = 'em_country';
ALTER TABLE `prices`
CHANGE `pr_selector` `pr_selector` VARCHAR( 255 ) NOT NULL default '' COMMENT 'template selector for drugs, empty for codes';
#IfMissingColumn form_encounter provider_id
ALTER TABLE `form_encounter`
ADD `provider_id` INT(11) DEFAULT '0' COMMENT 'default and main provider for this visit';
UPDATE form_encounter AS fe, forms AS f, billing AS b, users AS u
SET fe.provider_id = u.id WHERE
fe.provider_id = 0 AND
f.form_id = fe.id AND
f.formdir = 'newpatient' AND
f.deleted = 0 AND
b.pid = fe.pid AND
b.encounter = fe.encounter AND
b.fee > 0 AND
b.provider_id > 0 AND
b.activity = 1 AND
u.id = b.provider_id AND
u.authorized = 1;
UPDATE form_encounter AS fe, forms AS f, users AS u
SET fe.provider_id = u.id WHERE
fe.provider_id = 0 AND
f.form_id = fe.id AND
f.formdir = 'newpatient' AND
f.deleted = 0 AND
u.username = f.user AND
u.authorized = 1;
UPDATE form_encounter AS fe, forms AS f, billing AS b
SET b.provider_id = 0 WHERE
fe.provider_id > 0 AND
f.form_id = fe.id AND
f.formdir = 'newpatient' AND
f.deleted = 0 AND
b.pid = fe.pid AND
b.encounter = fe.encounter AND
b.activity = 1;
#EndIf
#IfMissingColumn codes active
ALTER TABLE `codes`
ADD `active` TINYINT(1) DEFAULT 1 COMMENT '0 = inactive, 1 = active';
#EndIf
#IfMissingColumn drugs active
ALTER TABLE `drugs`
ADD `active` TINYINT(1) DEFAULT 1 COMMENT '0 = inactive, 1 = active';
#EndIf
#IfNotTable users_facility
CREATE TABLE `users_facility` (
`tablename` varchar(64) NOT NULL,
`table_id` int(11) NOT NULL,
`facility_id` int(11) NOT NULL,
PRIMARY KEY (`tablename`,`table_id`,`facility_id`)
) ENGINE=InnoDB COMMENT='joins users or patient_data to facility table';
#EndIf
#IfTable form_reviewofs
ALTER TABLE form_reviewofs CHANGE fever fever varchar(5);
ALTER TABLE form_reviewofs CHANGE chills chills varchar(5);
ALTER TABLE form_reviewofs CHANGE night_sweats night_sweats varchar(5);
ALTER TABLE form_reviewofs CHANGE weight_loss weight_loss varchar(5);
ALTER TABLE form_reviewofs CHANGE poor_appetite poor_appetite varchar(5);
ALTER TABLE form_reviewofs CHANGE insomnia insomnia varchar(5);
ALTER TABLE form_reviewofs CHANGE fatigued fatigued varchar(5);
ALTER TABLE form_reviewofs CHANGE depressed depressed varchar(5);
ALTER TABLE form_reviewofs CHANGE hyperactive hyperactive varchar(5);
ALTER TABLE form_reviewofs CHANGE exposure_to_foreign_countries exposure_to_foreign_countries varchar(5);
ALTER TABLE form_reviewofs CHANGE cataracts cataracts varchar(5);
ALTER TABLE form_reviewofs CHANGE cataract_surgery cataract_surgery varchar(5);
ALTER TABLE form_reviewofs CHANGE glaucoma glaucoma varchar(5);
ALTER TABLE form_reviewofs CHANGE double_vision double_vision varchar(5);
ALTER TABLE form_reviewofs CHANGE blurred_vision blurred_vision varchar(5);
ALTER TABLE form_reviewofs CHANGE poor_hearing poor_hearing varchar(5);
ALTER TABLE form_reviewofs CHANGE headaches headaches varchar(5);
ALTER TABLE form_reviewofs CHANGE ringing_in_ears ringing_in_ears varchar(5);
ALTER TABLE form_reviewofs CHANGE bloody_nose bloody_nose varchar(5);
ALTER TABLE form_reviewofs CHANGE sinusitis sinusitis varchar(5);
ALTER TABLE form_reviewofs CHANGE sinus_surgery sinus_surgery varchar(5);
ALTER TABLE form_reviewofs CHANGE dry_mouth dry_mouth varchar(5);
ALTER TABLE form_reviewofs CHANGE strep_throat strep_throat varchar(5);
ALTER TABLE form_reviewofs CHANGE tonsillectomy tonsillectomy varchar(5);
ALTER TABLE form_reviewofs CHANGE swollen_lymph_nodes swollen_lymph_nodes varchar(5);
ALTER TABLE form_reviewofs CHANGE throat_cancer throat_cancer varchar(5);
ALTER TABLE form_reviewofs CHANGE throat_cancer_surgery throat_cancer_surgery varchar(5);
ALTER TABLE form_reviewofs CHANGE heart_attack heart_attack varchar(5);
ALTER TABLE form_reviewofs CHANGE irregular_heart_beat irregular_heart_beat varchar(5);
ALTER TABLE form_reviewofs CHANGE chest_pains chest_pains varchar(5);
ALTER TABLE form_reviewofs CHANGE shortness_of_breath shortness_of_breath varchar(5);
ALTER TABLE form_reviewofs CHANGE high_blood_pressure high_blood_pressure varchar(5);
ALTER TABLE form_reviewofs CHANGE heart_failure heart_failure varchar(5);
ALTER TABLE form_reviewofs CHANGE poor_circulation poor_circulation varchar(5);
ALTER TABLE form_reviewofs CHANGE vascular_surgery vascular_surgery varchar(5);
ALTER TABLE form_reviewofs CHANGE cardiac_catheterization cardiac_catheterization varchar(5);
ALTER TABLE form_reviewofs CHANGE coronary_artery_bypass coronary_artery_bypass varchar(5);
ALTER TABLE form_reviewofs CHANGE heart_transplant heart_transplant varchar(5);
ALTER TABLE form_reviewofs CHANGE stress_test stress_test varchar(5);
ALTER TABLE form_reviewofs CHANGE emphysema emphysema varchar(5);
ALTER TABLE form_reviewofs CHANGE chronic_bronchitis chronic_bronchitis varchar(5);
ALTER TABLE form_reviewofs CHANGE interstitial_lung_disease interstitial_lung_disease varchar(5);
ALTER TABLE form_reviewofs CHANGE shortness_of_breath_2 shortness_of_breath_2 varchar(5);
ALTER TABLE form_reviewofs CHANGE lung_cancer lung_cancer varchar(5);
ALTER TABLE form_reviewofs CHANGE lung_cancer_surgery lung_cancer_surgery varchar(5);
ALTER TABLE form_reviewofs CHANGE pheumothorax pheumothorax varchar(5);
ALTER TABLE form_reviewofs CHANGE stomach_pains stomach_pains varchar(5);
ALTER TABLE form_reviewofs CHANGE peptic_ulcer_disease peptic_ulcer_disease varchar(5);
ALTER TABLE form_reviewofs CHANGE gastritis gastritis varchar(5);
ALTER TABLE form_reviewofs CHANGE endoscopy endoscopy varchar(5);
ALTER TABLE form_reviewofs CHANGE polyps polyps varchar(5);
ALTER TABLE form_reviewofs CHANGE colonoscopy colonoscopy varchar(5);
ALTER TABLE form_reviewofs CHANGE colon_cancer colon_cancer varchar(5);
ALTER TABLE form_reviewofs CHANGE colon_cancer_surgery colon_cancer_surgery varchar(5);
ALTER TABLE form_reviewofs CHANGE ulcerative_colitis ulcerative_colitis varchar(5);
ALTER TABLE form_reviewofs CHANGE crohns_disease crohns_disease varchar(5);
ALTER TABLE form_reviewofs CHANGE appendectomy appendectomy varchar(5);
ALTER TABLE form_reviewofs CHANGE divirticulitis divirticulitis varchar(5);
ALTER TABLE form_reviewofs CHANGE divirticulitis_surgery divirticulitis_surgery varchar(5);
ALTER TABLE form_reviewofs CHANGE gall_stones gall_stones varchar(5);
ALTER TABLE form_reviewofs CHANGE cholecystectomy cholecystectomy varchar(5);
ALTER TABLE form_reviewofs CHANGE hepatitis hepatitis varchar(5);
ALTER TABLE form_reviewofs CHANGE cirrhosis_of_the_liver cirrhosis_of_the_liver varchar(5);
ALTER TABLE form_reviewofs CHANGE splenectomy splenectomy varchar(5);
ALTER TABLE form_reviewofs CHANGE kidney_failure kidney_failure varchar(5);
ALTER TABLE form_reviewofs CHANGE kidney_stones kidney_stones varchar(5);
ALTER TABLE form_reviewofs CHANGE kidney_cancer kidney_cancer varchar(5);
ALTER TABLE form_reviewofs CHANGE kidney_infections kidney_infections varchar(5);
ALTER TABLE form_reviewofs CHANGE bladder_infections bladder_infections varchar(5);
ALTER TABLE form_reviewofs CHANGE bladder_cancer bladder_cancer varchar(5);
ALTER TABLE form_reviewofs CHANGE prostate_problems prostate_problems varchar(5);
ALTER TABLE form_reviewofs CHANGE prostate_cancer prostate_cancer varchar(5);
ALTER TABLE form_reviewofs CHANGE kidney_transplant kidney_transplant varchar(5);
ALTER TABLE form_reviewofs CHANGE sexually_transmitted_disease sexually_transmitted_disease varchar(5);
ALTER TABLE form_reviewofs CHANGE burning_with_urination burning_with_urination varchar(5);
ALTER TABLE form_reviewofs CHANGE discharge_from_urethra discharge_from_urethra varchar(5);
ALTER TABLE form_reviewofs CHANGE rashes rashes varchar(5);
ALTER TABLE form_reviewofs CHANGE infections infections varchar(5);
ALTER TABLE form_reviewofs CHANGE ulcerations ulcerations varchar(5);
ALTER TABLE form_reviewofs CHANGE pemphigus pemphigus varchar(5);
ALTER TABLE form_reviewofs CHANGE herpes herpes varchar(5);
ALTER TABLE form_reviewofs CHANGE osetoarthritis osetoarthritis varchar(5);
ALTER TABLE form_reviewofs CHANGE rheumotoid_arthritis rheumotoid_arthritis varchar(5);
ALTER TABLE form_reviewofs CHANGE lupus lupus varchar(5);
ALTER TABLE form_reviewofs CHANGE ankylosing_sondlilitis ankylosing_sondlilitis varchar(5);
ALTER TABLE form_reviewofs CHANGE swollen_joints swollen_joints varchar(5);
ALTER TABLE form_reviewofs CHANGE stiff_joints stiff_joints varchar(5);
ALTER TABLE form_reviewofs CHANGE broken_bones broken_bones varchar(5);
ALTER TABLE form_reviewofs CHANGE neck_problems neck_problems varchar(5);
ALTER TABLE form_reviewofs CHANGE back_problems back_problems varchar(5);
ALTER TABLE form_reviewofs CHANGE back_surgery back_surgery varchar(5);
ALTER TABLE form_reviewofs CHANGE scoliosis scoliosis varchar(5);
ALTER TABLE form_reviewofs CHANGE herniated_disc herniated_disc varchar(5);
ALTER TABLE form_reviewofs CHANGE shoulder_problems shoulder_problems varchar(5);
ALTER TABLE form_reviewofs CHANGE elbow_problems elbow_problems varchar(5);
ALTER TABLE form_reviewofs CHANGE wrist_problems wrist_problems varchar(5);
ALTER TABLE form_reviewofs CHANGE hand_problems hand_problems varchar(5);
ALTER TABLE form_reviewofs CHANGE hip_problems hip_problems varchar(5);
ALTER TABLE form_reviewofs CHANGE knee_problems knee_problems varchar(5);
ALTER TABLE form_reviewofs CHANGE ankle_problems ankle_problems varchar(5);
ALTER TABLE form_reviewofs CHANGE foot_problems foot_problems varchar(5);
ALTER TABLE form_reviewofs CHANGE insulin_dependent_diabetes insulin_dependent_diabetes varchar(5);
ALTER TABLE form_reviewofs CHANGE noninsulin_dependent_diabetes noninsulin_dependent_diabetes varchar(5);
ALTER TABLE form_reviewofs CHANGE hypothyroidism hypothyroidism varchar(5);
ALTER TABLE form_reviewofs CHANGE hyperthyroidism hyperthyroidism varchar(5);
ALTER TABLE form_reviewofs CHANGE cushing_syndrom cushing_syndrom varchar(5);
ALTER TABLE form_reviewofs CHANGE addison_syndrom addison_syndrom varchar(5);
#EndIf
#IfTable gacl_phpgacl
ALTER TABLE gacl_phpgacl MODIFY value varchar(150) NOT NULL;
#EndIf
#IfTable gacl_acl
ALTER TABLE gacl_acl MODIFY section_value varchar(150) NOT NULL default 'system';
#EndIf
#IfTable gacl_acl_sections
ALTER TABLE gacl_acl_sections MODIFY value varchar(150) NOT NULL;
#EndIf
#IfTable gacl_aco
ALTER TABLE gacl_aco MODIFY section_value varchar(150) NOT NULL default '0';
ALTER TABLE gacl_aco MODIFY value varchar(150) NOT NULL;
#EndIf
#IfTable gacl_aco_map
ALTER TABLE gacl_aco_map MODIFY section_value varchar(150) NOT NULL default '0';
ALTER TABLE gacl_aco_map MODIFY value varchar(150) NOT NULL;
#EndIf
#IfTable gacl_aco_sections
ALTER TABLE gacl_aco_sections MODIFY value varchar(150) NOT NULL;
#EndIf
#IfTable gacl_aro
ALTER TABLE gacl_aro MODIFY section_value varchar(150) NOT NULL default '0';
ALTER TABLE gacl_aro MODIFY value varchar(150) NOT NULL;
#EndIf
#IfTable gacl_aro_map
ALTER TABLE gacl_aro_map MODIFY section_value varchar(150) NOT NULL default '0';
ALTER TABLE gacl_aro_map MODIFY value varchar(150) NOT NULL;
#EndIf
#IfTable gacl_aro_sections
ALTER TABLE gacl_aro_sections MODIFY value varchar(150) NOT NULL;
#EndIf
#IfTable gacl_axo
ALTER TABLE gacl_axo MODIFY section_value varchar(150) NOT NULL default '0';
ALTER TABLE gacl_axo MODIFY value varchar(150) NOT NULL;
#EndIf
#IfTable gacl_axo_map
ALTER TABLE gacl_axo_map MODIFY section_value varchar(150) NOT NULL default '0';
ALTER TABLE gacl_axo_map MODIFY value varchar(150) NOT NULL;
#EndIf
#IfTable gacl_axo_sections
ALTER TABLE gacl_axo_sections MODIFY value varchar(150) NOT NULL;
#EndIf
#IfTable gacl_aro_groups
ALTER TABLE gacl_aro_groups MODIFY value varchar(150) NOT NULL;
#EndIf
#IfTable gacl_axo_groups
ALTER TABLE gacl_axo_groups MODIFY value varchar(150) NOT NULL;
#EndIf