CREATE TABLE IF NOT EXISTS user_share_log (
  `id` INT(8) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  `event_name` VARCHAR(100) NOT NULL,
  `uid` VARCHAR(50) NOT NULL,
  `from_id` VARCHAR(50) NOT NULL DEFAULT '',
  `share_url` VARCHAR(500) NOT NULL DEFAULT '',
  `level` INT(8) NOT NULL DEFAULT 0,
  `tick` INT(8) NOT NULL DEFAULT 0,
  `share_time` INT(10) NOT NULL ,
  `create_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
) DEFAULT CHARSET=utf8mb4;

ALTER TABLE user_share_log ADD INDEX INDEX_EVENT_NAME (`event_name`);
ALTER TABLE user_share_log ADD INDEX INDEX_UID (`uid`);
ALTER TABLE user_share_log ADD INDEX INDEX_FROM_ID (`from_id`);
ALTER TABLE user_share_log ADD INDEX INDEX_SHARE_URL (`share_url`);