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

(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 635-642 CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower Link Here
635
  `checkprevcheckout` varchar(7) NOT NULL default 'inherit', -- produce a warning for this patron if this item has previously been checked out to this patron if 'yes', not if 'no', defer to category setting if 'inherit'.
635
  `checkprevcheckout` varchar(7) NOT NULL default 'inherit', -- produce a warning for this patron if this item has previously been checked out to this patron if 'yes', not if 'no', defer to category setting if 'inherit'.
636
  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)
636
  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)
637
  `lastseen` datetime default NULL, -- last time a patron has been seen (connected at the OPAC or staff interface)
637
  `lastseen` datetime default NULL, -- last time a patron has been seen (connected at the OPAC or staff interface)
638
  `lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron
639
  `login_attempts` int(4) default 0, -- number of failed login attemps
638
  `login_attempts` int(4) default 0, -- number of failed login attemps
639
  `lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron
640
  `overdrive_auth_token` text default NULL, -- persist OverDrive auth token
640
  `overdrive_auth_token` text default NULL, -- persist OverDrive auth token
641
  KEY borrowernumber (borrowernumber),
641
  KEY borrowernumber (borrowernumber),
642
  KEY `cardnumber` (`cardnumber`),
642
  KEY `cardnumber` (`cardnumber`),
Lines 1673-1680 CREATE TABLE `borrowers` ( -- this table includes information about your patrons Link Here
1673
  `checkprevcheckout` varchar(7) NOT NULL default 'inherit', -- produce a warning for this patron if this item has previously been checked out to this patron if 'yes', not if 'no', defer to category setting if 'inherit'.
1673
  `checkprevcheckout` varchar(7) NOT NULL default 'inherit', -- produce a warning for this patron if this item has previously been checked out to this patron if 'yes', not if 'no', defer to category setting if 'inherit'.
1674
  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)
1674
  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)
1675
  `lastseen` datetime default NULL, -- last time a patron has been seen (connected at the OPAC or staff interface)
1675
  `lastseen` datetime default NULL, -- last time a patron has been seen (connected at the OPAC or staff interface)
1676
  `lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron
1677
  `login_attempts` int(4) default 0, -- number of failed login attemps
1676
  `login_attempts` int(4) default 0, -- number of failed login attemps
1677
  `lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron
1678
  `overdrive_auth_token` text default NULL, -- persist OverDrive auth token
1678
  `overdrive_auth_token` text default NULL, -- persist OverDrive auth token
1679
  UNIQUE KEY `cardnumber` (`cardnumber`),
1679
  UNIQUE KEY `cardnumber` (`cardnumber`),
1680
  PRIMARY KEY `borrowernumber` (`borrowernumber`),
1680
  PRIMARY KEY `borrowernumber` (`borrowernumber`),
(-)a/t/db_dependent/Koha/Patrons.t (-2 / +1 lines)
Lines 261-267 subtest 'renew_account' => sub { Link Here
261
            value  => {
261
            value  => {
262
                dateexpiry   => $a_month_ago,
262
                dateexpiry   => $a_month_ago,
263
                categorycode => $patron_category->{categorycode},
263
                categorycode => $patron_category->{categorycode},
264
                date_renewed => undef, # Force builder to not popular the column for new patron
264
                date_renewed => undef, # Force builder to not populate the column for new patron
265
            }
265
            }
266
        }
266
        }
267
    );
267
    );
268
- 

Return to bug 6758