--
--





--
-- Name: account_emailaddress; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.account_emailaddress (
    id integer NOT NULL,
    email character varying(254) NOT NULL,
    verified boolean NOT NULL,
    "primary" boolean NOT NULL,
    user_id integer NOT NULL
);


ALTER TABLE public.account_emailaddress OWNER TO wenani_springinfor;

--
-- Name: account_emailaddress_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.account_emailaddress ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.account_emailaddress_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: auth_group; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.auth_group (
    id integer NOT NULL,
    name character varying(150) NOT NULL
);


ALTER TABLE public.auth_group OWNER TO wenani_springinfor;

--
-- Name: auth_group_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.auth_group ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.auth_group_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: auth_group_permissions; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.auth_group_permissions (
    id bigint NOT NULL,
    group_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE public.auth_group_permissions OWNER TO wenani_springinfor;

--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.auth_group_permissions ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.auth_group_permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: auth_permission; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.auth_permission (
    id integer NOT NULL,
    name character varying(255) NOT NULL,
    content_type_id integer NOT NULL,
    codename character varying(100) NOT NULL
);


ALTER TABLE public.auth_permission OWNER TO wenani_springinfor;

--
-- Name: auth_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.auth_permission ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.auth_permission_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);

--
-- Name: auth_user_groups; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.auth_user_groups (
    id bigint NOT NULL,
    user_id integer NOT NULL,
    group_id integer NOT NULL
);


ALTER TABLE public.auth_user_groups OWNER TO wenani_springinfor;

--
-- Name: auth_user_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.auth_user_groups ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.auth_user_groups_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: auth_user_user_permissions; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.auth_user_user_permissions (
    id bigint NOT NULL,
    user_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE public.auth_user_user_permissions OWNER TO wenani_springinfor;

--
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.auth_user_user_permissions ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.auth_user_user_permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: django_admin_log; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.django_admin_log (
    id integer NOT NULL,
    action_time timestamp with time zone NOT NULL,
    object_id text,
    object_repr character varying(200) NOT NULL,
    action_flag smallint NOT NULL,
    change_message text NOT NULL,
    content_type_id integer,
    user_id integer NOT NULL,
    CONSTRAINT django_admin_log_action_flag_check CHECK ((action_flag >= 0))
);


ALTER TABLE public.django_admin_log OWNER TO wenani_springinfor;

--
-- Name: django_admin_log_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.django_admin_log ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.django_admin_log_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: django_content_type; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.django_content_type (
    id integer NOT NULL,
    app_label character varying(100) NOT NULL,
    model character varying(100) NOT NULL
);


ALTER TABLE public.django_content_type OWNER TO wenani_springinfor;

--
-- Name: django_content_type_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.django_content_type ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.django_content_type_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: django_migrations; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.django_migrations (
    id bigint NOT NULL,
    app character varying(255) NOT NULL,
    name character varying(255) NOT NULL,
    applied timestamp with time zone NOT NULL
);


ALTER TABLE public.django_migrations OWNER TO wenani_springinfor;

--
-- Name: django_migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.django_migrations ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.django_migrations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);

--
-- Name: legal_agreements_legalacceptance; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.legal_agreements_legalacceptance (
    id bigint NOT NULL,
    accepted_at timestamp with time zone NOT NULL,
    ip_address inet,
    user_agent character varying(255) NOT NULL,
    document_id bigint NOT NULL,
    user_id integer NOT NULL
);


ALTER TABLE public.legal_agreements_legalacceptance OWNER TO wenani_springinfor;

--
-- Name: legal_agreements_legalacceptance_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.legal_agreements_legalacceptance ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.legal_agreements_legalacceptance_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: legal_agreements_legaldocument; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.legal_agreements_legaldocument (
    id bigint NOT NULL,
    slug character varying(80) NOT NULL,
    title character varying(255) NOT NULL,
    document_type character varying(20) NOT NULL,
    version integer NOT NULL,
    content text NOT NULL,
    is_required boolean NOT NULL,
    is_active boolean NOT NULL,
    effective_from timestamp with time zone NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    staff_acceptance_policy character varying(20) NOT NULL,
    sync_scope character varying(20) NOT NULL,
    target_website_keys jsonb NOT NULL,
    CONSTRAINT legal_agreements_legaldocument_version_check CHECK ((version >= 0))
);


ALTER TABLE public.legal_agreements_legaldocument OWNER TO wenani_springinfor;

--
-- Name: legal_agreements_legaldocument_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.legal_agreements_legaldocument ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.legal_agreements_legaldocument_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: legal_agreements_legalremoteacceptance; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.legal_agreements_legalremoteacceptance (
    id bigint NOT NULL,
    website_key character varying(100) NOT NULL,
    source_acceptance_id character varying(100) NOT NULL,
    document_slug character varying(80) NOT NULL,
    document_version integer NOT NULL,
    document_title character varying(255) NOT NULL,
    source_user_reference character varying(255) NOT NULL,
    signed_at timestamp with time zone NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    revoked_at timestamp with time zone,
    CONSTRAINT legal_agreements_legalremoteacceptance_document_version_check CHECK ((document_version >= 0))
);


ALTER TABLE public.legal_agreements_legalremoteacceptance OWNER TO wenani_springinfor;

--
-- Name: legal_agreements_legalremoteacceptance_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.legal_agreements_legalremoteacceptance ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.legal_agreements_legalremoteacceptance_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: mfa_authenticator; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.mfa_authenticator (
    id bigint NOT NULL,
    type character varying(20) NOT NULL,
    data jsonb NOT NULL,
    user_id integer NOT NULL,
    created_at timestamp with time zone NOT NULL,
    last_used_at timestamp with time zone
);


ALTER TABLE public.mfa_authenticator OWNER TO wenani_springinfor;

--
-- Name: mfa_authenticator_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.mfa_authenticator ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.mfa_authenticator_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: registrations_emailtemplate; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.registrations_emailtemplate (
    id bigint NOT NULL,
    template_type character varying(20) NOT NULL,
    subject character varying(255) NOT NULL,
    body text NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    updated_by_id integer
);


ALTER TABLE public.registrations_emailtemplate OWNER TO wenani_springinfor;

--
-- Name: registrations_emailtemplate_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.registrations_emailtemplate ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.registrations_emailtemplate_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: registrations_outboundmessage; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.registrations_outboundmessage (
    id bigint NOT NULL,
    message_type character varying(20) NOT NULL,
    audience_type character varying(20) NOT NULL,
    subject character varying(255) NOT NULL,
    body text NOT NULL,
    from_email character varying(254) NOT NULL,
    created_at timestamp with time zone NOT NULL,
    created_by_id integer,
    reply_to character varying(254) NOT NULL
);


ALTER TABLE public.registrations_outboundmessage OWNER TO wenani_springinfor;

--
-- Name: registrations_outboundmessage_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.registrations_outboundmessage ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.registrations_outboundmessage_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: registrations_outboundmessagerecipient; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.registrations_outboundmessagerecipient (
    id bigint NOT NULL,
    email character varying(254) NOT NULL,
    delivery_status character varying(20) NOT NULL,
    sent_at timestamp with time zone,
    error_message text NOT NULL,
    message_id bigint NOT NULL,
    registration_id bigint
);


ALTER TABLE public.registrations_outboundmessagerecipient OWNER TO wenani_springinfor;

