🗄️ Veritabanı Yapısı - Sadakat Sistemi Analizi

📊 Veritabanı İstatistikleri

Toplam Tablo Sayısı: 67
Veritabanı: 8.0.45-0ubuntu0.24.04.1

📋 Tablo: admin_logs

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

admin_idint(NOT NULL, INDEX)

actionvarchar(255)(NOT NULL, INDEX)

detailstext

created_attimestamp(NOT NULL, INDEX, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 10

📋 Tablo: admin_notifications

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

notification_typevarchar(50)(NOT NULL)

messagetext(NOT NULL)

datajson

severityenum('LOW','MEDIUM','HIGH','CRITICAL')(INDEX, DEFAULT: MEDIUM)

is_readtinyint(1)

created_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 67

📋 Tablo: balance_debug_logs

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

old_ticket_balancedecimal(10,2)(DEFAULT: 0.00)

new_ticket_balancedecimal(10,2)(DEFAULT: 0.00)

old_pap_balancedecimal(10,2)(DEFAULT: 0.00)

new_pap_balancedecimal(10,2)(DEFAULT: 0.00)

old_clover_balancedecimal(10,2)(DEFAULT: 0.00)

new_clover_balancedecimal(10,2)(DEFAULT: 0.00)

update_typeenum('absolute','delta','admin','reset')(NOT NULL, INDEX)

source_filevarchar(255)(NOT NULL, INDEX)

source_functionvarchar(255)

call_stacktext

post_datatext

session_datatext

admin_uservarchar(100)

ip_addressvarchar(45)

user_agenttext

created_attimestamp(INDEX, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 2178767

📋 Tablo: balance_logs

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

ticket_changedecimal(10,2)(NOT NULL)

pap_changedecimal(10,2)(NOT NULL)

clover_changeint(NOT NULL)

pap_balancedecimal(10,2)(NOT NULL, DEFAULT: 0.00)

ticket_balancedecimal(10,2)(NOT NULL, DEFAULT: 0.00)

clover_balanceint(NOT NULL)

notetext

admin_idint(INDEX)

created_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 13092

📋 Tablo: balance_update_audit

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

event_timetimestamp(INDEX, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

db_uservarchar(128)

conn_idbigint

app_user_idint(INDEX)

old_ticketdecimal(18,2)

new_ticketdecimal(18,2)

old_papdecimal(18,2)

new_papdecimal(18,2)

old_cloverbigint

new_cloverbigint

notevarchar(255)

📊 Toplam Kayıt: 3147682

📋 Tablo: betyu_bets

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

period_idint(NOT NULL, INDEX)

betint(NOT NULL)

selectionenum('win','lose')(NOT NULL)

created_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 1559

📋 Tablo: betyu_logs

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

betint(NOT NULL)

selectionvarchar(10)(NOT NULL)

created_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

result_statusenum('pending','won','lost','cancelled')(DEFAULT: pending)

result_amountint

📊 Toplam Kayıt: 3179

📋 Tablo: betyu_period_logs

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

period_idint(NOT NULL, INDEX)

start_datedate(NOT NULL, INDEX)

start_timetime(NOT NULL)

end_timetime(NOT NULL)

resultenum('win','lose','cancelled')(NOT NULL, INDEX)

total_win_betsint

total_lose_betsint

total_win_papint

total_lose_papint

total_participantsint

total_pap_amountint

created_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 111

📋 Tablo: betyu_periods

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

start_datedate(NOT NULL)

start_timetime(NOT NULL)

end_timetime(NOT NULL)

statusenum('pending','open','closed','resolved','cancelled')(DEFAULT: pending)

resultenum('win','lose','cancelled')

created_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 112

📋 Tablo: betyu_text_settings

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

text_typeenum('time','date')(NOT NULL)

text_contentvarchar(255)

active_untildatetime

created_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 118

📋 Tablo: blocked_ips

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

ip_addressvarchar(45)(NOT NULL, UNIQUE)

blocked_untiltimestamp(NOT NULL)

blocked_reasontext

created_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 0

📋 Tablo: clover_settings

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

daily_bonusint(NOT NULL, DEFAULT: 50)

referral_bonusint(NOT NULL, DEFAULT: 25)

game_win_multiplierdecimal(3,2)(NOT NULL, DEFAULT: 1.00)

max_daily_earnint(NOT NULL, DEFAULT: 500)

created_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

updated_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP)

📊 Toplam Kayıt: 1

📋 Tablo: consecutive_wins

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

consecutive_countint(INDEX)

last_win_typevarchar(50)(NOT NULL)

last_activitytimestamp(INDEX, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP)

created_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 677

📋 Tablo: general_settings

idint(NOT NULL, PRIMARY KEY, DEFAULT: 1)

reset_dayint(NOT NULL, DEFAULT: 1)

start_ticketdecimal(10,2)(NOT NULL, DEFAULT: 0.00)

start_papdecimal(10,2)(NOT NULL, DEFAULT: 0.00)

start_cloverint(NOT NULL, DEFAULT: 100)

last_reset_datedate

📊 Toplam Kayıt: 1

📋 Tablo: hidden_ip_warnings

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

warning_typeenum('creation_ip','last_login_ip')(NOT NULL)

created_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 11

📋 Tablo: hidden_logs

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

log_idint(NOT NULL, UNIQUE)

hidden_byvarchar(50)(NOT NULL, DEFAULT: erci)

hidden_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 83

📋 Tablo: hidden_users

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, UNIQUE)

hidden_byvarchar(50)(NOT NULL, DEFAULT: erci)

hidden_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 0

📋 Tablo: investment_links

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

step_indexint(NOT NULL)

link_namevarchar(100)(NOT NULL)

link_urlvarchar(500)(NOT NULL)

created_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

updated_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP)

