Attachment #148952 for bug #33368

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




use Modern::Perl;

return {
    bug_number => "33368",
    description => "Extend borrowers.flags to bigint",
    up => sub {
        my ($args) = @_;
        my ($dbh, $out) = @$args{qw(dbh out)};
        $dbh->do(q{
            ALTER TABLE borrower_modifications
            MODIFY COLUMN `flags` bigint(11)
        });
        $dbh->do(q{
            ALTER TABLE borrowers
            MODIFY COLUMN `flags` bigint(11) DEFAULT NULL COMMENT 'will include a number associated with the staff member''s permissions'
        });
        $dbh->do(q{
            ALTER TABLE deletedborrowers
            MODIFY COLUMN `flags` bigint(11) DEFAULT NULL COMMENT 'will include a number associated with the staff member''s permissions'
        });
    },
};




  `relationship` varchar(100) DEFAULT NULL,
  `sex` varchar(1) DEFAULT NULL,
  `password` varchar(30) DEFAULT NULL,
  `flags` bigint(11) DEFAULT NULL,
  `userid` varchar(75) DEFAULT NULL,
  `opacnote` longtext DEFAULT NULL,
  `contactnote` varchar(255) DEFAULT NULL,

  `password` varchar(60) DEFAULT NULL COMMENT 'patron/borrower''s Bcrypt encrypted password',
  `secret` mediumtext DEFAULT NULL COMMENT 'Secret for 2FA',
  `auth_method` enum('password','two-factor') NOT NULL DEFAULT 'password' COMMENT 'Authentication method',
  `flags` bigint(11) DEFAULT NULL COMMENT 'will include a number associated with the staff member''s permissions',
  `userid` varchar(75) DEFAULT NULL COMMENT 'patron/borrower''s opac and/or staff interface log in',
  `opacnote` longtext DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is visible in the OPAC and staff interface',
  `contactnote` varchar(255) DEFAULT NULL COMMENT 'a note related to the patron/borrower''s alternate address',

  `password` varchar(60) DEFAULT NULL COMMENT 'patron/borrower''s encrypted password',
  `secret` mediumtext DEFAULT NULL COMMENT 'Secret for 2FA',
  `auth_method` enum('password','two-factor') NOT NULL DEFAULT 'password' COMMENT 'Authentication method',
  `flags` bigint(11) DEFAULT NULL COMMENT 'will include a number associated with the staff member''s permissions',
  `userid` varchar(75) DEFAULT NULL COMMENT 'patron/borrower''s opac and/or staff interface log in',
  `opacnote` longtext DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is visible in the OPAC and staff interface',
  `contactnote` varchar(255) DEFAULT NULL COMMENT 'a note related to the patron/borrower''s alternate address',
- 

Return to bug 33368

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_33368.pl (+22 lines)
	1	use Modern::Perl;
	2
	3	return {
	4	bug_number => "33368",
	5	description => "Extend borrowers.flags to bigint",
	6	up => sub {
	7	my ($args) = @_;
	8	my ($dbh, $out) = @$args{qw(dbh out)};
	9	$dbh->do(q{
	10	ALTER TABLE borrower_modifications
	11	MODIFY COLUMN `flags` bigint(11)
	12	});
	13	$dbh->do(q{
	14	ALTER TABLE borrowers
	15	MODIFY COLUMN `flags` bigint(11) DEFAULT NULL COMMENT 'will include a number associated with the staff member''s permissions'
	16	});
	17	$dbh->do(q{
	18	ALTER TABLE deletedborrowers
	19	MODIFY COLUMN `flags` bigint(11) DEFAULT NULL COMMENT 'will include a number associated with the staff member''s permissions'
	20	});
	21	},
	22	};

