~vpzom/lotide

ref: 6f183c37ed24dfe1b8fc69a68f31b10bda3e49bd lotide/migrations/20200806044856_moderators/up.sql -rw-r--r-- 287 bytes
6f183c37Colin Reeder Update docs with new env variables 1 year, 1 month ago
                                                                                
1
2
3
4
5
6
7
8
9
10
BEGIN;
	CREATE TABLE community_moderator (
		community BIGINT REFERENCES community,
		person BIGINT REFERENCES person,

		PRIMARY KEY (community, person)
	);

	INSERT INTO community_moderator (community, person) SELECT id, created_by FROM community WHERE created_by IS NOT NULL;
COMMIT;