All schema changes in B2B Import ERP are managed as numbered SQL migration files underDocumentation Index
Fetch the complete documentation index at: https://mintlify.com/ency07/B2B-import/llms.txt
Use this file to discover all available pages before exploring further.
supabase/migrations/. Each file is prefixed with a sortable timestamp so that migrations are always applied in deterministic order. The files are idempotent by convention — re-running a migration on an already-migrated database will either be a no-op (for CREATE TABLE IF NOT EXISTS patterns) or raise an error that can be safely ignored after inspection.
Deployment Methods
Using Supabase CLI (Recommended)
The Supabase CLI applies all pending migrations automatically, tracking applied migrations in thesupabase_migrations table:
supabase/migrations/ directory against what has already been applied to the linked remote project and runs only the delta.
For local development with a self-hosted Supabase instance:
Manual SQL Editor
If the CLI is not available, paste each migration file into the Supabase SQL Editor in ascending numeric order. Start with20260617000000_init_core.sql and finish with the highest-numbered file.
Combined Migrations File
The repository includes a pre-concatenated convenience file at the project root:Always apply migrations in ascending numeric order. Each file may depend on tables or functions created by earlier migrations. Out-of-order application will produce foreign-key or function-not-found errors.
Migration File Reference
20260617000000_init_core.sql
Foundation. Creates core enums (
tenant_status_enum, user_status_enum, etc.), the tenants, sites, areas, users, roles, permissions, user_roles, user_permissions, and audit_log tables. Installs the process_audit_log() trigger function and all performance indexes.20260617000001_seed_master_data.sql
Demo fixtures. Inserts two demo tenants (AeroMax / Apex), 106 pre-confirmed user accounts, and reference data. Development/UAT only — do not run in production.
20260617000002_clients_core.sql
Clients. Creates
clients, client_sites, client_contacts, and business_events tables. Adds the handle_client_code() trigger for auto-generating CLI-000001 codes and handle_primary_contact() for enforcing a single primary contact per client.20260617000003_requirements_core.sql
Requirements. Creates
requirements and diagnostic_reports tables. Diagnostic reports store the CFM calculation and price estimation output from the wizard.20260617000004_quotes_core.sql
Quotes. Creates
quotes and quote_items tables with status workflow and auto-generated COT-XXXXXX codes.20260617000005_approvals_core.sql
Approvals. Creates
approval_requests and approval workflow tables for multi-step document sign-off (quotes, invoices, purchase orders).20260617000006_jobs_core.sql
Jobs. Creates
jobs and job_activities tables for field service work order management.20260617000007_inventory_core.sql
Inventory. Creates
inventory_items, warehouses, inventory_stock, and inventory_movements tables with warehouse-level stock tracking.20260617000008_invoices_core.sql
Invoices. Creates
invoices, invoice_items, payments, payment_transactions, and payment_reconciliations tables. Includes the payment status workflow.20260617000010_warranties_core.sql
Warranties. Creates
warranties and warranty_claims tables for post-sale warranty tracking.20260617000011_website_core.sql
Website CMS. Creates website content tables and landing page configuration (hero text, video URL, sections).
20260617000012_wizard_core.sql
Wizard. Creates
wizard_sessions and related tables for persisting multi-step wizard state across browser sessions.20260617000013_crm_core.sql
CRM / Leads. Creates the
leads table and CRM pipeline configuration. Establishes the scoring fields (score, risk_level) used by calculateLeadScore().20260617000014_marketing_core.sql
Marketing. Creates
campaigns, campaign_contacts, and marketing analytics tables.20260617000015_dashboards_core.sql
Dashboards. Creates materialized KPI views and dashboard metric queries for the analytics module.
20260617000016_costs_core.sql
Job Costs. Creates job cost tracking tables for materials, labour, and overhead per work order.
20260617000017_profitability_core.sql
Profitability. Creates profitability analysis views aggregating revenue vs. cost per client, job, and period.
20260617000018_documents_core.sql
Documents. Creates
document_attachments and media_assets tables for file storage references (Supabase Storage paths).20260617000019_notifications_core.sql
Notifications. Creates
notification_queue and notification_delivery_log tables for the in-app and email notification system.20260617000020_security_audit_core.sql
Security Audit. Creates
user_access_logs with immutability enforcement triggers (physical DELETE is blocked). Adds granular RLS policies for AUDITOR, GERENTE, and self-service access log reads.20260617000021_performance_hardening.sql
Performance. Adds composite indexes for common query patterns across all operational tables. No schema changes — index-only migration.
20260617000022_uat_validation.sql
UAT Helpers. Installs SQL helper functions for user-acceptance testing: data validation assertions, constraint checks, and test-data cleanup utilities.
20260617000023_release_monitoring.sql
Health Checks. Creates
v_system_health and related views for monitoring database size, row counts, and index health via the admin panel.20260617000031_settings_core.sql
Tenant Settings. Creates the
tenant_settings key-value store with (tenant_id, module, config_key) unique constraint. Adds the get_tenant_setting(p_tenant_id, p_module, p_key) RPC for decrypting encrypted settings.20260617000032_white_label.sql
White Label. Creates branding configuration tables and the
tenant_branding_version snapshot history table.20260617000033_integrations.sql
Integrations. Creates
payment_gateways and integration_credentials tables for third-party provider configuration (Wompi, Stripe, etc.).20260617000034_advanced_admin.sql
Advanced Admin. Adds advanced admin panel features: tenant suspension workflows, bulk operations, and platform-level reporting views.
20260617000035_industrial_cms.sql
Industrial CMS. Creates the full product catalog hierarchy:
product_categories, product_subcategories, product_families, product_series, products, product_specifications, product_images, product_documents, product_files, and seo_metadata tables.20260619000036_fix_leads_schema.sql
Leads Schema Patch. Adds missing columns to the
leads table (name, company_name, phone, email, urgency, lead_score) to support the public contact form submission path in submitContactForm().20260620000037_branding_version.sql
Branding Version Tracking. Adds version-number management and snapshot columns to
tenant_branding_version. Enables the restore-to-previous-version feature in restoreBrandingVersion().20260626000001_production_gaps.sql
Production Gaps. Adds tables missing from earlier migrations that are required for production:
vendors, purchase_orders, and supporting tables for the procurement module, Wompi payment tracking, support chat, and full-text catalog search.