From d1d5263486f96db578aad918a59007045c3c077f Mon Sep 17 00:00:00 2001
From: Mohamed Bassem <me@mbassem.com>
Date: Sun, 13 Jul 2025 09:28:24 +0000
Subject: feat: Add stripe based subscriptions

---
 packages/db/drizzle/0058_add_subscription.sql | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)
 create mode 100644 packages/db/drizzle/0058_add_subscription.sql

(limited to 'packages/db/drizzle/0058_add_subscription.sql')

diff --git a/packages/db/drizzle/0058_add_subscription.sql b/packages/db/drizzle/0058_add_subscription.sql
new file mode 100644
index 00000000..77260c58
--- /dev/null
+++ b/packages/db/drizzle/0058_add_subscription.sql
@@ -0,0 +1,19 @@
+CREATE TABLE `subscriptions` (
+	`id` text PRIMARY KEY NOT NULL,
+	`userId` text NOT NULL,
+	`stripeCustomerId` text NOT NULL,
+	`stripeSubscriptionId` text,
+	`status` text NOT NULL,
+	`tier` text DEFAULT 'free' NOT NULL,
+	`priceId` text,
+	`cancelAtPeriodEnd` integer DEFAULT false,
+	`startDate` integer,
+	`endDate` integer,
+	`createdAt` integer NOT NULL,
+	`modifiedAt` integer,
+	FOREIGN KEY (`userId`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE cascade
+);
+--> statement-breakpoint
+CREATE UNIQUE INDEX `subscriptions_userId_unique` ON `subscriptions` (`userId`);--> statement-breakpoint
+CREATE INDEX `subscriptions_userId_idx` ON `subscriptions` (`userId`);--> statement-breakpoint
+CREATE INDEX `subscriptions_stripeCustomerId_idx` ON `subscriptions` (`stripeCustomerId`);
\ No newline at end of file
-- 
cgit v1.2.3-70-g09d2

