CREATE TABLE IF NOT EXISTS artisan_designs (
    id VARCHAR(64) PRIMARY KEY,
    user_id INT NOT NULL,
    name VARCHAR(150) NOT NULL DEFAULT 'Sans titre',
    usage_type ENUM('post','portfolio','produit') NOT NULL DEFAULT 'post',
    format VARCHAR(40) NOT NULL DEFAULT 'instagram_carre',
    grid_config JSON NOT NULL,
    blocks JSON NOT NULL,
    thumbnail_url VARCHAR(500) DEFAULT '',
    created_at DATETIME NOT NULL,
    updated_at DATETIME NOT NULL,
    INDEX idx_artisan_designs_user (user_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS artisan_brand_kits (
    user_id INT PRIMARY KEY,
    logo_url VARCHAR(500) DEFAULT '',
    primary_color VARCHAR(20) DEFAULT '#1a1a1a',
    secondary_color VARCHAR(20) DEFAULT '#f4f1ec',
    font_family VARCHAR(80) DEFAULT 'DM Sans',
    updated_at DATETIME NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;