6 replies

Reference to auth.users?

i was following ben davis video about sveltekit + supabase/drizzle. in his video he mention that he want to use sql file in supabase/migrations as a source of truth and then rewrote it in schema.ts,

create table profile (
    id serial primary key,
    first_name varchar(100),
    last_name varchar(100),
    email varchar(100),
    user_id uuid references auth.users
);

create table profile (
    id serial primary key,
    first_name varchar(100),
    last_name varchar(100),
    email varchar(100),
    user_id uuid references auth.users
);

but i prefer to use schema.ts as a source of truth then use the drizzle migrations.

export const profileTable = pgTable('profile', {
    id: serial('id').primaryKey(),
    last_name: varchar('last_name', { length: 100 }),
    first_name: varchar('first_name', { length: 100 }),
    email: varchar('email', { length: 100 }),
    user_id: uuid('user_id').notNull().references(() => auth.users),
});

export const profileTable = pgTable('profile', {
    id: serial('id').primaryKey(),
    last_name: varchar('last_name', { length: 100 }),
    first_name: varchar('first_name', { length: 100 }),
    email: varchar('email', { length: 100 }),
    user_id: uuid('user_id').notNull().references(() => auth.users),
});

the problem is that i can't reference the auth.users like in the .sql file

Drizzle Team•3y ago•

6 replies

bhin

Reference to auth.users?

i was following ben davis video about sveltekit + supabase/drizzle. in his video he mention that he want to use sql file in supabase/migrations as a source of truth and then rewrote it in schema.ts,

create table profile (
    id serial primary key,
    first_name varchar(100),
    last_name varchar(100),
    email varchar(100),
    user_id uuid references auth.users
);

create table profile (
    id serial primary key,
    first_name varchar(100),
    last_name varchar(100),
    email varchar(100),
    user_id uuid references auth.users
);

but i prefer to use schema.ts as a source of truth then use the drizzle migrations.

export const profileTable = pgTable('profile', {
    id: serial('id').primaryKey(),
    last_name: varchar('last_name', { length: 100 }),
    first_name: varchar('first_name', { length: 100 }),
    email: varchar('email', { length: 100 }),
    user_id: uuid('user_id').notNull().references(() => auth.users),
});

export const profileTable = pgTable('profile', {
    id: serial('id').primaryKey(),
    last_name: varchar('last_name', { length: 100 }),
    first_name: varchar('first_name', { length: 100 }),
    email: varchar('email', { length: 100 }),
    user_id: uuid('user_id').notNull().references(() => auth.users),
});

the problem is that i can't reference the auth.users like in the .sql file

Reference to auth.users?

Similar Threads

Reference to auth.users?

Similar Threads

Similar Threads

Similar Threads