#
# Patch for 0.61 - 0.62
#

#
# 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);

# 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';
