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

1 files changed, 13 insertions, 0 deletions

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)
+);
+