Integrating Payload CMS with Supabase

[ricjohn-acosta]

I'm trying to access the /admin page and have written a beforeSchemaInit hook so that my existing schema doesn't get wiped but I am getting the following error. Any ideas?

error: type "serial" does not exist

I've used npx drizzle-kit introspect to generate my supabase schema which I then use in my payload.config.ts

// storage-adapter-import-placeholder
import { postgresAdapter } from "@payloadcms/db-postgres";
import { payloadCloudPlugin } from "@payloadcms/payload-cloud";
import { lexicalEditor } from "@payloadcms/richtext-lexical";
import path from "path";
import { buildConfig } from "payload";
import { fileURLToPath } from "url";
import sharp from "sharp";

import { Users } from "./collections/Users";
import { Media } from "./collections/Media";
import {
  companies,
  employerProfiles,
  employerResponses,
  profiles,
  reportedStories,
  stories,
  storyLikes,
  users,
} from "../drizzle/schema.ts";

const filename = fileURLToPath(import.meta.url);
const dirname = path.dirname(filename);

export default buildConfig({
  admin: {
    user: Users.slug,
    importMap: {
      baseDir: path.resolve(dirname),
    },
  },
  collections: [Users, Media],
  editor: lexicalEditor(),
  secret: process.env.PAYLOAD_SECRET || "",
  typescript: {
    outputFile: path.resolve(dirname, "payload-types.ts"),
  },
  db: postgresAdapter({
    beforeSchemaInit: [
      ({ schema }) => {
        return {
          ...schema,
          tables: {
            ...schema.tables,
            storyLikes,
            reportedStories,
            stories,
            employerResponses,
            companies,
            employerProfiles,
            profiles,
            users,
          },
        };
      },
    ],
    pool: {
      connectionString: process.env.DATABASE_URI || "",
    },
  }),
  sharp,
  plugins: [
    payloadCloudPlugin(),
    // storage-adapter-placeholder
  ],
});