added new migration

flippedcoder · Oct 7, 2023 · 6c13ea2 · 6c13ea2
1 parent 3b04579
commit 6c13ea2
Show file tree

Hide file tree

Showing 4 changed files with 35 additions and 16 deletions.
diff --git a/...230504014912_initial_tables/migration.sql → ...823205932_initial_migration/migration.sql b/...230504014912_initial_tables/migration.sql → ...823205932_initial_migration/migration.sql
@@ -3,6 3,7 @@ CREATE TABLE "User" (
  "id" SERIAL NOT NULL,
  "email" TEXT NOT NULL,
  "name" TEXT NOT NULL,
  "permissions" TEXT[],
 
  CONSTRAINT "User_pkey" PRIMARY KEY ("id")
 );
@@ -12,7 13,7 @@ CREATE TABLE "Product" (
  "id" TEXT NOT NULL,
  "name" TEXT NOT NULL,
  "price" DOUBLE PRECISION NOT NULL,
- "createdAt" TIMESTAMP(3) NOT NULL,
  "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "updatedAt" TIMESTAMP(3) NOT NULL,
 
  CONSTRAINT "Product_pkey" PRIMARY KEY ("id")
@@ -23,7 24,7 @@ CREATE TABLE "Order" (
  "id" SERIAL NOT NULL,
  "name" TEXT NOT NULL,
  "total" DOUBLE PRECISION NOT NULL,
- "createdAt" TIMESTAMP(3) NOT NULL,
  "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "updatedAt" TIMESTAMP(3) NOT NULL,
  "userId" INTEGER,
 

diff --git a/prisma/migrations/20230831211559_added_stripe_product_id_field/migration.sql b/prisma/migrations/20230831211559_added_stripe_product_id_field/migration.sql
@@ -0,0 1,8 @@
 /*
  Warnings:
 
  - Added the required column `stripeProductId` to the `Product` table without a default value. This is not possible if the table is not empty.
 
 */
 -- AlterTable
 ALTER TABLE "Product" ADD COLUMN "stripeProductId" TEXT NOT NULL;
diff --git a/prisma/migrations/20231005001642_added_stripe_invoice_id_to_orders/migration.sql b/prisma/migrations/20231005001642_added_stripe_invoice_id_to_orders/migration.sql
@@ -0,0 1,8 @@
 /*
  Warnings:
 
  - Added the required column `stripeInvoiceId` to the `Order` table without a default value. This is not possible if the table is not empty.
 
 */
 -- AlterTable
 ALTER TABLE "Order" ADD COLUMN "stripeInvoiceId" TEXT NOT NULL;
diff --git a/prisma/schema.prisma b/prisma/schema.prisma
@@ -19,21 19,23 @@ model User {
 }
 
 model Product {
- id String @id @default(uuid())
- name String
- price Float
- createdAt DateTime @default(now())
- updatedAt DateTime @updatedAt
- orders Order[]
  id String @id @default(uuid())
  name String
  price Float
  stripeProductId String
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
  orders Order[]
 }
 
 model Order {
- id Int @id @default(autoincrement())
- name String
- total Float
- products Product[]
- createdAt DateTime @default(now())
- updatedAt DateTime @updatedAt
- userId Int?
- User User? @relation(fields: [userId], references: [id])
  id Int @id @default(autoincrement())
  stripeInvoiceId String
  name String
  total Float
  products Product[]
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
  userId Int?
  User User? @relation(fields: [userId], references: [id])
 }