From 5203148ffdd8e27ae158d7bfb8527508a716ce6c Mon Sep 17 00:00:00 2001
From: Joel Klinghed <the_jk@spawned.biz>
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/1_initial_eyeballs.sql')

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

