28 lines
1.4 KiB
Plaintext
28 lines
1.4 KiB
Plaintext
|
v4.0
|
|||
|
|
1.sys_device_type表 启用other字段，0表示2d,1表示3d，v4.0加入，空表示2d
|
|||
|
|
2.ten_device表增加两个字段，识别阈值：recognize_score_3d,检测方式：detection_type
|
|||
|
|
3.ten_person表增加5个字段：depth,face_model,source_file,camera_param
|
|||
|
|
4.ten_record表增加8个字段：depth,source_file,duration,threshold,distance,score3d,temperature,camera_param
|
|||
|
|
|
|||
|
|
|
|||
|
|
v4.0 数据库修改内容
|
|||
|
|
alter table ten_device_copy1
|
|||
|
|
ADD COLUMN recognize_score3d varchar(30) DEFAULT '62,65' COMMENT '3d识别阈值',
|
|||
|
|
ADD COLUMN detection_type tinyint(1) DEFAULT 0 COMMENT '0：默认2d检测， 1：3d检测';
|
|||
|
|
|
|||
|
|
|
|||
|
|
alter table ten_person_copy1
|
|||
|
|
ADD COLUMN depth varchar(200) COMMENT '深度图片',
|
|||
|
|
ADD COLUMN face_model varchar(200) COMMENT '脸模',
|
|||
|
|
ADD COLUMN source_file varchar(200) COMMENT '源文件',
|
|||
|
|
ADD COLUMN camera_param varchar(200) COMMENT '相机参数';
|
|||
|
|
|
|||
|
|
alter table ten_record_9999999999999
|
|||
|
|
ADD COLUMN depth varchar(200) COMMENT '深度图片',
|
|||
|
|
ADD COLUMN source_file varchar(200) COMMENT '源文件',
|
|||
|
|
ADD COLUMN camera_param varchar(200) COMMENT '相机参数',
|
|||
|
|
ADD COLUMN duration int(11) COMMENT '耗时',
|
|||
|
|
ADD COLUMN threshold varchar(50) COMMENT '阈值',
|
|||
|
|
ADD COLUMN distance float COMMENT '距离',
|
|||
|
|
ADD COLUMN score3d varchar(50) COMMENT '分数',
|
|||
|
|
ADD COLUMN temperature float COMMENT '体温';
|