39 lines
1.4 KiB
SQL
39 lines
1.4 KiB
SQL
truncate grid_region_grid;
|
|
truncate grid_region_user_relate;
|
|
truncate grid_region_address_tree;
|
|
truncate grid_region_admin_division_relate;
|
|
truncate grid_area_fence;
|
|
|
|
|
|
|
|
truncate grid_virtual_grid;
|
|
truncate grid_virtual_user;
|
|
truncate grid_virtual_rule;
|
|
truncate grid_virtual_cust_965;
|
|
truncate grid_virtual_cust_901;
|
|
truncate grid_virtual_cust_user_965;
|
|
truncate grid_virtual_cust_user_901;
|
|
truncate grid_virtual_cust_user_unbind_965;
|
|
truncate grid_virtual_cust_user_unbind_901;
|
|
|
|
|
|
truncate draw_layer;
|
|
truncate draw_shape;
|
|
truncate draw_shape_cust_965;
|
|
truncate grid_draw_grid;
|
|
truncate grid_draw_shape_relate;
|
|
truncate grid_draw_user_relate;
|
|
|
|
create table draw_shape_cust_831 like draw_shape_cust_965;
|
|
create table cust_info_business_831 like cust_info_retail_965;
|
|
create table cust_info_merchant_831 like cust_info_merchant_965;
|
|
create table cust_info_retail_831 like cust_info_retail_965;
|
|
create table cust_dept_user_cmpm_831 like cust_dept_user_cmpm_965;
|
|
create table cust_dept_user_grid_831 like cust_dept_user_grid_965;
|
|
create table grid_region_cust_user_unbind_831 like grid_region_cust_user_unbind_965;
|
|
create table grid_virtual_cust_831 like grid_virtual_cust_965;
|
|
create table grid_virtual_cust_user_831 like grid_virtual_cust_user_965;
|
|
create table grid_virtual_cust_user_unbind_831 like grid_virtual_cust_user_unbind_965;
|
|
create table ibs_anchor_831 like ibs_anchor_965;
|
|
create table ibs_anchor_address_831 like ibs_anchor_address_965;
|