magic-boot/db/update20240410.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
-												更新数据库

											
										
										
											2024-04-10 21:16:45 +08:00
+								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;
-												更新数据库

											
										
										
											2024-05-17 22:25:22 +08:00
+								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