Changeset 1ebac59 for database/drizzle/schema/builds.ts

Timestamp:

12/20/25 00:55:47 (7 months ago)

Author:

Tome <gjorgievtome@…>

Branches:

main

Children:

b69759d

Parents:

c30935a

Message:

add schema and queries

File:

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

database/drizzle/schema/builds.ts

@@ -3 +3 @@
 import { componentsTable } from "./components";
 
-export const buildTable = pgTable("build", {
+export const buildsTable = pgTable("build", {
     id: serial("id").primaryKey(),
     userId: integer("user_id")
@@ -15 +15 @@
 });
 
-export const buildComponentTable = pgTable("build_component", {
+export const buildComponentsTable = pgTable("build_component", {
         buildId: integer("build_id")
             .notNull()
-            .references(() => buildTable.id, { onDelete: "cascade", onUpdate: "cascade" }),
+            .references(() => buildsTable.id, { onDelete: "cascade", onUpdate: "cascade" }),
         componentId: integer("component_id")
             .notNull()
@@ -28 +28 @@
 );
 
-export const favoriteBuildTable = pgTable("favorite_build", {
+export const favoriteBuildsTable = pgTable("favorite_build", {
         buildId: integer("build_id")
             .notNull()
-            .references(() => buildTable.id, { onDelete: "cascade", onUpdate: "cascade" }),
+            .references(() => buildsTable.id, { onDelete: "cascade", onUpdate: "cascade" }),
         userId: integer("user_id")
             .notNull()
@@ -41 +41 @@
 );
 
-export const ratingBuildTable = pgTable("rating_build", {
+export const ratingBuildsTable = pgTable("rating_build", {
         buildId: integer("build_id")
             .notNull()
-            .references(() => buildTable.id, { onDelete: "cascade", onUpdate: "cascade" }),
+            .references(() => buildsTable.id, { onDelete: "cascade", onUpdate: "cascade" }),
         userId: integer("user_id")
             .notNull()
@@ -55 +55 @@
 );
 
-export const reviewTable = pgTable("review", {
+export const reviewsTable = pgTable("review", {
     id: serial("id").primaryKey(),
 
     buildId: integer("build_id")
         .notNull()
-        .references(() => buildTable.id, { onDelete: "cascade", onUpdate: "cascade" }),
+        .references(() => buildsTable.id, { onDelete: "cascade", onUpdate: "cascade" }),
     userId: integer("user_id")
         .notNull()
@@ -68 +68 @@
 });
 
-export type buildItem = typeof buildTable.$inferSelect;
-export type buildInsert = typeof buildTable.$inferInsert;
+export type buildItem = typeof buildsTable.$inferSelect;
+export type buildInsert = typeof buildsTable.$inferInsert;
 
-export type buildComponentItem = typeof buildComponentTable.$inferSelect;
-export type buildComponentInsert = typeof buildComponentTable.$inferInsert;
+export type buildComponentItem = typeof buildComponentsTable.$inferSelect;
+export type buildComponentInsert = typeof buildComponentsTable.$inferInsert;
 
-export type favoriteBuildItem = typeof favoriteBuildTable.$inferSelect;
-export type favoriteBuildInsert = typeof favoriteBuildTable.$inferInsert;
+export type favoriteBuildItem = typeof favoriteBuildsTable.$inferSelect;
+export type favoriteBuildInsert = typeof favoriteBuildsTable.$inferInsert;
 
-export type ratingBuildItem = typeof ratingBuildTable.$inferSelect;
-export type ratingBuildInsert = typeof ratingBuildTable.$inferInsert;
+export type ratingBuildItem = typeof ratingBuildsTable.$inferSelect;
+export type ratingBuildInsert = typeof ratingBuildsTable.$inferInsert;
 
-export type reviewItem = typeof reviewTable.$inferSelect;
-export type reviewInsert = typeof reviewTable.$inferInsert;
+export type reviewItem = typeof reviewsTable.$inferSelect;
+export type reviewInsert = typeof reviewsTable.$inferInsert;