--
-- Name: registrations_outboundmessagerecipient_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.registrations_outboundmessagerecipient ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.registrations_outboundmessagerecipient_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: registrations_pendingregistration; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.registrations_pendingregistration (
    id bigint NOT NULL,
    email character varying(254) NOT NULL,
    payload jsonb NOT NULL,
    ip_address inet,
    created_at timestamp with time zone NOT NULL,
    verified_at timestamp with time zone,
    completed_registration_id bigint
);


ALTER TABLE public.registrations_pendingregistration OWNER TO wenani_springinfor;

--
-- Name: registrations_pendingregistration_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.registrations_pendingregistration ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.registrations_pendingregistration_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: registrations_registration; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.registrations_registration (
    id bigint NOT NULL,
    salutation character varying(32) NOT NULL,
    first_name character varying(150) NOT NULL,
    father_name character varying(150) NOT NULL,
    grandfather_name character varying(150) NOT NULL,
    email character varying(254),
    phone_country character varying(2) NOT NULL,
    phone_number character varying(32) NOT NULL,
    address_line1 character varying(255) NOT NULL,
    address_line2 character varying(255) NOT NULL,
    city character varying(120) NOT NULL,
    state_region character varying(120) NOT NULL,
    postal_code character varying(30) NOT NULL,
    address_country character varying(2) NOT NULL,
    pledged_amount numeric(10,2),
    notes text NOT NULL,
    extra_data jsonb NOT NULL,
    ip_address inet,
    registered_at timestamp with time zone NOT NULL,
    status character varying(20) NOT NULL,
    approved_at timestamp with time zone,
    approved_by_id integer,
    removed_at timestamp with time zone,
    removal_reason character varying(50) NOT NULL,
    removal_notes text NOT NULL,
    removed_by_id integer
);


ALTER TABLE public.registrations_registration OWNER TO wenani_springinfor;

--
-- Name: registrations_registration_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.registrations_registration ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.registrations_registration_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: socialaccount_socialaccount; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.socialaccount_socialaccount (
    id integer NOT NULL,
    provider character varying(200) NOT NULL,
    uid character varying(191) NOT NULL,
    last_login timestamp with time zone NOT NULL,
    date_joined timestamp with time zone NOT NULL,
    extra_data jsonb NOT NULL,
    user_id integer NOT NULL
);


ALTER TABLE public.socialaccount_socialaccount OWNER TO wenani_springinfor;

--
-- Name: socialaccount_socialaccount_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.socialaccount_socialaccount ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.socialaccount_socialaccount_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: website_aboutus; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.website_aboutus (
    id bigint NOT NULL,
    lead_content text NOT NULL,
    lead_title character varying(255) NOT NULL,
    sub_content_1 text NOT NULL,
    sub_content_2 text NOT NULL,
    sub_content_3 text NOT NULL,
    sub_content_4 text NOT NULL,
    sub_content_5 text NOT NULL,
    sub_title_1 character varying(255) NOT NULL,
    sub_title_2 character varying(255) NOT NULL,
    sub_title_3 character varying(255) NOT NULL,
    sub_title_4 character varying(255) NOT NULL,
    sub_title_5 character varying(255) NOT NULL,
    is_active boolean NOT NULL
);


ALTER TABLE public.website_aboutus OWNER TO wenani_springinfor;

--
-- Name: website_aboutus_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.website_aboutus ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.website_aboutus_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: website_calltoaction; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.website_calltoaction (
    id bigint NOT NULL,
    title character varying(255) NOT NULL,
    subtitle character varying(255) NOT NULL,
    button_text character varying(100) NOT NULL,
    button_link character varying(200) NOT NULL,
    is_active boolean NOT NULL
);


ALTER TABLE public.website_calltoaction OWNER TO wenani_springinfor;

--
-- Name: website_calltoaction_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.website_calltoaction ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.website_calltoaction_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: website_careers; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.website_careers (
    id bigint NOT NULL,
    "position" character varying(200) NOT NULL,
    description text NOT NULL,
    requirements text NOT NULL,
    is_active boolean NOT NULL,
    posted_at timestamp with time zone NOT NULL,
    ends_at timestamp with time zone
);


ALTER TABLE public.website_careers OWNER TO wenani_springinfor;

--
-- Name: website_careers_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.website_careers ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.website_careers_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: website_companyaddress; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.website_companyaddress (
    id bigint NOT NULL,
    company_name character varying(255) NOT NULL,
    description text NOT NULL,
    address_line_1 character varying(255) NOT NULL,
    address_line_2 character varying(255) NOT NULL,
    city character varying(100) NOT NULL,
    state character varying(100) NOT NULL,
    postal_code character varying(20) NOT NULL,
    country character varying(100) NOT NULL,
    email character varying(254) NOT NULL,
    phone character varying(20) NOT NULL,
    vat_number character varying(50) NOT NULL,
    reg_number character varying(50) NOT NULL,
    contact_person character varying(255) NOT NULL
);


ALTER TABLE public.website_companyaddress OWNER TO wenani_springinfor;

--
-- Name: website_companyaddress_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.website_companyaddress ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.website_companyaddress_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: website_contactmessage; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.website_contactmessage (
    id bigint NOT NULL,
    name character varying(120) NOT NULL,
    email character varying(254) NOT NULL,
    phone character varying(50) NOT NULL,
    company character varying(120) NOT NULL,
    subject character varying(200) NOT NULL,
    message text NOT NULL,
    created_at timestamp with time zone NOT NULL,
    is_processed boolean NOT NULL
);


ALTER TABLE public.website_contactmessage OWNER TO wenani_springinfor;

--
-- Name: website_contactmessage_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.website_contactmessage ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.website_contactmessage_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: website_faqitem; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.website_faqitem (
    id bigint NOT NULL,
    question character varying(300) NOT NULL,
    answer text NOT NULL,
    sort_order integer NOT NULL,
    is_active boolean NOT NULL,
    CONSTRAINT website_faqitem_sort_order_check CHECK ((sort_order >= 0))
);


ALTER TABLE public.website_faqitem OWNER TO wenani_springinfor;

--
-- Name: website_faqitem_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.website_faqitem ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.website_faqitem_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: website_herotext; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.website_herotext (
    id bigint NOT NULL,
    title character varying(255) NOT NULL,
    subtitle character varying(255) NOT NULL,
    description text NOT NULL,
    image character varying(100),
    button_primary_text character varying(100) NOT NULL,
    button_secondary_text character varying(100) NOT NULL,
    is_active boolean NOT NULL,
    button_link_2 character varying(200) NOT NULL
);


ALTER TABLE public.website_herotext OWNER TO wenani_springinfor;

--
-- Name: website_herotext_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.website_herotext ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.website_herotext_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: website_privacypolicy; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.website_privacypolicy (
    id bigint NOT NULL,
    title character varying(255) NOT NULL,
    content text NOT NULL,
    is_active boolean NOT NULL,
    last_updated timestamp with time zone NOT NULL
);


ALTER TABLE public.website_privacypolicy OWNER TO wenani_springinfor;

--
-- Name: website_privacypolicy_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.website_privacypolicy ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.website_privacypolicy_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: website_service; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.website_service (
    id bigint NOT NULL,
    title character varying(200) NOT NULL,
    short_description character varying(300) NOT NULL,
    description text NOT NULL,
    is_featured boolean NOT NULL,
    sort_order integer NOT NULL,
    is_active boolean NOT NULL,
    image character varying(100),
    CONSTRAINT website_service_sort_order_check CHECK ((sort_order >= 0))
);


ALTER TABLE public.website_service OWNER TO wenani_springinfor;

