🗄️ Veritabanı Yönetimi

Tablolar

Wo_Activities Wo_AdminInvitations Wo_Ads Wo_Affiliates_Requests Wo_AgoraVideoCall Wo_Albums_Media Wo_Announcement Wo_Announcement_Views Wo_Apps Wo_AppsSessions Wo_Apps_Hash Wo_Apps_Permission Wo_AudioCalls Wo_Backup_Codes Wo_Bad_Login Wo_Banned_Ip Wo_Blocks Wo_Blog Wo_BlogCommentReplies Wo_BlogComments Wo_BlogMovieDisLikes Wo_BlogMovieLikes Wo_Blog_Reaction Wo_Blogs_Categories Wo_Codes Wo_Colored_Posts Wo_CommentLikes Wo_CommentWonders Wo_Comment_Replies Wo_Comment_Replies_Likes Wo_Comment_Replies_Wonders Wo_Comments Wo_Config Wo_CustomPages Wo_Custom_Fields Wo_Egoing Wo_Einterested Wo_Einvited Wo_Emails Wo_Events Wo_Family Wo_Followers Wo_ForumThreadReplies Wo_Forum_Sections Wo_Forum_Threads Wo_Forums Wo_Funding Wo_Funding_Raise Wo_Games Wo_Games_Players Wo_Gender Wo_Gifts Wo_GroupAdmins Wo_GroupChat Wo_GroupChatUsers Wo_Group_Members Wo_Groups Wo_Groups_Categories Wo_HTML_Emails Wo_Hashtags Wo_HiddenPosts Wo_Invitation_Links Wo_Job Wo_Job_Apply Wo_Job_Categories Wo_LangIso Wo_Langs Wo_Likes Wo_Live_Sub_Users Wo_Manage_Pro Wo_Messages Wo_MonetizationSubscription Wo_MovieCommentReplies Wo_MovieComments Wo_Movies Wo_Mute Wo_Mute_Story Wo_Notifications Wo_Offers Wo_PageAdmins Wo_PageRating Wo_Pages Wo_Pages_Categories Wo_Pages_Invites Wo_Pages_Likes Wo_PatreonSubscribers Wo_Payment_Transactions Wo_Payments Wo_PendingPayments Wo_PinnedPosts Wo_Pokes Wo_Polls Wo_Posts Wo_ProductReview Wo_Products Wo_Products_Categories Wo_Products_Media Wo_ProfileFields Wo_Purchases Wo_Reactions Wo_Reactions_Types Wo_RecentSearches Wo_Refund Wo_Relationship Wo_Reports Wo_SavedPosts Wo_Stickers Wo_Story_Seen Wo_Sub_Categories Wo_Terms Wo_Tokens Wo_UploadedMedia Wo_UserAddress Wo_UserAds Wo_UserAds_Data Wo_UserCard Wo_UserCertification Wo_UserExperience Wo_UserFields Wo_UserLanguages Wo_UserMonetization Wo_UserOpenTo Wo_UserOrders Wo_UserProjects Wo_UserSkills Wo_UserStory Wo_UserStoryMedia Wo_UserTiers Wo_User_Gifts Wo_Users Wo_UsersChat Wo_Verification_Requests Wo_VideoCalles Wo_Votes Wo_Wonders bank_receipts broadcast broadcast_users wondertage_settings

Wo_Users

📋 Sütun Bilgileri

