Files
shopPRO/updates/0.10/ver_0.184_sql.txt
2024-10-23 13:44:50 +02:00

6 lines
652 B
Plaintext

ALTER TABLE `pp_shop_payment_methods` ADD COLUMN `apilo_payment_type_id` INT(11) NULL DEFAULT NULL AFTER `status`;
ALTER TABLE `pp_shop_transports` ADD COLUMN `apilo_carrier_account_id` INT NULL DEFAULT NULL AFTER `max_wp`;
ALTER TABLE `pp_shop_statuses` ADD COLUMN `apilo_status_id` INT NULL DEFAULT NULL AFTER `baselinker_status_id`;
UPDATE `pp_shop_statuses` SET `status`='zamówienie przygotowane do wysłania' WHERE `id`=7;
ALTER TABLE `pp_shop_orders` ADD COLUMN `apilo_order_id` INT(11) NULL DEFAULT NULL AFTER `baselinker_order_id`;
ALTER TABLE `pp_articles` ADD COLUMN `show_table_of_contents` INT(11) NOT NULL DEFAULT '0' AFTER `show_title`;