diff options
Diffstat (limited to 'apps/web/src/server/db')
| -rw-r--r-- | apps/web/src/server/db/index.ts | 7 | ||||
| -rw-r--r-- | apps/web/src/server/db/schema.ts | 15 |
2 files changed, 11 insertions, 11 deletions
diff --git a/apps/web/src/server/db/index.ts b/apps/web/src/server/db/index.ts index 5aa87fc1..4d671bea 100644 --- a/apps/web/src/server/db/index.ts +++ b/apps/web/src/server/db/index.ts @@ -1,8 +1,5 @@ -import { drizzle } from 'drizzle-orm/d1'; +import { drizzle } from "drizzle-orm/d1"; import * as schema from "./schema"; -export const db = drizzle( - process.env.DATABASE, - { schema, logger: true } -); +export const db = drizzle(process.env.DATABASE, { schema, logger: true }); diff --git a/apps/web/src/server/db/schema.ts b/apps/web/src/server/db/schema.ts index a80eb7cf..e0ddbdbc 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"; export const createTable = sqliteTableCreator((name) => `${name}`); @@ -78,7 +78,6 @@ export const verificationTokens = createTable( }), ); - export const storedContent = createTable( "storedContent", { @@ -103,8 +102,12 @@ export const storedContent = createTable( export const contentToSpace = createTable( "contentToSpace", { - contentId: integer("contentId").notNull().references(() => storedContent.id), - spaceId: integer("spaceId").notNull().references(() => space.id), + contentId: integer("contentId") + .notNull() + .references(() => storedContent.id), + spaceId: integer("spaceId") + .notNull() + .references(() => space.id), }, (cts) => ({ compoundKey: primaryKey({ columns: [cts.contentId, cts.spaceId] }), @@ -115,7 +118,7 @@ export const space = createTable( "space", { id: integer("id").notNull().primaryKey({ autoIncrement: true }), - name: text('name').notNull().default('all'), + name: text("name").notNull().default("all"), user: text("user", { length: 255 }).references(() => users.id), }, (space) => ({ @@ -124,4 +127,4 @@ export const space = createTable( }), ); -export type StoredContent = Omit<typeof storedContent.$inferSelect, 'user'>
\ No newline at end of file +export type StoredContent = Omit<typeof storedContent.$inferSelect, "user">; |