From 4b1f7fec1cf9d427234ff5bded79a6d18d5c88ce Mon Sep 17 00:00:00 2001 From: Joel Klinghed Date: Tue, 31 Dec 2024 12:24:46 +0100 Subject: Rename migration so its actually picked up Must be _.sql. --- server/migrations/1_initial_eyeballs.sql | 67 ++++++++++++++++++++++++++++++++ server/migrations/eyeballs.sql | 67 -------------------------------- server/src/main.rs | 2 +- 3 files changed, 68 insertions(+), 68 deletions(-) create mode 100644 server/migrations/1_initial_eyeballs.sql delete mode 100644 server/migrations/eyeballs.sql (limited to 'server') diff --git a/server/migrations/1_initial_eyeballs.sql b/server/migrations/1_initial_eyeballs.sql new file mode 100644 index 0000000..aeb1470 --- /dev/null +++ b/server/migrations/1_initial_eyeballs.sql @@ -0,0 +1,67 @@ +CREATE TABLE IF NOT EXISTS projects ( + id BIGINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, + title VARCHAR(1024) NOT NULL, + description MEDIUMTEXT NOT NULL DEFAULT '' +); + +CREATE TABLE IF NOT EXISTS users ( + id BIGINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, + username VARCHAR(256) NOT NULL UNIQUE, + name VARCHAR(1024) NOT NULL DEFAULT '', + active BOOLEAN NOT NULL DEFAULT 1 +); + +CREATE TABLE IF NOT EXISTS project_users ( + project BIGINT UNSIGNED NOT NULL, + user BIGINT UNSIGNED NOT NULL, + default_role TINYINT UNSIGNED NOT NULL, + maintainer BOOLEAN NOT NULL DEFAULT 0, + PRIMARY KEY (project, user), + + CONSTRAINT `fk_project_users_project` + FOREIGN KEY (project) REFERENCES projects (id) + ON DELETE CASCADE + ON UPDATE RESTRICT, + + CONSTRAINT `fk_project_users_user` + FOREIGN KEY (user) REFERENCES users (id) + ON DELETE CASCADE + ON UPDATE RESTRICT +); + +CREATE TABLE IF NOT EXISTS reviews ( + id BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, + project BIGINT UNSIGNED NOT NULL, + owner BIGINT UNSIGNED NOT NULL, + title VARCHAR(1024) NOT NULL, + description MEDIUMTEXT NOT NULL DEFAULT '', + state TINYINT UNSIGNED NOT NULL DEFAULT 0, + progress FLOAT NOT NULL DEFAULT 0, + + CONSTRAINT `fk_reviews_project` + FOREIGN KEY (project) REFERENCES projects (id) + ON DELETE CASCADE + ON UPDATE RESTRICT, + + CONSTRAINT `fk_reviews_owner` + FOREIGN KEY (owner) REFERENCES users (id) + ON DELETE CASCADE + ON UPDATE RESTRICT +); + +CREATE TABLE IF NOT EXISTS review_users ( + review BIGINT UNSIGNED NOT NULL, + user BIGINT UNSIGNED NOT NULL, + role TINYINT UNSIGNED NOT NULL DEFAULT 0, + PRIMARY KEY (review, user), + + CONSTRAINT `fk_review_users_review` + FOREIGN KEY (review) REFERENCES reviews (id) + ON DELETE CASCADE + ON UPDATE RESTRICT, + + CONSTRAINT `fk_review_users_user` + FOREIGN KEY (user) REFERENCES users (id) + ON DELETE CASCADE + ON UPDATE RESTRICT +); diff --git a/server/migrations/eyeballs.sql b/server/migrations/eyeballs.sql deleted file mode 100644 index aeb1470..0000000 --- a/server/migrations/eyeballs.sql +++ /dev/null @@ -1,67 +0,0 @@ -CREATE TABLE IF NOT EXISTS projects ( - id BIGINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, - title VARCHAR(1024) NOT NULL, - description MEDIUMTEXT NOT NULL DEFAULT '' -); - -CREATE TABLE IF NOT EXISTS users ( - id BIGINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, - username VARCHAR(256) NOT NULL UNIQUE, - name VARCHAR(1024) NOT NULL DEFAULT '', - active BOOLEAN NOT NULL DEFAULT 1 -); - -CREATE TABLE IF NOT EXISTS project_users ( - project BIGINT UNSIGNED NOT NULL, - user BIGINT UNSIGNED NOT NULL, - default_role TINYINT UNSIGNED NOT NULL, - maintainer BOOLEAN NOT NULL DEFAULT 0, - PRIMARY KEY (project, user), - - CONSTRAINT `fk_project_users_project` - FOREIGN KEY (project) REFERENCES projects (id) - ON DELETE CASCADE - ON UPDATE RESTRICT, - - CONSTRAINT `fk_project_users_user` - FOREIGN KEY (user) REFERENCES users (id) - ON DELETE CASCADE - ON UPDATE RESTRICT -); - -CREATE TABLE IF NOT EXISTS reviews ( - id BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, - project BIGINT UNSIGNED NOT NULL, - owner BIGINT UNSIGNED NOT NULL, - title VARCHAR(1024) NOT NULL, - description MEDIUMTEXT NOT NULL DEFAULT '', - state TINYINT UNSIGNED NOT NULL DEFAULT 0, - progress FLOAT NOT NULL DEFAULT 0, - - CONSTRAINT `fk_reviews_project` - FOREIGN KEY (project) REFERENCES projects (id) - ON DELETE CASCADE - ON UPDATE RESTRICT, - - CONSTRAINT `fk_reviews_owner` - FOREIGN KEY (owner) REFERENCES users (id) - ON DELETE CASCADE - ON UPDATE RESTRICT -); - -CREATE TABLE IF NOT EXISTS review_users ( - review BIGINT UNSIGNED NOT NULL, - user BIGINT UNSIGNED NOT NULL, - role TINYINT UNSIGNED NOT NULL DEFAULT 0, - PRIMARY KEY (review, user), - - CONSTRAINT `fk_review_users_review` - FOREIGN KEY (review) REFERENCES reviews (id) - ON DELETE CASCADE - ON UPDATE RESTRICT, - - CONSTRAINT `fk_review_users_user` - FOREIGN KEY (user) REFERENCES users (id) - ON DELETE CASCADE - ON UPDATE RESTRICT -); diff --git a/server/src/main.rs b/server/src/main.rs index be5bb77..54ad279 100644 --- a/server/src/main.rs +++ b/server/src/main.rs @@ -576,7 +576,7 @@ async fn review( async fn run_migrations(rocket: Rocket) -> fairing::Result { match Db::fetch(&rocket) { - Some(db) => match sqlx::migrate!("./migrations").run(&**db).await { + Some(db) => match sqlx::migrate!().run(&**db).await { Ok(_) => Ok(rocket), Err(e) => { error!("Failed to initialize database: {}", e); -- cgit v1.2.3-70-g09d2