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

(-)a/installer/data/mysql/atomicupdate/bug_29605.pl (+8 lines)
Lines 51-56 return { Link Here
51
        );
51
        );
52
        say $out "Ensure additional_contents.code is VARCHAR(100)";
52
        say $out "Ensure additional_contents.code is VARCHAR(100)";
53
53
54
        $dbh->do(
55
            q{
56
                ALTER TABLE `additional_contents`
57
                MODIFY COLUMN `lang` VARCHAR(50) NOT NULL DEFAULT ''
58
            }
59
        );
60
        say $out "Ensure additional_contents.lang is VARCHAR(50)";
61
54
    },
62
    },
55
63
56
}
64
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 196-202 CREATE TABLE `additional_contents` ( Link Here
196
  `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'branch code users to create branch specific additional content, NULL is every branch.',
196
  `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'branch code users to create branch specific additional content, NULL is every branch.',
197
  `title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'title of the additional content',
197
  `title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'title of the additional content',
198
  `content` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'the body of your additional content',
198
  `content` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'the body of your additional content',
199
  `lang` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'location for the additional content(koha is the staff interface, slip is the circulation receipt and language codes are for the opac)',
199
  `lang` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'location for the additional content(koha is the staff interface, slip is the circulation receipt and language codes are for the opac)',
200
  `published_on` date DEFAULT NULL COMMENT 'publication date',
200
  `published_on` date DEFAULT NULL COMMENT 'publication date',
201
  `updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'last modification',
201
  `updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'last modification',
202
  `expirationdate` date DEFAULT NULL COMMENT 'date the additional content is set to expire or no longer be visible',
202
  `expirationdate` date DEFAULT NULL COMMENT 'date the additional content is set to expire or no longer be visible',
203
- 

Return to bug 29605