--
-- Name: website_service_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.website_service ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.website_service_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: website_sitepageseo; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.website_sitepageseo (
    id bigint NOT NULL,
    page character varying(30) NOT NULL,
    seo_title character varying(70) NOT NULL,
    seo_description character varying(160) NOT NULL,
    seo_keywords character varying(255) NOT NULL,
    meta_robots character varying(50) NOT NULL,
    og_title character varying(70) NOT NULL,
    og_description character varying(160) NOT NULL,
    og_image character varying(100)
);


ALTER TABLE public.website_sitepageseo OWNER TO wenani_springinfor;

--
-- Name: website_sitepageseo_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.website_sitepageseo ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.website_sitepageseo_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: website_socialmedia; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.website_socialmedia (
    id bigint NOT NULL,
    name character varying NOT NULL,
    url character varying(200) NOT NULL
);


ALTER TABLE public.website_socialmedia OWNER TO wenani_springinfor;

--
-- Name: website_socialmedia_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.website_socialmedia ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.website_socialmedia_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: website_testimonial; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.website_testimonial (
    id bigint NOT NULL,
    client_name character varying(120),
    title character varying(200),
    company character varying(120),
    image character varying(100),
    content text NOT NULL,
    rating integer,
    created_at timestamp with time zone NOT NULL,
    website character varying(200),
    is_active boolean NOT NULL,
    sort_order integer NOT NULL,
    CONSTRAINT website_testimonial_rating_check CHECK ((rating >= 0)),
    CONSTRAINT website_testimonial_sort_order_check CHECK ((sort_order >= 0))
);


ALTER TABLE public.website_testimonial OWNER TO wenani_springinfor;

--
-- Name: website_testimonial_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.website_testimonial ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.website_testimonial_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: website_valueproposition; Type: TABLE; Schema: public; Owner: wenani_springinfor
--

CREATE TABLE public.website_valueproposition (
    id bigint NOT NULL,
    title character varying(255) NOT NULL,
    description text NOT NULL,
    icon character varying(100),
    image character varying(100),
    sort_order integer NOT NULL,
    is_active boolean NOT NULL,
    CONSTRAINT website_valueproposition_sort_order_check CHECK ((sort_order >= 0))
);


ALTER TABLE public.website_valueproposition OWNER TO wenani_springinfor;

--
-- Name: website_valueproposition_id_seq; Type: SEQUENCE; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE public.website_valueproposition ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.website_valueproposition_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Data for Name: account_emailaddress; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.account_emailaddress (id, email, verified, "primary", user_id) FROM stdin;
1	isaak@springinformatics.com	t	t	1
\.


--
-- Data for Name: auth_group; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.auth_group (id, name) FROM stdin;
\.


--
-- Data for Name: auth_group_permissions; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.auth_group_permissions (id, group_id, permission_id) FROM stdin;
\.


--
-- Data for Name: auth_permission; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.auth_permission (id, name, content_type_id, codename) FROM stdin;
1	Can add log entry	1	add_logentry
2	Can change log entry	1	change_logentry
3	Can delete log entry	1	delete_logentry
4	Can view log entry	1	view_logentry
5	Can add permission	2	add_permission
6	Can change permission	2	change_permission
7	Can delete permission	2	delete_permission
8	Can view permission	2	view_permission
9	Can add group	3	add_group
10	Can change group	3	change_group
11	Can delete group	3	delete_group
12	Can view group	3	view_group
13	Can add user	4	add_user
14	Can change user	4	change_user
15	Can delete user	4	delete_user
16	Can view user	4	view_user
17	Can add content type	5	add_contenttype
18	Can change content type	5	change_contenttype
19	Can delete content type	5	delete_contenttype
20	Can view content type	5	view_contenttype
21	Can add session	6	add_session
22	Can change session	6	change_session
23	Can delete session	6	delete_session
24	Can view session	6	view_session
25	Can add email address	7	add_emailaddress
26	Can change email address	7	change_emailaddress
27	Can delete email address	7	delete_emailaddress
28	Can view email address	7	view_emailaddress
29	Can add email confirmation	8	add_emailconfirmation
30	Can change email confirmation	8	change_emailconfirmation
31	Can delete email confirmation	8	delete_emailconfirmation
32	Can view email confirmation	8	view_emailconfirmation
33	Can add social account	9	add_socialaccount
34	Can change social account	9	change_socialaccount
35	Can delete social account	9	delete_socialaccount
36	Can view social account	9	view_socialaccount
37	Can add social application	10	add_socialapp
38	Can change social application	10	change_socialapp
39	Can delete social application	10	delete_socialapp
40	Can view social application	10	view_socialapp
41	Can add social application token	11	add_socialtoken
42	Can change social application token	11	change_socialtoken
43	Can delete social application token	11	delete_socialtoken
44	Can view social application token	11	view_socialtoken
45	Can add authenticator	12	add_authenticator
46	Can change authenticator	12	change_authenticator
47	Can delete authenticator	12	delete_authenticator
48	Can view authenticator	12	view_authenticator
49	Can add About Us	13	add_aboutus
50	Can change About Us	13	change_aboutus
51	Can delete About Us	13	delete_aboutus
52	Can view About Us	13	view_aboutus
53	Can add Career	14	add_careers
54	Can change Career	14	change_careers
55	Can delete Career	14	delete_careers
56	Can view Career	14	view_careers
57	Can add Contact message	15	add_contactmessage
58	Can change Contact message	15	change_contactmessage
59	Can delete Contact message	15	delete_contactmessage
60	Can view Contact message	15	view_contactmessage
61	Can add FAQ item	16	add_faqitem
62	Can change FAQ item	16	change_faqitem
63	Can delete FAQ item	16	delete_faqitem
64	Can view FAQ item	16	view_faqitem
65	Can add Service	17	add_service
66	Can change Service	17	change_service
67	Can delete Service	17	delete_service
68	Can view Service	17	view_service
69	Can add Testimonial	18	add_testimonial
70	Can change Testimonial	18	change_testimonial
71	Can delete Testimonial	18	delete_testimonial
72	Can view Testimonial	18	view_testimonial
73	Can add Company Address	19	add_companyaddress
74	Can change Company Address	19	change_companyaddress
75	Can delete Company Address	19	delete_companyaddress
76	Can view Company Address	19	view_companyaddress
77	Can add Social Media	20	add_socialmedia
78	Can change Social Media	20	change_socialmedia
79	Can delete Social Media	20	delete_socialmedia
80	Can view Social Media	20	view_socialmedia
81	Can add Hero Text	21	add_herotext
82	Can change Hero Text	21	change_herotext
83	Can delete Hero Text	21	delete_herotext
84	Can view Hero Text	21	view_herotext
85	Can add Value Proposition	22	add_valueproposition
86	Can change Value Proposition	22	change_valueproposition
87	Can delete Value Proposition	22	delete_valueproposition
88	Can view Value Proposition	22	view_valueproposition
89	Can add Call to Action	23	add_calltoaction
90	Can change Call to Action	23	change_calltoaction
91	Can delete Call to Action	23	delete_calltoaction
92	Can view Call to Action	23	view_calltoaction
93	Can add Site page SEO	24	add_sitepageseo
94	Can change Site page SEO	24	change_sitepageseo
95	Can delete Site page SEO	24	delete_sitepageseo
96	Can view Site page SEO	24	view_sitepageseo
97	Can add Privacy Policy	25	add_privacypolicy
98	Can change Privacy Policy	25	change_privacypolicy
99	Can delete Privacy Policy	25	delete_privacypolicy
100	Can view Privacy Policy	25	view_privacypolicy
101	Can add legal document	26	add_legaldocument
102	Can change legal document	26	change_legaldocument
103	Can delete legal document	26	delete_legaldocument
104	Can view legal document	26	view_legaldocument
105	Can add legal acceptance	27	add_legalacceptance
106	Can change legal acceptance	27	change_legalacceptance
107	Can delete legal acceptance	27	delete_legalacceptance
108	Can view legal acceptance	27	view_legalacceptance
109	Can add legal remote acceptance	28	add_legalremoteacceptance
110	Can change legal remote acceptance	28	change_legalremoteacceptance
111	Can delete legal remote acceptance	28	delete_legalremoteacceptance
112	Can view legal remote acceptance	28	view_legalremoteacceptance
113	Can add registration	29	add_registration
114	Can change registration	29	change_registration
115	Can delete registration	29	delete_registration
116	Can view registration	29	view_registration
117	Can add outbound message	30	add_outboundmessage
118	Can change outbound message	30	change_outboundmessage
119	Can delete outbound message	30	delete_outboundmessage
120	Can view outbound message	30	view_outboundmessage
121	Can add outbound message recipient	31	add_outboundmessagerecipient
122	Can change outbound message recipient	31	change_outboundmessagerecipient
123	Can delete outbound message recipient	31	delete_outboundmessagerecipient
124	Can view outbound message recipient	31	view_outboundmessagerecipient
125	Can add email template	32	add_emailtemplate
126	Can change email template	32	change_emailtemplate
127	Can delete email template	32	delete_emailtemplate
128	Can view email template	32	view_emailtemplate
129	Can add pending registration	33	add_pendingregistration
130	Can change pending registration	33	change_pendingregistration
131	Can delete pending registration	33	delete_pendingregistration
132	Can view pending registration	33	view_pendingregistration
\.


