Attachment 44082 Details for Bug 7736 – 0004-Fixed-the-definition-of-table-edifact_ean

[patch] 0004-Fixed-the-definition-of-table-edifact_ean

0004-BUG-7736-Follow-up-Fixed-the-definition-of-table-edi.patch (text/plain), 2.27 KB, created by Zeno Tajoli on 2015-10-27 15:15:35 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Zeno Tajoli

Created: 2015-10-27 15:15:35 UTC

Size: 2.27 KB

patch

obsolete

>From 250a3fe0010f53d53aa25a28f5af03bceaaf6677 Mon Sep 17 00:00:00 2001
>From: Zeno Tajoli <z.tajoli@cineca.it>
>Date: Tue, 27 Oct 2015 14:09:40 +0100
>Subject: [PATCH 4/6] [BUG 7736] Follow-up: Fixed the definition of table
> edifact_ean
>
>---
> installer/data/mysql/atomicupdate/edifact.sql |    7 ++++---
> installer/data/mysql/kohastructure.sql        |    5 +++--
> 2 files changed, 7 insertions(+), 5 deletions(-)
>
>diff --git a/installer/data/mysql/atomicupdate/edifact.sql b/installer/data/mysql/atomicupdate/edifact.sql
>index 0eb40ce..92adf6a 100755
>--- a/installer/data/mysql/atomicupdate/edifact.sql
>+++ b/installer/data/mysql/atomicupdate/edifact.sql
>@@ -61,11 +61,12 @@ ALTER TABLE aqorders ADD COLUMN suppliers_reference_qualifier varchar(3);
> 
> -- hold the EAN/SAN used in ordering
> CREATE TABLE IF NOT EXISTS edifact_ean (
>-  branchcode VARCHAR(10) NOT NULL REFERENCES branches (branchcode),
>+  branchcode varchar(10) NOT NULL ,
>   ean varchar(15) NOT NULL,
>-  id_code_qualifier VARCHAR(3) NOT NULL DEFAULT '14',
>+  id_code_qualifier varchar(3) NOT NULL default '14',
>+  KEY efk_branchcode ( branchcode ),
>   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');
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 781a0c1..bc3703c 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -3596,10 +3596,11 @@ CREATE TABLE discharges (
> --
> 
> DROP TABLE IF EXISTS edifact_ean;
>-CREATE TABLE IF NOT EXISTS edifact_ean (
>-  branchcode varchar(10) not null references branches (branchcode),
>+CREATE TABLE edifact_ean (
>+  branchcode varchar(10) NOT NULL ,
>   ean varchar(15) NOT NULL,
>   id_code_qualifier varchar(3) NOT NULL default '14',
>+  KEY efk_branchcode ( branchcode ),
>   CONSTRAINT efk_branchcode FOREIGN KEY ( branchcode ) REFERENCES branches ( branchcode )
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
> 
>-- 
>1.7.10.4
>

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