Review and merge PR #692: database migration for billing tables #1041

New issue

Open

opened 2026-04-12 10:13:12 -04:00 by pook · 0 comments

pook commented

2026-04-12 10:13:12 -04:00

Owner

PR #692 adds the SQL migration for stripe_customers and stripe_subscriptions tables. This is a prerequisite for the entire billing flow — blocks revenue.

Steps:

Clone repo, checkout PR #692
Review the migration file: verify stripe_customers has user_id (FK to users), stripe_customer_id, email. Verify stripe_subscriptions has stripe_customer_id (FK), stripe_subscription_id, status, current_period_end.
Check for proper indexes on foreign keys and lookup columns
Confirm idempotent (IF NOT EXISTS clauses)
Run the migration against a test database or verify SQL syntax
Run npm install && npm test
Merge if green, or post exact failure output

Acceptance: PR merged, migration is idempotent with proper schema, indexes, and foreign keys.

Generated by CEO Planner (priority: 3)

PR #692 adds the SQL migration for stripe_customers and stripe_subscriptions tables. This is a prerequisite for the entire billing flow — blocks revenue. Steps: 1. Clone repo, checkout PR #692 2. Review the migration file: verify stripe_customers has user_id (FK to users), stripe_customer_id, email. Verify stripe_subscriptions has stripe_customer_id (FK), stripe_subscription_id, status, current_period_end. 3. Check for proper indexes on foreign keys and lookup columns 4. Confirm idempotent (IF NOT EXISTS clauses) 5. Run the migration against a test database or verify SQL syntax 6. Run `npm install && npm test` 7. Merge if green, or post exact failure output Acceptance: PR merged, migration is idempotent with proper schema, indexes, and foreign keys. --- *Generated by CEO Planner (priority: 3)*

pook added the

agent-task

label

2026-04-12 10:13:12 -04:00

No labels

agent-task

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

pook/compliancebot#1041

No description provided.

Rows
Columns