Calculation/sql/weapp.sql

------------------------------------
-- 表结构
------------------------------------
CREATE TABLE `zh_weapp_attention`  (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `project_account_id` int(10) NOT NULL DEFAULT 0 COMMENT '关注人/用户ID',
  `tender_id` int(10) NOT NULL DEFAULT 0 COMMENT '关注的标段ID',
  `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '关注状态（1：有效，0：取消）',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '关注时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_user_section`(`project_account_id`, `tender_id`) USING BTREE,
  INDEX `idx_stage_id`(`tender_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '关注记录表' ROW_FORMAT = Dynamic;

ALTER TABLE `zh_project_account`
ADD COLUMN `weapp_openid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '小程序绑定openid（小程序专用）' AFTER `wx_openid`;