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

(-)a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbasket.sql (+4 lines)
Line 0 Link Here
1
ALTER IGNORE TABLE `aqbasket`
2
    ADD KEY `authorisedby` (`authorisedby`),
3
    ADD KEY `branch` (`branch`)
4
;
(-)a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbooksellers.sql (+3 lines)
Line 0 Link Here
1
ALTER IGNORE TABLE `aqbooksellers`
2
    ADD KEY `name` (`name`(255))
3
;
(-)a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbudgets.sql (+7 lines)
Line 0 Link Here
1
ALTER IGNORE TABLE `aqbudgets`
2
    ADD KEY `budget_parent_id` (`budget_parent_id`),
3
    ADD KEY `budget_code` (`budget_code`),
4
    ADD KEY `budget_branchcode` (`budget_branchcode`),
5
    ADD KEY `budget_period_id` (`budget_period_id`),
6
    ADD KEY `budget_owner_id` (`budget_owner_id`)
7
;
(-)a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbudgets_planning.sql (+4 lines)
Line 0 Link Here
1
ALTER IGNORE TABLE `aqbudgets_planning`
2
    ADD KEY `budget_id` (`budget_id`),
3
    ADD KEY `budget_period_id` (`budget_period_id`)
4
;
(-)a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqcontacts.sql (+3 lines)
Line 0 Link Here
1
ALTER IGNORE TABLE `aqcontacts`
2
    ADD KEY `booksellerid` (`booksellerid`)
3
;
(-)a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqcontract.sql (+3 lines)
Line 0 Link Here
1
ALTER IGNORE TABLE `aqcontract`
2
    ADD KEY `booksellerid` (`booksellerid`)
3
;
(-)a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqinvoices.sql (+4 lines)
Line 0 Link Here
1
ALTER IGNORE TABLE `aqinvoices`
2
    ADD KEY `booksellerid` (`booksellerid`),
3
    ADD KEY `shipmentcost_budgetid` (`shipmentcost_budgetid`)
4
;
(-)a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqorders.sql (-1 / +6 lines)
Line 0 Link Here
0
- 
1
ALTER IGNORE TABLE `aqorders`
2
    ADD KEY `invoiceid` (`invoiceid`),
3
    ADD KEY `subscriptionid` (`subscriptionid`),
4
    ADD KEY `parent_ordernumber` (`parent_ordernumber`),
5
    ADD KEY `orderstatus` (`orderstatus`)
6
;

Return to bug 14053