SHOW TABLES LIKE 'tbl_migration%'

SHOW TABLES

SHOW TABLES LIKE 'property%'

SHOW FULL COLUMNS FROM `tbl_migration`

SHOW FULL COLUMNS FROM `languages`

SHOW TABLES LIKE 'tbl_migration'

SELECT `version`, `apply_time`
FROM `tbl_migration`
ORDER BY `version` DESC

SELECT name,value FROM `property` `t` WHERE `t`.`category`='settings' AND `t`.`subcategory`='migration' AND (modified IS NOT NULL)

DELETE FROM `log` WHERE 0=1

SELECT name,value FROM `property` `t` WHERE `t`.`category`='settings' AND `t`.`subcategory`='file_store' AND (modified IS NOT NULL)

SHOW CREATE TABLE `languages`

SHOW CREATE TABLE `tbl_migration`

SELECT name,value FROM `property` `t` WHERE `t`.`category`='settings' AND `t`.`subcategory`='calibration' AND (modified IS NOT NULL)

SELECT name,value FROM `property` `t` WHERE `t`.`category`='settings' AND `t`.`subcategory`='customer' AND (modified IS NOT NULL)

SELECT * FROM `languages` `t` ORDER BY sort_order DESC

SELECT COUNT(*) FROM tbl_migration WHERE `version` = 'm240320_082359_add_new_fields_for_qrcode_role'

SELECT COUNT(*) FROM tbl_migration WHERE `version` = 'm250606_023205_add_qrlink_for_public'