yimishijie-miniapp/001.sql

alter table vuforia_image_info change create_time created_at datetime null;
alter table vuforia_image_info change update_time modified_at datetime null;
alter table vuforia_image_info change create_user created_by varchar(255) null;
alter table vuforia_image_info change update_user modified_by varchar(255) null;
alter table vuforia_image_info modify id bigint(20) not null;
alter table vuforia_image_info add enabled bit default 1 not null;
update vuforia_image_info set enabled = 1 where del_flag = 'N';
update vuforia_image_info set enabled = 0 where del_flag = 'Y';
alter table vuforia_image_info drop column del_flag;
alter table vuforia_image_info modify vuforia_image_group_id bigint(20) null;
alter table vuforia_image_info modify vuforia_image_type_id bigint(20) null;
alter table vuforia_image_info modify land_mark_id bigint(20) null;
alter table vuforia_image_info modify ar_content_group_id bigint(20) null;

alter table aim_place_position change create_time created_at datetime null;
alter table aim_place_position change update_time modified_at datetime null;
alter table aim_place_position change create_user created_by varchar(255) null;
alter table aim_place_position change update_user modified_by varchar(255) null;
alter table aim_place_position modify id bigint(20) not null;
alter table aim_place_position add enabled bit default 1 not null;
update aim_place_position set enabled = 1 where del_flag = 'N';
update aim_place_position set enabled = 0 where del_flag = 'Y';
alter table aim_place_position drop column del_flag;
alter table aim_place_position modify front_level_id bigint(20) null;
alter table aim_place_position modify owned_land_mark_id bigint(20) null;

alter table aim_template_aim change create_time created_at datetime null;
alter table aim_template_aim change update_time modified_at datetime null;
alter table aim_template_aim change create_user created_by varchar(255) null;
alter table aim_template_aim change update_user modified_by varchar(255) null;
alter table aim_template_aim modify id bigint(20) not null;
alter table aim_template_aim add enabled bit default 1 not null;
update aim_template_aim set enabled = 1 where del_flag = 'N';
update aim_template_aim set enabled = 0 where del_flag = 'Y';
alter table aim_template_aim drop column del_flag;
alter table aim_template_aim modify template_id bigint(20) null;

alter table market_code_log change create_time created_at datetime null;
alter table market_code_log change update_time modified_at datetime null;
alter table market_code_log change create_user created_by varchar(255) null;
alter table market_code_log change update_user modified_by varchar(255) null;
alter table market_code_log modify id bigint(20) not null;
alter table market_code_log add enabled bit default 1 not null;
update market_code_log set enabled = 1 where del_flag = 'N';
update market_code_log set enabled = 0 where del_flag = 'Y';
alter table market_code_log drop column del_flag;
alter table market_code_log modify user_id bigint(20) null;

alter table market_aim_place change create_time created_at datetime null;
alter table market_aim_place change update_time modified_at datetime null;
alter table market_aim_place change create_user created_by varchar(255) null;
alter table market_aim_place change update_user modified_by varchar(255) null;
alter table market_aim_place modify id bigint(20) not null;
alter table market_aim_place add enabled bit default 1 not null;
update market_aim_place set enabled = 1 where del_flag = 'N';
update market_aim_place set enabled = 0 where del_flag = 'Y';
alter table market_aim_place drop column del_flag;
alter table market_aim_place modify market_id bigint(20) null;

alter table ar_content_type change create_time created_at datetime null;
alter table ar_content_type change update_time modified_at datetime null;
alter table ar_content_type change create_user created_by varchar(255) null;
alter table ar_content_type change update_user modified_by varchar(255) null;
alter table ar_content_type modify id bigint(20) not null;
alter table ar_content_type add enabled bit default 1 not null;
update ar_content_type set enabled = 1 where del_flag = 'N';
update ar_content_type set enabled = 0 where del_flag = 'Y';
alter table ar_content_type drop column del_flag;

alter table market_map change create_time created_at datetime null;
alter table market_map change update_time modified_at datetime null;
alter table market_map change create_user created_by varchar(255) null;
alter table market_map change update_user modified_by varchar(255) null;
alter table market_map modify id bigint(20) not null;
alter table market_map add enabled bit default 1 not null;
update market_map set enabled = 1 where del_flag = 'N';
update market_map set enabled = 0 where del_flag = 'Y';
alter table market_map drop column del_flag;

