Edit file File name : pgbackup.sql Content :PGDMP | shopify 16.2 16.2 2 E 0 0 ENCODING ENCODING SET client_encoding = 'UTF8'; false F 0 0 STDSTRINGS STDSTRINGS ( SET standard_conforming_strings = 'on'; false G 0 0 SEARCHPATH SEARCHPATH 8 SELECT pg_catalog.set_config('search_path', '', false); false H 1262 16388 shopify DATABASE i CREATE DATABASE shopify WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PROVIDER = libc LOCALE = 'C'; DROP DATABASE shopify; postgres false � 1259 16390 failed_jobs TABLE CREATE TABLE public.failed_jobs ( id integer NOT NULL, uuid character varying(191) NOT NULL, connection text NOT NULL, queue text NOT NULL, payload text NOT NULL, exception text NOT NULL, failed_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP ); DROP TABLE public.failed_jobs; public heap postgres false � 1259 16389 failed_jobs_id_seq SEQUENCE � CREATE SEQUENCE public.failed_jobs_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ) DROP SEQUENCE public.failed_jobs_id_seq; public postgres false 216 I 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 215 � 1259 16400 migrations TABLE � CREATE TABLE public.migrations ( id integer NOT NULL, migration character varying(191) NOT NULL, batch integer NOT NULL ); DROP TABLE public.migrations; public heap postgres false � 1259 16399 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 218 J 0 0 migrations_id_seq SEQUENCE OWNED BY G ALTER SEQUENCE public.migrations_id_seq OWNED BY public.migrations.id; public postgres false 217 � 1259 16406 password_reset_tokens TABLE � CREATE TABLE public.password_reset_tokens ( email character varying(191) NOT NULL, token character varying(191) NOT NULL, created_at timestamp without time zone ); ) DROP TABLE public.password_reset_tokens; public heap postgres false � 1259 16412 personal_access_tokens TABLE � CREATE TABLE public.personal_access_tokens ( id integer NOT NULL, tokenable_type character varying(191) NOT NULL, tokenable_id integer NOT NULL, name character varying(191) NOT NULL, token character varying(64) NOT NULL, abilities text, last_used_at timestamp without time zone, expires_at timestamp without time zone, created_at timestamp without time zone, updated_at timestamp without time zone ); * DROP TABLE public.personal_access_tokens; public heap postgres false � 1259 16411 personal_access_tokens_id_seq SEQUENCE � CREATE SEQUENCE public.personal_access_tokens_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; 4 DROP SEQUENCE public.personal_access_tokens_id_seq; public postgres false 221 K 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 220 � 1259 16421 shopify_user TABLE CREATE TABLE public.shopify_user ( id integer NOT NULL, merchant_id text NOT NULL, terminal_id text NOT NULL, secret_key text NOT NULL, hmac text NOT NULL, shop text NOT NULL, embedded text NOT NULL, modetoggle text NOT NULL ); DROP TABLE public.shopify_user; public heap postgres false � 1259 16420 shopify_user_id_seq SEQUENCE � CREATE SEQUENCE public.shopify_user_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; * DROP SEQUENCE public.shopify_user_id_seq; public postgres false 223 L 0 0 shopify_user_id_seq SEQUENCE OWNED BY K ALTER SEQUENCE public.shopify_user_id_seq OWNED BY public.shopify_user.id; public postgres false 222 � 1259 16430 shops TABLE � CREATE TABLE public.shops ( id integer NOT NULL, shop_name character varying(191) NOT NULL, api_token character varying(191) NOT NULL, created_at timestamp without time zone, updated_at timestamp without time zone, merchant_id character varying(191), merchant_name character varying(191), terminal_id character varying(191), secure_hash character varying(191) ); DROP TABLE public.shops; public heap postgres false � 1259 16429 shops_id_seq SEQUENCE � CREATE SEQUENCE public.shops_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; # DROP SEQUENCE public.shops_id_seq; public postgres false 225 M 0 0 shops_id_seq SEQUENCE OWNED BY = ALTER SEQUENCE public.shops_id_seq OWNED BY public.shops.id; public postgres false 224 � 1259 16439 users TABLE p CREATE TABLE public.users ( id integer NOT NULL, name character varying(191) NOT NULL, email character varying(191) NOT NULL, email_verified_at timestamp without time zone, password character varying(191) NOT NULL, remember_token character varying(100), created_at timestamp without time zone, updated_at timestamp without time zone ); DROP TABLE public.users; public heap postgres false � 1259 16438 users_id_seq SEQUENCE � CREATE SEQUENCE public.users_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; # DROP SEQUENCE public.users_id_seq; public postgres false 227 N 0 0 users_id_seq SEQUENCE OWNED BY = ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id; public postgres false 226 � 2604 16393 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 216 215 216 � 2604 16403 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 218 217 218 � 2604 16415 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 221 220 221 � 2604 16424 shopify_user id DEFAULT r ALTER TABLE ONLY public.shopify_user ALTER COLUMN id SET DEFAULT nextval('public.shopify_user_id_seq'::regclass); > ALTER TABLE public.shopify_user ALTER COLUMN id DROP DEFAULT; public postgres false 223 222 223 � 2604 16433 shops id DEFAULT d ALTER TABLE ONLY public.shops ALTER COLUMN id SET DEFAULT nextval('public.shops_id_seq'::regclass); 7 ALTER TABLE public.shops ALTER COLUMN id DROP DEFAULT; public postgres false 224 225 225 � 2604 16442 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 226 227 227 7 0 16390 failed_jobs TABLE DATA a COPY public.failed_jobs (id, uuid, connection, queue, payload, exception, failed_at) FROM stdin; public postgres false 216 �: 9 0 16400 migrations TABLE DATA : COPY public.migrations (id, migration, batch) FROM stdin; public postgres false 218 �: : 0 16406 password_reset_tokens TABLE DATA I COPY public.password_reset_tokens (email, token, created_at) FROM stdin; public postgres false 219 �; < 0 16412 personal_access_tokens TABLE DATA � COPY public.personal_access_tokens (id, tokenable_type, tokenable_id, name, token, abilities, last_used_at, expires_at, created_at, updated_at) FROM stdin; public postgres false 221 �; > 0 16421 shopify_user TABLE DATA r COPY public.shopify_user (id, merchant_id, terminal_id, secret_key, hmac, shop, embedded, modetoggle) FROM stdin; public postgres false 223 �; @ 0 16430 shops TABLE DATA � COPY public.shops (id, shop_name, api_token, created_at, updated_at, merchant_id, merchant_name, terminal_id, secure_hash) FROM stdin; public postgres false 225 �< B 0 16439 users TABLE DATA u COPY public.users (id, name, email, email_verified_at, password, remember_token, created_at, updated_at) FROM stdin; public postgres false 227 d= O 0 0 failed_jobs_id_seq SEQUENCE SET A SELECT pg_catalog.setval('public.failed_jobs_id_seq', 1, false); public postgres false 215 P 0 0 migrations_id_seq SEQUENCE SET @ SELECT pg_catalog.setval('public.migrations_id_seq', 1, false); public postgres false 217 Q 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 220 R 0 0 shopify_user_id_seq SEQUENCE SET B SELECT pg_catalog.setval('public.shopify_user_id_seq', 1, false); public postgres false 222 S 0 0 shops_id_seq SEQUENCE SET ; SELECT pg_catalog.setval('public.shops_id_seq', 1, false); public postgres false 224 T 0 0 users_id_seq SEQUENCE SET ; SELECT pg_catalog.setval('public.users_id_seq', 1, false); public postgres false 226 � 2606 16398 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 216 � 2606 16405 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 218 � 2606 16410 0 password_reset_tokens password_reset_tokens_pkey CONSTRAINT q ALTER TABLE ONLY public.password_reset_tokens ADD CONSTRAINT password_reset_tokens_pkey PRIMARY KEY (email); Z ALTER TABLE ONLY public.password_reset_tokens DROP CONSTRAINT password_reset_tokens_pkey; public postgres false 219 � 2606 16419 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 221 � 2606 16428 shopify_user shopify_user_pkey CONSTRAINT \ ALTER TABLE ONLY public.shopify_user ADD CONSTRAINT shopify_user_pkey PRIMARY KEY (id); H ALTER TABLE ONLY public.shopify_user DROP CONSTRAINT shopify_user_pkey; public postgres false 223 � 2606 16437 shops shops_pkey CONSTRAINT N ALTER TABLE ONLY public.shops ADD CONSTRAINT shops_pkey PRIMARY KEY (id); : ALTER TABLE ONLY public.shops DROP CONSTRAINT shops_pkey; public postgres false 225 � 2606 16448 users users_email_key CONSTRAINT Q ALTER TABLE ONLY public.users ADD CONSTRAINT users_email_key UNIQUE (email); ? ALTER TABLE ONLY public.users DROP CONSTRAINT users_email_key; public postgres false 227 � 2606 16446 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 227 7 x������ � � 9 � x�]���0 �g��N��/&M�J@��u��nA�C���m�� *��Q}m`��O� ���R�a�H��������c�Tg�{[�vx����x.��8,=� ?Ҁd-��L�:��I] ���t~��^ԫ�NF�#�9|p� ���/]��P��N�`J : x������ � � < x������ � � > � x���1n�0 Eg��@ �"%k,r�,%9F�����}g�P� ?9���>v����J�ij�e�1����'j� �Z\��%��p��G�$(���1�~�������u���^(������Ϲ=]���S-� � �{�s��|���U��m3���n�����G�͕�йĂ�cO�� +���Rt e吤�QUCϘr�hw��`��>�[} @ � x�]�1�0 ��� �q ;fK�d� �*���@b�e�v��`H\�L���\��\}�7s�G���&h�i�YH0z�[�89o�:���`�4���0��Yщ_����5��9s���1�{*1��"r.!�P~"���ќ$�*ũ {k�4�,� B x������ � � Save