11 lines
243 B
SQL
11 lines
243 B
SQL
-- P5-3441 add automatic payouts column to designers
|
|
|
|
ALTER TABLE designers
|
|
ADD COLUMN automatic_payout INTEGER DEFAULT 0;
|
|
|
|
UPDATE designers SET automatic_payout = 0;
|
|
|
|
ALTER TABLE designers
|
|
ALTER COLUMN automatic_payout SET NOT NULL;
|
|
|