4dkankan-center-manage/doc/update-1.3.0.sql

use 4dkankan_v4;

CREATE TABLE `jy_user_share` (
  `id` int NOT NULL AUTO_INCREMENT,
  `jy_user_id` int DEFAULT NULL,
  `main_jy_user_id` int DEFAULT NULL,
  `rec_status` varchar(255) DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;


ALTER TABLE `4dkankan_v4`.`jy_scene_user_auth` 
ADD COLUMN `auth_type` int NULL DEFAULT 0 COMMENT '授权方式，0授权用户，1公开浏览' AFTER `can_del`;