88 lines
3.0 KiB
MySQL
88 lines
3.0 KiB
MySQL
|
ALTER TABLE vn.item DROP COLUMN IF EXISTS minQuantity;
|
||
|
|
|
||
|
|
ALTER TABLE vn.item ADD minQuantity INT UNSIGNED DEFAULT NULL NULL
|
||
|
|
COMMENT 'Cantidad mínima para una línea de venta';
|
||
|
|
|
||
|
|
INSERT IGNORE INTO hedera.message (code, description)
|
||
|
|
VALUES ('quantityLessThanMin','The quantity cannot be less than the minimum');
|
||
|
|
|
||
|
|
INSERT IGNORE INTO hedera.messageI18n (code, lang, description) VALUES
|
||
|
|
('quantityLessThanMin','fr','Le montant ne peut être inférieur au montant minimum'),
|
||
|
|
('quantityLessThanMin','pt','O montante não pode ser inferior ao montante mínimo'),
|
||
|
|
('quantityLessThanMin','es','La cantidad no puedes ser menor a la mínima');
|
||
|
|
|
||
|
|
UPDATE hedera.message
|
||
|
|
SET description='Orders for holidays are not possible'
|
||
|
|
WHERE code='ORDER_DATE_HOLIDAY';
|
||
|
|
|
||
|
|
UPDATE hedera.message
|
||
|
|
SET description='The order is empty'
|
||
|
|
WHERE code='ORDER_EMPTY';
|
||
|
|
|
||
|
|
UPDATE hedera.message
|
||
|
|
SET description='Some items are no longer available, please check the quantities highlighted in red'
|
||
|
|
WHERE code='ORDER_UNAVAILABLE';
|
||
|
|
|
||
|
|
UPDATE hedera.message
|
||
|
|
SET description='Only one vote per survey is possible'
|
||
|
|
WHERE code='SURVEY_MAX_ONE_VOTE';
|
||
|
|
|
||
|
|
UPDATE hedera.message
|
||
|
|
SET description='You have exceeded the maximum number of unconfirmed orders, please delete or confirm started orders'
|
||
|
|
WHERE code='ORDER_MAX_EXCEEDED';
|
||
|
|
|
||
|
|
UPDATE hedera.message
|
||
|
|
SET description='Incorrect username or password. Case-sensitive.'
|
||
|
|
WHERE code='LOGIN_INCORRECT';
|
||
|
|
|
||
|
|
UPDATE hedera.message
|
||
|
|
SET description='The order date must be today or later'
|
||
|
|
WHERE code='ORDER_DATE_PAST';
|
||
|
|
|
||
|
|
UPDATE hedera.message
|
||
|
|
SET description='No more orders can be made for today, please postpone your order for tomorrow or later'
|
||
|
|
WHERE code='ORDER_DATE_LAST';
|
||
|
|
|
||
|
|
UPDATE hedera.message
|
||
|
|
SET description='Orders for Sunday cannot be confirmed'
|
||
|
|
WHERE code='ORDER_DATE_SUNDAY';
|
||
|
|
|
||
|
|
UPDATE hedera.message
|
||
|
|
SET description='We are overwhelmed with orders, please select another delivery or pick-up date'
|
||
|
|
WHERE code='ORDER_DATE_SATURATED';
|
||
|
|
|
||
|
|
UPDATE hedera.message
|
||
|
|
SET description='You have been disconnected from the server, please log in again'
|
||
|
|
WHERE code='USER_DISCONNECTED';
|
||
|
|
|
||
|
|
UPDATE hedera.message
|
||
|
|
SET description='Action not allowed'
|
||
|
|
WHERE code='UNAUTH_ACTION';
|
||
|
|
|
||
|
|
UPDATE hedera.message
|
||
|
|
SET description='The shipping agency is not valid'
|
||
|
|
WHERE code='ORDER_INVALID_AGENCY';
|
||
|
|
|
||
|
|
UPDATE hedera.message
|
||
|
|
SET description='Please select a shipping address'
|
||
|
|
WHERE code='ORDER_EMPTY_ADDRESS';
|
||
|
|
|
||
|
|
UPDATE hedera.message
|
||
|
|
SET description='This item is sold in bundles, the quantity has been rounded'
|
||
|
|
WHERE code='ORDER_AMOUNT_ROUNDED';
|
||
|
|
|
||
|
|
UPDATE hedera.message
|
||
|
|
SET description='The order configuration is incorrect, please reconfigure it to continue shopping'
|
||
|
|
WHERE code='orderOutdated';
|
||
|
|
|
||
|
|
UPDATE hedera.message
|
||
|
|
SET description='The order belongs to another user'
|
||
|
|
WHERE code='orderNotOwnedByUser';
|
||
|
|
|
||
|
|
UPDATE hedera.message
|
||
|
|
SET description='The order has already been confirmed and cannot be modified'
|
||
|
|
WHERE code='orderConfirmed';
|
||
|
|
|
||
|
|
UPDATE hedera.message
|
||
|
|
SET description='Incomplete tax data, please contact your sales representative'
|
||
|
|
WHERE code='clientNotVerified';
|