24 lines
640 B
MySQL
24 lines
640 B
MySQL
|
|
||
|
|
ALTER TABLE edi.imapConfig
|
||
|
|
ADD environment varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER id,
|
||
|
|
ADD CONSTRAINT imapConfig_environment UNIQUE KEY (environment);
|
||
|
|
|
||
|
|
UPDATE edi.imapConfig
|
||
|
|
SET environment='production'
|
||
|
|
WHERE id=1;
|
||
|
|
|
||
|
|
UPDATE edi.param SET code='item'
|
||
|
|
WHERE id=2;
|
||
|
|
UPDATE edi.param SET code='k3'
|
||
|
|
WHERE id=21;
|
||
|
|
UPDATE edi.param SET code='k4'
|
||
|
|
WHERE id=22;
|
||
|
|
UPDATE edi.param SET code='deliveryNumber'
|
||
|
|
WHERE id=25;
|
||
|
|
|
||
|
|
INSERT INTO edi.param (code,name,`position`,`type`,`required`)
|
||
|
|
VALUES ('cps','CPS',1,'STRING', FALSE);
|
||
|
|
|
||
|
|
ALTER TABLE edi.ekt
|
||
|
|
ADD cps varchar(7) NULL COMMENT 'Código alfanumérico de Floriday';
|