3 ADD COLUMN creator_id int REFERENCES person ON UPDATE CASCADE ON DELETE CASCADE;
6 CREATE INDEX idx_community_creator ON community (creator_id);
8 -- Add the data, selecting the highest mod
12 creator_id = sub.person_id
18 community_moderator cm
21 id = sub.community_id;
25 ALTER COLUMN creator_id SET NOT NULL;