-- Drop table

-- DROP TABLE back_office.control_list;

CREATE TABLE back_office.control_list (
    id int2 NOT NULL,
    name varchar(100) NOT NULL,
    "group" varchar(100) NOT NULL DEFAULT ''::character varying,
    is_active bool NOT NULL DEFAULT true,
    CONSTRAINT control_list_pk PRIMARY KEY (id),
    CONSTRAINT control_list_un UNIQUE (name)
);
CREATE INDEX control_list_permission_idx ON back_office.control_list USING btree (name);