Bugzilla – Attachment 38729 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), 5.31 KB, created by
Mark Tompsett
on 2015-04-30 18:49:17 UTC
(
hide
)
Description:
Bug 14053 - Acquisition db tables are missing indexes - atomicupdates
Filename:
MIME Type:
Creator:
Mark Tompsett
Created:
2015-04-30 18:49:17 UTC
Size:
5.31 KB
patch
obsolete
>From d75be5cebb8076f24c0e93b369e94d46d2e4a9a8 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 | 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
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