View | Details | Raw Unified | Return to bug 29632
Collapse All | Expand All

(-)a/installer/data/mysql/db_revs/220600017.pl (-2 / +2 lines)
Lines 1-7 Link Here
1
use Modern::Perl;
1
use Modern::Perl;
2
2
3
return {
3
return {
4
    bug_number => "29632    ",
4
    bug_number => "29632",
5
    description => "Add callnumber type to allow sorting",
5
    description => "Add callnumber type to allow sorting",
6
    up => sub {
6
    up => sub {
7
        my ($args) = @_;
7
        my ($args) = @_;
Lines 9-14 return { Link Here
9
        $dbh->do(q{
9
        $dbh->do(q{
10
            ALTER TABLE `search_field` MODIFY COLUMN `type`
10
            ALTER TABLE `search_field` MODIFY COLUMN `type`
11
            enum('','string','date','number','boolean','sum','isbn','stdno','year','callnumber') NOT NULL
11
            enum('','string','date','number','boolean','sum','isbn','stdno','year','callnumber') NOT NULL
12
            COMMENT 'what type of data this holds, relevant when storing it in the search engine'
12
        });
13
        });
13
        say $out "Add callnumber to search_field type enum";
14
        say $out "Add callnumber to search_field type enum";
14
    },
15
    },
15
- 

Return to bug 29632