xiangqinxiangmu/service/Essential/target/classes/sql/user_profile_data.sql

-- 插入用户ID=1的扩展信息测试数据
INSERT INTO `user_profile` (
  `user_id`, `house`, `car`, `height`, `weight`, `star`, `animal`, 
  `real_name`, `id_card`, `education_level`, `hobby`, `school_name`, 
  `company`, `salary_range`, `job_title`, `marital_status`, 
  `is_real_name_verified`, `is_education_verified`, `is_work_verified`, `is_marital_verified`,
  `privacy_salary`, `privacy_phone`, `authenticity_score`
) 
VALUES (
  1, 1, 1, 175, 65, '白羊座', '龙',
  '张三', '110101199001011234', 3, '["旅游", "阅读", "运动"]', '北京大学',
  '某科技公司', 3, '软件工程师', 0,
  1, 1, 1, 1,
  0, 1, 85
)
ON DUPLICATE KEY UPDATE
  `house` = VALUES(`house`),
  `car` = VALUES(`car`),
  `height` = VALUES(`height`),
  `weight` = VALUES(`weight`),
  `star` = VALUES(`star`),
  `animal` = VALUES(`animal`),
  `real_name` = VALUES(`real_name`),
  `id_card` = VALUES(`id_card`),
  `education_level` = VALUES(`education_level`),
  `hobby` = VALUES(`hobby`),
  `school_name` = VALUES(`school_name`),
  `company` = VALUES(`company`),
  `salary_range` = VALUES(`salary_range`),
  `job_title` = VALUES(`job_title`),
  `marital_status` = VALUES(`marital_status`),
  `is_real_name_verified` = VALUES(`is_real_name_verified`),
  `is_education_verified` = VALUES(`is_education_verified`),
  `is_work_verified` = VALUES(`is_work_verified`),
  `is_marital_verified` = VALUES(`is_marital_verified`),
  `privacy_salary` = VALUES(`privacy_salary`),
  `privacy_phone` = VALUES(`privacy_phone`),
  `authenticity_score` = VALUES(`authenticity_score`);