-- -- PostgreSQL database dump -- \restrict vMzOYIgcYQfRWBNz334K5zaLN72xzh32DKNBKnh79EIbO8ZlByFyUNzIacQdGhU -- Dumped from database version 16.11 (Ubuntu 16.11-0ubuntu0.24.04.1) -- Dumped by pg_dump version 16.11 (Ubuntu 16.11-0ubuntu0.24.04.1) SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_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; SET default_tablespace = ''; SET default_table_access_method = heap; -- -- Name: agenda_items; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.agenda_items ( id bigint NOT NULL, agenda_id bigint, start_times text NOT NULL, end_times text NOT NULL, topics text NOT NULL, created_by bigint, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.agenda_items OWNER TO postgres; -- -- Name: agenda_items_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.agenda_items_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.agenda_items_id_seq OWNER TO postgres; -- -- Name: agenda_items_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.agenda_items_id_seq OWNED BY public.agenda_items.id; -- -- Name: agendas; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.agendas ( id bigint NOT NULL, day_number integer NOT NULL, date character varying(255) NOT NULL, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.agendas OWNER TO postgres; -- -- Name: agendas_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.agendas_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.agendas_id_seq OWNER TO postgres; -- -- Name: agendas_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.agendas_id_seq OWNED BY public.agendas.id; -- -- Name: booking_items; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.booking_items ( id bigint NOT NULL, booth_booking_id bigint NOT NULL, booth_id bigint NOT NULL, price_at_booking numeric(15,2) NOT NULL, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.booking_items OWNER TO postgres; -- -- Name: booking_items_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.booking_items_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.booking_items_id_seq OWNER TO postgres; -- -- Name: booking_items_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.booking_items_id_seq OWNED BY public.booking_items.id; -- -- Name: booth_bookings; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.booth_bookings ( id bigint NOT NULL, usereventregistration_id bigint NOT NULL, company_id bigint NOT NULL, subtotal numeric(15,2) NOT NULL, add_on_total numeric(15,2) DEFAULT '0'::numeric NOT NULL, grand_total numeric(15,2) NOT NULL, status character varying(255) DEFAULT 'pending'::character varying NOT NULL, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone, CONSTRAINT booth_bookings_status_check CHECK (((status)::text = ANY ((ARRAY['pending'::character varying, 'confirmed'::character varying, 'cancelled'::character varying])::text[]))) ); ALTER TABLE public.booth_bookings OWNER TO postgres; -- -- Name: booth_bookings_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.booth_bookings_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.booth_bookings_id_seq OWNER TO postgres; -- -- Name: booth_bookings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.booth_bookings_id_seq OWNED BY public.booth_bookings.id; -- -- Name: booths; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.booths ( id bigint NOT NULL, booth_number character varying(255) NOT NULL, dimensions character varying(255) DEFAULT '3m x 3m (9 SQM)'::character varying NOT NULL, scheme_type character varying(255) DEFAULT 'Standard Shell Scheme'::character varying NOT NULL, furniture_set text NOT NULL, utilities text NOT NULL, visibility character varying(255) DEFAULT 'Prime location'::character varying NOT NULL, price numeric(15,2) DEFAULT '45000'::numeric NOT NULL, status character varying(255) DEFAULT 'available'::character varying NOT NULL, type character varying(255), created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone, CONSTRAINT booths_status_check CHECK (((status)::text = ANY ((ARRAY['available'::character varying, 'booked'::character varying, 'reserved'::character varying])::text[]))) ); ALTER TABLE public.booths OWNER TO postgres; -- -- Name: booths_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.booths_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.booths_id_seq OWNER TO postgres; -- -- Name: booths_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.booths_id_seq OWNED BY public.booths.id; -- -- Name: companies; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.companies ( id bigint NOT NULL, name character varying(255) NOT NULL, website character varying(255), industry character varying(255), bio text, logo_path character varying(255), banner character varying(255), created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.companies OWNER TO postgres; -- -- Name: companies_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.companies_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.companies_id_seq OWNER TO postgres; -- -- Name: companies_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.companies_id_seq OWNED BY public.companies.id; -- -- Name: eventagenders; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.eventagenders ( id bigint NOT NULL, event_id bigint NOT NULL, agenda text NOT NULL, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.eventagenders OWNER TO postgres; -- -- Name: eventagenders_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.eventagenders_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.eventagenders_id_seq OWNER TO postgres; -- -- Name: eventagenders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.eventagenders_id_seq OWNED BY public.eventagenders.id; -- -- Name: events; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.events ( id bigint NOT NULL, institution_name character varying(255) NOT NULL, logo_url character varying(255), title character varying(255) NOT NULL, description text, start_date date, end_date date, photo_url character varying(255), control_number character varying(255), venue_id bigint, status bigint, createdby bigint, modifiedby bigint, company_id bigint, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.events OWNER TO postgres; -- -- Name: events_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.events_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.events_id_seq OWNER TO postgres; -- -- Name: events_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.events_id_seq OWNED BY public.events.id; -- -- Name: eventsessions; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.eventsessions ( id bigint NOT NULL, event_id bigint NOT NULL, quest_id bigint, title character varying(255) NOT NULL, description text, start_date date, end_date date, start_time time(0) without time zone, end_time time(0) without time zone, createdby bigint, modifiedby bigint, company_id bigint, status bigint, location character varying(255) NOT NULL, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.eventsessions OWNER TO postgres; -- -- Name: eventsessions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.eventsessions_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.eventsessions_id_seq OWNER TO postgres; -- -- Name: eventsessions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.eventsessions_id_seq OWNED BY public.eventsessions.id; -- -- Name: facilities; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.facilities ( id bigint NOT NULL, name character varying(255) NOT NULL, venue_id bigint NOT NULL, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.facilities OWNER TO postgres; -- -- Name: facilities_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.facilities_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.facilities_id_seq OWNER TO postgres; -- -- Name: facilities_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.facilities_id_seq OWNED BY public.facilities.id; -- -- Name: failed_jobs; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.failed_jobs ( id bigint NOT NULL, uuid character varying(255) NOT NULL, connection text NOT NULL, queue text NOT NULL, payload text NOT NULL, exception text NOT NULL, failed_at timestamp(0) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL ); ALTER TABLE public.failed_jobs OWNER TO postgres; -- -- Name: failed_jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.failed_jobs_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.failed_jobs_id_seq OWNER TO postgres; -- -- Name: failed_jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.failed_jobs_id_seq OWNED BY public.failed_jobs.id; -- -- Name: guests; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.guests ( id bigint NOT NULL, name character varying(255) NOT NULL, title character varying(255), role character varying(255) NOT NULL, bio text, photo_url character varying(255), venue_id bigint, createdby bigint, modifiedby bigint, company_id bigint, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.guests OWNER TO postgres; -- -- Name: guests_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.guests_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.guests_id_seq OWNER TO postgres; -- -- Name: guests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.guests_id_seq OWNED BY public.guests.id; -- -- Name: media_attendance_days; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.media_attendance_days ( id bigint NOT NULL, media_registration_id bigint NOT NULL, day character varying(255) NOT NULL, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.media_attendance_days OWNER TO postgres; -- -- Name: media_attendance_days_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.media_attendance_days_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.media_attendance_days_id_seq OWNER TO postgres; -- -- Name: media_attendance_days_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.media_attendance_days_id_seq OWNED BY public.media_attendance_days.id; -- -- Name: media_registrations; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.media_registrations ( id bigint NOT NULL, usereventregistration_id bigint NOT NULL, media_name character varying(255) NOT NULL, website_url character varying(255), press_id_number character varying(255), dietary_accessibility character varying(255), terms_acceptance boolean DEFAULT false NOT NULL, portfolio_url text, media_type character varying(255), news_segment boolean DEFAULT false NOT NULL, interview_request boolean DEFAULT false NOT NULL, live_stream boolean DEFAULT false NOT NULL, social_media boolean DEFAULT false NOT NULL, assignment_letter character varying(255), created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.media_registrations OWNER TO postgres; -- -- Name: media_registrations_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.media_registrations_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.media_registrations_id_seq OWNER TO postgres; -- -- Name: media_registrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.media_registrations_id_seq OWNED BY public.media_registrations.id; -- -- Name: migrations; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.migrations ( id integer NOT NULL, migration character varying(255) NOT NULL, batch integer NOT NULL ); ALTER TABLE public.migrations OWNER TO postgres; -- -- Name: migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.migrations_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.migrations_id_seq OWNER TO postgres; -- -- Name: migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.migrations_id_seq OWNED BY public.migrations.id; -- -- Name: notifications; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.notifications ( id bigint NOT NULL, title character varying(255) NOT NULL, content character varying(255) NOT NULL, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.notifications OWNER TO postgres; -- -- Name: notifications_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.notifications_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.notifications_id_seq OWNER TO postgres; -- -- Name: notifications_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.notifications_id_seq OWNED BY public.notifications.id; -- -- Name: organizations; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.organizations ( id bigint NOT NULL, name character varying(255) NOT NULL, business_model character varying(255) NOT NULL, usereventregistration_id bigint, createdby bigint, modifiedby bigint, status character varying(255) NOT NULL, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.organizations OWNER TO postgres; -- -- Name: organizations_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.organizations_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.organizations_id_seq OWNER TO postgres; -- -- Name: organizations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.organizations_id_seq OWNED BY public.organizations.id; -- -- Name: packages; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.packages ( id bigint NOT NULL, title character varying(255) NOT NULL, features json NOT NULL, price numeric(10,2) NOT NULL, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.packages OWNER TO postgres; -- -- Name: packages_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.packages_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.packages_id_seq OWNER TO postgres; -- -- Name: packages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.packages_id_seq OWNED BY public.packages.id; -- -- Name: password_reset_tokens; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.password_reset_tokens ( email character varying(255) NOT NULL, token character varying(255) NOT NULL, created_at timestamp(0) without time zone ); ALTER TABLE public.password_reset_tokens OWNER TO postgres; -- -- Name: permission_roles; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.permission_roles ( id bigint NOT NULL, permission_id bigint NOT NULL, role_id bigint NOT NULL ); ALTER TABLE public.permission_roles OWNER TO postgres; -- -- Name: permission_roles_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.permission_roles_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.permission_roles_id_seq OWNER TO postgres; -- -- Name: permission_roles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.permission_roles_id_seq OWNED BY public.permission_roles.id; -- -- Name: permissions; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.permissions ( id bigint NOT NULL, permission_name character varying(255) NOT NULL, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.permissions OWNER TO postgres; -- -- Name: permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.permissions_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.permissions_id_seq OWNER TO postgres; -- -- Name: permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.permissions_id_seq OWNED BY public.permissions.id; -- -- Name: personal_access_tokens; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.personal_access_tokens ( id bigint NOT NULL, tokenable_type character varying(255) NOT NULL, tokenable_id bigint NOT NULL, name character varying(255) NOT NULL, token character varying(64) NOT NULL, abilities text, last_used_at timestamp(0) without time zone, expires_at timestamp(0) without time zone, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.personal_access_tokens OWNER TO postgres; -- -- Name: personal_access_tokens_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.personal_access_tokens_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.personal_access_tokens_id_seq OWNER TO postgres; -- -- Name: personal_access_tokens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.personal_access_tokens_id_seq OWNED BY public.personal_access_tokens.id; -- -- Name: registration_meeting_types; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.registration_meeting_types ( id bigint NOT NULL, usereventregistration_id bigint NOT NULL, meeting_type character varying(255) NOT NULL, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.registration_meeting_types OWNER TO postgres; -- -- Name: registration_meeting_types_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.registration_meeting_types_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.registration_meeting_types_id_seq OWNER TO postgres; -- -- Name: registration_meeting_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.registration_meeting_types_id_seq OWNED BY public.registration_meeting_types.id; -- -- Name: registration_target_entities; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.registration_target_entities ( id bigint NOT NULL, usereventregistration_id bigint NOT NULL, entity_name character varying(255), entity_type character varying(255), created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.registration_target_entities OWNER TO postgres; -- -- Name: registration_target_entities_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.registration_target_entities_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.registration_target_entities_id_seq OWNER TO postgres; -- -- Name: registration_target_entities_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.registration_target_entities_id_seq OWNED BY public.registration_target_entities.id; -- -- Name: roles; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.roles ( id bigint NOT NULL, role_name character varying(255) NOT NULL, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.roles OWNER TO postgres; -- -- Name: roles_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.roles_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.roles_id_seq OWNER TO postgres; -- -- Name: roles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.roles_id_seq OWNED BY public.roles.id; -- -- Name: sectors; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.sectors ( id bigint NOT NULL, name character varying(255) NOT NULL, status boolean DEFAULT true NOT NULL, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.sectors OWNER TO postgres; -- -- Name: sectors_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.sectors_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.sectors_id_seq OWNER TO postgres; -- -- Name: sectors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.sectors_id_seq OWNED BY public.sectors.id; -- -- Name: sessionparticipants; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.sessionparticipants ( id bigint NOT NULL, eventsession_id bigint NOT NULL, participant character varying(255) NOT NULL, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.sessionparticipants OWNER TO postgres; -- -- Name: sessionparticipants_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.sessionparticipants_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.sessionparticipants_id_seq OWNER TO postgres; -- -- Name: sessionparticipants_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.sessionparticipants_id_seq OWNED BY public.sessionparticipants.id; -- -- Name: sessions; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.sessions ( id character varying(255) NOT NULL, user_id bigint, ip_address character varying(45), user_agent text, payload text NOT NULL, last_activity integer NOT NULL ); ALTER TABLE public.sessions OWNER TO postgres; -- -- Name: side_events; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.side_events ( id bigint NOT NULL, event_date character varying(255) NOT NULL, name character varying(255) NOT NULL, theme text NOT NULL, created_by bigint, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.side_events OWNER TO postgres; -- -- Name: side_events_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.side_events_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.side_events_id_seq OWNER TO postgres; -- -- Name: side_events_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.side_events_id_seq OWNED BY public.side_events.id; -- -- Name: speaker_agendas; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.speaker_agendas ( id bigint NOT NULL, speaker_id bigint NOT NULL, agenda_id bigint NOT NULL, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.speaker_agendas OWNER TO postgres; -- -- Name: speaker_agendas_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.speaker_agendas_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.speaker_agendas_id_seq OWNER TO postgres; -- -- Name: speaker_agendas_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.speaker_agendas_id_seq OWNED BY public.speaker_agendas.id; -- -- Name: speaker_side_events; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.speaker_side_events ( id bigint NOT NULL, speaker_id bigint NOT NULL, side_event_id bigint NOT NULL, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.speaker_side_events OWNER TO postgres; -- -- Name: speaker_side_events_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.speaker_side_events_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.speaker_side_events_id_seq OWNER TO postgres; -- -- Name: speaker_side_events_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.speaker_side_events_id_seq OWNED BY public.speaker_side_events.id; -- -- Name: speakers; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.speakers ( id bigint NOT NULL, usereventregistration_id bigint NOT NULL, name character varying(255), role character varying(255), cv_path character varying(255), have_you_spoken character varying(255), condition character varying(255), linkedin_url character varying(255), website_url character varying(255), request_description character varying(255), previous_speaking_experience character varying(255), created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.speakers OWNER TO postgres; -- -- Name: speakers_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.speakers_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.speakers_id_seq OWNER TO postgres; -- -- Name: speakers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.speakers_id_seq OWNED BY public.speakers.id; -- -- Name: tournaments; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.tournaments ( id bigint NOT NULL, title character varying(255) NOT NULL, description text NOT NULL, amount numeric(10,2), image_url character varying(255), type character varying(255), created_by bigint, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.tournaments OWNER TO postgres; -- -- Name: tournaments_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.tournaments_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.tournaments_id_seq OWNER TO postgres; -- -- Name: tournaments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.tournaments_id_seq OWNED BY public.tournaments.id; -- -- Name: user_registration_tournament; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.user_registration_tournament ( id bigint NOT NULL, usereventregistration_id bigint NOT NULL, tournament_id bigint NOT NULL, amount_paid numeric(10,2), payment_control_number character varying(255), payment_status integer DEFAULT 0 NOT NULL, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.user_registration_tournament OWNER TO postgres; -- -- Name: user_registration_tournament_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.user_registration_tournament_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.user_registration_tournament_id_seq OWNER TO postgres; -- -- Name: user_registration_tournament_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.user_registration_tournament_id_seq OWNED BY public.user_registration_tournament.id; -- -- Name: user_roles; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.user_roles ( id bigint NOT NULL, user_id bigint NOT NULL, role_id bigint NOT NULL ); ALTER TABLE public.user_roles OWNER TO postgres; -- -- Name: user_roles_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.user_roles_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.user_roles_id_seq OWNER TO postgres; -- -- Name: user_roles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.user_roles_id_seq OWNED BY public.user_roles.id; -- -- Name: user_side_events; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.user_side_events ( id bigint NOT NULL, usereventregistration_id bigint NOT NULL, side_event_id bigint NOT NULL, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.user_side_events OWNER TO postgres; -- -- Name: user_side_events_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.user_side_events_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.user_side_events_id_seq OWNER TO postgres; -- -- Name: user_side_events_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.user_side_events_id_seq OWNED BY public.user_side_events.id; -- -- Name: usereventregistrations; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.usereventregistrations ( id bigint NOT NULL, fullname character varying(255) NOT NULL, salutation character varying(255), email character varying(255) NOT NULL, organization character varying(255), nature_of_business character varying(255), jobtitle character varying(255), package_category character varying(255), package_price double precision, extra_commitment character varying(255), sector_specify character varying(255), organization_id bigint, sector_id bigint, networkcheck bigint, sideeventcheck bigint, galadinercheck bigint, phone character varying(255), "position" character varying(255), country character varying(255), home_country character varying(255), number_of_participants character varying(255), preferred_date date, meeting_purpose character varying(255), participant_type character varying(255), passport_photo character varying(255), passport_id character varying(255), controlnumber character varying(255), rejection_reason character varying(255), badge_url character varying(255), createdby bigint, modifiedby bigint, approvestatus bigint, status bigint, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.usereventregistrations OWNER TO postgres; -- -- Name: usereventregistrations_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.usereventregistrations_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.usereventregistrations_id_seq OWNER TO postgres; -- -- Name: usereventregistrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.usereventregistrations_id_seq OWNED BY public.usereventregistrations.id; -- -- Name: userparticipants; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.userparticipants ( id bigint NOT NULL, registration_id bigint NOT NULL, first_name character varying(255) NOT NULL, last_name character varying(255) NOT NULL, email character varying(255) NOT NULL, phone character varying(255) NOT NULL, photo_path character varying(255) NOT NULL, qr_code_path character varying(255), created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.userparticipants OWNER TO postgres; -- -- Name: userparticipants_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.userparticipants_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.userparticipants_id_seq OWNER TO postgres; -- -- Name: userparticipants_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.userparticipants_id_seq OWNED BY public.userparticipants.id; -- -- Name: users; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.users ( id bigint NOT NULL, full_name character varying(255) NOT NULL, companyid character varying(255), email character varying(255), username character varying(255) NOT NULL, phone_number character varying(255) NOT NULL, email_verified_at timestamp(0) without time zone, password character varying(255), role character varying(255) NOT NULL, status character varying(255) DEFAULT 'active'::character varying NOT NULL, address character varying(255), created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone, two_factor_secret text, two_factor_recovery_codes text, two_factor_confirmed_at timestamp(0) without time zone, remember_token character varying(100) ); ALTER TABLE public.users OWNER TO postgres; -- -- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.users_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.users_id_seq OWNER TO postgres; -- -- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id; -- -- Name: venues; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.venues ( id bigint NOT NULL, name character varying(255) NOT NULL, location text NOT NULL, capacity integer, description text, photo_url character varying(255), createdby bigint, modifiedby bigint, status bigint, company_id bigint, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.venues OWNER TO postgres; -- -- Name: venues_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.venues_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.venues_id_seq OWNER TO postgres; -- -- Name: venues_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.venues_id_seq OWNED BY public.venues.id; -- -- Name: agenda_items id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.agenda_items ALTER COLUMN id SET DEFAULT nextval('public.agenda_items_id_seq'::regclass); -- -- Name: agendas id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.agendas ALTER COLUMN id SET DEFAULT nextval('public.agendas_id_seq'::regclass); -- -- Name: booking_items id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.booking_items ALTER COLUMN id SET DEFAULT nextval('public.booking_items_id_seq'::regclass); -- -- Name: booth_bookings id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.booth_bookings ALTER COLUMN id SET DEFAULT nextval('public.booth_bookings_id_seq'::regclass); -- -- Name: booths id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.booths ALTER COLUMN id SET DEFAULT nextval('public.booths_id_seq'::regclass); -- -- Name: companies id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.companies ALTER COLUMN id SET DEFAULT nextval('public.companies_id_seq'::regclass); -- -- Name: eventagenders id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.eventagenders ALTER COLUMN id SET DEFAULT nextval('public.eventagenders_id_seq'::regclass); -- -- Name: events id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.events ALTER COLUMN id SET DEFAULT nextval('public.events_id_seq'::regclass); -- -- Name: eventsessions id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.eventsessions ALTER COLUMN id SET DEFAULT nextval('public.eventsessions_id_seq'::regclass); -- -- Name: facilities id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.facilities ALTER COLUMN id SET DEFAULT nextval('public.facilities_id_seq'::regclass); -- -- Name: failed_jobs id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.failed_jobs ALTER COLUMN id SET DEFAULT nextval('public.failed_jobs_id_seq'::regclass); -- -- Name: guests id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.guests ALTER COLUMN id SET DEFAULT nextval('public.guests_id_seq'::regclass); -- -- Name: media_attendance_days id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.media_attendance_days ALTER COLUMN id SET DEFAULT nextval('public.media_attendance_days_id_seq'::regclass); -- -- Name: media_registrations id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.media_registrations ALTER COLUMN id SET DEFAULT nextval('public.media_registrations_id_seq'::regclass); -- -- Name: migrations id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.migrations ALTER COLUMN id SET DEFAULT nextval('public.migrations_id_seq'::regclass); -- -- Name: notifications id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.notifications ALTER COLUMN id SET DEFAULT nextval('public.notifications_id_seq'::regclass); -- -- Name: organizations id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.organizations ALTER COLUMN id SET DEFAULT nextval('public.organizations_id_seq'::regclass); -- -- Name: packages id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.packages ALTER COLUMN id SET DEFAULT nextval('public.packages_id_seq'::regclass); -- -- Name: permission_roles id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.permission_roles ALTER COLUMN id SET DEFAULT nextval('public.permission_roles_id_seq'::regclass); -- -- Name: permissions id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.permissions ALTER COLUMN id SET DEFAULT nextval('public.permissions_id_seq'::regclass); -- -- Name: personal_access_tokens id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.personal_access_tokens ALTER COLUMN id SET DEFAULT nextval('public.personal_access_tokens_id_seq'::regclass); -- -- Name: registration_meeting_types id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.registration_meeting_types ALTER COLUMN id SET DEFAULT nextval('public.registration_meeting_types_id_seq'::regclass); -- -- Name: registration_target_entities id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.registration_target_entities ALTER COLUMN id SET DEFAULT nextval('public.registration_target_entities_id_seq'::regclass); -- -- Name: roles id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.roles ALTER COLUMN id SET DEFAULT nextval('public.roles_id_seq'::regclass); -- -- Name: sectors id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.sectors ALTER COLUMN id SET DEFAULT nextval('public.sectors_id_seq'::regclass); -- -- Name: sessionparticipants id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.sessionparticipants ALTER COLUMN id SET DEFAULT nextval('public.sessionparticipants_id_seq'::regclass); -- -- Name: side_events id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.side_events ALTER COLUMN id SET DEFAULT nextval('public.side_events_id_seq'::regclass); -- -- Name: speaker_agendas id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.speaker_agendas ALTER COLUMN id SET DEFAULT nextval('public.speaker_agendas_id_seq'::regclass); -- -- Name: speaker_side_events id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.speaker_side_events ALTER COLUMN id SET DEFAULT nextval('public.speaker_side_events_id_seq'::regclass); -- -- Name: speakers id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.speakers ALTER COLUMN id SET DEFAULT nextval('public.speakers_id_seq'::regclass); -- -- Name: tournaments id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.tournaments ALTER COLUMN id SET DEFAULT nextval('public.tournaments_id_seq'::regclass); -- -- Name: user_registration_tournament id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.user_registration_tournament ALTER COLUMN id SET DEFAULT nextval('public.user_registration_tournament_id_seq'::regclass); -- -- Name: user_roles id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.user_roles ALTER COLUMN id SET DEFAULT nextval('public.user_roles_id_seq'::regclass); -- -- Name: user_side_events id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.user_side_events ALTER COLUMN id SET DEFAULT nextval('public.user_side_events_id_seq'::regclass); -- -- Name: usereventregistrations id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.usereventregistrations ALTER COLUMN id SET DEFAULT nextval('public.usereventregistrations_id_seq'::regclass); -- -- Name: userparticipants id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.userparticipants ALTER COLUMN id SET DEFAULT nextval('public.userparticipants_id_seq'::regclass); -- -- Name: users id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.users ALTER COLUMN id SET DEFAULT nextval('public.users_id_seq'::regclass); -- -- Name: venues id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.venues ALTER COLUMN id SET DEFAULT nextval('public.venues_id_seq'::regclass); -- -- Data for Name: agenda_items; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.agenda_items (id, agenda_id, start_times, end_times, topics, created_by, created_at, updated_at) FROM stdin; 1 1 ["10:22 PM"] ["10:21 PM"] ["Walkathon \\u2013 Health"] 3 2026-02-12 07:21:22 2026-02-12 07:21:22 2 1 ["10:21 AM"] ["10:21 PM"] ["Welcome Remark and President Talk"] 3 2026-02-12 07:21:22 2026-02-12 07:21:22 3 2 ["10:21 AM"] ["10:21 AM"] ["Welcome Remark and President Talk"] 3 2026-02-12 07:21:45 2026-02-12 07:21:45 \. -- -- Data for Name: agendas; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.agendas (id, day_number, date, created_at, updated_at) FROM stdin; 1 1 2026-06-10 2026-02-12 07:21:22 2026-02-12 07:21:22 2 2 2026-07-09 2026-02-12 07:21:45 2026-02-12 07:21:45 \. -- -- Data for Name: booking_items; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.booking_items (id, booth_booking_id, booth_id, price_at_booking, created_at, updated_at) FROM stdin; \. -- -- Data for Name: booth_bookings; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.booth_bookings (id, usereventregistration_id, company_id, subtotal, add_on_total, grand_total, status, created_at, updated_at) FROM stdin; \. -- -- Data for Name: booths; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.booths (id, booth_number, dimensions, scheme_type, furniture_set, utilities, visibility, price, status, type, created_at, updated_at) FROM stdin; 1 A-01 3m x 3m (9 SQM) Standard Shell Scheme 1 Info Desk, 2 Chairs, 1 Waste Bin 1 Power (240V), 2 Spotlights, Wi-Fi Prime location 45000.00 available \N 2026-02-08 06:16:54 2026-02-08 06:16:54 2 A-02 3m x 3m (9 SQM) Standard Shell Scheme 1 Info Desk, 2 Chairs, 1 Waste Bin 1 Power (240V), 2 Spotlights, Wi-Fi Prime location 45000.00 available \N 2026-02-08 06:16:54 2026-02-08 06:16:54 3 A-03 3m x 3m (9 SQM) Standard Shell Scheme 1 Info Desk, 2 Chairs, 1 Waste Bin 1 Power (240V), 2 Spotlights, Wi-Fi Prime location 45000.00 booked \N 2026-02-08 06:16:54 2026-02-08 06:16:54 4 A-04 3m x 3m (9 SQM) Standard Shell Scheme 1 Info Desk, 2 Chairs, 1 Waste Bin 1 Power (240V), 2 Spotlights, Wi-Fi Prime location 45000.00 available \N 2026-02-08 06:16:54 2026-02-08 06:16:54 5 B-01 3m x 3m (9 SQM) Standard Shell Scheme 1 Info Desk, 2 Chairs, 1 Waste Bin 1 Power (240V), 2 Spotlights, Wi-Fi Prime location 45000.00 available \N 2026-02-08 06:16:54 2026-02-08 06:16:54 6 B-02 3m x 3m (9 SQM) Standard Shell Scheme 1 Info Desk, 2 Chairs, 1 Waste Bin 1 Power (240V), 2 Spotlights, Wi-Fi Prime location 45000.00 available \N 2026-02-08 06:16:54 2026-02-08 06:16:54 7 B-03 3m x 3m (9 SQM) Standard Shell Scheme 1 Info Desk, 2 Chairs, 1 Waste Bin 1 Power (240V), 2 Spotlights, Wi-Fi Prime location 45000.00 available \N 2026-02-08 06:16:54 2026-02-08 06:16:54 8 B-04 3m x 3m (9 SQM) Standard Shell Scheme 1 Info Desk, 2 Chairs, 1 Waste Bin 1 Power (240V), 2 Spotlights, Wi-Fi Prime location 45000.00 available \N 2026-02-08 06:16:54 2026-02-08 06:16:54 9 C-01 3m x 3m (9 SQM) Standard Shell Scheme 1 Info Desk, 2 Chairs, 1 Waste Bin 1 Power (240V), 2 Spotlights, Wi-Fi Prime location 45000.00 available \N 2026-02-08 06:16:54 2026-02-08 06:16:54 10 C-02 3m x 3m (9 SQM) Standard Shell Scheme 1 Info Desk, 2 Chairs, 1 Waste Bin 1 Power (240V), 2 Spotlights, Wi-Fi Prime location 45000.00 available \N 2026-02-08 06:16:54 2026-02-08 06:16:54 11 C-03 3m x 3m (9 SQM) Standard Shell Scheme 1 Info Desk, 2 Chairs, 1 Waste Bin 1 Power (240V), 2 Spotlights, Wi-Fi Prime location 45000.00 available \N 2026-02-08 06:16:54 2026-02-08 06:16:54 12 C-04 3m x 3m (9 SQM) Standard Shell Scheme 1 Info Desk, 2 Chairs, 1 Waste Bin 1 Power (240V), 2 Spotlights, Wi-Fi Prime location 45000.00 available \N 2026-02-08 06:16:54 2026-02-08 06:16:54 13 D-01 3m x 3m (9 SQM) Standard Shell Scheme 1 Info Desk, 2 Chairs, 1 Waste Bin 1 Power (240V), 2 Spotlights, Wi-Fi Prime location 45000.00 booked \N 2026-02-08 06:16:54 2026-02-08 06:16:54 14 D-02 3m x 3m (9 SQM) Standard Shell Scheme 1 Info Desk, 2 Chairs, 1 Waste Bin 1 Power (240V), 2 Spotlights, Wi-Fi Prime location 45000.00 available \N 2026-02-08 06:16:54 2026-02-08 06:16:54 15 D-03 3m x 3m (9 SQM) Standard Shell Scheme 1 Info Desk, 2 Chairs, 1 Waste Bin 1 Power (240V), 2 Spotlights, Wi-Fi Prime location 45000.00 available \N 2026-02-08 06:16:54 2026-02-08 06:16:54 16 D-04 3m x 3m (9 SQM) Standard Shell Scheme 1 Info Desk, 2 Chairs, 1 Waste Bin 1 Power (240V), 2 Spotlights, Wi-Fi Prime location 45000.00 available \N 2026-02-08 06:16:54 2026-02-08 06:16:54 17 E-01 3m x 3m (9 SQM) Standard Shell Scheme 1 Info Desk, 2 Chairs, 1 Waste Bin 1 Power (240V), 2 Spotlights, Wi-Fi Prime location 45000.00 available \N 2026-02-08 06:16:54 2026-02-08 06:16:54 18 E-02 3m x 3m (9 SQM) Standard Shell Scheme 1 Info Desk, 2 Chairs, 1 Waste Bin 1 Power (240V), 2 Spotlights, Wi-Fi Prime location 45000.00 available \N 2026-02-08 06:16:54 2026-02-08 06:16:54 19 E-03 3m x 3m (9 SQM) Standard Shell Scheme 1 Info Desk, 2 Chairs, 1 Waste Bin 1 Power (240V), 2 Spotlights, Wi-Fi Prime location 45000.00 available \N 2026-02-08 06:16:54 2026-02-08 06:16:54 20 E-04 3m x 3m (9 SQM) Standard Shell Scheme 1 Info Desk, 2 Chairs, 1 Waste Bin 1 Power (240V), 2 Spotlights, Wi-Fi Prime location 45000.00 available \N 2026-02-08 06:16:54 2026-02-08 06:16:54 \. -- -- Data for Name: companies; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.companies (id, name, website, industry, bio, logo_path, banner, created_at, updated_at) FROM stdin; \. -- -- Data for Name: eventagenders; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.eventagenders (id, event_id, agenda, created_at, updated_at) FROM stdin; \. -- -- Data for Name: events; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.events (id, institution_name, logo_url, title, description, start_date, end_date, photo_url, control_number, venue_id, status, createdby, modifiedby, company_id, created_at, updated_at) FROM stdin; \. -- -- Data for Name: eventsessions; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.eventsessions (id, event_id, quest_id, title, description, start_date, end_date, start_time, end_time, createdby, modifiedby, company_id, status, location, created_at, updated_at) FROM stdin; \. -- -- Data for Name: facilities; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.facilities (id, name, venue_id, created_at, updated_at) FROM stdin; \. -- -- Data for Name: failed_jobs; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.failed_jobs (id, uuid, connection, queue, payload, exception, failed_at) FROM stdin; \. -- -- Data for Name: guests; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.guests (id, name, title, role, bio, photo_url, venue_id, createdby, modifiedby, company_id, created_at, updated_at) FROM stdin; \. -- -- Data for Name: media_attendance_days; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.media_attendance_days (id, media_registration_id, day, created_at, updated_at) FROM stdin; \. -- -- Data for Name: media_registrations; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.media_registrations (id, usereventregistration_id, media_name, website_url, press_id_number, dietary_accessibility, terms_acceptance, portfolio_url, media_type, news_segment, interview_request, live_stream, social_media, assignment_letter, created_at, updated_at) FROM stdin; \. -- -- Data for Name: migrations; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.migrations (id, migration, batch) FROM stdin; 1 2014_10_12_000000_create_users_table 1 2 2014_10_12_100000_create_password_reset_tokens_table 1 3 2014_10_12_200000_add_two_factor_columns_to_users_table 1 4 2019_08_19_000000_create_failed_jobs_table 1 5 2019_12_14_000001_create_personal_access_tokens_table 1 6 2023_09_02_160625_create_roles_table 1 7 2023_09_02_160720_create_user_roles_table 1 8 2024_03_07_084653_create_sessions_table 1 9 2024_03_07_110802_create_permissions_table 1 10 2024_03_07_110813_create_permission_roles_table 1 11 2024_08_08_104657_create_notifications_table 1 12 2025_03_30_205508_create_venues_table 1 13 2025_03_31_204857_create_events_table 1 14 2025_03_31_205356_create_guests_table 1 15 2025_03_31_205440_create_eventsessions_table 1 16 2025_04_01_112818_create_facilities_table 1 17 2025_04_01_155030_create_eventagenders_table 1 18 2025_04_07_220019_add_remember_token_to_users_table 1 19 2025_04_10_185232_create_usereventregistrations_table 1 20 2025_04_12_200152_create_organizations_table 1 21 2025_06_27_055109_create_sessionparticipants_table 1 22 2025_07_04_190038_create_userparticipants_table 1 23 2026_01_23_085224_create_sectors_table 1 24 2026_01_28_041841_create_packages_table 1 25 2026_01_29_205829_create_agendas_table 1 26 2026_01_29_205829_create_side_events_table 1 27 2026_01_30_000206_create_tournaments_table 1 28 2026_01_30_075105_create_agenda_items_table 1 29 2026_01_31_180845_create_speakers_table 1 30 2026_02_01_094745_create_user_registration_tournament_table 1 31 2026_02_01_140323_create_companies_table 1 32 2026_02_01_140548_create_booths_table 1 33 2026_02_01_140800_create_booth_bookings_table 1 34 2026_02_01_141451_create_booking_items_table 1 35 2026_02_01_152002_create_media_registrations_table 1 36 2026_02_01_152005_create_media_attendance_days_table 1 37 2026_02_02_063302_create_speaker_agendas_table 1 38 2026_02_02_063308_create_speaker_side_events_table 1 39 2026_02_03_151411_create_registration_meeting_types_table 1 40 2026_02_03_151449_create_registration_target_entities_table 1 41 2026_02_07_083256_create_user_side_events_table 1 \. -- -- Data for Name: notifications; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.notifications (id, title, content, created_at, updated_at) FROM stdin; \. -- -- Data for Name: organizations; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.organizations (id, name, business_model, usereventregistration_id, createdby, modifiedby, status, created_at, updated_at) FROM stdin; 1 ZRA B2G \N 3 \N 1 2026-02-08 08:42:41 2026-02-08 08:42:41 2 ZIPA B2G \N 3 \N 1 2026-02-08 08:42:54 2026-02-08 08:42:54 3 ZIC B2G \N 3 \N 1 2026-02-08 08:43:05 2026-02-08 08:43:05 4 AZAM B2B \N 3 \N 1 2026-02-08 08:43:22 2026-02-08 08:43:22 \. -- -- Data for Name: packages; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.packages (id, title, features, price, created_at, updated_at) FROM stdin; 1 PLATINUM ["Logo integrated into summit branding","Premium Exhibition space","10 VIP delegates passes","Opening key note speaking slot","Access to the high-level opening ceremony and sector-side events","Access to the Gala Dinner","Access to Site Visits and networking","VIP seating and protocol recognition","Branding all media and press release"] 50000.00 2026-02-08 06:16:54 2026-02-10 05:30:01 2 GOLD ["Logo integrated into summit branding","Access to Exhibition booth","5 VIP delegates passes","Panel speaking opportunity","Access to the high-level opening ceremony and sector-side events","Access to the Gala Dinner","Access to Site Visits and networking","Branding all media and press release"] 30000.00 2026-02-08 06:16:54 2026-02-10 05:31:37 3 SILVER ["Logo integrated into summit branding","Access to Exhibition booth","3 VIP delegates passes","Access to the high-level opening ceremony and sector-side events","Access to the Gala Dinner","Access to Site Visits and networking","Branding all media and press release"] 20000.00 2026-02-08 06:16:54 2026-02-10 05:32:44 \. -- -- Data for Name: password_reset_tokens; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.password_reset_tokens (email, token, created_at) FROM stdin; \. -- -- Data for Name: permission_roles; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.permission_roles (id, permission_id, role_id) FROM stdin; 1 1 1 2 2 1 3 3 1 4 4 1 5 5 1 6 6 1 \. -- -- Data for Name: permissions; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.permissions (id, permission_name, created_at, updated_at) FROM stdin; 1 Admin access 2026-02-08 06:16:53 2026-02-08 06:16:53 2 adding new user 2026-02-08 06:16:53 2026-02-08 06:16:53 3 User management 2026-02-08 06:16:53 2026-02-08 06:16:53 4 disabling user 2026-02-08 06:16:53 2026-02-08 06:16:53 5 managing roles 2026-02-08 06:16:53 2026-02-08 06:16:53 6 adding roles to user 2026-02-08 06:16:53 2026-02-08 06:16:53 7 auditing system and activities 2026-02-08 06:16:53 2026-02-08 06:16:53 8 adding contract 2026-02-08 06:16:53 2026-02-08 06:16:53 9 view contract 2026-02-08 06:16:53 2026-02-08 06:16:53 10 adding consultant 2026-02-08 06:16:53 2026-02-08 06:16:53 11 viewing consultant 2026-02-08 06:16:53 2026-02-08 06:16:53 12 viewing report 2026-02-08 06:16:53 2026-02-08 06:16:53 13 approve contract 2026-02-08 06:16:53 2026-02-08 06:16:53 14 extend contract 2026-02-08 06:16:53 2026-02-08 06:16:53 15 terminate contract 2026-02-08 06:16:53 2026-02-08 06:16:53 16 viewing contract 2026-02-08 06:16:53 2026-02-08 06:16:53 17 resend contract 2026-02-08 06:16:53 2026-02-08 06:16:53 \. -- -- Data for Name: personal_access_tokens; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.personal_access_tokens (id, tokenable_type, tokenable_id, name, token, abilities, last_used_at, expires_at, created_at, updated_at) FROM stdin; \. -- -- Data for Name: registration_meeting_types; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.registration_meeting_types (id, usereventregistration_id, meeting_type, created_at, updated_at) FROM stdin; 1 1 B2G 2026-02-10 05:11:31 2026-02-10 05:11:31 \. -- -- Data for Name: registration_target_entities; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.registration_target_entities (id, usereventregistration_id, entity_name, entity_type, created_at, updated_at) FROM stdin; 1 1 1 govt 2026-02-10 05:11:31 2026-02-10 05:11:31 \. -- -- Data for Name: roles; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.roles (id, role_name, created_at, updated_at) FROM stdin; 1 admin 2026-02-08 06:16:53 2026-02-08 06:16:53 \. -- -- Data for Name: sectors; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.sectors (id, name, status, created_at, updated_at) FROM stdin; 1 Tourisim t 2026-02-08 08:41:03 2026-02-08 08:41:03 2 Manufucture t 2026-02-08 08:41:17 2026-02-08 08:41:17 4 Transport t 2026-02-08 08:42:07 2026-02-08 08:42:07 5 Real Estate t 2026-02-08 08:42:23 2026-02-08 08:42:23 3 Renewable Energy t 2026-02-08 08:42:00 2026-02-08 08:46:07 \. -- -- Data for Name: sessionparticipants; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.sessionparticipants (id, eventsession_id, participant, created_at, updated_at) FROM stdin; \. -- -- Data for Name: sessions; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.sessions (id, user_id, ip_address, user_agent, payload, last_activity) FROM stdin; lD7n2lQJCKyQlSHJhfipNJ9RveatGDlOJ0mL8Clq 3 127.0.0.1 Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36 YTo1OntzOjY6Il90b2tlbiI7czo0MDoiaFBPaW05cFNBS0Z0aDJEU0NnS0g0OVlFeHQwM3VDMEpPcVlpeW1FYSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9hcGkvc2lkZWV2ZW50cyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjM7czoyMToicGFzc3dvcmRfaGFzaF9zYW5jdHVtIjtzOjYwOiIkMnkkMTIkL0pma294TmNNNGcxZE5kQk5haW5QdUNySDhxb1JHUnllL3pqZEVoclRlNHBYQ3Nhei40bi4iO30= 1770880978 \. -- -- Data for Name: side_events; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.side_events (id, event_date, name, theme, created_by, created_at, updated_at) FROM stdin; 1 2026-06-10 Tourism Test haajjaja jakajka kajkaj kjakjakj ajkjakja 3 2026-02-08 06:56:03 2026-02-08 06:56:03 2 2026-06-10 Renewable Energy Test haajjaja jakajka kajkaj kjakjakj ajkjakja dsdsd 3 2026-02-08 06:56:03 2026-02-08 06:56:03 3 2026-06-10 ICT Test haajjaja jakajka kajkaj kjakjakj ajkjakja dsdsd 3 2026-02-08 06:56:03 2026-02-08 06:56:03 4 2026-06-11 Agribusiness Test haajjaja jakajka kajkaj kjakjakj ajkjakja dsdjjjh 3 2026-02-08 06:58:34 2026-02-08 06:58:34 5 2026-06-11 Blue Economy Test haajjaja jakajka kajkaj kjakjakj ajkjakja sds fff 3 2026-02-08 06:58:34 2026-02-08 06:58:34 \. -- -- Data for Name: speaker_agendas; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.speaker_agendas (id, speaker_id, agenda_id, created_at, updated_at) FROM stdin; \. -- -- Data for Name: speaker_side_events; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.speaker_side_events (id, speaker_id, side_event_id, created_at, updated_at) FROM stdin; \. -- -- Data for Name: speakers; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.speakers (id, usereventregistration_id, name, role, cv_path, have_you_spoken, condition, linkedin_url, website_url, request_description, previous_speaking_experience, created_at, updated_at) FROM stdin; \. -- -- Data for Name: tournaments; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.tournaments (id, title, description, amount, image_url, type, created_by, created_at, updated_at) FROM stdin; 1 Gala Dinner The tournament is designed to strengthen relationships formed throughout the conference in a relaxed, informal setting. By moving interactions from the boardroom to the fairways, it allows investors and partners to deepen their connections and engage in open dialogue beyond the rigidity of formal meetings. This is an essential opportunity to solidify your network and cement the week's discussions before your departure. 5000.00 uploads/tournaments/1770532377_69882e19954e1.jpeg vip 3 2026-02-08 06:32:57 2026-02-08 06:32:57 2 Gala Dinner The tournament is designed to strengthen relationships formed throughout the conference in a relaxed, informal setting. By moving interactions from the boardroom to the fairways, it allows investors and partners to deepen their connections and engage in open dialogue beyond the rigidity of formal meetings. This is an essential opportunity to solidify your network and cement the week's discussions before your departure. 500.00 uploads/tournaments/1770532412_69882e3cac58e.jpeg delegate 3 2026-02-08 06:33:32 2026-02-08 06:33:32 \. -- -- Data for Name: user_registration_tournament; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.user_registration_tournament (id, usereventregistration_id, tournament_id, amount_paid, payment_control_number, payment_status, created_at, updated_at) FROM stdin; 1 2 2 \N \N 0 2026-02-10 05:12:59 2026-02-10 05:12:59 \. -- -- Data for Name: user_roles; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.user_roles (id, user_id, role_id) FROM stdin; 1 1 1 2 2 1 \. -- -- Data for Name: user_side_events; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.user_side_events (id, usereventregistration_id, side_event_id, created_at, updated_at) FROM stdin; 1 1 3 2026-02-10 05:11:31 2026-02-10 05:11:31 2 1 4 2026-02-10 05:11:31 2026-02-10 05:11:31 3 2 1 2026-02-10 05:12:59 2026-02-10 05:12:59 \. -- -- Data for Name: usereventregistrations; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.usereventregistrations (id, fullname, salutation, email, organization, nature_of_business, jobtitle, package_category, package_price, extra_commitment, sector_specify, organization_id, sector_id, networkcheck, sideeventcheck, galadinercheck, phone, "position", country, home_country, number_of_participants, preferred_date, meeting_purpose, participant_type, passport_photo, passport_id, controlnumber, rejection_reason, badge_url, createdby, modifiedby, approvestatus, status, created_at, updated_at) FROM stdin; 1 Khamis Said Mohd Mr khasamoh.12@gmail.com ZIPA \N ICT \N \N \N Please Specify \N 5 1 1 \N 0773245757 \N Åland Islands American Samoa \N 2026-06-12 test delegate uploads/documents/1770700291_698abe03b3c1f.png uploads/documents/1770700291_698abe03b3c83_bio.png CN-1770700485-5645 \N \N \N \N 2 1 2026-02-10 05:11:31 2026-02-10 05:14:45 2 Ali Said Mohd Mr khasamoh.12@gmail.com ZIPA \N ICT \N \N \N Please Specify \N 1 0 1 \N 0773245757 \N Åland Islands American Samoa \N 2026-06-12 test delegate uploads/documents/1770700379_698abe5b096c2.png uploads/documents/1770700379_698abe5b09738_bio.png CN-1770700644-5455 \N \N \N \N 2 1 2026-02-10 05:12:59 2026-02-10 05:17:24 \. -- -- Data for Name: userparticipants; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.userparticipants (id, registration_id, first_name, last_name, email, phone, photo_path, qr_code_path, created_at, updated_at) FROM stdin; \. -- -- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.users (id, full_name, companyid, email, username, phone_number, email_verified_at, password, role, status, address, created_at, updated_at, two_factor_secret, two_factor_recovery_codes, two_factor_confirmed_at, remember_token) FROM stdin; 1 Hussein Mcheni \N admin@gmail.com mcheni 255657193660 \N $2y$12$v0/5C43UAHmlwTpKECyBw.SfSrbRDtK.72N0yI5ug9K3lZWsC0S9W admin active Mbagara 2026-02-08 06:16:54 2026-02-08 06:16:54 \N \N \N \N 2 Fahmy \N fahmy@gmail.com TAI +255762223264 \N $2y$12$7Yqm.lAZe7UEWDuCklH3Du8/gDa.sKM5nyBjc6w1QpeoWPwNFiQPy admin active Kinondoni 2026-02-08 06:16:54 2026-02-08 06:16:54 \N \N \N \N 3 Khamis Said Mohd \N khasamoh.12@gmail.com khasamoh 255773274743 \N $2y$12$/JfkoxNcM4g1dNdBNainPuCrH8qoRGRye/zjdEhrTe4pXCsaz.4n. admin active Amani 2026-02-08 06:25:43 2026-02-08 06:25:43 \N \N \N \N \. -- -- Data for Name: venues; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.venues (id, name, location, capacity, description, photo_url, createdby, modifiedby, status, company_id, created_at, updated_at) FROM stdin; \. -- -- Name: agenda_items_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.agenda_items_id_seq', 3, true); -- -- Name: agendas_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.agendas_id_seq', 2, true); -- -- Name: booking_items_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.booking_items_id_seq', 1, false); -- -- Name: booth_bookings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.booth_bookings_id_seq', 1, false); -- -- Name: booths_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.booths_id_seq', 20, true); -- -- Name: companies_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.companies_id_seq', 1, false); -- -- Name: eventagenders_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.eventagenders_id_seq', 1, false); -- -- Name: events_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.events_id_seq', 1, false); -- -- Name: eventsessions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.eventsessions_id_seq', 1, false); -- -- Name: facilities_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.facilities_id_seq', 1, false); -- -- Name: failed_jobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.failed_jobs_id_seq', 1, false); -- -- Name: guests_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.guests_id_seq', 1, false); -- -- Name: media_attendance_days_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.media_attendance_days_id_seq', 1, false); -- -- Name: media_registrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.media_registrations_id_seq', 1, false); -- -- Name: migrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.migrations_id_seq', 41, true); -- -- Name: notifications_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.notifications_id_seq', 1, false); -- -- Name: organizations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.organizations_id_seq', 4, true); -- -- Name: packages_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.packages_id_seq', 3, true); -- -- Name: permission_roles_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.permission_roles_id_seq', 6, true); -- -- Name: permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.permissions_id_seq', 17, true); -- -- Name: personal_access_tokens_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.personal_access_tokens_id_seq', 1, false); -- -- Name: registration_meeting_types_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.registration_meeting_types_id_seq', 1, true); -- -- Name: registration_target_entities_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.registration_target_entities_id_seq', 1, true); -- -- Name: roles_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.roles_id_seq', 1, true); -- -- Name: sectors_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.sectors_id_seq', 5, true); -- -- Name: sessionparticipants_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.sessionparticipants_id_seq', 1, false); -- -- Name: side_events_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.side_events_id_seq', 5, true); -- -- Name: speaker_agendas_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.speaker_agendas_id_seq', 1, false); -- -- Name: speaker_side_events_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.speaker_side_events_id_seq', 1, false); -- -- Name: speakers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.speakers_id_seq', 1, false); -- -- Name: tournaments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.tournaments_id_seq', 2, true); -- -- Name: user_registration_tournament_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.user_registration_tournament_id_seq', 1, true); -- -- Name: user_roles_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.user_roles_id_seq', 2, true); -- -- Name: user_side_events_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.user_side_events_id_seq', 3, true); -- -- Name: usereventregistrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.usereventregistrations_id_seq', 2, true); -- -- Name: userparticipants_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.userparticipants_id_seq', 1, false); -- -- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.users_id_seq', 3, true); -- -- Name: venues_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.venues_id_seq', 1, false); -- -- Name: agenda_items agenda_items_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.agenda_items ADD CONSTRAINT agenda_items_pkey PRIMARY KEY (id); -- -- Name: agendas agendas_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.agendas ADD CONSTRAINT agendas_pkey PRIMARY KEY (id); -- -- Name: booking_items booking_items_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.booking_items ADD CONSTRAINT booking_items_pkey PRIMARY KEY (id); -- -- Name: booth_bookings booth_bookings_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.booth_bookings ADD CONSTRAINT booth_bookings_pkey PRIMARY KEY (id); -- -- Name: booths booths_booth_number_unique; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.booths ADD CONSTRAINT booths_booth_number_unique UNIQUE (booth_number); -- -- Name: booths booths_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.booths ADD CONSTRAINT booths_pkey PRIMARY KEY (id); -- -- Name: companies companies_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.companies ADD CONSTRAINT companies_pkey PRIMARY KEY (id); -- -- Name: eventagenders eventagenders_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.eventagenders ADD CONSTRAINT eventagenders_pkey PRIMARY KEY (id); -- -- Name: events events_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.events ADD CONSTRAINT events_pkey PRIMARY KEY (id); -- -- Name: eventsessions eventsessions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.eventsessions ADD CONSTRAINT eventsessions_pkey PRIMARY KEY (id); -- -- Name: facilities facilities_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.facilities ADD CONSTRAINT facilities_pkey PRIMARY KEY (id); -- -- Name: failed_jobs failed_jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.failed_jobs ADD CONSTRAINT failed_jobs_pkey PRIMARY KEY (id); -- -- Name: failed_jobs failed_jobs_uuid_unique; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.failed_jobs ADD CONSTRAINT failed_jobs_uuid_unique UNIQUE (uuid); -- -- Name: guests guests_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.guests ADD CONSTRAINT guests_pkey PRIMARY KEY (id); -- -- Name: media_attendance_days media_attendance_days_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.media_attendance_days ADD CONSTRAINT media_attendance_days_pkey PRIMARY KEY (id); -- -- Name: media_registrations media_registrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.media_registrations ADD CONSTRAINT media_registrations_pkey PRIMARY KEY (id); -- -- Name: migrations migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.migrations ADD CONSTRAINT migrations_pkey PRIMARY KEY (id); -- -- Name: notifications notifications_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.notifications ADD CONSTRAINT notifications_pkey PRIMARY KEY (id); -- -- Name: organizations organizations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.organizations ADD CONSTRAINT organizations_pkey PRIMARY KEY (id); -- -- Name: packages packages_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.packages ADD CONSTRAINT packages_pkey PRIMARY KEY (id); -- -- Name: password_reset_tokens password_reset_tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.password_reset_tokens ADD CONSTRAINT password_reset_tokens_pkey PRIMARY KEY (email); -- -- Name: permission_roles permission_roles_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.permission_roles ADD CONSTRAINT permission_roles_pkey PRIMARY KEY (id); -- -- Name: permissions permissions_permission_name_unique; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.permissions ADD CONSTRAINT permissions_permission_name_unique UNIQUE (permission_name); -- -- Name: permissions permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.permissions ADD CONSTRAINT permissions_pkey PRIMARY KEY (id); -- -- Name: personal_access_tokens personal_access_tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.personal_access_tokens ADD CONSTRAINT personal_access_tokens_pkey PRIMARY KEY (id); -- -- Name: personal_access_tokens personal_access_tokens_token_unique; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.personal_access_tokens ADD CONSTRAINT personal_access_tokens_token_unique UNIQUE (token); -- -- Name: registration_meeting_types registration_meeting_types_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.registration_meeting_types ADD CONSTRAINT registration_meeting_types_pkey PRIMARY KEY (id); -- -- Name: registration_target_entities registration_target_entities_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.registration_target_entities ADD CONSTRAINT registration_target_entities_pkey PRIMARY KEY (id); -- -- Name: roles roles_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.roles ADD CONSTRAINT roles_pkey PRIMARY KEY (id); -- -- Name: roles roles_role_name_unique; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.roles ADD CONSTRAINT roles_role_name_unique UNIQUE (role_name); -- -- Name: sectors sectors_name_unique; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.sectors ADD CONSTRAINT sectors_name_unique UNIQUE (name); -- -- Name: sectors sectors_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.sectors ADD CONSTRAINT sectors_pkey PRIMARY KEY (id); -- -- Name: sessionparticipants sessionparticipants_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.sessionparticipants ADD CONSTRAINT sessionparticipants_pkey PRIMARY KEY (id); -- -- Name: sessions sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.sessions ADD CONSTRAINT sessions_pkey PRIMARY KEY (id); -- -- Name: side_events side_events_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.side_events ADD CONSTRAINT side_events_pkey PRIMARY KEY (id); -- -- Name: speaker_agendas speaker_agendas_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.speaker_agendas ADD CONSTRAINT speaker_agendas_pkey PRIMARY KEY (id); -- -- Name: speaker_side_events speaker_side_events_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.speaker_side_events ADD CONSTRAINT speaker_side_events_pkey PRIMARY KEY (id); -- -- Name: speakers speakers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.speakers ADD CONSTRAINT speakers_pkey PRIMARY KEY (id); -- -- Name: tournaments tournaments_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.tournaments ADD CONSTRAINT tournaments_pkey PRIMARY KEY (id); -- -- Name: user_registration_tournament user_registration_tournament_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.user_registration_tournament ADD CONSTRAINT user_registration_tournament_pkey PRIMARY KEY (id); -- -- Name: user_roles user_roles_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.user_roles ADD CONSTRAINT user_roles_pkey PRIMARY KEY (id); -- -- Name: user_side_events user_side_events_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.user_side_events ADD CONSTRAINT user_side_events_pkey PRIMARY KEY (id); -- -- Name: usereventregistrations usereventregistrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.usereventregistrations ADD CONSTRAINT usereventregistrations_pkey PRIMARY KEY (id); -- -- Name: userparticipants userparticipants_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.userparticipants ADD CONSTRAINT userparticipants_pkey PRIMARY KEY (id); -- -- Name: users users_email_unique; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.users ADD CONSTRAINT users_email_unique UNIQUE (email); -- -- Name: users users_password_unique; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.users ADD CONSTRAINT users_password_unique UNIQUE (password); -- -- Name: users users_phone_number_unique; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.users ADD CONSTRAINT users_phone_number_unique UNIQUE (phone_number); -- -- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.users ADD CONSTRAINT users_pkey PRIMARY KEY (id); -- -- Name: users users_username_unique; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.users ADD CONSTRAINT users_username_unique UNIQUE (username); -- -- Name: venues venues_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.venues ADD CONSTRAINT venues_pkey PRIMARY KEY (id); -- -- Name: personal_access_tokens_tokenable_type_tokenable_id_index; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX personal_access_tokens_tokenable_type_tokenable_id_index ON public.personal_access_tokens USING btree (tokenable_type, tokenable_id); -- -- Name: sessions_last_activity_index; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX sessions_last_activity_index ON public.sessions USING btree (last_activity); -- -- Name: sessions_user_id_index; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX sessions_user_id_index ON public.sessions USING btree (user_id); -- -- Name: permission_roles permission_roles_permission_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.permission_roles ADD CONSTRAINT permission_roles_permission_id_foreign FOREIGN KEY (permission_id) REFERENCES public.permissions(id) ON DELETE CASCADE; -- -- Name: permission_roles permission_roles_role_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.permission_roles ADD CONSTRAINT permission_roles_role_id_foreign FOREIGN KEY (role_id) REFERENCES public.roles(id) ON DELETE CASCADE; -- -- Name: user_roles user_roles_role_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.user_roles ADD CONSTRAINT user_roles_role_id_foreign FOREIGN KEY (role_id) REFERENCES public.roles(id) ON DELETE CASCADE; -- -- Name: user_roles user_roles_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.user_roles ADD CONSTRAINT user_roles_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE; -- -- PostgreSQL database dump complete -- \unrestrict vMzOYIgcYQfRWBNz334K5zaLN72xzh32DKNBKnh79EIbO8ZlByFyUNzIacQdGhU