📊 Toplam Kayıt: 7

📋 Tablo: investment_reset_settings

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

auto_reset_enabledtinyint(1)(NOT NULL)

auto_reset_daysint(NOT NULL, DEFAULT: 30)

last_reset_datedatetime

next_reset_datedatetime

created_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

updated_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP)

📊 Toplam Kayıt: 1

📋 Tablo: investment_rewards

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

pap_amountint

ticket_amountint

clover_amountint(NOT NULL)

📊 Toplam Kayıt: 1

📋 Tablo: loyalty_history

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

points_earnedint(NOT NULL)

points_typeenum('ticket_spent','daily_bonus','game_win','special_event')(NOT NULL, INDEX, DEFAULT: ticket_spent)

game_typeenum('slot','scratch','wheel','betyu','other')

descriptionvarchar(255)(NOT NULL)

created_attimestamp(INDEX, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 8617373

📋 Tablo: loyalty_levels

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

level_namevarchar(50)(NOT NULL)

min_pointsint(NOT NULL, INDEX)

max_pointsint(NOT NULL)

level_colorvarchar(7)(DEFAULT: #ffffff)

level_iconvarchar(10)(DEFAULT: ⭐)

bonus_multiplierdecimal(3,2)(DEFAULT: 1.00)

descriptiontext

created_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 6

📋 Tablo: maintenance_settings

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

game_typevarchar(50)(NOT NULL, UNIQUE)

is_maintenancetinyint(1)(NOT NULL)

maintenance_passwordvarchar(255)

created_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

updated_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP)

kick_timestampint

📊 Toplam Kayıt: 5

📋 Tablo: max_win_logs

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

usernamevarchar(255)(NOT NULL)

game_typeenum('scratch','slot','wheel','betyu')(NOT NULL, INDEX, DEFAULT: scratch)

prize_valueint(NOT NULL, INDEX)

created_attimestamp(INDEX, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 0

📋 Tablo: max_win_status

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

last_winner_user_idint

last_winner_usernamevarchar(255)

won_attimestamp(INDEX)

is_activetinyint(1)(INDEX, DEFAULT: 1)

prize_valueint(NOT NULL, INDEX, DEFAULT: 500)

created_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

updated_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP)

📊 Toplam Kayıt: 1

📋 Tablo: monthly_pap_quota

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

yearint(NOT NULL, INDEX)

monthint(NOT NULL)

quota_amountdecimal(10,2)(NOT NULL, DEFAULT: 0.00)

current_earneddecimal(10,2)(NOT NULL, DEFAULT: 0.00)

is_activetinyint(1)(INDEX, DEFAULT: 1)

created_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

updated_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP)

