add_credits_to_users.sql 190 B

12345
  1. -- 添加积分字段到users表
  2. ALTER TABLE users ADD COLUMN credits INTEGER NOT NULL DEFAULT 10;
  3. -- 为现有用户设置默认积分
  4. UPDATE users SET credits = 10 WHERE credits IS NULL;