db/schema_0044-contact_response_templates.sql


1
2
3
4
5
6
7
8
9
10
11
12

BEGIN;

CREATE TABLE contact_response_templates (
    id serial NOT NULL PRIMARY KEY,
    contact_id int REFERENCES contacts(id) NOT NULL,
    response_template_id int REFERENCES response_templates(id) NOT NULL
);

ALTER TABLE response_templates
  ADD COLUMN auto_response boolean NOT NULL DEFAULT 'f';

COMMIT;