summaryrefslogtreecommitdiff
path: root/server/migrations
diff options
context:
space:
mode:
Diffstat (limited to 'server/migrations')
-rw-r--r--server/migrations/1_initial_eyeballs.sql6
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)