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

(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 1670-1676 CREATE TABLE `borrowers` ( -- this table includes information about your patrons Link Here
1670
  `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
1670
  `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
1671
  `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'.
1671
  `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'.
1672
  `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)
1672
  `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)
1673
  `lastseen` datetime default NULL, -- last time a patron has been seed (connected at the OPAC or staff interface)
1673
  `lastseen` datetime default NULL, -- last time a patron has been seen (connected at the OPAC or staff interface)
1674
  `lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron
1674
  `lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron
1675
  `login_attempts` int(4) default 0, -- number of failed login attemps
1675
  `login_attempts` int(4) default 0, -- number of failed login attemps
1676
  `overdrive_auth_token` text default NULL, -- persist OverDrive auth token
1676
  `overdrive_auth_token` text default NULL, -- persist OverDrive auth token
1677
- 

Return to bug 18848