From 9ce2cd7082a2577278c3a7078f9e277cfa683ae9 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 Signed-off-by: Katrin Fischer Signed-off-by: Tomas Cohen Arazi --- .../mysql/atomicupdate/bug_14053-add_keys_aqbasket.sql | 3 +++ .../atomicupdate/bug_14053-add_keys_aqbooksellers.sql | 3 +++ .../mysql/atomicupdate/bug_14053-add_keys_aqbudgets.sql | 7 +++++++ .../atomicupdate/bug_14053-add_keys_aqbudgets_planning.sql | 3 +++ .../mysql/atomicupdate/bug_14053-add_keys_aqorders.sql | 4 ++++ 5 files changed, 20 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_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 0000000000..82c65e378e --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbasket.sql @@ -0,0 +1,3 @@ +ALTER IGNORE TABLE `aqbasket` + ADD KEY `authorisedby` (`authorisedby`) +; \ 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 0000000000..f70175dc60 --- /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 0000000000..03c91509bd --- /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 0000000000..3c1b2b637b --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqbudgets_planning.sql @@ -0,0 +1,3 @@ +ALTER IGNORE TABLE `aqbudgets_planning` + 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_aqorders.sql b/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqorders.sql new file mode 100644 index 0000000000..ff8a5857de --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_14053-add_keys_aqorders.sql @@ -0,0 +1,4 @@ +ALTER IGNORE TABLE `aqorders` + ADD KEY `parent_ordernumber` (`parent_ordernumber`), + ADD KEY `orderstatus` (`orderstatus`) +; \ No newline at end of file -- 2.20.1