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

(-)a/installer/data/mysql/atomicupdate/bug_30392.pl (-2 / +2 lines)
Lines 9-22 return { Link Here
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
        }
(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
Lines 2650-2656 CREATE TABLE `deleteditems` ( Link Here
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
- 

Return to bug 30392