Changeset 76b980b for database

Timestamp:

12/24/25 23:50:32 (7 months ago)

Author:

Tome <gjorgievtome@…>

Branches:

main

Children:

1bf6e1f

Parents:

2c6d75a

Message:

add pci_express_slots attribute

File:

• database/drizzle/schema/components.ts (modified) (18 diffs)

database/drizzle/schema/components.ts

@@ -26 +26 @@
     baseClock: numeric("base_clock").notNull(),
     boostClock: numeric("boost_clock"),
-    tdp: numeric("tdp").notNull(),
+    tdp: numeric("tdp").notNull()
 });
 
@@ -38 +38 @@
     boostClock: numeric("boost_clock"),
     chipset: text("chipset").notNull(),
-    length: numeric("length").notNull(),
+    length: numeric("length").notNull()
 });
 
@@ -48 +48 @@
     speed: numeric("speed").notNull(),
     capacity: numeric("capacity").notNull(),
-    modules: integer("modules").notNull(),
+    modules: integer("modules").notNull()
 });
 
@@ -57 +57 @@
     type: text("type").notNull(),
     wattage: numeric("wattage").notNull(),
-    formFactor: text("form_factor").notNull(),
+    formFactor: text("form_factor").notNull()
 });
 
@@ -65 +65 @@
         .references(() => componentsTable.id, { onDelete: "cascade", onUpdate: "cascade" }),
     coolerMaxHeight: numeric("cooler_max_height").notNull(),
-    gpuMaxLength: numeric("gpu_max_length").notNull(),
+    gpuMaxLength: numeric("gpu_max_length").notNull()
 });
 
@@ -74 +74 @@
             .references(() => pcCasesTable.componentId, {onDelete: "cascade", onUpdate: "cascade" }),
         formFactor: text("form_factor").notNull(),
-        numSlots: integer("num_slots").notNull(),
-    },
-    (t) => ({
-        pk: primaryKey({ columns: [t.caseId, t.formFactor] }),
+        numSlots: integer("num_slots").notNull()
+    },
+    (t) => ({
+        pk: primaryKey({ columns: [t.caseId, t.formFactor] })
     }),
 );
@@ -85 +85 @@
             .notNull()
             .references(() => pcCasesTable.componentId, { onDelete: "cascade", onUpdate: "cascade"}),
-        formFactor: text("form_factor").notNull(),
-    },
-    (t) => ({
-        pk: primaryKey({ columns: [t.caseId, t.formFactor] }),
+        formFactor: text("form_factor").notNull()
+    },
+    (t) => ({
+        pk: primaryKey({ columns: [t.caseId, t.formFactor] })
     }),
 );
@@ -96 +96 @@
             .notNull()
             .references(() => pcCasesTable.componentId, { onDelete: "cascade", onUpdate: "cascade"}),
-        formFactor: text("form_factor").notNull(),
-    },
-    (t) => ({
-        pk: primaryKey({ columns: [t.caseId, t.formFactor] }),
+        formFactor: text("form_factor").notNull()
+    },
+    (t) => ({
+        pk: primaryKey({ columns: [t.caseId, t.formFactor] })
     }),
 );
@@ -109 +109 @@
     type: text("type").notNull(),
     height: numeric("height").notNull(),
-    maxTdpSupported: numeric("max_tdp_supported").notNull(),
+    maxTdpSupported: numeric("max_tdp_supported").notNull()
 });
 
@@ -117 +117 @@
             .notNull()
             .references(() => coolersTable.componentId, { onDelete: "cascade", onUpdate: "cascade" }),
-        socket: text("socket").notNull(),
-    },
-    (t) => ({
-        pk: primaryKey({ columns: [t.coolerId, t.socket] }),
+        socket: text("socket").notNull()
+    },
+    (t) => ({
+        pk: primaryKey({ columns: [t.coolerId, t.socket] })
     })
 );
@@ -135 +135 @@
     numRamSlots: integer("num_ram_slots").notNull(),
     maxRamCapacity: numeric("max_ram_capacity").notNull(),
+    pciExpressSlots: numeric("pci_express_slots").notNull()
 });
 
@@ -143 +144 @@
     type: text("type").notNull(),
     capacity: numeric("capacity").notNull(),
-    formFactor: text("form_factor").notNull(),
+    formFactor: text("form_factor").notNull()
 });
 
@@ -152 +153 @@
         .references(() => componentsTable.id, { onDelete: "cascade", onUpdate: "cascade" }),
     numSlots: integer("num_slots").notNull(),
-    interface: text("interface").notNull(),
+    interface: text("interface").notNull()
 });
 
@@ -163 +164 @@
     interface: text("interface").notNull(),
     writeSpeed: numeric("write_speed").notNull(),
-    readSpeed: numeric("read_speed").notNull(),
+    readSpeed: numeric("read_speed").notNull()
 });
 
@@ -174 +175 @@
     chipset: text("chipset").notNull(),
     interface: text("interface").notNull(),
-    channel: text("channel").notNull(),
+    channel: text("channel").notNull()
 });
 
@@ -182 +183 @@
         .references(() => componentsTable.id, { onDelete: "cascade", onUpdate: "cascade" }),
     lengthCm: numeric("length_cm").notNull(),
-    type: text("type").notNull(),
+    type: text("type").notNull()
 });
 
@@ -191 +192 @@
     wifiVersion: text("wifi_version").notNull(),
     interface: text("interface").notNull(),
-    numAntennas: integer("num_antennas").notNull(),
+    numAntennas: integer("num_antennas").notNull()
 });
 
@@ -200 +201 @@
     numPorts: integer("num_ports").notNull(),
     speed: numeric("speed").notNull(),
-    interface: text("interface").notNull(),
+    interface: text("interface").notNull()
 });