16 lines
623 B
MySQL
16 lines
623 B
MySQL
|
CREATE INDEX ekt_batchNumber USING BTREE ON edi.ekt (batchNumber);
|
||
|
|
|
||
|
|
ALTER TABLE edi.ekt
|
||
|
|
MODIFY COLUMN k3 tinyint(3) unsigned DEFAULT NULL NULL COMMENT 'IMD+P01',
|
||
|
|
MODIFY COLUMN k4 tinyint(3) unsigned DEFAULT NULL NULL COMMENT 'IMD+P02';
|
||
|
|
|
||
|
|
ALTER TABLE edi.mail ADD source TEXT DEFAULT NULL NULL;
|
||
|
|
|
||
|
|
ALTER TABLE edi.ekt
|
||
|
|
ADD vendorOrderNumber BIGINT(20) unsigned DEFAULT NULL NULL COMMENT 'RFF+VN' AFTER deliveryNumber;
|
||
|
|
|
||
|
|
CREATE INDEX ekt_vendorOrderNumber USING BTREE ON edi.ekt (vendorOrderNumber);
|
||
|
|
|
||
|
|
INSERT INTO edi.param (code,name,subname,`position`,`type`,required) VALUES
|
||
|
|
('vendorOrderNumber','RFF','VN',2,'INTEGER',0);
|