1CREATE TABLE dev_server_projects (
 2    id INT PRIMARY KEY GENERATED ALWAYS AS IDENTITY (START WITH 100),
 3    dev_server_id INT NOT NULL REFERENCES dev_servers(id) ON DELETE CASCADE,
 4    path TEXT NOT NULL
 5);
 6INSERT INTO dev_server_projects OVERRIDING SYSTEM VALUE SELECT * FROM remote_projects;
 7
 8ALTER TABLE dev_server_projects ADD CONSTRAINT uix_dev_server_projects_dev_server_id_path UNIQUE(dev_server_id, path);
 9
10ALTER TABLE projects ADD COLUMN dev_server_project_id INTEGER REFERENCES dev_server_projects(id);
11UPDATE projects SET dev_server_project_id = remote_project_id;