105 lines
3.9 KiB
Markdown
105 lines
3.9 KiB
Markdown
# 代码仓库
|
||
链接：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');
|
||
```
|
||
# 20250730
|
||
```sql
|
||
UPDATE experiment_radiation_process
|
||
SET radiation_standard = SUBSTRING_INDEX(radiation_standard, ',', -1)
|
||
WHERE radiation_standard LIKE '%,%';
|
||
``` |