59 lines
1.9 KiB
PL/PgSQL
59 lines
1.9 KiB
PL/PgSQL
BEGIN;
|
|
|
|
|
|
ALTER TABLE mock.shop_amazon_events
|
|
DROP COLUMN processed,
|
|
DROP COLUMN processed_successfully;
|
|
DROP INDEX mock.shop_amazon_events_by_timestamp;
|
|
ALTER TABLE mock.shop_big_cartel_events
|
|
DROP COLUMN processed,
|
|
DROP COLUMN processed_successfully;
|
|
DROP INDEX mock.shop_big_cartel_events_by_timestamp;
|
|
ALTER TABLE mock.shop_ebay_events
|
|
DROP COLUMN processed,
|
|
DROP COLUMN processed_successfully;
|
|
DROP INDEX mock.shop_ebay_events_by_timestamp;
|
|
ALTER TABLE mock.shop_ecwid_events
|
|
DROP COLUMN processed,
|
|
DROP COLUMN processed_successfully;
|
|
DROP INDEX mock.shop_ecwid_events_by_timestamp;
|
|
ALTER TABLE mock.shop_etsy_events
|
|
DROP COLUMN processed,
|
|
DROP COLUMN processed_successfully;
|
|
DROP INDEX mock.shop_etsy_events_by_timestamp;
|
|
ALTER TABLE mock.shop_shopify_events
|
|
DROP COLUMN processed,
|
|
DROP COLUMN processed_successfully;
|
|
DROP INDEX mock.shop_shopify_events_by_timestamp;
|
|
ALTER TABLE mock.shop_square_online_events
|
|
DROP COLUMN processed,
|
|
DROP COLUMN processed_successfully;
|
|
DROP INDEX mock.shop_square_online_events_by_timestamp;
|
|
ALTER TABLE mock.shop_squarespace_events
|
|
DROP COLUMN processed,
|
|
DROP COLUMN processed_successfully;
|
|
DROP INDEX mock.shop_squarespace_events_by_timestamp;
|
|
ALTER TABLE mock.shop_tiktok_events
|
|
DROP COLUMN processed,
|
|
DROP COLUMN processed_successfully;
|
|
DROP INDEX mock.shop_tiktok_events_by_timestamp;
|
|
ALTER TABLE mock.shop_walmart_marketplace_events
|
|
DROP COLUMN processed,
|
|
DROP COLUMN processed_successfully;
|
|
DROP INDEX mock.shop_walmart_marketplace_events_by_timestamp;
|
|
ALTER TABLE mock.shop_wix_events
|
|
DROP COLUMN processed,
|
|
DROP COLUMN processed_successfully;
|
|
DROP INDEX mock.shop_wix_events_by_timestamp;
|
|
ALTER TABLE mock.shop_woo_commerce_events
|
|
DROP COLUMN processed,
|
|
DROP COLUMN processed_successfully;
|
|
DROP INDEX mock.shop_woo_commerce_events_by_timestamp;
|
|
ALTER TABLE mock.shop_zoho_events
|
|
DROP COLUMN processed,
|
|
DROP COLUMN processed_successfully;
|
|
DROP INDEX mock.shop_zoho_events_by_timestamp;
|
|
|
|
|
|
COMMIT;
|