yvjia/db/sys_user_integral.sql

/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2023/05/23 17:09:22
*/

DROP TABLE IF EXISTS `sys_user_integral`;
CREATE TABLE `sys_user_integral` (
    PRIMARY KEY (`user_id`),
    `user_id` BIGINT NOT NULL COMMENT '用户ID',
    `integral` INT DEFAULT 0 COMMENT '积分',
    UNIQUE KEY (`user_id`)
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='系统用户积分表';

INSERT INTO sys_user_integral(user_id, integral) VALUES
    (1, 1000),
    (2, 200),
    (3, 0),
    (4, 0),
    (5, 0),
    (6, 0),
    (7, 0),
    (8, 0),
    (9, 0),
    (10, 0),
    (11, 0),
    (12, 0),
    (13, 0),
    (14, 0),
    (15, 0),
    (16, 0)
;