Attachment #33421 for bug #10459

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

Lines 264-270 CREATE TABLE `borrowers` ( -- this table includes information about your patrons Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
264	`altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower	264	`altcontactcountry` text default NULL, -- the country 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	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`),




    SetVersion($DBversion);
}


$DBversion = "3.17.00.XXX";
if ( CheckVersion($DBversion) ) {
    $dbh->do(q|
ALTER TABLE borrowers ADD COLUMN timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER privacy;
    |);
    print "Upgrade to $DBversion done (Bug 10459: Borrowers should have a timestamp)\n";
    SetVersion($DBversion);
}

=head1 FUNCTIONS

=head2 TableExists($table)
- 

Return to bug 10459

Lines 9418-9423 if ( CheckVersion($DBversion) ) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +10 lines)
9418	SetVersion($DBversion);	9418	SetVersion($DBversion);
9419	}	9419	}
9420		9420
		9421
		9422	$DBversion = "3.17.00.XXX";
		9423	if ( CheckVersion($DBversion) ) {
		9424	$dbh->do(q\|
		9425	ALTER TABLE borrowers ADD COLUMN timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER privacy;
		9426	\|);
		9427	print "Upgrade to $DBversion done (Bug 10459: Borrowers should have a timestamp)\n";
		9428	SetVersion($DBversion);
		9429	}
		9430
9421	=head1 FUNCTIONS	9431	=head1 FUNCTIONS
9422		9432
9423	=head2 TableExists($table)	9433	=head2 TableExists($table)
9424	-