[pre_model_sync]
jingrow.patches.v15_0.remove_implicit_primary_key
jingrow.patches.v12_0.remove_deprecated_fields_from_pagetype #3
execute:jingrow.utils.global_search.setup_global_search_table()
execute:jingrow.reload_pg('core', 'pagetype', 'pagetype_action', force=True) #2019-09-23
execute:jingrow.reload_pg('core', 'pagetype', 'pagetype_link', force=True) #2020-10-17
execute:jingrow.reload_pg('core', 'pagetype', 'pagetype_state', force=True) #2021-12-15
execute:jingrow.reload_pg('core', 'pagetype', 'pagetype', force=True) #2017-09-22
execute:jingrow.reload_pg('core', 'pagetype', 'pagefield', force=True) #2018-02-20
jingrow.patches.v11_0.drop_column_apply_user_permissions
execute:jingrow.reload_pg('core', 'pagetype', 'custom_pageperm')
execute:jingrow.reload_pg('core', 'pagetype', 'pageperm') #2018-05-29
execute:jingrow.reload_pg('core', 'pagetype', 'comment')
execute:jingrow.reload_pg('core', 'pagetype', 'document_naming_rule', force=True)
execute:jingrow.reload_pg('core', 'pagetype', 'module_def') #2020-08-28
execute:jingrow.reload_pg('core', 'pagetype', 'version') #2017-04-01
execute:jingrow.reload_pg('email', 'pagetype', 'page_follow')
execute:jingrow.reload_pg('core', 'pagetype', 'communication_link') #2019-10-02
execute:jingrow.reload_pg('core', 'pagetype', 'has_role')
execute:jingrow.reload_pg('core', 'pagetype', 'communication') #2019-10-02
execute:jingrow.reload_pg('core', 'pagetype', 'server_script')
jingrow.patches.v11_0.replicate_old_user_permissions
jingrow.patches.v11_0.reload_and_rename_view_log #2019-01-03
jingrow.patches.v11_0.copy_fetch_data_from_options
jingrow.patches.v11_0.change_email_signature_fieldtype
execute:jingrow.reload_pg('core', 'pagetype', 'system_log')
execute:jingrow.reload_pg('core', 'pagetype', 'deleted_page')
execute:jingrow.reload_pg('core', 'pagetype', 'domain_settings')
jingrow.patches.v13_0.rename_custom_client_script
execute:jingrow.reload_pg('core', 'pagetype', 'role') #2017-05-23
execute:jingrow.reload_pg('core', 'pagetype', 'user') #2017-10-27
execute:jingrow.reload_pg('core', 'pagetype', 'report_column')
execute:jingrow.reload_pg('core', 'pagetype', 'report_filter')
execute:jingrow.reload_pg('core', 'pagetype', 'report') #2020-08-25
execute:jingrow.get_pg("User", "Guest").save()
execute:jingrow.delete_pg("PageType", "Control Panel", force=1)
execute:jingrow.delete_pg("PageType", "Tag")
execute:jingrow.db.sql("delete from `tabProperty Setter` where `property` in ('idx', '_idx')")
execute:jingrow.db.sql("update tabUser set new_password='' where ifnull(new_password, '')!=''")
execute:jingrow.permissions.reset_perms("PageType")
execute:jingrow.db.sql("delete from `tabProperty Setter` where `property` = 'idx'")
execute:jingrow.db.sql("delete from tabSessions where user is null")
execute:jingrow.delete_pg("PageType", "Backup Manager")
execute:jingrow.permissions.reset_perms("Web Page")
execute:jingrow.db.sql("delete from `tabWeb Page` where ifnull(template_path, '')!=''")
execute:jingrow.core.pagetype.language.language.update_language_names() # 2017-04-12
execute:jingrow.db.set_value("Print Settings", "Print Settings", "add_draft_heading", 1)
execute:jingrow.db.set_default('language', '')
execute:jingrow.db.sql("update tabCommunication set communication_date = creation where time(communication_date) = 0")
execute:jingrow.rename_pg('Country', 'Macedonia, Republic of', 'Macedonia', ignore_if_exists=True)
execute:jingrow.rename_pg('Country', 'Iran, Islamic Republic of', 'Iran', ignore_if_exists=True)
execute:jingrow.rename_pg('Country', 'Tanzania, United Republic of', 'Tanzania', ignore_if_exists=True)
execute:jingrow.rename_pg('Country', 'Syrian Arab Republic', 'Syria', ignore_if_exists=True)
execute:jingrow.reload_pg('desk', 'pagetype', 'notification_log')
execute:jingrow.db.sql('update tabReport set module="Desk" where name="ToDo"')
execute:jingrow.delete_pg('Page', 'data-import-tool', ignore_missing=True)
jingrow.patches.v10_0.reload_countries_and_currencies # 2021-02-03
jingrow.patches.v10_0.refactor_social_login_keys
jingrow.patches.v10_0.enable_chat_by_default_within_system_settings
jingrow.patches.v10_0.remove_custom_field_for_disabled_domain
execute:jingrow.delete_pg("Page", "chat")
jingrow.patches.v11_0.rename_standard_reply_to_email_template
execute:jingrow.delete_pg_if_exists('Page', 'user-permissions')
jingrow.patches.v10_0.set_no_copy_to_workflow_state
jingrow.patches.v10_0.increase_single_table_column_length
jingrow.patches.v11_0.create_contact_for_user
jingrow.patches.v11_0.update_list_user_settings
jingrow.patches.v11_0.rename_workflow_action_to_workflow_action_master #13-06-2018
jingrow.patches.v11_0.rename_email_alert_to_notification #13-06-2018
jingrow.patches.v11_0.delete_duplicate_user_permissions
jingrow.patches.v11_0.set_dropbox_file_backup
jingrow.patches.v10_0.set_default_locking_time
jingrow.patches.v10_0.modify_smallest_currency_fraction
jingrow.patches.v10_0.modify_naming_series_table
jingrow.patches.v10_0.enhance_security
jingrow.patches.v11_0.multiple_references_in_events
jingrow.patches.v11_0.set_allow_self_approval_in_workflow
jingrow.patches.v11_0.remove_skip_for_pagetype
jingrow.patches.v11_0.migrate_report_settings_for_new_listview
jingrow.patches.v11_0.delete_all_prepared_reports
jingrow.patches.v11_0.fix_order_by_in_reports_json
execute:jingrow.delete_pg('Page', 'applications', ignore_missing=True)
jingrow.patches.v11_0.set_missing_creation_and_modified_value_for_user_permissions
jingrow.patches.v11_0.set_default_letter_head_source
jingrow.patches.v12_0.set_primary_key_in_series
execute:jingrow.delete_pg("Page", "modules", ignore_missing=True)
jingrow.patches.v12_0.setup_comments_from_communications
jingrow.patches.v12_0.replace_null_values_in_tables
jingrow.patches.v12_0.reset_home_settings
jingrow.patches.v12_0.update_print_format_type
jingrow.patches.v11_0.remove_pagetype_user_permissions_for_page_and_report #2019-05-01
jingrow.patches.v11_0.apply_customization_to_custom_pagetype
jingrow.patches.v12_0.remove_feedback_rating
jingrow.patches.v12_0.move_form_attachments_to_attachments_folder
jingrow.patches.v12_0.move_timeline_links_to_dynamic_links
jingrow.patches.v12_0.delete_feedback_request_if_exists #1
jingrow.patches.v12_0.rename_events_repeat_on
jingrow.patches.v12_0.fix_public_private_files
jingrow.patches.v12_0.move_email_and_phone_to_child_table
jingrow.patches.v12_0.delete_duplicate_indexes  # 2022-12-15
jingrow.patches.v12_0.set_default_incoming_email_port
jingrow.patches.v12_0.update_global_search
jingrow.patches.v12_0.setup_tags
jingrow.patches.v12_0.update_auto_repeat_status_and_not_submittable
jingrow.patches.v12_0.create_notification_settings_for_user
jingrow.patches.v11_0.make_all_prepared_report_attachments_private #2019-11-26
jingrow.patches.v12_0.setup_email_linking
jingrow.patches.v12_0.change_existing_dashboard_chart_filters
jingrow.patches.v12_0.set_correct_assign_value_in_pgs #2020-07-13
execute:jingrow.delete_pg('PageType', 'Test Runner') # 2022-05-19
execute:jingrow.delete_pg_if_exists('PageType', 'Google Maps Settings')
execute:jingrow.db.set_default('desktop:home_page', 'workspace')
execute:jingrow.delete_pg_if_exists('PageType', 'GSuite Settings')
execute:jingrow.delete_pg_if_exists('PageType', 'GSuite Templates')
execute:jingrow.delete_pg_if_exists('PageType', 'GCalendar Account')
execute:jingrow.delete_pg_if_exists('PageType', 'GCalendar Settings')
jingrow.patches.v12_0.remove_example_email_thread_notify
execute:from jingrow.desk.page.setup_wizard.install_fixtures import update_genders;update_genders()
jingrow.patches.v12_0.set_correct_url_in_files
execute:jingrow.reload_pg('core', 'pagetype', 'pagetype') #2022-06-21
execute:jingrow.reload_pg('custom', 'pagetype', 'property_setter')
jingrow.patches.v13_0.remove_invalid_options_for_data_fields
jingrow.patches.v13_0.website_theme_custom_scss
jingrow.patches.v13_0.make_user_type
jingrow.patches.v13_0.set_existing_dashboard_charts_as_public
jingrow.patches.v13_0.set_path_for_homepage_in_web_page_view
jingrow.patches.v13_0.migrate_translation_column_data
jingrow.patches.v13_0.set_read_times
jingrow.patches.v13_0.remove_web_view
jingrow.patches.v13_0.site_wise_logging
jingrow.patches.v13_0.set_unique_for_page_view
jingrow.patches.v13_0.remove_tailwind_from_page_builder
jingrow.patches.v13_0.rename_onboarding
jingrow.patches.v13_0.email_unsubscribe
execute:jingrow.delete_pg("Web Template", "Section with Left Image", force=1)
execute:jingrow.delete_pg("PageType", "Onboarding Slide")
execute:jingrow.delete_pg("PageType", "Onboarding Slide Field")
execute:jingrow.delete_pg("PageType", "Onboarding Slide Help Link")
jingrow.patches.v13_0.update_date_filters_in_user_settings
jingrow.patches.v13_0.update_duration_options
jingrow.patches.v13_0.replace_old_data_import # 2020-06-24
jingrow.patches.v13_0.create_custom_dashboards_cards_and_charts
jingrow.patches.v13_0.rename_is_custom_field_in_dashboard_chart
jingrow.patches.v13_0.add_standard_navbar_items # 2020-12-15
jingrow.patches.v13_0.generate_theme_files_in_public_folder
jingrow.patches.v13_0.increase_password_length
jingrow.patches.v12_0.fix_email_id_formatting
jingrow.patches.v13_0.add_toggle_width_in_navbar_settings
jingrow.patches.v13_0.rename_notification_fields
jingrow.patches.v13_0.remove_duplicate_navbar_items
jingrow.patches.v13_0.set_social_icons
jingrow.patches.v12_0.set_default_password_reset_limit
jingrow.patches.v13_0.set_route_for_blog_category
jingrow.patches.v13_0.enable_custom_script
jingrow.patches.v13_0.update_newsletter_content_type
execute:jingrow.db.set_value('Website Settings', 'Website Settings', {'navbar_template': 'Standard Navbar', 'footer_template': 'Standard Footer'})
jingrow.patches.v13_0.web_template_set_module #2020-10-05
jingrow.patches.v13_0.remove_custom_link
execute:jingrow.delete_pg("PageType", "Footer Item")
execute:jingrow.reload_pagetype('user')
execute:jingrow.reload_pagetype('pageperm')
jingrow.patches.v13_0.replace_field_target_with_open_in_new_tab
jingrow.patches.v13_0.add_switch_theme_to_navbar_settings
jingrow.patches.v13_0.update_icons_in_customized_desk_pages
execute:jingrow.db.set_default('desktop:home_page', 'space')
execute:jingrow.delete_pg_if_exists('Page', 'workspace')
execute:jingrow.delete_pg_if_exists('Page', 'dashboard', force=1)
jingrow.core.pagetype.page.patches.drop_unused_pages
jingrow.patches.v13_0.remove_chat
jingrow.patches.v13_0.rename_desk_page_to_workspace # 02.02.2021
jingrow.patches.v13_0.delete_package_publish_tool
jingrow.patches.v13_0.rename_list_view_setting_to_list_view_settings
jingrow.patches.v13_0.remove_twilio_settings
jingrow.patches.v12_0.rename_uploaded_files_with_proper_name
jingrow.patches.v13_0.queryreport_columns
jingrow.patches.v13_0.jinja_hook
jingrow.patches.v13_0.update_notification_channel_if_empty
jingrow.patches.v13_0.set_first_day_of_the_week
jingrow.patches.v13_0.encrypt_2fa_secrets
jingrow.patches.v13_0.reset_corrupt_defaults
jingrow.patches.v13_0.remove_share_for_std_users
execute:jingrow.reload_pg('custom', 'pagetype', 'custom_field')
jingrow.email.pagetype.email_queue.patches.drop_search_index_on_message_id
jingrow.patches.v14_0.save_ratings_in_fraction #23-12-2021
jingrow.patches.v14_0.transform_todo_schema
jingrow.patches.v14_0.remove_post_and_post_comment
jingrow.patches.v14_0.reset_creation_datetime
jingrow.patches.v14_0.remove_is_first_startup
jingrow.patches.v14_0.clear_long_pending_stale_logs
jingrow.patches.v14_0.log_settings_migration
jingrow.patches.v14_0.setup_likes_from_feedback
jingrow.patches.v14_0.update_webforms
jingrow.patches.v14_0.delete_payment_gateways
jingrow.patches.v15_0.remove_event_streaming
jingrow.patches.v15_0.copy_disable_prepared_report_to_prepared_report
execute:jingrow.reload_pg("desk", "pagetype", "Form Tour")
execute:jingrow.delete_pg('Page', 'recorder', ignore_missing=True, force=True)
jingrow.patches.v14_0.modify_value_column_size_for_singles

