Veritabanı Kontrolü
✓ MySQL bağlantısı: BAŞARILI
✓ Database 'filtreya_portal_db': VAR
✓ Tablolar:
- access_logs
- id (int(11))
- user_id (int(11))
- action (varchar(50))
- ip_address (varchar(15))
- mac_address (varchar(17))
- timestamp (datetime)
- details (text)
- packages
- id (int(11))
- name (varchar(50))
- data_limit_mb (int(11))
- time_limit_hours (int(11))
- price (decimal(10,2))
- is_default (tinyint(1))
- description (text)
- sessions
- id (int(11))
- user_id (int(11))
- token (varchar(64))
- start_time (datetime)
- end_time (datetime)
- data_used_mb (decimal(10,2))
- status (enum('active','expired','terminated'))
- users
- id (int(11))
- username (varchar(50))
- password (varchar(255))
- full_name (varchar(100))
- email (varchar(100))
- phone (varchar(20))
- token (varchar(64))
- mac_address (varchar(17))
- ip_address (varchar(15))
- created_at (datetime)
- valid_from (datetime)
- valid_until (datetime)
- last_login (datetime)
- login_count (int(11))
- data_limit_mb (int(11))
- data_used_mb (decimal(10,2))
- time_limit_hours (int(11))
- time_used_minutes (int(11))
- is_active (tinyint(1))
- is_blocked (tinyint(1))
- user_type (enum('guest','staff','admin'))
- notes (text)