Thomas Gelf 7c18c0b614 schema: unique constraint for import_row_modifier
...priority. Also align current priority to id to get as close as possible
to current fetch order.
2017-08-20 16:01:46 +02:00

8 lines
225 B
SQL

UPDATE import_row_modifier SET priority = id;
ALTER TABLE import_row_modifier ADD UNIQUE INDEX idx_prio (source_id, priority);
INSERT INTO director_schema_migration
(schema_version, migration_time)
VALUES (139, NOW());