database_dump.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 17.5 (6bc9ef8)
-- Dumped by pg_dump version 17.5

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: public; Type: SCHEMA; Schema: -; Owner: neondb_owner
--

-- *not* creating schema, since initdb creates it


ALTER SCHEMA public OWNER TO neondb_owner;

--
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: neondb_owner
--

COMMENT ON SCHEMA public IS '';


--
-- Name: topology; Type: SCHEMA; Schema: -; Owner: neondb_owner
--

CREATE SCHEMA topology;


ALTER SCHEMA topology OWNER TO neondb_owner;

--
-- Name: SCHEMA topology; Type: COMMENT; Schema: -; Owner: neondb_owner
--

COMMENT ON SCHEMA topology IS 'PostGIS Topology schema';


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

CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public;


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

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


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

CREATE EXTENSION IF NOT EXISTS postgis_topology WITH SCHEMA topology;


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

COMMENT ON EXTENSION postgis_topology IS 'PostGIS topology spatial types and functions';


--
-- Name: activitystatusenum; Type: TYPE; Schema: public; Owner: neondb_owner
--

CREATE TYPE public.activitystatusenum AS ENUM (
    'ACTIVE',
    'INACTIVE',
    'PENDING',
    'SUSPENDED'
);


ALTER TYPE public.activitystatusenum OWNER TO neondb_owner;

--
-- Name: interactiontypeenum; Type: TYPE; Schema: public; Owner: neondb_owner
--

CREATE TYPE public.interactiontypeenum AS ENUM (
    'SEARCH',
    'VIEW',
    'CLICK',
    'CALL',
    'WHATSAPP',
    'EMAIL',
    'WEBSITE',
    'DIRECTION'
);


ALTER TYPE public.interactiontypeenum OWNER TO neondb_owner;

--
-- Name: verificationstatusenum; Type: TYPE; Schema: public; Owner: neondb_owner
--

CREATE TYPE public.verificationstatusenum AS ENUM (
    'PENDING',
    'APPROVED',
    'REJECTED'
);


ALTER TYPE public.verificationstatusenum OWNER TO neondb_owner;

--
-- Name: calculate_distance(numeric, numeric, numeric, numeric); Type: FUNCTION; Schema: public; Owner: neondb_owner
--

CREATE FUNCTION public.calculate_distance(lat1 numeric, lon1 numeric, lat2 numeric, lon2 numeric) RETURNS numeric
    LANGUAGE plpgsql
    AS $$

BEGIN

    RETURN ST_Distance(

        ST_SetSRID(ST_MakePoint(lon1, lat1), 4326),

        ST_SetSRID(ST_MakePoint(lon2, lat2), 4326)

    );

END;

$$;


ALTER FUNCTION public.calculate_distance(lat1 numeric, lon1 numeric, lat2 numeric, lon2 numeric) OWNER TO neondb_owner;

--
-- Name: find_activities_in_radius(numeric, numeric, integer, character varying, integer); Type: FUNCTION; Schema: public; Owner: neondb_owner
--

CREATE FUNCTION public.find_activities_in_radius(user_lat numeric, user_lon numeric, radius_meters integer DEFAULT 5000, activity_type_filter character varying DEFAULT NULL::character varying, category_filter integer DEFAULT NULL::integer) RETURNS TABLE(activity_id integer, name character varying, distance_meters numeric, activity_type character varying, category_name character varying, rating numeric, is_open boolean)
    LANGUAGE plpgsql
    AS $$

BEGIN

    RETURN QUERY

    SELECT 

        a.id,

        a.name,

        ST_Distance(

            a.location,

            ST_SetSRID(ST_MakePoint(user_lon, user_lat), 4326)

        ) as distance,

        at.name as activity_type,

        c.name as category,

        a.rating,

        a.is_open

    FROM activities a

    LEFT JOIN activity_types at ON a.activity_type_id = at.id

    LEFT JOIN categories c ON a.category_id = c.id

    WHERE 

        a.is_active = TRUE

        AND ST_DWithin(

            a.location,

            ST_SetSRID(ST_MakePoint(user_lon, user_lat), 4326),

            radius_meters

        )

        AND (activity_type_filter IS NULL OR at.slug = activity_type_filter)

        AND (category_filter IS NULL OR a.category_id = category_filter)

    ORDER BY distance;

END;

$$;


ALTER FUNCTION public.find_activities_in_radius(user_lat numeric, user_lon numeric, radius_meters integer, activity_type_filter character varying, category_filter integer) OWNER TO neondb_owner;

--
-- Name: update_activity_stats(); Type: FUNCTION; Schema: public; Owner: neondb_owner
--

CREATE FUNCTION public.update_activity_stats() RETURNS trigger
    LANGUAGE plpgsql
    AS $$

BEGIN

    IF TG_OP = 'INSERT' OR TG_OP = 'UPDATE' THEN

        -- Mettre ├á jour les statistiques de l'activit├®

        UPDATE activities 

        SET 

            rating = (

                SELECT COALESCE(AVG(rating), 0) 

                FROM reviews 

                WHERE activity_id = NEW.activity_id AND is_approved = TRUE

            ),

            review_count = (

                SELECT COUNT(*) 

                FROM reviews 

                WHERE activity_id = NEW.activity_id AND is_approved = TRUE

            )

        WHERE id = NEW.activity_id;

    END IF;

    

    RETURN COALESCE(NEW, OLD);

END;

$$;


ALTER FUNCTION public.update_activity_stats() OWNER TO neondb_owner;

--
-- Name: update_updated_at_column(); Type: FUNCTION; Schema: public; Owner: neondb_owner
--

CREATE FUNCTION public.update_updated_at_column() RETURNS trigger
    LANGUAGE plpgsql
    AS $$

BEGIN

    NEW.updated_at = NOW();

    RETURN NEW;

END;

$$;


ALTER FUNCTION public.update_updated_at_column() OWNER TO neondb_owner;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: activities; Type: TABLE; Schema: public; Owner: neondb_owner
--

CREATE TABLE public.activities (
    id integer NOT NULL,
    name character varying(255) NOT NULL,
    slug character varying(255) NOT NULL,
    description text,
    short_description character varying(500),
    activity_type_id integer,
    category_id integer,
    address text,
    location public.geometry(Point,4326) NOT NULL,
    zone_id integer,
    phone_number character varying(20),
    whatsapp_number character varying(20),
    email character varying(255),
    website character varying(500),
    is_verified boolean DEFAULT false,
    is_active boolean DEFAULT true,
    is_open boolean DEFAULT true,
    verification_level integer DEFAULT 0,
    owner_id integer,
    manager_id integer,
    ambassador_id integer,
    price_level integer DEFAULT 1,
    accepts_cash boolean DEFAULT true,
    accepts_card boolean DEFAULT false,
    accepts_mobile_money boolean DEFAULT false,
    opening_hours jsonb DEFAULT '{}'::jsonb,
    special_hours jsonb DEFAULT '{}'::jsonb,
    rating numeric(3,2) DEFAULT 0.0,
    review_count integer DEFAULT 0,
    view_count integer DEFAULT 0,
    search_count integer DEFAULT 0,
    cover_image_url text,
    logo_url text,
    tags text[],
    keywords text[],
    languages character varying(10)[],
    custom_data jsonb DEFAULT '{}'::jsonb,
    created_at timestamp with time zone DEFAULT now(),
    updated_at timestamp with time zone DEFAULT now(),
    verified_at timestamp with time zone,
    last_activity_at timestamp with time zone DEFAULT now()
);


ALTER TABLE public.activities OWNER TO neondb_owner;

--
-- Name: TABLE activities; Type: COMMENT; Schema: public; Owner: neondb_owner
--

COMMENT ON TABLE public.activities IS 'Table principale des activit├®s - remplace merchants pour plus de polyvalence';


--
-- Name: activity_types; Type: TABLE; Schema: public; Owner: neondb_owner
--

CREATE TABLE public.activity_types (
    id integer NOT NULL,
    name character varying(100) NOT NULL,
    slug character varying(100) NOT NULL,
    description text,
    category_id integer,
    requires_verification boolean DEFAULT false,
    allows_online_booking boolean DEFAULT false,
    allows_delivery boolean DEFAULT false,
    is_public boolean DEFAULT true,
    created_at timestamp with time zone DEFAULT now()
);


ALTER TABLE public.activity_types OWNER TO neondb_owner;

--
-- Name: TABLE activity_types; Type: COMMENT; Schema: public; Owner: neondb_owner
--

COMMENT ON TABLE public.activity_types IS 'Types d''activit├®s possibles (restaurant, pharmacie, ├®cole, etc.)';


--
-- Name: ambassadors; Type: TABLE; Schema: public; Owner: neondb_owner
--

CREATE TABLE public.ambassadors (
    id integer NOT NULL,
    user_id integer,
    full_name character varying(255) NOT NULL,
    id_document_type character varying(50),
    id_document_number character varying(100),
    id_document_image_url text,
    status character varying(20) DEFAULT 'pending'::character varying,
    level integer DEFAULT 1,
    points integer DEFAULT 0,
    assigned_zones integer[],
    max_activities integer DEFAULT 10,
    activities_created integer DEFAULT 0,
    activities_verified integer DEFAULT 0,
    verification_accuracy numeric(3,2) DEFAULT 0.0,
    created_at timestamp with time zone DEFAULT now(),
    updated_at timestamp with time zone DEFAULT now(),
    approved_at timestamp with time zone
);


ALTER TABLE public.ambassadors OWNER TO neondb_owner;

--
-- Name: categories; Type: TABLE; Schema: public; Owner: neondb_owner
--

