
-- --------------------------------------------------------

--
-- Structure for view `antennas_license_checks`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`raimonds`@`%` SQL SECURITY DEFINER VIEW `antennas_license_checks`  AS  select `clc`.`id` AS `id`,`clc`.`user_id` AS `user_id`,`clc`.`company` AS `company`,`clc`.`location` AS `location`,`clc`.`version` AS `version`,`clc`.`created` AS `created`,`clc`.`local_time` AS `local_time`,`clc`.`ip` AS `ip`,`clc`.`result_code` AS `result_code`,`clc`.`result` AS `result`,`clc`.`problems` AS `problems` from (`client_license_checks` `clc` left join `users` `u` on((`u`.`id` = `clc`.`user_id`))) where (`u`.`cenos_app` like 'ANTENNAS') order by `clc`.`created` desc ;