--
-- Data for Name: auth_user_groups; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.auth_user_groups (id, user_id, group_id) FROM stdin;
\.


--
-- Data for Name: auth_user_user_permissions; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.auth_user_user_permissions (id, user_id, permission_id) FROM stdin;
\.


--
-- Data for Name: django_admin_log; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) FROM stdin;
\.


--
-- Data for Name: django_content_type; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.django_content_type (id, app_label, model) FROM stdin;
1	admin	logentry
2	auth	permission
3	auth	group
4	auth	user
5	contenttypes	contenttype
6	sessions	session
7	account	emailaddress
8	account	emailconfirmation
9	socialaccount	socialaccount
10	socialaccount	socialapp
11	socialaccount	socialtoken
12	mfa	authenticator
13	website	aboutus
14	website	careers
15	website	contactmessage
16	website	faqitem
17	website	service
18	website	testimonial
19	website	companyaddress
20	website	socialmedia
21	website	herotext
22	website	valueproposition
23	website	calltoaction
24	website	sitepageseo
25	website	privacypolicy
26	legal_agreements	legaldocument
27	legal_agreements	legalacceptance
28	legal_agreements	legalremoteacceptance
29	registrations	registration
30	registrations	outboundmessage
31	registrations	outboundmessagerecipient
32	registrations	emailtemplate
33	registrations	pendingregistration
\.


--
-- Data for Name: django_migrations; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.django_migrations (id, app, name, applied) FROM stdin;
1	contenttypes	0001_initial	2026-03-25 11:44:57.957694+01
2	auth	0001_initial	2026-03-25 11:44:58.038677+01
3	account	0001_initial	2026-03-25 11:44:58.076892+01
4	account	0002_email_max_length	2026-03-25 11:44:58.091482+01
5	account	0003_alter_emailaddress_create_unique_verified_email	2026-03-25 11:44:58.107817+01
6	account	0004_alter_emailaddress_drop_unique_email	2026-03-25 11:44:58.148473+01
7	account	0005_emailaddress_idx_upper_email	2026-03-25 11:44:58.164122+01
8	account	0006_emailaddress_lower	2026-03-25 11:44:58.177102+01
9	account	0007_emailaddress_idx_email	2026-03-25 11:44:58.194409+01
10	account	0008_emailaddress_unique_primary_email_fixup	2026-03-25 11:44:58.215164+01
11	account	0009_emailaddress_unique_primary_email	2026-03-25 11:44:58.226643+01
12	admin	0001_initial	2026-03-25 11:44:58.251197+01
13	admin	0002_logentry_remove_auto_add	2026-03-25 11:44:58.261641+01
14	admin	0003_logentry_add_action_flag_choices	2026-03-25 11:44:58.274323+01
15	contenttypes	0002_remove_content_type_name	2026-03-25 11:44:58.326877+01
16	auth	0002_alter_permission_name_max_length	2026-03-25 11:44:58.335842+01
17	auth	0003_alter_user_email_max_length	2026-03-25 11:44:58.344322+01
18	auth	0004_alter_user_username_opts	2026-03-25 11:44:58.352128+01
19	auth	0005_alter_user_last_login_null	2026-03-25 11:44:58.362345+01
20	auth	0006_require_contenttypes_0002	2026-03-25 11:44:58.364344+01
21	auth	0007_alter_validators_add_error_messages	2026-03-25 11:44:58.374984+01
22	auth	0008_alter_user_username_max_length	2026-03-25 11:44:58.389855+01
23	auth	0009_alter_user_last_name_max_length	2026-03-25 11:44:58.406062+01
24	auth	0010_alter_group_name_max_length	2026-03-25 11:44:58.416987+01
25	auth	0011_update_proxy_permissions	2026-03-25 11:44:58.428655+01
26	auth	0012_alter_user_first_name_max_length	2026-03-25 11:44:58.440462+01
27	legal_agreements	0001_initial	2026-03-25 11:44:58.492865+01
28	legal_agreements	0002_legaldocument_staff_acceptance_policy	2026-03-25 11:44:58.502089+01
29	legal_agreements	0003_alter_legaldocument_slug	2026-03-25 11:44:58.50901+01
30	legal_agreements	0004_legaldocument_sync_targeting	2026-03-25 11:44:58.528393+01
31	legal_agreements	0005_legalremoteacceptance	2026-03-25 11:44:58.548014+01
32	legal_agreements	0006_legalremoteacceptance_revoked_at	2026-03-25 11:44:58.554934+01
33	mfa	0001_initial	2026-03-25 11:44:58.586626+01
34	mfa	0002_authenticator_timestamps	2026-03-25 11:44:58.616237+01
35	mfa	0003_authenticator_type_uniq	2026-03-25 11:44:58.652159+01
36	registrations	0001_initial	2026-03-25 11:44:58.683835+01
37	registrations	0002_registration_removal_fields	2026-03-25 11:44:58.74798+01
38	registrations	0003_registration_name_contact_uniqueness	2026-03-25 11:44:58.790922+01
39	registrations	0004_outbound_messages	2026-03-25 11:44:58.841428+01
40	registrations	0005_outbound_message_reply_to	2026-03-25 11:44:58.858745+01
41	registrations	0006_allow_reregistration_after_removal	2026-03-25 11:44:58.918046+01
42	registrations	0007_email_templates	2026-03-25 11:44:58.982221+01
43	registrations	0008_pending_registration	2026-03-25 11:44:59.032699+01
44	sessions	0001_initial	2026-03-25 11:44:59.040728+01
45	socialaccount	0001_initial	2026-03-25 11:44:59.117438+01
46	socialaccount	0002_token_max_lengths	2026-03-25 11:44:59.145673+01
47	socialaccount	0003_extra_data_default_dict	2026-03-25 11:44:59.161594+01
48	socialaccount	0004_app_provider_id_settings	2026-03-25 11:44:59.196873+01
49	socialaccount	0005_socialtoken_nullable_app	2026-03-25 11:44:59.235061+01
50	socialaccount	0006_alter_socialaccount_extra_data	2026-03-25 11:44:59.25549+01
51	website	0001_initial	2026-03-25 11:44:59.306129+01
52	website	0002_companyaddress_socialmedia_testimonial_website	2026-03-25 11:44:59.333732+01
53	website	0003_testimonial_is_active_testimonial_sort_order	2026-03-25 11:44:59.343743+01
54	website	0004_alter_testimonial_client_name_and_more	2026-03-25 11:44:59.362191+01
55	website	0005_remove_testimonial_is_approved	2026-03-25 11:44:59.367857+01
56	website	0006_aboutus_core_values_aboutus_image_and_more	2026-03-25 11:44:59.386448+01
57	website	0007_herotext_valueproposition_alter_faqitem_answer_and_more	2026-03-25 11:44:59.411393+01
58	website	0008_alter_herotext_options_remove_herotext_button_text_1_and_more	2026-03-25 11:44:59.437027+01
59	website	0009_rename_button_primary_herotext_button_primary_text_and_more	2026-03-25 11:44:59.444764+01
60	website	0010_calltoaction	2026-03-25 11:44:59.453421+01
61	website	0011_remove_aboutus_content_remove_aboutus_core_values_and_more	2026-03-25 11:44:59.520977+01
62	website	0012_aboutus_is_active	2026-03-25 11:44:59.52556+01
63	website	0013_alter_aboutus_lead_content	2026-03-25 11:44:59.529685+01
64	website	0014_sitepageseo_alter_aboutus_sub_content_1_and_more	2026-03-25 11:44:59.558963+01
65	website	0015_privacypolicy	2026-03-25 11:44:59.573447+01
66	website	0016_alter_sitepageseo_page	2026-03-25 11:44:59.647646+01
67	website	0017_herotext_button_link_2	2026-03-25 11:44:59.809889+01
68	website	0018_service_image	2026-03-25 17:37:57.795051+01
\.