[post_model_sync]
execute:jingrow.get_pg('Role', 'Guest').save() # remove desk access
jingrow.core.pagetype.role.patches.v13_set_default_desk_properties
jingrow.patches.v14_0.update_workspace2 # 06.06.2023
jingrow.patches.v14_0.drop_data_import_legacy
jingrow.patches.v14_0.copy_mail_data #08.03.21
jingrow.patches.v14_0.update_github_endpoints #08-11-2021
jingrow.patches.v14_0.remove_db_aggregation
jingrow.patches.v14_0.update_color_names_in_kanban_board_column
jingrow.patches.v14_0.update_is_system_generated_flag
jingrow.patches.v14_0.update_auto_account_deletion_duration
jingrow.patches.v14_0.update_integration_request
jingrow.patches.v14_0.set_document_expiry_default
jingrow.patches.v14_0.delete_data_migration_tool
jingrow.patches.v14_0.set_suspend_email_queue_default
jingrow.patches.v14_0.different_encryption_key
jingrow.patches.v14_0.update_multistep_webforms
execute:jingrow.delete_pg('Page', 'background_jobs', ignore_missing=True, force=True)
jingrow.patches.v14_0.drop_unused_indexes
jingrow.patches.v15_0.drop_modified_index
jingrow.patches.v14_0.update_attachment_comment
jingrow.patches.v15_0.set_contact_full_name
execute:jingrow.delete_pg("Page", "activity", force=1)
jingrow.patches.v14_0.disable_email_accounts_with_oauth
execute:jingrow.delete_pg("Page", "translation-tool", force=1)
jingrow.patches.v15_0.remove_prepared_report_settings_from_system_settings
jingrow.patches.v14_0.remove_manage_subscriptions_from_navbar
jingrow.patches.v15_0.remove_background_jobs_from_dropdown
jingrow.desk.pagetype.form_tour.patches.introduce_ui_tours
execute:jingrow.delete_pg_if_exists("Workspace", "Customization")
execute:jingrow.db.set_single_value("Document Naming Settings", "default_amend_naming", "Amend Counter")
jingrow.patches.v15_0.move_event_cancelled_to_status
jingrow.patches.v15_0.set_file_type
jingrow.core.pagetype.data_import.patches.remove_stale_pagefields_from_legacy_version
jingrow.patches.v15_0.validate_newsletter_recipients
jingrow.patches.v15_0.sanitize_workspace_titles
jingrow.custom.pagetype.property_setter.patches.remove_invalid_fetch_from_expressions
jingrow.integrations.pagetype.oauth_client.patches.set_default_allowed_role_in_oauth_client
jingrow.patches.v16_0.add_app_launcher_in_navbar_settings
jingrow.patches.v15_0.remove_workspace_settings_navbar_items
jingrow.patches.v16_0.move_role_desk_settings_to_user
jingrow.patches.v14_0.fix_user_settings_collation
jingrow.printing.pagetype.print_format.patches.sets_wkhtmltopdf_as_default_for_pdf_generator_field
