SHOW TABLES

SHOW TABLES LIKE 'tbl_migration%'

SHOW TABLES LIKE 'property%'

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

SHOW FULL COLUMNS FROM `tbl_migration`

SHOW FULL COLUMNS FROM `user`

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

SHOW FULL COLUMNS FROM `property`

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

SELECT * FROM `property` `t` WHERE (category = 'settings' AND subcategory = 'user' AND name = 'default_language') LIMIT 1

SHOW FULL COLUMNS FROM `messages`

SHOW FULL COLUMNS FROM `languages`

SHOW FULL COLUMNS FROM `message_categories`

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

SHOW CREATE TABLE `tbl_migration`

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

SHOW CREATE TABLE `property`

SHOW CREATE TABLE `messages`

SHOW CREATE TABLE `user`

SHOW CREATE TABLE `languages`

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

DELETE FROM `log` WHERE 0=1

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

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Sign in with Entra ID SSO' LIMIT 1

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

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Deployed. Preparing Refresh ...' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Last 30 Days' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Edit Actual Filter' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Refreshing' LIMIT 1

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

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

SHOW CREATE TABLE `message_categories`

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Active' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Select Page' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Next Month' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Dashboard Name cannot be blank.' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Search customer' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Edit Advanced Filter' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Empty' LIMIT 1

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

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Next 30 Days' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Today' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Forgot password' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Next 7 Days' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Custom' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE `t`.`message_from`='Stop' AND `t`.`language_code`='de' ORDER BY secure DESC LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Please enter a number smaller than 1000' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Please choose date' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '17' AND BINARY message_from = 'ACTIVE' LIMIT 1

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

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Use * for any number of characters, and ? for a single character<br>Example: Fluke* (starts with Fluke), *179 (ends with 179), Flu?e (one character between Flu and e).' LIMIT 1

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

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 message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Primary Key' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Blue Theme' LIMIT 1

SELECT * FROM `message_categories` `t`

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Last 7 Days' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Pending' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Name cannot be blank.' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Please wait' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Add Advanced Filter' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Expand' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Login' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Yesterday' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Apply' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Search calibration' LIMIT 1

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

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Black Theme' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Collapse' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Sign in with Google' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Clear' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Search booking' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Choose date' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '19' AND BINARY message_from = 'ReCaptcha' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '19' AND BINARY message_from = 'Remember me next time' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Register' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '19' AND BINARY message_from = 'Skin' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Columns' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Stop' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Tomorrow' LIMIT 1

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 message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Search inventory' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '17' AND BINARY message_from = 'Sorry, there was an error with your request.' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Approved' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Add Actual Filter' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Version {v}' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'ALL' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '17' AND BINARY message_from = 'DELETED' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Don\'t have an account?' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Yes' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '19' AND BINARY message_from = 'User Name' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Sign in' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '17' AND BINARY message_from = 'INACTIVE' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'OR' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '19' AND BINARY message_from = 'Password' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Copied' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '32' AND BINARY message_from = 'User Name cannot be blank.' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Last Month' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '32' AND BINARY message_from = 'Resend activation email' 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'

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

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '19' AND BINARY message_from = 'Login with LDAP' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'This Month' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Inactive' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '19' AND BINARY message_from = 'Language' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Unique Index' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'No' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE `t`.`message_from`='OR' AND `t`.`language_code`='de' ORDER BY secure DESC LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '19' AND BINARY message_from = 'Hint: Provide proper login details' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Sign in with Entra ID' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Index' LIMIT 1