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

(-)a/installer/data/mysql/atomicupdate/bug_22456.pl (+21 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number  => "22456",
5
    description => "Allow cancelling waiting holds",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
10
        unless ( TableExists( 'hold_cancellation_requests' ) ) {
11
            $dbh->do(q{
12
                CREATE TABLE `hold_cancellation_requests` (
13
                `hold_cancellation_request_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique ID of the cancellation request',
14
                `hold_id` int(11) NOT null COMMENT 'ID of the hold',
15
                `creation_date` timestamp NULL DEFAULT NULL COMMENT 'Time and date the cancellation request was created',
16
                PRIMARY KEY (`hold_cancellation_request_id`)
17
                ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
18
            });
19
        }
20
    },
21
};
(-)a/installer/data/mysql/kohastructure.sql (-1 / +15 lines)
Lines 4419-4424 CREATE TABLE `reserves` ( Link Here
4419
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4419
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4420
/*!40101 SET character_set_client = @saved_cs_client */;
4420
/*!40101 SET character_set_client = @saved_cs_client */;
4421
4421
4422
--
4423
-- Table structure for table `hold_cancellation_requests`
4424
--
4425
4426
DROP TABLE IF EXISTS `hold_cancellation_requests`;
4427
/*!40101 SET @saved_cs_client     = @@character_set_client */;
4428
/*!40101 SET character_set_client = utf8 */;
4429
CREATE TABLE `hold_cancellation_requests` (
4430
  `hold_cancellation_request_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique ID of the cancellation request',
4431
  `hold_id` int(11) NOT null COMMENT 'ID of the hold',
4432
  `creation_date` timestamp NULL DEFAULT NULL COMMENT 'Time and date the cancellation request was created',
4433
  PRIMARY KEY (`hold_cancellation_request_id`)
4434
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4435
/*!40101 SET character_set_client = @saved_cs_client */;
4436
4422
--
4437
--
4423
-- Table structure for table `return_claims`
4438
-- Table structure for table `return_claims`
4424
--
4439
--
4425
- 

Return to bug 22456