Skip to content

Instantly share code, notes, and snippets.

@travnewmatic

travnewmatic/gist:a76a02a33b11be7dd69abc032a577a6f Secret

Created September 29, 2016 20:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save travnewmatic/a76a02a33b11be7dd69abc032a577a6f to your computer and use it in GitHub Desktop.
Save travnewmatic/a76a02a33b11be7dd69abc032a577a6f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
mysql> show create view sogo.users;
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
| View | Create View | character_set_client | collation_connection |
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
| users | CREATE ALGORITHM=UNDEFINED DEFINER=`admin_iredmail`@`192.168.122.186` SQL SECURITY DEFINER VIEW `sogo`.`users` AS select `vmail`.`mailbox`.`username` AS `c_uid`,`vmail`.`mailbox`.`username` AS `c_name`,`vmail`.`mailbox`.`password` AS `c_password`,`vmail`.`mailbox`.`name` AS `c_cn`,`vmail`.`mailbox`.`username` AS `mail`,`vmail`.`mailbox`.`domain` AS `domain` from `vmail`.`mailbox` where ((`vmail`.`mailbox`.`enablesogo` = 1) and (`vmail`.`mailbox`.`active` = 1)) | latin1 | latin1_swedish_ci |
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
1 row in set, 1 warning (0.00 sec)
mysql>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment