11 lines
315 B
MySQL
11 lines
315 B
MySQL
|
USE vn;
|
||
|
|
|
||
|
|
ALTER TABLE `vn`.`ticketConfig`
|
||
|
|
ADD COLUMN `packagingInvoicingDated` DATE NOT NULL DEFAULT '2017-11-21'
|
||
|
|
COMMENT 'Fecha desde la cual se gestiona el registro de embalajes de tickets (tabla vn.ticketPackaging)'
|
||
|
|
AFTER `pickingDelay`;
|
||
|
|
|
||
|
|
UPDATE `vn`.`warehouse`
|
||
|
|
SET `code` = 'inv'
|
||
|
|
WHERE (`id` = '13');
|