ambee/giterated

So. Much. Work.

View files Patch

Amber - ⁨2⁩ years ago

parent: tbd commit: ⁨b05f964⁩

⁨giterated-daemon/migrations/20231104175218_create_issues.sql⁩ - ⁨595⁩ bytes

Raw

1	CREATE TYPE comment_visibility AS ENUM
2	(
3	'public',
4	'maintainers',
5	'private'
6	);
7
8	CREATE TABLE IF NOT EXISTS issues
9	(
10	id SERIAL PRIMARY KEY,
11	repository TEXT NOT NULL,
12	author TEXT NOT NULL,
13	creation_date INTEGER NOT NULL,
14	issue_name TEXT NOT NULL,
15	contents TEXT
16	);
17
18	CREATE TABLE IF NOT EXISTS issue_comments
19	(
20	id SERIAL PRIMARY KEY,
21	issue INTEGER NOT NULL REFERENCES issues(id),
22	author TEXT NOT NULL,
23	visibility comment_visibility NOT NULL,
24	contents TEXT
25	);