Bugzilla – Attachment 48973 Details for
Bug 7736
Edifact QUOTE and ORDER functionality
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 7736 [QA Followup] - Fix collation
Bug-7736-QA-Followup---Fix-collation.patch (text/plain), 2.21 KB, created by
Kyle M Hall (khall)
on 2016-03-10 19:45:36 UTC
(
hide
)
Description:
Bug 7736 [QA Followup] - Fix collation
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2016-03-10 19:45:36 UTC
Size:
2.21 KB
patch
obsolete
>From 7fa55634d5b60b25dc51c654480a268f8e14fbd5 Mon Sep 17 00:00:00 2001 >From: Kyle M Hall <kyle@bywatersolutions.com> >Date: Thu, 10 Mar 2016 16:58:09 +0000 >Subject: [PATCH] Bug 7736 [QA Followup] - Fix collation > >--- > installer/data/mysql/atomicupdate/edifact.sql | 6 +++--- > 1 file changed, 3 insertions(+), 3 deletions(-) > >diff --git a/installer/data/mysql/atomicupdate/edifact.sql b/installer/data/mysql/atomicupdate/edifact.sql >index 79053cd..25ffb07 100644 >--- a/installer/data/mysql/atomicupdate/edifact.sql >+++ b/installer/data/mysql/atomicupdate/edifact.sql >@@ -23,7 +23,7 @@ CREATE TABLE IF NOT EXISTS vendor_edi_accounts ( > KEY shipmentbudget (shipment_budget), > CONSTRAINT vfk_vendor_id FOREIGN KEY ( vendor_id ) REFERENCES aqbooksellers ( id ), > CONSTRAINT vfk_shipment_budget FOREIGN KEY ( shipment_budget ) REFERENCES aqbudgets ( budget_id ) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; > > -- Hold the actual edifact messages with links to associated baskets > CREATE TABLE IF NOT EXISTS edifact_messages ( >@@ -44,7 +44,7 @@ CREATE TABLE IF NOT EXISTS edifact_messages ( > CONSTRAINT emfk_vendor FOREIGN KEY ( vendor_id ) REFERENCES aqbooksellers ( id ), > CONSTRAINT emfk_edi_acct FOREIGN KEY ( edi_acct ) REFERENCES vendor_edi_accounts ( id ), > CONSTRAINT emfk_basketno FOREIGN KEY ( basketno ) REFERENCES aqbasket ( basketno ) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; > > -- invoices link back to the edifact message it was generated from > ALTER TABLE aqinvoices ADD COLUMN message_id INT(11) REFERENCES edifact_messages( id ); >@@ -69,7 +69,7 @@ CREATE TABLE IF NOT EXISTS edifact_ean ( > ean varchar(15) NOT NULL, > id_code_qualifier VARCHAR(3) NOT NULL DEFAULT '14', > CONSTRAINT efk_branchcode FOREIGN KEY ( branchcode ) REFERENCES branches ( branchcode ) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; > > -- Syspref budget to hold shipping costs > INSERT INTO systempreferences (variable, explanation, type) VALUES('EDIInvoicesShippingBudget','The budget code used to allocate shipping charges to when processing EDI Invoice messages', 'free'); >-- >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 7736
:
8275
|
8276
|
8446
|
8635
|
10226
|
12398
|
12438
|
12467
|
13071
|
15304
|
15729
|
16538
|
16629
|
16649
|
16652
|
16667
|
16732
|
16761
|
16779
|
16792
|
16864
|
16865
|
16866
|
16867
|
16868
|
16869
|
16870
|
16871
|
16872
|
16873
|
16874
|
16882
|
16883
|
16884
|
16885
|
16886
|
17120
|
17121
|
20983
|
20984
|
21475
|
33953
|
33957
|
34332
|
34833
|
35030
|
35106
|
35716
|
35717
|
35718
|
36738
|
44079
|
44080
|
44081
|
44082
|
44083
|
44084
|
46996
|
47004
|
48623
|
48624
|
48625
|
48626
|
48971
|
48972
|
48973
|
48974
|
48975
|
48976
|
49037
|
49038
|
49039
|
49040
|
49041
|
49042
|
49307
|
49850
|
50002
|
50008