Getting started

[garthtrickett]

Two things to know when starting this up.

You need to run this in postgres
CREATE EXTENSION citext;

and to get the relations to work properly with drizzle studio you need to add

// lib/server/api/infrastructure/database/tables/sessions.table.ts  
export const sessionsRelations = relations(sessionsTable, ({ one }) => ({
	user: one(usersTable, {
		fields: [sessionsTable.userId],
		references: [usersTable.id]
	})
}));

// lib/server/api/infrastructure/database/tables/tokens.table.ts
export const tokensRelations = relations(tokensTable, ({ one }) => ({
	user: one(usersTable, {
		fields: [tokensTable.userId],
		references: [usersTable.id]
	})
}));
// lib/server/api/infrastructure/database/tables/users.table.ts
export const usersRelations = relations(usersTable, ({ many }) => ({
	sessions: many(sessionsTable),
	tokens: many(tokensTable)
}));