9 lines
225 B
SQL
9 lines
225 B
SQL
ALTER TABLE helicopter_files
|
|
ADD COLUMN position INT NOT NULL DEFAULT 1 AFTER section,
|
|
ADD KEY idx_helicopter_files_position (position);
|
|
|
|
UPDATE helicopter_files
|
|
SET position = 1
|
|
WHERE position IS NULL OR position <= 0;
|
|
|