1 files changed, 0 insertions, 143 deletions
diff --git a/apps/web/app/helpers/server/db/schema.ts b/apps/web/app/helpers/server/db/schema.ts
deleted file mode 100644
index c4616eb2..00000000
--- a/apps/web/app/helpers/server/db/schema.ts
+++ /dev/null
@@ -1,143 +0,0 @@
-import { relations, sql } from "drizzle-orm";
-import {
-  index,
-  int,
-  primaryKey,
-  sqliteTableCreator,
-  text,
-  integer,
-} from "drizzle-orm/sqlite-core";
-
-export const createTable = sqliteTableCreator((name) => `${name}`);
-
-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`,
-  ),
-  image: text("image", { length: 255 }),
-});
-
-export type User = typeof users.$inferSelect;
-
-export const usersRelations = relations(users, ({ many }) => ({
-  accounts: many(accounts),
-  sessions: many(sessions),
-}));
-
-export const accounts = createTable(
-  "account",
-  {
-    id: integer("id").notNull().primaryKey({ autoIncrement: true }),
-    userId: text("userId", { length: 255 })
-      .notNull()
-      .references(() => users.id, { onDelete: "cascade" }),
-    type: text("type", { length: 255 }).notNull(),
-    provider: text("provider", { length: 255 }).notNull(),
-    providerAccountId: text("providerAccountId", { length: 255 }).notNull(),
-    refresh_token: text("refresh_token"),
-    access_token: text("access_token"),
-    expires_at: int("expires_at"),
-    token_type: text("token_type", { length: 255 }),
-    scope: text("scope", { length: 255 }),
-    id_token: text("id_token"),
-    session_state: text("session_state", { length: 255 }),
-    oauth_token_secret: text("oauth_token_secret"),
-    oauth_token: text("oauth_token"),
-  },
-  (account) => ({
-    userIdIdx: index("account_userId_idx").on(account.userId),
-  }),
-);
-
-export const sessions = createTable(
-  "session",
-  {
-    id: integer("id").notNull().primaryKey({ autoIncrement: true }),
-    sessionToken: text("sessionToken", { length: 255 }).notNull(),
-    userId: text("userId", { length: 255 })
-      .notNull()
-      .references(() => users.id, { onDelete: "cascade" }),
-    expires: int("expires", { mode: "timestamp" }).notNull(),
-  },
-  (session) => ({
-    userIdIdx: index("session_userId_idx").on(session.userId),
-  }),
-);
-
-export const verificationTokens = createTable(
-  "verificationToken",
-  {
-    identifier: text("identifier", { length: 255 }).notNull(),
-    token: text("token", { length: 255 }).notNull(),
-    expires: int("expires", { mode: "timestamp" }).notNull(),
-  },
-  (vt) => ({
-    compoundKey: primaryKey({ columns: [vt.identifier, vt.token] }),
-  }),
-);
-
-export const storedContent = createTable(
-  "storedContent",
-  {
-    id: integer("id").notNull().primaryKey({ autoIncrement: true }),
-    content: text("content").notNull(),
-    title: text("title", { length: 255 }),
-    description: text("description", { length: 255 }),
-    url: text("url").notNull(),
-    savedAt: int("savedAt", { mode: "timestamp" }).notNull(),
-    baseUrl: text("baseUrl", { length: 255 }),
-    ogImage: text("ogImage", { length: 255 }),
-    type: text("type", { enum: ["note", "page", "twitter-bookmark"] }).default(
-      "page",
-    ),
-    image: text("image", { length: 255 }),
-    user: text("user", { length: 255 }).references(() => users.id, {
-      onDelete: "cascade",
-    }),
-  },
-  (sc) => ({
-    urlIdx: index("storedContent_url_idx").on(sc.url),
-    savedAtIdx: index("storedContent_savedAt_idx").on(sc.savedAt),
-    titleInx: index("storedContent_title_idx").on(sc.title),
-    userIdx: index("storedContent_user_idx").on(sc.user),
-  }),
-);
-
-export const contentToSpace = createTable(
-  "contentToSpace",
-  {
-    contentId: integer("contentId")
-      .notNull()
-      .references(() => storedContent.id, { onDelete: "cascade" }),
-    spaceId: integer("spaceId")
-      .notNull()
-      .references(() => space.id, { onDelete: "cascade" }),
-  },
-  (cts) => ({
-    compoundKey: primaryKey({ columns: [cts.contentId, cts.spaceId] }),
-  }),
-);
-
-export const space = createTable(
-  "space",
-  {
-    id: integer("id").notNull().primaryKey({ autoIncrement: true }),
-    name: text("name").notNull().unique().default("none"),
-    user: text("user", { length: 255 }).references(() => users.id, {
-      onDelete: "cascade",
-    }),
-  },
-  (space) => ({
-    nameIdx: index("spaces_name_idx").on(space.name),
-    userIdx: index("spaces_user_idx").on(space.user),
-  }),
-);
-
-export type StoredContent = Omit<typeof storedContent.$inferSelect, "user">;
-export type StoredSpace = typeof space.$inferSelect;
-export type ChachedSpaceContent = StoredContent & {
-  space: number;
-};