Sütun Adı Tip Null Key Default Extra
user_id int(11) NO PRIMARY NULL auto_increment
username varchar(32) NO UNIQUE
email varchar(255) NO UNIQUE
password varchar(70) NO INDEX
first_name varchar(60) NO INDEX
last_name varchar(32) NO INDEX
avatar varchar(100) NO INDEX upload/photos/d-avatar.jpg
cover varchar(100) NO - upload/photos/d-cover.jpg
background_image varchar(100) NO -
background_image_status enum('0','1') NO - 0
relationship_id int(11) NO INDEX 0
address varchar(100) NO -
working varchar(32) NO -
working_link varchar(32) NO -
about text YES - NULL
school varchar(32) NO -
gender varchar(32) NO INDEX male
birthday varchar(50) NO - 0000-00-00
country_id int(11) NO - 0
website varchar(50) NO -
facebook varchar(50) NO -
google varchar(50) NO -
twitter varchar(50) NO -
linkedin varchar(32) NO -
youtube varchar(100) NO -
vk varchar(32) NO -
instagram varchar(32) NO -
qq text YES - NULL
wechat text YES - NULL
discord text YES - NULL
mailru text YES - NULL
okru varchar(30) NO -
language varchar(31) NO - english
email_code varchar(32) NO INDEX
src varchar(32) NO INDEX Undefined
ip_address varchar(100) YES -
follow_privacy enum('1','0') NO - 0
friend_privacy enum('0','1','2','3') NO INDEX 0
post_privacy varchar(255) NO INDEX ifollow
message_privacy enum('1','0','2') NO - 0
confirm_followers enum('1','0') NO - 0
show_activities_privacy enum('0','1') NO - 1
birth_privacy enum('0','1','2') NO - 0
visit_privacy enum('0','1') NO - 0
verified enum('1','0') NO - 0
lastseen int(32) NO INDEX 0
showlastseen enum('1','0') NO - 1
emailNotification enum('1','0') NO - 1
e_liked enum('0','1') NO - 1
e_wondered enum('0','1') NO - 1
e_shared enum('0','1') NO - 1
e_followed enum('0','1') NO - 1
e_commented enum('0','1') NO - 1
e_visited enum('0','1') NO - 1
e_liked_page enum('0','1') NO - 1
e_mentioned enum('0','1') NO - 1
e_joined_group enum('0','1') NO - 1
e_accepted enum('0','1') NO - 1
e_profile_wall_post enum('0','1') NO - 1
e_sentme_msg enum('0','1') NO - 0
e_last_notif varchar(50) NO - 0
notification_settings varchar(400) NO - {"e_liked":1,"e_shared":1,"e_wondered":0,"e_commented":1,"e_followed":1,"e_accepted":1,"e_mentioned":1,"e_joined_group":1,"e_liked_page":1,"e_visited":1,"e_profile_wall_post":1,"e_memory":1}
status enum('1','0') NO INDEX 0
active enum('0','1','2') NO INDEX 0
admin enum('0','1','2') NO INDEX 0
type varchar(11) NO INDEX user
registered varchar(32) NO INDEX 0/0000
start_up enum('0','1') NO - 0
start_up_info enum('0','1') NO - 0
startup_follow enum('0','1') NO - 0
startup_image enum('0','1') NO - 0
last_email_sent int(32) NO - 0
phone_number varchar(32) NO INDEX
sms_code int(11) NO - 0
is_pro enum('0','1') NO INDEX 0
pro_time int(11) NO - 0
pro_type int(11) NO - 0
pro_remainder varchar(20) NO INDEX
joined int(11) NO INDEX 0
css_file varchar(100) NO -
timezone varchar(50) NO -
referrer int(11) NO INDEX 0
ref_user_id int(11) NO INDEX 0
ref_level text YES - NULL
balance varchar(100) NO - 0
paypal_email varchar(100) NO -
notifications_sound enum('0','1') NO - 0
order_posts_by enum('0','1') NO - 1
social_login enum('0','1') NO - 0
android_m_device_id varchar(50) NO -
ios_m_device_id varchar(50) NO -
android_n_device_id varchar(50) NO -
ios_n_device_id varchar(50) NO -
web_device_id varchar(100) NO -
wallet varchar(20) NO INDEX 0.00
lat varchar(200) NO INDEX 0
lng varchar(200) NO INDEX 0
last_location_update varchar(30) NO - 0
share_my_location int(11) NO - 1
last_data_update int(11) NO INDEX 0
details varchar(300) NO - {"post_count":0,"album_count":0,"following_count":0,"followers_count":0,"groups_count":0,"likes_count":0}
sidebar_data text YES - NULL
last_avatar_mod int(11) NO - 0
last_cover_mod int(11) NO - 0
points float unsigned NO INDEX 0
daily_points int(11) NO - 0
converted_points float unsigned NO INDEX 0
point_day_expire varchar(50) NO -
last_follow_id int(11) NO - 0
share_my_data int(11) NO - 1
last_login_data text YES - NULL
two_factor int(11) NO - 0
two_factor_hash varchar(50) NO INDEX
new_email varchar(255) NO -
two_factor_verified int(11) NO - 0
new_phone varchar(32) NO -
info_file varchar(300) NO -
city varchar(50) NO -
state varchar(50) NO -
zip varchar(11) NO -
school_completed int(11) NO - 0
weather_unit varchar(11) NO - us
paystack_ref varchar(100) NO INDEX
code_sent int(11) NO - 0
time_code_sent int(11) NO - 0
permission text YES - NULL
skills text YES - NULL
languages text YES - NULL
currently_working varchar(50) NO INDEX
banned int(5) NO INDEX 0
banned_reason varchar(500) NO -
credits float YES - 0
authy_id varchar(100) NO -
google_secret varchar(100) NO -
two_factor_method varchar(50) NO - two_factor
phone_privacy enum('0','1','2') NO - 0
have_monetization int(10) NO - 0

