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

(-)a/installer/data/mysql/atomicupdate/bug31503.pl (+16 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number  => 31503,
5
    description => "Change patron_consent.type",
6
    up          => sub {
7
        my ($args) = @_;
8
        my ( $dbh, $out ) = @$args{qw(dbh out)};
9
10
        $dbh->do(
11
            q{ALTER TABLE `patron_consent` MODIFY `type` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'consent type, could be custom type'}
12
        );
13
14
        say $out "Changed column 'patron_consent.type'";
15
    },
16
};
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 4636-4642 DROP TABLE IF EXISTS `patron_consent`; Link Here
4636
CREATE TABLE `patron_consent` (
4636
CREATE TABLE `patron_consent` (
4637
  `id` int(11) NOT NULL AUTO_INCREMENT,
4637
  `id` int(11) NOT NULL AUTO_INCREMENT,
4638
  `borrowernumber` int(11) NOT NULL,
4638
  `borrowernumber` int(11) NOT NULL,
4639
  `type` enum('GDPR_PROCESSING') DEFAULT NULL COMMENT 'allows for future extension',
4639
  `type` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'consent type, could be custom type',
4640
  `given_on` datetime DEFAULT NULL,
4640
  `given_on` datetime DEFAULT NULL,
4641
  `refused_on` datetime DEFAULT NULL,
4641
  `refused_on` datetime DEFAULT NULL,
4642
  PRIMARY KEY (`id`),
4642
  PRIMARY KEY (`id`),
4643
- 

Return to bug 31503