PGDMP  #    -                |            db_idein    16.0    16.0                0    0    ENCODING    ENCODING        SET client_encoding = 'UTF8';
                      false                       0    0 
   STDSTRINGS 
   STDSTRINGS     (   SET standard_conforming_strings = 'on';
                      false                       0    0 
   SEARCHPATH 
   SEARCHPATH     8   SELECT pg_catalog.set_config('search_path', '', false);
                      false                       1262    16390    db_idein    DATABASE        CREATE DATABASE db_idein WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PROVIDER = libc LOCALE = 'English_Indonesia.1252';
    DROP DATABASE db_idein;
                postgres    false                        1259    16530    activity_log    TABLE       CREATE TABLE public.activity_log (
    id bigint NOT NULL,
    log_name character varying(255),
    description text NOT NULL,
    subject_id bigint,
    subject_type character varying(255),
    causer_id bigint,
    causer_type character varying(255),
    properties json,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    event character varying(255),
    batch_uuid uuid
);
     DROP TABLE public.activity_log;
       public         heap    postgres    false                        1259    16529    activity_log_id_seq    SEQUENCE     |   CREATE SEQUENCE public.activity_log_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 *   DROP SEQUENCE public.activity_log_id_seq;
       public          postgres    false    236                       0    0    activity_log_id_seq    SEQUENCE OWNED BY     K   ALTER SEQUENCE public.activity_log_id_seq OWNED BY public.activity_log.id;
          public          postgres    false    235                        1259    16508    announcements    TABLE     
  CREATE TABLE public.announcements (
    id bigint NOT NULL,
    area character varying(255),
    type character varying(255) DEFAULT 'info'::character varying NOT NULL,
    message text NOT NULL,
    enabled boolean DEFAULT true NOT NULL,
    starts_at timestamp(0) without time zone,
    ends_at timestamp(0) without time zone,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    CONSTRAINT announcements_area_check CHECK (((area)::text = ANY ((ARRAY['frontend'::character varying, 'backend'::character varying])::text[]))),
    CONSTRAINT announcements_type_check CHECK (((type)::text = ANY ((ARRAY['info'::character varying, 'danger'::character varying, 'warning'::character varying, 'success'::character varying])::text[])))
);
 !   DROP TABLE public.announcements;
       public         heap    postgres    false                        1259    16507    announcements_id_seq    SEQUENCE     }   CREATE SEQUENCE public.announcements_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 +   DROP SEQUENCE public.announcements_id_seq;
       public          postgres    false    232                       0    0    announcements_id_seq    SEQUENCE OWNED BY     M   ALTER SEQUENCE public.announcements_id_seq OWNED BY public.announcements.id;
          public          postgres    false    231                        1259    25358    apply_forms    TABLE     <  CREATE TABLE public.apply_forms (
    id bigint NOT NULL,
    email character varying(255) NOT NULL,
    name character varying(255) NOT NULL,
    last_name character varying(255) NOT NULL,
    phone character varying(255) NOT NULL,
    base_in_jakarta character varying(255) NOT NULL,
    address text NOT NULL,
    about_yourself text NOT NULL,
    find_idein character varying(255) NOT NULL,
    cv character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    read boolean DEFAULT false NOT NULL
);
    DROP TABLE public.apply_forms;
       public         heap    postgres    false                        1259    25357    apply_forms_id_seq    SEQUENCE     {   CREATE SEQUENCE public.apply_forms_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 )   DROP SEQUENCE public.apply_forms_id_seq;
       public          postgres    false    250                       0    0    apply_forms_id_seq    SEQUENCE OWNED BY     I   ALTER SEQUENCE public.apply_forms_id_seq OWNED BY public.apply_forms.id;
          public          postgres    false    249                        1259    25346    book_sessions    TABLE       CREATE TABLE public.book_sessions (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    email character varying(255) NOT NULL,
    company character varying(255) NOT NULL,
    goals text NOT NULL,
    can_help character varying(255) NOT NULL,
    budget character varying(255) NOT NULL,
    hear_about_us character varying(255) NOT NULL,
    referral character varying(255) NOT NULL,
    read boolean DEFAULT false NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);
 !   DROP TABLE public.book_sessions;
       public         heap    postgres    false                        1259    25345    book_sessions_id_seq    SEQUENCE     }   CREATE SEQUENCE public.book_sessions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 +   DROP SEQUENCE public.book_sessions_id_seq;
       public          postgres    false    248                       0    0    book_sessions_id_seq    SEQUENCE OWNED BY     M   ALTER SEQUENCE public.book_sessions_id_seq OWNED BY public.book_sessions.id;
          public          postgres    false    247                        1259    16630 
   categories    TABLE        CREATE TABLE public.categories (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    slug character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);
    DROP TABLE public.categories;
       public         heap    postgres    false                        1259    16629    categories_id_seq    SEQUENCE     z   CREATE SEQUENCE public.categories_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 (   DROP SEQUENCE public.categories_id_seq;
       public          postgres    false    242                       0    0    categories_id_seq    SEQUENCE OWNED BY     G   ALTER SEQUENCE public.categories_id_seq OWNED BY public.categories.id;
          public          postgres    false    241                        1259    25444    cms_perpages    TABLE       CREATE TABLE public.cms_perpages (
    id bigint NOT NULL,
    page_id bigint NOT NULL,
    key character varying(255) NOT NULL,
    type character varying(255) NOT NULL,
    input_type character varying(255) NOT NULL,
    value text,
    note character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    label character varying(255),
    CONSTRAINT cms_perpages_input_type_check CHECK (((input_type)::text = ANY ((ARRAY['text'::character varying, 'image'::character varying, 'textarea'::character varying, 'texteditor'::character varying])::text[]))),
    CONSTRAINT cms_perpages_type_check CHECK (((type)::text = ANY ((ARRAY['text'::character varying, 'image'::character varying, 'text_image'::character varying])::text[])))
);
     DROP TABLE public.cms_perpages;
       public         heap    postgres    false                        1259    25443    cms_perpages_id_seq    SEQUENCE     |   CREATE SEQUENCE public.cms_perpages_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 *   DROP SEQUENCE public.cms_perpages_id_seq;
       public          postgres    false    256                       0    0    cms_perpages_id_seq    SEQUENCE OWNED BY     K   ALTER SEQUENCE public.cms_perpages_id_seq OWNED BY public.cms_perpages.id;
          public          postgres    false    255                        1259    16619    explores    TABLE       CREATE TABLE public.explores (
    id bigint NOT NULL,
    category_id bigint NOT NULL,
    title character varying(255) NOT NULL,
    slug character varying(255) NOT NULL,
    image character varying(255),
    body text NOT NULL,
    published_at timestamp(0) without time zone,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    read_time character varying(255)
);
    DROP TABLE public.explores;
       public         heap    postgres    false                        1259    16618    explores_id_seq    SEQUENCE     x   CREATE SEQUENCE public.explores_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 &   DROP SEQUENCE public.explores_id_seq;
       public          postgres    false    240                       0    0    explores_id_seq    SEQUENCE OWNED BY     C   ALTER SEQUENCE public.explores_id_seq OWNED BY public.explores.id;
          public          postgres    false    239                        1259    16421    failed_jobs    TABLE     &  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
);
    DROP TABLE public.failed_jobs;
       public         heap    postgres    false                        1259    16420    failed_jobs_id_seq    SEQUENCE     {   CREATE SEQUENCE public.failed_jobs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 )   DROP SEQUENCE public.failed_jobs_id_seq;
       public          postgres    false    221                       0    0    failed_jobs_id_seq    SEQUENCE OWNED BY     I   ALTER SEQUENCE public.failed_jobs_id_seq OWNED BY public.failed_jobs.id;
          public          postgres    false    220                        1259    16393 
   migrations    TABLE        CREATE TABLE public.migrations (
    id integer NOT NULL,
    migration character varying(255) NOT NULL,
    batch integer NOT NULL
);
    DROP TABLE public.migrations;
       public         heap    postgres    false                        1259    16392    migrations_id_seq    SEQUENCE        CREATE SEQUENCE public.migrations_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 (   DROP SEQUENCE public.migrations_id_seq;
       public          postgres    false    216                       0    0    migrations_id_seq    SEQUENCE OWNED BY     G   ALTER SEQUENCE public.migrations_id_seq OWNED BY public.migrations.id;
          public          postgres    false    215                        1259    16470    model_has_permissions    TABLE        CREATE TABLE public.model_has_permissions (
    permission_id bigint NOT NULL,
    model_type character varying(255) NOT NULL,
    model_id bigint NOT NULL
);
 )   DROP TABLE public.model_has_permissions;
       public         heap    postgres    false                        1259    16481    model_has_roles    TABLE        CREATE TABLE public.model_has_roles (
    role_id bigint NOT NULL,
    model_type character varying(255) NOT NULL,
    model_id bigint NOT NULL
);
 #   DROP TABLE public.model_has_roles;
       public         heap    postgres    false                        1259    17144 
   open_roles    TABLE       CREATE TABLE public.open_roles (
    id bigint NOT NULL,
    title character varying(255) NOT NULL,
    body text NOT NULL,
    published_at timestamp(0) without time zone,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);
    DROP TABLE public.open_roles;
       public         heap    postgres    false                        1259    17143    open_roles_id_seq    SEQUENCE     z   CREATE SEQUENCE public.open_roles_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 (   DROP SEQUENCE public.open_roles_id_seq;
       public          postgres    false    244                       0    0    open_roles_id_seq    SEQUENCE OWNED BY     G   ALTER SEQUENCE public.open_roles_id_seq OWNED BY public.open_roles.id;
          public          postgres    false    243                        1259    25428    page_sliders    TABLE       CREATE TABLE public.page_sliders (
    id bigint NOT NULL,
    page_id bigint NOT NULL,
    "group" character varying(255) NOT NULL,
    type character varying(255) NOT NULL,
    input_type character varying(255) NOT NULL,
    image character varying(255),
    text text,
    note character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    CONSTRAINT page_sliders_input_type_check CHECK (((input_type)::text = ANY ((ARRAY['text'::character varying, 'image'::character varying, 'textarea'::character varying, 'texteditor'::character varying])::text[]))),
    CONSTRAINT page_sliders_type_check CHECK (((type)::text = ANY ((ARRAY['text'::character varying, 'image'::character varying, 'text_image'::character varying])::text[])))
);
     DROP TABLE public.page_sliders;
       public         heap    postgres    false                        1259    25427    page_sliders_id_seq    SEQUENCE     |   CREATE SEQUENCE public.page_sliders_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 *   DROP SEQUENCE public.page_sliders_id_seq;
       public          postgres    false    254                       0    0    page_sliders_id_seq    SEQUENCE OWNED BY     K   ALTER SEQUENCE public.page_sliders_id_seq OWNED BY public.page_sliders.id;
          public          postgres    false    253                        1259    25417    pages    TABLE        CREATE TABLE public.pages (
    id bigint NOT NULL,
    code character varying(255) NOT NULL,
    label character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);
    DROP TABLE public.pages;
       public         heap    postgres    false                        1259    25416    pages_id_seq    SEQUENCE     u   CREATE SEQUENCE public.pages_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 #   DROP SEQUENCE public.pages_id_seq;
       public          postgres    false    252                       0    0    pages_id_seq    SEQUENCE OWNED BY     =   ALTER SEQUENCE public.pages_id_seq OWNED BY public.pages.id;
          public          postgres    false    251                        1259    16521    password_histories    TABLE       CREATE TABLE public.password_histories (
    id bigint NOT NULL,
    model_type character varying(255) NOT NULL,
    model_id bigint NOT NULL,
    password character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);
 &   DROP TABLE public.password_histories;
       public         heap    postgres    false                        1259    16520    password_histories_id_seq    SEQUENCE        CREATE SEQUENCE public.password_histories_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 0   DROP SEQUENCE public.password_histories_id_seq;
       public          postgres    false    234                       0    0    password_histories_id_seq    SEQUENCE OWNED BY     W   ALTER SEQUENCE public.password_histories_id_seq OWNED BY public.password_histories.id;
          public          postgres    false    233                        1259    16414    password_resets    TABLE        CREATE TABLE public.password_resets (
    email character varying(255) NOT NULL,
    token character varying(255) NOT NULL,
    created_at timestamp(0) without time zone
);
 #   DROP TABLE public.password_resets;
       public         heap    postgres    false                        1259    16445    permissions    TABLE       CREATE TABLE public.permissions (
    id bigint NOT NULL,
    type character varying(255) NOT NULL,
    guard_name character varying(255) NOT NULL,
    name character varying(255) NOT NULL,
    description character varying(255),
    parent_id bigint,
    sort smallint DEFAULT '1'::smallint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    CONSTRAINT permissions_type_check CHECK (((type)::text = ANY ((ARRAY['admin'::character varying, 'user'::character varying])::text[])))
);
    DROP TABLE public.permissions;
       public         heap    postgres    false                        1259    16444    permissions_id_seq    SEQUENCE     {   CREATE SEQUENCE public.permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 )   DROP SEQUENCE public.permissions_id_seq;
       public          postgres    false    225                       0    0    permissions_id_seq    SEQUENCE OWNED BY     I   ALTER SEQUENCE public.permissions_id_seq OWNED BY public.permissions.id;
          public          postgres    false    224                        1259    16433    personal_access_tokens    TABLE       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,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);
 *   DROP TABLE public.personal_access_tokens;
       public         heap    postgres    false                        1259    16432    personal_access_tokens_id_seq    SEQUENCE        CREATE SEQUENCE public.personal_access_tokens_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 4   DROP SEQUENCE public.personal_access_tokens_id_seq;
       public          postgres    false    223                       0    0    personal_access_tokens_id_seq    SEQUENCE OWNED BY     _   ALTER SEQUENCE public.personal_access_tokens_id_seq OWNED BY public.personal_access_tokens.id;
          public          postgres    false    222                        1259    25336    reach_us    TABLE     ]  CREATE TABLE public.reach_us (
    id bigint NOT NULL,
    email character varying(255) NOT NULL,
    name character varying(255) NOT NULL,
    subject character varying(255) NOT NULL,
    message text NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    read boolean DEFAULT false NOT NULL
);
    DROP TABLE public.reach_us;
       public         heap    postgres    false                        1259    25335    reach_us_id_seq    SEQUENCE     x   CREATE SEQUENCE public.reach_us_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 &   DROP SEQUENCE public.reach_us_id_seq;
       public          postgres    false    246                       0    0    reach_us_id_seq    SEQUENCE OWNED BY     C   ALTER SEQUENCE public.reach_us_id_seq OWNED BY public.reach_us.id;
          public          postgres    false    245                        1259    16492    role_has_permissions    TABLE     m   CREATE TABLE public.role_has_permissions (
    permission_id bigint NOT NULL,
    role_id bigint NOT NULL
);
 (   DROP TABLE public.role_has_permissions;
       public         heap    postgres    false                        1259    16461    roles    TABLE       CREATE TABLE public.roles (
    id bigint NOT NULL,
    type character varying(255) NOT NULL,
    name character varying(255) NOT NULL,
    guard_name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    CONSTRAINT roles_type_check CHECK (((type)::text = ANY ((ARRAY['admin'::character varying, 'user'::character varying])::text[])))
);
    DROP TABLE public.roles;
       public         heap    postgres    false                        1259    16460    roles_id_seq    SEQUENCE     u   CREATE SEQUENCE public.roles_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 #   DROP SEQUENCE public.roles_id_seq;
       public          postgres    false    227                       0    0    roles_id_seq    SEQUENCE OWNED BY     =   ALTER SEQUENCE public.roles_id_seq OWNED BY public.roles.id;
          public          postgres    false    226                        1259    16542    two_factor_authentications    TABLE       CREATE TABLE public.two_factor_authentications (
    id bigint NOT NULL,
    authenticatable_type character varying(255) NOT NULL,
    authenticatable_id bigint NOT NULL,
    shared_secret text NOT NULL,
    enabled_at timestamp(0) with time zone,
    label character varying(255) NOT NULL,
    digits smallint DEFAULT '6'::smallint NOT NULL,
    seconds smallint DEFAULT '30'::smallint NOT NULL,
    "window" smallint DEFAULT '0'::smallint NOT NULL,
    algorithm character varying(16) DEFAULT 'sha1'::character varying NOT NULL,
    recovery_codes text,
    recovery_codes_generated_at timestamp(0) with time zone,
    safe_devices json,
    created_at timestamp(0) with time zone,
    updated_at timestamp(0) with time zone
);
 .   DROP TABLE public.two_factor_authentications;
       public         heap    postgres    false                        1259    16541 !   two_factor_authentications_id_seq    SEQUENCE        CREATE SEQUENCE public.two_factor_authentications_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 8   DROP SEQUENCE public.two_factor_authentications_id_seq;
       public          postgres    false    238                       0    0 !   two_factor_authentications_id_seq    SEQUENCE OWNED BY     g   ALTER SEQUENCE public.two_factor_authentications_id_seq OWNED BY public.two_factor_authentications.id;
          public          postgres    false    237                        1259    16400    users    TABLE       CREATE TABLE public.users (
    id bigint NOT NULL,
    type character varying(255) DEFAULT 'user'::character varying NOT NULL,
    name character varying(255) NOT NULL,
    email character varying(255),
    email_verified_at timestamp(0) without time zone,
    password character varying(255),
    password_changed_at timestamp(0) without time zone,
    active smallint DEFAULT '1'::smallint NOT NULL,
    timezone character varying(255),
    last_login_at timestamp(0) without time zone,
    last_login_ip character varying(255),
    to_be_logged_out boolean DEFAULT false NOT NULL,
    provider character varying(255),
    provider_id character varying(255),
    remember_token character varying(100),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone,
    CONSTRAINT users_type_check CHECK (((type)::text = ANY ((ARRAY['admin'::character varying, 'user'::character varying])::text[])))
);
    DROP TABLE public.users;
       public         heap    postgres    false                        1259    16399    users_id_seq    SEQUENCE     u   CREATE SEQUENCE public.users_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 #   DROP SEQUENCE public.users_id_seq;
       public          postgres    false    218                       0    0    users_id_seq    SEQUENCE OWNED BY     =   ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;
          public          postgres    false    217                       2604    16533    activity_log id    DEFAULT     r   ALTER TABLE ONLY public.activity_log ALTER COLUMN id SET DEFAULT nextval('public.activity_log_id_seq'::regclass);
 >   ALTER TABLE public.activity_log ALTER COLUMN id DROP DEFAULT;
       public          postgres    false    236    235    236                       2604    16511    announcements id    DEFAULT     t   ALTER TABLE ONLY public.announcements ALTER COLUMN id SET DEFAULT nextval('public.announcements_id_seq'::regclass);
 ?   ALTER TABLE public.announcements ALTER COLUMN id DROP DEFAULT;
       public          postgres    false    231    232    232                       2604    25361    apply_forms id    DEFAULT     p   ALTER TABLE ONLY public.apply_forms ALTER COLUMN id SET DEFAULT nextval('public.apply_forms_id_seq'::regclass);
 =   ALTER TABLE public.apply_forms ALTER COLUMN id DROP DEFAULT;
       public          postgres    false    249    250    250                       2604    25349    book_sessions id    DEFAULT     t   ALTER TABLE ONLY public.book_sessions ALTER COLUMN id SET DEFAULT nextval('public.book_sessions_id_seq'::regclass);
 ?   ALTER TABLE public.book_sessions ALTER COLUMN id DROP DEFAULT;
       public          postgres    false    248    247    248                       2604    16633    categories id    DEFAULT     n   ALTER TABLE ONLY public.categories ALTER COLUMN id SET DEFAULT nextval('public.categories_id_seq'::regclass);
 <   ALTER TABLE public.categories ALTER COLUMN id DROP DEFAULT;
       public          postgres    false    241    242    242                       2604    25447    cms_perpages id    DEFAULT     r   ALTER TABLE ONLY public.cms_perpages ALTER COLUMN id SET DEFAULT nextval('public.cms_perpages_id_seq'::regclass);
 >   ALTER TABLE public.cms_perpages ALTER COLUMN id DROP DEFAULT;
       public          postgres    false    256    255    256                       2604    16622    explores id    DEFAULT     j   ALTER TABLE ONLY public.explores ALTER COLUMN id SET DEFAULT nextval('public.explores_id_seq'::regclass);
 :   ALTER TABLE public.explores ALTER COLUMN id DROP DEFAULT;
       public          postgres    false    240    239    240                       2604    16424    failed_jobs id    DEFAULT     p   ALTER TABLE ONLY public.failed_jobs ALTER COLUMN id SET DEFAULT nextval('public.failed_jobs_id_seq'::regclass);
 =   ALTER TABLE public.failed_jobs ALTER COLUMN id DROP DEFAULT;
       public          postgres    false    220    221    221                       2604    16396    migrations id    DEFAULT     n   ALTER TABLE ONLY public.migrations ALTER COLUMN id SET DEFAULT nextval('public.migrations_id_seq'::regclass);
 <   ALTER TABLE public.migrations ALTER COLUMN id DROP DEFAULT;
       public          postgres    false    215    216    216                       2604    17147    open_roles id    DEFAULT     n   ALTER TABLE ONLY public.open_roles ALTER COLUMN id SET DEFAULT nextval('public.open_roles_id_seq'::regclass);
 <   ALTER TABLE public.open_roles ALTER COLUMN id DROP DEFAULT;
       public          postgres    false    243    244    244                       2604    25431    page_sliders id    DEFAULT     r   ALTER TABLE ONLY public.page_sliders ALTER COLUMN id SET DEFAULT nextval('public.page_sliders_id_seq'::regclass);
 >   ALTER TABLE public.page_sliders ALTER COLUMN id DROP DEFAULT;
       public          postgres    false    254    253    254                       2604    25420    pages id    DEFAULT     d   ALTER TABLE ONLY public.pages ALTER COLUMN id SET DEFAULT nextval('public.pages_id_seq'::regclass);
 7   ALTER TABLE public.pages ALTER COLUMN id DROP DEFAULT;
       public          postgres    false    252    251    252                       2604    16524    password_histories id    DEFAULT     ~   ALTER TABLE ONLY public.password_histories ALTER COLUMN id SET DEFAULT nextval('public.password_histories_id_seq'::regclass);
 D   ALTER TABLE public.password_histories ALTER COLUMN id DROP DEFAULT;
       public          postgres    false    234    233    234                       2604    16448    permissions id    DEFAULT     p   ALTER TABLE ONLY public.permissions ALTER COLUMN id SET DEFAULT nextval('public.permissions_id_seq'::regclass);
 =   ALTER TABLE public.permissions ALTER COLUMN id DROP DEFAULT;
       public          postgres    false    224    225    225                       2604    16436    personal_access_tokens id    DEFAULT        ALTER TABLE ONLY public.personal_access_tokens ALTER COLUMN id SET DEFAULT nextval('public.personal_access_tokens_id_seq'::regclass);
 H   ALTER TABLE public.personal_access_tokens ALTER COLUMN id DROP DEFAULT;
       public          postgres    false    222    223    223                       2604    25339    reach_us id    DEFAULT     j   ALTER TABLE ONLY public.reach_us ALTER COLUMN id SET DEFAULT nextval('public.reach_us_id_seq'::regclass);
 :   ALTER TABLE public.reach_us ALTER COLUMN id DROP DEFAULT;
       public          postgres    false    245    246    246                       2604    16464    roles id    DEFAULT     d   ALTER TABLE ONLY public.roles ALTER COLUMN id SET DEFAULT nextval('public.roles_id_seq'::regclass);
 7   ALTER TABLE public.roles ALTER COLUMN id DROP DEFAULT;
       public          postgres    false    226    227    227                       2604    16545    two_factor_authentications id    DEFAULT        ALTER TABLE ONLY public.two_factor_authentications ALTER COLUMN id SET DEFAULT nextval('public.two_factor_authentications_id_seq'::regclass);
 L   ALTER TABLE public.two_factor_authentications ALTER COLUMN id DROP DEFAULT;
       public          postgres    false    237    238    238                       2604    16403    users id    DEFAULT     d   ALTER TABLE ONLY public.users ALTER COLUMN id SET DEFAULT nextval('public.users_id_seq'::regclass);
 7   ALTER TABLE public.users ALTER COLUMN id DROP DEFAULT;
       public          postgres    false    217    218    218                      0    16530    activity_log 
   TABLE DATA              COPY public.activity_log (id, log_name, description, subject_id, subject_type, causer_id, causer_type, properties, created_at, updated_at, event, batch_uuid) FROM stdin;
    public          postgres    false    236                    0    16508    announcements 
   TABLE DATA           u   COPY public.announcements (id, area, type, message, enabled, starts_at, ends_at, created_at, updated_at) FROM stdin;
    public          postgres    false    232                    0    25358    apply_forms 
   TABLE DATA              COPY public.apply_forms (id, email, name, last_name, phone, base_in_jakarta, address, about_yourself, find_idein, cv, created_at, updated_at, read) FROM stdin;
    public          postgres    false    250   =                 0    25346    book_sessions 
   TABLE DATA              COPY public.book_sessions (id, name, email, company, goals, can_help, budget, hear_about_us, referral, read, created_at, updated_at) FROM stdin;
    public          postgres    false    248   Z                 0    16630 
   categories 
   TABLE DATA           L   COPY public.categories (id, name, slug, created_at, updated_at) FROM stdin;
    public          postgres    false    242   w                 0    25444    cms_perpages 
   TABLE DATA           v   COPY public.cms_perpages (id, page_id, key, type, input_type, value, note, created_at, updated_at, label) FROM stdin;
    public          postgres    false    256                    0    16619    explores 
   TABLE DATA           ~   COPY public.explores (id, category_id, title, slug, image, body, published_at, created_at, updated_at, read_time) FROM stdin;
    public          postgres    false    240                    0    16421    failed_jobs 
   TABLE DATA           a   COPY public.failed_jobs (id, uuid, connection, queue, payload, exception, failed_at) FROM stdin;
    public          postgres    false    221   8                 0    16393 
   migrations 
   TABLE DATA           :   COPY public.migrations (id, migration, batch) FROM stdin;
    public          postgres    false    216   U                 0    16470    model_has_permissions 
   TABLE DATA           T   COPY public.model_has_permissions (permission_id, model_type, model_id) FROM stdin;
    public          postgres    false    228   8                 0    16481    model_has_roles 
   TABLE DATA           H   COPY public.model_has_roles (role_id, model_type, model_id) FROM stdin;
    public          postgres    false    229   U                 0    17144 
   open_roles 
   TABLE DATA           [   COPY public.open_roles (id, title, body, published_at, created_at, updated_at) FROM stdin;
    public          postgres    false    244                    0    25428    page_sliders 
   TABLE DATA           y   COPY public.page_sliders (id, page_id, "group", type, input_type, image, text, note, created_at, updated_at) FROM stdin;
    public          postgres    false    254   "                 0    25417    pages 
   TABLE DATA           H   COPY public.pages (id, code, label, created_at, updated_at) FROM stdin;
    public          postgres    false    252   6                 0    16521    password_histories 
   TABLE DATA           h   COPY public.password_histories (id, model_type, model_id, password, created_at, updated_at) FROM stdin;
    public          postgres    false    234                    0    16414    password_resets 
   TABLE DATA           C   COPY public.password_resets (email, token, created_at) FROM stdin;
    public          postgres    false    219   
                 0    16445    permissions 
   TABLE DATA           w   COPY public.permissions (id, type, guard_name, name, description, parent_id, sort, created_at, updated_at) FROM stdin;
    public          postgres    false    225   '                 0    16433    personal_access_tokens 
   TABLE DATA              COPY public.personal_access_tokens (id, tokenable_type, tokenable_id, name, token, abilities, last_used_at, created_at, updated_at) FROM stdin;
    public          postgres    false    223   &                 0    25336    reach_us 
   TABLE DATA           c   COPY public.reach_us (id, email, name, subject, message, created_at, updated_at, read) FROM stdin;
    public          postgres    false    246   C                 0    16492    role_has_permissions 
   TABLE DATA           F   COPY public.role_has_permissions (permission_id, role_id) FROM stdin;
    public          postgres    false    230   `                 0    16461    roles 
   TABLE DATA           S   COPY public.roles (id, type, name, guard_name, created_at, updated_at) FROM stdin;
    public          postgres    false    227                    0    16542    two_factor_authentications 
   TABLE DATA              COPY public.two_factor_authentications (id, authenticatable_type, authenticatable_id, shared_secret, enabled_at, label, digits, seconds, "window", algorithm, recovery_codes, recovery_codes_generated_at, safe_devices, created_at, updated_at) FROM stdin;
    public          postgres    false    238                    0    16400    users 
   TABLE DATA              COPY public.users (id, type, name, email, email_verified_at, password, password_changed_at, active, timezone, last_login_at, last_login_ip, to_be_logged_out, provider, provider_id, remember_token, created_at, updated_at, deleted_at) FROM stdin;
    public          postgres    false    218   M                  0    0    activity_log_id_seq    SEQUENCE SET     A   SELECT pg_catalog.setval('public.activity_log_id_seq', 7, true);
          public          postgres    false    235                        0    0    announcements_id_seq    SEQUENCE SET     B   SELECT pg_catalog.setval('public.announcements_id_seq', 1, true);
          public          postgres    false    231                       0    0    apply_forms_id_seq    SEQUENCE SET     @   SELECT pg_catalog.setval('public.apply_forms_id_seq', 3, true);
          public          postgres    false    249                       0    0    book_sessions_id_seq    SEQUENCE SET     B   SELECT pg_catalog.setval('public.book_sessions_id_seq', 5, true);
          public          postgres    false    247                       0    0    categories_id_seq    SEQUENCE SET     @   SELECT pg_catalog.setval('public.categories_id_seq', 10, true);
          public          postgres    false    241                       0    0    cms_perpages_id_seq    SEQUENCE SET     B   SELECT pg_catalog.setval('public.cms_perpages_id_seq', 1, false);
          public          postgres    false    255                       0    0    explores_id_seq    SEQUENCE SET     >   SELECT pg_catalog.setval('public.explores_id_seq', 84, true);
          public          postgres    false    239                       0    0    failed_jobs_id_seq    SEQUENCE SET     A   SELECT pg_catalog.setval('public.failed_jobs_id_seq', 1, false);
          public          postgres    false    220                       0    0    migrations_id_seq    SEQUENCE SET     @   SELECT pg_catalog.setval('public.migrations_id_seq', 28, true);
          public          postgres    false    215                       0    0    open_roles_id_seq    SEQUENCE SET     ?   SELECT pg_catalog.setval('public.open_roles_id_seq', 6, true);
          public          postgres    false    243            	           0    0    page_sliders_id_seq    SEQUENCE SET     B   SELECT pg_catalog.setval('public.page_sliders_id_seq', 72, true);
          public          postgres    false    253            
           0    0    pages_id_seq    SEQUENCE SET     :   SELECT pg_catalog.setval('public.pages_id_seq', 5, true);
          public          postgres    false    251                       0    0    password_histories_id_seq    SEQUENCE SET     G   SELECT pg_catalog.setval('public.password_histories_id_seq', 4, true);
          public          postgres    false    233                       0    0    permissions_id_seq    SEQUENCE SET     @   SELECT pg_catalog.setval('public.permissions_id_seq', 7, true);
          public          postgres    false    224                       0    0    personal_access_tokens_id_seq    SEQUENCE SET     L   SELECT pg_catalog.setval('public.personal_access_tokens_id_seq', 1, false);
          public          postgres    false    222                       0    0    reach_us_id_seq    SEQUENCE SET     =   SELECT pg_catalog.setval('public.reach_us_id_seq', 3, true);
          public          postgres    false    245                       0    0    roles_id_seq    SEQUENCE SET     :   SELECT pg_catalog.setval('public.roles_id_seq', 3, true);
          public          postgres    false    226                       0    0 !   two_factor_authentications_id_seq    SEQUENCE SET     O   SELECT pg_catalog.setval('public.two_factor_authentications_id_seq', 1, true);
          public          postgres    false    237                       0    0    users_id_seq    SEQUENCE SET     :   SELECT pg_catalog.setval('public.users_id_seq', 4, true);
          public          postgres    false    217                       2606    16537    activity_log activity_log_pkey 
   CONSTRAINT     \   ALTER TABLE ONLY public.activity_log
    ADD CONSTRAINT activity_log_pkey PRIMARY KEY (id);
 H   ALTER TABLE ONLY public.activity_log DROP CONSTRAINT activity_log_pkey;
       public            postgres    false    236                       2606    16519     announcements announcements_pkey 
   CONSTRAINT     ^   ALTER TABLE ONLY public.announcements
    ADD CONSTRAINT announcements_pkey PRIMARY KEY (id);
 J   ALTER TABLE ONLY public.announcements DROP CONSTRAINT announcements_pkey;
       public            postgres    false    232                       2606    25365    apply_forms apply_forms_pkey 
   CONSTRAINT     Z   ALTER TABLE ONLY public.apply_forms
    ADD CONSTRAINT apply_forms_pkey PRIMARY KEY (id);
 F   ALTER TABLE ONLY public.apply_forms DROP CONSTRAINT apply_forms_pkey;
       public            postgres    false    250                       2606    25354     book_sessions book_sessions_pkey 
   CONSTRAINT     ^   ALTER TABLE ONLY public.book_sessions
    ADD CONSTRAINT book_sessions_pkey PRIMARY KEY (id);
 J   ALTER TABLE ONLY public.book_sessions DROP CONSTRAINT book_sessions_pkey;
       public            postgres    false    248                       2606    16639 !   categories categories_name_unique 
   CONSTRAINT     \   ALTER TABLE ONLY public.categories
    ADD CONSTRAINT categories_name_unique UNIQUE (name);
 K   ALTER TABLE ONLY public.categories DROP CONSTRAINT categories_name_unique;
       public            postgres    false    242                       2606    16637    categories categories_pkey 
   CONSTRAINT     X   ALTER TABLE ONLY public.categories
    ADD CONSTRAINT categories_pkey PRIMARY KEY (id);
 D   ALTER TABLE ONLY public.categories DROP CONSTRAINT categories_pkey;
       public            postgres    false    242                       2606    16641 !   categories categories_slug_unique 
   CONSTRAINT     \   ALTER TABLE ONLY public.categories
    ADD CONSTRAINT categories_slug_unique UNIQUE (slug);
 K   ALTER TABLE ONLY public.categories DROP CONSTRAINT categories_slug_unique;
       public            postgres    false    242            %           2606    25453    cms_perpages cms_perpages_pkey 
   CONSTRAINT     \   ALTER TABLE ONLY public.cms_perpages
    ADD CONSTRAINT cms_perpages_pkey PRIMARY KEY (id);
 H   ALTER TABLE ONLY public.cms_perpages DROP CONSTRAINT cms_perpages_pkey;
       public            postgres    false    256                       2606    16626    explores explores_pkey 
   CONSTRAINT     T   ALTER TABLE ONLY public.explores
    ADD CONSTRAINT explores_pkey PRIMARY KEY (id);
 @   ALTER TABLE ONLY public.explores DROP CONSTRAINT explores_pkey;
       public            postgres    false    240                       2606    16628    explores explores_slug_unique 
   CONSTRAINT     X   ALTER TABLE ONLY public.explores
    ADD CONSTRAINT explores_slug_unique UNIQUE (slug);
 G   ALTER TABLE ONLY public.explores DROP CONSTRAINT explores_slug_unique;
       public            postgres    false    240                       2606    16429    failed_jobs failed_jobs_pkey 
   CONSTRAINT     Z   ALTER TABLE ONLY public.failed_jobs
    ADD CONSTRAINT failed_jobs_pkey PRIMARY KEY (id);
 F   ALTER TABLE ONLY public.failed_jobs DROP CONSTRAINT failed_jobs_pkey;
       public            postgres    false    221                       2606    16431 #   failed_jobs failed_jobs_uuid_unique 
   CONSTRAINT     ^   ALTER TABLE ONLY public.failed_jobs
    ADD CONSTRAINT failed_jobs_uuid_unique UNIQUE (uuid);
 M   ALTER TABLE ONLY public.failed_jobs DROP CONSTRAINT failed_jobs_uuid_unique;
       public            postgres    false    221                       2606    16398    migrations migrations_pkey 
   CONSTRAINT     X   ALTER TABLE ONLY public.migrations
    ADD CONSTRAINT migrations_pkey PRIMARY KEY (id);
 D   ALTER TABLE ONLY public.migrations DROP CONSTRAINT migrations_pkey;
       public            postgres    false    216                       2606    16480 0   model_has_permissions model_has_permissions_pkey 
   CONSTRAINT        ALTER TABLE ONLY public.model_has_permissions
    ADD CONSTRAINT model_has_permissions_pkey PRIMARY KEY (permission_id, model_id, model_type);
 Z   ALTER TABLE ONLY public.model_has_permissions DROP CONSTRAINT model_has_permissions_pkey;
       public            postgres    false    228    228    228                       2606    16491 $   model_has_roles model_has_roles_pkey 
   CONSTRAINT     }   ALTER TABLE ONLY public.model_has_roles
    ADD CONSTRAINT model_has_roles_pkey PRIMARY KEY (role_id, model_id, model_type);
 N   ALTER TABLE ONLY public.model_has_roles DROP CONSTRAINT model_has_roles_pkey;
       public            postgres    false    229    229    229                       2606    17151    open_roles open_roles_pkey 
   CONSTRAINT     X   ALTER TABLE ONLY public.open_roles
    ADD CONSTRAINT open_roles_pkey PRIMARY KEY (id);
 D   ALTER TABLE ONLY public.open_roles DROP CONSTRAINT open_roles_pkey;
       public            postgres    false    244            #           2606    25437    page_sliders page_sliders_pkey 
   CONSTRAINT     \   ALTER TABLE ONLY public.page_sliders
    ADD CONSTRAINT page_sliders_pkey PRIMARY KEY (id);
 H   ALTER TABLE ONLY public.page_sliders DROP CONSTRAINT page_sliders_pkey;
       public            postgres    false    254                       2606    25426    pages pages_code_unique 
   CONSTRAINT     R   ALTER TABLE ONLY public.pages
    ADD CONSTRAINT pages_code_unique UNIQUE (code);
 A   ALTER TABLE ONLY public.pages DROP CONSTRAINT pages_code_unique;
       public            postgres    false    252            !           2606    25424    pages pages_pkey 
   CONSTRAINT     N   ALTER TABLE ONLY public.pages
    ADD CONSTRAINT pages_pkey PRIMARY KEY (id);
 :   ALTER TABLE ONLY public.pages DROP CONSTRAINT pages_pkey;
       public            postgres    false    252                       2606    16528 *   password_histories password_histories_pkey 
   CONSTRAINT     h   ALTER TABLE ONLY public.password_histories
    ADD CONSTRAINT password_histories_pkey PRIMARY KEY (id);
 T   ALTER TABLE ONLY public.password_histories DROP CONSTRAINT password_histories_pkey;
       public            postgres    false    234                       2606    16454    permissions permissions_pkey 
   CONSTRAINT     Z   ALTER TABLE ONLY public.permissions
    ADD CONSTRAINT permissions_pkey PRIMARY KEY (id);
 F   ALTER TABLE ONLY public.permissions DROP CONSTRAINT permissions_pkey;
       public            postgres    false    225                       2606    16440 2   personal_access_tokens personal_access_tokens_pkey 
   CONSTRAINT     p   ALTER TABLE ONLY public.personal_access_tokens
    ADD CONSTRAINT personal_access_tokens_pkey PRIMARY KEY (id);
 \   ALTER TABLE ONLY public.personal_access_tokens DROP CONSTRAINT personal_access_tokens_pkey;
       public            postgres    false    223                       2606    16443 :   personal_access_tokens personal_access_tokens_token_unique 
   CONSTRAINT     v   ALTER TABLE ONLY public.personal_access_tokens
    ADD CONSTRAINT personal_access_tokens_token_unique UNIQUE (token);
 d   ALTER TABLE ONLY public.personal_access_tokens DROP CONSTRAINT personal_access_tokens_token_unique;
       public            postgres    false    223                       2606    25343    reach_us reach_us_pkey 
   CONSTRAINT     T   ALTER TABLE ONLY public.reach_us
    ADD CONSTRAINT reach_us_pkey PRIMARY KEY (id);
 @   ALTER TABLE ONLY public.reach_us DROP CONSTRAINT reach_us_pkey;
       public            postgres    false    246                       2606    16506 .   role_has_permissions role_has_permissions_pkey 
   CONSTRAINT        ALTER TABLE ONLY public.role_has_permissions
    ADD CONSTRAINT role_has_permissions_pkey PRIMARY KEY (permission_id, role_id);
 X   ALTER TABLE ONLY public.role_has_permissions DROP CONSTRAINT role_has_permissions_pkey;
       public            postgres    false    230    230                       2606    16469    roles roles_pkey 
   CONSTRAINT     N   ALTER TABLE ONLY public.roles
    ADD CONSTRAINT roles_pkey PRIMARY KEY (id);
 :   ALTER TABLE ONLY public.roles DROP CONSTRAINT roles_pkey;
       public            postgres    false    227                       2606    16553 :   two_factor_authentications two_factor_authentications_pkey 
   CONSTRAINT     x   ALTER TABLE ONLY public.two_factor_authentications
    ADD CONSTRAINT two_factor_authentications_pkey PRIMARY KEY (id);
 d   ALTER TABLE ONLY public.two_factor_authentications DROP CONSTRAINT two_factor_authentications_pkey;
       public            postgres    false    238                       2606    16413    users users_email_unique 
   CONSTRAINT     T   ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_email_unique UNIQUE (email);
 B   ALTER TABLE ONLY public.users DROP CONSTRAINT users_email_unique;
       public            postgres    false    218                       2606    16411    users users_pkey 
   CONSTRAINT     N   ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_pkey PRIMARY KEY (id);
 :   ALTER TABLE ONLY public.users DROP CONSTRAINT users_pkey;
       public            postgres    false    218            	           1259    16554    2fa_auth_type_auth_id_index    INDEX        CREATE INDEX "2fa_auth_type_auth_id_index" ON public.two_factor_authentications USING btree (authenticatable_type, authenticatable_id);
 1   DROP INDEX public."2fa_auth_type_auth_id_index";
       public            postgres    false    238    238                       1259    16538    activity_log_log_name_index    INDEX     X   CREATE INDEX activity_log_log_name_index ON public.activity_log USING btree (log_name);
 /   DROP INDEX public.activity_log_log_name_index;
       public            postgres    false    236                       1259    16540    causer    INDEX     Q   CREATE INDEX causer ON public.activity_log USING btree (causer_id, causer_type);
    DROP INDEX public.causer;
       public            postgres    false    236    236                       1259    16473 /   model_has_permissions_model_id_model_type_index    INDEX        CREATE INDEX model_has_permissions_model_id_model_type_index ON public.model_has_permissions USING btree (model_id, model_type);
 C   DROP INDEX public.model_has_permissions_model_id_model_type_index;
       public            postgres    false    228    228                       1259    16484 )   model_has_roles_model_id_model_type_index    INDEX     u   CREATE INDEX model_has_roles_model_id_model_type_index ON public.model_has_roles USING btree (model_id, model_type);
 =   DROP INDEX public.model_has_roles_model_id_model_type_index;
       public            postgres    false    229    229                       1259    16419    password_resets_email_index    INDEX     X   CREATE INDEX password_resets_email_index ON public.password_resets USING btree (email);
 /   DROP INDEX public.password_resets_email_index;
       public            postgres    false    219                       1259    16441 8   personal_access_tokens_tokenable_type_tokenable_id_index    INDEX        CREATE INDEX personal_access_tokens_tokenable_type_tokenable_id_index ON public.personal_access_tokens USING btree (tokenable_type, tokenable_id);
 L   DROP INDEX public.personal_access_tokens_tokenable_type_tokenable_id_index;
       public            postgres    false    223    223                       1259    16539    subject    INDEX     T   CREATE INDEX subject ON public.activity_log USING btree (subject_id, subject_type);
    DROP INDEX public.subject;
       public            postgres    false    236    236            ,           2606    25454 )   cms_perpages cms_perpages_page_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.cms_perpages
    ADD CONSTRAINT cms_perpages_page_id_foreign FOREIGN KEY (page_id) REFERENCES public.pages(id);
 S   ALTER TABLE ONLY public.cms_perpages DROP CONSTRAINT cms_perpages_page_id_foreign;
       public          postgres    false    4897    256    252            '           2606    16474 A   model_has_permissions model_has_permissions_permission_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.model_has_permissions
    ADD CONSTRAINT model_has_permissions_permission_id_foreign FOREIGN KEY (permission_id) REFERENCES public.permissions(id) ON DELETE CASCADE;
 k   ALTER TABLE ONLY public.model_has_permissions DROP CONSTRAINT model_has_permissions_permission_id_foreign;
       public          postgres    false    228    225    4853            (           2606    16485 /   model_has_roles model_has_roles_role_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.model_has_roles
    ADD CONSTRAINT model_has_roles_role_id_foreign FOREIGN KEY (role_id) REFERENCES public.roles(id) ON DELETE CASCADE;
 Y   ALTER TABLE ONLY public.model_has_roles DROP CONSTRAINT model_has_roles_role_id_foreign;
       public          postgres    false    4855    227    229            +           2606    25438 )   page_sliders page_sliders_page_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.page_sliders
    ADD CONSTRAINT page_sliders_page_id_foreign FOREIGN KEY (page_id) REFERENCES public.pages(id);
 S   ALTER TABLE ONLY public.page_sliders DROP CONSTRAINT page_sliders_page_id_foreign;
       public          postgres    false    252    254    4897            &           2606    16455 )   permissions permissions_parent_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.permissions
    ADD CONSTRAINT permissions_parent_id_foreign FOREIGN KEY (parent_id) REFERENCES public.permissions(id) ON DELETE CASCADE;
 S   ALTER TABLE ONLY public.permissions DROP CONSTRAINT permissions_parent_id_foreign;
       public          postgres    false    225    225    4853            )           2606    16495 ?   role_has_permissions role_has_permissions_permission_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.role_has_permissions
    ADD CONSTRAINT role_has_permissions_permission_id_foreign FOREIGN KEY (permission_id) REFERENCES public.permissions(id) ON DELETE CASCADE;
 i   ALTER TABLE ONLY public.role_has_permissions DROP CONSTRAINT role_has_permissions_permission_id_foreign;
       public          postgres    false    225    4853    230            *           2606    16500 9   role_has_permissions role_has_permissions_role_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.role_has_permissions
    ADD CONSTRAINT role_has_permissions_role_id_foreign FOREIGN KEY (role_id) REFERENCES public.roles(id) ON DELETE CASCADE;
 c   ALTER TABLE ONLY public.role_has_permissions DROP CONSTRAINT role_has_permissions_role_id_foreign;
       public          postgres    false    227    4855    230                 xŔOo0)HjJ=d/zpeibf3)NȖ(!!}޶{ߑ9OY¤7#.dT3R-O64Hs3MBr2Ԇy-)/)d JPt 8AGL .D]<8~] =).߄TF{ĪK,	+{r1[4p2v&PԦ(T?:jnҶ.[-qȇ|joG:H׊%3VN]o+'p~ϫmZtZVh/i]2Z9jڟ,T`X+PzR/-RqTH#S6x+ê]'=ui4            xm
0SFxEt[FڎV #gxMj9
dLܝ,݂V?C `[hh0P2#<OyaA\ uďc|)F5#CX*K~#v)mӴ{?WJ(            x              x           u   x3t*JKKL1uu̭ͭMqq&eY6)Ji)1k\XYZ^̙xĚb_ZT̙ K)           xVn8]S_ ؒHɲU[ Wa$)`0+(v~.pԙXM"yϹ>hL)zǙkQ=mjQrvioL{SO4t0	BJ(~4c]`8dq=E^REfͲLid7vSUe8f[	&tm
&`0X?.7U_ךUOb\ ?rmax)~FH<r؟'~! .p8
cxnsԆUnZWȸ)8lW~"<!>r.h5bc+b<d:ZK|-%τ|xXn0}|ʲ\;ϬWpQSԒ38&]EszF[W֘C(@XZlug-2j	.!0:
%NH܁K~m;d(lt!uE6Ƴ9ǺCp~wFuCъ߲],:>'Gl3Q;$<+ ~do6	"3;UWcв_8.V{b'Ch&.f%2?2qv|8trDZ	r|}ّh|>{m;D<ÞB(fiڬҞVH})j+E
ZҢwb$FiU=GQ!hoP΁[j{ٳӢ)N+-?+9|?E.7Wx/zO_*ꊯ(i/^Z
_4.Gs>ӿ         
  x]ko<?4`*e'^m"5nH	XP39b{f7Nr8ЃsqHa1*~L"iSDĴ$^U`&mڴqP,\e1Q,]eСFؘҨdbqиa҉+EF'Yhc$:GBOtA7&4^BmY@<ZY5MSiK|٥:EP
02:[+6zcRk\GеEkH/46iNH*4y2ڕzp;7AϵdϬrGPNYkl%tc67^"1@A,;DuC7J"#lt/ۘ|Sdu^pq8/e5bﶕ|3_geKA]׭g:Lң3s;]R7	(ƻ;0Ŗ#jLJ1kMxK?s?:_2Zn^H4Wm +,8	m~#11TʦQg+dsU\&:AfT֪e%jAo[t?&	b
?LGA4uլ[BU1径Im 7o92W'49w9CJ/,ҡZ͘cLW"''#9ʓ8~0g'xTSaV:LUIIJ7mR:Ax6IEpƀIdcW%AxLFIʨ+,LY8o.b`9edܸTP_8IcPnA9 ǀǴk'Y4qAQ+DP	,1QybřHZdOkPA$yNkUjf/7-1{aH0{aL윽S56ִ>TociCehIjI%F/e$!Ѩ)
S={0$0&vNQΊⅮBС\H-4Ȋ($f88o*a`9_'UiPZl;P^J4v4{2(t|$O'x70?aH0?aL윟<(NtUn)M^7B$8/:yhZ+U(&P{CA:37Ȯjo0Gagss998ʓ6JB` MTBp[D.RmeD:{-UI־2TK's}N2EE;"mnXZ7MP:y͠ WFҚ	юʹ
pZ-|'M4GG#}3I2AIoM4:o-sͮe:/{+*G͘0e\)C)cӔeM|<<1j7<.?xp8+#ZBb/J7ov7W%]!Aa:yfgPEjp7(T${\GL#ɔiC$p2/kec3
ΉyqVtffPLg QDX5"sz?8oba`58?.>UCx5BTL
ondPl=
g}+Ϫ$?QtN_oNU0W$\!\1:[9☗H[k&!jN_W7siM߿brKaO㑼@ß isëbp1%(][,@~C9U&]
\q	fH0+aL|6+9o1kwccY1,^kKn.	zn;)=-H
=CLWLWMWߒvLUīgCWP{;T;r*tyمf)ֽd.2yC!/*_̟$6vzzy?]`4*\]9ĵ賓^:@^437*c,&yy.6$68-D֙w-՝#;*Hz +;S4~Ie{fpCBPcɱNܭl17 qYjw]<NmKqIڏ"/P<ZbY,-槁Bh	dۿ!G"Jkʻղ񳠚y)/\E,R)Һ	mIƟ̽HzK\$?sc	p|b]mĀrƵt+^&YHO~:RV@OGo42]:83g@zM5ݏyPP
)~UGU'y5n+ԫ&(QG"2Jzv#WB-
Gtܥrʓ'pR<9CEQKA2!`B'\UXꍤ>g!;vbx6>=q#mݍQqV<SWijLE"qM:d͠ȧuE"Vrӿ_`<s]_~c6aNowF:w5888/R>            x             xn @4/d*ݥU1}wMf'A!p|y`\:LA8	O-N6ؘyi=(u7ɸi{ua@'4w;dS)8rB#
T3{Ý\/ !7硱vYD]_\~r6[*(@.L݇׉ȩd(S
f7:kLr4']Jm~jV}1<-}]a+n~î7(3{ݗpq@;C~Np@gnӚZaŠ8nZR'Mٞ͠<3lvP2;jl.m
tk]e)+(_ԯ|y-UyH%Kfb)(,s-	L'Tйv!ڌ4kJ
)Ơ<b {yf             x           ;   x3t,(qM+q,-ɈOIBS8+22&Ȅ+F @'N         r  xmo0_OqU*.CHV0&ͅ&v,iŷ$S"%9Oڷ2aNR@bAC,RB/׃uPta4|3fT|DE0$$f5;!8\j'& -TJ)e`_6g]D(9.zƔরE
8|2Wdg;+aX|YYI-CS!C)z]ft)$2iV=; ?׉5{)6uiK1ѱ<Wt>a{
d>EV<+&\[;ۏC=ib~ؼpH#p9:;Zuz!,tI\!XYи*-aSf@tT(XD僦x9)/4Jx%wξuR^H6M=vj=h}ݨ9]DO|:SvM+**vZQ}SyAnPy\K+UQWW{^BF&nx*/U[[{fQ{֩]UUO+Q<5 a           xYM6=ӿ§X,2Ʒ&T%nr)-@)f}Z21삩rZͳ}󣪊Zoj-ZU-F^>ĶT*dZV-48Dq8'Y6XnfJGj-r:iZtZf,Ʒ/dw㤻qm)80!c#.I؁	Q	i
I<]zL}Lg z1τs ^FuU~ssGel>H.ayawBc҆cG|D"6jUdG[:>3bs8O,/u*KJќBp6N=,U"Ԉ7fN)g-Rur`PɨZK#ݍqGl "=1ax{"a!}N=O<zR }o#$C7]ϣ'7J%KCwaVq<LRa@ěS=~ԣRv􏱠wq)FiLJTc@Lz=IIsAHH4&A1ͩuژuژ扻P7+P7M`;=[3i<zDGoGY<8jytW敛?bz|Hڢ-)^^X^ܭ,McWj1H}|r\ZӜye>ge~$ Dz4bCJ|{"Hw蝓==hՋ6+QU^;{=^nY/ꨰN^vRgAcŻoEbm[#*JRU6`cUWܴowĜ΀v>=],ZYF3& /,Ek4F~!,alf+VZժ[b8 2Q~:l)ZgiԴ\\``&<¶\t.~Z+U{1^z[ZT?+1.!eV/,zJ]
Ť}	,a7]bmQ=ܝA:=Ri:dON0HsFHs=z`,i|F嶰MEpXO0u[akLgV=nMU´f]yN1خz]b1`!KNS"; }I         {   x3M FF&
VFVFĸ89Az9R3K9@bp&'q:Ciburd䗦gs5,N-)K/1 "OE         9  x;s@~E
[tFCqA.௏)l2ΘӜhU2IA@kcw|z|_P׃Cە}VNЕjR1vzsh:qA!Ȫ zX^u鼭_(t~"ʘ|NƴL)'wDxJ[IV1KK$[&]i:Z-!T_5V|/b<KKnWaEv8aH9;M.r\{ɯ, v?            x              x0)xmE蠃htrpF($Mn]4W*~S(E:{4"R&q0p<n㇙
B5ם,eR,V}-Aj1?"-Ւd(M@M0;&Vʟ݌~gK})¤lu7qMμKRl`L} |G            x              x              x44          l   x3LLt%E%EIFFƺF
VVFĸ&&edt)YXZb2®]+F s9+z         <  x]PMo0=ï}jTJGA%4q )h*nIl*۾29Y},j%KJ5}ɽ6R1rbmli#hO]);֫;v88tBh5'MzS\7A-LFgQ0>Bv`2F22{tt)=RRZ_ F@DDԀHD"	Ne1v> ifdH1Ro^PVoÇ=A4X=Ԡl0x           xKo0Wdvͪ)PH	AHUHM0iH}(ҙWWGwdfY.<֪K`B-,	P3$P0hⲉ`FmNgme;Pʝ{/_a;x2|Ӿ?Q"Su姼tɛsc0.6,̣>:7?pwY6gsYrzvozplܽz=]d͈(?I1rTI7$ :=IńgUS݀Bz#s\C-]; $]lU_coI
\~{ir :q5"BޣlS*~JxiNn3[h[S%BFR-     