- Добавлена колонка job в profiles (устраняет ошибку column job does not exist)
- Добавлена колонка state в users (устраняет предупреждения State column does not exist)
- Исправлен триггер create_initial_profile() для включения looking_for
- Колонка looking_for сделана nullable с DEFAULT 'both'
- Добавлена колонка interested_in как современный синоним для looking_for
- Созданы индексы для производительности: idx_profiles_job, idx_users_state, idx_profiles_interested_in
Патчи:
- sql/fix_looking_for_column.sql
- sql/add_job_and_state_columns.sql
Утилиты:
- bin/apply_all_patches.sh - автоматическое применение всех патчей
Документация:
- docs/DATABASE_FIXES.md - подробное описание исправлений
- docs/HEALTH_CHECK.md - чеклист проверки здоровья бота
- docs/FIXES_SUMMARY_2025-11-06.md - краткая сводка изменений
Fixes: #job-column-error #state-column-warning #looking-for-constraint
🌍 Added complete translation files:
- 🇪🇸 Spanish (es.json) - Español
- 🇫🇷 French (fr.json) - Français
- 🇩🇪 German (de.json) - Deutsch
- 🇮🇹 Italian (it.json) - Italiano
- 🇵🇹 Portuguese (pt.json) - Português
- 🇨🇳 Chinese (zh.json) - 中文
- 🇯🇵 Japanese (ja.json) - 日本語
🔧 Updated LocalizationService:
- All 10 languages loaded and initialized
- Updated supported languages list
- Enhanced language detection
��️ Enhanced UI:
- Extended language selection menu with all 10 languages
- Updated language names mapping in controllers
- Proper flag emojis for each language
💡 Features:
- Native translations for all UI elements
- Cultural appropriate pricing displays
- Proper date/currency formatting per locale
- Korean language support with proper hangul characters
Ready for global deployment with comprehensive language support!
🌐 Interface Localization:
- Added i18next for multi-language interface support
- Created LocalizationService with language detection
- Added translation files for Russian and English
- Implemented language selection in user settings
🤖 AI Profile Translation (Premium feature):
- Integrated DeepSeek API for profile translation
- Added TranslationController for translation management
- Premium-only access to profile translation feature
- Support for 10 languages (ru, en, es, fr, de, it, pt, zh, ja, ko)
�� Database & Models:
- Added language field to users table with migration
- Updated User model to support language preferences
- Added language constraints and indexing
🎛️ User Interface:
- Added language settings menu in bot settings
- Implemented callback handlers for language selection
- Added translate profile button for VIP users
- Localized all interface strings
📚 Documentation:
- Created comprehensive LOCALIZATION.md guide
- Documented API usage and configuration
- Added examples for extending language support
- Added a new button for '⭐ VIP поиск' in command handlers.
- Implemented profile editing states and methods in message handlers.
- Enhanced profile model to include hobbies, religion, dating goals, and lifestyle preferences.
- Updated profile service to handle new fields and ensure proper database interactions.
- Introduced a VIP function in matching service to find candidates based on dating goals.
