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

(-)a/installer/data/mysql/atomicupdate/bug_27726.perl (+6 lines)
Line 0 Link Here
1 
$DBversion = 'XXX'; # will be replaced by the RM
2 
if( CheckVersion( $DBversion ) ) {
3 
    $dbh->do("ALTER TABLE problem_reports MODIFY content TEXT NOT NULL");
4 

            

            

              5
              
    NewVersion( $DBversion, 27726, "Increase field size for problem_reports.content");

            

            

              6
              
}

            



(-)a/installer/data/mysql/kohastructure.sql
      (-2 / +1 lines)




  

    
      
            Lines 4132-4138
          DROP TABLE IF EXISTS `problem_reports`;
      
      
        Link Here
      
    
  

        

          4132
          
CREATE TABLE `problem_reports` (

          4132
          
CREATE TABLE `problem_reports` (

        

        

          4133
          
  `reportid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha',

          4133
          
  `reportid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha',

        

        

          4134
          
  `title` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'report subject line',

          4134
          
  `title` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'report subject line',

        

          
            

              4135
              
  `content` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'report message content',


              4135
              
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'report message content',

            

        

          4136
          
  `borrowernumber` int(11) NOT NULL DEFAULT 0 COMMENT 'the user who created the problem report',

          4136
          
  `borrowernumber` int(11) NOT NULL DEFAULT 0 COMMENT 'the user who created the problem report',

        

        

          4137
          
  `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'borrower''s branch',

          4137
          
  `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'borrower''s branch',

        

        

          4138
          
  `username` varchar(75) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'OPAC username',

          4138
          
  `username` varchar(75) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'OPAC username',

        

            

              4139
              
- 

              
              
            






  

  Return to bug 27726