database

Database Setup

Initialize all required tables

This will create all necessary database tables for the Fujitsu Admin Console. The process is safe and will only create tables that don't already exist (using CREATE TABLE IF NOT EXISTS).

ℹ️

Tables to be created:

access_users, access_roles, access_role_permissions
activity_logs (audit trail with user, action, detail, status)
sites (multi-site management with metadata)
teams, team_members (team-based access)
secrets (AES-256-GCM encrypted vault)
stock_shelves, stock_products, stock_history

⚠️

Warning: This will only CREATE tables that don't exist. If tables already exist with wrong schema, you need to manually ALTER or DROP them using wrangler CLI.