CREATE TABLE public.categories (
    id integer NOT NULL,
    name character varying(100) NOT NULL,
    slug character varying(100) NOT NULL,
    description text,
    icon character varying(100),
    color character varying(7),
    parent_id integer,
    level integer DEFAULT 0,
    is_active boolean DEFAULT true,
    sort_order integer DEFAULT 0,
    created_at timestamp with time zone DEFAULT now()
);


ALTER TABLE public.categories OWNER TO neondb_owner;

--
-- Name: cities; Type: TABLE; Schema: public; Owner: neondb_owner
--

CREATE TABLE public.cities (
    id integer NOT NULL,
    region_id integer,
    name character varying(100) NOT NULL,
    population integer,
    geometry public.geometry(MultiPolygon,4326),
    center_point public.geometry(Point,4326),
    created_at timestamp with time zone DEFAULT now()
);


ALTER TABLE public.cities OWNER TO neondb_owner;

--
-- Name: countries; Type: TABLE; Schema: public; Owner: neondb_owner
--

CREATE TABLE public.countries (
    id integer NOT NULL,
    name character varying(100) NOT NULL,
    code character varying(3) NOT NULL,
    currency character varying(3),
    timezone character varying(50),
    geometry public.geometry(MultiPolygon,4326),
    created_at timestamp with time zone DEFAULT now()
);


ALTER TABLE public.countries OWNER TO neondb_owner;

--
-- Name: regions; Type: TABLE; Schema: public; Owner: neondb_owner
--

CREATE TABLE public.regions (
    id integer NOT NULL,
    country_id integer,
    name character varying(100) NOT NULL,
    code character varying(10),
    geometry public.geometry(MultiPolygon,4326),
    created_at timestamp with time zone DEFAULT now()
);


ALTER TABLE public.regions OWNER TO neondb_owner;

--
-- Name: users; Type: TABLE; Schema: public; Owner: neondb_owner
--

CREATE TABLE public.users (
    id integer NOT NULL,
    phone_number character varying(20) NOT NULL,
    email character varying(255),
    full_name character varying(255),
    avatar_url text,
    is_verified boolean DEFAULT false,
    is_active boolean DEFAULT true,
    last_location public.geometry(Point,4326),
    preferred_language character varying(5) DEFAULT 'fr'::character varying,
    timezone character varying(50) DEFAULT 'Africa/Abidjan'::character varying,
    created_at timestamp with time zone DEFAULT now(),
    updated_at timestamp with time zone DEFAULT now(),
    last_seen timestamp with time zone DEFAULT now()
);


ALTER TABLE public.users OWNER TO neondb_owner;

--
-- Name: zones; Type: TABLE; Schema: public; Owner: neondb_owner
--

CREATE TABLE public.zones (
    id integer NOT NULL,
    city_id integer,
    name character varying(100) NOT NULL,
    type character varying(50) DEFAULT 'neighborhood'::character varying,
    geometry public.geometry(MultiPolygon,4326),
    center_point public.geometry(Point,4326),
    population integer,
    created_at timestamp with time zone DEFAULT now()
);


ALTER TABLE public.zones OWNER TO neondb_owner;

--
-- Name: TABLE zones; Type: COMMENT; Schema: public; Owner: neondb_owner
--

COMMENT ON TABLE public.zones IS 'Zones g├®ographiques pour la localisation et le ciblage';


--
-- Name: activities_full; Type: VIEW; Schema: public; Owner: neondb_owner
--

CREATE VIEW public.activities_full AS
 SELECT a.id,
    a.name,
    a.slug,
    a.description,
    a.short_description,
    a.activity_type_id,
    a.category_id,
    a.address,
    a.location,
    a.zone_id,
    a.phone_number,
    a.whatsapp_number,
    a.email,
    a.website,
    a.is_verified,
    a.is_active,
    a.is_open,
    a.verification_level,
    a.owner_id,
    a.manager_id,
    a.ambassador_id,
    a.price_level,
    a.accepts_cash,
    a.accepts_card,
    a.accepts_mobile_money,
    a.opening_hours,
    a.special_hours,
    a.rating,
    a.review_count,
    a.view_count,
    a.search_count,
    a.cover_image_url,
    a.logo_url,
    a.tags,
    a.keywords,
    a.languages,
    a.custom_data,
    a.created_at,
    a.updated_at,
    a.verified_at,
    a.last_activity_at,
    at.name AS activity_type_name,
    at.slug AS activity_type_slug,
    c.name AS category_name,
    c.slug AS category_slug,
    z.name AS zone_name,
    z.type AS zone_type,
    ci.name AS city_name,
    r.name AS region_name,
    co.name AS country_name,
    u.full_name AS owner_name,
    amb.full_name AS ambassador_name,
    public.st_x(a.location) AS longitude,
    public.st_y(a.location) AS latitude
   FROM ((((((((public.activities a
     LEFT JOIN public.activity_types at ON ((a.activity_type_id = at.id)))
     LEFT JOIN public.categories c ON ((a.category_id = c.id)))
     LEFT JOIN public.zones z ON ((a.zone_id = z.id)))
     LEFT JOIN public.cities ci ON ((z.city_id = ci.id)))
     LEFT JOIN public.regions r ON ((ci.region_id = r.id)))
     LEFT JOIN public.countries co ON ((r.country_id = co.id)))
     LEFT JOIN public.users u ON ((a.owner_id = u.id)))
     LEFT JOIN public.ambassadors amb ON ((a.ambassador_id = amb.user_id)));


ALTER VIEW public.activities_full OWNER TO neondb_owner;

--
-- Name: activities_id_seq; Type: SEQUENCE; Schema: public; Owner: neondb_owner
--

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


ALTER SEQUENCE public.activities_id_seq OWNER TO neondb_owner;

--
-- Name: activities_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: neondb_owner
--

ALTER SEQUENCE public.activities_id_seq OWNED BY public.activities.id;


--
-- Name: activity_types_id_seq; Type: SEQUENCE; Schema: public; Owner: neondb_owner
--

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


ALTER SEQUENCE public.activity_types_id_seq OWNER TO neondb_owner;

--
-- Name: activity_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: neondb_owner
--

ALTER SEQUENCE public.activity_types_id_seq OWNED BY public.activity_types.id;


--
-- Name: ambassadors_id_seq; Type: SEQUENCE; Schema: public; Owner: neondb_owner
--

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


ALTER SEQUENCE public.ambassadors_id_seq OWNER TO neondb_owner;

--
-- Name: ambassadors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: neondb_owner
--

ALTER SEQUENCE public.ambassadors_id_seq OWNED BY public.ambassadors.id;


--
-- Name: audit_logs; Type: TABLE; Schema: public; Owner: neondb_owner
--

CREATE TABLE public.audit_logs (
    id integer NOT NULL,
    user_id integer,
    action character varying(100) NOT NULL,
    table_name character varying(100),
    record_id integer,
    old_values jsonb,
    new_values jsonb,
    ip_address inet,
    user_agent text,
    session_id character varying(100),
    created_at timestamp with time zone DEFAULT now()
);


ALTER TABLE public.audit_logs OWNER TO neondb_owner;

--
-- Name: audit_logs_id_seq; Type: SEQUENCE; Schema: public; Owner: neondb_owner
--

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


ALTER SEQUENCE public.audit_logs_id_seq OWNER TO neondb_owner;

--
-- Name: audit_logs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: neondb_owner
--

ALTER SEQUENCE public.audit_logs_id_seq OWNED BY public.audit_logs.id;


--
-- Name: categories_id_seq; Type: SEQUENCE; Schema: public; Owner: neondb_owner
--

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


ALTER SEQUENCE public.categories_id_seq OWNER TO neondb_owner;

--
-- Name: categories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: neondb_owner
--

ALTER SEQUENCE public.categories_id_seq OWNED BY public.categories.id;


--
-- Name: cities_id_seq; Type: SEQUENCE; Schema: public; Owner: neondb_owner
--

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


ALTER SEQUENCE public.cities_id_seq OWNER TO neondb_owner;

--
-- Name: cities_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: neondb_owner
--

ALTER SEQUENCE public.cities_id_seq OWNED BY public.cities.id;


--
-- Name: conversations; Type: TABLE; Schema: public; Owner: neondb_owner
--

CREATE TABLE public.conversations (
    id integer NOT NULL,
    user_id integer,
    session_id character varying(100),
    context jsonb DEFAULT '{}'::jsonb,
    user_location public.geometry(Point,4326),
    status character varying(20) DEFAULT 'active'::character varying,
    language character varying(5) DEFAULT 'fr'::character varying,
    created_at timestamp with time zone DEFAULT now(),
    updated_at timestamp with time zone DEFAULT now(),
    last_message_at timestamp with time zone DEFAULT now()
);


ALTER TABLE public.conversations OWNER TO neondb_owner;

--
-- Name: conversations_id_seq; Type: SEQUENCE; Schema: public; Owner: neondb_owner
--

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


ALTER SEQUENCE public.conversations_id_seq OWNER TO neondb_owner;

--
-- Name: conversations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: neondb_owner
--

ALTER SEQUENCE public.conversations_id_seq OWNED BY public.conversations.id;


--
-- Name: countries_id_seq; Type: SEQUENCE; Schema: public; Owner: neondb_owner
--

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


ALTER SEQUENCE public.countries_id_seq OWNER TO neondb_owner;

--
-- Name: countries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: neondb_owner
--

ALTER SEQUENCE public.countries_id_seq OWNED BY public.countries.id;


--
-- Name: data_models; Type: TABLE; Schema: public; Owner: neondb_owner
--

