cnbg-be/db/v2022/1wm_ad_record.sql

USE hnqzx;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for wm_ad_record
-- ----------------------------
DROP TABLE IF EXISTS `wm_ad_record`;
CREATE TABLE `wm_ad_record`
(
    `record_id`    BIGINT UNSIGNED AUTO_INCREMENT COMMENT 'id',
    `user_id`      INT(11)      NOT NULL COMMENT '用户id',
    `ad_url`       VARCHAR(255) NOT NULL COMMENT '跳转地址',
    `created_time` DATETIME     NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    PRIMARY KEY (`record_id`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 9
  DEFAULT CHARSET = utf8mb4 COMMENT ='部门管理';


SET FOREIGN_KEY_CHECKS = 1;