HC小区管理系统数据清理方法

1、登录mysql TT库，执行以下脚本，主要请勿在生产系统执行

delete from u_user where name not in ('dev','admin','dails','wuxw');

delete from f_floor ;

delete from building_unit ;

delete from building_room ;

delete from building_room_attr ;

delete from building_owner_room_rel ;

delete from n_notice ;

delete from r_repair_pool ;

delete from r_repair_user ;

delete from complaint ;

delete from s_visit_info ;

-- 以下三条语句 hc_community 和TT库都需要执行

delete from s_community where community_id <> '7020181217000001';

delete from s_community_attr where community_id <> '7020181217000001';

delete from s_community_member where community_id <> '7020181217000001';

delete from building_owner ;

delete from building_owner_room_rel;

delete from parking_area;

delete from parking_space;

delete from pay_fee;

delete from pay_fee_attrs ;

delete from pay_fee_detail;

delete from advert ;

delete from advert_item;

delete from car_black_white ;

delete from car_inout;

delete from car_inout_detail;

delete from activities ;

delete from audit_user ;

delete from machine ;

delete from machine_attrs ;

delete from machine_record;

delete from machine_translate;

delete from demo;

delete from inspection_plan;

delete from inspection_point;

DELETE from inspection_route;

delete from inspection_route_point_rel;

delete from inspection_task;

delete from owner_app_user;

delete from s_store where store_id not in (

select member_id from s_community_member

);

delete from s_store_attr where store_id not in (select a.store_id from s_store a);

delete from c_orders ;

delete from c_business;

 

2、登录mysql hc_community库，执行以下脚本，主要请勿在生产系统执行

delete from s_community where community_id <> '7020181217000001';

delete from s_community_attr where community_id <> '7020181217000001';

delete from s_community_member where community_id <> '7020181217000001';