Attachment #33435 for bug #10459

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




   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;
    |);
    $dbh->do(q|
ALTER TABLE deletedborrowers 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 9438-9443 if ( CheckVersion($DBversion) ) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +12 lines)
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	-

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

(-)a/installer/data/mysql/kohastructure.sql (+2 lines)
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;