File: patch.sql

package info (click to toggle)
opendb 0.81p18-2
  • links: PTS
  • area: main
  • in suites: etch, etch-m68k
  • size: 4,716 kB
  • ctags: 6,787
  • sloc: php: 50,213; sql: 3,098; sh: 272; makefile: 54; xml: 48
file content (18 lines) | stat: -rw-r--r-- 614 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
 
#
# 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';