dev/2020/2020-018(OK)/2020-018-wzw-001.sql

use `dcp`;
UPDATE committee_basis_entity SET sort = NULL;
UPDATE committee_basis_info SET sort = NULL;
UPDATE committee_activity_entity SET sort = NULL;
UPDATE committee_activity_info SET sort = NULL;
UPDATE committee_information_release_management_entity SET sort = NULL;
UPDATE committee_information_release_management_info SET sort = NULL;
UPDATE committee_show_message_entity SET sort = NULL;
UPDATE committee_show_message_info SET sort = NULL;

alter table committee_basis_entity modify column sort BIGINT(20)  DEFAULT 99 COMMENT '排序';
alter table committee_basis_info modify column sort BIGINT(20)  DEFAULT 99 COMMENT '排序';

alter table committee_activity_entity modify column sort BIGINT(20)  DEFAULT 99 COMMENT '排序';
alter table committee_activity_info modify column sort BIGINT(20)  DEFAULT 99 COMMENT '排序';

alter table committee_information_release_management_entity modify column sort BIGINT(20)  DEFAULT 99 COMMENT '排序';
alter table committee_information_release_management_info modify column sort BIGINT(20)  DEFAULT 99 COMMENT '排序';

alter table committee_show_message_entity modify column sort BIGINT(20)  DEFAULT 99 COMMENT '排序';
alter table committee_show_message_info modify column sort BIGINT(20)  DEFAULT 99 COMMENT '排序';

/*161 已执行*/
/*159 已执行 ljh 2020年11月30日 12:03:25*/