mirror of
https://gitee.com/ssssssss-team/magic-boot.git
synced 2025-01-18 19:42:49 +08:00
4 lines
329 B
SQL
4 lines
329 B
SQL
ALTER TABLE sys_dynamic_component ADD type INT(11) comment "0：分组，1：vue组件" AFTER compile_css;
|
||
ALTER TABLE sys_dynamic_component ADD remark text comment "备注" AFTER type;
|
||
update sys_dynamic_component set type = 0 where id in(select * from (select pid from sys_dynamic_component where is_del = 0) a) and is_del = 0
|