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