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

(-)a/installer/data/mysql/atomicupdate/bug_35635_add_opac_mandatory.pl (-1 / +1 lines)
Lines 11-17 return { Link Here
11
        $dbh->do(
11
        $dbh->do(
12
            q{
12
            q{
13
                ALTER TABLE borrower_attribute_types
13
                ALTER TABLE borrower_attribute_types
14
                MODIFY COLUMN `mandatory` tinyint(1) DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not in the staff client'
14
                MODIFY COLUMN `mandatory` tinyint(1) DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not in the staff interface'
15
            }
15
            }
16
        );
16
        );
17
17
(-)a/installer/data/mysql/kohastructure.sql (-3 / +3 lines)
Lines 1260-1266 CREATE TABLE `borrower_attribute_types` ( Link Here
1260
  `category_code` varchar(10) DEFAULT NULL COMMENT 'defines a category for an attribute_type',
1260
  `category_code` varchar(10) DEFAULT NULL COMMENT 'defines a category for an attribute_type',
1261
  `class` varchar(255) NOT NULL DEFAULT '' COMMENT 'defines a class for an attribute_type',
1261
  `class` varchar(255) NOT NULL DEFAULT '' COMMENT 'defines a class for an attribute_type',
1262
  `keep_for_pseudonymization` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this field is copied to anonymized_borrower_attributes (1 for yes, 0 for no)',
1262
  `keep_for_pseudonymization` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this field is copied to anonymized_borrower_attributes (1 for yes, 0 for no)',
1263
  `mandatory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not',
1263
  `mandatory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not in the staff interface',
1264
  `opac_mandatory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not in the OPAC',
1264
  PRIMARY KEY (`code`),
1265
  PRIMARY KEY (`code`),
1265
  KEY `auth_val_cat_idx` (`authorised_value_category`),
1266
  KEY `auth_val_cat_idx` (`authorised_value_category`),
1266
  KEY `category_code` (`category_code`),
1267
  KEY `category_code` (`category_code`),
Lines 6755-6758 CREATE TABLE `zebraqueue` ( Link Here
6755
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
6756
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
6756
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
6757
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
6757
6758
6758
-- Dump completed on 2024-11-25 12:13:27
6759
-- Dump completed on 2024-11-25 12:13:27
6759
- 

Return to bug 35635