From 9a3db2b9fab5e5cfa34d921bbff9ad95dbf05ee6 Mon Sep 17 00:00:00 2001 From: WriterV2 Date: Sun, 24 Nov 2024 12:51:57 +0100 Subject: Fix: Make tags unique (empties product tags) --- migrations/20241124111952_uniquetags.sql | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 migrations/20241124111952_uniquetags.sql (limited to 'migrations') diff --git a/migrations/20241124111952_uniquetags.sql b/migrations/20241124111952_uniquetags.sql new file mode 100644 index 0000000..ff8b6ef --- /dev/null +++ b/migrations/20241124111952_uniquetags.sql @@ -0,0 +1,19 @@ +DELETE FROM producttag; +CREATE TABLE IF NOT EXISTS newtag +( + id INTEGER PRIMARY KEY NOT NULL, + name TEXT NOT NULL UNIQUE +); + +WITH uniquetags AS ( + SELECT id, name, ROW_NUMBER() OVER (PARTITION BY name ORDER BY id) AS row_num + FROM tag +) + +INSERT INTO newtag (id, name) +SELECT id, name +FROM uniquetags +WHERE row_num = 1; + +DROP TABLE tag; +ALTER TABLE newtag RENAME TO tag; -- cgit v1.2.3