Add drizzle-kit configuration

[kxyne]

This PR splits out the schema into a schema file, adds a dev dependency on drizzle-kit, and adds a configuration file to allow drizzle-kit to apply the schema changes. The README is also adjusted accordingly.

I removed the sslmode=require that was in the client connection string as its the default I believe and also breaks connections if you provided any options yourself.

It all works correctly in my environment but I haven't tried it against other versions or bumped any dependencies.

[vercel[bot]]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name	Status	Preview	Comments	Updated (UTC)
nextjs-mysql-auth-starter	❌ Failed (Inspect)			May 27, 2024 10:28pm

[vercel[bot]]

@kxyne is attempting to deploy a commit to the Vercel Team on Vercel.

A member of the Team first needs to authorize it.