Feat: Update db to set tag for product instead of specific product

7 files changed, 17 insertions, 15 deletions

diff --git a/.dockerignore b/.dockerignore
index c3e7034..fc04251 100644
--- a/.dockerignore
+++ b/.dockerignore
@@ -2,3 +2,4 @@ target/
 .git/
 .env
 *.db
+documentation/
diff --git a/documentation/er-model.pdf b/documentation/er-model.pdf
new file mode 100644
index 0000000..2a6d49c
--- /dev/null
+++ b/documentation/er-model.pdf
diff --git a/migrations/20241106161637_tagredesign.sql b/migrations/20241106161637_tagredesign.sql
new file mode 100644
index 0000000..c33cec3
--- /dev/null
+++ b/migrations/20241106161637_tagredesign.sql
@@ -0,0 +1,13 @@
+DROP TABLE IF EXISTS storytag;
+DROP TABLE IF EXISTS gametag;
+DROP TABLE IF EXISTS tooltag;
+
+CREATE TABLE IF NOT EXISTS producttag
+(
+    pid  INTEGER NOT NULL,
+    tid INTEGER NOT NULL,
+    FOREIGN KEY (pid) REFERENCES product(id),
+    FOREIGN KEY (tid) REFERENCES tag(id),
+    PRIMARY KEY (pid, tid)
+);
+
diff --git a/src/db/gametag.rs b/src/db/gametag.rs
deleted file mode 100644
index 335d2a4..0000000
--- a/src/db/gametag.rs
+++ /dev/null
@@ -1,5 +0,0 @@
-#[derive(Debug, serde::Serialize, sqlx::FromRow)]
-pub struct Gametag {
-    pub gid: i64,
-    pub tgid: i64,
-}
diff --git a/src/db/mod.rs b/src/db/mod.rs
index 0b310c6..7050527 100644
--- a/src/db/mod.rs
+++ b/src/db/mod.rs
@@ -4,13 +4,11 @@ use crate::error::AppError;
 use async_trait::async_trait;
 
 pub mod game;
-pub mod gametag;
 pub mod product;
+pub mod producttag;
 pub mod story;
-pub mod storytag;
 pub mod tag;
 pub mod tool;
-pub mod tooltag;
 
 #[async_trait]
 pub trait ProductDatabaseHandler {
diff --git a/src/db/storytag.rs b/src/db/producttag.rs
index 0953fc2..b3091c3 100644
--- a/src/db/storytag.rs
+++ b/src/db/producttag.rs
@@ -1,5 +1,5 @@
 #[derive(Debug, serde::Serialize, sqlx::FromRow)]
 pub struct Storytag {
-    pub sid: i64,
-    pub tgid: i64,
+    pub pid: i64,
+    pub tid: i64,
 }
diff --git a/src/db/tooltag.rs b/src/db/tooltag.rs
deleted file mode 100644
index 393e687..0000000
--- a/src/db/tooltag.rs
+++ /dev/null
@@ -1,5 +0,0 @@
-#[derive(Debug, serde::Serialize, sqlx::FromRow)]
-pub struct Tooltag {
-    pub tid: i64,
-    pub tgid: i64,
-}