-- 初始化语言表数据
-- 先清空表（如果有旧数据）
TRUNCATE TABLE ak_languages RESTART IDENTITY CASCADE;

-- 插入中文和英文选项
INSERT INTO ak_languages (code, name, native_name) VALUES 
('zh-CN', 'Chinese Simplified', '简体中文'),
('en-US', 'English (US)', 'English'),
('zh-TW', 'Chinese Traditional', '繁體中文'),
('ja-JP', 'Japanese', '日本語'),
('ko-KR', 'Korean', '한국어'),
('es-ES', 'Spanish', 'Español'),
('fr-FR', 'French', 'Français'),
('de-DE', 'German', 'Deutsch'),
('it-IT', 'Italian', 'Italiano'),
('pt-BR', 'Portuguese (Brazil)', 'Português'),
('ru-RU', 'Russian', 'Русский'),
('ar-SA', 'Arabic', 'العربية'),
('hi-IN', 'Hindi', 'हिन्दी'),
('th-TH', 'Thai', 'ไทย'),
('vi-VN', 'Vietnamese', 'Tiếng Việt');

-- 查看插入的数据
SELECT id, code, name, native_name FROM ak_languages ORDER BY code;