RadioCheck Database Migrations¶
SQL migration files for the RadioCheck Supabase database.
Migration Order¶
Run these in order after schema.sql:
| # | File | Description |
|---|---|---|
| 1 | 20260129_1326_001_last1_integration.sql |
Last1 prefixed tables for shared database |
| 2 | 20260129_2222_002_organization_tiers.sql |
Organization RBAC and tier system |
| 3 | 20260130_0805_003_bundle_pricing.sql |
VSO bundle pricing tables and functions |
| 4 | 20260202_1609_004_last1_auth_integration.sql |
Last1 central auth integration |
Prerequisites¶
- Run
schema.sqlfirst to create base RadioCheck tables - Ensure
uuid-osspextension is enabled
Naming Convention¶
Files are named: YYYYMMDD_HHMM_NNN_description.sql
- YYYYMMDD = Date created
- HHMM = Time created (24hr)
- NNN = Sequence number
- description = Brief description in snake_case