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_staff 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 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_month_card;
delete from car_month_order;
delete from car_black_white;
delete from parking_space_machine;
delete from parking_space_machine_rel;
delete from car_inout;
delete from work_license_pos;
delete from asset_import_log_detail;
delete from tel_call_log;
delete from account;
delete from account_detail;
2.0 清理设备数据
这个清理后无法恢复需要自行添加
delete from access_control;
delete from access_control_ad;
delete from access_control_ad_rel;
delete from access_control_face;
delete from access_control_floor;
delete from access_control_inout;
delete from access_control_log;
delete from access_control_org;
delete from barrier;
delete from charge_rule;
delete from charge_rule_fee;
delete from charge_rule_price;
delete from charge_machine;
delete from charge_machine_order;
delete from charge_machine_order_acct;
delete from charge_machine_order_coupon;
delete from charge_machine_port;
delete from charge_month_card;
delete from charge_month_order;
delete from meter_type;
delete from meter_machine;
delete from meter_machine_charge;
delete from meter_machine_detail;
delete from meter_machine_log;
delete from lift_machine;
delete from lift_machine_ac;
delete from lift_machine_log;
delete from lift_machine_reservation;
delete from lamp_machine;
delete from lamp_machine_log;
delete from lamp_machine_open_close;
delete from lamp_machine_operation;
delete from monitor_machine;
delete from monitor_machine_person;
delete from parking_coupon;
delete from parking_coupon_car;
delete from parking_coupon_car_order;
delete from parking_coupon_order;
delete from parking_coupon_shop;
delete from lock_machine;
delete from lock_inout;
delete from lock_log;
delete from lock_person;
delete from attendance_machine;
delete from attendance_checkin;
delete from attendance_machine_log;
delete from attendance_staff;
delete from tel_machine;
delete from tel_machine_user;
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 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;