--
-- Data for Name: legal_agreements_legalacceptance; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.legal_agreements_legalacceptance (id, accepted_at, ip_address, user_agent, document_id, user_id) FROM stdin;
\.


--
-- Data for Name: legal_agreements_legaldocument; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.legal_agreements_legaldocument (id, slug, title, document_type, version, content, is_required, is_active, effective_from, created_at, updated_at, staff_acceptance_policy, sync_scope, target_website_keys) FROM stdin;
\.


--
-- Data for Name: legal_agreements_legalremoteacceptance; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.legal_agreements_legalremoteacceptance (id, website_key, source_acceptance_id, document_slug, document_version, document_title, source_user_reference, signed_at, created_at, updated_at, revoked_at) FROM stdin;
\.


--
-- Data for Name: mfa_authenticator; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.mfa_authenticator (id, type, data, user_id, created_at, last_used_at) FROM stdin;
\.


--
-- Data for Name: registrations_emailtemplate; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.registrations_emailtemplate (id, template_type, subject, body, updated_at, updated_by_id) FROM stdin;
1	approval	Registration approved	Dear {{ registration.first_name }},\n\nYour registration has been approved.	2026-03-25 11:44:58.972484+01	\N
2	removal	Registration update	Dear {{ registration.first_name }},\n\nWe are unable to approve your registration at this time.\n\n{% if removal_reason_label %}Reason: {{ removal_reason_label }}{% endif %}\n\n{% if registration.removal_notes %}{{ registration.removal_notes }}{% endif %}	2026-03-25 11:44:58.976344+01	\N
\.


--
-- Data for Name: registrations_outboundmessage; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.registrations_outboundmessage (id, message_type, audience_type, subject, body, from_email, created_at, created_by_id, reply_to) FROM stdin;
\.


--
-- Data for Name: registrations_outboundmessagerecipient; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.registrations_outboundmessagerecipient (id, email, delivery_status, sent_at, error_message, message_id, registration_id) FROM stdin;
\.


--
-- Data for Name: registrations_pendingregistration; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.registrations_pendingregistration (id, email, payload, ip_address, created_at, verified_at, completed_registration_id) FROM stdin;
\.


--
-- Data for Name: registrations_registration; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.registrations_registration (id, salutation, first_name, father_name, grandfather_name, email, phone_country, phone_number, address_line1, address_line2, city, state_region, postal_code, address_country, pledged_amount, notes, extra_data, ip_address, registered_at, status, approved_at, approved_by_id, removed_at, removal_reason, removal_notes, removed_by_id) FROM stdin;
\.


--
-- Data for Name: socialaccount_socialaccount; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.socialaccount_socialaccount (id, provider, uid, last_login, date_joined, extra_data, user_id) FROM stdin;
\.


--
-- Data for Name: website_aboutus; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.website_aboutus (id, lead_content, lead_title, sub_content_1, sub_content_2, sub_content_3, sub_content_4, sub_content_5, sub_title_1, sub_title_2, sub_title_3, sub_title_4, sub_title_5, is_active) FROM stdin;
1	<p>My name is Isaak Yosief Tecle. I trained in quantitative genetics (PhD, Cornell).&nbsp; And, I develop data science solutions using a fusion of several computer languages and machine learning tools.</p>												t
\.


--
-- Data for Name: website_calltoaction; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.website_calltoaction (id, title, subtitle, button_text, button_link, is_active) FROM stdin;
1	Need informatics solutions?	Accelerate your evidence based decisions.	Contact Us	https://springinformatics.com/contact/	t
\.


--
-- Data for Name: website_careers; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.website_careers (id, "position", description, requirements, is_active, posted_at, ends_at) FROM stdin;
\.


--
-- Data for Name: website_companyaddress; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.website_companyaddress (id, company_name, description, address_line_1, address_line_2, city, state, postal_code, country, email, phone, vat_number, reg_number, contact_person) FROM stdin;
1	Spring Informatics		Rietveldlaan 10		Wageningen		6708 SB	The Netherlands		+31 6 10528643		KVK No.: 52183688	
\.


--
-- Data for Name: website_contactmessage; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.website_contactmessage (id, name, email, phone, company, subject, message, created_at, is_processed) FROM stdin;
1	isaak	isaak@springinformatics.com				testt maiag	2026-03-26 08:55:23.72919+01	f
\.


--
-- Data for Name: website_faqitem; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.website_faqitem (id, question, answer, sort_order, is_active) FROM stdin;
\.


--
-- Data for Name: website_herotext; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.website_herotext (id, title, subtitle, description, image, button_primary_text, button_secondary_text, is_active, button_link_2) FROM stdin;
1	Make data driven decisions	Make informed decisions.		hero_text/corre.png	Contact Us		t	
\.


--
-- Data for Name: website_privacypolicy; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.website_privacypolicy (id, title, content, is_active, last_updated) FROM stdin;
\.