🔑 Index Bilgileri

Index Adı Sütun Unique Sıra Tip
PRIMARY user_id YES 1 BTREE
username username YES 1 BTREE
email email YES 1 BTREE
active active NO 1 BTREE
admin admin NO 1 BTREE
src src NO 1 BTREE
gender gender NO 1 BTREE
avatar avatar NO 1 BTREE
first_name first_name NO 1 BTREE
last_name last_name NO 1 BTREE
registered registered NO 1 BTREE
joined joined NO 1 BTREE
phone_number phone_number NO 1 BTREE
referrer referrer NO 1 BTREE
wallet wallet NO 1 BTREE
friend_privacy friend_privacy NO 1 BTREE
lat lat NO 1 BTREE
lng lng NO 1 BTREE
order1 username NO 1 BTREE
order1 user_id NO 2 BTREE
order2 email NO 1 BTREE
order2 user_id NO 2 BTREE
order3 lastseen NO 1 BTREE
order3 user_id NO 2 BTREE
order4 active NO 1 BTREE
order4 user_id NO 2 BTREE
last_data_update last_data_update NO 1 BTREE
points points NO 1 BTREE
paystack_ref paystack_ref NO 1 BTREE
relationship_id relationship_id NO 1 BTREE
post_privacy post_privacy NO 1 BTREE
email_code email_code NO 1 BTREE
password password NO 1 BTREE
status status NO 1 BTREE
type type NO 1 BTREE
is_pro is_pro NO 1 BTREE
ref_user_id ref_user_id NO 1 BTREE
currently_working currently_working NO 1 BTREE
banned banned NO 1 BTREE
two_factor_hash two_factor_hash NO 1 BTREE
pro_remainder pro_remainder NO 1 BTREE
converted_points converted_points NO 1 BTREE
📊 En son eklenen 3 kayıt gösteriliyor
user_id username email password first_name last_name avatar cover background_image background_image_status relationship_id address working working_link about school gender birthday country_id website facebook google twitter linkedin youtube vk instagram qq wechat discord mailru okru language email_code src ip_address follow_privacy friend_privacy post_privacy message_privacy confirm_followers show_activities_privacy birth_privacy visit_privacy verified lastseen showlastseen emailNotification e_liked e_wondered e_shared e_followed e_commented e_visited e_liked_page e_mentioned e_joined_group e_accepted e_profile_wall_post e_sentme_msg e_last_notif notification_settings status active admin type registered start_up start_up_info startup_follow startup_image last_email_sent phone_number sms_code is_pro pro_time pro_type pro_remainder joined css_file timezone referrer ref_user_id ref_level balance paypal_email notifications_sound order_posts_by social_login android_m_device_id ios_m_device_id android_n_device_id ios_n_device_id web_device_id wallet lat lng last_location_update share_my_location last_data_update details sidebar_data last_avatar_mod last_cover_mod points daily_points converted_points point_day_expire last_follow_id share_my_data last_login_data two_factor two_factor_hash new_email two_factor_verified new_phone info_file city state zip school_completed weather_unit paystack_ref code_sent time_code_sent permission skills languages currently_working banned banned_reason credits authy_id google_secret two_factor_method phone_privacy have_monetization
3 test29160 [email protected] $2y$10$UNnHZuTsj9tLHLwB/kBOXuF6PqVoBFQIAlgxzDOPy/rUeFjAbCRzK upload/photos/d-avatar.jpg upload/photos/d-cover.jpg 0 0 male 0000-00-00 0 english 206b411b5e6513fa196f45de44c1673d Undefined 0 0 ifollow 0 0 1 0 0 0 1766065939 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 {"e_liked":1,"e_shared":1,"e_wondered":0,"e_commented":1,"e_followed":1,"e_accepted":1,"e_mentioned":1,"e_joined_group":1,"e_liked_page":1,"e_visited":1,"e_profile_wall_post":1,"e_memory":1} 0 1 0 user 12/2025 0 0 0 0 0 0 0 0 0 1766065939 0 0 0 0 1 0 0.00 0 0 0 1 1778347293 {"post_count":"0","album_count":"0","following_count":"0","followers_count":"0","groups_count":"0","likes_count":"0","mutual_friends_count":false} {"following_data":[],"followers_data":[],"likes_data":[],"groups_data":[],"mutual_friends_data":[]} 0 0 0 0 0 0 1 0 0 0 us 0 0 0 0 two_factor 0 0
2 oguzhan [email protected] $2y$10$cvBO/KJssCkbIZ8q0bwCFeEwBBk5zsOvT8w31Z9Ya/WtvpcrDhlPe upload/photos/d-avatar.jpg upload/photos/d-cover.jpg 0 0 male 0000-00-00 0 turkish ec7841c8523a44aa58d593c5ce2b2b13 site 195.174.244.221 0 0 ifollow 0 0 1 0 0 0 1766023196 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 {"e_liked":1,"e_shared":1,"e_wondered":0,"e_commented":1,"e_followed":1,"e_accepted":1,"e_mentioned":1,"e_joined_group":1,"e_liked_page":1,"e_visited":1,"e_profile_wall_post":1,"e_memory":1} 0 1 0 user 12/2025 1 1 1 1 0 0 0 0 0 1766005284 0 0 0 0 0 0 0.00 0 0 0 1 1778347293 {"post_count":"0","album_count":"0","following_count":"0","followers_count":"0","groups_count":"0","likes_count":"0","mutual_friends_count":false} {"following_data":[],"followers_data":[],"likes_data":[],"groups_data":[],"mutual_friends_data":[]} 0 0 0 0 0 0 1 {"status":"success","country":"Turkey","countryCode":"TR","region":"07","regionName":"Antalya","city":"Kepez","zip":"27500","lat":36.9158,"lon":30.7078,"timezone":"Europe/Istanbul","isp":"Uydunet","org":"Turksat Uydu Haberlesme Kablo TV ve Isletme A.S.","as":"AS9121 Turk Telekomunikasyon Anonim Sirketi","query":"195.174.244.221"} 0 0 0 us 0 0 0 0 two_factor 0 0
1 motocluptest [email protected] $2y$10$wExsNTZ0E5mDN.v/4QXokehc3c.dNiPD.oYY8jJPbRyOEk7h5gjYS upload/photos/d-avatar.jpg upload/photos/d-cover.jpg 0 0 male 0000-00-00 0 english Undefined 195.174.244.221 0 0 ifollow 0 0 1 0 0 1 1766313539 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 {"e_liked":1,"e_shared":1,"e_wondered":0,"e_commented":1,"e_followed":1,"e_accepted":1,"e_mentioned":1,"e_joined_group":1,"e_liked_page":1,"e_visited":1,"e_profile_wall_post":1,"e_memory":1} 0 1 1 user 00/0000 1 1 1 1 0 0 0 0 0 1765998853 0 0 0 0 1 0 0.00 0 0 0 1 1778347293 {"post_count":"0","album_count":"0","following_count":"0","followers_count":"0","groups_count":"0","likes_count":"0","mutual_friends_count":false} {"following_data":[],"followers_data":[],"likes_data":[],"groups_data":[],"mutual_friends_data":[]} 0 0 0 0 0 0 1 0 0 0 us 0 0 0 0 two_factor 0 0