Support Database Migrations for SQL and PostgreSQL Storage

[Mehrn0ush]

Description: To ensure smooth deployment and versioning of database schemas, we need to add support for database migrations when using SQL or PostgreSQL backends in rustify-auth. This will enable developers to easily update and modify database schemas as the project evolves.

Requirements:

• Integrate a migration tool (e.g., sqlx or diesel migrations) to handle schema updates for SQL and PostgreSQL databases.
• Write initial migrations to create tables for storing client data, access tokens, refresh tokens, and authorization codes.
• Ensure that migration scripts can be easily run and versioned.

Tasks:

• [ ] Integrate a migration framework like sqlx or diesel.
• [ ] Write initial migration scripts for SQL and PostgreSQL schema.
• [ ] Document the steps for running migrations.
• [ ] Test migrations on different database setups (MySQL, PostgreSQL).

[github-actions[bot]]

This issue has been marked as stale due to inactivity. It will be closed if no further activity occurs.