10 lines
740 B
Plaintext
10 lines
740 B
Plaintext
ALTER TABLE pp_shop_orders ADD COLUMN baselinker_order_id INT NULL DEFAULT NULL AFTER notes;
|
|
ALTER TABLE pp_shop_statuses ADD COLUMN baselinker_status_id INT(11) NULL DEFAULT NULL AFTER o;
|
|
UPDATE pp_shop_statuses SET baselinker_status_id='65931' WHERE id=0;
|
|
UPDATE pp_shop_statuses SET baselinker_status_id='66803' WHERE id=1;
|
|
UPDATE pp_shop_statuses SET baselinker_status_id='66805' WHERE id=2;
|
|
UPDATE pp_shop_statuses SET baselinker_status_id='65937' WHERE id=4;
|
|
UPDATE pp_shop_statuses SET baselinker_status_id='65933' WHERE id=5;
|
|
UPDATE pp_shop_statuses SET baselinker_status_id='65936' WHERE id=6;
|
|
UPDATE pp_shop_statuses SET baselinker_status_id='65932' WHERE id=7;
|
|
UPDATE pp_shop_statuses SET baselinker_status_id='65934' WHERE id=8; |