(대표님) 권한관리, 문서업로드, rfq첨부, SWP문서룰 등

(최겸) 입찰

1 files changed, 20 insertions, 20 deletions

diff --git a/db/schema/users.ts b/db/schema/users.ts
index f01db8db..1d963228 100644
--- a/db/schema/users.ts
+++ b/db/schema/users.ts
@@ -229,12 +229,12 @@ export const otps = pgTable('otps', {
   otpExpires: timestamp('otp_expires').notNull(), // null 불가능
 });
 
-export const permissions = pgTable("permissions", {
-  id: integer("id").primaryKey().generatedAlwaysAsIdentity(),
-  permissionKey: text("permission_key").notNull(),
-  description: text("description"),
-  createdAt: timestamp("created_at").default(sql`now()`),
-});
+// export const permissions = pgTable("permissions", {
+//   id: integer("id").primaryKey().generatedAlwaysAsIdentity(),
+//   permissionKey: text("permission_key").notNull(),
+//   description: text("description"),
+//   createdAt: timestamp("created_at").default(sql`now()`),
+// });
 
 export const roles = pgTable("roles", {
   id: integer("id").primaryKey().generatedAlwaysAsIdentity(),
@@ -246,19 +246,19 @@ export const roles = pgTable("roles", {
   createdAt: timestamp("created_at").default(sql`now()`),
 });
 
-export const rolePermissions = pgTable("role_permissions", {
-  roleId: integer("role_id")
-    .references(() => roles.id, { onDelete: "cascade" })
-    .notNull(),
-  permissionId: integer("permission_id")
-    .references(() => permissions.id, { onDelete: "cascade" })
-    .notNull(),
-}, (table) => {
-  return [{
-    pk: primaryKey({ columns: [table.roleId, table.permissionId] }),
-    pkWithCustomName: primaryKey({ name: 'rolePermissions_pk', columns: [table.roleId, table.permissionId] }),
-  }];
-});
+// export const rolePermissions = pgTable("role_permissions", {
+//   roleId: integer("role_id")
+//     .references(() => roles.id, { onDelete: "cascade" })
+//     .notNull(),
+//   permissionId: integer("permission_id")
+//     .references(() => permissions.id, { onDelete: "cascade" })
+//     .notNull(),
+// }, (table) => {
+//   return [{
+//     pk: primaryKey({ columns: [table.roleId, table.permissionId] }),
+//     pkWithCustomName: primaryKey({ name: 'rolePermissions_pk', columns: [table.roleId, table.permissionId] }),
+//   }];
+// });
 
 export const userRoles = pgTable("user_roles", {
   userId: integer("user_id")
@@ -360,4 +360,4 @@ export const roleView = pgView("role_view").as((qb) => {
 
 export type UserView = typeof userView.$inferSelect;
 export type RoleView = typeof roleView.$inferSelect;
-export type RolePermission = typeof rolePermissions.$inferSelect;
\ No newline at end of file
+// export type RolePermission = typeof rolePermissions.$inferSelect;
\ No newline at end of file