FuJianModelPlatform/ruoyi-admin/db-tools/add_columns.sql

-- 为 BUSINESS_SCENE 表添加缺失的第三人称相机朝向字段
ALTER TABLE BUSINESS_SCENE ADD COLUMN THIRD_PERSON_CAMERA_HEADING DECIMAL(10,6);
ALTER TABLE BUSINESS_SCENE ADD COLUMN THIRD_PERSON_CAMERA_PITCH DECIMAL(10,6);
ALTER TABLE BUSINESS_SCENE ADD COLUMN THIRD_PERSON_CAMERA_ROLL DECIMAL(10,6);
ALTER TABLE BUSINESS_SCENE ADD COLUMN THIRD_PERSON_CAMERA_DIRECTION VARCHAR(200);
ALTER TABLE BUSINESS_SCENE ADD COLUMN THIRD_PERSON_CAMERA_UP VARCHAR(200);

-- 添加字段注释
COMMENT ON COLUMN BUSINESS_SCENE.THIRD_PERSON_CAMERA_HEADING IS '第三视角相机朝向角（弧度）';
COMMENT ON COLUMN BUSINESS_SCENE.THIRD_PERSON_CAMERA_PITCH IS '第三视角相机俯仰角（弧度）';
COMMENT ON COLUMN BUSINESS_SCENE.THIRD_PERSON_CAMERA_ROLL IS '第三视角相机翻滚角（弧度）';
COMMENT ON COLUMN BUSINESS_SCENE.THIRD_PERSON_CAMERA_DIRECTION IS '第三视角相机方向向量（JSON格式）';
COMMENT ON COLUMN BUSINESS_SCENE.THIRD_PERSON_CAMERA_UP IS '第三视角相机上向量（JSON格式）';

SELECT '所有字段添加完成' AS result;