建表

CREATE TABLE IF NOT EXISTS user_info (
  id BIGINT NOT NULL AUTO_INCREMENT COMMENT '用户 id',
  user_name VARCHAR(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户昵称',
  avatar_url VARCHAR(255) NOT NULL COMMENT '用户头像',
  open_id VARCHAR(100) NOT NULL COMMENT 'open id',
  member_status TINYINT NOT NULL DEFAULT 0 COMMENT '会员状态 0 非会员 1..待定',
  create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (id)
) 
ENGINE = InnoDB 
DEFAULT CHARSET = utf8 
AUTO_INCREMENT 11030
COMMENT='用户基本信息';

INSERT INTO user_info (open_id, avatar_url, user_name)
VALUES (
  "123",
  "http://url",
  "李白23131313131"
);