1ALTER TABLE billing_customers DROP COLUMN last_stripe_event_id;
2ALTER TABLE billing_subscriptions DROP COLUMN last_stripe_event_id;
3
4CREATE TABLE IF NOT EXISTS processed_stripe_events (
5 stripe_event_id TEXT PRIMARY KEY,
6 stripe_event_type TEXT NOT NULL,
7 stripe_event_created_timestamp BIGINT NOT NULL,
8 processed_at TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT now()
9);
10
11CREATE INDEX "ix_processed_stripe_events_on_stripe_event_created_timestamp" ON processed_stripe_events (stripe_event_created_timestamp);