--
-- Data for Name: website_service; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.website_service (id, title, short_description, description, is_featured, sort_order, is_active, image) FROM stdin;
2	Machine learning	Our Machine learning solutions harness historical data to generate reliable predictions and support better decision-making through advanced regression and classification models.	Our machine learning solutions harness historical data to generate reliable predictions and support better decision-making through advanced regression and classification models. A leading example is our genomic prediction pipeline, solGS, which is currently deployed across all BreedBase websites.	t	2	t	services/springinfor_hclustering.png
3	Capacity Development	For scientists and graduate students looking to strengthen their data science capabilities, we provide foundational training in statistical programming with R and Python.	For scientists and graduate students looking to strengthen their data science capabilities, we provide foundational training in statistical programming with R and Python.	t	3	t	services/training_iita_2018.png
1	Exploratory Data Analysis	Our exploratory data analysis tools combine advanced analytics with interactive visualizations to uncover anomalies, clarify distributions, reveal relationships between variables, and highlight meaningful trends and patterns.	Our exploratory data analysis tools combine advanced analytics with interactive visualizations to uncover anomalies, clarify distributions, reveal relationships between variables, and highlight meaningful trends and patterns. Some of the applications available on BreedBase are principal component, K-Means and hierarchical clustering, and correlation analysis.	t	1	t	services/springinfo_correlation.png
\.


--
-- Data for Name: website_sitepageseo; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.website_sitepageseo (id, page, seo_title, seo_description, seo_keywords, meta_robots, og_title, og_description, og_image) FROM stdin;
\.


--
-- Data for Name: website_socialmedia; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.website_socialmedia (id, name, url) FROM stdin;
1	LinkedIn	https://www.linkedin.com/in/isaakyosieftecle
\.


--
-- Data for Name: website_testimonial; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.website_testimonial (id, client_name, title, company, image, content, rating, created_at, website, is_active, sort_order) FROM stdin;
1	The Sol Genomics Network	\N	\N	testimonials/sgn.png	The database for the Solanaceae Research Community	\N	2026-03-25 15:06:03.551002+01	https://solgenomics.net	t	0
2	NextGen Cassava Breeding Project	\N	\N	testimonials/cassavabase.png	Empowering smallholder farmers through innovative, sustainable cassava breeding.	\N	2026-03-25 15:32:23.426716+01	https://cassavabase.org	t	0
3	The Triticeae Toolbox	\N	\N	testimonials/t3.png	Public breeding databases for wheat, oat, and barley. Generated by the USDA Triticeae CAP.	\N	2026-03-25 16:38:19.913406+01	https://triticeaetoolbox.github.io/	t	0
\.


--
-- Data for Name: website_valueproposition; Type: TABLE DATA; Schema: public; Owner: wenani_springinfor
--

COPY public.website_valueproposition (id, title, description, icon, image, sort_order, is_active) FROM stdin;
\.



--
-- Name: account_emailaddress account_emailaddress_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.account_emailaddress
    ADD CONSTRAINT account_emailaddress_pkey PRIMARY KEY (id);


--
-- Name: account_emailaddress account_emailaddress_user_id_email_987c8728_uniq; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.account_emailaddress
    ADD CONSTRAINT account_emailaddress_user_id_email_987c8728_uniq UNIQUE (user_id, email);


--
-- Name: auth_group auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.auth_group
    ADD CONSTRAINT auth_group_name_key UNIQUE (name);


--
-- Name: auth_group_permissions auth_group_permissions_group_id_permission_id_0cd325b0_uniq; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_group_id_permission_id_0cd325b0_uniq UNIQUE (group_id, permission_id);


--
-- Name: auth_group_permissions auth_group_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_pkey PRIMARY KEY (id);


--
-- Name: auth_group auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.auth_group
    ADD CONSTRAINT auth_group_pkey PRIMARY KEY (id);


--
-- Name: auth_permission auth_permission_content_type_id_codename_01ab375a_uniq; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.auth_permission
    ADD CONSTRAINT auth_permission_content_type_id_codename_01ab375a_uniq UNIQUE (content_type_id, codename);


--
-- Name: auth_permission auth_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.auth_permission
    ADD CONSTRAINT auth_permission_pkey PRIMARY KEY (id);


--
-- Name: auth_user_groups auth_user_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.auth_user_groups
    ADD CONSTRAINT auth_user_groups_pkey PRIMARY KEY (id);


--
-- Name: auth_user_groups auth_user_groups_user_id_group_id_94350c0c_uniq; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.auth_user_groups
    ADD CONSTRAINT auth_user_groups_user_id_group_id_94350c0c_uniq UNIQUE (user_id, group_id);


--
-- Name: auth_user_user_permissions auth_user_user_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_pkey PRIMARY KEY (id);


--
-- Name: auth_user_user_permissions auth_user_user_permissions_user_id_permission_id_14a6b632_uniq; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_user_id_permission_id_14a6b632_uniq UNIQUE (user_id, permission_id);


--
-- Name: django_admin_log django_admin_log_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.django_admin_log
    ADD CONSTRAINT django_admin_log_pkey PRIMARY KEY (id);


--
-- Name: django_content_type django_content_type_app_label_model_76bd3d3b_uniq; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.django_content_type
    ADD CONSTRAINT django_content_type_app_label_model_76bd3d3b_uniq UNIQUE (app_label, model);


--
-- Name: django_content_type django_content_type_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.django_content_type
    ADD CONSTRAINT django_content_type_pkey PRIMARY KEY (id);


--
-- Name: django_migrations django_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.django_migrations
    ADD CONSTRAINT django_migrations_pkey PRIMARY KEY (id);


--
-- Name: legal_agreements_legalacceptance legal_acceptance_unique_document_user; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.legal_agreements_legalacceptance
    ADD CONSTRAINT legal_acceptance_unique_document_user UNIQUE (document_id, user_id);


--
-- Name: legal_agreements_legalacceptance legal_agreements_legalacceptance_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.legal_agreements_legalacceptance
    ADD CONSTRAINT legal_agreements_legalacceptance_pkey PRIMARY KEY (id);


--
-- Name: legal_agreements_legaldocument legal_agreements_legaldocument_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.legal_agreements_legaldocument
    ADD CONSTRAINT legal_agreements_legaldocument_pkey PRIMARY KEY (id);


--
-- Name: legal_agreements_legalremoteacceptance legal_agreements_legalremoteacceptance_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.legal_agreements_legalremoteacceptance
    ADD CONSTRAINT legal_agreements_legalremoteacceptance_pkey PRIMARY KEY (id);


--
-- Name: legal_agreements_legaldocument legal_doc_unique_slug_version; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.legal_agreements_legaldocument
    ADD CONSTRAINT legal_doc_unique_slug_version UNIQUE (slug, version);


--
-- Name: legal_agreements_legalremoteacceptance legal_remote_acceptance_unique_site_source_acceptance; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.legal_agreements_legalremoteacceptance
    ADD CONSTRAINT legal_remote_acceptance_unique_site_source_acceptance UNIQUE (website_key, source_acceptance_id);


--
-- Name: mfa_authenticator mfa_authenticator_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.mfa_authenticator
    ADD CONSTRAINT mfa_authenticator_pkey PRIMARY KEY (id);


--
-- Name: registrations_emailtemplate registrations_emailtemplate_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.registrations_emailtemplate
    ADD CONSTRAINT registrations_emailtemplate_pkey PRIMARY KEY (id);


--
-- Name: registrations_emailtemplate registrations_emailtemplate_template_type_key; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.registrations_emailtemplate
    ADD CONSTRAINT registrations_emailtemplate_template_type_key UNIQUE (template_type);


--
-- Name: registrations_outboundmessage registrations_outboundmessage_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.registrations_outboundmessage
    ADD CONSTRAINT registrations_outboundmessage_pkey PRIMARY KEY (id);


--
-- Name: registrations_outboundmessagerecipient registrations_outboundmessagerecipient_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.registrations_outboundmessagerecipient
    ADD CONSTRAINT registrations_outboundmessagerecipient_pkey PRIMARY KEY (id);


