Attachment #127797 for bug #21729

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




use Modern::Perl;

return {
    bug_number => "21729",
    description => "Add new column reserves.patron_expiration_date",
    up => sub {
        my ($args) = @_;
        my ($dbh, $out) = @$args{qw(dbh out)};
        unless( column_exists('reserves', 'patron_expiration_date') ) {
            $dbh->do(q{
                ALTER TABLE reserves
                ADD COlUMN patron_expiration_date date DEFAULT NULL COMMENT 'the date the hold expires - usually the date entered by the patron to say they don''t need the hold after a certain date'
                AFTER expirationdate
            });
        }
        unless( column_exists('old_reserves', 'patron_expiration_date') ) {
            $dbh->do(q{
                ALTER TABLE old_reserves
                ADD COlUMN patron_expiration_date date DEFAULT NULL COMMENT 'the date the hold expires - usually the date entered by the patron to say they don''t need the hold after a certain date'
                AFTER expirationdate
            });
        }

    },
}




  `itemnumber` int(11) DEFAULT NULL COMMENT 'foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with',
  `waitingdate` date DEFAULT NULL COMMENT 'the date the item was marked as waiting for the patron at the library',
  `expirationdate` date DEFAULT NULL COMMENT 'the date the hold expires (usually the date entered by the patron to say they don''t need the hold after a certain date)',
  `patron_expiration_date` date DEFAULT NULL COMMENT 'the date the hold expires - usually the date entered by the patron to say they don''t need the hold after a certain date',
  `lowestPriority` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no)',
  `suspend` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'in this hold suspended (1 for yes, 0 for no)',
  `suspend_until` datetime DEFAULT NULL COMMENT 'the date this hold is suspended until (NULL for infinitely)',

  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'the date and time this hold was last updated',
  `itemnumber` int(11) DEFAULT NULL COMMENT 'foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with',
  `waitingdate` date DEFAULT NULL COMMENT 'the date the item was marked as waiting for the patron at the library',
  `expirationdate` date DEFAULT NULL COMMENT 'the date the hold expires (calculated value)',
  `patron_expiration_date` date DEFAULT NULL COMMENT 'the date the hold expires - usually the date entered by the patron to say they don''t need the hold after a certain date',
  `lowestPriority` tinyint(1) NOT NULL DEFAULT 0,
  `suspend` tinyint(1) NOT NULL DEFAULT 0,
  `suspend_until` datetime DEFAULT NULL,
- 

Return to bug 21729

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_21729.pl (+25 lines)
	1	use Modern::Perl;
	2
	3	return {
	4	bug_number => "21729",
	5	description => "Add new column reserves.patron_expiration_date",
	6	up => sub {
	7	my ($args) = @_;
	8	my ($dbh, $out) = @$args{qw(dbh out)};
	9	unless( column_exists('reserves', 'patron_expiration_date') ) {
	10	$dbh->do(q{
	11	ALTER TABLE reserves
	12	ADD COlUMN patron_expiration_date date DEFAULT NULL COMMENT 'the date the hold expires - usually the date entered by the patron to say they don''t need the hold after a certain date'
	13	AFTER expirationdate
	14	});
	15	}
	16	unless( column_exists('old_reserves', 'patron_expiration_date') ) {
	17	$dbh->do(q{
	18	ALTER TABLE old_reserves
	19	ADD COlUMN patron_expiration_date date DEFAULT NULL COMMENT 'the date the hold expires - usually the date entered by the patron to say they don''t need the hold after a certain date'
	20	AFTER expirationdate
	21	});
	22	}
	23
	24	},
	25	}

Lines 3895-3900 CREATE TABLE `old_reserves` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-2 / +3 lines)
3895	`itemnumber` int(11) DEFAULT NULL COMMENT 'foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with',	3895	`itemnumber` int(11) DEFAULT NULL COMMENT 'foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with',
3896	`waitingdate` date DEFAULT NULL COMMENT 'the date the item was marked as waiting for the patron at the library',	3896	`waitingdate` date DEFAULT NULL COMMENT 'the date the item was marked as waiting for the patron at the library',
3897	`expirationdate` date DEFAULT NULL COMMENT 'the date the hold expires (usually the date entered by the patron to say they don''t need the hold after a certain date)',	3897	`expirationdate` date DEFAULT NULL COMMENT 'the date the hold expires (usually the date entered by the patron to say they don''t need the hold after a certain date)',
		3898	`patron_expiration_date` date DEFAULT NULL COMMENT 'the date the hold expires - usually the date entered by the patron to say they don''t need the hold after a certain date',
3898	`lowestPriority` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no)',	3899	`lowestPriority` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no)',
3899	`suspend` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'in this hold suspended (1 for yes, 0 for no)',	3900	`suspend` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'in this hold suspended (1 for yes, 0 for no)',
3900	`suspend_until` datetime DEFAULT NULL COMMENT 'the date this hold is suspended until (NULL for infinitely)',	3901	`suspend_until` datetime DEFAULT NULL COMMENT 'the date this hold is suspended until (NULL for infinitely)',
Lines 4337-4343 CREATE TABLE `reserves` ( Link Here
4337	`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'the date and time this hold was last updated',	4338	`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'the date and time this hold was last updated',
4338	`itemnumber` int(11) DEFAULT NULL COMMENT 'foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with',	4339	`itemnumber` int(11) DEFAULT NULL COMMENT 'foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with',
4339	`waitingdate` date DEFAULT NULL COMMENT 'the date the item was marked as waiting for the patron at the library',	4340	`waitingdate` date DEFAULT NULL COMMENT 'the date the item was marked as waiting for the patron at the library',
4340	`expirationdate` date DEFAULT NULL COMMENT 'the date the hold expires (usually the date entered by the patron to say they don''t need the hold after a certain date)',	4341	`expirationdate` date DEFAULT NULL COMMENT 'the date the hold expires (calculated value)',
		4342	`patron_expiration_date` date DEFAULT NULL COMMENT 'the date the hold expires - usually the date entered by the patron to say they don''t need the hold after a certain date',
4341	`lowestPriority` tinyint(1) NOT NULL DEFAULT 0,	4343	`lowestPriority` tinyint(1) NOT NULL DEFAULT 0,
4342	`suspend` tinyint(1) NOT NULL DEFAULT 0,	4344	`suspend` tinyint(1) NOT NULL DEFAULT 0,
4343	`suspend_until` datetime DEFAULT NULL,	4345	`suspend_until` datetime DEFAULT NULL,
4344	-