CREATE TABLE public.data_models (
    id integer NOT NULL,
    name character varying(100) NOT NULL,
    description text,
    model_type character varying(50) NOT NULL,
    parameters jsonb DEFAULT '{}'::jsonb,
    training_data jsonb DEFAULT '{}'::jsonb,
    accuracy numeric(5,4),
    precision_score numeric(5,4),
    recall_score numeric(5,4),
    f1_score numeric(5,4),
    status character varying(20) DEFAULT 'draft'::character varying,
    version character varying(20) DEFAULT '1.0.0'::character varying,
    created_at timestamp with time zone DEFAULT now(),
    updated_at timestamp with time zone DEFAULT now(),
    trained_at timestamp with time zone
);


ALTER TABLE public.data_models OWNER TO neondb_owner;

--
-- Name: TABLE data_models; Type: COMMENT; Schema: public; Owner: neondb_owner
--

COMMENT ON TABLE public.data_models IS 'Mod├¿les de machine learning entra├«n├®s sur les donn├®es';


--
-- Name: data_models_id_seq; Type: SEQUENCE; Schema: public; Owner: neondb_owner
--

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


ALTER SEQUENCE public.data_models_id_seq OWNER TO neondb_owner;

--
-- Name: data_models_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: neondb_owner
--

ALTER SEQUENCE public.data_models_id_seq OWNED BY public.data_models.id;


--
-- Name: insights; Type: TABLE; Schema: public; Owner: neondb_owner
--

CREATE TABLE public.insights (
    id integer NOT NULL,
    title character varying(255) NOT NULL,
    description text,
    insight_type character varying(50) NOT NULL,
    data jsonb NOT NULL,
    visualization_config jsonb DEFAULT '{}'::jsonb,
    source_tables text[],
    filters_applied jsonb DEFAULT '{}'::jsonb,
    confidence_level numeric(3,2),
    target_audience character varying(50) DEFAULT 'all'::character varying,
    is_public boolean DEFAULT false,
    created_at timestamp with time zone DEFAULT now(),
    expires_at timestamp with time zone
);


ALTER TABLE public.insights OWNER TO neondb_owner;

--
-- Name: TABLE insights; Type: COMMENT; Schema: public; Owner: neondb_owner
--

COMMENT ON TABLE public.insights IS 'Insights g├®n├®r├®s par l''IA ├á partir des donn├®es collect├®es';


--
-- Name: insights_id_seq; Type: SEQUENCE; Schema: public; Owner: neondb_owner
--

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


ALTER SEQUENCE public.insights_id_seq OWNER TO neondb_owner;

--
-- Name: insights_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: neondb_owner
--

ALTER SEQUENCE public.insights_id_seq OWNED BY public.insights.id;


--
-- Name: media; Type: TABLE; Schema: public; Owner: neondb_owner
--

CREATE TABLE public.media (
    id integer NOT NULL,
    activity_id integer,
    user_id integer,
    file_url text NOT NULL,
    file_type character varying(50) NOT NULL,
    mime_type character varying(100),
    file_size integer,
    title character varying(255),
    description text,
    alt_text character varying(255),
    width integer,
    height integer,
    duration integer,
    category character varying(50) DEFAULT 'general'::character varying,
    is_primary boolean DEFAULT false,
    is_public boolean DEFAULT true,
    is_approved boolean DEFAULT true,
    moderation_notes text,
    created_at timestamp with time zone DEFAULT now(),
    updated_at timestamp with time zone DEFAULT now()
);


ALTER TABLE public.media OWNER TO neondb_owner;

--
-- Name: media_id_seq; Type: SEQUENCE; Schema: public; Owner: neondb_owner
--

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


ALTER SEQUENCE public.media_id_seq OWNER TO neondb_owner;

--
-- Name: media_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: neondb_owner
--

ALTER SEQUENCE public.media_id_seq OWNED BY public.media.id;


--
-- Name: messages; Type: TABLE; Schema: public; Owner: neondb_owner
--

CREATE TABLE public.messages (
    id integer NOT NULL,
    conversation_id integer,
    sender character varying(20) NOT NULL,
    content text NOT NULL,
    message_type character varying(20) DEFAULT 'text'::character varying,
    intent character varying(50),
    entities jsonb DEFAULT '{}'::jsonb,
    confidence_score numeric(3,2),
    processing_time_ms integer,
    referenced_activities integer[],
    referenced_categories integer[],
    created_at timestamp with time zone DEFAULT now()
);


ALTER TABLE public.messages OWNER TO neondb_owner;

--
-- Name: messages_id_seq; Type: SEQUENCE; Schema: public; Owner: neondb_owner
--

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


ALTER SEQUENCE public.messages_id_seq OWNER TO neondb_owner;

--
-- Name: messages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: neondb_owner
--

ALTER SEQUENCE public.messages_id_seq OWNED BY public.messages.id;


--
-- Name: notifications; Type: TABLE; Schema: public; Owner: neondb_owner
--

CREATE TABLE public.notifications (
    id integer NOT NULL,
    user_id integer,
    title character varying(255) NOT NULL,
    message text NOT NULL,
    notification_type character varying(50) NOT NULL,
    target_activity_id integer,
    target_zone_id integer,
    is_read boolean DEFAULT false,
    is_push_sent boolean DEFAULT false,
    is_sms_sent boolean DEFAULT false,
    is_email_sent boolean DEFAULT false,
    data jsonb DEFAULT '{}'::jsonb,
    created_at timestamp with time zone DEFAULT now(),
    read_at timestamp with time zone
);


ALTER TABLE public.notifications OWNER TO neondb_owner;

--
-- Name: notifications_id_seq; Type: SEQUENCE; Schema: public; Owner: neondb_owner
--

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


ALTER SEQUENCE public.notifications_id_seq OWNER TO neondb_owner;

--
-- Name: notifications_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: neondb_owner
--

ALTER SEQUENCE public.notifications_id_seq OWNED BY public.notifications.id;


--
-- Name: regions_id_seq; Type: SEQUENCE; Schema: public; Owner: neondb_owner
--

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


ALTER SEQUENCE public.regions_id_seq OWNER TO neondb_owner;

--
-- Name: regions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: neondb_owner
--

ALTER SEQUENCE public.regions_id_seq OWNED BY public.regions.id;


--
-- Name: reviews; Type: TABLE; Schema: public; Owner: neondb_owner
--

CREATE TABLE public.reviews (
    id integer NOT NULL,
    activity_id integer,
    user_id integer,
    rating integer NOT NULL,
    title character varying(255),
    comment text,
    category_ratings jsonb DEFAULT '{}'::jsonb,
    photos text[],
    helpful_count integer DEFAULT 0,
    is_verified_purchase boolean DEFAULT false,
    is_approved boolean DEFAULT true,
    is_flagged boolean DEFAULT false,
    moderation_notes text,
    created_at timestamp with time zone DEFAULT now(),
    updated_at timestamp with time zone DEFAULT now(),
    CONSTRAINT reviews_rating_check CHECK (((rating >= 1) AND (rating <= 5)))
);


ALTER TABLE public.reviews OWNER TO neondb_owner;

--
-- Name: reviews_id_seq; Type: SEQUENCE; Schema: public; Owner: neondb_owner
--

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


ALTER SEQUENCE public.reviews_id_seq OWNER TO neondb_owner;

--
-- Name: reviews_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: neondb_owner
--

ALTER SEQUENCE public.reviews_id_seq OWNED BY public.reviews.id;


--
-- Name: roles; Type: TABLE; Schema: public; Owner: neondb_owner
--

CREATE TABLE public.roles (
    id integer NOT NULL,
    name character varying(50) NOT NULL,
    description text,
    permissions jsonb DEFAULT '{}'::jsonb,
    is_system boolean DEFAULT false,
    created_at timestamp with time zone DEFAULT now()
);


ALTER TABLE public.roles OWNER TO neondb_owner;

--
-- Name: roles_id_seq; Type: SEQUENCE; Schema: public; Owner: neondb_owner
--

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


ALTER SEQUENCE public.roles_id_seq OWNER TO neondb_owner;

--
-- Name: roles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: neondb_owner
--

ALTER SEQUENCE public.roles_id_seq OWNED BY public.roles.id;


--
-- Name: search_logs; Type: TABLE; Schema: public; Owner: neondb_owner
--

CREATE TABLE public.search_logs (
    id integer NOT NULL,
    user_id integer,
    session_id character varying(100),
    query text NOT NULL,
    processed_query text,
    language character varying(5) DEFAULT 'fr'::character varying,
    user_location public.geometry(Point,4326),
    search_radius integer DEFAULT 5000,
    filters jsonb DEFAULT '{}'::jsonb,
    results_count integer DEFAULT 0,
    results_ids integer[],
    intent character varying(50),
    entities jsonb DEFAULT '{}'::jsonb,
    confidence_score numeric(3,2),
    search_time_ms integer,
    created_at timestamp with time zone DEFAULT now()
);


ALTER TABLE public.search_logs OWNER TO neondb_owner;

--
-- Name: TABLE search_logs; Type: COMMENT; Schema: public; Owner: neondb_owner
--

COMMENT ON TABLE public.search_logs IS 'Logs des recherches pour l''am├®lioration de l''IA';


--
-- Name: search_logs_id_seq; Type: SEQUENCE; Schema: public; Owner: neondb_owner
--

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


ALTER SEQUENCE public.search_logs_id_seq OWNER TO neondb_owner;

--
-- Name: search_logs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: neondb_owner
--

ALTER SEQUENCE public.search_logs_id_seq OWNED BY public.search_logs.id;


--
-- Name: service_zones; Type: TABLE; Schema: public; Owner: neondb_owner
--

CREATE TABLE public.service_zones (
    id integer NOT NULL,
    activity_id integer,
    activity_type character varying(50),
    zone_id integer,
    radius_meters integer DEFAULT 5000,
    is_primary boolean DEFAULT true,
    created_at timestamp with time zone DEFAULT now()
);