--
-- Name: registrations_pendingregistration registrations_pendingregistration_completed_registration_id_key; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.registrations_pendingregistration
    ADD CONSTRAINT registrations_pendingregistration_completed_registration_id_key UNIQUE (completed_registration_id);


--
-- Name: registrations_pendingregistration registrations_pendingregistration_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.registrations_pendingregistration
    ADD CONSTRAINT registrations_pendingregistration_pkey PRIMARY KEY (id);


--
-- Name: registrations_registration registrations_registration_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.registrations_registration
    ADD CONSTRAINT registrations_registration_pkey PRIMARY KEY (id);


--
-- Name: socialaccount_socialaccount socialaccount_socialaccount_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.socialaccount_socialaccount
    ADD CONSTRAINT socialaccount_socialaccount_pkey PRIMARY KEY (id);


--
-- Name: socialaccount_socialaccount socialaccount_socialaccount_provider_uid_fc810c6e_uniq; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.socialaccount_socialaccount
    ADD CONSTRAINT socialaccount_socialaccount_provider_uid_fc810c6e_uniq UNIQUE (provider, uid);


--
-- Name: website_aboutus website_aboutus_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.website_aboutus
    ADD CONSTRAINT website_aboutus_pkey PRIMARY KEY (id);


--
-- Name: website_calltoaction website_calltoaction_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.website_calltoaction
    ADD CONSTRAINT website_calltoaction_pkey PRIMARY KEY (id);


--
-- Name: website_careers website_careers_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.website_careers
    ADD CONSTRAINT website_careers_pkey PRIMARY KEY (id);


--
-- Name: website_companyaddress website_companyaddress_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.website_companyaddress
    ADD CONSTRAINT website_companyaddress_pkey PRIMARY KEY (id);


--
-- Name: website_contactmessage website_contactmessage_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.website_contactmessage
    ADD CONSTRAINT website_contactmessage_pkey PRIMARY KEY (id);


--
-- Name: website_faqitem website_faqitem_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.website_faqitem
    ADD CONSTRAINT website_faqitem_pkey PRIMARY KEY (id);


--
-- Name: website_herotext website_herotext_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.website_herotext
    ADD CONSTRAINT website_herotext_pkey PRIMARY KEY (id);


--
-- Name: website_privacypolicy website_privacypolicy_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.website_privacypolicy
    ADD CONSTRAINT website_privacypolicy_pkey PRIMARY KEY (id);


--
-- Name: website_service website_service_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.website_service
    ADD CONSTRAINT website_service_pkey PRIMARY KEY (id);


--
-- Name: website_sitepageseo website_sitepageseo_page_key; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.website_sitepageseo
    ADD CONSTRAINT website_sitepageseo_page_key UNIQUE (page);


--
-- Name: website_sitepageseo website_sitepageseo_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.website_sitepageseo
    ADD CONSTRAINT website_sitepageseo_pkey PRIMARY KEY (id);


--
-- Name: website_socialmedia website_socialmedia_name_key; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.website_socialmedia
    ADD CONSTRAINT website_socialmedia_name_key UNIQUE (name);


--
-- Name: website_socialmedia website_socialmedia_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.website_socialmedia
    ADD CONSTRAINT website_socialmedia_pkey PRIMARY KEY (id);


--
-- Name: website_testimonial website_testimonial_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.website_testimonial
    ADD CONSTRAINT website_testimonial_pkey PRIMARY KEY (id);


--
-- Name: website_valueproposition website_valueproposition_pkey; Type: CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.website_valueproposition
    ADD CONSTRAINT website_valueproposition_pkey PRIMARY KEY (id);


--
-- Name: account_emailaddress_email_03be32b2; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX account_emailaddress_email_03be32b2 ON public.account_emailaddress USING btree (email);


--
-- Name: account_emailaddress_email_03be32b2_like; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX account_emailaddress_email_03be32b2_like ON public.account_emailaddress USING btree (email varchar_pattern_ops);


--
-- Name: account_emailaddress_user_id_2c513194; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX account_emailaddress_user_id_2c513194 ON public.account_emailaddress USING btree (user_id);


--
-- Name: auth_group_name_a6ea08ec_like; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX auth_group_name_a6ea08ec_like ON public.auth_group USING btree (name varchar_pattern_ops);


--
-- Name: auth_group_permissions_group_id_b120cbf9; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX auth_group_permissions_group_id_b120cbf9 ON public.auth_group_permissions USING btree (group_id);


--
-- Name: auth_group_permissions_permission_id_84c5c92e; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX auth_group_permissions_permission_id_84c5c92e ON public.auth_group_permissions USING btree (permission_id);


--
-- Name: auth_permission_content_type_id_2f476e4b; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX auth_permission_content_type_id_2f476e4b ON public.auth_permission USING btree (content_type_id);


--
-- Name: auth_user_groups_group_id_97559544; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX auth_user_groups_group_id_97559544 ON public.auth_user_groups USING btree (group_id);


--
-- Name: auth_user_groups_user_id_6a12ed8b; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX auth_user_groups_user_id_6a12ed8b ON public.auth_user_groups USING btree (user_id);


--
-- Name: auth_user_user_permissions_permission_id_1fbb5f2c; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX auth_user_user_permissions_permission_id_1fbb5f2c ON public.auth_user_user_permissions USING btree (permission_id);


--
-- Name: auth_user_user_permissions_user_id_a95ead1b; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX auth_user_user_permissions_user_id_a95ead1b ON public.auth_user_user_permissions USING btree (user_id);


--
-- Name: django_admin_log_content_type_id_c4bce8eb; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX django_admin_log_content_type_id_c4bce8eb ON public.django_admin_log USING btree (content_type_id);


--
-- Name: django_admin_log_user_id_c564eba6; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX django_admin_log_user_id_c564eba6 ON public.django_admin_log USING btree (user_id);


--
-- Name: legal_agreements_legalacceptance_document_id_976b7012; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX legal_agreements_legalacceptance_document_id_976b7012 ON public.legal_agreements_legalacceptance USING btree (document_id);


--
-- Name: legal_agreements_legalacceptance_user_id_d70e0f5b; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX legal_agreements_legalacceptance_user_id_d70e0f5b ON public.legal_agreements_legalacceptance USING btree (user_id);


--
-- Name: legal_agreements_legaldocument_slug_1e30145c; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX legal_agreements_legaldocument_slug_1e30145c ON public.legal_agreements_legaldocument USING btree (slug);


--
-- Name: legal_agreements_legaldocument_slug_1e30145c_like; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX legal_agreements_legaldocument_slug_1e30145c_like ON public.legal_agreements_legaldocument USING btree (slug varchar_pattern_ops);


--
-- Name: legal_agreements_legalre_document_slug_c266061d_like; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX legal_agreements_legalre_document_slug_c266061d_like ON public.legal_agreements_legalremoteacceptance USING btree (document_slug varchar_pattern_ops);


--
-- Name: legal_agreements_legalremoteacceptance_document_slug_c266061d; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX legal_agreements_legalremoteacceptance_document_slug_c266061d ON public.legal_agreements_legalremoteacceptance USING btree (document_slug);


--
-- Name: mfa_authenticator_user_id_0c3a50c0; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX mfa_authenticator_user_id_0c3a50c0 ON public.mfa_authenticator USING btree (user_id);


--
-- Name: registrations_emailtemplate_template_type_1cdde2a3_like; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX registrations_emailtemplate_template_type_1cdde2a3_like ON public.registrations_emailtemplate USING btree (template_type varchar_pattern_ops);


