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

(-)a/installer/data/mysql/atomicupdate/bug_39835.pl (+9 lines)
Lines 32-36 return { Link Here
32
            MODIFY COLUMN `debarred3` tinyint(1) DEFAULT 0 COMMENT 'is the patron restricted when the third notice is sent (1 for yes, 0 for no)'
32
            MODIFY COLUMN `debarred3` tinyint(1) DEFAULT 0 COMMENT 'is the patron restricted when the third notice is sent (1 for yes, 0 for no)'
33
        }
33
        }
34
        );
34
        );
35
36
        $dbh->do(
37
            q{
38
            ALTER TABLE `columns_settings`
39
            MODIFY COLUMN `cannot_be_toggled` tinyint(1) NOT NULL DEFAULT 0,
40
            MODIFY COLUMN `is_hidden` tinyint(1) NOT NULL DEFAULT 0
41
            }
42
        );
43
35
    },
44
    },
36
};
45
};
(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
Lines 2206-2213 CREATE TABLE `columns_settings` ( Link Here
2206
  `page` varchar(255) NOT NULL,
2206
  `page` varchar(255) NOT NULL,
2207
  `tablename` varchar(255) NOT NULL,
2207
  `tablename` varchar(255) NOT NULL,
2208
  `columnname` varchar(255) NOT NULL,
2208
  `columnname` varchar(255) NOT NULL,
2209
  `cannot_be_toggled` int(1) NOT NULL DEFAULT 0,
2209
  `cannot_be_toggled` tinyint(1) NOT NULL DEFAULT 0,
2210
  `is_hidden` int(1) NOT NULL DEFAULT 0,
2210
  `is_hidden` tinyint(1) NOT NULL DEFAULT 0,
2211
  PRIMARY KEY (`module`(191),`page`(191),`tablename`(191),`columnname`(191))
2211
  PRIMARY KEY (`module`(191),`page`(191),`tablename`(191),`columnname`(191))
2212
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2212
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2213
/*!40101 SET character_set_client = @saved_cs_client */;
2213
/*!40101 SET character_set_client = @saved_cs_client */;
2214
- 

Return to bug 39835