Drizzle Migration Issue

[jrparks]

Hello,

I pulled the latest canary branch to implement the Gitea repo feature and encountered issues with the Drizzle migrations. There are foreign key constraints referencing 'adminId' in various tables (project, destination, registry) that point to an admin table, but these columns don't exist in the database.

When running 'npx drizzle-kit migrate', I get errors like:
PostgresError: column "adminId" referenced in foreign key constraint does not exist
I could implement a temporary fix, but I don't want to risk breaking anything. Could you please address the migration issues in the canary branch and let me know when it's fixed so I can continue with my feature implementation?

Thank you in advance.

[Siumauricio]

Hi, can you give more context?

I assume you are running it in local mode, if so and you have migrations coming from canary and they are conflicting with what you are doing I suggest you undo the migrations you did and generate your migrations again, and try restarting the database again you can run db:truncate command to leave the bd clean.

[jrparks]

After I truncated the db, I was able to run the migration successfully. I will proceed with my changes.

Thank you