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

(-)a/installer/data/mysql/atomicupdate/bug_37934.pl (+26 lines)
Line 0 Link Here
1
use Modern::Perl;
2
use Koha::Installer::Output qw(say_warning say_success say_info);
3
4
return {
5
    bug_number  => "37934",
6
    description => "Extend storable data for customer ID, requestor ID and API Key for ERM data providers",
7
    up          => sub {
8
        my ($args) = @_;
9
        my ( $dbh, $out ) = @$args{qw(dbh out)};
10
11
        $dbh->do(
12
            q{ALTER TABLE erm_usage_data_providers MODIFY COLUMN customer_id text DEFAULT NULL COMMENT 'SUSHI customer ID'}
13
        );
14
        say_success( $out, "Updated erm_usage_data_providers.customer_id to datatype text" );
15
16
        $dbh->do(
17
            q{ALTER TABLE erm_usage_data_providers MODIFY COLUMN requestor_id text DEFAULT NULL COMMENT 'SUSHI requestor ID'}
18
        );
19
        say_success( $out, "Updated erm_usage_data_providers.requestor_id to datatype text" );
20
21
        $dbh->do(
22
            q{ALTER TABLE erm_usage_data_providers MODIFY COLUMN api_key text DEFAULT NULL COMMENT 'SUSHI API key'});
23
        say_success( $out, "Updated erm_usage_data_providers.api_key to datatype text" );
24
25
    },
26
};
(-)a/installer/data/mysql/kohastructure.sql (-5 / +4 lines)
Lines 3261-3269 CREATE TABLE `erm_usage_data_providers` ( Link Here
3261
  `service_type` varchar(80) DEFAULT NULL COMMENT 'service_type of the harvester',
3261
  `service_type` varchar(80) DEFAULT NULL COMMENT 'service_type of the harvester',
3262
  `service_url` varchar(80) DEFAULT NULL COMMENT 'service_url of the harvester',
3262
  `service_url` varchar(80) DEFAULT NULL COMMENT 'service_url of the harvester',
3263
  `report_release` varchar(80) DEFAULT NULL COMMENT 'report_release of the harvester',
3263
  `report_release` varchar(80) DEFAULT NULL COMMENT 'report_release of the harvester',
3264
  `customer_id` varchar(50) DEFAULT NULL COMMENT 'sushi customer id',
3264
  `customer_id` text DEFAULT NULL COMMENT 'SUSHI customer ID',
3265
  `requestor_id` varchar(50) DEFAULT NULL COMMENT 'sushi requestor id',
3265
  `requestor_id` text DEFAULT NULL COMMENT 'SUSHI requestor ID',
3266
  `api_key` varchar(80) DEFAULT NULL COMMENT 'sushi api key',
3266
  `api_key` text DEFAULT NULL COMMENT 'SUSHI API key',
3267
  `requestor_name` varchar(80) DEFAULT NULL COMMENT 'requestor name',
3267
  `requestor_name` varchar(80) DEFAULT NULL COMMENT 'requestor name',
3268
  `requestor_email` varchar(80) DEFAULT NULL COMMENT 'requestor email',
3268
  `requestor_email` varchar(80) DEFAULT NULL COMMENT 'requestor email',
3269
  `report_types` varchar(255) DEFAULT NULL COMMENT 'report types provided by the harvester',
3269
  `report_types` varchar(255) DEFAULT NULL COMMENT 'report types provided by the harvester',
Lines 6796-6799 CREATE TABLE `zebraqueue` ( Link Here
6796
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
6796
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
6797
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
6797
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
6798
6798
6799
-- Dump completed on 2024-11-25 12:13:27
6799
-- Dump completed on 2024-11-25 12:13:27
6800
- 

Return to bug 37934