CREATE ALGORITHM=UNDEFINED DEFINER=`drupal_trac_user`@`localhost` SQL SECURITY DEFINER VIEW `SVN_USERS` AS select `users`.`uid` AS `uid`,`users`.`name` AS `name`,`users`.`pass` AS `pass`,`users`.`mail` AS `mail`,`users`.`mode` AS `mode`,`users`.`sort` AS `sort`,`users`.`threshold` AS `threshold`,`users`.`theme` AS `theme`,`users`.`signature` AS `signature`,`users`.`created` AS `created`,`users`.`access` AS `access`,`users`.`login` AS `login`,`users`.`status` AS `status`,`users`.`timezone` AS `timezone`,`users`.`language` AS `language`,`users`.`picture` AS `picture`,`users`.`init` AS `init`,`users`.`data` AS `data`,`users`.`envname` AS `envname` from `users` where (`users`.`envname` is not null);