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

4 lines
406 B
Plaintext

ALTER TABLE pp_shop_products ADD COLUMN sku VARCHAR(50) NULL DEFAULT NULL AFTER wp;
CREATE TABLE pp_cron ( name VARCHAR(50) NULL DEFAULT NULL, last_update DATETIME NULL DEFAULT NULL, UNIQUE INDEX name (name) ) COLLATE='utf8_polish_ci' ENGINE=InnoDB;
INSERT INTO pp_cron (name) VALUES ('baselinker');
ALTER TABLE pp_shop_products ADD COLUMN baselinker_product_id INT(11) NULL DEFAULT NULL AFTER producer_id;