Changeset b615094 for database/drizzle/schema/users.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/users.ts (modified) (2 diffs)

database/drizzle/schema/users.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 {sql} from "drizzle-orm";
 
 export const usersTable = pgTable("users", {
@@ -26 +27 @@
     status: text("status")
         .notNull()
-        .default("pending"), // Pending, Approved, Rejected
+        .default("pending"),
     componentType: text("component_type").notNull()
-});
+    },
+    (t) => ({
+        checkStatus: check("check_status", sql`${t.status} in ('pending', 'approved', 'rejected')`),
+    }),
+);
 
 export type userItem = typeof usersTable.$inferSelect;