Attachment #138233 for bug #30392

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




use Modern::Perl;

return {
    bug_number => "30392",
    description => "Add deleteditems.deleted_on",
    up => sub {
        my ($args) = @_;
        my ($dbh, $out) = @$args{qw(dbh out)};
        unless ( column_exists('items', 'deleted_on') ) {
            $dbh->do(q{
                ALTER TABLE items
                ADD COLUMN deleted_on DATETIME DEFAULT NULL COMMENT 'date of the deletion'
                AFTER timestamp
            });
        }
        unless ( column_exists('deleteditems', 'deleted_on') ) {
            $dbh->do(q{
                ALTER TABLE deleteditems
                ADD COLUMN deleted_on DATETIME DEFAULT NULL COMMENT 'date of the deletion'
                AFTER timestamp
            });
        }
    },
};

Return to bug 30392

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_30392.pl (+24 lines)
	1	use Modern::Perl;
	2
	3	return {
	4	bug_number => "30392",
	5	description => "Add deleteditems.deleted_on",
	6	up => sub {
	7	my ($args) = @_;
	8	my ($dbh, $out) = @$args{qw(dbh out)};
	9	unless ( column_exists('items', 'deleted_on') ) {
	10	$dbh->do(q{
	11	ALTER TABLE items
	12	ADD COLUMN deleted_on DATETIME DEFAULT NULL COMMENT 'date of the deletion'
	13	AFTER timestamp
	14	});
	15	}
	16	unless ( column_exists('deleteditems', 'deleted_on') ) {
	17	$dbh->do(q{
	18	ALTER TABLE deleteditems
	19	ADD COLUMN deleted_on DATETIME DEFAULT NULL COMMENT 'date of the deletion'
	20	AFTER timestamp
	21	});
	22	}
	23	},
	24	};

Lines 2578-2583 CREATE TABLE `deleteditems` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
2578	`itemnotes_nonpublic` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'non-public notes on this item (MARC21 952$x)',	2578	`itemnotes_nonpublic` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'non-public notes on this item (MARC21 952$x)',
2579	`holdingbranch` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)',	2579	`holdingbranch` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)',
2580	`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time this item was last altered',	2580	`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time this item was last altered',
		2581	`deleted_on` DATETIME DEFAULT NULL COMMENT 'date of the deletion',
2581	`location` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)',	2582	`location` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)',
2582	`permanent_location` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'linked to the CART and PROC temporary locations feature, stores the permanent shelving location',	2583	`permanent_location` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'linked to the CART and PROC temporary locations feature, stores the permanent shelving location',
2583	`onloan` date DEFAULT NULL COMMENT 'defines if item is checked out (NULL for not checked out, and due date for checked out)',	2584	`onloan` date DEFAULT NULL COMMENT 'defines if item is checked out (NULL for not checked out, and due date for checked out)',
Lines 3139-3144 CREATE TABLE `items` ( Link Here
3139	`itemnotes_nonpublic` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'non-public notes on this item (MARC21 952$x)',	3140	`itemnotes_nonpublic` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'non-public notes on this item (MARC21 952$x)',
3140	`holdingbranch` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)',	3141	`holdingbranch` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)',
3141	`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time this item was last altered',	3142	`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time this item was last altered',
		3143	`deleted_on` DATETIME DEFAULT NULL COMMENT 'date of the deletion',
3142	`location` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)',	3144	`location` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)',
3143	`permanent_location` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'linked to the CART and PROC temporary locations feature, stores the permanent shelving location',	3145	`permanent_location` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'linked to the CART and PROC temporary locations feature, stores the permanent shelving location',
3144	`onloan` date DEFAULT NULL COMMENT 'defines if item is checked out (NULL for not checked out, and due date for checked out)',	3146	`onloan` date DEFAULT NULL COMMENT 'defines if item is checked out (NULL for not checked out, and due date for checked out)',
3145	-