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

(-)a/installer/data/mysql/atomicupdate/bug_20581-add_new_illrequests_status_alias_column.perl (+10 lines)
Line 0 Link Here
1
$DBversion = 'XXX';  # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
4
    $dbh->do( "ALTER TABLE illrequests ADD COLUMN status_alias integer DEFAULT NULL" );
5
    $dbh->do( "ALTER TABLE illrequests ADD CONSTRAINT illrequests_safk FOREIGN KEY (status_alias) REFERENCES authorised_values(id) ON DELETE SET NULL" );
6
    $dbh->do( "INSERT IGNORE INTO authorised_value_categories SET category_name = 'ILLSTATUS'");
7
8
    SetVersion( $DBversion );
9
    print "Upgrade to $DBversion done (Bug 20581 - Allow manual selection of custom ILL request statuses)\n";
10
}
(-)a/installer/data/mysql/en/optional/ill_auth_cat.sql (+1 lines)
Line 0 Link Here
1
INSERT IGNORE INTO authorised_value_categories (category_name) VALUES ('ILLSTATUS');
(-)a/installer/data/mysql/en/optional/ill_auth_cat.txt (+1 lines)
Line 0 Link Here
1
Default ILL request status authorised value category name
(-)a/installer/data/mysql/kohastructure.sql (-1 / +5 lines)
Lines 4130-4135 CREATE TABLE illrequests ( Link Here
4130
    biblio_id integer DEFAULT NULL,             -- Potential bib linked to request
4130
    biblio_id integer DEFAULT NULL,             -- Potential bib linked to request
4131
    branchcode varchar(50) NOT NULL,            -- The branch associated with the request
4131
    branchcode varchar(50) NOT NULL,            -- The branch associated with the request
4132
    status varchar(50) DEFAULT NULL,            -- Current Koha status of request
4132
    status varchar(50) DEFAULT NULL,            -- Current Koha status of request
4133
    status_alias integer DEFAULT NULL,          -- Foreign key to relevant authorised_values.id
4133
    placed date DEFAULT NULL,                   -- Date the request was placed
4134
    placed date DEFAULT NULL,                   -- Date the request was placed
4134
    replied date DEFAULT NULL,                  -- Last API response
4135
    replied date DEFAULT NULL,                  -- Last API response
4135
    updated timestamp DEFAULT CURRENT_TIMESTAMP -- Last modification to request
4136
    updated timestamp DEFAULT CURRENT_TIMESTAMP -- Last modification to request
Lines 4150-4155 CREATE TABLE illrequests ( Link Here
4150
      FOREIGN KEY (`branchcode`)
4151
      FOREIGN KEY (`branchcode`)
4151
      REFERENCES `branches` (`branchcode`)
4152
      REFERENCES `branches` (`branchcode`)
4152
      ON UPDATE CASCADE ON DELETE CASCADE
4153
      ON UPDATE CASCADE ON DELETE CASCADE
4154
    CONSTRAINT `illrequests_safk`
4155
      FOREIGN KEY (`status_alias`)
4156
      REFERENCES `authorised_values` (`id`)
4157
      ON DELETE SET NULL
4153
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4158
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4154
4159
4155
--
4160
--
4156
- 

Return to bug 20581