--
--


-- Started on 2025-10-03 12:20:50

SET transaction_timeout = 0;

DROP DATABASE db_cibel;
--
-- TOC entry 6100 (class 1262 OID 17575)
-- Name: db_cibel; Type: DATABASE; Schema: -; Owner: postgres
--

CREATE DATABASE db_cibel WITH TEMPLATE = template0 ENCODING = 'UTF8';


ALTER DATABASE db_cibel OWNER TO postgres;
SET transaction_timeout = 0;

--
-- TOC entry 11 (class 2615 OID 17588)
-- Name: codelist; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA codelist;


ALTER SCHEMA codelist OWNER TO postgres;

--
-- TOC entry 6101 (class 0 OID 0)
-- Dependencies: 11
-- Name: SCHEMA codelist; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA codelist IS 'Code list table';


--
-- TOC entry 6102 (class 0 OID 0)
-- Dependencies: 7
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: pg_database_owner
--

COMMENT ON SCHEMA public IS 'standard public schema table almost created by angular framework';


--
-- TOC entry 10 (class 2615 OID 17589)
-- Name: spatial; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA spatial;


ALTER SCHEMA spatial OWNER TO postgres;

--
-- TOC entry 6103 (class 0 OID 0)
-- Dependencies: 10
-- Name: SCHEMA spatial; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA spatial IS 'Schema for spatial data tables';


--
-- TOC entry 9 (class 2615 OID 17587)
-- Name: tabular; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA tabular;


ALTER SCHEMA tabular OWNER TO postgres;

--
-- TOC entry 6104 (class 0 OID 0)
-- Dependencies: 9
-- Name: SCHEMA tabular; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA tabular IS 'Dynamic tables';


--
-- TOC entry 3 (class 3079 OID 17894)
-- Name: pgcrypto; Type: EXTENSION; Schema: -; Owner: -
--

CREATE EXTENSION IF NOT EXISTS pgcrypto WITH SCHEMA public;


--
-- TOC entry 6105 (class 0 OID 0)
-- Dependencies: 3
-- Name: EXTENSION pgcrypto; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION pgcrypto IS 'cryptographic functions';


--
-- TOC entry 4 (class 3079 OID 19798)
-- Name: postgis; Type: EXTENSION; Schema: -; Owner: -
--

CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public;


--
-- TOC entry 6106 (class 0 OID 0)
-- Dependencies: 4
-- Name: EXTENSION postgis; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION postgis IS 'PostGIS geometry and geography spatial types and functions';


--
-- TOC entry 2 (class 3079 OID 17576)
-- Name: uuid-ossp; Type: EXTENSION; Schema: -; Owner: -
--

CREATE EXTENSION IF NOT EXISTS "uuid-ossp" WITH SCHEMA public;


--
-- TOC entry 6107 (class 0 OID 0)
-- Dependencies: 2
-- Name: EXTENSION "uuid-ossp"; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION "uuid-ossp" IS 'generate universally unique identifiers (UUIDs)';




--
-- TOC entry 250 (class 1259 OID 19538)
-- Name: collection_methods; Type: TABLE; Schema: codelist; Owner: postgres
--