📊 Toplam Kayıt: 5

📋 Tablo: notifications

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

typeenum('joker_assigned','referral_reward','withdrawal_approved','reset_warning','investment_rejected','daily_login','tophill_change_rejected','tophill_change_approved','tophill_rejected','tophill_approved','daily_reward','weekly_reward','monthly_reward','yearly_reward','sponsor_approved','sponsor_rejected','sponsor_change_approved','sponsor_change_rejected','sponsor_reward','betyu_win','betyu_lose','betyu_cancelled','balance_updated','admin_notification')(NOT NULL)

titlevarchar(255)(NOT NULL)

messagetext(NOT NULL)

is_readtinyint(1)(INDEX)

datajson

created_attimestamp(INDEX, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 51785

📋 Tablo: pap_earning_logs

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

usernamevarchar(255)(NOT NULL)

game_typeenum('slot','wheel','scratch','betyu')(NOT NULL, INDEX)

pap_amountdecimal(10,2)(NOT NULL)

original_prize_typevarchar(50)

adjusted_prize_typevarchar(50)

was_quota_exceededtinyint(1)(INDEX)

created_attimestamp(INDEX, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 6

📋 Tablo: png_sponsor_cards

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

sponsor_idint(NOT NULL, UNIQUE)

filenamevarchar(255)(NOT NULL, INDEX)

original_namevarchar(255)(NOT NULL)

file_pathvarchar(500)(NOT NULL)

file_sizeint

widthint

heightint

is_activetinyint(1)(INDEX, DEFAULT: 1)

display_orderint

click_urlvarchar(500)

click_countint

created_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

updated_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP)

📊 Toplam Kayıt: 5

📋 Tablo: png_sponsor_stats

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

sponsor_idint(NOT NULL, INDEX)

action_typeenum('view','click','upload','delete')(NOT NULL)

user_idint

ip_addressvarchar(45)

user_agenttext

created_attimestamp(INDEX, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 196

📋 Tablo: referrals

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

referrer_idint(NOT NULL, INDEX)

referred_idint(NOT NULL, INDEX)

referral_codevarchar(20)(NOT NULL, INDEX)

statusenum('pending','accepted','rejected')(DEFAULT: pending)

reward_giventinyint(1)

created_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

accepted_attimestamp

📊 Toplam Kayıt: 2

📋 Tablo: reward_logs

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

reward_datedate(NOT NULL)

ticket_changedecimal(10,2)(DEFAULT: 0.00)

pap_changedecimal(10,2)(DEFAULT: 0.00)

clover_changeint(NOT NULL)

operationenum('add','subtract','set')(NOT NULL)

created_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 0

📋 Tablo: scratch_config

idint(NOT NULL, PRIMARY KEY, DEFAULT: 1)

daily_play_limitint(NOT NULL, DEFAULT: 100)

updated_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP)

📊 Toplam Kayıt: 1

📋 Tablo: scratch_logs

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

betint(NOT NULL)

winint(NOT NULL)

clover_betint(NOT NULL)

clover_winint(NOT NULL)

created_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

prize_typevarchar(50)

📊 Toplam Kayıt: 998783

📋 Tablo: scratch_settings

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

symbol_idint(NOT NULL)

chancedecimal(5,2)(NOT NULL)

valueint(NOT NULL)

typevarchar(20)(NOT NULL)

created_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

updated_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP)

📊 Toplam Kayıt: 8

📋 Tablo: security_heartbeats

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, UNIQUE)

violations_countint

is_visibletinyint(1)(DEFAULT: 1)

