migrations/20241106161637_tagredesign.sql


1
2
3
4
5
6
7
8
9
10
11
12
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)
);