View | Details | Raw Unified | Return to bug 7736
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/edifact.sql (-3 / +4 lines)
Lines 61-71 ALTER TABLE aqorders ADD COLUMN suppliers_reference_qualifier varchar(3); Link Here
61
61
62
-- hold the EAN/SAN used in ordering
62
-- hold the EAN/SAN used in ordering
63
CREATE TABLE IF NOT EXISTS edifact_ean (
63
CREATE TABLE IF NOT EXISTS edifact_ean (
64
  branchcode VARCHAR(10) NOT NULL REFERENCES branches (branchcode),
64
  branchcode varchar(10) NOT NULL ,
65
  ean varchar(15) NOT NULL,
65
  ean varchar(15) NOT NULL,
66
  id_code_qualifier VARCHAR(3) NOT NULL DEFAULT '14',
66
  id_code_qualifier varchar(3) NOT NULL default '14',
67
  KEY efk_branchcode ( branchcode ),
67
  CONSTRAINT efk_branchcode FOREIGN KEY ( branchcode ) REFERENCES branches ( branchcode )
68
  CONSTRAINT efk_branchcode FOREIGN KEY ( branchcode ) REFERENCES branches ( branchcode )
68
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
69
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
69
70
70
-- Syspref budget to hold shipping costs
71
-- Syspref budget to hold shipping costs
71
INSERT INTO systempreferences (variable, explanation, type) VALUES('EDIInvoicesShippingBudget','The budget code used to allocate shipping charges to when processing EDI Invoice messages',  'free');
72
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 (-3 / +3 lines)
Lines 3596-3605 CREATE TABLE discharges ( Link Here
3596
--
3596
--
3597
3597
3598
DROP TABLE IF EXISTS edifact_ean;
3598
DROP TABLE IF EXISTS edifact_ean;
3599
CREATE TABLE IF NOT EXISTS edifact_ean (
3599
CREATE TABLE edifact_ean (
3600
  branchcode varchar(10) not null references branches (branchcode),
3600
  branchcode varchar(10) NOT NULL ,
3601
  ean varchar(15) NOT NULL,
3601
  ean varchar(15) NOT NULL,
3602
  id_code_qualifier varchar(3) NOT NULL default '14',
3602
  id_code_qualifier varchar(3) NOT NULL default '14',
3603
  KEY efk_branchcode ( branchcode ),
3603
  CONSTRAINT efk_branchcode FOREIGN KEY ( branchcode ) REFERENCES branches ( branchcode )
3604
  CONSTRAINT efk_branchcode FOREIGN KEY ( branchcode ) REFERENCES branches ( branchcode )
3604
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3605
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3605
3606
3606
- 

Return to bug 7736