Modrinth/apps/labrinth/migrations/20220902025606_initial-payouts.sql
2024-10-16 14:11:42 -07:00

8 lines
226 B
SQL

ALTER TABLE team_members ADD COLUMN payouts_split REAL NOT NULL DEFAULT 0;
UPDATE team_members
SET permissions = 1023, payouts_split = 100
WHERE role = 'Owner';
ALTER TABLE users ADD COLUMN badges bigint default 0 NOT NULL;