localhost:3306/xenforo_forum/ https://hermes.xlv.nl/index.php?route=/database/sql&db=xenforo_forum
Uw SQL-query is succesvol uitgevoerd.
SHOW TABLE STATUS WHERE name LIKE 'xf_user';
xf_user InnoDB 10 Dynamic 5223 304 1589248 0 1982464 2097152 5285 2024-04-03 08:15:58 NULL NULL utf8mb4_0900_ai_ci NULL
localhost:3306/xenforo_forum/ https://hermes.xlv.nl/index.php?route=/database/sql&db=xenforo_forum
Uw SQL-query is succesvol uitgevoerd.
SHOW FULL COLUMNS FROM `xf_user`;
user_id int unsigned NULL NO PRI NULL auto_increment select,insert,update,references
username varchar(50) utf8mb4_0900_ai_ci NO UNI NULL select,insert,update,references
username_date int unsigned NULL NO 0 select,insert,update,references
username_date_visible int unsigned NULL NO 0 select,insert,update,references
email varchar(120) utf8mb4_0900_ai_ci NO MUL NULL select,insert,update,references
custom_title varchar(50) utf8mb4_0900_ai_ci NO select,insert,update,references
language_id int unsigned NULL NO NULL select,insert,update,references
style_id int unsigned NULL NO NULL select,insert,update,references 0 = use system default
timezone varchar(50) utf8mb4_0900_ai_ci NO NULL select,insert,update,references Example: 'Europe/London'
visible tinyint unsigned NULL NO 1 select,insert,update,references Show browsing activity to others
activity_visible tinyint unsigned NULL NO 1 select,insert,update,references
user_group_id int unsigned NULL NO NULL select,insert,update,references
secondary_group_ids varbinary(255) NULL NO NULL select,insert,update,references
display_style_group_id int unsigned NULL NO 0 select,insert,update,references User group ID that provides user styling
permission_combination_id int unsigned NULL NO MUL NULL select,insert,update,references
message_count int unsigned NULL NO MUL 0 select,insert,update,references
question_solution_count int unsigned NULL NO MUL 0 select,insert,update,references
conversations_unread smallint unsigned NULL NO 0 select,insert,update,references
register_date int unsigned NULL NO MUL 0 select,insert,update,references
last_activity int unsigned NULL NO MUL 0 select,insert,update,references
last_summary_email_date int unsigned NULL YES MUL NULL select,insert,update,references
trophy_points int unsigned NULL NO MUL 0 select,insert,update,references
alerts_unviewed smallint unsigned NULL NO 0 select,insert,update,references
alerts_unread smallint unsigned NULL NO 0 select,insert,update,references
avatar_date int unsigned NULL NO 0 select,insert,update,references
avatar_width smallint unsigned NULL NO 0 select,insert,update,references
avatar_height smallint unsigned NULL NO 0 select,insert,update,references
avatar_highdpi tinyint unsigned NULL NO 0 select,insert,update,references
gravatar varchar(120) utf8mb4_0900_ai_ci NO select,insert,update,references If specified, this is an email address correspondi...
user_state enum('valid','email_confirm','email_confirm_edit',... utf8mb4_0900_ai_ci NO MUL valid select,insert,update,references
security_lock enum('','change','reset') utf8mb4_0900_ai_ci NO select,insert,update,references
is_moderator tinyint unsigned NULL NO 0 select,insert,update,references
is_admin tinyint unsigned NULL NO 0 select,insert,update,references
is_banned tinyint unsigned NULL NO 0 select,insert,update,references
reaction_score int NULL NO MUL 0 select,insert,update,references
vote_score int NULL NO MUL 0 select,insert,update,references
warning_points int unsigned NULL NO 0 select,insert,update,references
is_staff tinyint unsigned NULL NO MUL 0 select,insert,update,references
secret_key varbinary(32) NULL NO NULL select,insert,update,references
privacy_policy_accepted int unsigned NULL NO 0 select,insert,update,references
terms_accepted int unsigned NULL NO 0 select,insert,update,references
siropu_shoutbox_last_active int unsigned NULL NO MUL 0 select,insert,update,references
siropu_shoutbox_post_count int unsigned NULL NO MUL 0 select,insert,update,references
siropu_shoutbox_ban int NULL NO MUL -1 select,insert,update,references
nf_tickets_count int unsigned NULL NO MUL 0 select,insert,update,references
nf_tickets_unread int unsigned NULL NO MUL 0 select,insert,update,references
andy_country_flag_select varchar(50) utf8mb4_0900_ai_ci NO select,insert,update,references
siropu_shoutbox_room_id int unsigned NULL NO MUL 0 select,insert,update,references