增加统一字段

add sql

ALTER TABLE `xx_supplier_purchase`
ADD COLUMN `created_by` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT ‘创建人。默认:CURRENT_TIMESTAMP(6)’ AFTER `confirmation_mark`,
ADD COLUMN `created_at` datetime DEFAULT NULL COMMENT ‘创建时间’ AFTER `created_by` ,
ADD COLUMN `updated_by` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT ‘修改人’ AFTER `created_at`,
ADD COLUMN `updated_at` datetime DEFAULT NULL COMMENT ‘修改时间’ AFTER `updated_by`,
ADD COLUMN `last_updated_at` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT ‘最后修改时间’ AFTER `updated_at`,
ADD COLUMN `is_del` tinyint(1) DEFAULT NULL COMMENT ‘是否删除。0:有效、1:删除’ AFTER `last_updated_at`;

发表评论

邮箱地址不会被公开。 必填项已用*标注