~singpolyma/jmp-schemas

ref: 240b3444466fb458b517d84c83bd6a782a21934e jmp-schemas/deploy/unused_invites.sql -rw-r--r-- 161 bytes
240b3444Stephen Paul Weber NOTIFY on low balance 9 months ago
                                                                                
1
2
3
4
5
6
7
8
9
10
-- Deploy jmp:unused_invites to pg

BEGIN;

CREATE VIEW unused_invites AS
	SELECT creator_id, created_at, code
	FROM invites
	WHERE used_by_id IS NULL;

COMMIT;