@@ -, +, @@ atomicupdates --- installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbasket.sql | 4 ++++ .../data/mysql/atomicupdate/bug_14053-add_keys_aqbooksellers.sql | 3 +++ installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbudgets.sql | 7 +++++++ .../mysql/atomicupdate/bug_14053-add_keys_aqbudgets_planning.sql | 4 ++++ .../data/mysql/atomicupdate/bug_14053-add_keys_aqcontacts.sql | 3 +++ .../data/mysql/atomicupdate/bug_14053-add_keys_aqcontract.sql | 3 +++ .../data/mysql/atomicupdate/bug_14053-add_keys_aqinvoices.sql | 4 ++++ installer/data/mysql/atomicupdate/bug_14053-add_keys_aqorders.sql | 6 ++++++ 8 files changed, 34 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbasket.sql create mode 100644 installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbooksellers.sql create mode 100644 installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbudgets.sql create mode 100644 installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbudgets_planning.sql create mode 100644 installer/data/mysql/atomicupdate/bug_14053-add_keys_aqcontacts.sql create mode 100644 installer/data/mysql/atomicupdate/bug_14053-add_keys_aqcontract.sql create mode 100644 installer/data/mysql/atomicupdate/bug_14053-add_keys_aqinvoices.sql create mode 100644 installer/data/mysql/atomicupdate/bug_14053-add_keys_aqorders.sql --- a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbasket.sql +++ a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbasket.sql @@ -0,0 +1,4 @@ +ALTER IGNORE TABLE `aqbasket` + ADD KEY `authorisedby` (`authorisedby`), + ADD KEY `branch` (`branch`) +; --- a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbooksellers.sql +++ a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbooksellers.sql @@ -0,0 +1,3 @@ +ALTER IGNORE TABLE `aqbooksellers` + ADD KEY `name` (`name`(255)) +; --- a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbudgets.sql +++ a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbudgets.sql @@ -0,0 +1,7 @@ +ALTER IGNORE TABLE `aqbudgets` + ADD KEY `budget_parent_id` (`budget_parent_id`), + ADD KEY `budget_code` (`budget_code`), + ADD KEY `budget_branchcode` (`budget_branchcode`), + ADD KEY `budget_period_id` (`budget_period_id`), + ADD KEY `budget_owner_id` (`budget_owner_id`) +; --- a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbudgets_planning.sql +++ a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbudgets_planning.sql @@ -0,0 +1,4 @@ +ALTER IGNORE TABLE `aqbudgets_planning` + ADD KEY `budget_id` (`budget_id`), + ADD KEY `budget_period_id` (`budget_period_id`) +; --- a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqcontacts.sql +++ a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqcontacts.sql @@ -0,0 +1,3 @@ +ALTER IGNORE TABLE `aqcontacts` + ADD KEY `booksellerid` (`booksellerid`) +; --- a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqcontract.sql +++ a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqcontract.sql @@ -0,0 +1,3 @@ +ALTER IGNORE TABLE `aqcontract` + ADD KEY `booksellerid` (`booksellerid`) +; --- a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqinvoices.sql +++ a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqinvoices.sql @@ -0,0 +1,4 @@ +ALTER IGNORE TABLE `aqinvoices` + ADD KEY `booksellerid` (`booksellerid`), + ADD KEY `shipmentcost_budgetid` (`shipmentcost_budgetid`) +; --- a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqorders.sql +++ a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqorders.sql @@ -0,0 +1,6 @@ +ALTER IGNORE TABLE `aqorders` + ADD KEY `invoiceid` (`invoiceid`), + ADD KEY `subscriptionid` (`subscriptionid`), + ADD KEY `parent_ordernumber` (`parent_ordernumber`), + ADD KEY `orderstatus` (`orderstatus`) +; --