1 create table category (
3 name varchar(100) not null unique
6 insert into category (name) values
23 ('Gender/Identity/Sexuality'),
24 ('Race/Colonisation'),
26 ('Science/Technology'),
27 ('Programming/Software'),
28 ('Health/Sports/Fitness'),
34 ALTER TABLE community ADD category_id int references category on update cascade on delete cascade not null default 1;