feat(schemas): add application unknown session fallback uri field

[simeng-li]

Summary

Add a new unknown_session_fallback_uri field to the applications.

This new field will be used to store a fallback URL for the application when the user accesses the sign-in page without a valid auth session.

Testing

Checklist

• [ ] .changeset
• [ ] unit tests
• [ ] integration tests
• [ ] necessary TSDoc comments

[github-actions[bot]]

COMPARE TO master

Total Size Diff :chart_with_upwards_trend: +618 Bytes

Diff by File

|Name|Diff| |---|---| |packages/core/src/__mocks__/index.ts|:chart_with_upwards_trend: +70 Bytes| |packages/schemas/alterations/next-1731037123-add-unknown-session-fallback-uri-column-to-application-table.ts|:chart_with_upwards_trend: +476 Bytes| |packages/schemas/src/seeds/application.ts|:chart_with_upwards_trend: +35 Bytes| |packages/schemas/tables/applications.sql|:chart_with_upwards_trend: +37 Bytes|