diff options
Diffstat (limited to 'server/migrations')
| -rw-r--r-- | server/migrations/1_initial_eyeballs.sql | 6 |
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) |
