Attachment #109520 for bug #23816

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




$DBversion = 'XXX'; # will be replaced by the RM
if( CheckVersion( $DBversion ) ) {
    # you can use $dbh here like:
    # $dbh->do( "ALTER TABLE biblio ADD COLUMN badtaste int" );
    if( !column_exists( 'categories', 'min_password_length' ) ) {
        $dbh->do("ALTER TABLE categories ADD COLUMN `min_password_length` smallint(6) NULL DEFAULT NULL AFTER `change_password` -- set minimum password length for patrons in this category");
    }
    if( !column_exists( 'categories', 'require_strong_password' ) ) {
        $dbh->do("ALTER TABLE categories ADD COLUMN `require_strong_password` TINYINT(1) NULL DEFAULT NULL AFTER `min_password_length` -- set required password strength for patrons in this category");
    }

    # Always end with this (adjust the bug info)
    NewVersion( $DBversion, 23816, "Add min_password_length and require_strong_password columns in categories table");
}

Lines 328-333 CREATE TABLE `categories` ( -- this table shows information related to Koha patr Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
328	`reset_password` TINYINT(1) NULL DEFAULT NULL, -- if patrons of this category can do the password reset flow,	328	`reset_password` TINYINT(1) NULL DEFAULT NULL, -- if patrons of this category can do the password reset flow,
329	`change_password` TINYINT(1) NULL DEFAULT NULL, -- if patrons of this category can change their passwords in the OAPC	329	`change_password` TINYINT(1) NULL DEFAULT NULL, -- if patrons of this category can change their passwords in the OAPC
330	`exclude_from_local_holds_priority` tinyint(1) default NULL, -- Exclude patrons of this category from local holds priority	330	`exclude_from_local_holds_priority` tinyint(1) default NULL, -- Exclude patrons of this category from local holds priority
		331	`min_password_length` smallint(6) NULL DEFAULT NULL, -- set minimum password length for patrons in this category
		332	`require_strong_password` TINYINT(1) NULL DEFAULT NULL, -- set required password strength for patrons in this category
331	PRIMARY KEY (`categorycode`),	333	PRIMARY KEY (`categorycode`),
332	UNIQUE KEY `categorycode` (`categorycode`)	334	UNIQUE KEY `categorycode` (`categorycode`)
333	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;	335	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
334	-

Return to bug 23816

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_23816.perl (+14 lines)
	1	$DBversion = 'XXX'; # will be replaced by the RM
	2	if( CheckVersion( $DBversion ) ) {
	3	# you can use $dbh here like:
	4	# $dbh->do( "ALTER TABLE biblio ADD COLUMN badtaste int" );
	5	if( !column_exists( 'categories', 'min_password_length' ) ) {
	6	$dbh->do("ALTER TABLE categories ADD COLUMN `min_password_length` smallint(6) NULL DEFAULT NULL AFTER `change_password` -- set minimum password length for patrons in this category");
	7	}
	8	if( !column_exists( 'categories', 'require_strong_password' ) ) {
	9	$dbh->do("ALTER TABLE categories ADD COLUMN `require_strong_password` TINYINT(1) NULL DEFAULT NULL AFTER `min_password_length` -- set required password strength for patrons in this category");
	10	}
	11
	12	# Always end with this (adjust the bug info)
	13	NewVersion( $DBversion, 23816, "Add min_password_length and require_strong_password columns in categories table");
	14	}