ALTER TABLE public.service_zones OWNER TO neondb_owner;

--
-- Name: service_zones_id_seq; Type: SEQUENCE; Schema: public; Owner: neondb_owner
--

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


ALTER SEQUENCE public.service_zones_id_seq OWNER TO neondb_owner;

--
-- Name: service_zones_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: neondb_owner
--

ALTER SEQUENCE public.service_zones_id_seq OWNED BY public.service_zones.id;


--
-- Name: subscription_plans; Type: TABLE; Schema: public; Owner: neondb_owner
--

CREATE TABLE public.subscription_plans (
    id integer NOT NULL,
    name character varying(100) NOT NULL,
    description text,
    price_monthly numeric(10,2),
    price_yearly numeric(10,2),
    currency character varying(3) DEFAULT 'XOF'::character varying,
    max_activities integer,
    max_photos_per_activity integer,
    max_ambassadors integer,
    features jsonb DEFAULT '{}'::jsonb,
    is_active boolean DEFAULT true,
    is_popular boolean DEFAULT false,
    created_at timestamp with time zone DEFAULT now(),
    updated_at timestamp with time zone DEFAULT now()
);


ALTER TABLE public.subscription_plans OWNER TO neondb_owner;

--
-- Name: subscription_plans_id_seq; Type: SEQUENCE; Schema: public; Owner: neondb_owner
--

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


ALTER SEQUENCE public.subscription_plans_id_seq OWNER TO neondb_owner;

--
-- Name: subscription_plans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: neondb_owner
--

ALTER SEQUENCE public.subscription_plans_id_seq OWNED BY public.subscription_plans.id;


--
-- Name: subscriptions; Type: TABLE; Schema: public; Owner: neondb_owner
--

CREATE TABLE public.subscriptions (
    id integer NOT NULL,
    user_id integer,
    plan_id integer,
    status character varying(20) DEFAULT 'active'::character varying,
    payment_status character varying(20) DEFAULT 'pending'::character varying,
    started_at timestamp with time zone DEFAULT now(),
    expires_at timestamp with time zone,
    cancelled_at timestamp with time zone,
    payment_method character varying(50),
    transaction_id character varying(255),
    created_at timestamp with time zone DEFAULT now(),
    updated_at timestamp with time zone DEFAULT now()
);


ALTER TABLE public.subscriptions OWNER TO neondb_owner;

--
-- Name: subscriptions_id_seq; Type: SEQUENCE; Schema: public; Owner: neondb_owner
--

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


ALTER SEQUENCE public.subscriptions_id_seq OWNER TO neondb_owner;

--
-- Name: subscriptions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: neondb_owner
--

ALTER SEQUENCE public.subscriptions_id_seq OWNED BY public.subscriptions.id;


--
-- Name: user_interactions; Type: TABLE; Schema: public; Owner: neondb_owner
--

CREATE TABLE public.user_interactions (
    id integer NOT NULL,
    user_id integer,
    activity_id integer,
    interaction_type character varying(50) NOT NULL,
    session_id character varying(100),
    referrer character varying(500),
    user_agent text,
    ip_address inet,
    metadata jsonb DEFAULT '{}'::jsonb,
    created_at timestamp with time zone DEFAULT now()
);


ALTER TABLE public.user_interactions OWNER TO neondb_owner;

--
-- Name: user_interactions_id_seq; Type: SEQUENCE; Schema: public; Owner: neondb_owner
--

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


ALTER SEQUENCE public.user_interactions_id_seq OWNER TO neondb_owner;

--
-- Name: user_interactions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: neondb_owner
--

ALTER SEQUENCE public.user_interactions_id_seq OWNED BY public.user_interactions.id;


--
-- Name: user_roles; Type: TABLE; Schema: public; Owner: neondb_owner
--

CREATE TABLE public.user_roles (
    id integer NOT NULL,
    user_id integer,
    role_id integer,
    assigned_by integer,
    assigned_at timestamp with time zone DEFAULT now(),
    expires_at timestamp with time zone,
    is_active boolean DEFAULT true
);


ALTER TABLE public.user_roles OWNER TO neondb_owner;

--
-- Name: user_roles_id_seq; Type: SEQUENCE; Schema: public; Owner: neondb_owner
--

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


ALTER SEQUENCE public.user_roles_id_seq OWNER TO neondb_owner;

--
-- Name: user_roles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: neondb_owner
--

ALTER SEQUENCE public.user_roles_id_seq OWNED BY public.user_roles.id;


--
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: neondb_owner
--

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


ALTER SEQUENCE public.users_id_seq OWNER TO neondb_owner;

--
-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: neondb_owner
--

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


--
-- Name: verifications; Type: TABLE; Schema: public; Owner: neondb_owner
--

CREATE TABLE public.verifications (
    id integer NOT NULL,
    activity_id integer,
    ambassador_id integer,
    verification_type character varying(50) NOT NULL,
    status character varying(20) DEFAULT 'pending'::character varying,
    verification_data jsonb DEFAULT '{}'::jsonb,
    notes text,
    photos text[],
    created_at timestamp with time zone DEFAULT now(),
    completed_at timestamp with time zone
);


ALTER TABLE public.verifications OWNER TO neondb_owner;

--
-- Name: verifications_id_seq; Type: SEQUENCE; Schema: public; Owner: neondb_owner
--

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


ALTER SEQUENCE public.verifications_id_seq OWNER TO neondb_owner;

--
-- Name: verifications_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: neondb_owner
--

ALTER SEQUENCE public.verifications_id_seq OWNED BY public.verifications.id;


--
-- Name: webhook_logs; Type: TABLE; Schema: public; Owner: neondb_owner
--

CREATE TABLE public.webhook_logs (
    id integer NOT NULL,
    webhook_id integer,
    event_type character varying(50) NOT NULL,
    payload jsonb NOT NULL,
    status character varying(20) NOT NULL,
    response_code integer,
    response_body text,
    error_message text,
    created_at timestamp with time zone DEFAULT now(),
    processed_at timestamp with time zone
);


ALTER TABLE public.webhook_logs OWNER TO neondb_owner;

--
-- Name: webhook_logs_id_seq; Type: SEQUENCE; Schema: public; Owner: neondb_owner
--

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


ALTER SEQUENCE public.webhook_logs_id_seq OWNER TO neondb_owner;

--
-- Name: webhook_logs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: neondb_owner
--

ALTER SEQUENCE public.webhook_logs_id_seq OWNED BY public.webhook_logs.id;


--
-- Name: webhooks; Type: TABLE; Schema: public; Owner: neondb_owner
--

CREATE TABLE public.webhooks (
    id integer NOT NULL,
    name character varying(100) NOT NULL,
    url text NOT NULL,
    secret_key character varying(255),
    events text[] NOT NULL,
    is_active boolean DEFAULT true,
    retry_count integer DEFAULT 3,
    success_count integer DEFAULT 0,
    failure_count integer DEFAULT 0,
    last_triggered_at timestamp with time zone,
    created_at timestamp with time zone DEFAULT now(),
    updated_at timestamp with time zone DEFAULT now()
);


ALTER TABLE public.webhooks OWNER TO neondb_owner;

--
-- Name: webhooks_id_seq; Type: SEQUENCE; Schema: public; Owner: neondb_owner
--

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


ALTER SEQUENCE public.webhooks_id_seq OWNER TO neondb_owner;

--
-- Name: webhooks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: neondb_owner
--

ALTER SEQUENCE public.webhooks_id_seq OWNED BY public.webhooks.id;


--
-- Name: zones_id_seq; Type: SEQUENCE; Schema: public; Owner: neondb_owner
--

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


ALTER SEQUENCE public.zones_id_seq OWNER TO neondb_owner;

--
-- Name: zones_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: neondb_owner
--

ALTER SEQUENCE public.zones_id_seq OWNED BY public.zones.id;


--
-- Name: activities id; Type: DEFAULT; Schema: public; Owner: neondb_owner
--

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


--
-- Name: activity_types id; Type: DEFAULT; Schema: public; Owner: neondb_owner
--

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


--
-- Name: ambassadors id; Type: DEFAULT; Schema: public; Owner: neondb_owner
--

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


--
-- Name: audit_logs id; Type: DEFAULT; Schema: public; Owner: neondb_owner
--

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


--
-- Name: categories id; Type: DEFAULT; Schema: public; Owner: neondb_owner
--

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


--
-- Name: cities id; Type: DEFAULT; Schema: public; Owner: neondb_owner
--

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


--
-- Name: conversations id; Type: DEFAULT; Schema: public; Owner: neondb_owner
--

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


--
-- Name: countries id; Type: DEFAULT; Schema: public; Owner: neondb_owner
--

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


--
-- Name: data_models id; Type: DEFAULT; Schema: public; Owner: neondb_owner
--

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


--
-- Name: insights id; Type: DEFAULT; Schema: public; Owner: neondb_owner
--

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


--
-- Name: media id; Type: DEFAULT; Schema: public; Owner: neondb_owner
--

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


--
-- Name: messages id; Type: DEFAULT; Schema: public; Owner: neondb_owner
--

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


--
-- Name: notifications id; Type: DEFAULT; Schema: public; Owner: neondb_owner
--

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


--
-- Name: regions id; Type: DEFAULT; Schema: public; Owner: neondb_owner
--

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


--
-- Name: reviews id; Type: DEFAULT; Schema: public; Owner: neondb_owner
--

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


--
-- Name: roles id; Type: DEFAULT; Schema: public; Owner: neondb_owner
--

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


--
-- Name: search_logs id; Type: DEFAULT; Schema: public; Owner: neondb_owner
--

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


