From d75be5cebb8076f24c0e93b369e94d46d2e4a9a8 Mon Sep 17 00:00:00 2001 From: Fridolin Somers Date: Mon, 27 Apr 2015 17:01:37 +0200 Subject: [PATCH] Bug 14053 - Acquisition db tables are missing indexes - atomicupdates Signed-off-by: Mark Tompsett --- 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 diff --git a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbasket.sql b/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbasket.sql new file mode 100644 index 0000000..93b4844 --- /dev/null +++ b/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`) +; \ No newline at end of file diff --git a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbooksellers.sql b/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbooksellers.sql new file mode 100644 index 0000000..f70175d --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbooksellers.sql @@ -0,0 +1,3 @@ +ALTER IGNORE TABLE `aqbooksellers` + ADD KEY `name` (`name`(255)) +; diff --git a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbudgets.sql b/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbudgets.sql new file mode 100644 index 0000000..03c9150 --- /dev/null +++ b/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`) +; \ No newline at end of file diff --git a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbudgets_planning.sql b/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbudgets_planning.sql new file mode 100644 index 0000000..01aa725 --- /dev/null +++ b/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`) +; \ No newline at end of file diff --git a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqcontacts.sql b/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqcontacts.sql new file mode 100644 index 0000000..cfdc105 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqcontacts.sql @@ -0,0 +1,3 @@ +ALTER IGNORE TABLE `aqcontacts` + ADD KEY `booksellerid` (`booksellerid`) +; \ No newline at end of file diff --git a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqcontract.sql b/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqcontract.sql new file mode 100644 index 0000000..71ded58 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqcontract.sql @@ -0,0 +1,3 @@ +ALTER IGNORE TABLE `aqcontract` + ADD KEY `booksellerid` (`booksellerid`) +; \ No newline at end of file diff --git a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqinvoices.sql b/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqinvoices.sql new file mode 100644 index 0000000..21afe11 --- /dev/null +++ b/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`) +; \ No newline at end of file diff --git a/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqorders.sql b/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqorders.sql new file mode 100644 index 0000000..307a22e --- /dev/null +++ b/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`) +; \ No newline at end of file -- 2.1.4