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

(-)a/installer/data/mysql/atomicupdate/bug_33368.pl (+22 lines)
Line 0 Link Here
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
};
(-)a/installer/data/mysql/kohastructure.sql (-4 / +3 lines)
Lines 1327-1333 CREATE TABLE `borrower_modifications` ( Link Here
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
- 

Return to bug 33368