Lines 1327-1333 CREATE TABLE `borrower_modifications` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-4 / +3 lines)
1327	`relationship` varchar(100) DEFAULT NULL,	1327	`relationship` varchar(100) DEFAULT NULL,
1328	`sex` varchar(1) DEFAULT NULL,	1328	`sex` varchar(1) DEFAULT NULL,
1329	`password` varchar(30) DEFAULT NULL,	1329	`password` varchar(30) DEFAULT NULL,
1330	`flags` int(11) DEFAULT NULL,	1330	`flags` bigint(11) DEFAULT NULL,
1331	`userid` varchar(75) DEFAULT NULL,	1331	`userid` varchar(75) DEFAULT NULL,
1332	`opacnote` longtext DEFAULT NULL,	1332	`opacnote` longtext DEFAULT NULL,
1333	`contactnote` varchar(255) DEFAULT NULL,	1333	`contactnote` varchar(255) DEFAULT NULL,
Lines 1450-1456 CREATE TABLE `borrowers` ( Link Here
1450	`password` varchar(60) DEFAULT NULL COMMENT 'patron/borrower''s Bcrypt encrypted password',	1450	`password` varchar(60) DEFAULT NULL COMMENT 'patron/borrower''s Bcrypt encrypted password',
1451	`secret` mediumtext DEFAULT NULL COMMENT 'Secret for 2FA',	1451	`secret` mediumtext DEFAULT NULL COMMENT 'Secret for 2FA',
1452	`auth_method` enum('password','two-factor') NOT NULL DEFAULT 'password' COMMENT 'Authentication method',	1452	`auth_method` enum('password','two-factor') NOT NULL DEFAULT 'password' COMMENT 'Authentication method',
1453	`flags` int(11) DEFAULT NULL COMMENT 'will include a number associated with the staff member''s permissions',	1453	`flags` bigint(11) DEFAULT NULL COMMENT 'will include a number associated with the staff member''s permissions',
1454	`userid` varchar(75) DEFAULT NULL COMMENT 'patron/borrower''s opac and/or staff interface log in',	1454	`userid` varchar(75) DEFAULT NULL COMMENT 'patron/borrower''s opac and/or staff interface log in',
1455	`opacnote` longtext DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is visible in the OPAC and staff interface',	1455	`opacnote` longtext DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is visible in the OPAC and staff interface',
1456	`contactnote` varchar(255) DEFAULT NULL COMMENT 'a note related to the patron/borrower''s alternate address',	1456	`contactnote` varchar(255) DEFAULT NULL COMMENT 'a note related to the patron/borrower''s alternate address',
Lines 2573-2579 CREATE TABLE `deletedborrowers` ( Link Here
2573	`password` varchar(60) DEFAULT NULL COMMENT 'patron/borrower''s encrypted password',	2573	`password` varchar(60) DEFAULT NULL COMMENT 'patron/borrower''s encrypted password',
2574	`secret` mediumtext DEFAULT NULL COMMENT 'Secret for 2FA',	2574	`secret` mediumtext DEFAULT NULL COMMENT 'Secret for 2FA',
2575	`auth_method` enum('password','two-factor') NOT NULL DEFAULT 'password' COMMENT 'Authentication method',	2575	`auth_method` enum('password','two-factor') NOT NULL DEFAULT 'password' COMMENT 'Authentication method',
2576	`flags` int(11) DEFAULT NULL COMMENT 'will include a number associated with the staff member''s permissions',	2576	`flags` bigint(11) DEFAULT NULL COMMENT 'will include a number associated with the staff member''s permissions',
2577	`userid` varchar(75) DEFAULT NULL COMMENT 'patron/borrower''s opac and/or staff interface log in',	2577	`userid` varchar(75) DEFAULT NULL COMMENT 'patron/borrower''s opac and/or staff interface log in',
2578	`opacnote` longtext DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is visible in the OPAC and staff interface',	2578	`opacnote` longtext DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is visible in the OPAC and staff interface',
2579	`contactnote` varchar(255) DEFAULT NULL COMMENT 'a note related to the patron/borrower''s alternate address',	2579	`contactnote` varchar(255) DEFAULT NULL COMMENT 'a note related to the patron/borrower''s alternate address',
2580	-