play_timeint

frame_rateint

click_rateint

ip_addressvarchar(45)

last_heartbeattimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP)

created_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 0

📋 Tablo: security_requests

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

request_typevarchar(50)(INDEX)

created_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 115

📋 Tablo: security_violations

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

violation_typevarchar(100)(NOT NULL)

violation_datajson

severityvarchar(10)(DEFAULT: MEDIUM)

ip_addressvarchar(45)

created_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 2

📋 Tablo: segment1_status

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

last_winner_user_idint

last_winner_usernamevarchar(255)

won_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

is_activetinyint(1)(DEFAULT: 1)

created_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 46

📋 Tablo: slot_config

idint(NOT NULL, PRIMARY KEY, DEFAULT: 1)

daily_play_limitint(NOT NULL, DEFAULT: 100)

updated_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP)

📊 Toplam Kayıt: 1

📋 Tablo: slot_logs

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

betint(NOT NULL)

winint(NOT NULL)

clover_betint(NOT NULL)

clover_winint(NOT NULL)

created_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

prize_typevarchar(50)

📊 Toplam Kayıt: 2968882

📋 Tablo: slot_max_symbol_logs

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

symbol_idint(NOT NULL, INDEX, DEFAULT: 12)

bet_amountint(NOT NULL, DEFAULT: 1)

win_amountint(NOT NULL)

prize_typevarchar(50)(NOT NULL)

created_attimestamp(INDEX, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 0

📋 Tablo: slot_max_symbol_status

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

symbol_idint(NOT NULL, INDEX, DEFAULT: 12)

last_winner_user_idint

last_winner_usernamevarchar(255)

won_attimestamp(INDEX, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

is_activetinyint(1)(INDEX, DEFAULT: 1)

created_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 508

📋 Tablo: special_win_state

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, UNIQUE)

special_state_activetinyint(1)(INDEX)

state_start_timetimestamp

state_end_timetimestamp(INDEX)

created_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

updated_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP)

📊 Toplam Kayıt: 0

📋 Tablo: sponsor_cards_backup_20250627_201450

idint(NOT NULL, PRIMARY KEY)

card1_titlevarchar(100)(NOT NULL, DEFAULT: ? Oyun Rehberi)

card1_descriptionvarchar(255)(NOT NULL, DEFAULT: Oyun kurallarını öğren, puanlarını yükselt!)

card2_titlevarchar(100)(NOT NULL, DEFAULT: ? Kazanç Fırsatları)

card2_descriptionvarchar(255)(NOT NULL, DEFAULT: Günlük görevler ve bonus fırsatları keşfet!)

card3_titlevarchar(100)(NOT NULL, DEFAULT: ? Liderlik Tablosu)

card3_descriptionvarchar(255)(NOT NULL, DEFAULT: En yüksek skorları gör, yarış!)

created_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

updated_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP)

📊 Toplam Kayıt: 1

📋 Tablo: sponsor_cards_backup_20260510_011851

idint(NOT NULL, PRIMARY KEY)

card1_titlevarchar(100)(NOT NULL, DEFAULT: ? Oyun Rehberi)

card1_descriptionvarchar(255)(NOT NULL, DEFAULT: Oyun kurallarını öğren, puanlarını yükselt!)

card2_titlevarchar(100)(NOT NULL, DEFAULT: ? Kazanç Fırsatları)

card2_descriptionvarchar(255)(NOT NULL, DEFAULT: Günlük görevler ve bonus fırsatları keşfet!)

card3_titlevarchar(100)(NOT NULL, DEFAULT: ? Liderlik Tablosu)

card3_descriptionvarchar(255)(NOT NULL, DEFAULT: En yüksek skorları gör, yarış!)

created_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

updated_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP)

📊 Toplam Kayıt: 1

📋 Tablo: sponsor_types

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

namevarchar(50)(NOT NULL, UNIQUE)

display_namevarchar(100)(NOT NULL)

is_activetinyint(1)(DEFAULT: 1)

created_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

