You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
16 lines
1.9 KiB
16 lines
1.9 KiB
TYPE=VIEW
|
|
query=select `main_database`.`firmwares`.`firmware_id` AS `firmware_id`,`main_database`.`firmwares`.`filepath` AS `filepath`,`main_database`.`firmwares`.`etiqueta` AS `etiqueta`,`main_database`.`products`.`product` AS `product`,`main_database`.`devices`.`product_id` AS `product_id`,`main_database`.`devices`.`chip_id` AS `chip_id` from ((`main_database`.`devices` join `main_database`.`firmwares` on(`main_database`.`devices`.`firmware_id_update` = `main_database`.`firmwares`.`firmware_id`)) join `main_database`.`products` on(`main_database`.`devices`.`product_id` = `main_database`.`products`.`product_id`))
|
|
md5=2924f0f66852d1cee702f8a855488c29
|
|
updatable=1
|
|
algorithm=0
|
|
definer_user=aplication
|
|
definer_host=%
|
|
suid=1
|
|
with_check_option=0
|
|
timestamp=2022-02-18 11:22:55
|
|
create-version=2
|
|
source=select `firmwares`.`firmware_id` AS `firmware_id`,`firmwares`.`filepath` AS `filepath`,`firmwares`.`etiqueta` AS `etiqueta`,`products`.`product` AS `product`,`devices`.`product_id` AS `product_id`,`devices`.`chip_id` AS `chip_id` from ((`devices` join `firmwares` on((`devices`.`firmware_id_update` = `firmwares`.`firmware_id`))) join `products` on((`devices`.`product_id` = `products`.`product_id`)))
|
|
client_cs_name=utf8mb4
|
|
connection_cl_name=utf8mb4_general_ci
|
|
view_body_utf8=select `main_database`.`firmwares`.`firmware_id` AS `firmware_id`,`main_database`.`firmwares`.`filepath` AS `filepath`,`main_database`.`firmwares`.`etiqueta` AS `etiqueta`,`main_database`.`products`.`product` AS `product`,`main_database`.`devices`.`product_id` AS `product_id`,`main_database`.`devices`.`chip_id` AS `chip_id` from ((`main_database`.`devices` join `main_database`.`firmwares` on(`main_database`.`devices`.`firmware_id_update` = `main_database`.`firmwares`.`firmware_id`)) join `main_database`.`products` on(`main_database`.`devices`.`product_id` = `main_database`.`products`.`product_id`))
|
|
mariadb-version=100513
|
|
|