CREATE TABLE user_points (
    user_id INT PRIMARY KEY,
    points INT DEFAULT 0 NOT NULL COMMENT '当前积分余额',
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    INDEX idx_points (points)
);

CREATE TABLE points_log (
    log_id BIGINT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    change INT NOT NULL COMMENT '积分变化值，正为增加，负为减少',
    reason VARCHAR(50) NOT NULL COMMENT '积分变动原因，如签到、消费、奖励等',
    related_id VARCHAR(64) COMMENT '关联业务ID，如订单号',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    INDEX idx_user_time (user_id, created_at),
    INDEX idx_reason (reason)
);

START TRANSACTION;
<p>-- 更新用户积分
UPDATE user_points 
SET points = points + 10, updated_at = NOW() 
WHERE user_id = 123;</p><p>-- 记录积分流水
INSERT INTO points_log (user_id, change, reason, related_id) 
VALUES (123, 10, 'daily_checkin', NULL);</p><p>COMMIT;</p>
                    <div class="aritcle_card">
                        <a class="aritcle_card_img" href="/xiazai/code/11225">
                            <img src="https://img.php.cn/upload/webcode/000/000/017/176541120974891.jpg" alt="I-Shop购物系统">
                        </a>
                        <div class="aritcle_card_info">
                            <a href="/xiazai/code/11225">I-Shop购物系统</a>
                            <p>部分功能简介：商品收藏夹功能热门商品最新商品分级价格功能自选风格打印结算页面内部短信箱商品评论增加上一商品，下一商品功能增强商家提示功能友情链接用户在线统计用户来访统计用户来访信息用户积分功能广告设置用户组分类邮件系统后台实现更新用户数据系统图片设置模板管理CSS风格管理申诉内容过滤功能用户注册过滤特征字符IP库管理及来访限制及管理压缩，恢复，备份数据库功能上传文件管理商品类别管理商品添加/修改/</p>
                            <div class="">
                                <img src="/static/images/card_xiazai.png" alt="I-Shop购物系统">
                                <span>0</span>
                            </div>
                        </div>
                        <a href="/xiazai/code/11225" class="aritcle_card_btn">
                            <span>查看详情</span>
                            <img src="/static/images/cardxiayige-3.png" alt="I-Shop购物系统">
                        </a>
                    </div>
                

SELECT points FROM user_points WHERE user_id = 123;

SELECT change, reason, related_id, created_at 
FROM points_log 
WHERE user_id = 123 
ORDER BY created_at DESC 
LIMIT 20;