List Item with Sidebar

1 files changed, 32 insertions, 14 deletions

diff --git a/apps/web/src/server/db/schema.ts b/apps/web/src/server/db/schema.ts
index d473ef2d..55a2ea1e 100644
--- a/apps/web/src/server/db/schema.ts
+++ b/apps/web/src/server/db/schema.ts
@@ -6,7 +6,7 @@ import {
   sqliteTableCreator,
   text,
   integer,
-  unique
+  unique,
 } from "drizzle-orm/sqlite-core";
 
 /**
@@ -21,7 +21,9 @@ export const users = createTable("user", {
   id: text("id", { length: 255 }).notNull().primaryKey(),
   name: text("name", { length: 255 }),
   email: text("email", { length: 255 }).notNull(),
-  emailVerified: int("emailVerified", { mode: "timestamp" }).default(sql`CURRENT_TIMESTAMP`),
+  emailVerified: int("emailVerified", { mode: "timestamp" }).default(
+    sql`CURRENT_TIMESTAMP`,
+  ),
   image: text("image", { length: 255 }),
 });
 
@@ -34,7 +36,9 @@ export const accounts = createTable(
   "account",
   {
     id: integer("id").notNull().primaryKey({ autoIncrement: true }),
-    userId: text("userId", { length: 255 }).notNull().references(() => users.id),
+    userId: text("userId", { length: 255 })
+      .notNull()
+      .references(() => users.id),
     type: text("type", { length: 255 }).notNull(),
     provider: text("provider", { length: 255 }).notNull(),
     providerAccountId: text("providerAccountId", { length: 255 }).notNull(),
@@ -50,7 +54,7 @@ export const accounts = createTable(
   },
   (account) => ({
     userIdIdx: index("account_userId_idx").on(account.userId),
-  })
+  }),
 );
 
 export const sessions = createTable(
@@ -58,12 +62,14 @@ export const sessions = createTable(
   {
     id: integer("id").notNull().primaryKey({ autoIncrement: true }),
     sessionToken: text("sessionToken", { length: 255 }).notNull(),
-    userId: text("userId", { length: 255 }).notNull().references(() => users.id),
+    userId: text("userId", { length: 255 })
+      .notNull()
+      .references(() => users.id),
     expires: int("expires", { mode: "timestamp" }).notNull(),
   },
   (session) => ({
     userIdIdx: index("session_userId_idx").on(session.userId),
-  })
+  }),
 );
 
 export const verificationTokens = createTable(
@@ -75,19 +81,29 @@ export const verificationTokens = createTable(
   },
   (vt) => ({
     compoundKey: primaryKey({ columns: [vt.identifier, vt.token] }),
-  })
+  }),
 );
 
 export const userStoredContent = createTable(
   "userStoredContent",
   {
-    userId: text("userId").notNull().references(() => users.id),
-    contentId: integer("contentId").notNull().references(() => storedContent.id),
+    userId: text("userId")
+      .notNull()
+      .references(() => users.id),
+    contentId: integer("contentId")
+      .notNull()
+      .references(() => storedContent.id),
   },
   (usc) => ({
-    userContentIdx: index("userStoredContent_idx").on(usc.userId, usc.contentId),
-    uniqueUserContent: unique("unique_user_content").on(usc.userId, usc.contentId),
-  })
+    userContentIdx: index("userStoredContent_idx").on(
+      usc.userId,
+      usc.contentId,
+    ),
+    uniqueUserContent: unique("unique_user_content").on(
+      usc.userId,
+      usc.contentId,
+    ),
+  }),
 );
 
 export const storedContent = createTable(
@@ -106,5 +122,7 @@ export const storedContent = createTable(
     urlIdx: index("storedContent_url_idx").on(sc.url),
     savedAtIdx: index("storedContent_savedAt_idx").on(sc.savedAt),
     titleInx: index("storedContent_title_idx").on(sc.title),
-  })
-);
\ No newline at end of file
+  }),
+);
+
+export type StoredContent = typeof storedContent.$inferSelect;