-- SQL script to add translations directly to database
-- Replace values as needed

-- First, get the language IDs
-- SELECT id, code, name FROM languages;

-- Add new translation keys (replace language_id values as needed)
INSERT INTO translations (language_id, translation_key, translation_value, category, created_at) VALUES
-- English (language_id = 1, adjust as needed)
(1, 'orders.new_feature', 'New Feature', 'orders', NOW()),
(1, 'products.quick_edit', 'Quick Edit', 'products', NOW()),
(1, 'dashboard.recent_activity', 'Recent Activity', 'dashboard', NOW()),

-- Spanish (language_id = 2, adjust as needed) 
(2, 'orders.new_feature', 'Nueva Función', 'orders', NOW()),
(2, 'products.quick_edit', 'Edición Rápida', 'products', NOW()),
(2, 'dashboard.recent_activity', 'Actividad Reciente', 'dashboard', NOW())

-- Add more languages as needed
ON DUPLICATE KEY UPDATE 
    translation_value = VALUES(translation_value),
    updated_at = NOW();
