diff options
| author | Joel Klinghed <the_jk@spawned.biz> | 2025-01-07 22:08:56 +0100 |
|---|---|---|
| committer | Joel Klinghed <the_jk@spawned.biz> | 2025-01-07 22:08:56 +0100 |
| commit | 5203148ffdd8e27ae158d7bfb8527508a716ce6c (patch) | |
| tree | f076887196c9fd2d8864f55059ee1c46c8a329b5 /server/migrations/1_initial_eyeballs.sql | |
| parent | 13056242ab976b766bbff345d9b22e3aa9ad4a94 (diff) | |
Add remote & branch to project and review
Preparing for git connection.
Diffstat (limited to 'server/migrations/1_initial_eyeballs.sql')
| -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) |