-- Migration: Insert common settings company
-- Date: 2025-01-XX
-- Description: Creates the common settings company for system-wide settings
-- Company ID: 00000000-0000-0000-0000-000000000001

-- Insert common settings company
-- Note: ON DUPLICATE KEY UPDATE ensures the company is created or updated if already exists
INSERT INTO companies (
    id, 
    name, 
    created_at, 
    updated_at,
    deleted_at
)
VALUES (
    '00000000-0000-0000-0000-000000000001',
    '全社共通設定',
    CURRENT_TIMESTAMP,
    CURRENT_TIMESTAMP,
    NULL
)
ON DUPLICATE KEY UPDATE
    name = VALUES(name),
    deleted_at = NULL,
    updated_at = CURRENT_TIMESTAMP;

