Changeset ea09e98 for database/drizzle/schema

Timestamp:

12/23/25 04:22:06 (7 months ago)

Author:

Tome <gjorgievtome@…>

Branches:

main

Children:

6196d60

Parents:

226fbbb

Message:

Update and add

File:

• database/drizzle/schema/builds.ts (modified) (2 diffs)

database/drizzle/schema/builds.ts

@@ -1 @@
-import {pgTable, serial, integer, text, numeric, boolean, date, primaryKey, check} from "drizzle-orm/pg-core";
+import {pgTable, serial, integer, text, numeric, boolean, date, primaryKey, check, unique} from "drizzle-orm/pg-core";
 import { usersTable } from "./users";
 import { componentsTable } from "./components";
@@ -58 +58 @@
 
 export const reviewsTable = pgTable("review", {
-    id: serial("id").primaryKey(),
+        id: serial("id").primaryKey(),
 
-    buildId: integer("build_id")
-        .notNull()
-        .references(() => buildsTable.id, { onDelete: "cascade", onUpdate: "cascade" }),
-    userId: integer("user_id")
-        .notNull()
-        .references(() => usersTable.id, { onDelete: "cascade", onUpdate: "cascade" }),
-    content: text("content").notNull(),
-    createdAt: date("created_at").notNull(),
-});
+        buildId: integer("build_id")
+            .notNull()
+            .references(() => buildsTable.id, { onDelete: "cascade", onUpdate: "cascade" }),
+        userId: integer("user_id")
+            .notNull()
+            .references(() => usersTable.id, { onDelete: "cascade", onUpdate: "cascade" }),
+        content: text("content").notNull(),
+        createdAt: date("created_at").notNull()
+    },
+    (t) => ({
+        uniqueUserBuild: unique().on(t.buildId, t.userId),
+    }),
+);
 
 export type buildItem = typeof buildsTable.$inferSelect;