--
-- Name: service_zones id; Type: DEFAULT; Schema: public; Owner: neondb_owner
--

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


--
-- Name: subscription_plans id; Type: DEFAULT; Schema: public; Owner: neondb_owner
--

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


--
-- Name: subscriptions id; Type: DEFAULT; Schema: public; Owner: neondb_owner
--

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


--
-- Name: user_interactions id; Type: DEFAULT; Schema: public; Owner: neondb_owner
--

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


--
-- Name: user_roles id; Type: DEFAULT; Schema: public; Owner: neondb_owner
--

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


--
-- Name: users id; Type: DEFAULT; Schema: public; Owner: neondb_owner
--

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


--
-- Name: verifications id; Type: DEFAULT; Schema: public; Owner: neondb_owner
--

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


--
-- Name: webhook_logs id; Type: DEFAULT; Schema: public; Owner: neondb_owner
--

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


--
-- Name: webhooks id; Type: DEFAULT; Schema: public; Owner: neondb_owner
--

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


--
-- Name: zones id; Type: DEFAULT; Schema: public; Owner: neondb_owner
--

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


--
-- Data for Name: activities; Type: TABLE DATA; Schema: public; Owner: neondb_owner
--

COPY public.activities (id, name, slug, description, short_description, activity_type_id, category_id, address, location, zone_id, phone_number, whatsapp_number, email, website, is_verified, is_active, is_open, verification_level, owner_id, manager_id, ambassador_id, price_level, accepts_cash, accepts_card, accepts_mobile_money, opening_hours, special_hours, rating, review_count, view_count, search_count, cover_image_url, logo_url, tags, keywords, languages, custom_data, created_at, updated_at, verified_at, last_activity_at) FROM stdin;
\.


--
-- Data for Name: activity_types; Type: TABLE DATA; Schema: public; Owner: neondb_owner
--

COPY public.activity_types (id, name, slug, description, category_id, requires_verification, allows_online_booking, allows_delivery, is_public, created_at) FROM stdin;
1	Boutique	boutique	Magasin de vêtements et accessoires	1	f	f	f	t	2025-10-10 04:58:04.293608+00
2	├ëpicerie	epicerie	Magasin d'alimentation g├®n├®rale	1	f	f	f	t	2025-10-10 04:58:04.293608+00
3	Pharmacie	pharmacie	Pharmacie et produits de sant├®	1	t	t	f	t	2025-10-10 04:58:04.293608+00
4	Coiffure	coiffure	Salon de coiffure et esth├®tique	1	f	t	f	t	2025-10-10 04:58:04.293608+00
5	R├®paration	reparation	Service de r├®paration divers	1	f	f	f	t	2025-10-10 04:58:04.293608+00
6	Hôpital	hopital	Établissement hospitalier	2	t	t	f	t	2025-10-10 04:58:04.293608+00
7	Clinique	clinique	Clinique m├®dicale	2	t	t	f	t	2025-10-10 04:58:04.293608+00
8	Cabinet m├®dical	cabinet-medical	Cabinet de m├®decin	2	t	t	f	t	2025-10-10 04:58:04.293608+00
9	Laboratoire	laboratoire	Laboratoire d'analyses	2	t	t	f	t	2025-10-10 04:58:04.293608+00
10	École	ecole	Établissement scolaire	3	t	f	f	t	2025-10-10 04:58:04.293608+00
11	Universit├®	universite	├ëtablissement universitaire	3	t	f	f	t	2025-10-10 04:58:04.293608+00
12	Centre de formation	centre-formation	Centre de formation professionnelle	3	f	t	f	t	2025-10-10 04:58:04.293608+00
13	Station-service	station-service	Station-service et carburant	4	f	f	f	t	2025-10-10 04:58:04.293608+00
14	Garage	garage	Garage automobile	4	f	t	f	t	2025-10-10 04:58:04.293608+00
15	Transport public	transport-public	Service de transport public	4	t	f	f	t	2025-10-10 04:58:04.293608+00
16	Cin├®ma	cinema	Salle de cin├®ma	5	f	t	f	t	2025-10-10 04:58:04.293608+00
17	Th├®├ótre	theatre	Salle de th├®├ótre	5	f	t	f	t	2025-10-10 04:58:04.293608+00
18	Centre de jeux	centre-jeux	Centre de jeux et divertissement	5	f	f	f	t	2025-10-10 04:58:04.293608+00
19	Bibliothèque	bibliotheque	Bibliothèque publique	5	t	f	f	t	2025-10-10 04:58:04.293608+00
20	Restaurant	restaurant	Restaurant et gastronomie	6	f	t	f	t	2025-10-10 04:58:04.293608+00
21	Maquis	maquis	Maquis et restauration locale	6	f	f	f	t	2025-10-10 04:58:04.293608+00
22	Bar	bar	Bar et boissons	6	f	f	f	t	2025-10-10 04:58:04.293608+00
23	Caf├®	cafe	Caf├® et p├ótisserie	6	f	f	f	t	2025-10-10 04:58:04.293608+00
24	Mairie	mairie	Mairie et administration locale	10	t	f	f	t	2025-10-10 04:58:04.293608+00
25	Pr├®fecture	prefecture	Pr├®fecture et administration	10	t	f	f	t	2025-10-10 04:58:04.293608+00
26	Tribunal	tribunal	Tribunal et justice	10	t	f	f	t	2025-10-10 04:58:04.293608+00
27	Banque	banque	Établissement bancaire	10	t	t	f	t	2025-10-10 04:58:04.293608+00
\.


--
-- Data for Name: ambassadors; Type: TABLE DATA; Schema: public; Owner: neondb_owner
--

COPY public.ambassadors (id, user_id, full_name, id_document_type, id_document_number, id_document_image_url, status, level, points, assigned_zones, max_activities, activities_created, activities_verified, verification_accuracy, created_at, updated_at, approved_at) FROM stdin;
\.


--
-- Data for Name: audit_logs; Type: TABLE DATA; Schema: public; Owner: neondb_owner
--

COPY public.audit_logs (id, user_id, action, table_name, record_id, old_values, new_values, ip_address, user_agent, session_id, created_at) FROM stdin;
\.


--
-- Data for Name: categories; Type: TABLE DATA; Schema: public; Owner: neondb_owner
--

COPY public.categories (id, name, slug, description, icon, color, parent_id, level, is_active, sort_order, created_at) FROM stdin;
1	Commerce & Services	commerce-services	Tous types de commerces et services	store	#3B82F6	\N	0	t	0	2025-10-10 04:58:04.089345+00
2	Sant├® & Bien-├¬tre	sante-bien-etre	Services de sant├® et bien-├¬tre	heart	#EF4444	\N	0	t	0	2025-10-10 04:58:04.089345+00
3	├ëducation & Formation	education-formation	├ëtablissements ├®ducatifs et formation	graduation-cap	#10B981	\N	0	t	0	2025-10-10 04:58:04.089345+00
4	Transport & Mobilit├®	transport-mobilite	Services de transport et mobilit├®	car	#F59E0B	\N	0	t	0	2025-10-10 04:58:04.089345+00
5	Loisirs & Culture	loisirs-culture	Divertissements et activit├®s culturelles	music	#8B5CF6	\N	0	t	0	2025-10-10 04:58:04.089345+00
6	Alimentation & Restauration	alimentation-restauration	Restaurants, bars, et alimentation	utensils	#F97316	\N	0	t	0	2025-10-10 04:58:04.089345+00
7	Immobilier & Construction	immobilier-construction	Services immobiliers et construction	home	#06B6D4	\N	0	t	0	2025-10-10 04:58:04.089345+00
8	Technologie & Communication	technologie-communication	Services technologiques et communication	laptop	#6366F1	\N	0	t	0	2025-10-10 04:58:04.089345+00
9	Finance & Assurance	finance-assurance	Services financiers et assurance	credit-card	#84CC16	\N	0	t	0	2025-10-10 04:58:04.089345+00
10	Gouvernement & Administration	gouvernement-administration	Services publics et administration	building	#6B7280	\N	0	t	0	2025-10-10 04:58:04.089345+00
12	Restaurant	restaurant	\N	\N	\N	\N	0	t	0	2025-10-16 04:10:41.501495+00
13	Maquis	maquis	\N	\N	\N	\N	0	t	0	2025-10-16 04:10:41.501495+00
14	Bar	bar	\N	\N	\N	\N	0	t	0	2025-10-16 04:10:41.501495+00
15	Caf├®	caf	\N	\N	\N	\N	0	t	0	2025-10-16 04:10:41.501495+00
16	Boutique	boutique	\N	\N	\N	\N	0	t	0	2025-10-16 04:10:41.501495+00
17	Magasin	magasin	\N	\N	\N	\N	0	t	0	2025-10-16 04:10:41.501495+00
18	Pharmacie	pharmacie	\N	\N	\N	\N	0	t	0	2025-10-16 04:10:41.501495+00
19	Coiffure	coiffure	\N	\N	\N	\N	0	t	0	2025-10-16 04:10:41.501495+00
20	R├®paration	r-paration	\N	\N	\N	\N	0	t	0	2025-10-16 04:10:41.501495+00
21	Sant├®	sant	\N	\N	\N	\N	0	t	0	2025-10-16 04:10:41.501495+00
22	Éducation	ducation	\N	\N	\N	\N	0	t	0	2025-10-16 04:10:41.501495+00
23	Services	services	\N	\N	\N	\N	0	t	0	2025-10-16 04:10:41.501495+00
24	Finance	finance	\N	\N	\N	\N	0	t	0	2025-10-16 04:10:41.501495+00
25	Loisirs	loisirs	\N	\N	\N	\N	0	t	0	2025-10-16 04:10:41.501495+00
26	Religion	religion	\N	\N	\N	\N	0	t	0	2025-10-16 04:10:41.501495+00
27	Gouvernement	gouvernement	\N	\N	\N	\N	0	t	0	2025-10-16 04:10:41.501495+00
\.


