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