1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
#
# Patch for 0.60 - 0.62
#
# Update External type, to prevent check-out of External items
UPDATE s_status_type SET borrow_ind = 'B' WHERE s_status_type = 'X';
# Update to have correct description
UPDATE s_status_type SET description = 'Available' WHERE s_status_type = 'A';
UPDATE s_status_type SET description = 'Inactive' WHERE s_status_type = 'N';
#
# A bug in System Admin Tool for 0.60 releases
#
UPDATE s_attribute_type SET s_field_type = UPPER(s_field_type) WHERE s_field_type IS NOT NULL;
#
# Need to increase size of language and theme columns in database
# as there are already themes which have exceeded the previous
# 10 character limit.
#
ALTER TABLE user CHANGE language language varchar(20);
ALTER TABLE user CHANGE theme theme varchar(20);
|
