spdm-backend/1-sql/2026-01-27/simulation_design_versions.sql

CREATE TABLE `simulation_design_versions` (
                                              `id` int NOT NULL AUTO_INCREMENT,
                                              `projectId` varchar(255) DEFAULT NULL COMMENT '项目uuid',
                                              `currentVersion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '当前策划版本号',
                                              `parentVersion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '所属父版本版本号',
                                              `childVersion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '所属子版本版本号',
                                              `versionContents` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '版本内容（JSON字符串）',
                                              `creator` bigint DEFAULT NULL,
                                              `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
                                              PRIMARY KEY (`id`),
                                              KEY `poolName` (`projectId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;