1CREATE TABLE remote_projects (
2    id INT PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
3    channel_id INT NOT NULL REFERENCES channels(id),
4    dev_server_id INT NOT NULL REFERENCES dev_servers(id),
5    name TEXT NOT NULL,
6    path TEXT NOT NULL
7);
8
9ALTER TABLE projects ADD COLUMN remote_project_id INTEGER REFERENCES remote_projects(id);