migrations/20220429210913_message_filter.sql


1
2
3
4
5
6
7
8

-- Add migration script here

CREATE TYPE filter_action AS ENUM ( 'delete', 'review' );
CREATE TABLE message_filter(
	id SERIAL PRIMARY KEY,
	pattern TEXT NOT NULL,
	action filter_action NOT NULL DEFAULT 'review'
);