1-- Add migration script here
 2
 3CREATE TABLE hosted_projects (
 4    id INT PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
 5    channel_id INT NOT NULL REFERENCES channels(id),
 6    name TEXT NOT NULL,
 7    visibility TEXT NOT NULL,
 8    deleted_at TIMESTAMP NULL
 9);
10CREATE INDEX idx_hosted_projects_on_channel_id ON hosted_projects (channel_id);
11CREATE UNIQUE INDEX uix_hosted_projects_on_channel_id_and_name ON hosted_projects (channel_id, name) WHERE (deleted_at IS NULL);