alter table member_point change create_time created_at datetime null;
alter table member_point change update_time modified_at datetime null;
alter table member_point change create_user created_by varchar(255) null;
alter table member_point change update_user modified_by varchar(255) null;
alter table member_point modify id bigint(20) not null;
alter table member_point add enabled bit default 1 not null;
update member_point set enabled = 1 where del_flag = 'N';
update member_point set enabled = 0 where del_flag = 'Y';
alter table member_point drop column del_flag;
alter table member_point modify user_id bigint(20) null;
alter table member_point modify order_id bigint(20) null;

alter table city_info change create_time created_at datetime null;
alter table city_info change update_time modified_at datetime null;
alter table city_info change create_user created_by varchar(255) null;
alter table city_info change update_user modified_by varchar(255) null;
alter table city_info modify id bigint(20) not null;
alter table city_info add enabled bit default 1 not null;
update city_info set enabled = 1 where del_flag = 'N';
update city_info set enabled = 0 where del_flag = 'Y';
alter table city_info drop column del_flag;

alter table user_order change create_time created_at datetime null;
alter table user_order change update_time modified_at datetime null;
alter table user_order change create_user created_by varchar(255) null;
alter table user_order change update_user modified_by varchar(255) null;
alter table user_order modify id bigint(20) not null;
alter table user_order add enabled bit default 1 not null;
update user_order set enabled = 1 where del_flag = 'N';
update user_order set enabled = 0 where del_flag = 'Y';
alter table user_order drop column del_flag;
alter table user_order modify user_id bigint(20) null;
alter table user_order modify lank_mark_id bigint(20) null;
alter table user_order modify package_id bigint(20) null;

alter table area_show_point change create_time created_at datetime null;
alter table area_show_point change update_time modified_at datetime null;
alter table area_show_point change create_user created_by varchar(255) null;
alter table area_show_point change update_user modified_by varchar(255) null;
alter table area_show_point modify id bigint(20) not null;
alter table area_show_point add enabled bit default 1 not null;
update area_show_point set enabled = 1 where del_flag = 'N';
update area_show_point set enabled = 0 where del_flag = 'Y';
alter table area_show_point drop column del_flag;
alter table area_show_point modify city_id bigint(20) null;
alter table area_show_point modify landmark_id bigint(20) null;
alter table area_show_point modify area_id bigint(20) null;

alter table land_mark_level change create_time created_at datetime null;
alter table land_mark_level change update_time modified_at datetime null;
alter table land_mark_level change create_user created_by varchar(255) null;
alter table land_mark_level change update_user modified_by varchar(255) null;
alter table land_mark_level modify id bigint(20) not null;
alter table land_mark_level add enabled bit default 1 not null;
update land_mark_level set enabled = 1 where del_flag = 'N';
update land_mark_level set enabled = 0 where del_flag = 'Y';
alter table land_mark_level drop column del_flag;
alter table land_mark_level modify owned_city_id bigint(20) null;
alter table land_mark_level modify front_level_id bigint(20) null;
alter table land_mark_level modify land_mark_id bigint(20) null;

alter table land_mark change create_time created_at datetime null;
alter table land_mark change update_time modified_at datetime null;
alter table land_mark change create_user created_by varchar(255) null;
alter table land_mark change update_user modified_by varchar(255) null;
alter table land_mark modify id bigint(20) not null;
alter table land_mark add enabled bit default 1 not null;
update land_mark set enabled = 1 where del_flag = 'N';
update land_mark set enabled = 0 where del_flag = 'Y';
alter table land_mark drop column del_flag;
alter table land_mark modify vuforia_image_group_id bigint(20) null;
alter table land_mark modify front_level_id bigint(20) null;

alter table market_type change create_time created_at datetime null;
alter table market_type change update_time modified_at datetime null;
alter table market_type change create_user created_by varchar(255) null;
alter table market_type change update_user modified_by varchar(255) null;
alter table market_type modify id bigint(20) not null;
alter table market_type add enabled bit default 1 not null;
update market_type set enabled = 1 where del_flag = 'N';
update market_type set enabled = 0 where del_flag = 'Y';
alter table market_type drop column del_flag;

alter table alipay_temp change create_time created_at datetime null;
alter table alipay_temp change update_time modified_at datetime null;
alter table alipay_temp change create_user created_by varchar(255) null;
alter table alipay_temp change update_user modified_by varchar(255) null;
alter table alipay_temp modify id bigint(20) not null;
alter table alipay_temp add enabled bit default 1 not null;
update alipay_temp set enabled = 1 where del_flag = 'N';
update alipay_temp set enabled = 0 where del_flag = 'Y';
alter table alipay_temp drop column del_flag;

