--
-- PostgreSQL database dump
--
\restrict 2YwVHiG8dwjWHDA32gcP7kcynH2whqVE53iuCSt4HywB7vWmrtLbC6cSUzdUQ69
-- Dumped from database version 18.4 (Ubuntu 18.4-1.pgdg25.10+1)
-- Dumped by pg_dump version 18.4 (Ubuntu 18.4-1.pgdg25.10+1)
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
DROP INDEX IF EXISTS public.sessions_user_id_index;
DROP INDEX IF EXISTS public.sessions_last_activity_index;
DROP INDEX IF EXISTS public.jobs_queue_index;
DROP INDEX IF EXISTS public.failed_jobs_connection_queue_failed_at_index;
DROP INDEX IF EXISTS public.cache_locks_expiration_index;
DROP INDEX IF EXISTS public.cache_expiration_index;
ALTER TABLE IF EXISTS ONLY public.users DROP CONSTRAINT IF EXISTS users_pkey;
ALTER TABLE IF EXISTS ONLY public.users DROP CONSTRAINT IF EXISTS users_email_unique;
ALTER TABLE IF EXISTS ONLY public.topics DROP CONSTRAINT IF EXISTS topics_value_unique;
ALTER TABLE IF EXISTS ONLY public.topics DROP CONSTRAINT IF EXISTS topics_pkey;
ALTER TABLE IF EXISTS ONLY public.slides DROP CONSTRAINT IF EXISTS slides_pkey;
ALTER TABLE IF EXISTS ONLY public.settings DROP CONSTRAINT IF EXISTS settings_pkey;
ALTER TABLE IF EXISTS ONLY public.settings DROP CONSTRAINT IF EXISTS settings_key_name_unique;
ALTER TABLE IF EXISTS ONLY public.sessions DROP CONSTRAINT IF EXISTS sessions_pkey;
ALTER TABLE IF EXISTS ONLY public.registrations DROP CONSTRAINT IF EXISTS registrations_pkey;
ALTER TABLE IF EXISTS ONLY public.products DROP CONSTRAINT IF EXISTS products_pkey;
ALTER TABLE IF EXISTS ONLY public.password_reset_tokens DROP CONSTRAINT IF EXISTS password_reset_tokens_pkey;
ALTER TABLE IF EXISTS ONLY public.orders DROP CONSTRAINT IF EXISTS orders_pkey;
ALTER TABLE IF EXISTS ONLY public.orders DROP CONSTRAINT IF EXISTS orders_order_number_unique;
ALTER TABLE IF EXISTS ONLY public.news DROP CONSTRAINT IF EXISTS news_pkey;
ALTER TABLE IF EXISTS ONLY public.migrations DROP CONSTRAINT IF EXISTS migrations_pkey;
ALTER TABLE IF EXISTS ONLY public.jobs DROP CONSTRAINT IF EXISTS jobs_pkey;
ALTER TABLE IF EXISTS ONLY public.job_batches DROP CONSTRAINT IF EXISTS job_batches_pkey;
ALTER TABLE IF EXISTS ONLY public.failed_jobs DROP CONSTRAINT IF EXISTS failed_jobs_uuid_unique;
ALTER TABLE IF EXISTS ONLY public.failed_jobs DROP CONSTRAINT IF EXISTS failed_jobs_pkey;
ALTER TABLE IF EXISTS ONLY public.event_sessions DROP CONSTRAINT IF EXISTS event_sessions_pkey;
ALTER TABLE IF EXISTS ONLY public.customers DROP CONSTRAINT IF EXISTS customers_pkey;
ALTER TABLE IF EXISTS ONLY public.customers DROP CONSTRAINT IF EXISTS customers_email_unique;
ALTER TABLE IF EXISTS ONLY public.customer_sessions DROP CONSTRAINT IF EXISTS customer_sessions_token_unique;
ALTER TABLE IF EXISTS ONLY public.customer_sessions DROP CONSTRAINT IF EXISTS customer_sessions_pkey;
ALTER TABLE IF EXISTS ONLY public.cache DROP CONSTRAINT IF EXISTS cache_pkey;
ALTER TABLE IF EXISTS ONLY public.cache_locks DROP CONSTRAINT IF EXISTS cache_locks_pkey;
ALTER TABLE IF EXISTS public.users ALTER COLUMN id DROP DEFAULT;
ALTER TABLE IF EXISTS public.topics ALTER COLUMN id DROP DEFAULT;
ALTER TABLE IF EXISTS public.slides ALTER COLUMN id DROP DEFAULT;
ALTER TABLE IF EXISTS public.settings ALTER COLUMN id DROP DEFAULT;
ALTER TABLE IF EXISTS public.registrations ALTER COLUMN id DROP DEFAULT;
ALTER TABLE IF EXISTS public.products ALTER COLUMN id DROP DEFAULT;
ALTER TABLE IF EXISTS public.orders ALTER COLUMN id DROP DEFAULT;
ALTER TABLE IF EXISTS public.news ALTER COLUMN id DROP DEFAULT;
ALTER TABLE IF EXISTS public.migrations ALTER COLUMN id DROP DEFAULT;
ALTER TABLE IF EXISTS public.jobs ALTER COLUMN id DROP DEFAULT;
ALTER TABLE IF EXISTS public.failed_jobs ALTER COLUMN id DROP DEFAULT;
ALTER TABLE IF EXISTS public.event_sessions ALTER COLUMN id DROP DEFAULT;
ALTER TABLE IF EXISTS public.customers ALTER COLUMN id DROP DEFAULT;
ALTER TABLE IF EXISTS public.customer_sessions ALTER COLUMN id DROP DEFAULT;
DROP SEQUENCE IF EXISTS public.users_id_seq;
DROP TABLE IF EXISTS public.users;
DROP SEQUENCE IF EXISTS public.topics_id_seq;
DROP TABLE IF EXISTS public.topics;
DROP SEQUENCE IF EXISTS public.slides_id_seq;
DROP TABLE IF EXISTS public.slides;
DROP SEQUENCE IF EXISTS public.settings_id_seq;
DROP TABLE IF EXISTS public.settings;
DROP TABLE IF EXISTS public.sessions;
DROP SEQUENCE IF EXISTS public.registrations_id_seq;
DROP TABLE IF EXISTS public.registrations;
DROP SEQUENCE IF EXISTS public.products_id_seq;
DROP TABLE IF EXISTS public.products;
DROP TABLE IF EXISTS public.password_reset_tokens;
DROP SEQUENCE IF EXISTS public.orders_id_seq;
DROP TABLE IF EXISTS public.orders;
DROP SEQUENCE IF EXISTS public.news_id_seq;
DROP TABLE IF EXISTS public.news;
DROP SEQUENCE IF EXISTS public.migrations_id_seq;
DROP TABLE IF EXISTS public.migrations;
DROP SEQUENCE IF EXISTS public.jobs_id_seq;
DROP TABLE IF EXISTS public.jobs;
DROP TABLE IF EXISTS public.job_batches;
DROP SEQUENCE IF EXISTS public.failed_jobs_id_seq;
DROP TABLE IF EXISTS public.failed_jobs;
DROP SEQUENCE IF EXISTS public.event_sessions_id_seq;
DROP TABLE IF EXISTS public.event_sessions;
DROP SEQUENCE IF EXISTS public.customers_id_seq;
DROP TABLE IF EXISTS public.customers;
DROP SEQUENCE IF EXISTS public.customer_sessions_id_seq;
DROP TABLE IF EXISTS public.customer_sessions;
DROP TABLE IF EXISTS public.cache_locks;
DROP TABLE IF EXISTS public.cache;
SET default_tablespace = '';
SET default_table_access_method = heap;
--
-- Name: cache; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.cache (
key character varying(255) NOT NULL,
value text NOT NULL,
expiration bigint NOT NULL
);
ALTER TABLE public.cache OWNER TO postgres;
--
-- Name: cache_locks; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.cache_locks (
key character varying(255) NOT NULL,
owner character varying(255) NOT NULL,
expiration bigint NOT NULL
);
ALTER TABLE public.cache_locks OWNER TO postgres;
--
-- Name: customer_sessions; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.customer_sessions (
id bigint NOT NULL,
customer_id bigint NOT NULL,
token character varying(255) NOT NULL,
expires_at timestamp(0) without time zone NOT NULL,
created_at timestamp(0) without time zone,
updated_at timestamp(0) without time zone
);
ALTER TABLE public.customer_sessions OWNER TO postgres;
--
-- Name: customer_sessions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.customer_sessions_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER SEQUENCE public.customer_sessions_id_seq OWNER TO postgres;
--
-- Name: customer_sessions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.customer_sessions_id_seq OWNED BY public.customer_sessions.id;
--
-- Name: customers; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.customers (
id bigint NOT NULL,
name character varying(255) NOT NULL,
email character varying(255) NOT NULL,
phone character varying(255),
password_hash character varying(255) NOT NULL,
is_active integer DEFAULT 1 NOT NULL,
last_login timestamp(0) without time zone,
created_at timestamp(0) without time zone,
updated_at timestamp(0) without time zone
);
ALTER TABLE public.customers OWNER TO postgres;
--
-- Name: customers_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.customers_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER SEQUENCE public.customers_id_seq OWNER TO postgres;
--
-- Name: customers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.customers_id_seq OWNED BY public.customers.id;
--
-- Name: event_sessions; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.event_sessions (
id bigint NOT NULL,
event_date character varying(255),
name character varying(255) NOT NULL,
description text,
bg_color character varying(255) DEFAULT 'bg-yellow'::character varying NOT NULL,
is_tall integer DEFAULT 0 NOT NULL,
sort_order integer DEFAULT 0 NOT NULL,
created_at timestamp(0) without time zone,
updated_at timestamp(0) without time zone
);
ALTER TABLE public.event_sessions OWNER TO postgres;
--
-- Name: event_sessions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.event_sessions_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER SEQUENCE public.event_sessions_id_seq OWNER TO postgres;
--
-- Name: event_sessions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.event_sessions_id_seq OWNED BY public.event_sessions.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 character varying(255) NOT NULL,
queue character varying(255) 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: job_batches; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.job_batches (
id character varying(255) NOT NULL,
name character varying(255) NOT NULL,
total_jobs integer NOT NULL,
pending_jobs integer NOT NULL,
failed_jobs integer NOT NULL,
failed_job_ids text NOT NULL,
options text,
cancelled_at integer,
created_at integer NOT NULL,
finished_at integer
);
ALTER TABLE public.job_batches OWNER TO postgres;
--
-- Name: jobs; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.jobs (
id bigint NOT NULL,
queue character varying(255) NOT NULL,
payload text NOT NULL,
attempts smallint NOT NULL,
reserved_at integer,
available_at integer NOT NULL,
created_at integer NOT NULL
);
ALTER TABLE public.jobs OWNER TO postgres;
--
-- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.jobs_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER SEQUENCE public.jobs_id_seq OWNER TO postgres;
--
-- Name: jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.jobs_id_seq OWNED BY public.jobs.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: news; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.news (
id bigint NOT NULL,
title character varying(255) NOT NULL,
description text,
news_date character varying(255),
image character varying(255),
created_at timestamp(0) without time zone,
updated_at timestamp(0) without time zone
);
ALTER TABLE public.news OWNER TO postgres;
--
-- Name: news_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.news_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER SEQUENCE public.news_id_seq OWNER TO postgres;
--
-- Name: news_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.news_id_seq OWNED BY public.news.id;
--
-- Name: orders; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.orders (
id bigint NOT NULL,
order_number character varying(255) NOT NULL,
customer_name character varying(255) NOT NULL,
customer_phone character varying(255) NOT NULL,
customer_email character varying(255),
items_json text,
total_price integer DEFAULT 0 NOT NULL,
payment_method character varying(255) DEFAULT 'transfer'::character varying NOT NULL,
status character varying(255) DEFAULT 'pending'::character varying NOT NULL,
notes text,
created_at timestamp(0) without time zone,
updated_at timestamp(0) without time zone
);
ALTER TABLE public.orders OWNER TO postgres;
--
-- Name: orders_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.orders_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER SEQUENCE public.orders_id_seq OWNER TO postgres;
--
-- Name: orders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.orders_id_seq OWNED BY public.orders.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: products; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.products (
id bigint NOT NULL,
name character varying(255) NOT NULL,
description text,
price character varying(255),
promo_price character varying(255),
image character varying(255) DEFAULT 'assets/images/laptop.png'::character varying NOT NULL,
category character varying(255) DEFAULT 'ebook'::character varying NOT NULL,
shopee_url text,
tokopedia_url text,
va_details text,
stock integer DEFAULT '-1'::integer NOT NULL,
is_active integer DEFAULT 1 NOT NULL,
sort_order integer DEFAULT 0 NOT NULL,
created_at timestamp(0) without time zone,
updated_at timestamp(0) without time zone
);
ALTER TABLE public.products OWNER TO postgres;
--
-- Name: products_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.products_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER SEQUENCE public.products_id_seq OWNER TO postgres;
--
-- Name: products_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.products_id_seq OWNED BY public.products.id;
--
-- Name: registrations; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.registrations (
id bigint NOT NULL,
name character varying(255) NOT NULL,
phone character varying(255),
email character varying(255),
topic character varying(255),
referral character varying(255),
created_at timestamp(0) without time zone,
updated_at timestamp(0) without time zone
);
ALTER TABLE public.registrations OWNER TO postgres;
--
-- Name: registrations_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.registrations_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER SEQUENCE public.registrations_id_seq OWNER TO postgres;
--
-- Name: registrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.registrations_id_seq OWNED BY public.registrations.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: settings; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.settings (
id bigint NOT NULL,
key_name character varying(255) NOT NULL,
value text,
created_at timestamp(0) without time zone,
updated_at timestamp(0) without time zone
);
ALTER TABLE public.settings OWNER TO postgres;
--
-- Name: settings_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.settings_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER SEQUENCE public.settings_id_seq OWNER TO postgres;
--
-- Name: settings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.settings_id_seq OWNED BY public.settings.id;
--
-- Name: slides; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.slides (
id bigint NOT NULL,
type character varying(255) DEFAULT 'original'::character varying NOT NULL,
tech_text text,
title text,
subtitle text,
tagline text,
outcomes text,
event_date character varying(255),
old_price character varying(255),
new_price character varying(255),
bonus character varying(255),
btn_text character varying(255) DEFAULT 'DAFTAR SEKARANG'::character varying NOT NULL,
image character varying(255),
speaker_name character varying(255),
speaker_title1 character varying(255),
speaker_title2 character varying(255),
speaker_image character varying(255),
is_active integer DEFAULT 1 NOT NULL,
sort_order integer DEFAULT 0 NOT NULL,
created_at timestamp(0) without time zone,
updated_at timestamp(0) without time zone
);
ALTER TABLE public.slides OWNER TO postgres;
--
-- Name: slides_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.slides_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER SEQUENCE public.slides_id_seq OWNER TO postgres;
--
-- Name: slides_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.slides_id_seq OWNED BY public.slides.id;
--
-- Name: topics; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.topics (
id bigint NOT NULL,
value character varying(255) NOT NULL,
label character varying(255) NOT NULL,
sort_order integer DEFAULT 0 NOT NULL,
created_at timestamp(0) without time zone,
updated_at timestamp(0) without time zone
);
ALTER TABLE public.topics OWNER TO postgres;
--
-- Name: topics_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.topics_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER SEQUENCE public.topics_id_seq OWNER TO postgres;
--
-- Name: topics_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.topics_id_seq OWNED BY public.topics.id;
--
-- Name: users; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.users (
id bigint NOT NULL,
name character varying(255) NOT NULL,
email character varying(255) NOT NULL,
email_verified_at timestamp(0) without time zone,
password character varying(255) NOT NULL,
remember_token character varying(100),
created_at timestamp(0) without time zone,
updated_at timestamp(0) without time zone
);
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: customer_sessions id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.customer_sessions ALTER COLUMN id SET DEFAULT nextval('public.customer_sessions_id_seq'::regclass);
--
-- Name: customers id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.customers ALTER COLUMN id SET DEFAULT nextval('public.customers_id_seq'::regclass);
--
-- Name: event_sessions id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.event_sessions ALTER COLUMN id SET DEFAULT nextval('public.event_sessions_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: jobs id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.jobs ALTER COLUMN id SET DEFAULT nextval('public.jobs_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: news id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.news ALTER COLUMN id SET DEFAULT nextval('public.news_id_seq'::regclass);
--
-- Name: orders id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.orders ALTER COLUMN id SET DEFAULT nextval('public.orders_id_seq'::regclass);
--
-- Name: products id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.products ALTER COLUMN id SET DEFAULT nextval('public.products_id_seq'::regclass);
--
-- Name: registrations id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.registrations ALTER COLUMN id SET DEFAULT nextval('public.registrations_id_seq'::regclass);
--
-- Name: settings id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.settings ALTER COLUMN id SET DEFAULT nextval('public.settings_id_seq'::regclass);
--
-- Name: slides id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.slides ALTER COLUMN id SET DEFAULT nextval('public.slides_id_seq'::regclass);
--
-- Name: topics id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.topics ALTER COLUMN id SET DEFAULT nextval('public.topics_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);
--
-- Data for Name: cache; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.cache (key, value, expiration) FROM stdin;
\.
--
-- Data for Name: cache_locks; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.cache_locks (key, owner, expiration) FROM stdin;
\.
--
-- Data for Name: customer_sessions; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.customer_sessions (id, customer_id, token, expires_at, created_at, updated_at) FROM stdin;
2 0 2690285b48d30e34927c98c11bdac56f53f7b0f8515d4f3bcd3ab42d9a0a1a46 2026-07-25 03:21:12 2026-06-25 03:21:12 2026-06-25 03:21:12
\.
--
-- Data for Name: customers; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.customers (id, name, email, phone, password_hash, is_active, last_login, created_at, updated_at) FROM stdin;
1 John Smith john@example.com 081234567890 $2y$12$apkK18jzNFx3/X22aJkYleWhb2hckDqqr0AODDdz8Nirqnz1DfXLy 1 \N 2026-06-25 03:20:09 2026-06-25 03:22:19
\.
--
-- Data for Name: event_sessions; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.event_sessions (id, event_date, name, description, bg_color, is_tall, sort_order, created_at, updated_at) FROM stdin;
1 06/06 TOEFL Mastery: Cetak Biru Menuju Skor Juara Teknik Cerdas untuk Mencapai Target Skor Band Anda bg-yellow 0 1 2026-06-25 03:17:08 2026-06-25 03:17:08
2 14/06 Kuasai Pengaruh Media Sosial Membangun Branding Digital yang Menarik Peluang bg-blue text-white 0 2 2026-06-25 03:17:08 2026-06-25 03:17:08
3 21/06 Keseimbangan Kesehatan Mental & Produktivitas Mengelola Tekanan di Era Digital Modern bg-pink text-white 1 3 2026-06-25 03:17:08 2026-06-25 03:17:08
4 27/06 Public Speaking untuk Pemimpin Masa Depan Berbicara dengan Percaya Diri, Pengaruh & Otoritas bg-red text-white 0 4 2026-06-25 03:17:08 2026-06-25 03:17:08
5 04/07 Revolusi Sumber Daya Manusia (HR) Cara Perusahaan Teratas Mengidentifikasi Talenta Berkualitas Tinggi bg-cyan 0 5 2026-06-25 03:17:08 2026-06-25 03:17:08
\.
--
-- 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: job_batches; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.job_batches (id, name, total_jobs, pending_jobs, failed_jobs, failed_job_ids, options, cancelled_at, created_at, finished_at) FROM stdin;
\.
--
-- Data for Name: jobs; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.jobs (id, queue, payload, attempts, reserved_at, available_at, created_at) FROM stdin;
\.
--
-- Data for Name: migrations; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.migrations (id, migration, batch) FROM stdin;
1 0001_01_01_000000_create_users_table 1
2 0001_01_01_000001_create_cache_table 1
3 0001_01_01_000002_create_jobs_table 1
4 2026_06_25_031537_create_orders_table 1
5 2026_06_25_031537_create_products_table 1
6 2026_06_25_031537_create_registrations_table 1
7 2026_06_25_031538_create_news_table 1
8 2026_06_25_031538_create_sessions_table 1
9 2026_06_25_031538_create_slides_table 1
10 2026_06_25_031538_create_topics_table 1
11 2026_06_25_031539_create_customer_sessions_table 1
12 2026_06_25_031539_create_customers_table 1
13 2026_06_25_031539_create_settings_table 1
\.
--
-- Data for Name: news; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.news (id, title, description, news_date, image, created_at, updated_at) FROM stdin;
1 Webinar Nasional TOEFL Mastery Sukses Besar Diikuti lebih dari 1000 peserta, webinar menghadirkan Liann Camille untuk membagikan formula sukses ujian. 20 Juni 2026 assets/images/conference.png 2026-06-25 03:17:08 2026-06-25 03:17:08
2 Kelas Speak Up Angkatan 15 Resmi Dibuka Program unggulan pelatihan presentasi dan kepercayaan diri berbicara bahasa Inggris untuk para profesional. 15 Juni 2026 assets/images/laptop.png 2026-06-25 03:17:08 2026-06-25 03:17:08
\.
--
-- Data for Name: orders; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.orders (id, order_number, customer_name, customer_phone, customer_email, items_json, total_price, payment_method, status, notes, created_at, updated_at) FROM stdin;
\.
--
-- 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: products; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.products (id, name, description, price, promo_price, image, category, shopee_url, tokopedia_url, va_details, stock, is_active, sort_order, created_at, updated_at) FROM stdin;
1 E-Book Ultimate TOEFL Mastery Guide Panduan lengkap belajar TOEFL mandiri berisi taktik, strategi menjawab soal, dan pola soal terpopuler. Rp 150.000 Rp 99.000 assets/images/laptop.png ebook https://shopee.co.id https://tokopedia.com Bank BCA 1234567890 a/n Bilinggo Global Academy -1 1 0 2026-06-25 03:17:08 2026-06-25 03:17:08
2 IELTS Premium Prep 1-on-1 Kelas intensif privat bersama mentor tersertifikasi IELTS Band 8.5. Dilengkapi simulasi dan feedback instan. Rp 1.999.000 Rp 1.499.000 assets/images/conference.png course https://shopee.co.id https://tokopedia.com Bank Mandiri 1310022233445 a/n Bilinggo Academy -1 1 0 2026-06-25 03:17:08 2026-06-25 03:17:08
3 Simulasi Ujian TOEFL ITP Resmi Simulasi ujian TOEFL dengan format, tingkat kesulitan, dan sistem waktu pengerjaan yang mirip dengan ujian asli. Rp 250.000 Rp 199.000 assets/images/laptop.png test https://shopee.co.id https://tokopedia.com Bank BCA 9876543210 a/n Bilinggo Global Academy -1 1 0 2026-06-25 03:17:08 2026-06-25 03:17:08
\.
--
-- Data for Name: registrations; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.registrations (id, name, phone, email, topic, referral, 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;
EAR7VLYj0VjSZQe7qJyABwoE6IkC6NAEZfQMhLW7 \N 127.0.0.1 curl/8.18.0 eyJfdG9rZW4iOiJYS0tpeVRIOW1NTWNTVHlYZzd4SzlBVHQwOFZqZXBZSVVndjY0V2tkIiwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ== 1782357609
tDRLsoTpyxCnmGBbWd0TwatvKg973HqkyJ6ngbZG \N ::1 Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36 eyJfdG9rZW4iOiIzQTQ4SmM1Z3hYdkJmYTNsVnZxY0JlTVZ4MjVYNnZiUk1kTjJmaU1UIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdFwvYmlsaW5nZ28iLCJyb3V0ZSI6bnVsbH0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0= 1782369823
rcA4aQs1DZG4BnYTOc0bUapxPt5UE9CDfmRO4hmN \N ::1 Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36 eyJfdG9rZW4iOiJrNHpidlBIZTRDR3BTNERsanhBMnJiakdaQms4dXVURHNkYXNmaUxJIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdFwvYmlsaW5nZ28iLCJyb3V0ZSI6bnVsbH0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0= 1785227766
voBalrayVbwO1xLhRcHWyt06iVNNj3p4M0zZ8LLI \N 127.0.0.1 Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36 eyJfdG9rZW4iOiJWRjhvczdEY3NoeElEaHZQR1drN2FoMHp0NEFIS3cxUWdLUUQzT0RGIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDgwXC9hcGlcL3Byb2R1Y3RzLnBocCIsInJvdXRlIjpudWxsfSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ== 1782357754
7T1oMxEejYkNDgJxAKCqmb6hCkKv68DUYVTPqiks \N ::1 Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36 eyJfdG9rZW4iOiJYWE55WHkycndJREpzUnJTMEpOOGs1d1NTSWVSQ3FiYnA2WTRWVjJmIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdFwvYmlsaW5nZ28iLCJyb3V0ZSI6bnVsbH0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0= 1782359002
eZGGFdZeh3B7SjPiywrX4KXozVHIhl7CTB6lYIsj \N ::1 Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36 eyJfdG9rZW4iOiJZd1hldG8zWUt2emhHQ2p5UXpUbXZxWm43dFJyejh2NEZkdTM2SWU0IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdFwvYmlsaW5nZ28iLCJyb3V0ZSI6bnVsbH0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0= 1782367211
IiCHbBtSOk5Tv6sgfX9bliz7AZmsIYocGR0H2CaG \N ::1 Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36 eyJfdG9rZW4iOiJUbGE3bnkzc0R1Y3VpMFFuWEw4WDRkU0hEWVVUMkpRb3M3eHpnT2JkIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdFwvYmlsaW5nZ28iLCJyb3V0ZSI6bnVsbH0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0= 1785230234
\.
--
-- Data for Name: settings; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.settings (id, key_name, value, created_at, updated_at) FROM stdin;
1 whatsapp_number 6282118940782 2026-06-25 03:17:08 2026-06-25 03:17:08
2 site_title BilînGo Global Academy 2026-06-25 03:17:08 2026-06-25 03:17:08
4 admin_password admin123 2026-06-25 03:17:08 2026-07-28 09:41:16
3 admin_username admin 2026-06-25 03:17:08 2026-07-28 09:41:16
\.
--
-- Data for Name: slides; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.slides (id, type, tech_text, title, subtitle, tagline, outcomes, event_date, old_price, new_price, bonus, btn_text, image, speaker_name, speaker_title1, speaker_title2, speaker_image, is_active, sort_order, created_at, updated_at) FROM stdin;
1 original KETERAMPILAN MASA DEPAN DIMULAI DI SINI! Memberdayakan
Talenta Masa Depan
Indonesia di Era Digital \N \N \N \N \N \N \N GABUNG SEKARANG assets/images/laptop.png \N \N \N \N 1 1 2026-06-25 03:17:08 2026-06-25 03:17:08
2 toefl \N TOEFL MASTERY Cetak Biru Menuju Skor Juara Taktik Terbukti dan Formula Sukses untuk Karier Global Anda Presisi Taktis: Identifikasi jawaban "jebakan" dalam hitungan detik.|Formula Eksekutif: Dapatkan templat P.R.E.P. yang terbukti.|Peta Jalan Global: Manfaatkan skor untuk rekrutmen internasional.|Simulasi Langsung: Latihan waktu nyata dengan masukan ahli. 06 JUNI 2026 Rp 150K RP 75.000 SERTIFIKAT GRATIS DAFTAR SEKARANG \N Liann Camille Davalos Perez Magister Bahasa Inggris Mahasiswa Doktoral Ilmu Pendidikan Bahasa assets/images/liann_perez.png 1 2 2026-06-25 03:17:08 2026-06-25 03:17:08
\.
--
-- Data for Name: topics; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.topics (id, value, label, sort_order, created_at, updated_at) FROM stdin;
1 Digital Leadership 1. Kepemimpinan Digital (Digital Leadership) 1 2026-06-25 03:17:08 2026-06-25 03:17:08
2 Workplace Mental Health & HR Strategy 2. Kesehatan Mental di Tempat Kerja & Strategi HR 2 2026-06-25 03:17:08 2026-06-25 03:17:08
3 Digital HR & Talent Analytics 3. HR Digital & Analitik Talenta (Digital HR & Talent Analytics) 3 2026-06-25 03:17:08 2026-06-25 03:17:08
4 English for Global Leadership 4. Bahasa Inggris untuk Kepemimpinan Global 4 2026-06-25 03:17:08 2026-06-25 03:17:08
5 Digital Wellbeing & Mental Health 5. Kesejahteraan Digital & Kesehatan Mental (Digital Wellbeing & Mental Health) 5 2026-06-25 03:17:08 2026-06-25 03:17:08
\.
--
-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.users (id, name, email, email_verified_at, password, remember_token, created_at, updated_at) FROM stdin;
\.
--
-- Name: customer_sessions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--
SELECT pg_catalog.setval('public.customer_sessions_id_seq', 2, true);
--
-- Name: customers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--
SELECT pg_catalog.setval('public.customers_id_seq', 1, true);
--
-- Name: event_sessions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--
SELECT pg_catalog.setval('public.event_sessions_id_seq', 5, true);
--
-- Name: failed_jobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--
SELECT pg_catalog.setval('public.failed_jobs_id_seq', 1, false);
--
-- Name: jobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--
SELECT pg_catalog.setval('public.jobs_id_seq', 1, false);
--
-- Name: migrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--
SELECT pg_catalog.setval('public.migrations_id_seq', 13, true);
--
-- Name: news_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--
SELECT pg_catalog.setval('public.news_id_seq', 2, true);
--
-- Name: orders_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--
SELECT pg_catalog.setval('public.orders_id_seq', 1, false);
--
-- Name: products_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--
SELECT pg_catalog.setval('public.products_id_seq', 3, true);
--
-- Name: registrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--
SELECT pg_catalog.setval('public.registrations_id_seq', 1, false);
--
-- Name: settings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--
SELECT pg_catalog.setval('public.settings_id_seq', 4, true);
--
-- Name: slides_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--
SELECT pg_catalog.setval('public.slides_id_seq', 2, true);
--
-- Name: topics_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--
SELECT pg_catalog.setval('public.topics_id_seq', 5, true);
--
-- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--
SELECT pg_catalog.setval('public.users_id_seq', 1, false);
--
-- Name: cache_locks cache_locks_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.cache_locks
ADD CONSTRAINT cache_locks_pkey PRIMARY KEY (key);
--
-- Name: cache cache_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.cache
ADD CONSTRAINT cache_pkey PRIMARY KEY (key);
--
-- Name: customer_sessions customer_sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.customer_sessions
ADD CONSTRAINT customer_sessions_pkey PRIMARY KEY (id);
--
-- Name: customer_sessions customer_sessions_token_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.customer_sessions
ADD CONSTRAINT customer_sessions_token_unique UNIQUE (token);
--
-- Name: customers customers_email_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.customers
ADD CONSTRAINT customers_email_unique UNIQUE (email);
--
-- Name: customers customers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.customers
ADD CONSTRAINT customers_pkey PRIMARY KEY (id);
--
-- Name: event_sessions event_sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.event_sessions
ADD CONSTRAINT event_sessions_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: job_batches job_batches_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.job_batches
ADD CONSTRAINT job_batches_pkey PRIMARY KEY (id);
--
-- Name: jobs jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.jobs
ADD CONSTRAINT jobs_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: news news_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.news
ADD CONSTRAINT news_pkey PRIMARY KEY (id);
--
-- Name: orders orders_order_number_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.orders
ADD CONSTRAINT orders_order_number_unique UNIQUE (order_number);
--
-- Name: orders orders_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.orders
ADD CONSTRAINT orders_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: products products_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.products
ADD CONSTRAINT products_pkey PRIMARY KEY (id);
--
-- Name: registrations registrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.registrations
ADD CONSTRAINT registrations_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: settings settings_key_name_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.settings
ADD CONSTRAINT settings_key_name_unique UNIQUE (key_name);
--
-- Name: settings settings_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.settings
ADD CONSTRAINT settings_pkey PRIMARY KEY (id);
--
-- Name: slides slides_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.slides
ADD CONSTRAINT slides_pkey PRIMARY KEY (id);
--
-- Name: topics topics_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.topics
ADD CONSTRAINT topics_pkey PRIMARY KEY (id);
--
-- Name: topics topics_value_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.topics
ADD CONSTRAINT topics_value_unique UNIQUE (value);
--
-- 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_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.users
ADD CONSTRAINT users_pkey PRIMARY KEY (id);
--
-- Name: cache_expiration_index; Type: INDEX; Schema: public; Owner: postgres
--
CREATE INDEX cache_expiration_index ON public.cache USING btree (expiration);
--
-- Name: cache_locks_expiration_index; Type: INDEX; Schema: public; Owner: postgres
--
CREATE INDEX cache_locks_expiration_index ON public.cache_locks USING btree (expiration);
--
-- Name: failed_jobs_connection_queue_failed_at_index; Type: INDEX; Schema: public; Owner: postgres
--
CREATE INDEX failed_jobs_connection_queue_failed_at_index ON public.failed_jobs USING btree (connection, queue, failed_at);
--
-- Name: jobs_queue_index; Type: INDEX; Schema: public; Owner: postgres
--
CREATE INDEX jobs_queue_index ON public.jobs USING btree (queue);
--
-- 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);
--
-- PostgreSQL database dump complete
--
\unrestrict 2YwVHiG8dwjWHDA32gcP7kcynH2whqVE53iuCSt4HywB7vWmrtLbC6cSUzdUQ69