1 CREATE TABLE category (
3 name varchar(100) NOT NULL UNIQUE
6 INSERT INTO category (name)
23 ('Gender/Identity/Sexuality'),
24 ('Race/Colonisation'),
26 ('Science/Technology'),
27 ('Programming/Software'),
28 ('Health/Sports/Fitness'),
35 ADD category_id int REFERENCES category ON UPDATE CASCADE ON DELETE CASCADE NOT NULL DEFAULT 1;