mall/sql/20260203_diy

CREATE TABLE m_diy
(
	id bigint AUTO_INCREMENT PRIMARY KEY,
	title varchar(50) COLLATE utf8mb4_general_ci DEFAULT '' NULL COMMENT '名称',
	image varchar(256) COLLATE utf8mb4_general_ci DEFAULT '' NULL COMMENT '图片地址',
	sort int DEFAULT 0 NOT NULL COMMENT '排序',
	create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL COMMENT '创建时间',
	update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
	create_user_id bigint NULL COMMENT '创建人id',
	update_user_id bigint NULL COMMENT '更新人id',
	is_delete bit DEFAULT b'0' NOT NULL COMMENT '是否删除',
	diy_data longtext NULL
);