Bugzilla – Attachment 39154 Details for
Bug 14053
Acquisition db tables are missing indexes
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 14053 - Acquisition db tables are missing indexes - atomicupdates
Bug-14053---Acquisition-db-tables-are-missing-inde.patch (text/plain), 3.40 KB, created by
Mark Tompsett
on 2015-05-13 18:05:58 UTC
(
hide
)
Description:
Bug 14053 - Acquisition db tables are missing indexes - atomicupdates
Filename:
MIME Type:
Creator:
Mark Tompsett
Created:
2015-05-13 18:05:58 UTC
Size:
3.40 KB
patch
obsolete
>From 948adb979a63988ab69033a78bc2f64334f6152a Mon Sep 17 00:00:00 2001 >From: Fridolin Somers <fridolin.somers@biblibre.com> >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 <mtompset@hotmail.com> >--- > 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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 14053
:
38568
|
38569
|
38728
|
38729
|
38808
|
39135
|
39136
|
39153
|
39154
|
39155
|
39719
|
39720