Incorrect default value for type definitions file path listed in docs

[joepaolicelli]

The docs say the default is for the types directory to be in the rootDir, while it is actually expected to be in the sourceDir. While these are often the same in Nuxt v3 they don't have to be, and they will be different in Nuxt v4. (A starter repo from NuxtHub already makes them different, which is why I ran into this.)

supabase/docs/content/2.get-started.md

Line 141 in be41d94

Default: `./types/database.types.ts`

supabase/src/module.ts

Line 98 in be41d94

* @default '~/types/database.types.ts'

Apologies for creating an issue for a one character documentation change! But this caused me some confusion and brief issues, and seemed like a simple fix. I'm happy to make a PR, but wasn't sure if that would be more work for you than just a note.