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

(-)a/installer/data/mysql/kohastructure.sql (+2 lines)
Lines 265-270 CREATE TABLE `borrowers` ( -- this table includes information about your patrons Link Here
265
  `altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower
265
  `altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower
266
  `smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on)
266
  `smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on)
267
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history
267
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history
268
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)
268
  UNIQUE KEY `cardnumber` (`cardnumber`),
269
  UNIQUE KEY `cardnumber` (`cardnumber`),
269
  PRIMARY KEY `borrowernumber` (`borrowernumber`),
270
  PRIMARY KEY `borrowernumber` (`borrowernumber`),
270
  KEY `categorycode` (`categorycode`),
271
  KEY `categorycode` (`categorycode`),
Lines 876-881 CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower Link Here
876
  `altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower
877
  `altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower
877
  `smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on)
878
  `smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on)
878
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history  KEY `borrowernumber` (`borrowernumber`),
879
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history  KEY `borrowernumber` (`borrowernumber`),
880
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)
879
  KEY borrowernumber (borrowernumber),
881
  KEY borrowernumber (borrowernumber),
880
  KEY `cardnumber` (`cardnumber`)
882
  KEY `cardnumber` (`cardnumber`)
881
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
883
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +12 lines)
Lines 9438-9443 if ( CheckVersion($DBversion) ) { Link Here
9438
   SetVersion ($DBversion);
9438
   SetVersion ($DBversion);
9439
}
9439
}
9440
9440
9441
$DBversion = "3.17.00.XXX";
9442
if ( CheckVersion($DBversion) ) {
9443
    $dbh->do(q|
9444
ALTER TABLE borrowers ADD COLUMN timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER privacy;
9445
    |);
9446
    $dbh->do(q|
9447
ALTER TABLE deletedborrowers ADD COLUMN timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER privacy;
9448
    |);
9449
    print "Upgrade to $DBversion done (Bug 10459: Borrowers should have a timestamp)\n";
9450
    SetVersion($DBversion);
9451
}
9452
9441
=head1 FUNCTIONS
9453
=head1 FUNCTIONS
9442
9454
9443
=head2 TableExists($table)
9455
=head2 TableExists($table)
9444
- 

Return to bug 10459