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 NOT NULL DEFAULT current_timestamp() 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 4493-4498 CREATE TABLE `reserves` ( Link Here
4493
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4493
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4494
/*!40101 SET character_set_client = @saved_cs_client */;
4494
/*!40101 SET character_set_client = @saved_cs_client */;
4495
4495
4496
--
4497
-- Table structure for table `hold_cancellation_requests`
4498
--
4499
4500
DROP TABLE IF EXISTS `hold_cancellation_requests`;
4501
/*!40101 SET @saved_cs_client     = @@character_set_client */;
4502
/*!40101 SET character_set_client = utf8 */;
4503
CREATE TABLE `hold_cancellation_requests` (
4504
  `hold_cancellation_request_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique ID of the cancellation request',
4505
  `hold_id` int(11) NOT null COMMENT 'ID of the hold',
4506
  `creation_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Time and date the cancellation request was created',
4507
  PRIMARY KEY (`hold_cancellation_request_id`)
4508
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4509
/*!40101 SET character_set_client = @saved_cs_client */;
4510
4496
--
4511
--
4497
-- Table structure for table `return_claims`
4512
-- Table structure for table `return_claims`
4498
--
4513
--
4499
- 

Return to bug 22456