Add remote & branch to project and review

Preparing for git connection.

1 files changed, 5 insertions, 1 deletions

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)