lib/db/src/schema/node_files.ts

import { pgTable, serial, text, integer, timestamp } from "drizzle-orm/pg-core";
import { createInsertSchema } from "drizzle-zod";
import { z } from "zod/v4";

export const nodeFilesTable = pgTable("node_files", {
  id: serial("id").primaryKey(),
  nodeId: integer("node_id").notNull(),
  name: text("name").notNull(),
  directory: text("directory").notNull().default("shared"),
  content: text("content").notNull().default(""),
  size: integer("size").notNull().default(0),
  createdAt: timestamp("created_at").defaultNow().notNull(),
});

export const insertNodeFileSchema = createInsertSchema(nodeFilesTable).omit({ id: true, createdAt: true });
export type InsertNodeFile = z.infer<typeof insertNodeFileSchema>;
export type NodeFile = typeof nodeFilesTable.$inferSelect;