Hello. Is there a way to view/edit an app record in the catalog through MySQL? Specifically, I want to uncheck the box in the app records that forces app updates from all the apps in the catalog where it shows up.
Does anyone know what that field is called?
mysql> describe mobile_device_apps;
-----------------------------------------------------------------------------------------
| Field | Type | Null | Key | Default | Extra |
-----------------------------------------------------------------------------------------
| mobile_device_app_id | int(11) | NO | PRI | NULL | auto_increment |
| app_name | varchar(255) | NO | | | |
| description | longtext | YES | | NULL | |
| bundle_id | varchar(255) | NO | MUL | | |
| current_version | varchar(255) | NO | | | |
| category_id | int(11) | NO | | -1 | |
| icon_attachment_id | int(11) | NO | | -1 | |
| provisioning_profile_id | int(11) | NO | | -1 | |
| itunes_store_url | varchar(2083) | NO | | | |
| all_mobile_devices | tinyint(1) | NO | | 0 | |
| deployed_via_self_service | tinyint(1) | NO | | 1 | |
| deploy_as_managed_app | tinyint(1) | NO | | 1 | |
| remove_app_when_mdm_profile_removed | tinyint(1) | NO | | 0 | |
| prevent_backup_of_app_data | tinyint(1) | NO | | 0 | |
| is_free | tinyint(1) | NO | | 1 | |
| hosting_location | tinyint(1) | NO | | 0 | |
| external_url | varchar(255) | NO | | | |
| itunes_id | varchar(255) | NO | | | |
| deleted | tinyint(1) | NO | | 0 | |
| ipa_name | varchar(255) | NO | | | |
| md5 | varchar(255) | NO | | | |
| per_app_vpn_name | varchar(255) | NO | | None | |
| per_app_vpn_uuid | varchar(255) | NO | | -1 | |
| featured | tinyint(1) | NO | | 0 | |
| keep_description_and_icon_up_to_date | tinyint(1) | NO | | 0 | |
| itunes_sync_time | int(11) | NO | | 0 | |
| itunes_region | varchar(2) | NO | | US | |
| vpp_admin_account_id | int(11) | NO | | -1 | |
| assign_vpp_device_based_licenses | tinyint(1) | NO | | 0 | |
| take_over_management | tinyint(1) | NO | | 0 | |
| available_after_install | tinyint(1) | NO | | 1 | |
| require_network_tethered | tinyint(1) | NO | | 0 | |
| available_in_appstore | tinyint(1) | NO | | 1 | |
| enabled | tinyint(1) | NO | | 1 | |
| keep_app_updated_on_devices | tinyint(1) | NO | | 0 | |
-----------------------------------------------------------------------------------------+
35 rows in set (0.01 sec)