diff options
Diffstat (limited to 'prisma')
| -rw-r--r-- | prisma/migrations/20240108174319_add_expense_date/migration.sql | 2 | ||||
| -rw-r--r-- | prisma/schema.prisma | 1 |
2 files changed, 3 insertions, 0 deletions
diff --git a/prisma/migrations/20240108174319_add_expense_date/migration.sql b/prisma/migrations/20240108174319_add_expense_date/migration.sql new file mode 100644 index 0000000..0b6de90 --- /dev/null +++ b/prisma/migrations/20240108174319_add_expense_date/migration.sql @@ -0,0 +1,2 @@ +-- AlterTable +ALTER TABLE "Expense" ADD COLUMN "expenseDate" DATE NOT NULL DEFAULT CURRENT_DATE; diff --git a/prisma/schema.prisma b/prisma/schema.prisma index fd65754..42d4cfc 100644 --- a/prisma/schema.prisma +++ b/prisma/schema.prisma @@ -32,6 +32,7 @@ model Participant { model Expense { id String @id group Group @relation(fields: [groupId], references: [id], onDelete: Cascade) + expenseDate DateTime @db.Date @default(dbgenerated("CURRENT_DATE")) title String amount Int paidBy Participant @relation(fields: [paidById], references: [id], onDelete: Cascade) |