--
--


SELECT pg_catalog.set_config('search_path', '', false);

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';




--
-- Name: policy_set_stack; Type: TABLE; Schema: public; Owner: gazelle
--

CREATE TABLE public.policy_set_stack (
  id                   integer                   NOT NULL,
  id_root              character varying(100)    NOT NULL,
  id_extension         character varying(100)    NOT NULL,
  policyset_id         character varying(100)    NOT NULL,
  policyset            character varying(300000) NOT NULL,
  community            character varying(100),
  policysetidreference character varying(100),
  subject              character varying(50),
  subject_role         character varying(50),
  is_active            boolean
);


ALTER TABLE public.policy_set_stack
  OWNER TO gazelle;

--
-- Name: policy_set_stack_id_seq; Type: SEQUENCE; Schema: public; Owner: gazelle
--

CREATE SEQUENCE public.policy_set_stack_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.policy_set_stack_id_seq
  OWNER TO gazelle;

--
-- Name: policy_set_stack_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: gazelle
--

ALTER SEQUENCE public.policy_set_stack_id_seq
OWNED BY public.policy_set_stack.id;


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: gazelle
--

ALTER TABLE ONLY public.policy_set_stack
  ALTER COLUMN id SET DEFAULT nextval('public.policy_set_stack_id_seq' :: regclass);


--
-- Data for Name: policy_set_stack; Type: TABLE DATA; Schema: public; Owner: gazelle
--

COPY public.policy_set_stack (id, id_root, id_extension, policyset_id, policyset, community, policysetidreference, subject, subject_role, is_active) FROM stdin;
390	2.16.756.5.30.1.127.3.10.3	761337610455909127	urn:uuid:05d6f6d8-91dd-410b-9c6f-e4bdffc5d439	[BLOB]	urn:oid:1.3.6.1.4.1.21367.2017.2.6.2	urn:e-health-suisse:2015:policies:provide-level:normal	761337610445502987	PAT	t
391	2.16.756.5.30.1.127.3.10.3	761337610445502987	urn:uuid:05d6f6d8-91dd-410b-9c6f-e4bdffc5d438		urn:oid:1.3.6.1.4.1.21367.2017.2.6.2	urn:e-health-suisse:2015:policies:provide-level:normal	761337610445502987	PAT	f
392	2.16.756.5.30.1.127.3.10.3	761337610445502987	urn:uuid:8ca6137e-7f81-47e3-9afc-0784bfda4741		urn:oid:1.3.6.1.4.1.21367.2017.2.6.2	urn:e-health-suisse:2015:policies:provide-level:normal	761337610445502987	PAT	f
393	2.16.756.5.30.1.127.3.10.3	761337610445502987	urn:uuid:9dbc25d9-1452-4d57-99da-b0d442e102de		urn:oid:1.3.6.1.4.1.21367.2017.2.6.2	urn:e-health-suisse:2015:policies:provide-level:normal	761337610445502987	PAT	f
\.


--
-- Name: policy_set_stack_id_seq; Type: SEQUENCE SET; Schema: public; Owner: gazelle
--

SELECT pg_catalog.setval('public.policy_set_stack_id_seq', 393, true);


--
-- Name: policy_set_stack_pkey; Type: CONSTRAINT; Schema: public; Owner: gazelle
--

ALTER TABLE ONLY public.policy_set_stack
  ADD CONSTRAINT policy_set_stack_pkey PRIMARY KEY (id);


--
-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
--

