kknongchang_2506/app/Module/System/Databases/1.sql

DROP TABLE IF EXISTS `kku_continuous_times`;
CREATE TABLE `kku_continuous_times`
(
    id         int auto_increment                                            NOT NULL COMMENT '主键id',
    user_id    bigint unsigned                                               NULL COMMENT '用户id',
    stype      varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '产品类型',
    sid        bigint                                                        NULL COMMENT '产品id',
    `number`   bigint                                                        NULL COMMENT '计数',
    last_time  bigint                                                        NULL COMMENT '最后的时间',
    created_at timestamp                                                     NULL,
    updated_at timestamp                                                     NULL,
    deleted_at timestamp                                                     NULL,
    diff       int                                                           NULL,
    PRIMARY KEY (id)
)
    ENGINE = InnoDB
    DEFAULT CHARSET = utf8mb4
    COLLATE = utf8mb4_general_ci
    COMMENT ='连续次数判定';