updated_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP)

📊 Toplam Kayıt: 13

📋 Tablo: symbol_settings

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

symbol_idint(NOT NULL)

chancedecimal(5,2)(NOT NULL)

valueint(NOT NULL)

typeenum('pap','ticket','clover')(NOT NULL)

created_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

updated_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP)

📊 Toplam Kayıt: 13

📋 Tablo: symbols

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

symbolvarchar(10)(NOT NULL)

created_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 32

📋 Tablo: tasks

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

namevarchar(100)(NOT NULL)

descriptiontext

reward_ticketdecimal(10,2)(DEFAULT: 0.00)

reward_papdecimal(10,2)(DEFAULT: 0.00)

reward_cloverint(NOT NULL)

sponsor_count_requiredint(DEFAULT: 1)

typeenum('daily_login','referral','sponsor_reward')(NOT NULL, DEFAULT: daily_login)

is_activetinyint(1)(NOT NULL, DEFAULT: 1)

📊 Toplam Kayıt: 3

📋 Tablo: test_security_violations

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

violation_typevarchar(100)(NOT NULL)

violation_datajson

severityvarchar(10)(DEFAULT: MEDIUM)

ip_addressvarchar(45)

created_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 1

📋 Tablo: tokens

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

tokenvarchar(255)(NOT NULL, UNIQUE)

created_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

expires_attimestamp(NOT NULL, DEFAULT: 0000-00-00 00:00:00)

📊 Toplam Kayıt: 3

📋 Tablo: user_investment_steps

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

step_indextinyint(NOT NULL)

statusenum('pending','waiting','approved','rejected','joker')(DEFAULT: pending)

image_pathvarchar(255)

admin_notetext

investment_linkvarchar(255)

updated_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP)

is_hiddentinyint(1)

user_notetext

📊 Toplam Kayıt: 7

📋 Tablo: user_jokers

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL)

joker_codevarchar(64)(NOT NULL)

usedtinyint(1)

used_step_indextinyint

created_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 22

📋 Tablo: user_metric_overrides

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

metric_keyvarchar(64)(NOT NULL)

delta_valuedecimal(18,4)(NOT NULL, DEFAULT: 0.0000)

expires_atdatetime(NOT NULL, INDEX)

created_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

target_valuedecimal(18,4)

📊 Toplam Kayıt: 675

📋 Tablo: user_notes

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

admin_idint(NOT NULL, INDEX)

note_contenttext(NOT NULL)

created_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 9

📋 Tablo: user_restrictions

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

restriction_typevarchar(50)(NOT NULL)

restriction_valuevarchar(255)

expires_attimestamp(NOT NULL)

created_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 0

📋 Tablo: user_sponsor_ids

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

sponsor_type_idint(NOT NULL, INDEX)

sponsor_idvarchar(255)(NOT NULL)

statusenum('pending','approved','rejected','change_pending')(INDEX, DEFAULT: pending)

rejection_notetext

admin_idint

created_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

updated_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP)

📊 Toplam Kayıt: 9

📋 Tablo: user_stats

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

total_gamesint(NOT NULL)

total_winsint(NOT NULL)

total_lossesint(NOT NULL)

highest_winint(NOT NULL)

📊 Toplam Kayıt: 11

📋 Tablo: user_task_logs

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

task_idint(NOT NULL)

log_datedate(NOT NULL)

created_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 21181

📋 Tablo: user_violation_counters

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

violation_typevarchar(50)(NOT NULL)

countint(DEFAULT: 1)

last_violationtimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP)

📊 Toplam Kayıt: 1

📋 Tablo: username_history

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

old_usernamevarchar(255)(NOT NULL)

new_usernamevarchar(255)(NOT NULL)

changed_attimestamp(INDEX, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

changed_byvarchar(50)(DEFAULT: user)

📊 Toplam Kayıt: 884

📋 Tablo: users

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

telegram_idbigint(NOT NULL, UNIQUE)

referral_codevarchar(20)(UNIQUE)

usernamevarchar(255)(NOT NULL)

photo_urltext

created_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

last_logintimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP)

