Changeset b615094 for database/drizzle/schema/builds.ts

Timestamp:

12/20/25 01:31:36 (7 months ago)

Author:

Tome <gjorgievtome@…>

Branches:

main

Children:

0d447f6

Parents:

b69759d

Message:

add constraints

File:

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

database/drizzle/schema/builds.ts

@@ -1 @@
-import { pgTable, serial, integer, text, numeric, boolean, date, primaryKey } from "drizzle-orm/pg-core";
+import {pgTable, serial, integer, text, numeric, boolean, date, primaryKey, check} from "drizzle-orm/pg-core";
 import { usersTable } from "./users";
 import { componentsTable } from "./components";
+import {sql} from "drizzle-orm";
 
 export const buildsTable = pgTable("build", {
@@ -52 +53 @@
     (t) => ({
         pk: primaryKey({ columns: [t.buildId, t.userId] }),
+        checkValue: check("check_value", sql`${t.value} BETWEEN 1 AND 5`),
     }),
 );