--
-- Data for Name: cities; Type: TABLE DATA; Schema: public; Owner: neondb_owner
--

COPY public.cities (id, region_id, name, population, geometry, center_point, created_at) FROM stdin;
\.


--
-- Data for Name: conversations; Type: TABLE DATA; Schema: public; Owner: neondb_owner
--

COPY public.conversations (id, user_id, session_id, context, user_location, status, language, created_at, updated_at, last_message_at) FROM stdin;
\.


--
-- Data for Name: countries; Type: TABLE DATA; Schema: public; Owner: neondb_owner
--

COPY public.countries (id, name, code, currency, timezone, geometry, created_at) FROM stdin;
\.


--
-- Data for Name: data_models; Type: TABLE DATA; Schema: public; Owner: neondb_owner
--

COPY public.data_models (id, name, description, model_type, parameters, training_data, accuracy, precision_score, recall_score, f1_score, status, version, created_at, updated_at, trained_at) FROM stdin;
\.


--
-- Data for Name: insights; Type: TABLE DATA; Schema: public; Owner: neondb_owner
--

COPY public.insights (id, title, description, insight_type, data, visualization_config, source_tables, filters_applied, confidence_level, target_audience, is_public, created_at, expires_at) FROM stdin;
\.


--
-- Data for Name: media; Type: TABLE DATA; Schema: public; Owner: neondb_owner
--