ticket_balancedecimal(10,2)(DEFAULT: 0.00)

pap_balancedecimal(10,2)(DEFAULT: 0.00)

clover_balanceint(NOT NULL)

loyalty_pointsint(NOT NULL)

is_admintinyint(1)

passwordvarchar(255)

creation_ipvarchar(45)

last_login_ipvarchar(45)

is_bannedtinyint(1)(NOT NULL)

blocked_untiltimestamp

blocked_reasontext

is_verifiedtinyint(1)(NOT NULL)

tophill_idvarchar(32)

tophill_statusenum('pending','approved','rejected','change_pending')

tophill_rejection_notetext

tophill_updated_attimestamp

tophill_admin_idint

reward_claimedtinyint(1)

kick_usernamevarchar(255)

youtube_usernamevarchar(255)

instagram_usernamevarchar(255)

📊 Toplam Kayıt: 1330

📋 Tablo: wheel_config

idint(NOT NULL, PRIMARY KEY, DEFAULT: 1)

daily_spin_limitint(NOT NULL, DEFAULT: 100)

updated_attimestamp(DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP)

📊 Toplam Kayıt: 1

📋 Tablo: wheel_logs

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

bet_amountdecimal(10,2)(NOT NULL)

win_amountdecimal(10,2)(NOT NULL)

clover_bet_amountint(NOT NULL)

clover_win_amountint(NOT NULL)

prize_typevarchar(50)(NOT NULL)

created_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

📊 Toplam Kayıt: 1128780

📋 Tablo: wheel_settings

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

typevarchar(50)(NOT NULL)

valueint(NOT NULL)

amountint(NOT NULL, DEFAULT: 1)

chancefloat(NOT NULL)

imagevarchar(255)(NOT NULL)

created_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED)

updated_attimestamp(NOT NULL, DEFAULT: CURRENT_TIMESTAMP, DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP)

📊 Toplam Kayıt: 16

📋 Tablo: withdraw_requests

idint(NOT NULL, PRIMARY KEY, AUTO_INCREMENT)

user_idint(NOT NULL, INDEX)

amountint(NOT NULL)

statusenum('pending','approved','rejected')(NOT NULL, DEFAULT: pending)

created_atdatetime(NOT NULL)

updated_atdatetime

admin_notetext

📊 Toplam Kayıt: 551

🔍 USERS Tablosu - Sadakat Sistemi Analizi

📋 Mevcut Kolonlar:

• id (int)

• telegram_id (bigint)

• referral_code (varchar(20))

• username (varchar(255))

• photo_url (text)

• created_at (timestamp)

• last_login (timestamp)

• ticket_balance (decimal(10,2))

• pap_balance (decimal(10,2))

• clover_balance (int)

✅ loyalty_points (int) - SADAKAT SİSTEMİ MEVCUT!

• is_admin (tinyint(1))

• password (varchar(255))

• creation_ip (varchar(45))

• last_login_ip (varchar(45))

• is_banned (tinyint(1))

• blocked_until (timestamp)

• blocked_reason (text)

• is_verified (tinyint(1))

• tophill_id (varchar(32))

• tophill_status (enum('pending','approved','rejected','change_pending'))

• tophill_rejection_note (text)

• tophill_updated_at (timestamp)

• tophill_admin_id (int)

• reward_claimed (tinyint(1))

• kick_username (varchar(255))

• youtube_username (varchar(255))

• instagram_username (varchar(255))

✅ Sadakat sistemi kolonları MEVCUT!

🎫 Ticket Harcama Noktaları Analizi

Sadakat puanı kazanılacak yerler:

🎰 Slot Oyunları: /slot/ klasörü
🎲 Scratch Oyunları: /scratch/ klasörü
🎡 Wheel Oyunu: /wheel/ klasörü
🃏 Betyu Oyunu: /betyu/ klasörü
💰 Pap Çevrim: convert_pap_to_ticket.php