CREATE TABLE codelist.collection_methods (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE codelist.collection_methods OWNER TO postgres;

--
-- TOC entry 236 (class 1259 OID 19012)
-- Name: currency; Type: TABLE; Schema: codelist; Owner: postgres
--

CREATE TABLE codelist.currency (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE codelist.currency OWNER TO postgres;

--
-- TOC entry 248 (class 1259 OID 19520)
-- Name: data_formats; Type: TABLE; Schema: codelist; Owner: postgres
--

CREATE TABLE codelist.data_formats (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE codelist.data_formats OWNER TO postgres;

--
-- TOC entry 249 (class 1259 OID 19528)
-- Name: data_licences; Type: TABLE; Schema: codelist; Owner: postgres
--

CREATE TABLE codelist.data_licences (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    description text NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE codelist.data_licences OWNER TO postgres;

--
-- TOC entry 235 (class 1259 OID 19004)
-- Name: project_locations; Type: TABLE; Schema: codelist; Owner: postgres
--

CREATE TABLE codelist.project_locations (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE codelist.project_locations OWNER TO postgres;

--
-- TOC entry 251 (class 1259 OID 19546)
-- Name: thematic_categories; Type: TABLE; Schema: codelist; Owner: postgres
--

CREATE TABLE codelist.thematic_categories (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE codelist.thematic_categories OWNER TO postgres;

--
-- TOC entry 234 (class 1259 OID 18821)
-- Name: user_roles; Type: TABLE; Schema: codelist; Owner: postgres
--

CREATE TABLE codelist.user_roles (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE codelist.user_roles OWNER TO postgres;

--
-- TOC entry 232 (class 1259 OID 18762)
-- Name: cache; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.cache (
    key character varying(255) NOT NULL,
    value text NOT NULL,
    expiration integer NOT NULL
);


ALTER TABLE public.cache OWNER TO postgres;

--
-- TOC entry 233 (class 1259 OID 18769)
-- Name: cache_locks; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.cache_locks (
    key character varying(255) NOT NULL,
    owner character varying(255) NOT NULL,
    expiration integer NOT NULL
);


ALTER TABLE public.cache_locks OWNER TO postgres;

--
-- TOC entry 231 (class 1259 OID 18751)
-- Name: failed_jobs; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.failed_jobs (
    id bigint NOT NULL,
    uuid character varying(255) NOT NULL,
    connection text NOT NULL,
    queue text NOT NULL,
    payload text NOT NULL,
    exception text NOT NULL,
    failed_at timestamp(0) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL
);


ALTER TABLE public.failed_jobs OWNER TO postgres;

--
-- TOC entry 230 (class 1259 OID 18750)
-- Name: failed_jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.failed_jobs_id_seq OWNER TO postgres;

--
-- TOC entry 6108 (class 0 OID 0)
-- Dependencies: 230
-- Name: failed_jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.failed_jobs_id_seq OWNED BY public.failed_jobs.id;


--
-- TOC entry 229 (class 1259 OID 18743)
-- Name: job_batches; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.job_batches (
    id character varying(255) NOT NULL,
    name character varying(255) NOT NULL,
    total_jobs integer NOT NULL,
    pending_jobs integer NOT NULL,
    failed_jobs integer NOT NULL,
    failed_job_ids text NOT NULL,
    options text,
    cancelled_at integer,
    created_at integer NOT NULL,
    finished_at integer
);


ALTER TABLE public.job_batches OWNER TO postgres;

--
-- TOC entry 228 (class 1259 OID 18734)
-- Name: jobs; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.jobs (
    id bigint NOT NULL,
    queue character varying(255) NOT NULL,
    payload text NOT NULL,
    attempts smallint NOT NULL,
    reserved_at integer,
    available_at integer NOT NULL,
    created_at integer NOT NULL
);


ALTER TABLE public.jobs OWNER TO postgres;

--
-- TOC entry 227 (class 1259 OID 18733)
-- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.jobs_id_seq OWNER TO postgres;

--
-- TOC entry 6109 (class 0 OID 0)
-- Dependencies: 227
-- Name: jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.jobs_id_seq OWNED BY public.jobs.id;


--
-- TOC entry 224 (class 1259 OID 17591)
-- Name: migrations; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.migrations (
    id integer NOT NULL,
    migration character varying(255) NOT NULL,
    batch integer NOT NULL
);


ALTER TABLE public.migrations OWNER TO postgres;

--
-- TOC entry 223 (class 1259 OID 17590)
-- Name: migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.migrations_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.migrations_id_seq OWNER TO postgres;

--
-- TOC entry 6110 (class 0 OID 0)
-- Dependencies: 223
-- Name: migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.migrations_id_seq OWNED BY public.migrations.id;


--
-- TOC entry 241 (class 1259 OID 19426)
-- Name: password_reset_tokens; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.password_reset_tokens (
    email character varying(255) NOT NULL,
    token character varying(255) NOT NULL,
    created_at timestamp(0) without time zone
);


ALTER TABLE public.password_reset_tokens OWNER TO postgres;

--
-- TOC entry 225 (class 1259 OID 18710)
-- Name: personal_access_tokens_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.personal_access_tokens_id_seq OWNER TO postgres;

--
-- TOC entry 6111 (class 0 OID 0)
-- Dependencies: 225
-- Name: personal_access_tokens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.personal_access_tokens_id_seq OWNED BY public.personal_access_tokens.id;

--
-- TOC entry 246 (class 1259 OID 19498)
-- Name: refresh_tokens_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.refresh_tokens_id_seq OWNER TO postgres;

--
-- TOC entry 6112 (class 0 OID 0)
-- Dependencies: 246
-- Name: refresh_tokens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.refresh_tokens_id_seq OWNED BY public.refresh_tokens.id;


--
-- TOC entry 242 (class 1259 OID 19433)
-- Name: sessions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sessions (
    id character varying(255) NOT NULL,
    user_id bigint,
    ip_address character varying(45),
    user_agent text,
    payload text NOT NULL,
    last_activity integer NOT NULL
);


ALTER TABLE public.sessions OWNER TO postgres;

--
-- TOC entry 260 (class 1259 OID 20956)
-- Name: tridom_3857; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.tridom_3857 (
    gid integer NOT NULL,
    id double precision,
    geom public.geometry(MultiPolygon,3857)
);


ALTER TABLE public.tridom_3857 OWNER TO postgres;

--
-- TOC entry 259 (class 1259 OID 20955)
-- Name: tridom_3857_gid_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.tridom_3857_gid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.tridom_3857_gid_seq OWNER TO postgres;

--
-- TOC entry 6113 (class 0 OID 0)
-- Dependencies: 259
-- Name: tridom_3857_gid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.tridom_3857_gid_seq OWNED BY public.tridom_3857.gid;

--
-- TOC entry 239 (class 1259 OID 19402)
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.users_id_seq OWNER TO postgres;

--
-- TOC entry 6114 (class 0 OID 0)
-- Dependencies: 239
-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;


--
-- TOC entry 262 (class 1259 OID 20974)
-- Name: tridom; Type: TABLE; Schema: spatial; Owner: postgres
--

CREATE TABLE spatial.tridom (
    id integer NOT NULL,
    shape_leng numeric,
    name character varying(50),
    admin_area numeric,
    gis_area_h numeric,
    gis_length numeric,
    toponyme character varying(10),
    geom public.geometry(MultiPolygon,3857)
);


ALTER TABLE spatial.tridom OWNER TO postgres;

--
-- TOC entry 261 (class 1259 OID 20973)
-- Name: tridom_gid_seq; Type: SEQUENCE; Schema: spatial; Owner: postgres
--

CREATE SEQUENCE spatial.tridom_gid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE spatial.tridom_gid_seq OWNER TO postgres;

--
-- TOC entry 6115 (class 0 OID 0)
-- Dependencies: 261
-- Name: tridom_gid_seq; Type: SEQUENCE OWNED BY; Schema: spatial; Owner: postgres
--

ALTER SEQUENCE spatial.tridom_gid_seq OWNED BY spatial.tridom.id;


--
-- TOC entry 253 (class 1259 OID 19635)
-- Name: documents; Type: TABLE; Schema: tabular; Owner: postgres
--

CREATE TABLE tabular.documents (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    type character varying(255) NOT NULL,
    description text NOT NULL,
    size integer NOT NULL,
    publication_date timestamp(0) without time zone,
    author text,
    edition_year character varying(4),
    path text NOT NULL,
    project_id uuid NOT NULL,
    user_id uuid NOT NULL,
    role_id uuid NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE tabular.documents OWNER TO postgres;

--
-- TOC entry 238 (class 1259 OID 19213)
-- Name: organizations; Type: TABLE; Schema: tabular; Owner: postgres
--

CREATE TABLE tabular.organizations (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    description text,
    logo character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE tabular.organizations OWNER TO postgres;

--
-- TOC entry 245 (class 1259 OID 19485)
-- Name: project_objectives; Type: TABLE; Schema: tabular; Owner: postgres
--

CREATE TABLE tabular.project_objectives (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    project_id uuid NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE tabular.project_objectives OWNER TO postgres;

--
-- TOC entry 244 (class 1259 OID 19472)
-- Name: project_results; Type: TABLE; Schema: tabular; Owner: postgres
--

CREATE TABLE tabular.project_results (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    project_id uuid NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE tabular.project_results OWNER TO postgres;

--
-- TOC entry 252 (class 1259 OID 19585)
-- Name: project_thematics; Type: TABLE; Schema: tabular; Owner: postgres
--

CREATE TABLE tabular.project_thematics (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    data_licence_id uuid,
    collection_method_ids json,
    data_format_ids json,
    project_id uuid NOT NULL,
    thematic_id uuid NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE tabular.project_thematics OWNER TO postgres;

--
-- TOC entry 243 (class 1259 OID 19442)
-- Name: projects; Type: TABLE; Schema: tabular; Owner: postgres
--

CREATE TABLE tabular.projects (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    field character varying(255),
    location_id uuid,
    start_date timestamp(0) without time zone,
    end_date timestamp(0) without time zone,
    budget integer,
    currency_id uuid,
    organization_id uuid NOT NULL,
    user_id uuid NOT NULL,
    website character varying(255),
    manager_name character varying(255),
    manager_email character varying(255),
    manager_phone character varying(255),
    focal_point_name character varying(255),
    focal_point_email character varying(255),
    focal_point_phone character varying(255),
    main_objective text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    logo character varying(255),
    logo_copyright character varying(255)
);


ALTER TABLE tabular.projects OWNER TO postgres;

--
-- TOC entry 237 (class 1259 OID 19091)
-- Name: thematics; Type: TABLE; Schema: tabular; Owner: postgres
--

CREATE TABLE tabular.thematics (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    definition text,
    source character varying(255),
    source_link character varying(255),
    category_thematic_id uuid
);


ALTER TABLE tabular.thematics OWNER TO postgres;

--
-- TOC entry 5772 (class 2604 OID 18754)
-- Name: failed_jobs id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- TOC entry 5771 (class 2604 OID 18737)
-- Name: jobs id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- TOC entry 5769 (class 2604 OID 17594)
-- Name: migrations id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- TOC entry 5791 (class 2604 OID 20959)
-- Name: tridom_3857 gid; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tridom_3857 ALTER COLUMN gid SET DEFAULT nextval('public.tridom_3857_gid_seq'::regclass);


--
-- TOC entry 5792 (class 2604 OID 20977)
-- Name: tridom id; Type: DEFAULT; Schema: spatial; Owner: postgres
--

ALTER TABLE ONLY spatial.tridom ALTER COLUMN id SET DEFAULT nextval('spatial.tridom_gid_seq'::regclass);


--
-- TOC entry 6087 (class 0 OID 19538)
-- Dependencies: 250
-- Data for Name: collection_methods; Type: TABLE DATA; Schema: codelist; Owner: postgres
--

INSERT INTO codelist.collection_methods VALUES ('e7b3e927-a8b0-4e74-a557-292d57dccc98', 'collection_method_interviews', '2025-06-27 09:42:20', '2025-06-27 09:42:20');
INSERT INTO codelist.collection_methods VALUES ('5d892af8-8bff-42f6-bcbe-488f3451ce9b', 'collection_method_surveys', '2025-06-27 09:42:20', '2025-06-27 09:42:20');
INSERT INTO codelist.collection_methods VALUES ('d3b299a4-2544-4eba-a433-cf110edcda81', 'collection_method_observation', '2025-06-27 09:42:20', '2025-06-27 09:42:20');
INSERT INTO codelist.collection_methods VALUES ('94f089e2-8553-42db-8a98-9d095c8769f9', 'collection_method_documents_and_or_records', '2025-06-27 09:42:20', '2025-06-27 09:42:20');
INSERT INTO codelist.collection_methods VALUES ('988b85f2-78e0-4c47-b15a-71675117890d', 'collection_method_discussion_group', '2025-06-27 09:42:20', '2025-06-27 09:42:20');


--
-- TOC entry 6073 (class 0 OID 19012)
-- Dependencies: 236
-- Data for Name: currency; Type: TABLE DATA; Schema: codelist; Owner: postgres
--

INSERT INTO codelist.currency VALUES ('8f52a997-59c9-488b-b2cd-7c8dfa301bb4', 'EURO', '2025-06-24 14:46:26', '2025-06-24 14:46:26');
INSERT INTO codelist.currency VALUES ('2893541d-843a-4f7f-af5c-5a1f8593bf06', 'USD', '2025-06-24 14:46:26', '2025-06-24 14:46:26');
INSERT INTO codelist.currency VALUES ('5a13ed76-a315-4122-845e-2a0a02937675', 'XAF', '2025-06-24 14:46:26', '2025-06-24 14:46:26');


--
-- TOC entry 6085 (class 0 OID 19520)
-- Dependencies: 248
-- Data for Name: data_formats; Type: TABLE DATA; Schema: codelist; Owner: postgres
--

INSERT INTO codelist.data_formats VALUES ('0fb251de-3206-446d-a58b-7cb2cc6f4da9', 'data_format_technical_report', '2025-06-27 09:41:46', '2025-06-27 09:41:46');
INSERT INTO codelist.data_formats VALUES ('7d784d1f-6cbb-47d6-99da-8150be228bb5', 'data_format_spatial_data', '2025-06-27 09:41:46', '2025-06-27 09:41:46');
INSERT INTO codelist.data_formats VALUES ('23427270-a3c8-4dce-aef9-9ad6ca82f06a', 'data_format_data_table', '2025-06-27 09:41:46', '2025-06-27 09:41:46');


--
-- TOC entry 6086 (class 0 OID 19528)
-- Dependencies: 249
-- Data for Name: data_licences; Type: TABLE DATA; Schema: codelist; Owner: postgres
--

INSERT INTO codelist.data_licences VALUES ('17f55ee6-0038-4fe3-b845-7770f9df540a', 'data_licence_commercial_name', 'data_licence_commercial_description', '2025-06-27 09:42:02', '2025-06-27 09:42:02');
INSERT INTO codelist.data_licences VALUES ('eb9a46d7-c7c7-4d41-8ed4-597370bb2ecb', 'data_licence_copyleft_name', 'data_licence_copyleft_description', '2025-06-27 09:42:02', '2025-06-27 09:42:02');
INSERT INTO codelist.data_licences VALUES ('d5b625e5-390b-41c4-87b4-6012f67d63f5', 'data_licence_free_name', 'data_licence_free_description', '2025-06-27 09:42:02', '2025-06-27 09:42:02');
INSERT INTO codelist.data_licences VALUES ('06b5188c-445b-46b1-a443-be4bfb67b899', 'data_licence_restricted_name', 'data_licence_restricted_description', '2025-06-27 09:42:02', '2025-06-27 09:42:02');


--
-- TOC entry 6072 (class 0 OID 19004)
-- Dependencies: 235
-- Data for Name: project_locations; Type: TABLE DATA; Schema: codelist; Owner: postgres
--

INSERT INTO codelist.project_locations VALUES ('f1ccfef1-2066-4c5b-903f-ed3212b16a28', 'location_cameroon', '2025-06-24 14:29:42', '2025-06-24 14:29:42');
INSERT INTO codelist.project_locations VALUES ('5197d1e6-6442-4bf9-8597-f43db3bb5b8c', 'location_gabon', '2025-06-24 14:29:42', '2025-06-24 14:29:42');
INSERT INTO codelist.project_locations VALUES ('079fad94-17ca-4812-9cac-83d77855ae9c', 'location_tridom', '2025-06-24 14:29:42', '2025-06-24 14:29:42');
INSERT INTO codelist.project_locations VALUES ('30504452-2cc6-48a7-8b9c-c961daa7ad26', 'location_cameroon_congo', '2025-06-24 14:29:42', '2025-06-24 14:29:42');
INSERT INTO codelist.project_locations VALUES ('b0433c9d-2370-42c1-a879-a82e155e12f6', 'location_cameroon_gabon', '2025-06-24 14:29:42', '2025-06-24 14:29:42');
INSERT INTO codelist.project_locations VALUES ('1e4a6334-ea34-434c-a3bc-935c8038bed5', 'location_congo', '2025-06-24 14:29:42', '2025-06-24 14:29:42');
INSERT INTO codelist.project_locations VALUES ('e9325f73-7969-4da6-9870-41faa20442e5', 'location_congo_gabon', '2025-06-24 14:29:42', '2025-06-24 14:29:42');


--
-- TOC entry 6088 (class 0 OID 19546)
-- Dependencies: 251
-- Data for Name: thematic_categories; Type: TABLE DATA; Schema: codelist; Owner: postgres
--

INSERT INTO codelist.thematic_categories VALUES ('00466f04-9471-43fc-a3ee-63db5e4ba2d0', 'category_thematic_focus', '2025-06-27 09:42:33', '2025-06-27 09:42:33');
INSERT INTO codelist.thematic_categories VALUES ('8cc0cd04-3bef-416d-8a01-7698cbd61f11', 'category_thematic_threat', '2025-06-27 09:42:33', '2025-06-27 09:42:33');
INSERT INTO codelist.thematic_categories VALUES ('c70981f9-44d7-48d3-ba6c-12623105aeae', 'category_thematic_opportunity', '2025-06-27 09:42:33', '2025-06-27 09:42:33');


--
-- TOC entry 6071 (class 0 OID 18821)
-- Dependencies: 234
-- Data for Name: user_roles; Type: TABLE DATA; Schema: codelist; Owner: postgres
--

INSERT INTO codelist.user_roles VALUES ('5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf', 'user_role_viewer', '2025-06-23 11:27:31', '2025-06-23 11:27:31');
INSERT INTO codelist.user_roles VALUES ('ca4e388b-b6c6-415a-9b47-3264d8257574', 'user_role_editor', '2025-06-23 11:27:31', '2025-06-23 11:27:31');
INSERT INTO codelist.user_roles VALUES ('883112a8-fed4-4c25-8e8d-e4e77ed46e59', 'user_role_administrator', '2025-06-23 11:27:31', '2025-06-23 11:27:31');


--
-- TOC entry 6069 (class 0 OID 18762)
-- Dependencies: 232
-- Data for Name: cache; Type: TABLE DATA; Schema: public; Owner: postgres
--



--
-- TOC entry 6070 (class 0 OID 18769)
-- Dependencies: 233
-- Data for Name: cache_locks; Type: TABLE DATA; Schema: public; Owner: postgres
--



--
-- TOC entry 6068 (class 0 OID 18751)
-- Dependencies: 231
-- Data for Name: failed_jobs; Type: TABLE DATA; Schema: public; Owner: postgres
--



--
-- TOC entry 6066 (class 0 OID 18743)
-- Dependencies: 229
-- Data for Name: job_batches; Type: TABLE DATA; Schema: public; Owner: postgres
--



--
-- TOC entry 6065 (class 0 OID 18734)
-- Dependencies: 228
-- Data for Name: jobs; Type: TABLE DATA; Schema: public; Owner: postgres
--



--
-- TOC entry 6061 (class 0 OID 17591)
-- Dependencies: 224
-- Data for Name: migrations; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.migrations VALUES (59, '0001_01_01_000002_create_jobs_table', 3);
INSERT INTO public.migrations VALUES (60, '0001_01_01_000001_create_cache_table', 4);
INSERT INTO public.migrations VALUES (61, '2025_06_20_080127_create_user_roles_table', 5);
INSERT INTO public.migrations VALUES (64, '2025_06_20_071430_create_refresh_tokens_table', 8);
INSERT INTO public.migrations VALUES (68, '2025_06_24_142726_create_project_locations_table', 9);
INSERT INTO public.migrations VALUES (69, '2025_06_24_144011_create_currency_table', 10);
INSERT INTO public.migrations VALUES (80, '2025_06_25_154059_create_organizations_table', 11);
INSERT INTO public.migrations VALUES (85, '2024_06_25_164402_create_users_table', 12);
INSERT INTO public.migrations VALUES (86, '2025_06_24_164635_create_projects_table', 13);
INSERT INTO public.migrations VALUES (87, '2025_06_25_164722_create_project_results_table', 14);
INSERT INTO public.migrations VALUES (88, '2025_06_25_164429_create_project_objectives_table', 15);
INSERT INTO public.migrations VALUES (89, '2025_06_25_071430_create_refresh_tokens_table', 16);
INSERT INTO public.migrations VALUES (90, '2025_06_27_083328_create_data_formats_table', 17);
INSERT INTO public.migrations VALUES (91, '2025_06_27_083338_create_data_licences_table', 18);
INSERT INTO public.migrations VALUES (92, '2025_06_27_083409_create_collection_methods_table', 19);
INSERT INTO public.migrations VALUES (93, '2025_06_27_083852_create_thematic_cathegories_table', 20);
INSERT INTO public.migrations VALUES (95, '2025_06_27_155136_create_project_thematics_table', 21);
INSERT INTO public.migrations VALUES (96, '2025_06_25_153823_create_documents_table', 22);
INSERT INTO public.migrations VALUES (97, '2025_07_03_153823_create_documents_table', 23);


--
-- TOC entry 6079 (class 0 OID 19433)
-- Dependencies: 242
-- Data for Name: sessions; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.sessions VALUES ('d5gMe5G89VbFXgn8QiSwxYvjTMA5NZQPMxvLW7nO', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36 Edg/140.0.0.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWG8xVmw3WTZHb3ByR2thSWVSaFFlbmMySDlrQk1CalRMOE9UUTMxdSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvbG9jYWxlcyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1758787754);
INSERT INTO public.sessions VALUES ('ecKkxaC66wmb6jbAAPDlQixZI1OtF284n271f7Vz', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQ2pnd0EydDlTcEwwQWQxTHI1cEFFMDVKY0tTdjhWaVlOaUp3aTBCaCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6OTA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvZG9jdW1lbnRzL3B1YmxpYz9wcm9qZWN0X2lkPWFlYjU4ZDkyLWU0ODMtNDkzNi05ZmQ3LTZmOWIyYzZiNzczMCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1758900414);
INSERT INTO public.sessions VALUES ('u3Cm7zWCuXg7AilbgK9krB5TxSLCpHoV9sFARRnT', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiajUxZUp6M0tVeXV5T1RienUwcE44Z2Y2cmNOcklVeERJYzB3bFJjSCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6ODk6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvcHJvamVjdC9yZXN1bHRzP3Byb2plY3RfaWQ9YWViNThkOTItZTQ4My00OTM2LTlmZDctNmY5YjJjNmI3NzMwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1758900431);
INSERT INTO public.sessions VALUES ('L9cjCcljakPkt4xy5zWTdTLzp0ziWSKb0ptXZ3zp', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZHU2eWVvdGt0bkV3WUs2TEtyeGtMWVhXWmNmcVJRbW1wYkphVzdiTCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzk6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvb3JnYW5pemF0aW9ucyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1758900543);
INSERT INTO public.sessions VALUES ('2UE63hW24XUUPEsfqQfUAZ6xEpYPs6Vfsq3nwGBU', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZEt1R20wVDdEN1dZWHhFeG43dzZ6eDFHdlFoVXY5U0lpSm1zMzI3ZiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6OTI6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvcHJvamVjdC9vYmplY3RpdmVzP3Byb2plY3RfaWQ9OTBmZTZjOTYtOGRmMy00ZDQzLTllNWItMTFlNjE1YmUyZDJhIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1758901667);
INSERT INTO public.sessions VALUES ('rSPYHD2NGpehr6DWXCbmVcNHawAOI97YwD4VDrs5', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiekRFczNid09XbkxJM1ZkNktneVFuejNHR3UzUUFzS0VUQWtaemJjZyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvbG9jYWxlcyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1758811398);
INSERT INTO public.sessions VALUES ('2xhbRGnxsdhVB0EFIWfjHvrdYSxRKyETomsr4sZ1', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNzE2WGx5bFNlU082elhEeUFDWEhPNGQzdFdJSEFrc0FZS3V2c2c3MCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvcHJvamVjdHMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1758900415);
INSERT INTO public.sessions VALUES ('i1yZgfmKBtF0GGFGMhty8YD5EWS0ivpIOHxP9EzG', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUFlxSDhxdjdLRHY1ODE3YmZ4bmdGU3pDUzZKdVVBSXJPelR2Vmx5MiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6OTE6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvcHJvamVjdC90aGVtYXRpY3M/cHJvamVjdF9pZD1hZWI1OGQ5Mi1lNDgzLTQ5MzYtOWZkNy02ZjliMmM2Yjc3MzAiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1758900432);
INSERT INTO public.sessions VALUES ('kypPyCxqQqFgbLtsUOfo7s103wKbVXcWwAT0QLrm', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWmFDOTF6SzYyNk94aXY4ZXhnMkJhZjA1Z2h0SndNOVV0UDdRUFlsaSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvdGhlbWF0aWNzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1758900543);
INSERT INTO public.sessions VALUES ('Zv4JLAPuDP30wWyzbszOJAY35Me1TOKujoD6mfh7', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiOXowVGk5RDU3VnRnVXRENTlyOTUwcUFNUVZVUUw4OWVrZDk2ZGh5SSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6ODk6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvcHJvamVjdC9yZXN1bHRzP3Byb2plY3RfaWQ9OTBmZTZjOTYtOGRmMy00ZDQzLTllNWItMTFlNjE1YmUyZDJhIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1758901667);
INSERT INTO public.sessions VALUES ('peVF40IQmdvbQUVKqwIibc4F7DHeTCi8rKs8hrpU', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTkl1OTdOanJrTnJmQkF4VXBpUkRpd294YmJQVEZ1b0VJUExhNzhZcSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvbG9jYWxlcyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1759302492);
INSERT INTO public.sessions VALUES ('o4kF3o3nZU7G4Yv7Uxu1KcVb3wNsXLHyN2WJj6MT', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiYXl0MVdBSXNLcEpzd0JuZ3Q1b1h1aTdsc01aZGRPRTg1SHRNMmZZSyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvbG9jYWxlcyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1759417940);
INSERT INTO public.sessions VALUES ('0wjh6XPmx2VCOK9HggdvYx1kytTaS2GU95ODqmGQ', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibzRHSHZ3RXVybVJPVTZwcXJvdGxDaUFzaW9YM1pSYU8xdjQ5MmRRUSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvbG9jYWxlcyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1758812347);
INSERT INTO public.sessions VALUES ('JVghXRiETveelNVO2vLuvt1WXpfdcSdZk9p1bNcH', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSExCQmZCeHlzT2dSdHc5SUtkell0UHFaR2Z1bThmSzM0eEpJbkFUeiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzk6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvb3JnYW5pemF0aW9ucyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1758900416);
INSERT INTO public.sessions VALUES ('PRLXdT5nTt3gKydmwLP9ucRdK4VhVXVtwih8Uqwq', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQnEyTVpTSkpRRWdkbWhBZUpUbXRwWkdtMGJmQ1ZkZTN6cFU4MjFXcCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6OTA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvZG9jdW1lbnRzL3B1YmxpYz9wcm9qZWN0X2lkPWFlYjU4ZDkyLWU0ODMtNDkzNi05ZmQ3LTZmOWIyYzZiNzczMCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1758900432);
INSERT INTO public.sessions VALUES ('G6IHwpwIYiokwGoLEWX8o7Db8Zsu8c1Ex6MTvntR', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibEtVSEJseXFOUlR1OUNwQXV4RXl6bzBCWVE4cGhieDVnaHV3VzFiVCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NzA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvcHJvamVjdC85MGZlNmM5Ni04ZGYzLTRkNDMtOWU1Yi0xMWU2MTViZTJkMmEiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1758900547);
INSERT INTO public.sessions VALUES ('9dXX6VvUE5yM33nN7E8W1Yj2YLwqRAUPkQHfysBP', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZU1ocnNOVWpjYk5QQ3ZWUzNsZzBONkdGc0JMdm1nT1NGT2xoRFQ0ayI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6OTE6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvcHJvamVjdC90aGVtYXRpY3M/cHJvamVjdF9pZD05MGZlNmM5Ni04ZGYzLTRkNDMtOWU1Yi0xMWU2MTViZTJkMmEiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1758901667);
INSERT INTO public.sessions VALUES ('1jrkQBnYJp6DFdhxhs8GeZEdlMJonRABm55LsnmB', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiU0tNVFhPRW9RRG4xZ1JmY1pwNkZsbUkzb1Y0YWw3OXBaM1BZMlZkSSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvbG9jYWxlcyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1758832677);
INSERT INTO public.sessions VALUES ('JNCi0wessFkJIHUZl0SDTvf1zdAh1dmZBRG2R4wh', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRk9RV2FnS294bUFmSElScXVKM1IycmJwRm9KZmtYSXZsNGNWWjVwVCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvdGhlbWF0aWNzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1758900416);
INSERT INTO public.sessions VALUES ('4S9KZQGivOy6W6bA1U5WRSQfoNGUZ2o0YG6f17NU', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWjZ5Q3NpbnpKUkJoNlFmdzBVYVJXOTBvZnpNeHRab1ZuUkRwYm9adyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvcHJvamVjdHMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1758900496);
INSERT INTO public.sessions VALUES ('FvG3QB6CddiPePe1PcKFItUeBwO7zgrixdjW8mtm', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiOWNydXlxd0hBS0JFTTlSdmhaUnBETlNqTGpjY0pOWG9VRmFEZzdlVCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6OTI6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvcHJvamVjdC9vYmplY3RpdmVzP3Byb2plY3RfaWQ9OTBmZTZjOTYtOGRmMy00ZDQzLTllNWItMTFlNjE1YmUyZDJhIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1758900548);
INSERT INTO public.sessions VALUES ('PbyVOwBxnyyRLIEDMNXixewZRwM7V1hYad8VM4V0', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiV2xVNTVad3h1bWhTcGpBR05NRWlsblNxQWFJWEVDem5Zb3FEaDhYQiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6OTA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvZG9jdW1lbnRzL3B1YmxpYz9wcm9qZWN0X2lkPTkwZmU2Yzk2LThkZjMtNGQ0My05ZTViLTExZTYxNWJlMmQyYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1758901668);
INSERT INTO public.sessions VALUES ('enbwxmaAj6ZetOq0VTNc12gYvIXlDSWyoB7zxpse', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVWUwajlCRWEwMXZ6aXp5SVpqVzg2a0FxazZpQVB5MVdwNmlMbHRVdiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvbG9jYWxlcyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1758894604);
INSERT INTO public.sessions VALUES ('geCY5PiZ12WAleHx5xcW68Nvqa3sfcX7ulSGgeYi', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZ2ZTbzhuaXRjNkltMWhuTFowZW5FQkxPdnpzY3QzazZwWmRjcXBLRSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvcHJvamVjdHMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1758900421);
INSERT INTO public.sessions VALUES ('MPA6XRFBAFrFRRC8ppihRhmvLJNKeqCbDKv69f7X', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiOTJMTGp0NENlWEMwYmgwUHcxeHNSRE5DaHkzYzhDWmxQT05BdENFVCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzk6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvb3JnYW5pemF0aW9ucyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1758900497);
INSERT INTO public.sessions VALUES ('AIomw62TTQq1ukbrwiTaSKE0uJG6x7bKLfi57xVh', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNTdaNGZMZlB2dmtKZExrNHBGYlJKVnVwaTlmTDJaUTNrY0NlRzJ5WSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6ODk6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvcHJvamVjdC9yZXN1bHRzP3Byb2plY3RfaWQ9OTBmZTZjOTYtOGRmMy00ZDQzLTllNWItMTFlNjE1YmUyZDJhIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1758900548);
INSERT INTO public.sessions VALUES ('MwfCrC7YiifkL1NlM2TKyFYAuAJ85V6LULGex3ZF', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YToyOntzOjY6Il90b2tlbiI7czo0MDoiS2t3UDRmcnlNR3B4T0s4OHVOUTdzb1B0bzNUMzFwejVqVm9pQjVZeCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1759129192);
INSERT INTO public.sessions VALUES ('6AjMdBm9sanJwR7PyVHIw667gwjS98Y345IJvaO8', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiaFp3VVVYSHVrRXgxajRMYXVSbXZBZTJLaWV4OUNud0JyRjVsMWR2NyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvcHJvamVjdHMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1758900403);
INSERT INTO public.sessions VALUES ('WmERdhckgIJJWFrpONXmvx4ve5buJtIsTLW7nOcy', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoid3dGb2x3cGZqb21yZXVkU3BxUzNJUVFlbUhic2JMVWt6bG5oWHgyUiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzk6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvb3JnYW5pemF0aW9ucyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1758900422);
INSERT INTO public.sessions VALUES ('btUuA7lLQOisjfrFxQ5XS7R71xKE4Of54U7Tmedb', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUDFQRDNZZzVuNkVMdHBpVW1WcWZlOWFveWpVR1VlVlFFQnM5V2w3ZyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvdGhlbWF0aWNzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1758900497);
INSERT INTO public.sessions VALUES ('j763QhykVphkVtgsfJK7LgXsTISiE5n7Wz1uf2ri', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQ0FmY1pNejJ5N00zbEZuV0xwQTQ5ZE1MZUFZNzB6OUk4OVhLbmxZNCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6OTE6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvcHJvamVjdC90aGVtYXRpY3M/cHJvamVjdF9pZD05MGZlNmM5Ni04ZGYzLTRkNDMtOWU1Yi0xMWU2MTViZTJkMmEiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1758900549);
INSERT INTO public.sessions VALUES ('oAAFGgoB5d1RgrfNodXv6s94NTjBH7qTTO17O2cF', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVE9Oa0JQYTI1eXM1eERRWTZYbkFTeEd2U0h6aTF2elc2MnNwMFpTZyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvbG9jYWxlcyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1759137414);
INSERT INTO public.sessions VALUES ('1fkQgK0Kda1oyMLGzyo3ABaraHyr4bhmb2wsFwbq', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoia0c4QTF0Q285WHhnUk5aNWxNWU9hcHFOM0NObEU0V25PUDZUaUR0ZyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzk6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvb3JnYW5pemF0aW9ucyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1758900404);
INSERT INTO public.sessions VALUES ('dQvUs8ggwL4Az0WrkAaduwtMQ0m49BxTnw1cQBbh', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiYmRuaklpbGd6eXFhWGtzdmJDWFhSclhLOXpWS2FwRmZ1R1BUSklMRiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvdGhlbWF0aWNzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1758900422);
INSERT INTO public.sessions VALUES ('SIjru4TBx1wtQOxvffHbnRQVXD0Re8Y2kA3T6OVV', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoieEl3YmhqanpIa1V0VHYxTlpYcVk4YjFlQ3VSeGpqRVR5U01yQndBdyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NzA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvcHJvamVjdC8xY2JjZDgyYi1mMjNmLTQ0OGUtYjdiYi1hNWJlYjdjZWQyNmYiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1758900501);
INSERT INTO public.sessions VALUES ('q8Q6CytZZy7NPo1DUEXqglQeXgJjPr6mM3xlQTij', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZ0J1Z2o2ZlppN3BYeXU4aXRTc1p6cmltZFdudzRvRUh6MFF0NjVEZiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6OTA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvZG9jdW1lbnRzL3B1YmxpYz9wcm9qZWN0X2lkPTkwZmU2Yzk2LThkZjMtNGQ0My05ZTViLTExZTYxNWJlMmQyYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1758900549);
INSERT INTO public.sessions VALUES ('3748JVDRxcX4RGgdIe8NfdLeUeFAc9uLa6FS3oyv', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoia2xHWXgzOUlsY3V4WGNqWWVNRHh1YVJWeEhXa3lnU1VoSjEyd0ZYbCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvbG9jYWxlcyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1759156584);
INSERT INTO public.sessions VALUES ('qKiZQd4XXe2JwC5IanRKuuYILqtlSjqDsi0BwbMH', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoieGRUOUFUNHNFZFZHWHd1QlJGUno0dlNTc0YxUkk1MDRMdzQ1VHJ2SiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvdGhlbWF0aWNzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1758900405);
INSERT INTO public.sessions VALUES ('gP2TVyxS5gG5Ks7WijlRAqrmN5rE5KknJAtvwNLD', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicjFPNzExcWhuZlFzMTZaSDdWSnp5SEtoTDA2Rm9RTEZpM0FMNEJLOCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvcHJvamVjdHMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1758900425);
INSERT INTO public.sessions VALUES ('PXzKFfKaiiZ8Z2jJ8RwjRZPRg2G4ll372YPUzzWO', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiazdqaEVlaEZtVXdxejZxcTlLU3l6SkxMVmJHOFAwcXhENWNnOTJzQiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6OTI6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvcHJvamVjdC9vYmplY3RpdmVzP3Byb2plY3RfaWQ9MWNiY2Q4MmItZjIzZi00NDhlLWI3YmItYTViZWI3Y2VkMjZmIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1758900502);
INSERT INTO public.sessions VALUES ('vNRA5kUVbbq7DeUP4Md7A06xqXKrAn6R4nBwnv0r', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YToyOntzOjY6Il90b2tlbiI7czo0MDoiNzlqMGRTTFptNmJxVW9ab3d6YlVjUlJDQ29pRlM4V0xlRGpLV000eiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1758901395);
INSERT INTO public.sessions VALUES ('YYoS4x5vV4anvWqBuldRT8b2l6IGi05ArwSPijQa', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZXRTSnRuR2hCSWRZanlhblA1UmRZYXhaZTVoNVIyRmx2OXRRNEZORSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvbG9jYWxlcyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1759169786);
INSERT INTO public.sessions VALUES ('2k6sepsjNROyNEgKMsTscV58KKXdKGm0N4CgWD8H', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZWZlVzk1bUE5ODlXVExsV0JITjZzTUZZOTFESmpxTkZUdHllVXl6OSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvbG9jYWxlcyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1758784968);
INSERT INTO public.sessions VALUES ('eyNbV2TowcYSQv5ERTCp8fmniT55KvlOUYT3NGNZ', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoieHlwZ2I3RmdlME00MWJmdzVZUzI4SFpUYTNrNmhDUXJoZ0oyT1VxTyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NzA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvcHJvamVjdC9hZWI1OGQ5Mi1lNDgzLTQ5MzYtOWZkNy02ZjliMmM2Yjc3MzAiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1758900410);
INSERT INTO public.sessions VALUES ('oO9TEEPNkX6sz1Cfp9QlXm7AghNAOhfXyxb6UTK9', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicFNZTzRRdU14ejdrU2lFWXU2UERNNEJaVzdKWmFRVk5GNldieE9vMyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzk6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvb3JnYW5pemF0aW9ucyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1758900425);
INSERT INTO public.sessions VALUES ('2TqW346xYIwNQQ1he3nK3vJrgMii2BPI5EECxDtv', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUXdkYTMwcGc0eEFiVkJXWm5Rc09nMGxmeXdsZXhyYzFFVW93dkFwNCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6ODk6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvcHJvamVjdC9yZXN1bHRzP3Byb2plY3RfaWQ9MWNiY2Q4MmItZjIzZi00NDhlLWI3YmItYTViZWI3Y2VkMjZmIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1758900502);
INSERT INTO public.sessions VALUES ('U6vKmo7oKlhTeouE8Hu6LAAcZM1gaCB00hETm5Oy', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibUl2bEZPSTAxOEE5TkxVN05iU1pVcTNPWW81SE5sOG1tSHlmOFMzayI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvcHJvamVjdHMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1758901402);
INSERT INTO public.sessions VALUES ('tdE5RsEfNe3ioePMGVEOyN9mcIxwZRTyBgXWIuQe', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMGNyWmkwS2dCdTB3cmFZeml0Y0M1MVZrdlM5dXMzbzJoY2tZTmJnOSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvbG9jYWxlcyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1759177348);
INSERT INTO public.sessions VALUES ('IOjqDb0OUymMhGSlXFdjumtVbsw15LRSf5GlSV6k', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZ2R2VVl1V2oxY0VFSlRtVFdZWnpYVnFGUmFTUlI0czJXc3dMTzh5QSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvbG9jYWxlcyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1758784970);
INSERT INTO public.sessions VALUES ('IBFfjUyg4HanyLmhrQnobhvJmhs8hPOEzEodUpGJ', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoid1BYVmdOcDhEamdLTG1XdUFXaWloWHUxeGRwS0pIV09zRk1sYnN4SCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6OTI6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvcHJvamVjdC9vYmplY3RpdmVzP3Byb2plY3RfaWQ9YWViNThkOTItZTQ4My00OTM2LTlmZDctNmY5YjJjNmI3NzMwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1758900412);
INSERT INTO public.sessions VALUES ('ifpVAzNt1DhPJ85iA50vH8ULCUKroFkw2lJDNmat', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoidnFEQ0l5VWlHYVJxRXd1MW9Db1dCeTJmVEJkV2htcnNqWmtBaXVUeiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvdGhlbWF0aWNzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1758900426);
INSERT INTO public.sessions VALUES ('eGQUW61k5zWglNdjy5YbM0e1Py5UGpHFsGeGWKwy', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUnpwNUdWNk45Rk5scXBZeUY5cXB6ZlR5dGI0UUoxTThTZXZQSlZFdSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6OTE6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvcHJvamVjdC90aGVtYXRpY3M/cHJvamVjdF9pZD0xY2JjZDgyYi1mMjNmLTQ0OGUtYjdiYi1hNWJlYjdjZWQyNmYiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1758900503);
INSERT INTO public.sessions VALUES ('GMn0tfXvmaUuoDePVPxI7RLg1FCKqweD2z1eiowy', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoidDhJd21tZGxTN2gwd2Z3UWc5bUdrVHhSMkRkSUdoaWx6R1luQ0N3aCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzk6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvb3JnYW5pemF0aW9ucyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1758901403);
INSERT INTO public.sessions VALUES ('GaKsmHPrSBVsd9Lo696Ie6TUqsFBE3RT1XmYdg1T', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YToyOntzOjY6Il90b2tlbiI7czo0MDoiZ3NxR2dLajRuYlhBSnRkVDVjakx1Wk1mSWl2R0w3YmNlZTRyd3dZViI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1759215414);
INSERT INTO public.sessions VALUES ('ij5ETwnOU4FMqQiYhz3BwIcYzTZMSZqJiJlCXfz3', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoidERTRmRMZlh3dXRqR3dFUE8zUmpqMFdYcjdyYlpsdHRnZXl2THdIWSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvbG9jYWxlcyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1758787519);
INSERT INTO public.sessions VALUES ('AoVRtOyJas3HYPK5Qu5XzpEvY2OtYdkCIwwDROxT', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiR2x2dXBrZ2lwb0ZVQ3JqYTJ6UDFEdHB6ZUFqNHZyS0JndXFHMXNBTyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6ODk6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvcHJvamVjdC9yZXN1bHRzP3Byb2plY3RfaWQ9YWViNThkOTItZTQ4My00OTM2LTlmZDctNmY5YjJjNmI3NzMwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1758900413);
INSERT INTO public.sessions VALUES ('96guYgcpfKtKuYrFSz1oKHoz2YeAgwIq80ei9q3Y', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibWRZbWJpNVZpSXo5SFVVa1ZJamllTHVkZGtrU1g2NWRteHBoUFBrZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NzA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvcHJvamVjdC9hZWI1OGQ5Mi1lNDgzLTQ5MzYtOWZkNy02ZjliMmM2Yjc3MzAiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1758900431);
INSERT INTO public.sessions VALUES ('85Ul1CxuGHhVAODcauwLzCGvXkZEh70GgEqyD5xV', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicnNQb2pYSEV3RncxUkJLeXB3dG1Xc2FPWUNkaXpOU1dWYmJ6aVB2RCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6OTA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvZG9jdW1lbnRzL3B1YmxpYz9wcm9qZWN0X2lkPTFjYmNkODJiLWYyM2YtNDQ4ZS1iN2JiLWE1YmViN2NlZDI2ZiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1758900503);
INSERT INTO public.sessions VALUES ('5BZlhUNDXoGNkqfP30VMHsdOr0i5cTW1hgg6QAkF', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiemQwS09ad1hxMjJPZ2V5VGx0bEpISjdQT3d6YXNGQ2hXYkN0MHVuUiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvdGhlbWF0aWNzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1758901403);
INSERT INTO public.sessions VALUES ('9r5eGpED1pnIoXznRWwHbYMNpI12dNXSavBCebl6', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiaVlqelhEZUs3MDFldmU1S2RiVzJONDZEam9NaExDS3VWa3l1WUNGSyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvbG9jYWxlcyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1759215416);
INSERT INTO public.sessions VALUES ('4u4XCXPSsqMqrn7e64VmaLQ1sccCvvg2YPZYiA5v', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiaG9UdE1sdjJZeXF5T1ZvMkkyZ3lZbzh2TXI4aVdtMFlUeDZHaERIayI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvbG9jYWxlcyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1758787621);
INSERT INTO public.sessions VALUES ('5hDuTZrq9dbRqUryQ4tCoWBjKVl3HUuUoBLS8Ut7', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicVhRWjhTVU5RejMwc0E1bkdYRTJXbk1LNkVxME1vaXluNGd1eVdPdyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6OTE6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvcHJvamVjdC90aGVtYXRpY3M/cHJvamVjdF9pZD1hZWI1OGQ5Mi1lNDgzLTQ5MzYtOWZkNy02ZjliMmM2Yjc3MzAiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1758900413);
INSERT INTO public.sessions VALUES ('2foqSkiCaYuYCdhgK8R5fv5K6OqIsrWpFvlLA6LI', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiOVBSbjJ6VUJkRGYwamZRN0hYZFRudE55cjZpekRDNE5pMVMzcFFjaSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6OTI6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvcHJvamVjdC9vYmplY3RpdmVzP3Byb2plY3RfaWQ9YWViNThkOTItZTQ4My00OTM2LTlmZDctNmY5YjJjNmI3NzMwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1758900431);
INSERT INTO public.sessions VALUES ('f8g210hQMdYvKmeWvT7loPDzUD7C4ZunN0N6Bfyu', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWVUzTndkbERqanJmOURKSjdmejU5VXBDYmQxdTI1NWRYZmFEMnZpZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvcHJvamVjdHMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1758900542);
INSERT INTO public.sessions VALUES ('fTyK0gDvzlWIqIM24wALZECd88gZZbsfN9RSulNX', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQ2pQeVY3c3Z2RkoxOTV3c1VsSXJwUzZPM0dsYzRrbmVZWENTTXBvdSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NzA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvcHJvamVjdC85MGZlNmM5Ni04ZGYzLTRkNDMtOWU1Yi0xMWU2MTViZTJkMmEiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1758901665);
INSERT INTO public.sessions VALUES ('vQrks5lEwM1DM7BffiB22uNi1Ot1bGkGCqCXzJ16', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiN0JGaE5EY2dyczdoYXdmZUpmcTVsR1VWeEp2MzdyTkV6dnpJR0N3eSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hcGkvbG9jYWxlcyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1758787650);


--
-- TOC entry 6094 (class 0 OID 20974)
-- Dependencies: 262
-- Data for Name: tridom; Type: TABLE DATA; Schema: spatial; Owner: postgres
--

INSERT INTO spatial.tridom VALUES (1, 2549729.84885000018, 'Dja-Odzala-Minkébé Tri-National (Tridom)', 17779411.5337000004, 179162311757.000000, 2559785.20893999981, 'TRIDOM', '[encoded data, 299668 characters]');


--
-- TOC entry 6090 (class 0 OID 19635)
-- Dependencies: 253
-- Data for Name: documents; Type: TABLE DATA; Schema: tabular; Owner: postgres
--

INSERT INTO tabular.documents VALUES ('cc86b1d9-585c-4e09-819b-8d218578243d', 'TDR de la Réunion avec les acteurs du paysage TRIDOM Cameroun', 'application/pdf', 'Cette réunion avait pour objectif de définir les clauses de partage de données entre le WWF et les  institutions/organisations contributrices après un examen critique des intérêts communs.', 690950, '2024-06-13 00:00:00', 'CIBEL TRIDOM', '2024', 'documents/e054e854-946d-4780-8e61-593d03c8c3e7.pdf', 'aeb58d92-e483-4936-9fd7-6f9b2c6b7730', '4ca1db3f-9e82-483a-b5eb-5507c9147ccf', '883112a8-fed4-4c25-8e8d-e4e77ed46e59', '2025-07-04 10:58:40', '2025-07-04 14:54:16');
INSERT INTO tabular.documents VALUES ('d6ed5bb8-4563-4330-9a20-37b0d164f689', 'TDR de la Réunion avec les acteurs du paysage TRIDOM au Gabon', 'application/pdf', 'Cette réunion avait pour objectif de définir les clauses de partage de données entre le WWF et les  institutions/organisations contributrices après un examen critique des intérêts communs.', 737911, '2024-05-10 00:00:00', 'CIBEL TRIDOM', '2024', 'documents/4f6a6d9b-ae9c-445c-8faa-66728fcd254b.pdf', 'aeb58d92-e483-4936-9fd7-6f9b2c6b7730', '4ca1db3f-9e82-483a-b5eb-5507c9147ccf', '5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf', '2025-07-04 11:13:59', '2025-07-04 11:13:59');
INSERT INTO tabular.documents VALUES ('926af510-ba20-424d-9f47-35457bac82ad', 'TDR de la Réunion avec les acteurs du paysage TRIDOM au Congo (CG)', 'application/pdf', 'Cette réunion avait pour objectif de définir les clauses de partage de données entre le WWF et les  institutions/organisations contributrices après un examen critique des intérêts communs.', 726362, '2024-05-30 00:00:00', 'CIBEL TRIDOM', '2024', 'documents/ab439149-8df0-4fd8-8464-9ce0c533c5d1.pdf', 'aeb58d92-e483-4936-9fd7-6f9b2c6b7730', '4ca1db3f-9e82-483a-b5eb-5507c9147ccf', '5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf', '2025-07-04 11:11:47', '2025-07-18 15:15:43');


--
-- TOC entry 6075 (class 0 OID 19213)
-- Dependencies: 238
-- Data for Name: organizations; Type: TABLE DATA; Schema: tabular; Owner: postgres
--

INSERT INTO tabular.organizations VALUES ('645620c2-b9aa-41ca-87c2-dc4a1e8efbe9', 'TRAFFIC', 'Organization description', 'logos/beee2062-8848-44c5-b1f6-5c2f5221f26e.png', '2025-06-26 12:08:44', '2025-06-26 12:08:44');
INSERT INTO tabular.organizations VALUES ('84f264dc-9cc4-494e-8a44-5571a341cb08', 'GIZ', 'GIZ', 'logos/8dca418d-a5cc-424a-8216-ac3677ae9d2f.png', '2025-06-26 19:57:49', '2025-06-26 19:57:49');
INSERT INTO tabular.organizations VALUES ('bef8e6d5-90cd-4eda-9341-d55a40b6a6f4', 'OFAC', 'OFAC', 'logos/b041d4d0-e550-4df0-a906-069637842deb.png', '2025-06-26 19:58:01', '2025-06-26 19:58:01');
INSERT INTO tabular.organizations VALUES ('c9a8a346-2f42-4d85-81bf-c1608d318419', 'Conservation Justice', 'Conservation Justice', 'logos/a178c5f5-c025-465d-961f-d8d56c2794f3.png', '2025-06-26 19:59:25', '2025-06-26 19:59:25');
INSERT INTO tabular.organizations VALUES ('ecb030c5-2b1c-4b48-afcc-e9b73ef832be', 'ZSL', 'ZSL', 'logos/2aebbc44-1809-4a95-8aa4-8342866d3854.png', '2025-06-26 19:57:13', '2025-06-26 19:57:13');
INSERT INTO tabular.organizations VALUES ('335db174-a66a-4b46-aa86-ab79745d04c9', 'WWF', 'TEST DESCRIPTION', 'logos/335db174-a66a-4b46-aa86-ab79745d04c9.jpg', NULL, NULL);


--
-- TOC entry 6082 (class 0 OID 19485)
-- Dependencies: 245
-- Data for Name: project_objectives; Type: TABLE DATA; Schema: tabular; Owner: postgres
--

INSERT INTO tabular.project_objectives VALUES ('0eb2532a-bedb-497e-8397-268f10b77636', 'Suivre et Evaluation des impact du Projet (Protocoles, Suivi, Analyses et Evaluation)', 'aeb58d92-e483-4936-9fd7-6f9b2c6b7730', '2025-06-26 17:31:38', '2025-06-26 17:31:38');
INSERT INTO tabular.project_objectives VALUES ('5a2f010c-b572-474c-98fd-d9e3b50b66dc', 'Suivre de la qualité de mise en œuvre (Analyses, Contrôle et Orientations Adaptatives)', 'aeb58d92-e483-4936-9fd7-6f9b2c6b7730', '2025-06-26 17:33:53', '2025-06-26 17:33:53');
INSERT INTO tabular.project_objectives VALUES ('2682e93e-2712-429e-bfe2-555538e56f75', 'Développer de plateforme Web (Compilation de données, Production de Résultats stratégiques, Création d’un Tableau de bord)', 'aeb58d92-e483-4936-9fd7-6f9b2c6b7730', '2025-06-26 17:34:30', '2025-06-26 17:34:30');


--
-- TOC entry 6081 (class 0 OID 19472)
-- Dependencies: 244
-- Data for Name: project_results; Type: TABLE DATA; Schema: tabular; Owner: postgres
--



--
-- TOC entry 6089 (class 0 OID 19585)
-- Dependencies: 252
-- Data for Name: project_thematics; Type: TABLE DATA; Schema: tabular; Owner: postgres
--

INSERT INTO tabular.project_thematics VALUES ('0bda7708-80df-4fee-8e71-777add3d08b3', '06b5188c-445b-46b1-a443-be4bfb67b899', '["d3b299a4-2544-4eba-a433-cf110edcda81","e7b3e927-a8b0-4e74-a557-292d57dccc98"]', '["0fb251de-3206-446d-a58b-7cb2cc6f4da9","23427270-a3c8-4dce-aef9-9ad6ca82f06a"]', 'aeb58d92-e483-4936-9fd7-6f9b2c6b7730', '10a62626-2c45-41c1-8c79-563dd7488b32', '2025-06-27 14:42:42', '2025-06-27 14:42:42');
INSERT INTO tabular.project_thematics VALUES ('0557ff8d-d6c5-4ca5-ad82-5bea5f32872f', '06b5188c-445b-46b1-a443-be4bfb67b899', '["d3b299a4-2544-4eba-a433-cf110edcda81","e7b3e927-a8b0-4e74-a557-292d57dccc98"]', '["0fb251de-3206-446d-a58b-7cb2cc6f4da9","23427270-a3c8-4dce-aef9-9ad6ca82f06a"]', 'aeb58d92-e483-4936-9fd7-6f9b2c6b7730', '6969efaf-e99b-43f3-9da1-c03c1bb331ca', '2025-06-27 14:46:39', '2025-06-27 14:46:39');
INSERT INTO tabular.project_thematics VALUES ('c4529469-76ec-4c69-80a4-75cf37269e08', '06b5188c-445b-46b1-a443-be4bfb67b899', '["d3b299a4-2544-4eba-a433-cf110edcda81","e7b3e927-a8b0-4e74-a557-292d57dccc98"]', '["23427270-a3c8-4dce-aef9-9ad6ca82f06a"]', 'aeb58d92-e483-4936-9fd7-6f9b2c6b7730', 'fb508fd1-da18-4c8d-94fa-010b5b15b7ac', '2025-07-08 10:58:08', '2025-07-08 10:58:08');


--
-- TOC entry 6080 (class 0 OID 19442)
-- Dependencies: 243
-- Data for Name: projects; Type: TABLE DATA; Schema: tabular; Owner: postgres
--

INSERT INTO tabular.projects VALUES ('90fe6c96-8df3-4d43-9e5b-11e615be2d2a', 'NIAP (National Ivory Action Plan)', 'Yaoundé', '079fad94-17ca-4812-9cac-83d77855ae9c', '2022-07-01 00:00:00', '2024-06-30 00:00:00', 104000, '8f52a997-59c9-488b-b2cd-7c8dfa301bb4', '645620c2-b9aa-41ca-87c2-dc4a1e8efbe9', '4ca1db3f-9e82-483a-b5eb-5507c9147ccf', NULL, 'SONE NKOKE', NULL, '+237699731856', 'DALIDA IKOUM', 'dalida.ikoum@traffic.org', NULL, NULL, '2025-06-26 20:12:26', '2025-06-26 20:12:26', NULL, NULL);
INSERT INTO tabular.projects VALUES ('1cbcd82b-f23f-448e-b7bb-a5beb7ced26f', 'Achieving An Integrated Agribusiness-Conservation Agreement For Deforestation Free Palm Oil Or Cacao Production In Tridom Landscape Int/Practices Innovation Funds.', 'Yaoundé', '079fad94-17ca-4812-9cac-83d77855ae9c', '2019-05-01 00:00:00', '2020-04-30 00:00:00', NULL, NULL, '335db174-a66a-4b46-aa86-ab79745d04c9', '4ca1db3f-9e82-483a-b5eb-5507c9147ccf', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-07-15 16:13:52', '2025-07-15 16:13:52', NULL, NULL);
INSERT INTO tabular.projects VALUES ('aeb58d92-e483-4936-9fd7-6f9b2c6b7730', 'TRIDOM CIBEL', 'Yaoundé', '079fad94-17ca-4812-9cac-83d77855ae9c', '2023-07-01 00:00:00', '2027-06-30 00:00:00', 500000, '8f52a997-59c9-488b-b2cd-7c8dfa301bb4', '335db174-a66a-4b46-aa86-ab79745d04c9', '4ca1db3f-9e82-483a-b5eb-5507c9147ccf', 'https://wwf-congobasin-monitoring.org/', 'Paul N''Goran', 'pngoran@wwfcam.org', NULL, 'Christian NGANWA', 'cnganwa@wwfcam.org', NULL, NULL, '2025-06-26 17:09:50', '2025-07-02 08:52:48', 'logos/9b20d3c9-304e-4c6f-9459-7f64d60ac38a.jpg', 'WWF, 2023');


--
-- TOC entry 6074 (class 0 OID 19091)
-- Dependencies: 237
-- Data for Name: thematics; Type: TABLE DATA; Schema: tabular; Owner: postgres
--

INSERT INTO tabular.thematics VALUES ('06abef34-cf0d-45f6-80f1-7200150573e1', 'Accords', '2025-06-27 07:33:33', '2025-06-27 07:33:33', NULL, NULL, NULL, '00466f04-9471-43fc-a3ee-63db5e4ba2d0');
INSERT INTO tabular.thematics VALUES ('10a62626-2c45-41c1-8c79-563dd7488b32', 'Agriculture durable', '2025-06-27 07:38:03', '2025-06-27 07:38:03', NULL, NULL, NULL, '00466f04-9471-43fc-a3ee-63db5e4ba2d0');
INSERT INTO tabular.thematics VALUES ('1d1369bd-c387-4215-84ad-dacb474855e5', 'Aires protégées', '2025-06-27 07:38:21', '2025-06-27 07:38:21', NULL, NULL, NULL, '00466f04-9471-43fc-a3ee-63db5e4ba2d0');
INSERT INTO tabular.thematics VALUES ('2d19a548-1de0-4829-a275-fc2b73711e94', 'Bien-être des communautés', '2025-06-27 07:38:31', '2025-06-27 07:38:31', NULL, NULL, NULL, 'c70981f9-44d7-48d3-ba6c-12623105aeae');
INSERT INTO tabular.thematics VALUES ('6969efaf-e99b-43f3-9da1-c03c1bb331ca', 'Changements climatiques', '2025-06-27 07:37:47', '2025-06-27 07:37:47', NULL, NULL, NULL, 'c70981f9-44d7-48d3-ba6c-12623105aeae');
INSERT INTO tabular.thematics VALUES ('7fb7fadf-4c83-4771-9b17-db839a147dc5', 'Conflits homme-faune', '2025-06-27 07:38:40', '2025-06-27 07:38:40', NULL, NULL, NULL, '00466f04-9471-43fc-a3ee-63db5e4ba2d0');
INSERT INTO tabular.thematics VALUES ('852c33dc-a69f-44dd-b570-96ffebc710f9', 'Conservation inclusive', '2025-06-27 07:38:52', '2025-06-27 07:38:52', NULL, NULL, NULL, '00466f04-9471-43fc-a3ee-63db5e4ba2d0');
INSERT INTO tabular.thematics VALUES ('9cd5ae78-56dc-433a-9b9c-5930fe969dfc', 'Criminalité faunique', '2025-06-27 07:37:32', '2025-06-27 07:37:32', NULL, NULL, NULL, '00466f04-9471-43fc-a3ee-63db5e4ba2d0');
INSERT INTO tabular.thematics VALUES ('e93c1ccf-e21b-4b9e-a92f-4eb6a5b22d08', 'Cross-cutting', '2025-06-27 07:37:56', '2025-06-27 07:37:56', NULL, NULL, NULL, 'c70981f9-44d7-48d3-ba6c-12623105aeae');
INSERT INTO tabular.thematics VALUES ('fb508fd1-da18-4c8d-94fa-010b5b15b7ac', 'Financement de la conservation', '2025-06-27 07:37:39', '2025-06-27 07:37:39', NULL, NULL, NULL, '8cc0cd04-3bef-416d-8a01-7698cbd61f11');
INSERT INTO tabular.thematics VALUES ('85406479-ed53-4343-9dec-233e64abdcfb', 'Gouvernance', '2025-09-17 13:06:34', '2025-09-17 13:06:34', NULL, NULL, NULL, NULL);
INSERT INTO tabular.thematics VALUES ('5da21baa-bb36-4577-99d4-eb590e098876', 'Zones clés de biodiversité', '2025-09-17 13:06:52', '2025-09-17 13:06:52', NULL, NULL, NULL, NULL);
INSERT INTO tabular.thematics VALUES ('3d03a396-d812-4365-9bf9-829b2342ac5a', 'Législation et application de la loi', '2025-09-17 13:07:06', '2025-09-17 13:07:06', NULL, NULL, NULL, NULL);
INSERT INTO tabular.thematics VALUES ('9c8d34b8-3007-46de-ab4a-390df055fb30', 'Planification et utilisation des terres', '2025-09-17 13:07:22', '2025-09-17 13:07:22', NULL, NULL, NULL, NULL);
INSERT INTO tabular.thematics VALUES ('52839992-8e10-4217-a751-bf449d6dd92d', 'Protection de la biodiversité', '2025-09-17 13:07:34', '2025-09-17 13:07:34', NULL, NULL, NULL, NULL);
INSERT INTO tabular.thematics VALUES ('9b32a11f-496c-483a-8bd1-c56449f350cd', 'Protection des écosystèmes', '2025-09-17 13:07:47', '2025-09-17 13:07:47', NULL, NULL, NULL, NULL);
INSERT INTO tabular.thematics VALUES ('63a54e33-2845-4b79-b7b0-c2fad7c95fd4', 'Recherche et suivi écologique', '2025-09-17 13:09:14', '2025-09-17 13:09:14', NULL, NULL, NULL, NULL);
INSERT INTO tabular.thematics VALUES ('3fe09f8f-df5e-42f7-b684-c78e3b1e4ade', 'Renforcement des capacités', '2025-09-17 13:09:24', '2025-09-17 13:09:24', NULL, NULL, NULL, NULL);
INSERT INTO tabular.thematics VALUES ('e71b0911-d159-4174-aae5-95f8ad340663', 'Restauration des écosystèmes', '2025-09-17 13:13:55', '2025-09-17 13:13:55', NULL, NULL, NULL, NULL);
INSERT INTO tabular.thematics VALUES ('4850b344-6889-485b-91ff-3c199b6367b3', 'Sauvegarde environnementale et sociale', '2025-09-17 13:14:05', '2025-09-17 13:14:05', NULL, NULL, NULL, NULL);
INSERT INTO tabular.thematics VALUES ('9e219aed-90c9-44f3-ae53-b7cc59ad3bad', 'Suivi socio-économique', '2025-09-17 13:14:39', '2025-09-17 13:14:39', NULL, NULL, NULL, NULL);
INSERT INTO tabular.thematics VALUES ('f5178792-f610-4f7f-b14c-d6a5a507649c', 'Suivi-écologique et recherche', '2025-09-17 13:14:59', '2025-09-17 13:14:59', NULL, NULL, NULL, NULL);
INSERT INTO tabular.thematics VALUES ('593f821a-5dca-47a4-a94c-b11dc2cc3e5b', 'Systèmes d''information', '2025-09-17 13:15:09', '2025-09-17 13:15:09', NULL, NULL, NULL, NULL);


--
-- TOC entry 5873 (class 2606 OID 19545)
-- Name: collection_methods codelist_collection_methods_name_unique; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

ALTER TABLE ONLY codelist.collection_methods
    ADD CONSTRAINT codelist_collection_methods_name_unique UNIQUE (name);


--
-- TOC entry 5823 (class 2606 OID 19019)
-- Name: currency codelist_currency_name_unique; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

ALTER TABLE ONLY codelist.currency
    ADD CONSTRAINT codelist_currency_name_unique UNIQUE (name);


--
-- TOC entry 5865 (class 2606 OID 19527)
-- Name: data_formats codelist_data_formats_name_unique; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

ALTER TABLE ONLY codelist.data_formats
    ADD CONSTRAINT codelist_data_formats_name_unique UNIQUE (name);


--
-- TOC entry 5869 (class 2606 OID 19537)
-- Name: data_licences codelist_data_licences_name_unique; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

ALTER TABLE ONLY codelist.data_licences
    ADD CONSTRAINT codelist_data_licences_name_unique UNIQUE (name);


--
-- TOC entry 5819 (class 2606 OID 19011)
-- Name: project_locations codelist_project_locations_name_unique; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

ALTER TABLE ONLY codelist.project_locations
    ADD CONSTRAINT codelist_project_locations_name_unique UNIQUE (name);


--
-- TOC entry 5877 (class 2606 OID 19553)
-- Name: thematic_categories codelist_thematic_cathegories_name_unique; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

ALTER TABLE ONLY codelist.thematic_categories
    ADD CONSTRAINT codelist_thematic_cathegories_name_unique UNIQUE (name);


--
-- TOC entry 5815 (class 2606 OID 18828)
-- Name: user_roles codelist_user_roles_name_unique; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

ALTER TABLE ONLY codelist.user_roles
    ADD CONSTRAINT codelist_user_roles_name_unique UNIQUE (name);


--
-- TOC entry 5875 (class 2606 OID 19543)
-- Name: collection_methods collection_methods_pkey; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

ALTER TABLE ONLY codelist.collection_methods
    ADD CONSTRAINT collection_methods_pkey PRIMARY KEY (id);


--
-- TOC entry 5825 (class 2606 OID 19017)
-- Name: currency currency_pkey; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

ALTER TABLE ONLY codelist.currency
    ADD CONSTRAINT currency_pkey PRIMARY KEY (id);


--
-- TOC entry 5867 (class 2606 OID 19525)
-- Name: data_formats data_formats_pkey; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

ALTER TABLE ONLY codelist.data_formats
    ADD CONSTRAINT data_formats_pkey PRIMARY KEY (id);


--
-- TOC entry 5871 (class 2606 OID 19535)
-- Name: data_licences data_licences_pkey; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

ALTER TABLE ONLY codelist.data_licences
    ADD CONSTRAINT data_licences_pkey PRIMARY KEY (id);


--
-- TOC entry 5821 (class 2606 OID 19009)
-- Name: project_locations project_locations_pkey; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

ALTER TABLE ONLY codelist.project_locations
    ADD CONSTRAINT project_locations_pkey PRIMARY KEY (id);


--
-- TOC entry 5879 (class 2606 OID 19551)
-- Name: thematic_categories thematic_cathegories_pkey; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

ALTER TABLE ONLY codelist.thematic_categories
    ADD CONSTRAINT thematic_cathegories_pkey PRIMARY KEY (id);


--
-- TOC entry 5817 (class 2606 OID 18826)
-- Name: user_roles user_roles_pkey; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

ALTER TABLE ONLY codelist.user_roles
    ADD CONSTRAINT user_roles_pkey PRIMARY KEY (id);


--
-- TOC entry 5813 (class 2606 OID 18775)
-- Name: cache_locks cache_locks_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cache_locks
    ADD CONSTRAINT cache_locks_pkey PRIMARY KEY (key);


--
-- TOC entry 5811 (class 2606 OID 18768)
-- Name: cache cache_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cache
    ADD CONSTRAINT cache_pkey PRIMARY KEY (key);


--
-- TOC entry 5807 (class 2606 OID 18759)
-- Name: failed_jobs failed_jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.failed_jobs
    ADD CONSTRAINT failed_jobs_pkey PRIMARY KEY (id);


--
-- TOC entry 5809 (class 2606 OID 18761)
-- Name: failed_jobs failed_jobs_uuid_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.failed_jobs
    ADD CONSTRAINT failed_jobs_uuid_unique UNIQUE (uuid);


--
-- TOC entry 5805 (class 2606 OID 18749)
-- Name: job_batches job_batches_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.job_batches
    ADD CONSTRAINT job_batches_pkey PRIMARY KEY (id);


--
-- TOC entry 5802 (class 2606 OID 18741)
-- Name: jobs jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.jobs
    ADD CONSTRAINT jobs_pkey PRIMARY KEY (id);


--
-- TOC entry 5795 (class 2606 OID 17596)
-- Name: migrations migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.migrations
    ADD CONSTRAINT migrations_pkey PRIMARY KEY (id);


--
-- TOC entry 5841 (class 2606 OID 19432)
-- Name: password_reset_tokens password_reset_tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.password_reset_tokens
    ADD CONSTRAINT password_reset_tokens_pkey PRIMARY KEY (email);


--
-- TOC entry 5844 (class 2606 OID 19439)
-- Name: sessions sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sessions
    ADD CONSTRAINT sessions_pkey PRIMARY KEY (id);


--
-- TOC entry 5890 (class 2606 OID 20961)
-- Name: tridom_3857 tridom_3857_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tridom_3857
    ADD CONSTRAINT tridom_3857_pkey PRIMARY KEY (gid);


--
-- TOC entry 5893 (class 2606 OID 20981)
-- Name: tridom tridom_pkey; Type: CONSTRAINT; Schema: spatial; Owner: postgres
--

ALTER TABLE ONLY spatial.tridom
    ADD CONSTRAINT tridom_pkey PRIMARY KEY (id);


--
-- TOC entry 5883 (class 2606 OID 19657)
-- Name: documents documents_pkey; Type: CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.documents
    ADD CONSTRAINT documents_pkey PRIMARY KEY (id);


--
-- TOC entry 5831 (class 2606 OID 19220)
-- Name: organizations organizations_pkey; Type: CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.organizations
    ADD CONSTRAINT organizations_pkey PRIMARY KEY (id);


--
-- TOC entry 5855 (class 2606 OID 19495)
-- Name: project_objectives project_objectives_pkey; Type: CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.project_objectives
    ADD CONSTRAINT project_objectives_pkey PRIMARY KEY (id);


--
-- TOC entry 5851 (class 2606 OID 19482)
-- Name: project_results project_results_pkey; Type: CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.project_results
    ADD CONSTRAINT project_results_pkey PRIMARY KEY (id);


--
-- TOC entry 5881 (class 2606 OID 19607)
-- Name: project_thematics project_thematics_pkey; Type: CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.project_thematics
    ADD CONSTRAINT project_thematics_pkey PRIMARY KEY (id);


--
-- TOC entry 5847 (class 2606 OID 19469)
-- Name: projects projects_pkey; Type: CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.projects
    ADD CONSTRAINT projects_pkey PRIMARY KEY (id);


--
-- TOC entry 5885 (class 2606 OID 19659)
-- Name: documents tabular_documents_name_unique; Type: CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.documents
    ADD CONSTRAINT tabular_documents_name_unique UNIQUE (name);


--
-- TOC entry 5857 (class 2606 OID 19497)
-- Name: project_objectives tabular_project_objectives_name_unique; Type: CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.project_objectives
    ADD CONSTRAINT tabular_project_objectives_name_unique UNIQUE (name);


--
-- TOC entry 5853 (class 2606 OID 19484)
-- Name: project_results tabular_project_results_name_unique; Type: CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.project_results
    ADD CONSTRAINT tabular_project_results_name_unique UNIQUE (name);


--
-- TOC entry 5849 (class 2606 OID 19471)
-- Name: projects tabular_projects_name_unique; Type: CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.projects
    ADD CONSTRAINT tabular_projects_name_unique UNIQUE (name);


--
-- TOC entry 5827 (class 2606 OID 19098)
-- Name: thematics tabular_thematics_name_unique; Type: CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.thematics
    ADD CONSTRAINT tabular_thematics_name_unique UNIQUE (name);


--
-- TOC entry 5829 (class 2606 OID 19096)
-- Name: thematics thematics_pkey; Type: CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.thematics
    ADD CONSTRAINT thematics_pkey PRIMARY KEY (id);


--
-- TOC entry 5833 (class 2606 OID 19516)
-- Name: organizations unique_column_name; Type: CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.organizations
    ADD CONSTRAINT unique_column_name UNIQUE (name);


--
-- TOC entry 5803 (class 1259 OID 18742)
-- Name: jobs_queue_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX jobs_queue_index ON public.jobs USING btree (queue);


--
-- TOC entry 5842 (class 1259 OID 19441)
-- Name: sessions_last_activity_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX sessions_last_activity_index ON public.sessions USING btree (last_activity);


--
-- TOC entry 5845 (class 1259 OID 19440)
-- Name: sessions_user_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX sessions_user_id_index ON public.sessions USING btree (user_id);


--
-- TOC entry 5888 (class 1259 OID 20965)
-- Name: tridom_3857_geom_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX tridom_3857_geom_idx ON public.tridom_3857 USING gist (geom);


--
-- TOC entry 5891 (class 1259 OID 20984)
-- Name: tridom_geom_idx; Type: INDEX; Schema: spatial; Owner: postgres
--

CREATE INDEX tridom_geom_idx ON spatial.tridom USING gist (geom);


--
-- TOC entry 5907 (class 2606 OID 19641)
-- Name: documents tabular_documents_project_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.documents
    ADD CONSTRAINT tabular_documents_project_id_foreign FOREIGN KEY (project_id) REFERENCES tabular.projects(id) ON DELETE CASCADE;


--
-- TOC entry 5908 (class 2606 OID 19651)
-- Name: documents tabular_documents_role_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.documents
    ADD CONSTRAINT tabular_documents_role_id_foreign FOREIGN KEY (role_id) REFERENCES codelist.user_roles(id) ON DELETE CASCADE;


--
-- TOC entry 5909 (class 2606 OID 19646)
-- Name: documents tabular_documents_user_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.documents
    ADD CONSTRAINT tabular_documents_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(user_id) ON DELETE CASCADE;


--
-- TOC entry 5902 (class 2606 OID 19489)
-- Name: project_objectives tabular_project_objectives_project_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.project_objectives
    ADD CONSTRAINT tabular_project_objectives_project_id_foreign FOREIGN KEY (project_id) REFERENCES tabular.projects(id) ON DELETE CASCADE;


--
-- TOC entry 5901 (class 2606 OID 19476)
-- Name: project_results tabular_project_results_project_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.project_results
    ADD CONSTRAINT tabular_project_results_project_id_foreign FOREIGN KEY (project_id) REFERENCES tabular.projects(id) ON DELETE CASCADE;


--
-- TOC entry 5904 (class 2606 OID 19591)
-- Name: project_thematics tabular_project_thematics_data_licence_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.project_thematics
    ADD CONSTRAINT tabular_project_thematics_data_licence_id_foreign FOREIGN KEY (data_licence_id) REFERENCES codelist.data_licences(id) ON DELETE CASCADE;


--
-- TOC entry 5905 (class 2606 OID 19596)
-- Name: project_thematics tabular_project_thematics_project_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.project_thematics
    ADD CONSTRAINT tabular_project_thematics_project_id_foreign FOREIGN KEY (project_id) REFERENCES tabular.projects(id) ON DELETE CASCADE;


--
-- TOC entry 5906 (class 2606 OID 19601)
-- Name: project_thematics tabular_project_thematics_thematic_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.project_thematics
    ADD CONSTRAINT tabular_project_thematics_thematic_id_foreign FOREIGN KEY (thematic_id) REFERENCES tabular.thematics(id) ON DELETE CASCADE;


--
-- TOC entry 5897 (class 2606 OID 19453)
-- Name: projects tabular_projects_currency_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.projects
    ADD CONSTRAINT tabular_projects_currency_id_foreign FOREIGN KEY (currency_id) REFERENCES codelist.currency(id) ON DELETE CASCADE;


--
-- TOC entry 5898 (class 2606 OID 19448)
-- Name: projects tabular_projects_location_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.projects
    ADD CONSTRAINT tabular_projects_location_id_foreign FOREIGN KEY (location_id) REFERENCES codelist.project_locations(id) ON DELETE CASCADE;


--
-- TOC entry 5899 (class 2606 OID 19458)
-- Name: projects tabular_projects_organization_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.projects
    ADD CONSTRAINT tabular_projects_organization_id_foreign FOREIGN KEY (organization_id) REFERENCES tabular.organizations(id) ON DELETE CASCADE;


--
-- TOC entry 5900 (class 2606 OID 19463)
-- Name: projects tabular_projects_user_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.projects
    ADD CONSTRAINT tabular_projects_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(user_id) ON DELETE CASCADE;


--
-- TOC entry 5894 (class 2606 OID 19698)
-- Name: thematics tabular_thematics_codelist_thematic_categories_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.thematics
    ADD CONSTRAINT tabular_thematics_codelist_thematic_categories_id_foreign FOREIGN KEY (category_thematic_id) REFERENCES codelist.thematic_categories(id) ON DELETE CASCADE NOT VALID;


-- Completed on 2025-10-03 12:20:50

--
--