COPY public.media (id, activity_id, user_id, file_url, file_type, mime_type, file_size, title, description, alt_text, width, height, duration, category, is_primary, is_public, is_approved, moderation_notes, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: messages; Type: TABLE DATA; Schema: public; Owner: neondb_owner
--

COPY public.messages (id, conversation_id, sender, content, message_type, intent, entities, confidence_score, processing_time_ms, referenced_activities, referenced_categories, created_at) FROM stdin;
\.


--
-- Data for Name: notifications; Type: TABLE DATA; Schema: public; Owner: neondb_owner
--

COPY public.notifications (id, user_id, title, message, notification_type, target_activity_id, target_zone_id, is_read, is_push_sent, is_sms_sent, is_email_sent, data, created_at, read_at) FROM stdin;
\.


--
-- Data for Name: regions; Type: TABLE DATA; Schema: public; Owner: neondb_owner
--

COPY public.regions (id, country_id, name, code, geometry, created_at) FROM stdin;
\.


--
-- Data for Name: reviews; Type: TABLE DATA; Schema: public; Owner: neondb_owner
--

COPY public.reviews (id, activity_id, user_id, rating, title, comment, category_ratings, photos, helpful_count, is_verified_purchase, is_approved, is_flagged, moderation_notes, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: roles; Type: TABLE DATA; Schema: public; Owner: neondb_owner
--

COPY public.roles (id, name, description, permissions, is_system, created_at) FROM stdin;
1	admin	Administrateur système	{"all": true}	t	2025-10-10 04:58:03.885167+00
2	ambassador	Ambassadeur	{"create_activities": true, "verify_activities": true, "manage_own_activities": true}	t	2025-10-10 04:58:03.885167+00
3	moderator	Mod├®rateur	{"moderate_content": true, "verify_activities": true}	t	2025-10-10 04:58:03.885167+00
4	user	Utilisateur standard	{"create_reviews": true, "view_activities": true}	t	2025-10-10 04:58:03.885167+00
5	analyst	Analyste de donn├®es	{"export_data": true, "view_analytics": true}	t	2025-10-10 04:58:03.885167+00
\.


--
-- Data for Name: search_logs; Type: TABLE DATA; Schema: public; Owner: neondb_owner
--

COPY public.search_logs (id, user_id, session_id, query, processed_query, language, user_location, search_radius, filters, results_count, results_ids, intent, entities, confidence_score, search_time_ms, created_at) FROM stdin;
\.


--
-- Data for Name: service_zones; Type: TABLE DATA; Schema: public; Owner: neondb_owner
--

COPY public.service_zones (id, activity_id, activity_type, zone_id, radius_meters, is_primary, created_at) FROM stdin;
\.


--
-- Data for Name: spatial_ref_sys; Type: TABLE DATA; Schema: public; Owner: cloud_admin
--

COPY public.spatial_ref_sys (srid, auth_name, auth_srid, srtext, proj4text) FROM stdin;
\.


--
-- Data for Name: subscription_plans; Type: TABLE DATA; Schema: public; Owner: neondb_owner
--

COPY public.subscription_plans (id, name, description, price_monthly, price_yearly, currency, max_activities, max_photos_per_activity, max_ambassadors, features, is_active, is_popular, created_at, updated_at) FROM stdin;
1	Gratuit	Plan gratuit pour d├®buter	0.00	0.00	XOF	5	\N	\N	{"basic_search": true, "limited_photos": true}	t	f	2025-10-10 04:58:04.485411+00	2025-10-10 04:58:04.485411+00
2	Pro	Plan professionnel	5000.00	50000.00	XOF	50	\N	\N	{"analytics": true, "advanced_search": true, "priority_support": true, "unlimited_photos": true}	t	f	2025-10-10 04:58:04.485411+00	2025-10-10 04:58:04.485411+00
3	Business	Plan entreprise	15000.00	150000.00	XOF	200	\N	\N	{"api_access": true, "all_features": true, "custom_branding": true, "dedicated_support": true}	t	f	2025-10-10 04:58:04.485411+00	2025-10-10 04:58:04.485411+00
4	Enterprise	Plan entreprise avanc├®	50000.00	500000.00	XOF	-1	\N	\N	{"unlimited": true, "white_label": true, "24_7_support": true, "custom_development": true}	t	f	2025-10-10 04:58:04.485411+00	2025-10-10 04:58:04.485411+00
\.


--
-- Data for Name: subscriptions; Type: TABLE DATA; Schema: public; Owner: neondb_owner
--

COPY public.subscriptions (id, user_id, plan_id, status, payment_status, started_at, expires_at, cancelled_at, payment_method, transaction_id, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: user_interactions; Type: TABLE DATA; Schema: public; Owner: neondb_owner
--

COPY public.user_interactions (id, user_id, activity_id, interaction_type, session_id, referrer, user_agent, ip_address, metadata, created_at) FROM stdin;
\.


--
-- Data for Name: user_roles; Type: TABLE DATA; Schema: public; Owner: neondb_owner
--

COPY public.user_roles (id, user_id, role_id, assigned_by, assigned_at, expires_at, is_active) FROM stdin;
\.


--
-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: neondb_owner
--

COPY public.users (id, phone_number, email, full_name, avatar_url, is_verified, is_active, last_location, preferred_language, timezone, created_at, updated_at, last_seen) FROM stdin;
1	+225123456789	\N	\N	\N	t	t	\N	fr	Africa/Abidjan	2025-10-16 04:11:20.725721+00	2025-10-16 04:11:20.725721+00	2025-10-16 04:11:20.725721+00
\.


--
-- Data for Name: verifications; Type: TABLE DATA; Schema: public; Owner: neondb_owner
--

COPY public.verifications (id, activity_id, ambassador_id, verification_type, status, verification_data, notes, photos, created_at, completed_at) FROM stdin;
\.


--
-- Data for Name: webhook_logs; Type: TABLE DATA; Schema: public; Owner: neondb_owner
--

COPY public.webhook_logs (id, webhook_id, event_type, payload, status, response_code, response_body, error_message, created_at, processed_at) FROM stdin;
\.


--
-- Data for Name: webhooks; Type: TABLE DATA; Schema: public; Owner: neondb_owner
--

COPY public.webhooks (id, name, url, secret_key, events, is_active, retry_count, success_count, failure_count, last_triggered_at, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: zones; Type: TABLE DATA; Schema: public; Owner: neondb_owner
--

COPY public.zones (id, city_id, name, type, geometry, center_point, population, created_at) FROM stdin;
\.


--
-- Data for Name: topology; Type: TABLE DATA; Schema: topology; Owner: cloud_admin
--

COPY topology.topology (id, name, srid, "precision", hasz) FROM stdin;
\.


--
-- Data for Name: layer; Type: TABLE DATA; Schema: topology; Owner: cloud_admin
--

COPY topology.layer (topology_id, layer_id, schema_name, table_name, feature_column, feature_type, level, child_id) FROM stdin;
\.


--
-- Name: activities_id_seq; Type: SEQUENCE SET; Schema: public; Owner: neondb_owner
--

SELECT pg_catalog.setval('public.activities_id_seq', 1, false);


--
-- Name: activity_types_id_seq; Type: SEQUENCE SET; Schema: public; Owner: neondb_owner
--

SELECT pg_catalog.setval('public.activity_types_id_seq', 27, true);


--
-- Name: ambassadors_id_seq; Type: SEQUENCE SET; Schema: public; Owner: neondb_owner
--

SELECT pg_catalog.setval('public.ambassadors_id_seq', 1, true);


--
-- Name: audit_logs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: neondb_owner
--

SELECT pg_catalog.setval('public.audit_logs_id_seq', 1, false);


--
-- Name: categories_id_seq; Type: SEQUENCE SET; Schema: public; Owner: neondb_owner
--

SELECT pg_catalog.setval('public.categories_id_seq', 27, true);


--
-- Name: cities_id_seq; Type: SEQUENCE SET; Schema: public; Owner: neondb_owner
--

SELECT pg_catalog.setval('public.cities_id_seq', 1, false);


--
-- Name: conversations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: neondb_owner
--

SELECT pg_catalog.setval('public.conversations_id_seq', 1, false);


--
-- Name: countries_id_seq; Type: SEQUENCE SET; Schema: public; Owner: neondb_owner
--

SELECT pg_catalog.setval('public.countries_id_seq', 1, false);


--
-- Name: data_models_id_seq; Type: SEQUENCE SET; Schema: public; Owner: neondb_owner
--

SELECT pg_catalog.setval('public.data_models_id_seq', 1, false);


--
-- Name: insights_id_seq; Type: SEQUENCE SET; Schema: public; Owner: neondb_owner
--

SELECT pg_catalog.setval('public.insights_id_seq', 1, false);


--
-- Name: media_id_seq; Type: SEQUENCE SET; Schema: public; Owner: neondb_owner
--

SELECT pg_catalog.setval('public.media_id_seq', 1, false);


--
-- Name: messages_id_seq; Type: SEQUENCE SET; Schema: public; Owner: neondb_owner
--

SELECT pg_catalog.setval('public.messages_id_seq', 1, false);


--
-- Name: notifications_id_seq; Type: SEQUENCE SET; Schema: public; Owner: neondb_owner
--

SELECT pg_catalog.setval('public.notifications_id_seq', 1, false);


--
-- Name: regions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: neondb_owner
--

SELECT pg_catalog.setval('public.regions_id_seq', 1, false);


--
-- Name: reviews_id_seq; Type: SEQUENCE SET; Schema: public; Owner: neondb_owner
--

SELECT pg_catalog.setval('public.reviews_id_seq', 1, false);


--
-- Name: roles_id_seq; Type: SEQUENCE SET; Schema: public; Owner: neondb_owner
--

SELECT pg_catalog.setval('public.roles_id_seq', 5, true);


--
-- Name: search_logs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: neondb_owner
--

SELECT pg_catalog.setval('public.search_logs_id_seq', 1, false);


--
-- Name: service_zones_id_seq; Type: SEQUENCE SET; Schema: public; Owner: neondb_owner
--

SELECT pg_catalog.setval('public.service_zones_id_seq', 1, false);


--
-- Name: subscription_plans_id_seq; Type: SEQUENCE SET; Schema: public; Owner: neondb_owner
--

SELECT pg_catalog.setval('public.subscription_plans_id_seq', 4, true);


--
-- Name: subscriptions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: neondb_owner
--

SELECT pg_catalog.setval('public.subscriptions_id_seq', 1, false);


--
-- Name: user_interactions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: neondb_owner
--

SELECT pg_catalog.setval('public.user_interactions_id_seq', 1, false);


--
-- Name: user_roles_id_seq; Type: SEQUENCE SET; Schema: public; Owner: neondb_owner
--

SELECT pg_catalog.setval('public.user_roles_id_seq', 1, false);


--
-- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: neondb_owner
--

SELECT pg_catalog.setval('public.users_id_seq', 2, true);


--
-- Name: verifications_id_seq; Type: SEQUENCE SET; Schema: public; Owner: neondb_owner
--

SELECT pg_catalog.setval('public.verifications_id_seq', 1, false);


--
-- Name: webhook_logs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: neondb_owner
--

SELECT pg_catalog.setval('public.webhook_logs_id_seq', 1, false);


--
-- Name: webhooks_id_seq; Type: SEQUENCE SET; Schema: public; Owner: neondb_owner
--

SELECT pg_catalog.setval('public.webhooks_id_seq', 1, false);


--
-- Name: zones_id_seq; Type: SEQUENCE SET; Schema: public; Owner: neondb_owner
--

SELECT pg_catalog.setval('public.zones_id_seq', 1, false);


--
-- Name: topology_id_seq; Type: SEQUENCE SET; Schema: topology; Owner: cloud_admin
--

SELECT pg_catalog.setval('topology.topology_id_seq', 1, false);


--
-- Name: activities activities_pkey; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.activities
    ADD CONSTRAINT activities_pkey PRIMARY KEY (id);


--
-- Name: activities activities_slug_key; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.activities
    ADD CONSTRAINT activities_slug_key UNIQUE (slug);


--
-- Name: activity_types activity_types_pkey; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.activity_types
    ADD CONSTRAINT activity_types_pkey PRIMARY KEY (id);


--
-- Name: activity_types activity_types_slug_key; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.activity_types
    ADD CONSTRAINT activity_types_slug_key UNIQUE (slug);


--
-- Name: ambassadors ambassadors_pkey; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.ambassadors
    ADD CONSTRAINT ambassadors_pkey PRIMARY KEY (id);


--
-- Name: ambassadors ambassadors_user_id_key; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.ambassadors
    ADD CONSTRAINT ambassadors_user_id_key UNIQUE (user_id);


--
-- Name: audit_logs audit_logs_pkey; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.audit_logs
    ADD CONSTRAINT audit_logs_pkey PRIMARY KEY (id);


--
-- Name: categories categories_pkey; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.categories
    ADD CONSTRAINT categories_pkey PRIMARY KEY (id);


--
-- Name: categories categories_slug_key; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.categories
    ADD CONSTRAINT categories_slug_key UNIQUE (slug);


--
-- Name: cities cities_pkey; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.cities
    ADD CONSTRAINT cities_pkey PRIMARY KEY (id);


--
-- Name: conversations conversations_pkey; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.conversations
    ADD CONSTRAINT conversations_pkey PRIMARY KEY (id);


--
-- Name: countries countries_code_key; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.countries
    ADD CONSTRAINT countries_code_key UNIQUE (code);


--
-- Name: countries countries_pkey; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.countries
    ADD CONSTRAINT countries_pkey PRIMARY KEY (id);


--
-- Name: data_models data_models_pkey; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.data_models
    ADD CONSTRAINT data_models_pkey PRIMARY KEY (id);


--
-- Name: insights insights_pkey; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.insights
    ADD CONSTRAINT insights_pkey PRIMARY KEY (id);


--
-- Name: media media_pkey; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.media
    ADD CONSTRAINT media_pkey PRIMARY KEY (id);


--
-- Name: messages messages_pkey; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.messages
    ADD CONSTRAINT messages_pkey PRIMARY KEY (id);


--
-- Name: notifications notifications_pkey; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.notifications
    ADD CONSTRAINT notifications_pkey PRIMARY KEY (id);


--
-- Name: regions regions_pkey; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.regions
    ADD CONSTRAINT regions_pkey PRIMARY KEY (id);


--
-- Name: reviews reviews_pkey; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.reviews
    ADD CONSTRAINT reviews_pkey PRIMARY KEY (id);


--
-- Name: roles roles_name_key; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.roles
    ADD CONSTRAINT roles_name_key UNIQUE (name);


--
-- Name: roles roles_pkey; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.roles
    ADD CONSTRAINT roles_pkey PRIMARY KEY (id);


--
-- Name: search_logs search_logs_pkey; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.search_logs
    ADD CONSTRAINT search_logs_pkey PRIMARY KEY (id);


--
-- Name: service_zones service_zones_pkey; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.service_zones
    ADD CONSTRAINT service_zones_pkey PRIMARY KEY (id);


--
-- Name: subscription_plans subscription_plans_pkey; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.subscription_plans
    ADD CONSTRAINT subscription_plans_pkey PRIMARY KEY (id);


--
-- Name: subscriptions subscriptions_pkey; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.subscriptions
    ADD CONSTRAINT subscriptions_pkey PRIMARY KEY (id);


--
-- Name: user_interactions user_interactions_pkey; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.user_interactions
    ADD CONSTRAINT user_interactions_pkey PRIMARY KEY (id);


--
-- Name: user_roles user_roles_pkey; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

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


--
-- Name: user_roles user_roles_user_id_role_id_key; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.user_roles
    ADD CONSTRAINT user_roles_user_id_role_id_key UNIQUE (user_id, role_id);


--
-- Name: users users_email_key; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_email_key UNIQUE (email);


--
-- Name: users users_phone_number_key; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_phone_number_key UNIQUE (phone_number);


--
-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_pkey PRIMARY KEY (id);


--
-- Name: verifications verifications_pkey; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.verifications
    ADD CONSTRAINT verifications_pkey PRIMARY KEY (id);


--
-- Name: webhook_logs webhook_logs_pkey; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.webhook_logs
    ADD CONSTRAINT webhook_logs_pkey PRIMARY KEY (id);


--
-- Name: webhooks webhooks_pkey; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.webhooks
    ADD CONSTRAINT webhooks_pkey PRIMARY KEY (id);


--
-- Name: zones zones_pkey; Type: CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.zones
    ADD CONSTRAINT zones_pkey PRIMARY KEY (id);


--
-- Name: idx_activities_active; Type: INDEX; Schema: public; Owner: neondb_owner
--

CREATE INDEX idx_activities_active ON public.activities USING btree (is_active, is_open);


--
-- Name: idx_activities_ambassador; Type: INDEX; Schema: public; Owner: neondb_owner
--

CREATE INDEX idx_activities_ambassador ON public.activities USING btree (ambassador_id);


--
-- Name: idx_activities_category; Type: INDEX; Schema: public; Owner: neondb_owner
--

CREATE INDEX idx_activities_category ON public.activities USING btree (category_id);


--
-- Name: idx_activities_created; Type: INDEX; Schema: public; Owner: neondb_owner
--

CREATE INDEX idx_activities_created ON public.activities USING btree (created_at DESC);


--
-- Name: idx_activities_location; Type: INDEX; Schema: public; Owner: neondb_owner
--

CREATE INDEX idx_activities_location ON public.activities USING gist (location);


--
-- Name: idx_activities_owner; Type: INDEX; Schema: public; Owner: neondb_owner
--

CREATE INDEX idx_activities_owner ON public.activities USING btree (owner_id);


--
-- Name: idx_activities_rating; Type: INDEX; Schema: public; Owner: neondb_owner
--

CREATE INDEX idx_activities_rating ON public.activities USING btree (rating DESC, review_count DESC);


--
-- Name: idx_activities_type; Type: INDEX; Schema: public; Owner: neondb_owner
--

CREATE INDEX idx_activities_type ON public.activities USING btree (activity_type_id);


--
-- Name: idx_activities_updated; Type: INDEX; Schema: public; Owner: neondb_owner
--

CREATE INDEX idx_activities_updated ON public.activities USING btree (updated_at DESC);


--
-- Name: idx_activities_verified; Type: INDEX; Schema: public; Owner: neondb_owner
--

CREATE INDEX idx_activities_verified ON public.activities USING btree (is_verified, verification_level);


--
-- Name: idx_activities_zone; Type: INDEX; Schema: public; Owner: neondb_owner
--

CREATE INDEX idx_activities_zone ON public.activities USING btree (zone_id);


--
-- Name: idx_notifications_type; Type: INDEX; Schema: public; Owner: neondb_owner
--

CREATE INDEX idx_notifications_type ON public.notifications USING btree (notification_type, created_at DESC);


--
-- Name: idx_notifications_user_unread; Type: INDEX; Schema: public; Owner: neondb_owner
--

CREATE INDEX idx_notifications_user_unread ON public.notifications USING btree (user_id, is_read, created_at DESC);


--
-- Name: idx_search_logs_created; Type: INDEX; Schema: public; Owner: neondb_owner
--

CREATE INDEX idx_search_logs_created ON public.search_logs USING btree (created_at DESC);


--
-- Name: idx_user_interactions_created; Type: INDEX; Schema: public; Owner: neondb_owner
--

CREATE INDEX idx_user_interactions_created ON public.user_interactions USING btree (created_at DESC);


--
-- Name: idx_user_interactions_type; Type: INDEX; Schema: public; Owner: neondb_owner
--

CREATE INDEX idx_user_interactions_type ON public.user_interactions USING btree (interaction_type, created_at DESC);


--
-- Name: activities update_activities_updated_at; Type: TRIGGER; Schema: public; Owner: neondb_owner
--

CREATE TRIGGER update_activities_updated_at BEFORE UPDATE ON public.activities FOR EACH ROW EXECUTE FUNCTION public.update_updated_at_column();


--
-- Name: reviews update_activity_stats_trigger; Type: TRIGGER; Schema: public; Owner: neondb_owner
--

CREATE TRIGGER update_activity_stats_trigger AFTER INSERT OR DELETE OR UPDATE ON public.reviews FOR EACH ROW EXECUTE FUNCTION public.update_activity_stats();


--
-- Name: ambassadors update_ambassadors_updated_at; Type: TRIGGER; Schema: public; Owner: neondb_owner
--

CREATE TRIGGER update_ambassadors_updated_at BEFORE UPDATE ON public.ambassadors FOR EACH ROW EXECUTE FUNCTION public.update_updated_at_column();


--
-- Name: users update_users_updated_at; Type: TRIGGER; Schema: public; Owner: neondb_owner
--

CREATE TRIGGER update_users_updated_at BEFORE UPDATE ON public.users FOR EACH ROW EXECUTE FUNCTION public.update_updated_at_column();


--
-- Name: activities activities_activity_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.activities
    ADD CONSTRAINT activities_activity_type_id_fkey FOREIGN KEY (activity_type_id) REFERENCES public.activity_types(id);


--
-- Name: activities activities_ambassador_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.activities
    ADD CONSTRAINT activities_ambassador_id_fkey FOREIGN KEY (ambassador_id) REFERENCES public.users(id);


--
-- Name: activities activities_category_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.activities
    ADD CONSTRAINT activities_category_id_fkey FOREIGN KEY (category_id) REFERENCES public.categories(id);


--
-- Name: activities activities_manager_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.activities
    ADD CONSTRAINT activities_manager_id_fkey FOREIGN KEY (manager_id) REFERENCES public.users(id);


--
-- Name: activities activities_owner_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.activities
    ADD CONSTRAINT activities_owner_id_fkey FOREIGN KEY (owner_id) REFERENCES public.users(id);


--
-- Name: activities activities_zone_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.activities
    ADD CONSTRAINT activities_zone_id_fkey FOREIGN KEY (zone_id) REFERENCES public.zones(id);


--
-- Name: activity_types activity_types_category_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.activity_types
    ADD CONSTRAINT activity_types_category_id_fkey FOREIGN KEY (category_id) REFERENCES public.categories(id);


--
-- Name: ambassadors ambassadors_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.ambassadors
    ADD CONSTRAINT ambassadors_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: audit_logs audit_logs_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.audit_logs
    ADD CONSTRAINT audit_logs_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: categories categories_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.categories
    ADD CONSTRAINT categories_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES public.categories(id);


--
-- Name: cities cities_region_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.cities
    ADD CONSTRAINT cities_region_id_fkey FOREIGN KEY (region_id) REFERENCES public.regions(id);


--
-- Name: conversations conversations_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.conversations
    ADD CONSTRAINT conversations_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: media media_activity_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.media
    ADD CONSTRAINT media_activity_id_fkey FOREIGN KEY (activity_id) REFERENCES public.activities(id) ON DELETE CASCADE;


--
-- Name: media media_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.media
    ADD CONSTRAINT media_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: messages messages_conversation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.messages
    ADD CONSTRAINT messages_conversation_id_fkey FOREIGN KEY (conversation_id) REFERENCES public.conversations(id) ON DELETE CASCADE;


--
-- Name: notifications notifications_target_activity_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.notifications
    ADD CONSTRAINT notifications_target_activity_id_fkey FOREIGN KEY (target_activity_id) REFERENCES public.activities(id);


--
-- Name: notifications notifications_target_zone_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.notifications
    ADD CONSTRAINT notifications_target_zone_id_fkey FOREIGN KEY (target_zone_id) REFERENCES public.zones(id);


--
-- Name: notifications notifications_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.notifications
    ADD CONSTRAINT notifications_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: regions regions_country_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.regions
    ADD CONSTRAINT regions_country_id_fkey FOREIGN KEY (country_id) REFERENCES public.countries(id);


--
-- Name: reviews reviews_activity_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.reviews
    ADD CONSTRAINT reviews_activity_id_fkey FOREIGN KEY (activity_id) REFERENCES public.activities(id) ON DELETE CASCADE;


--
-- Name: reviews reviews_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.reviews
    ADD CONSTRAINT reviews_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: search_logs search_logs_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.search_logs
    ADD CONSTRAINT search_logs_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: service_zones service_zones_zone_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.service_zones
    ADD CONSTRAINT service_zones_zone_id_fkey FOREIGN KEY (zone_id) REFERENCES public.zones(id);


--
-- Name: subscriptions subscriptions_plan_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.subscriptions
    ADD CONSTRAINT subscriptions_plan_id_fkey FOREIGN KEY (plan_id) REFERENCES public.subscription_plans(id);


--
-- Name: subscriptions subscriptions_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.subscriptions
    ADD CONSTRAINT subscriptions_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: user_interactions user_interactions_activity_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.user_interactions
    ADD CONSTRAINT user_interactions_activity_id_fkey FOREIGN KEY (activity_id) REFERENCES public.activities(id);


--
-- Name: user_interactions user_interactions_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.user_interactions
    ADD CONSTRAINT user_interactions_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: user_roles user_roles_assigned_by_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.user_roles
    ADD CONSTRAINT user_roles_assigned_by_fkey FOREIGN KEY (assigned_by) REFERENCES public.users(id);


--
-- Name: user_roles user_roles_role_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.user_roles
    ADD CONSTRAINT user_roles_role_id_fkey FOREIGN KEY (role_id) REFERENCES public.roles(id) ON DELETE CASCADE;


--
-- Name: user_roles user_roles_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.user_roles
    ADD CONSTRAINT user_roles_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: verifications verifications_activity_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.verifications
    ADD CONSTRAINT verifications_activity_id_fkey FOREIGN KEY (activity_id) REFERENCES public.activities(id);


--
-- Name: verifications verifications_ambassador_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.verifications
    ADD CONSTRAINT verifications_ambassador_id_fkey FOREIGN KEY (ambassador_id) REFERENCES public.ambassadors(id);


--
-- Name: webhook_logs webhook_logs_webhook_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.webhook_logs
    ADD CONSTRAINT webhook_logs_webhook_id_fkey FOREIGN KEY (webhook_id) REFERENCES public.webhooks(id);


--
-- Name: zones zones_city_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: neondb_owner
--

ALTER TABLE ONLY public.zones
    ADD CONSTRAINT zones_city_id_fkey FOREIGN KEY (city_id) REFERENCES public.cities(id);


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

REVOKE USAGE ON SCHEMA public FROM PUBLIC;


--
-- Name: DEFAULT PRIVILEGES FOR SEQUENCES; Type: DEFAULT ACL; Schema: public; Owner: cloud_admin
--

ALTER DEFAULT PRIVILEGES FOR ROLE cloud_admin IN SCHEMA public GRANT ALL ON SEQUENCES TO neon_superuser WITH GRANT OPTION;


--
-- Name: DEFAULT PRIVILEGES FOR TABLES; Type: DEFAULT ACL; Schema: public; Owner: cloud_admin
--

ALTER DEFAULT PRIVILEGES FOR ROLE cloud_admin IN SCHEMA public GRANT ALL ON TABLES TO neon_superuser WITH GRANT OPTION;


--
-- PostgreSQL database dump complete
--