From 948adb979a63988ab69033a78bc2f64334f6152a 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 | 3 +++ .../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 | 3 +++ installer/data/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 0000000..82c65e3 --- /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 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..3c1b2b6 --- /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 0000000..ff8a585 --- /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.1.4