HC物业系统清理测试数据
测试数据不是必须要清理的，如果您没有操作数据库的能力，那么我们不建议你清理以免搞坏系统
1.0 清理房产数据
物联网的房产数据清理后，可以通过物业系统全量同步
delete from s_community;
delete from s_community_member;
delete from s_store where store_id not in ('400000000000000001','400000000000000002');
delete from s_store_user where store_id not in ('400000000000000001','400000000000000002');
delete from f_floor;
delete from building_unit;
delete from building_room;
delete from building_owner_room_rel;
delete from building_owner;
delete from owner_app_user;
delete from parking_area;
delete from parking_space;
delete from parking_box;
delete from parking_box_area;
delete from owner_car;
delete from temp_car_fee_config;
delete from car_black_white;
delete from asset_import_log_detail;
delete from account;
delete from account_detail;
delete from account_bond_obj;
delete from account_bond_obj_detail;
delete from room_renovation;
delete from room_renovation_record;
delete from room_renovation_detail;
delete from property_right_registration;
delete from property_right_registration_detail;
delete from item_release_type;
delete from item_release_res;
delete from item_release;
delete from community_publicity;
delete from community_space;
delete from community_space_confirm_order;
delete from community_space_open_time;
delete from community_space_person;
delete from community_space_person_time;
delete from owner_committee;
delete from owner_invoice;
delete from invoice_apply;
delete from invoice_apply_item;
delete from pay_fee_config;
delete from pay_fee_config_discount;
delete from pay_fee;
delete from pay_fee_attrs;
delete from pay_fee_batch;
delete from pay_fee_detail;
delete from pay_fee_detail_discount;
delete from pay_fee_detail_month;
delete from pay_fee_qrcode;
delete from pay_fee_rule;
delete from pay_fee_rule_bill;
delete from pay_fee_sub;
delete from meter_water;
delete from meter_type;
delete from return_pay_fee;
delete from fee_discount;
delete from fee_receipt;
delete from fee_receipt_detail;
delete from apply_room_discount;
delete from apply_room_discount_record;
delete from fee_combo;
delete from fee_combo_member;
delete from pay_fee_audit;
delete from owe_fee_callable;
delete from report_owe_fee;
delete from oa_workflow;
delete from oa_workflow_data;
delete from oa_workflow_data_file;
delete from attendance_classes;
delete from attendance_classes_attr;
delete from attendance_classes_staff;
delete from attendance_classes_task;
delete from attendance_classes_task_detail;
delete from attendance_log;
delete from work_type;
delete from work_copy;
delete from work_event;
delete from work_pool;
delete from work_pool_content;
delete from work_pool_file;
delete from work_task;
delete from work_task_item;
delete from r_repair_pool;
delete from r_repair_return_visit;
delete from r_repair_setting;
delete from r_repair_type_user;
delete from r_repair_user;
delete from inspection_item;
delete from inspection_item_title;
delete from inspection_item_title_value;
delete from inspection_plan;
delete from inspection_plan_staff;
delete from inspection_point;
delete from inspection_route;
delete from inspection_route_point_rel;
delete from inspection_task;
delete from inspection_task_detail;
delete from resource_audit_flow;
delete from storehouse;
delete from resource_store_specification;
delete from resource_store;
delete from resource_supplier;
delete from purchase_apply;
delete from purchase_apply_detail;
delete from allocation_storehouse;
delete from allocation_storehouse_apply;
delete from allocation_user_storehouse;
delete from asset_inventory;
delete from asset_inventory_detail;
delete from user_storehouse;
delete from allocation_user_storehouse;
delete from resource_store_use_record;
delete from community_location;
delete from machine_type;
delete from equipment_account;
delete from equipment_operating_log;
delete from maintainance_item;
delete from maintainance_item_value;
delete from maintainance_plan;
delete from maintainance_plan_machine;
delete from maintainance_plan_staff;
delete from maintainance_standard;
delete from maintainance_standard_item;
delete from maintainance_task;
delete from maintainance_task_detail;
delete from activities_type;
delete from activities;
delete from n_notice;
delete from complaint;
delete from contract_type;
delete from contract;
delete from contract_partya;
delete from contract_change_plan;
delete from contract_change_plan_detail;
delete from contract_change_plan_room;
delete from report_fee_month_statistics;
delete from report_fee_year_collection;
delete from report_fee_year_collection_detail;
delete from report_owner_pay_fee;
delete from file_rel;
2.0 日志表
truncate table transaction_log;
truncate table transaction_log_message;
truncate table transaction_out_log;
truncate table log_system_error;
3.0 删除组织架构
delete from u_org;
delete from u_org_community;
delete from u_org_staff_rel;
delete from u_user where name not in ('dev','admin');
delete from u_user_attr;
delete from p_privilege_user where store_id not in ('400000000000000001','400000000000000002');
delete from c_orders;
delete from c_business;
delete from unitem_log;
delete from c_order_item;
delete from m_menu_group_community;
delete from u_user_login;
4.0 工作流表清理
工作流表有主外建依赖所以清理如果报错，可以百度研究或者跳过
delete from ACT_RU_TASK;
DELETE FROM ACT_RU_IDENTITYLINK;
DELETE FROM ACT_HI_PROCINST;
DELETE FROM ACT_RU_VARIABLE;
DELETE FROM ACT_RU_EXECUTION;
delete from ACT_RE_MODEL;
DELETE FROM ACT_GE_BYTEARRAY;
DELETE FROM ACT_RE_DEPLOYMENT;
DELETE FROM ACT_HI_ACTINST;
delete from ACT_RE_PROCDEF;
delete from ACT_HI_TASKINST;
delete from ACT_HI_COMMENT;
delete from ACT_HI_IDENTITYLINK;
delete from ACT_HI_VARINST;