alter table aim_template change create_time created_at datetime null;
alter table aim_template change update_time modified_at datetime null;
alter table aim_template change create_user created_by varchar(255) null;
alter table aim_template change update_user modified_by varchar(255) null;
alter table aim_template modify id bigint(20) not null;
alter table aim_template add enabled bit default 1 not null;
update aim_template set enabled = 1 where del_flag = 'N';
update aim_template set enabled = 0 where del_flag = 'Y';
alter table aim_template drop column del_flag;

alter table aim_place_info change create_time created_at datetime null;
alter table aim_place_info change update_time modified_at datetime null;
alter table aim_place_info change create_user created_by varchar(255) null;
alter table aim_place_info change update_user modified_by varchar(255) null;
alter table aim_place_info modify id bigint(20) not null;
alter table aim_place_info add enabled bit default 1 not null;
update aim_place_info set enabled = 1 where del_flag = 'N';
update aim_place_info set enabled = 0 where del_flag = 'Y';
alter table aim_place_info drop column del_flag;
alter table aim_place_info modify aim_group_id bigint(20) null;

alter table user_comment change create_time created_at datetime null;
alter table user_comment change update_time modified_at datetime null;
alter table user_comment change create_user created_by varchar(255) null;
alter table user_comment change update_user modified_by varchar(255) null;
alter table user_comment modify id bigint(20) not null;
alter table user_comment add enabled bit default 1 not null;
update user_comment set enabled = 1 where del_flag = 'N';
update user_comment set enabled = 0 where del_flag = 'Y';
alter table user_comment drop column del_flag;
alter table user_comment modify user_id bigint(20) null;
alter table user_comment modify landmark_id bigint(20) null;

alter table aim_template_ar change create_time created_at datetime null;
alter table aim_template_ar change update_time modified_at datetime null;
alter table aim_template_ar change create_user created_by varchar(255) null;
alter table aim_template_ar change update_user modified_by varchar(255) null;
alter table aim_template_ar modify id bigint(20) not null;
alter table aim_template_ar add enabled bit default 1 not null;
update aim_template_ar set enabled = 1 where del_flag = 'N';
update aim_template_ar set enabled = 0 where del_flag = 'Y';
alter table aim_template_ar drop column del_flag;
alter table aim_template_ar modify template_aim_id bigint(20) null;

alter table user_update_log change create_time created_at datetime null;
alter table user_update_log change update_time modified_at datetime null;
alter table user_update_log change create_user created_by varchar(255) null;
alter table user_update_log change update_user modified_by varchar(255) null;
alter table user_update_log modify id bigint(20) not null;
alter table user_update_log add enabled bit default 1 not null;
update user_update_log set enabled = 1 where del_flag = 'N';
update user_update_log set enabled = 0 where del_flag = 'Y';
alter table user_update_log drop column del_flag;

alter table aim_place_content change create_time created_at datetime null;
alter table aim_place_content change update_time modified_at datetime null;
alter table aim_place_content change create_user created_by varchar(255) null;
alter table aim_place_content change update_user modified_by varchar(255) null;
alter table aim_place_content modify id bigint(20) not null;
alter table aim_place_content add enabled bit default 1 not null;
update aim_place_content set enabled = 1 where del_flag = 'N';
update aim_place_content set enabled = 0 where del_flag = 'Y';
alter table aim_place_content drop column del_flag;
alter table aim_place_content modify owned_land_mark_id bigint(20) null;
alter table aim_place_content modify ar_content_group_id bigint(20) null;

alter table area_info change create_time created_at datetime null;
alter table area_info change update_time modified_at datetime null;
alter table area_info change create_user created_by varchar(255) null;
alter table area_info change update_user modified_by varchar(255) null;
alter table area_info modify id bigint(20) not null;
alter table area_info add enabled bit default 1 not null;
update area_info set enabled = 1 where del_flag = 'N';
update area_info set enabled = 0 where del_flag = 'Y';
alter table area_info drop column del_flag;
alter table area_info modify landmark_id bigint(20) null;
alter table area_info modify template_id bigint(20) null;
alter table area_info modify area_type bigint(20) null;

alter table land_mark_version change create_time created_at datetime null;
alter table land_mark_version change update_time modified_at datetime null;
alter table land_mark_version change create_user created_by varchar(255) null;
alter table land_mark_version change update_user modified_by varchar(255) null;
alter table land_mark_version modify id bigint(20) not null;
alter table land_mark_version add enabled bit default 1 not null;
update land_mark_version set enabled = 1 where del_flag = 'N';
update land_mark_version set enabled = 0 where del_flag = 'Y';
alter table land_mark_version drop column del_flag;
alter table land_mark_version modify land_mark_id bigint(20) null;

