762b702e46
<!-- This is an auto-generated comment: release notes by coderabbit.ai --> ## Summary by CodeRabbit * **New Features** * RevenueCat support: public webhook endpoint, webhook handler/service, nightly reconciliation and per-user sync; subscriptions now expose provider and iapStore; new user-facing error for App Store/Play-managed subscriptions. * **Chores** * Multi-provider subscription schema (Provider, IapStore); Stripe credentials moved into payment.stripe (top-level apiKey/webhookKey deprecated); new payment.revenuecat config and defaults added. * **Tests** * Comprehensive RevenueCat integration test suite and snapshots. * **Documentation** * Admin config descriptions updated with deprecation guidance. <!-- end of auto-generated comment: release notes by coderabbit.ai -->
13 lines
415 B
SQL
13 lines
415 B
SQL
-- CreateEnum
|
|
CREATE TYPE "Provider" AS ENUM ('stripe', 'revenuecat');
|
|
|
|
-- CreateEnum
|
|
CREATE TYPE "IapStore" AS ENUM ('app_store', 'play_store');
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "subscriptions" ADD COLUMN "iap_store" "IapStore",
|
|
ADD COLUMN "provider" "Provider" NOT NULL DEFAULT 'stripe',
|
|
ADD COLUMN "rc_entitlement" VARCHAR,
|
|
ADD COLUMN "rc_external_ref" VARCHAR,
|
|
ADD COLUMN "rc_product_id" VARCHAR;
|