ambee/giterated

Initial git handling

View files Patch

Type: Feature

emilia - ⁨2⁩ years ago

parent: tbd commit: ⁨523decf⁩

⁨migrations/20230828083716_create_repositories.sql⁩ - ⁨422⁩ bytes

Raw

1	CREATE TYPE visibility AS ENUM
2	(
3	'public',
4	'unlisted',
5	'private'
6	);
7
8	CREATE TABLE IF NOT EXISTS repositories
9	(
10	username TEXT NOT NULL,
11	instance_url TEXT NOT NULL,
12	name TEXT NOT NULL,
13	description TEXT,
14	visibility visibility NOT NULL,
15	default_branch TEXT NOT NULL
16	);
17
18	CREATE UNIQUE INDEX unique_name_per_user ON repositories (username, instance_url, name);
19