ngds/sql/2020_07/change_net.sql

CREATE TABLE `AR_USER_NETWORK_NEW` (
  `ID` varchar(32) COLLATE utf8mb4_general_ci NOT NULL,
  `USER_ID` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户ID',
  `PARENT_UID` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '安置人ID',
  `LOCATION_TAG` varchar(5000) COLLATE utf8mb4_general_ci NOT NULL COMMENT '网体标记',
  `RELATIVE_LOCATION` tinyint(1) NOT NULL DEFAULT '0' COMMENT '相对父级的区位',
  `TOP_UID` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '顶级会员ID',
  `TOP_DEEP` int(10) NOT NULL DEFAULT '0' COMMENT '总网体中层数',
  `PARENT_UIDS` longtext COLLATE utf8mb4_general_ci NOT NULL COMMENT '所有上级ID',
  `CREATED_AT` int(10) NOT NULL COMMENT '创建时间',
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `USER_ID` (`USER_ID`) USING BTREE,
  KEY `PARENT_UID` (`PARENT_UID`),
  KEY `TOP_DEEP` (`TOP_DEEP`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='新安置关系表';


CREATE TABLE `AR_USER_RELATION_NEW` (
  `ID` varchar(32) COLLATE utf8mb4_general_ci NOT NULL,
  `USER_ID` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户ID',
  `PARENT_UID` varchar(32) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '上级ID',
  `TOP_UID` varchar(32) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '顶级会员ID',
  `TOP_DEEP` int(10) NOT NULL DEFAULT '0' COMMENT '开拓总深度',
  `PARENT_UIDS` longtext COLLATE utf8mb4_general_ci NOT NULL COMMENT '所有的上级ID',
  `CREATED_AT` int(10) NOT NULL COMMENT '创建时间',
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `USER_ID` (`USER_ID`) USING BTREE,
  KEY `PARENT_UID` (`PARENT_UID`),
  KEY `TOP_DEEP` (`TOP_DEEP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='新开拓关系表';