alter table ar_content_child change create_time created_at datetime null;
alter table ar_content_child change update_time modified_at datetime null;
alter table ar_content_child change create_user created_by varchar(255) null;
alter table ar_content_child change update_user modified_by varchar(255) null;
alter table ar_content_child modify id bigint(20) not null;
alter table ar_content_child add enabled bit default 1 not null;
update ar_content_child set enabled = 1 where del_flag = 'N';
update ar_content_child set enabled = 0 where del_flag = 'Y';
alter table ar_content_child drop column del_flag;
alter table ar_content_child modify ar_content_id bigint(20) null;

alter table member_coin change create_time created_at datetime null;
alter table member_coin change update_time modified_at datetime null;
alter table member_coin change create_user created_by varchar(255) null;
alter table member_coin change update_user modified_by varchar(255) null;
alter table member_coin modify id bigint(20) not null;
alter table member_coin add enabled bit default 1 not null;
update member_coin set enabled = 1 where del_flag = 'N';
update member_coin set enabled = 0 where del_flag = 'Y';
alter table member_coin drop column del_flag;
alter table member_coin modify user_id bigint(20) null;
alter table member_coin modify order_id bigint(20) null;

alter table navigation_package change create_time created_at datetime null;
alter table navigation_package change update_time modified_at datetime null;
alter table navigation_package change create_user created_by varchar(255) null;
alter table navigation_package change update_user modified_by varchar(255) null;
alter table navigation_package modify id bigint(20) not null;
alter table navigation_package add enabled bit default 1 not null;
update navigation_package set enabled = 1 where del_flag = 'N';
update navigation_package set enabled = 0 where del_flag = 'Y';
alter table navigation_package drop column del_flag;
alter table navigation_package modify land_mark_id bigint(20) null;

alter table aim_place_content_child change create_time created_at datetime null;
alter table aim_place_content_child change update_time modified_at datetime null;
alter table aim_place_content_child change create_user created_by varchar(255) null;
alter table aim_place_content_child change update_user modified_by varchar(255) null;
alter table aim_place_content_child modify id bigint(20) not null;
alter table aim_place_content_child add enabled bit default 1 not null;
update aim_place_content_child set enabled = 1 where del_flag = 'N';
update aim_place_content_child set enabled = 0 where del_flag = 'Y';
alter table aim_place_content_child drop column del_flag;
alter table aim_place_content_child modify aim_place_content_id bigint(20) null;

alter table vuforia_image_type change create_time created_at datetime null;
alter table vuforia_image_type change update_time modified_at datetime null;
alter table vuforia_image_type change create_user created_by varchar(255) null;
alter table vuforia_image_type change update_user modified_by varchar(255) null;
alter table vuforia_image_type modify id bigint(20) not null;
alter table vuforia_image_type add enabled bit default 1 not null;
update vuforia_image_type set enabled = 1 where del_flag = 'N';
update vuforia_image_type set enabled = 0 where del_flag = 'Y';
alter table vuforia_image_type drop column del_flag;

alter table landmark_type change create_time created_at datetime null;
alter table landmark_type change update_time modified_at datetime null;
alter table landmark_type change create_user created_by varchar(255) null;
alter table landmark_type change update_user modified_by varchar(255) null;
alter table landmark_type modify id bigint(20) not null;
alter table landmark_type add enabled bit default 1 not null;
update landmark_type set enabled = 1 where del_flag = 'N';
update landmark_type set enabled = 0 where del_flag = 'Y';
alter table landmark_type drop column del_flag;

alter table thing_info change create_time created_at datetime null;
alter table thing_info change update_time modified_at datetime null;
alter table thing_info change create_user created_by varchar(255) null;
alter table thing_info change update_user modified_by varchar(255) null;
alter table thing_info modify id bigint(20) not null;
alter table thing_info add enabled bit default 1 not null;
update thing_info set enabled = 1 where del_flag = 'N';
update thing_info set enabled = 0 where del_flag = 'Y';
alter table thing_info drop column del_flag;
alter table thing_info modify landmark_id bigint(20) null;
alter table thing_info modify template_id bigint(20) null;
alter table thing_info modify city_id bigint(20) null;
alter table thing_info modify area_id bigint(20) null;

alter table market_map_box_des change create_time created_at datetime null;
alter table market_map_box_des change update_time modified_at datetime null;
alter table market_map_box_des change create_user created_by varchar(255) null;
alter table market_map_box_des change update_user modified_by varchar(255) null;
alter table market_map_box_des modify id bigint(20) not null;
alter table market_map_box_des add enabled bit default 1 not null;
update market_map_box_des set enabled = 1 where del_flag = 'N';
update market_map_box_des set enabled = 0 where del_flag = 'Y';
alter table market_map_box_des drop column del_flag;

