database

Database Setup

Initialize all required tables for Fujitsu Store Central

This will create all necessary D1 database tables for the Store Central platform. The process is idempotent — it only applies migrations that haven't been run yet.

ℹ️
Tables to be created:
  • migrations — Schema version tracking
  • sites — Store sites (code, name, provision_code, site_key)
  • site_events — Events synced from Beelinks
  • site_config — Per-site key-value config
  • activity_logs — Audit trail
  • site_connectors — JES, Zippin, Receipt connectors
  • clients — Multi-tenant organizations
  • client_users — User-to-client mapping + roles
Safe to run multiple times. Existing data is never modified or deleted. Only missing tables and columns are created.
info Current Status
Checking database status...
arrow_back Back to Dashboard