SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- Name: app_configuration; Type: TABLE; Schema: public; Owner: gazelle; Tablespace:
--

CREATE TABLE app_configuration (
  id integer NOT NULL,
  value character varying(255),
  variable character varying(255)
);

ALTER TABLE public.app_configuration OWNER TO gazelle;

--
-- Name: app_configuration_pkey; Type: CONSTRAINT; Schema: public; Owner: gazelle; Tablespace:
--

ALTER TABLE ONLY app_configuration
ADD CONSTRAINT app_configuration_pkey PRIMARY KEY (id);

--
-- Name: variable_unique; Type: CONSTRAINT; Schema: public; Owner: gazelle; Tablespace:
--

ALTER TABLE ONLY app_configuration
ADD CONSTRAINT variable_unique UNIQUE (variable);

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

INSERT INTO app_configuration VALUES (1, 'false', 'ip_login');
INSERT INTO app_configuration VALUES (23, '.*', 'ip_login_admin');
INSERT INTO app_configuration VALUES (3, '100000000', 'upload_max_size');
INSERT INTO app_configuration VALUES (4, '/testAssertion/assertion', 'assertion_manager_rest_path_to_assertion');
INSERT INTO app_configuration VALUES (5, 'https://server_domain:8080/AssertionManagerGui/rest', 'assertion_manager_rest_url'); --update with your server domain example: https://gazelle.ihe.net/AssertionManagerGui/rest
INSERT INTO app_configuration VALUES (6, 'true', 'security-policies');
INSERT INTO app_configuration VALUES (7, 'SAMEORIGIN', 'X-Frame-Options');
INSERT INTO app_configuration VALUES (8, 'private, no-cache, no-store, must-revalidate, max-age=0', 'Cache-Control');
INSERT INTO app_configuration VALUES (9, 'max-age=31536000 ; includeSubDomains', 'Strict-Transport-Security');
INSERT INTO app_configuration VALUES (10, '', 'X-Content-Security-Policy');
INSERT INTO app_configuration VALUES (11, 'Use X-Content-Security-Policy values', 'X-WebKit-CSP');
INSERT INTO app_configuration VALUES (12, 'Use X-Content-Security-Policy-Report-Only values', 'X-WebKit-CSP-Report-Only');
INSERT INTO app_configuration VALUES (13, 'default-src self *.ihe-europe.net; script-src self unsafe-eval unsafe-inline ; style-src self unsafe-inline ;', 'X-Content-Security-Policy-Report-Only');
INSERT INTO app_configuration VALUES (14, 'true', 'sql_injection_filter_switch');
INSERT INTO app_configuration VALUES (15, 'https://server_domain:8080/AssertionManagerGui', 'application_url'); --update with your server domain
INSERT INTO app_configuration VALUES (16, 'false', 'application_works_without_cas');
INSERT INTO app_configuration VALUES (17, 'https://server_domain:8080/cas', 'cas_url'); --update with your server domain
INSERT INTO app_configuration VALUES (18, 'https://server_domain:8080/gazelle/rest/', 'gazelle_test-managment-url'); --update with your server domain
INSERT INTO app_configuration VALUES (19, 'https://gazelle.ihe.net/gazelle-documentation/Assertion-Manager/user.html', 'application_documentation');
INSERT INTO app_configuration VALUES (20, 'https://gazelle.ihe.net/gazelle-documentation/Assertion-Manager/user.html', 'documentation_url');
INSERT INTO app_configuration VALUES (21, 'https://gazelle.ihe.net/jira/browse/AS#selectedTab=com.atlassian.jira.plugin.system.project%3Achangelog-panel', 'application_release_notes_url');
INSERT INTO app_configuration (id,value,variable) values (22,'true','cas_enable');