forum.bitel.ru http://forum.bitel.ru/ |
|
структура бд http://forum.bitel.ru/viewtopic.php?f=22&t=4016 |
Страница 1 из 1 |
Автор: | skyb [ 13 май 2010, 10:55 ] |
Заголовок сообщения: | структура бд |
решил почистить бд... и такое ощущение что удалил что то лишнее....посмотрите - за этот месяц и за прошлый нормально с таблицами Код: mysql> show tables;
+-------------------------------------+ | Tables_in_bgbilling | +-------------------------------------+ | _contract_status_bak_bir | | _user | | address_area | | address_city | | address_house | | address_quarter | | address_street | | aliases | | bgs_group | | bgs_group_action | | bgs_module_action | | bgs_query_log_201004 | | bgs_query_log_201005 | | bgs_user_action | | bgs_user_group | | bill_account_8 | | bill_attribute_8 | | bill_contract_doc_type_8 | | bill_data_8 | | bill_doc_type_8 | | bill_invoice_data_8 | | billing_event_bus | | calculate_period_1 | | cashcheck_payment_queue_13 | | contract | | contract_account | | contract_balance | | contract_charge | | contract_charge_types | | contract_comment | | contract_comment_patterns | | contract_delete_money | | contract_delete_time | | contract_error | | contract_group | | contract_limit_manage | | contract_limit_manage_mode | | contract_limit_period | | contract_logon_error | | contract_logon_last | | contract_logon_ok | | contract_module | | contract_parameter_group | | contract_parameter_group_name | | contract_parameter_type_1 | | contract_parameter_type_1_log | | contract_parameter_type_2 | | contract_parameter_type_2_log | | contract_parameter_type_3 | | contract_parameter_type_3_log | | contract_parameter_type_3_mail | | contract_parameter_type_4 | | contract_parameter_type_4_directory | | contract_parameter_type_4_log | | contract_parameter_type_5 | | contract_parameter_type_5_log | | contract_parameter_type_6 | | contract_parameter_type_6_log | | contract_parameter_type_7 | | contract_parameter_type_7_log | | contract_parameter_type_7_values | | contract_parameter_type_8 | | contract_parameter_type_8_log | | contract_parameter_type_9 | | contract_parameter_type_9_log | | contract_parameters_pref | | contract_password_once | | contract_pattern | | contract_pattern_modules | | contract_pattern_services | | contract_payment | | contract_payment_types | | contract_script | | contract_service | | contract_status | | contract_status_balance_dump | | contract_status_log | | contract_tariff | | contract_tariff_group | | contract_tariff_option | | contract_tree_link | | data_log_error_201004 | | data_log_error_201005 | | detail_create_task_6 | | dialup_conn_error | | domains | | drweb_contract_agent_10 | | drweb_contract_agent_log_10 | | drweb_tariffs_10 | | email_account_3 | | email_attribute_3 | | email_domain_3 | | email_forward_3 | | filestorage_files_list_11 | | firm | | global_script | | helpdesk_message_11 | | helpdesk_package_11 | | helpdesk_package_contract_11 | | helpdesk_param_11 | | helpdesk_topic_11 | | helpdesk_topic_manager_change_11 | | helpdesk_topic_statuses_11 | | installed_modules | | ip_resource_6 | | ip_resource_category_6 | | ip_resource_range_6 | | ipn_contract_data_6_201004 | | ipn_contract_data_6_201005 | | ipn_contract_status_6 | | ipn_contract_status_log_6 | | ipn_gate_6 | | ipn_gate_contract_port_6 | | ipn_gate_rule_6 | | ipn_gate_type_6 | | ipn_gate_vlan_6 | | ipn_iface_6 | | ipn_rule_type_6 | | ipn_service_6 | | ipn_service_link_plan_6 | | ipn_user_gate_6 | | ipn_user_range_6 | | ipn_user_source_6 | | ipn_zone_6 | | log_contract_limit | | log_contract_limit_manage_mode | | log_contract_mode | | log_contract_pswd | | log_error_1_201004 | | log_error_1_201005 | | log_function_process_201004 | | log_function_process_201005 | | log_gscript_process_201004 | | log_gscript_process_201005 | | log_login_pswd | | log_server_1_201004 | | log_server_1_201005 | | log_session_1_201004 | | log_session_1_201005 | | log_session_net_1_201004 | | log_session_net_1_201005 | | login_account_1_201004 | | login_account_1_201005 | | login_parameter_1 | | login_parameter_log_1 | | mail_list | | mail_list_message | | mail_temp | | module | | module_config | | module_tariff_tree | | mps_login_5 | | mps_payment_5_200910 | | mps_payment_5_200911 | | mps_payment_5_200912 | | mps_payment_5_201001 | | mps_payment_5_201002 | | mps_payment_5_201003 | | mps_payment_5_201004 | | mps_payment_5_201005 | | mps_payment_seq_5 | | mtree_node | | nas_1 | | nas_config_1 | | news | | npay_add_cost_detail_4_200909 | | npay_add_cost_detail_4_200910 | | npay_add_cost_detail_4_200911 | | npay_add_cost_detail_4_200912 | | npay_add_cost_detail_4_201001 | | npay_add_cost_detail_4_201002 | | npay_add_cost_detail_4_201003 | | npay_add_cost_detail_4_201004 | | npay_add_cost_detail_4_201005 | | npay_detail_4_200909 | | npay_detail_4_200910 | | npay_detail_4_200911 | | npay_detail_4_200912 | | npay_detail_4_201001 | | npay_detail_4_201002 | | npay_detail_4_201003 | | npay_detail_4_201004 | | npay_detail_4_201005 | | npay_service_object_4 | | object | | object_list_value | | object_param | | object_param_value_address | | object_param_value_date | | object_param_value_list | | object_param_value_text | | object_type | | object_type_module | | object_type_param | | organizer_journal_2 | | organizer_records_2 | | payment_register | | payment_register_item | | periodic_errors | | plugin_config | | radius_pair_1 | | radius_pair_ip_1 | | radius_pair_set_1 | | register_call | | register_category | | register_executor | | register_executor_group | | register_group | | register_group_task_type | | register_problem | | register_problem_executor | | register_problem_group | | register_problem_log | | register_subject | | register_task | | register_task_executor | | register_task_type | | register_work | | register_work_object | | register_work_problem | | register_work_type | | report_reference | | report_template | | rscm_service_2 | | rscm_service_account_2_200910 | | rscm_service_account_2_200911 | | rscm_service_account_2_200912 | | rscm_service_account_2_201001 | | rscm_service_account_2_201002 | | rscm_service_account_2_201003 | | rscm_service_account_2_201004 | | rscm_service_account_2_201005 | | scheduled_class | | scheduled_task_run | | scheduled_tasks | | script | | script_event_queue | | script_event_type | | script_function | | script_function_event_type | | script_lib | | service | | session_account_1_201004 | | session_account_1_201005 | | session_detail_1_201004 | | session_detail_1_201005 | | setup | | source | | source_data_200910 | | source_data_200911 | | source_data_200912 | | source_data_201001 | | source_data_201002 | | source_data_201003 | | source_data_201004 | | source_data_201005 | | sql_patches_history | | sql_template | | status_log | | subscr_contact | | tariff_change_task | | tariff_detail_1_200909 | | tariff_detail_1_200910 | | tariff_detail_1_200912 | | tariff_detail_1_201001 | | tariff_detail_1_201003 | | tariff_detail_1_201004 | | tariff_group | | tariff_group_tariff | | tariff_option | | tariff_option_activate_mode | | tariff_plan | | tariff_tree | | tariff_tree_config | | tariff_tree_link | | task_load | | task_proccess | | time_type | | trayinfo_login_9 | | trayinfo_type_9 | | user | | user_alias_1 | | user_dispatch | | user_dispatch_reference | | user_group | | user_group_access | | user_group_entry | | user_group_member | | user_login_1 | | user_login_condition_1 | | user_login_limit_1 | | user_module_action | | user_tables | | user_user_access | | userforward | | users | | web_query_log_201004 | | web_query_log_201005 | | web_request_count | | web_request_limit |
Автор: | nolka4 [ 13 май 2010, 12:16 ] |
Заголовок сообщения: | Re: структура бд |
а какие конкретно таблицы то удаляли? |
Автор: | skyb [ 13 май 2010, 12:27 ] |
Заголовок сообщения: | Re: структура бд |
те таблици которые создаются ежемесячно, которые с индексом даты идут |
Автор: | nolka4 [ 13 май 2010, 12:42 ] |
Заголовок сообщения: | Re: структура бд |
ок, биллинг работает? |
Автор: | skyb [ 13 май 2010, 12:51 ] |
Заголовок сообщения: | Re: структура бд |
nolka4 писал(а): ок, биллинг работает? Да, биллинг работает, просто леплю очень сложные отчеты, а цифры не совпадают. Вот и пытаюсь найти проблему. |
Автор: | ok-2004 [ 13 май 2010, 14:17 ] |
Заголовок сообщения: | Re: структура бд |
В конце мая буду дропать только эти таблицы, удаление других приводило к странным глюкам: Код: log_server_4_200910
log_server_4_201003 log_server_3_201002 log_server_3_201003 ipn_contract_data_1_200906 ipn_contract_data_1_200907 ipn_contract_data_1_200908 ipn_contract_data_1_200909 ipn_contract_data_1_200910 ipn_contract_data_1_200911 ipn_contract_data_1_200912 ipn_contract_data_1_201001 ipn_contract_data_1_201002 ipn_contract_data_1_201003 bgs_query_log_200906 bgs_query_log_200908 bgs_query_log_201003 log_session_net_4_200910 log_session_net_4_200911 log_session_net_4_200912 log_session_net_4_201001 log_session_net_4_201002 log_session_net_4_201003 session_account_4_200910 session_account_4_200911 session_account_4_200912 session_account_4_201001 session_account_4_201002 session_account_4_201003 log_session_3_200911 log_session_3_201001 log_session_3_201002 log_session_3_201003 log_session_4_200910 log_session_4_200911 log_session_4_201002 log_session_4_201003 session_detail_4_200910 session_detail_4_200911 session_detail_4_201002 session_detail_4_201003 data_log_error_200906 data_log_error_200907 data_log_error_200908 data_log_error_201001 data_log_error_201002 data_log_error_201003 log_error_3_200912 log_error_3_201001 log_error_3_201002 log_error_3_201003 log_error_4_200910 log_error_4_200911 log_error_4_201003 |
Автор: | skyb [ 13 май 2010, 14:19 ] |
Заголовок сообщения: | Re: структура бд |
Спс...хоть не на себе эксперементирую |
Страница 1 из 1 | Часовой пояс: UTC + 5 часов [ Летнее время ] |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |