Skip to main content

Database setup

Secrets

Update all the secrets in the file init.sql.
  • JWT_SECRET: provided by Supabase in the Database API section.
  • ENDPOINT_URL: you can choose to put the Hookdeck URL or the API Endpoint of the Edge Functions
  • SERVER_DEV: Choose the ENV name: dev, staging, prod.

Installation

Go to the Supabase SQL Editor, and execute the SQL files templates.
(micleo-functions/supabase/migrations) Follow the order of the SQL files: init -> crons
Set variables:
  • VUE_APP_SUPABASE_ANON_KEY
  • VUE_APP_SUPABASE_URL
  • JWT_SECRET

Tables

  • Members
  • Roles & permissions
  • Subscriptions
  • Integrations
  • Invoices
  • Objects
  • Models
  • Properties
  • Listings
  • Folders
  • Campaigns
  • Templates
  • Activities
  • Files
  • Logs
  • Tasks
  • Forms
  • Workflows
  • Admins
  • Organizations
  • Projects
  • Chats
  • Stripe tables:
    • Products
    • Prices
I