# 代码仓库
链接：https://codeup.aliyun.com/?navKey=mine
权限：找李山邀请添加

# 前端打包命令
pnpm run build


# 后端发布
## 测试环境
cd /root/physical
sh build.sh
docker compose pull  
docker compose up -d

# 数据库地址
47.102.126.67：23306  
root urwTocIA1f395t
# minio bucket 权限配置

```json

{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Sid": "PublicReadGetObject",
            "Effect": "Allow",
            "Principal": {
                "AWS": [
                    "*"
                ]
            },
            "Action": [
                "s3:GetObject"
            ],
            "Resource": [
                "arn:aws:s3:::physical/*"
            ]
        }
    ]
}
```


```sql
INSERT INTO `document_library` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `sys_org_code`, `title`, `tags`, `content`, `parent_id`, `type`, `file_list`) VALUES
('1111111111111111111', 'admin', '2025-02-22 23:24:43', NULL, NULL, 'A01', '相关文献', NULL, NULL, NULL, 'FOLDER', NULL);

INSERT INTO `document_library` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `sys_org_code`, `title`, `tags`, `content`, `parent_id`, `type`, `file_list`) VALUES
('2222222222222222222', 'admin', '2025-02-22 23:24:43', NULL, NULL, 'A01', '试验标准数据库', NULL, NULL, NULL, 'FOLDER', NULL);

INSERT INTO `document_library` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `sys_org_code`, `title`, `tags`, `content`, `parent_id`, `type`, `file_list`) VALUES
('3333333333333333333', 'admin', '2025-02-22 23:24:43', NULL, NULL, 'A01', '辐射效应损伤', NULL, NULL, NULL, 'FOLDER', NULL);
```

#20250324
```sql
ALTER TABLE `physical-boot`.`experiment_test_process`
CHANGE `test_metering_point` `test_metering_point` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '测试计量点',
CHANGE `test_fluence_point` `test_fluence_point` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '测试注量点',
CHANGE `annealing_duration` `annealing_duration` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '退火时长';
```

#20250418
```sql

ALTER TABLE `local_database`
ADD COLUMN `sample_model` varchar(2048) NULL COMMENT '样品型号' ;

```
# 20250709
```sql
ALTER TABLE `experiment_irradiation_board`
ADD COLUMN `sample_id` varchar(36) NULL COMMENT '样品ID' AFTER `experiment_id`;

ALTER TABLE `experiment_irradiation_board`
ADD COLUMN `irradiation_board_image` text NULL COMMENT '辐照板图片' AFTER `experiment_id`;

ALTER TABLE `experiment_deviation_equipment`
ADD COLUMN `sample_id` varchar(36) NULL COMMENT '样品ID' AFTER `experiment_id`;

ALTER TABLE `experiment_deviation_equipment`
ADD COLUMN `equipment_id` varchar(36) NULL COMMENT '设备ID' AFTER `experiment_id`;

ALTER TABLE `experiment_deviation_equipment`
ADD COLUMN `equipment_image` text NULL COMMENT '设备图片' AFTER `experiment_id`;

ALTER TABLE `experiment_deviation_condition`
ADD COLUMN `sample_id` varchar(36) NULL COMMENT '样品ID' AFTER `experiment_id`;


TRUNCATE TABLE radiate_type;
INSERT INTO `radiate_type` (`id`,`name`, `create_by`,`create_time` ) VALUES ('1',  '小钴源','admin','2025-07-07 00:00:00');
INSERT INTO `radiate_type` (`id`,`name`, `create_by`,`create_time` ) VALUES ('2',  '大钴源','admin','2025-07-07 00:00:00');
INSERT INTO `radiate_type` (`id`,`name`, `create_by`,`create_time` ) VALUES ('3',  'X光机','admin','2025-07-07 00:00:00');
INSERT INTO `radiate_type` (`id`,`name`, `create_by`,`create_time` ) VALUES ('4',  '电子加速器','admin','2025-07-07 00:00:00');
INSERT INTO `radiate_type` (`id`,`name`, `create_by`,`create_time` ) VALUES ('5',  '质子加速器','admin','2025-07-07 00:00:00');
```
