SHOW TABLES LIKE 'tbl_migration%'

SHOW TABLES

SHOW FULL COLUMNS FROM `user`

SHOW TABLES LIKE 'property%'

SHOW FULL COLUMNS FROM `authitem`

SHOW FULL COLUMNS FROM `languages`

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

SHOW FULL COLUMNS FROM `tbl_migration`

DELETE FROM `log` WHERE 0=1

SHOW CREATE TABLE `authitem`

SHOW CREATE TABLE `user`

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

SHOW CREATE TABLE `tbl_migration`

SHOW CREATE TABLE `languages`

SELECT * FROM `user` `t` WHERE `t`.`uID` IS NULL LIMIT 1

SELECT * FROM `authitem` `t` WHERE `t`.`name`='QR_Code_Role' AND `t`.`type`=2 AND `t`.`portal_enable`=1 AND (portal_start_address IS NOT NULL AND portal_start_address <> '') LIMIT 1

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

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

SELECT COUNT(uID) FROM user WHERE uID = '' AND FIND_IN_SET('hidden_super_admin', `role`) > 0

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` = 'm250606_023205_add_qrlink_for_public'

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

SELECT * FROM `authitem` `t` WHERE `t`.`name`='QR_Code_Role' AND `t`.`type`=2 AND `t`.`qrlink_enable`=1 AND (qrlink_address IS NOT NULL AND qrlink_address <> '') LIMIT 1

SELECT DISTINCT(`child`), au.itemname, item.group_uID
FROM authitemchild AS ac
LEFT JOIN authassignment AS au ON ac.parent=au.itemname
LEFT JOIN authitem AS item ON item.name=ac.child AND item.type = 0
WHERE userid=NULL AND au.itemname <> 'QR_Code_Role'