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

(-)a/C4/HoldsQueue.pm (-6 / +2 lines)
Lines 167-176 Top level function that turns reserves into tmp_holdsqueue and hold_fill_targets Link Here
167
sub CreateQueue {
167
sub CreateQueue {
168
    my $dbh   = C4::Context->dbh;
168
    my $dbh   = C4::Context->dbh;
169
169
170
    $dbh->do("DROP TABLE IF EXISTS tmp_holdsqueue_builder");
170
    $dbh->do("DELETE FROM tmp_holdsqueue_builder");
171
    $dbh->do("DROP TABLE IF EXISTS hold_fill_targets_builder");
171
    $dbh->do("DELETE FROM hold_fill_targets_builder");
172
    $dbh->do("CREATE TABLE tmp_holdsqueue_builder LIKE tmp_holdsqueue");
173
    $dbh->do("CREATE TABLE hold_fill_targets_builder LIKE hold_fill_targets");
174
172
175
    my $total_bibs            = 0;
173
    my $total_bibs            = 0;
176
    my $total_requests        = 0;
174
    my $total_requests        = 0;
Lines 222-229 sub CreateQueue { Link Here
222
    $dbh->do("DELETE FROM hold_fill_targets");
220
    $dbh->do("DELETE FROM hold_fill_targets");
223
    $dbh->do("INSERT INTO tmp_holdsqueue SELECT * FROM tmp_holdsqueue_builder");
221
    $dbh->do("INSERT INTO tmp_holdsqueue SELECT * FROM tmp_holdsqueue_builder");
224
    $dbh->do("INSERT INTO hold_fill_targets SELECT * FROM hold_fill_targets_builder");
222
    $dbh->do("INSERT INTO hold_fill_targets SELECT * FROM hold_fill_targets_builder");
225
    $dbh->do("DROP TABLE tmp_holdsqueue_builder");
226
    $dbh->do("DROP TABLE hold_fill_targets_builder");
227
    $dbh->commit() unless $do_not_lock;
223
    $dbh->commit() unless $do_not_lock;
228
}
224
}
229
225
(-)a/installer/data/mysql/kohastructure.sql (-1 / +14 lines)
Lines 2631-2636 CREATE TABLE `hold_fill_targets` ( Link Here
2631
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2631
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2632
/*!40101 SET character_set_client = @saved_cs_client */;
2632
/*!40101 SET character_set_client = @saved_cs_client */;
2633
2633
2634
--
2635
-- Table structure for table `hold_fill_targets_builder` is a duplicate of `hold_fill_targets`
2636
--
2637
2638
DROP TABLE IF EXISTS `hold_fill_targets_builder`;
2639
CREATE TABLE hold_fill_targets_builder LIKE tmp_holdsqueue;
2640
2634
--
2641
--
2635
-- Table structure for table `housebound_profile`
2642
-- Table structure for table `housebound_profile`
2636
--
2643
--
Lines 5110-5115 CREATE TABLE `tmp_holdsqueue` ( Link Here
5110
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5117
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5111
/*!40101 SET character_set_client = @saved_cs_client */;
5118
/*!40101 SET character_set_client = @saved_cs_client */;
5112
5119
5120
--
5121
-- Table structure for table `tmp_holdsqueue_builder` is a duplicate of `tmp_holdsqueue`
5122
--
5123
5124
DROP TABLE IF EXISTS `tmp_holdsqueue_builder`;
5125
CREATE TABLE tmp_holdsqueue_builder LIKE tmp_holdsqueue;
5126
5113
--
5127
--
5114
-- Table structure for table `transport_cost`
5128
-- Table structure for table `transport_cost`
5115
--
5129
--
5116
- 

Return to bug 29130