--
-- Name: registrations_emailtemplate_updated_by_id_0e32d710; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX registrations_emailtemplate_updated_by_id_0e32d710 ON public.registrations_emailtemplate USING btree (updated_by_id);


--
-- Name: registrations_outboundmessage_created_by_id_971d9632; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX registrations_outboundmessage_created_by_id_971d9632 ON public.registrations_outboundmessage USING btree (created_by_id);


--
-- Name: registrations_outboundmessagerecipient_message_id_459f2de3; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX registrations_outboundmessagerecipient_message_id_459f2de3 ON public.registrations_outboundmessagerecipient USING btree (message_id);


--
-- Name: registrations_outboundmessagerecipient_registration_id_76f60593; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX registrations_outboundmessagerecipient_registration_id_76f60593 ON public.registrations_outboundmessagerecipient USING btree (registration_id);


--
-- Name: registrations_registration_approved_by_id_a9bb7b51; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX registrations_registration_approved_by_id_a9bb7b51 ON public.registrations_registration USING btree (approved_by_id);


--
-- Name: registrations_registration_removed_by_id_a6ecffb5; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX registrations_registration_removed_by_id_a6ecffb5 ON public.registrations_registration USING btree (removed_by_id);


--
-- Name: registrations_unique_name_email; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE UNIQUE INDEX registrations_unique_name_email ON public.registrations_registration USING btree (first_name, father_name, grandfather_name, email) WHERE ((email IS NOT NULL) AND (NOT ((status)::text = 'removed'::text)));


--
-- Name: registrations_unique_name_phone; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE UNIQUE INDEX registrations_unique_name_phone ON public.registrations_registration USING btree (first_name, father_name, grandfather_name, phone_number) WHERE ((NOT ((phone_number)::text = ''::text)) AND (NOT ((status)::text = 'removed'::text)));


--
-- Name: socialaccount_socialaccount_user_id_8146e70c; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX socialaccount_socialaccount_user_id_8146e70c ON public.socialaccount_socialaccount USING btree (user_id);


--
-- Name: unique_authenticator_type; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE UNIQUE INDEX unique_authenticator_type ON public.mfa_authenticator USING btree (user_id, type) WHERE ((type)::text = ANY ((ARRAY['totp'::character varying, 'recovery_codes'::character varying])::text[]));


--
-- Name: unique_primary_email; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE UNIQUE INDEX unique_primary_email ON public.account_emailaddress USING btree (user_id, "primary") WHERE "primary";


--
-- Name: unique_verified_email; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE UNIQUE INDEX unique_verified_email ON public.account_emailaddress USING btree (email) WHERE verified;


--
-- Name: website_sitepageseo_page_931bae77_like; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX website_sitepageseo_page_931bae77_like ON public.website_sitepageseo USING btree (page varchar_pattern_ops);


--
-- Name: website_socialmedia_name_34836fea_like; Type: INDEX; Schema: public; Owner: wenani_springinfor
--

CREATE INDEX website_socialmedia_name_34836fea_like ON public.website_socialmedia USING btree (name varchar_pattern_ops);


--
-- Name: account_emailaddress account_emailaddress_user_id_2c513194_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.account_emailaddress
    ADD CONSTRAINT account_emailaddress_user_id_2c513194_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_group_permissions auth_group_permissio_permission_id_84c5c92e_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissio_permission_id_84c5c92e_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES public.auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_group_permissions auth_group_permissions_group_id_b120cbf9_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_group_id_b120cbf9_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_permission auth_permission_content_type_id_2f476e4b_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.auth_permission
    ADD CONSTRAINT auth_permission_content_type_id_2f476e4b_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_groups auth_user_groups_group_id_97559544_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.auth_user_groups
    ADD CONSTRAINT auth_user_groups_group_id_97559544_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_groups auth_user_groups_user_id_6a12ed8b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.auth_user_groups
    ADD CONSTRAINT auth_user_groups_user_id_6a12ed8b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_user_permissions auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES public.auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_user_permissions auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: django_admin_log django_admin_log_content_type_id_c4bce8eb_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.django_admin_log
    ADD CONSTRAINT django_admin_log_content_type_id_c4bce8eb_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: django_admin_log django_admin_log_user_id_c564eba6_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.django_admin_log
    ADD CONSTRAINT django_admin_log_user_id_c564eba6_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: legal_agreements_legalacceptance legal_agreements_leg_document_id_976b7012_fk_legal_agr; Type: FK CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.legal_agreements_legalacceptance
    ADD CONSTRAINT legal_agreements_leg_document_id_976b7012_fk_legal_agr FOREIGN KEY (document_id) REFERENCES public.legal_agreements_legaldocument(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: legal_agreements_legalacceptance legal_agreements_leg_user_id_d70e0f5b_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.legal_agreements_legalacceptance
    ADD CONSTRAINT legal_agreements_leg_user_id_d70e0f5b_fk_auth_user FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: mfa_authenticator mfa_authenticator_user_id_0c3a50c0_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.mfa_authenticator
    ADD CONSTRAINT mfa_authenticator_user_id_0c3a50c0_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: registrations_emailtemplate registrations_emailt_updated_by_id_0e32d710_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.registrations_emailtemplate
    ADD CONSTRAINT registrations_emailt_updated_by_id_0e32d710_fk_auth_user FOREIGN KEY (updated_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: registrations_outboundmessage registrations_outbou_created_by_id_971d9632_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.registrations_outboundmessage
    ADD CONSTRAINT registrations_outbou_created_by_id_971d9632_fk_auth_user FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: registrations_outboundmessagerecipient registrations_outbou_message_id_459f2de3_fk_registrat; Type: FK CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.registrations_outboundmessagerecipient
    ADD CONSTRAINT registrations_outbou_message_id_459f2de3_fk_registrat FOREIGN KEY (message_id) REFERENCES public.registrations_outboundmessage(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: registrations_outboundmessagerecipient registrations_outbou_registration_id_76f60593_fk_registrat; Type: FK CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.registrations_outboundmessagerecipient
    ADD CONSTRAINT registrations_outbou_registration_id_76f60593_fk_registrat FOREIGN KEY (registration_id) REFERENCES public.registrations_registration(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: registrations_pendingregistration registrations_pendin_completed_registrati_f4cc1fbe_fk_registrat; Type: FK CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.registrations_pendingregistration
    ADD CONSTRAINT registrations_pendin_completed_registrati_f4cc1fbe_fk_registrat FOREIGN KEY (completed_registration_id) REFERENCES public.registrations_registration(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: registrations_registration registrations_regist_approved_by_id_a9bb7b51_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.registrations_registration
    ADD CONSTRAINT registrations_regist_approved_by_id_a9bb7b51_fk_auth_user FOREIGN KEY (approved_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: registrations_registration registrations_regist_removed_by_id_a6ecffb5_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.registrations_registration
    ADD CONSTRAINT registrations_regist_removed_by_id_a6ecffb5_fk_auth_user FOREIGN KEY (removed_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: socialaccount_socialaccount socialaccount_socialaccount_user_id_8146e70c_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: wenani_springinfor
--

ALTER TABLE ONLY public.socialaccount_socialaccount
    ADD CONSTRAINT socialaccount_socialaccount_user_id_8146e70c_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


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

REVOKE ALL ON SCHEMA public FROM isaaktecle;
REVOKE ALL ON SCHEMA public FROM PUBLIC;
GRANT ALL ON SCHEMA public TO wenani_springinfor;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
--

