yvjia/db/crt_lora_style_collect.sql

/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2025/06/03 10:09:22
*/

DROP TABLE IF EXISTS `crt_lora_style_collect`;
CREATE TABLE `crt_lora_style_collect` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `user_id` BIGINT NOT NULL COMMENT '用户ID',
    `lora_style_id` BIGINT NOT NULL COMMENT '风格ID',
    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    INDEX `idx_user_id` (`user_id`),
    INDEX `idx_lora_style_id` (`lora_style_id`)
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='短剧创作-风格LoRA-用户收藏表';

INSERT INTO crt_lora_style_collect(user_id, lora_style_id, create_time) VALUES
    (1, 1, '2025-06-07 16:26:33'),
    (1, 2, '2025-06-07 16:25:00')
;