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'); |