Attachment #138483 for bug #30392

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




        unless ( column_exists('items', 'deleted_on') ) {
            $dbh->do(q{
                ALTER TABLE items
                ADD COLUMN deleted_on DATETIME DEFAULT NULL COMMENT 'date/time of deletion'
                AFTER timestamp
            });
        }
        unless ( column_exists('deleteditems', 'deleted_on') ) {
            $dbh->do(q{
                ALTER TABLE deleteditems
                ADD COLUMN deleted_on DATETIME DEFAULT NULL COMMENT 'date/time of deletion'
                AFTER timestamp
            });
        }

Return to bug 30392

Lines 9-22 return { Link Here

(-)a/installer/data/mysql/atomicupdate/bug_30392.pl (-2 / +2 lines)
9	unless ( column_exists('items', 'deleted_on') ) {	9	unless ( column_exists('items', 'deleted_on') ) {
10	$dbh->do(q{	10	$dbh->do(q{
11	ALTER TABLE items	11	ALTER TABLE items
12	ADD COLUMN deleted_on DATETIME DEFAULT NULL COMMENT 'date of the deletion'	12	ADD COLUMN deleted_on DATETIME DEFAULT NULL COMMENT 'date/time of deletion'
13	AFTER timestamp	13	AFTER timestamp
14	});	14	});
15	}	15	}
16	unless ( column_exists('deleteditems', 'deleted_on') ) {	16	unless ( column_exists('deleteditems', 'deleted_on') ) {
17	$dbh->do(q{	17	$dbh->do(q{
18	ALTER TABLE deleteditems	18	ALTER TABLE deleteditems
19	ADD COLUMN deleted_on DATETIME DEFAULT NULL COMMENT 'date of the deletion'	19	ADD COLUMN deleted_on DATETIME DEFAULT NULL COMMENT 'date/time of deletion'
20	AFTER timestamp	20	AFTER timestamp
21	});	21	});
22	}	22	}

Lines 2650-2656 CREATE TABLE `deleteditems` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
2650	`itemnotes_nonpublic` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'non-public notes on this item (MARC21 952$x)',	2650	`itemnotes_nonpublic` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'non-public notes on this item (MARC21 952$x)',
2651	`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)',	2651	`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)',
2652	`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time this item was last altered',	2652	`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time this item was last altered',
2653	`deleted_on` DATETIME DEFAULT NULL COMMENT 'date of the deletion',	2653	`deleted_on` DATETIME DEFAULT NULL COMMENT 'date/time of deletion',
2654	`location` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)',	2654	`location` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)',
2655	`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',	2655	`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',
2656	`onloan` date DEFAULT NULL COMMENT 'defines if item is checked out (NULL for not checked out, and due date for checked out)',	2656	`onloan` date DEFAULT NULL COMMENT 'defines if item is checked out (NULL for not checked out, and due date for checked out)',
Lines 3212-3218 CREATE TABLE `items` ( Link Here
3212	`itemnotes_nonpublic` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'non-public notes on this item (MARC21 952$x)',	3212	`itemnotes_nonpublic` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'non-public notes on this item (MARC21 952$x)',
3213	`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)',	3213	`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)',
3214	`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time this item was last altered',	3214	`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time this item was last altered',
3215	`deleted_on` DATETIME DEFAULT NULL COMMENT 'date of the deletion',	3215	`deleted_on` DATETIME DEFAULT NULL COMMENT 'date/time of deletion',
3216	`location` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)',	3216	`location` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)',
3217	`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',	3217	`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',
3218	`onloan` date DEFAULT NULL COMMENT 'defines if item is checked out (NULL for not checked out, and due date for checked out)',	3218	`onloan` date DEFAULT NULL COMMENT 'defines if item is checked out (NULL for not checked out, and due date for checked out)',
3219	-