Krenair

English Wikipedia user table on public tools replica

Aug 2nd, 2013
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.17 KB | None | 0 0
  1. alex@alex:~$ ssh tools-login.wmflabs.org -t sql enwiki
  2.  
  3. If you are having access problems, please see: https://wikitech.wikimedia.org/wiki/Access#Accessing_public_and_private_instances
  4. Reading table information for completion of table and column names
  5. You can turn off this feature to get a quicker startup with -A
  6.  
  7. Welcome to the MariaDB monitor. Commands end with ; or \g.
  8. Your MariaDB connection id is 7189339
  9. Server version: 5.5.30-MariaDB-mariadb1~precise-log mariadb.org binary distribution
  10.  
  11. Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others.
  12.  
  13. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  14.  
  15. MariaDB [enwiki_p]> EXPLAIN user;
  16. +--------------------------+-----------------+------+-----+---------+-------+
  17. | Field | Type | Null | Key | Default | Extra |
  18. +--------------------------+-----------------+------+-----+---------+-------+
  19. | user_id | int(5) unsigned | NO | | 0 | |
  20. | user_name | varbinary(255) | NO | | | |
  21. | user_real_name | varbinary(255) | NO | | | |
  22. | user_password | tinyblob | NO | | NULL | |
  23. | user_newpassword | tinyblob | NO | | NULL | |
  24. | user_email | tinyblob | NO | | NULL | |
  25. | user_options | blob | NO | | NULL | |
  26. | user_touched | varbinary(14) | NO | | | |
  27. | user_token | varbinary(32) | NO | | | |
  28. | user_email_authenticated | varbinary(14) | YES | | NULL | |
  29. | user_email_token | varbinary(32) | YES | | NULL | |
  30. | user_email_token_expires | varbinary(14) | YES | | NULL | |
  31. | user_registration | varbinary(14) | YES | | NULL | |
  32. | user_newpass_time | varbinary(14) | YES | | NULL | |
  33. | user_editcount | int(11) | YES | | NULL | |
  34. +--------------------------+-----------------+------+-----+---------+-------+
  35. 15 rows in set (0.04 sec)
Advertisement
Add Comment
Please, Sign In to add comment