alter table ar_content change create_time created_at datetime null;
alter table ar_content change update_time modified_at datetime null;
alter table ar_content change create_user created_by varchar(255) null;
alter table ar_content change update_user modified_by varchar(255) null;
alter table ar_content modify id bigint(20) not null;
alter table ar_content add enabled bit default 1 not null;
update ar_content set enabled = 1 where del_flag = 'N';
update ar_content set enabled = 0 where del_flag = 'Y';
alter table ar_content drop column del_flag;
alter table ar_content modify aim_place_id bigint(20) null;

alter table aim_place_position_level change create_time created_at datetime null;
alter table aim_place_position_level change update_time modified_at datetime null;
alter table aim_place_position_level change create_user created_by varchar(255) null;
alter table aim_place_position_level change update_user modified_by varchar(255) null;
alter table aim_place_position_level modify id bigint(20) not null;
alter table aim_place_position_level add enabled bit default 1 not null;
update aim_place_position_level set enabled = 1 where del_flag = 'N';
update aim_place_position_level set enabled = 0 where del_flag = 'Y';
alter table aim_place_position_level drop column del_flag;

alter table market_map_box change create_time created_at datetime null;
alter table market_map_box change update_time modified_at datetime null;
alter table market_map_box change create_user created_by varchar(255) null;
alter table market_map_box change update_user modified_by varchar(255) null;
alter table market_map_box modify id bigint(20) not null;
alter table market_map_box add enabled bit default 1 not null;
update market_map_box set enabled = 1 where del_flag = 'N';
update market_map_box set enabled = 0 where del_flag = 'Y';
alter table market_map_box drop column del_flag;

alter table vuforia_image_group change create_time created_at datetime null;
alter table vuforia_image_group change update_time modified_at datetime null;
alter table vuforia_image_group change create_user created_by varchar(255) null;
alter table vuforia_image_group change update_user modified_by varchar(255) null;
alter table vuforia_image_group modify id bigint(20) not null;
alter table vuforia_image_group add enabled bit default 1 not null;
update vuforia_image_group set enabled = 1 where del_flag = 'N';
update vuforia_image_group set enabled = 0 where del_flag = 'Y';
alter table vuforia_image_group drop column del_flag;

alter table aim_group_info change create_time created_at datetime null;
alter table aim_group_info change update_time modified_at datetime null;
alter table aim_group_info change create_user created_by varchar(255) null;
alter table aim_group_info change update_user modified_by varchar(255) null;
alter table aim_group_info modify id bigint(20) not null;
alter table aim_group_info add enabled bit default 1 not null;
update aim_group_info set enabled = 1 where del_flag = 'N';
update aim_group_info set enabled = 0 where del_flag = 'Y';
alter table aim_group_info drop column del_flag;
alter table aim_group_info modify area_id bigint(20) null;
alter table aim_group_info modify thing_id bigint(20) null;
alter table aim_group_info modify aim_template_id bigint(20) null;

alter table guide_tip_image change create_time created_at datetime null;
alter table guide_tip_image change update_time modified_at datetime null;
alter table guide_tip_image change create_user created_by varchar(255) null;
alter table guide_tip_image change update_user modified_by varchar(255) null;
alter table guide_tip_image modify id bigint(20) not null;
alter table guide_tip_image add enabled bit default 1 not null;
update guide_tip_image set enabled = 1 where del_flag = 'N';
update guide_tip_image set enabled = 0 where del_flag = 'Y';
alter table guide_tip_image drop column del_flag;

alter table user_file_info change create_time created_at datetime null;
alter table user_file_info change update_time modified_at datetime null;
alter table user_file_info change create_user created_by varchar(255) null;
alter table user_file_info change update_user modified_by varchar(255) null;
alter table user_file_info modify id bigint(20) not null;
alter table user_file_info add enabled bit default 1 not null;
update user_file_info set enabled = 1 where del_flag = 'N';
update user_file_info set enabled = 0 where del_flag = 'Y';
alter table user_file_info drop column del_flag;
alter table user_file_info modify user_id bigint(20) null;

alter table market_code change create_time created_at datetime null;
alter table market_code change update_time modified_at datetime null;
alter table market_code change create_user created_by varchar(255) null;
alter table market_code change update_user modified_by varchar(255) null;
alter table market_code modify id bigint(20) not null;
alter table market_code add enabled bit default 1 not null;
update market_code set enabled = 1 where del_flag = 'N';
update market_code set enabled = 0 where del_flag = 'Y';
alter table market_code drop column del_flag;
alter table market_code modify type_id bigint(20) null;