@@ -, +, @@ edifact_ean --- installer/data/mysql/atomicupdate/edifact.sql | 7 ++++--- installer/data/mysql/kohastructure.sql | 5 +++-- 2 files changed, 7 insertions(+), 5 deletions(-) --- a/installer/data/mysql/atomicupdate/edifact.sql +++ a/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'); --- a/installer/data/mysql/kohastructure.sql +++ a/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; --