7 lines
161 B
SQL
7 lines
161 B
SQL
ALTER TABLE flights
|
|
ADD COLUMN status VARCHAR(20) NOT NULL DEFAULT 'draft' AFTER id;
|
|
|
|
UPDATE flights
|
|
SET status = 'draft'
|
|
WHERE status IS NULL OR status = '';
|