|
View: group_conf_v
| Name | group_conf_v |
| Comment | Returns groups only |
| Code | CREATE VIEW `group_conf_v` AS
SELECT `user_conf`.`id` AS `id`
, `user_conf`.`name` AS `name`
, `user_conf`.`description` AS `description`
FROM `user_conf`
WHERE (`user_conf`.`is_group` = 'Y') |
View: group_users_v
| Name | group_users_v |
| Comment | Returns Users By Group |
| Code | CREATE VIEW `group_users_v` AS
SELECT `groups`.`id` AS `group_id`
, `groups`.`name` AS `group_name`
, `user_conf`.`id` AS `user_id`
, `user_conf`.`name` AS `user_name`
, `user_conf`.`full_name` AS `user_full_name`
, `user_conf`.`password` AS `password`
FROM ((`user_conf` `groups` join `group_user_xref`
ON((`groups`.`id` = `group_user_xref`.`group_id`))) join `user_conf`
ON((`group_user_xref`.`user_id` = `user_conf`.`id`)))
WHERE (`groups`.`is_group` = 'Y') order by `groups`.`name`
, `user_conf`.`name` |
View: user_groups_v
| Name | user_groups_v |
| Comment | Returns Groups by User |
| Code | CREATE VIEW `user_groups_v` AS
SELECT `user_conf`.`id` AS `user_id`
, `user_conf`.`name` AS `user_name`
, `user_conf`.`password` AS `password`
, `user_conf`.`full_name` AS `full_name`
, `groups`.`name` AS `group_name`
, `group_user_xref`.`group_id` AS `group_id`
FROM ((`user_conf` join `group_user_xref`
ON((`user_conf`.`id` = `group_user_xref`.`user_id`))) join `user_conf` `groups`
ON((`group_user_xref`.`group_id` = `groups`.`id`)))
WHERE (`user_conf`.`is_group` = 'N') order by `user_conf`.`name`
, `groups`.`name` |
|