-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `network_theraphy_new`
--

-- --------------------------------------------------------

--
-- Table structure for table `globals`
--

CREATE TABLE IF NOT EXISTS `globals` (
  `gl_name` varchar(63) NOT NULL,
  `gl_index` int(11) NOT NULL DEFAULT '0',
  `gl_value` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`gl_name`,`gl_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `globals`
--

INSERT INTO `globals` (`gl_name`, `gl_index`, `gl_value`) VALUES
('activate_ccr_ccd_report', 0, '1'),
('addr_label_type', 0, '1'),
('advance_directives_warning', 0, ''),
('age_display_format', 0, '0'),
('age_display_limit', 0, '3'),
('allow_debug_language', 0, ''),
('allow_early_check_in', 0, '1'),
('allow_multiple_databases', 0, ''),
('allow_pat_delete', 0, ''),
('allow_portal_appointments', 0, '1'),
('allow_portal_chat', 0, '1'),
('amendments', 0, '1'),
('api_log_option', 0, '2'),
('appt_display_sets_color_1', 0, '#FFFFFF'),
('appt_display_sets_color_2', 0, '#E6E6FF'),
('appt_display_sets_color_3', 0, '#E6FFE6'),
('appt_display_sets_color_4', 0, '#FFE6FF'),
('appt_display_sets_option', 0, '1'),
('appt_recurrences_widget', 0, '1'),
('atna_audit_cacert', 0, ''),
('atna_audit_host', 0, ''),
('atna_audit_localcert', 0, ''),
('atna_audit_port', 0, '6514'),
('audit_events_backup', 0, '1'),
('audit_events_cdr', 0, ''),
('audit_events_order', 0, '1'),
('audit_events_other', 0, '1'),
('audit_events_patient-record', 0, '1'),
('audit_events_query', 0, ''),
('audit_events_scheduling', 0, '1'),
('audit_events_security-administration', 0, '1'),
('auto_create_new_encounters', 0, '1'),
('backup_log_dir', 0, '/tmp'),
('barcode_label_type', 0, '9'),
('billing_log_option', 0, '1'),
('billing_phone_number', 0, ''),
('calendar_appt_style', 0, '2'),
('calendar_interval', 0, '15'),
('calendar_view_type', 0, 'day'),
('cash_receipts_report_invoice', 0, '0'),
('ccda_alt_service_enable', 0, '0'),
('cdr_report_nice', 0, ''),
('certificate_authority_crt', 0, ''),
('certificate_authority_key', 0, ''),
('chart_label_type', 0, '1'),
('checkout_roll_off', 0, '0'),
('client_certificate_valid_in_days', 0, '365'),
('cms_1500_box_31_date', 0, '0'),
('cms_1500_box_31_format', 0, '0'),
('cms_left_margin_default', 0, '20'),
('cms_top_margin_default', 0, '24'),
('configuration_import_export', 0, ''),
('couchdb_connection_ssl', 0, '1'),
('couchdb_dbase', 0, ''),
('couchdb_encryption', 0, '1'),
('couchdb_host', 0, 'localhost'),
('couchdb_log', 0, ''),
('couchdb_pass', 0, ''),
('couchdb_port', 0, '6984'),
('couchdb_ssl_allow_selfsigned', 0, ''),
('couchdb_user', 0, ''),
('country_data_type', 0, '26'),
('country_list', 0, 'country'),
('css_header', 0, 'style_cobalt_blue.css'),
('currency_decimals', 0, '2'),
('currency_dec_point', 0, '.'),
('currency_thousands_sep', 0, ','),
('dated_reminders_max_alerts_to_show', 0, '5'),
('date_display_format', 0, '0'),
('daysheet_provider_totals', 0, '1'),
('default_chief_complaint', 0, ''),
('default_encounter_view', 0, '0'),
('default_fee_sheet_line_item_provider', 0, ''),
('default_rendering_provider', 0, '1'),
('default_search_code_type', 0, 'ICD10'),
('default_second_tab', 0, ''),
('default_top_pane', 0, '../../interface/main/finder/dynamic_finder.php'),
('default_visit_category', 0, '_blank'),
('disable_calendar', 0, ''),
('disable_chart_tracker', 0, ''),
('disable_eligibility_log', 0, ''),
('disable_immunizations', 0, ''),
('disable_non_default_groups', 0, '1'),
('disable_pat_trkr', 0, ''),
('disable_prescriptions', 0, ''),
('disable_rcb', 0, ''),
('discount_by_money', 0, '1'),
('display_units_in_billing', 0, ''),
('docs_see_entire_calendar', 0, ''),
('document_storage_method', 0, '0'),
('drive_encryption', 0, '1'),
('drug_screen', 0, ''),
('drug_testing_percentage', 0, '33'),
('easipro_enable', 0, ''),
('easipro_name', 0, ''),
('easipro_pass', 0, ''),
('easipro_server', 0, ''),
('EMAIL_METHOD', 0, 'SMTP'),
('EMAIL_NOTIFICATION_HOUR', 0, '50'),
('Emergency_Login_email_id', 0, ''),
('enable_alert_log', 0, '1'),
('enable_allergy_check', 0, '1'),
('enable_amc', 0, '1'),
('enable_amc_prompting', 0, '1'),
('enable_amc_tracking', 0, '1'),
('enable_atna_audit', 0, ''),
('enable_auditlog', 0, '1'),
('enable_auditlog_encryption', 0, ''),
('enable_batch_payment', 0, '1'),
('enable_cdr', 0, '1'),
('enable_cdr_crp', 0, '1'),
('enable_cdr_crw', 0, '1'),
('enable_cdr_new_crp', 0, '1'),
('enable_cdr_prw', 0, '1'),
('enable_compact_mode', 0, ''),
('enable_cqm', 0, '1'),
('enable_database_connection_pooling', 0, '1'),
('enable_edihistory_in_left_menu', 0, '1'),
('enable_fees_in_left_menu', 0, '1'),
('enable_follow_up_encounters', 0, ''),
('enable_group_therapy', 0, ''),
('enable_help', 0, '1'),
('enable_hylafax', 0, ''),
('enable_oa', 0, ''),
('enable_percent_pricing', 0, ''),
('enable_posting', 0, '1'),
('enable_scanner', 0, ''),
('encounter_page_size', 0, '20'),
('enforce_signin_email', 0, '1'),
('env_font_size', 0, '14'),
('env_x_dist', 0, '65'),
('env_x_width', 0, '104.775'),
('env_y_dist', 0, '220'),
('env_y_height', 0, '241.3'),
('erx_account_id', 0, '1'),
('erx_account_name', 0, ''),
('erx_account_partner_name', 0, ''),
('erx_account_password', 0, ''),
('erx_allergy_display', 0, ''),
('erx_debug_setting', 0, '0'),
('erx_default_patient_country', 0, ''),
('erx_enable', 0, ''),
('erx_import_status_message', 0, ''),
('erx_medication_display', 0, ''),
('erx_newcrop_path', 0, 'https://secure.newcropaccounts.com/InterfaceV7/RxEntry.aspx'),
('erx_newcrop_path_soap', 0, 'https://secure.newcropaccounts.com/v7/WebServices/Update1.asmx?WSDL;https://secure.newcropaccounts.com/v7/WebServices/Patient.asmx?WSDL'),
('erx_soap_ttl_allergies', 0, '21600'),
('erx_soap_ttl_medications', 0, '21600'),
('erx_upload_active', 0, ''),
('esign_all', 0, ''),
('esign_individual', 0, '1'),
('esign_lock_toggle', 0, ''),
('esign_report_hide_empty_sig', 0, '1'),
('event_color', 0, '1'),
('expand_document_tree', 0, ''),
('expand_form', 0, '1'),
('extra_logo_login', 0, ''),
('fifth_dun_msg_set', 0, '150'),
('fifth_dun_msg_text', 0, ''),
('first_day_week', 0, '1'),
('first_dun_msg_set', 0, '30'),
('first_dun_msg_text', 0, ''),
('force_billing_widget_open', 0, ''),
('fourth_dun_msg_set', 0, '120'),
('fourth_dun_msg_text', 0, ''),
('full_new_patient_form', 0, '1'),
('gateway_api_key', 0, ''),
('gateway_mode_production', 0, ''),
('gateway_public_key', 0, ''),
('gateway_transaction_key', 0, ''),
('gbl_auth_argon_hash_memory_cost', 0, 'DEFAULT'),
('gbl_auth_argon_hash_thread_cost', 0, 'DEFAULT'),
('gbl_auth_argon_hash_time_cost', 0, 'DEFAULT'),
('gbl_auth_bcrypt_hash_cost', 0, 'DEFAULT'),
('gbl_auth_hash_algo', 0, 'DEFAULT'),
('gbl_auth_sha512_rounds', 0, '100000'),
('gbl_currency_symbol', 0, '$'),
('gbl_debug_hash_verify_execution_time', 0, ''),
('gbl_edit_patient_form', 0, '0'),
('gbl_force_log_breakglass', 0, '1'),
('gbl_ldap_dn', 0, ''),
('gbl_ldap_enabled', 0, ''),
('gbl_ldap_exclusions', 0, ''),
('gbl_ldap_host', 0, ''),
('gbl_mask_invoice_number', 0, ''),
('gbl_mask_patient_id', 0, ''),
('gbl_mask_product_id', 0, ''),
('gbl_mdm_category_name', 0, 'Lab Report'),
('gbl_minimum_password_length', 0, '9'),
('gbl_nav_area_width', 0, '175'),
('gbl_nav_visit_forms', 0, '1'),
('gbl_print_log_option', 0, '0'),
('gbl_pt_list_new_window', 0, ''),
('gbl_pt_list_page_size', 0, '10'),
('gbl_tall_nav_area', 0, ''),
('gbl_time_zone', 0, ''),
('gbl_visit_referral_source', 0, ''),
('gbl_vitals_options', 0, '0'),
('gb_how_sort_list', 0, '0'),
('generate_doc_thumb', 0, ''),
('hidden_auth_dummy_hash', 0, '$2y$10$GznGYXFEOKYa8eJa.URGU.Z9E49TzCixHhpJJeak8idsJPvFihcvG'),
('hide_billing_widget', 0, ''),
('hide_document_encryption', 0, ''),
('hylafax_basedir', 0, '/var/spool/hylafax'),
('hylafax_server', 0, 'localhost'),
('ignore_pnotes_authorization', 0, '1'),
('inhouse_pharmacy', 0, '0'),
('insurance_information', 0, '5'),
('insurance_only_one', 0, ''),
('is_client_ssl_enabled', 0, ''),
('lab_results_category_name', 0, 'Lab Report'),
('language_default', 0, 'English (Standard)'),
('language_menu_showall', 0, '1'),
('ledger_begin_date', 0, 'Y1'),
('left_ubmargin_default', 0, '11'),
('lock_esign_all', 0, ''),
('lock_esign_individual', 0, '1'),
('login_into_facility', 0, ''),
('login_page_layout', 0, 'center'),
('maximum_drug_test_yearly', 0, '0'),
('medex_enable', 0, ''),
('MedicareReferrerIsRenderer', 0, ''),
('menu_styling_vertical', 0, '1'),
('messages_due_date', 0, ''),
('minimum_amount_to_print', 0, '1.00'),
('mysql_bin_dir', 0, '/usr/bin'),
('new_validate', 0, '1'),
('notes_to_display_in_Billing', 0, '3'),
('number_appointments_on_statement', 0, '0'),
('number_of_appts_to_show', 0, '10'),
('number_of_ex_appts_to_show', 0, '15'),
('number_of_group_appts_to_show', 0, '10'),
('num_of_messages_displayed', 0, '3'),
('num_past_appointments_to_show', 0, '0'),
('oauth_password_grant', 0, '0'),
('observation_results_immunization', 0, '1'),
('omit_employers', 0, ''),
('online_support_link', 0, 'http://open-emr.org/'),
('openemr_name', 0, 'OpenEMR'),
('password_expiration_days', 0, '180'),
('password_grace_time', 0, '30'),
('password_history', 0, '5'),
('password_max_failed_logins', 0, '0'),
('patient_birthday_alert', 0, '1'),
('patient_birthday_alert_manual_off', 0, ''),
('patient_id_category_name', 0, 'Patient ID card'),
('patient_photo_category_name', 0, 'Patient Photograph'),
('patient_reminder_sender_email', 0, ''),
('patient_reminder_sender_name', 0, ''),
('patient_search_results_style', 0, '0'),
('pat_rem_clin_nice', 0, ''),
('pat_trkr_timer', 0, '0:20'),
('payment_gateway', 0, 'InHouse'),
('pdf_bottom_margin', 0, '8'),
('pdf_language', 0, 'en'),
('pdf_layout', 0, 'P'),
('pdf_left_margin', 0, '5'),
('pdf_output', 0, 'D'),
('pdf_right_margin', 0, '5'),
('pdf_size', 0, 'LETTER'),
('pdf_top_margin', 0, '5'),
('perl_bin_dir', 0, '/usr/bin'),
('phimail_ccd_enable', 0, ''),
('phimail_ccr_enable', 0, ''),
('phimail_enable', 0, ''),
('phimail_interval', 0, '5'),
('phimail_notify', 0, 'admin'),
('phimail_password', 0, ''),
('phimail_server_address', 0, 'https://phimail.example.com:32541'),
('phimail_username', 0, ''),
('phone_country_code', 0, '1'),
('phone_gateway_password', 0, ''),
('phone_gateway_url', 0, ''),
('phone_gateway_username', 0, ''),
('phone_notification_hour', 0, '50'),
('portal_onsite_document_download', 0, '1'),
('portal_onsite_two_address', 0, 'https://your_web_site.com/openemr/portal'),
('portal_onsite_two_basepath', 0, '1'),
('portal_onsite_two_enable', 0, '1'),
('portal_onsite_two_register', 0, '1'),
('portal_two_ledger', 0, '1'),
('portal_two_pass_reset', 0, '1'),
('portal_two_payments', 0, ''),
('posting_adj_disable', 0, ''),
('post_to_date_benchmark', 0, '2021-07-03'),
('pqri_registry_id', 0, '125789123'),
('pqri_registry_name', 0, 'Model Registry'),
('practice_return_email_path', 0, ''),
('preprinted_cms_1500', 0, ''),
('prevent_browser_refresh', 0, '2'),
('print_next_appointment_on_ledger', 0, '1'),
('ptkr_date_range', 0, '1'),
('ptkr_end_date', 0, 'D0'),
('ptkr_show_encounter', 0, '1'),
('ptkr_show_pid', 0, '1'),
('ptkr_show_staff', 0, '1'),
('ptkr_start_date', 0, 'D0'),
('ptkr_visit_reason', 0, ''),
('receipts_by_provider', 0, ''),
('replicate_justification', 0, ''),
('report_itemizing_amc', 0, '1'),
('report_itemizing_cqm', 0, '1'),
('report_itemizing_standard', 0, '1'),
('restrict_user_facility', 0, ''),
('rest_api', 0, ''),
('rest_fhir_api', 0, ''),
('rest_portal_api', 0, ''),
('rest_portal_fhir_api', 0, ''),
('rx_bottom_margin', 0, '30'),
('rx_enable_DEA', 0, '1'),
('rx_enable_NPI', 0, ''),
('rx_enable_SLN', 0, ''),
('rx_left_margin', 0, '30'),
('rx_paper_size', 0, 'LETTER'),
('rx_right_margin', 0, '30'),
('rx_show_DEA', 0, ''),
('rx_show_drug_drug', 0, ''),
('rx_show_NPI', 0, ''),
('rx_show_SLN', 0, ''),
('rx_top_margin', 0, '72'),
('rx_use_fax_template', 0, '1'),
('rx_zend_html_action', 0, 'default'),
('rx_zend_html_template', 0, ''),
('rx_zend_pdf_action', 0, 'default'),
('rx_zend_pdf_template', 0, ''),
('safe_key_database', 0, ''),
('sales_report_invoice', 0, '2'),
('save_codes_history', 0, '1'),
('scanner_output_directory', 0, '/mnt/scan_docs'),
('schedule_end', 0, '17'),
('schedule_start', 0, '8'),
('search_any_patient', 0, 'dual'),
('second_dun_msg_set', 0, '60'),
('second_dun_msg_text', 0, ''),
('secure_password', 0, '1'),
('secure_upload', 0, '1'),
('select_multi_providers', 0, ''),
('set_facility_cookie', 0, ''),
('set_pos_code_encounter', 0, ''),
('show_aging_on_custom_statement', 0, ''),
('show_label_login', 0, ''),
('show_payment_history', 0, '1'),
('simplified_copay', 0, ''),
('simplified_demographics', 0, ''),
('simplified_prescriptions', 0, ''),
('site_addr_oath', 0, ''),
('SMS_GATEWAY_APIKEY', 0, ''),
('SMS_GATEWAY_PASSWORD', 0, ''),
('SMS_GATEWAY_USENAME', 0, ''),
('SMS_NOTIFICATION_HOUR', 0, '50'),
('SMTP_HOST', 0, 'localhost'),
('SMTP_PASS', 0, ''),
('SMTP_PORT', 0, '25'),
('SMTP_SECURE', 0, ''),
('SMTP_USER', 0, ''),
('specific_application', 0, '0'),
('sql_string_no_show_screen', 0, ''),
('statement_appearance', 0, '1'),
('statement_bill_note_print', 0, ''),
('statement_logo', 0, 'practice_logo.gif'),
('statement_message_to_patient', 0, ''),
('statement_msg_text', 0, ''),
('state_custom_addlist_widget', 0, '1'),
('state_data_type', 0, '26'),
('state_list', 0, 'state'),
('submit_changes_for_all_appts_at_once', 0, '1'),
('support_encounter_claims', 0, ''),
('support_fee_sheet_line_item_provider', 0, ''),
('support_phone_number', 0, ''),
('system_error_logging', 0, 'WARNING'),
('temporary_files_dir', 0, '/tmp'),
('text_templates_enabled', 0, ''),
('theme_tabs_layout', 0, 'tabs_style_full.css'),
('third_dun_msg_set', 0, '90'),
('third_dun_msg_text', 0, ''),
('thumb_doc_max_size', 0, '100'),
('timeout', 0, '7200'),
('time_display_format', 0, '0'),
('tiny_logo_1', 0, ''),
('tiny_logo_2', 0, ''),
('top_ubmargin_default', 0, '14'),
('translate_appt_categories', 0, '1'),
('translate_document_categories', 0, '1'),
('translate_form_titles', 0, '1'),
('translate_gacl_groups', 0, '1'),
('translate_layout', 0, '1'),
('translate_lists', 0, '1'),
('translate_no_safe_apostrophe', 0, ''),
('ub04_support', 0, ''),
('unique_installation_id', 0, 'fb35c296-e7c2-4916-a861-4da45fac0ea3'),
('units_of_measurement', 0, '1'),
('update_mbi', 0, ''),
('user_debug', 0, '0'),
('use_charges_panel', 0, ''),
('use_custom_daysheet', 0, '1'),
('use_custom_immun_list', 0, ''),
('use_custom_statement', 0, ''),
('use_dunning_message', 0, ''),
('use_statement_print_exclusion', 0, ''),
('us_weight_format', 0, '1'),
('weekend_days', 0, '6,0'),
('weno_account_id', 0, '137'),
('weno_account_pass', 0, ''),
('weno_provider_id', 0, 'C36275'),
('weno_rx_enable', 0, '');
COMMIT;

