From 5203148ffdd8e27ae158d7bfb8527508a716ce6c Mon Sep 17 00:00:00 2001 From: Joel Klinghed Date: Tue, 7 Jan 2025 22:08:56 +0100 Subject: Add remote & branch to project and review Preparing for git connection. --- server/migrations/1_initial_eyeballs.sql | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'server/migrations') diff --git a/server/migrations/1_initial_eyeballs.sql b/server/migrations/1_initial_eyeballs.sql index 2e5f771..b839c42 100644 --- a/server/migrations/1_initial_eyeballs.sql +++ b/server/migrations/1_initial_eyeballs.sql @@ -1,7 +1,9 @@ CREATE TABLE IF NOT EXISTS projects ( id BIGINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, title VARCHAR(1024) NOT NULL, - description MEDIUMTEXT NOT NULL DEFAULT '' + description MEDIUMTEXT NOT NULL DEFAULT '', + remote VARCHAR(2048) NOT NULL, + main_branch VARCHAR(1024) NOT NULL ); CREATE TABLE IF NOT EXISTS users ( @@ -37,6 +39,8 @@ CREATE TABLE IF NOT EXISTS reviews ( description MEDIUMTEXT NOT NULL DEFAULT '', state TINYINT UNSIGNED NOT NULL DEFAULT 0, progress FLOAT NOT NULL DEFAULT 0, + branch VARCHAR(1024) NOT NULL, + archived BOOLEAN NOT NULL DEFAULT 0, CONSTRAINT `fk_reviews_project` FOREIGN KEY (project) REFERENCES projects (id) -- cgit v1.2.3-70-g09d2