-- Data for Name: woocommerce_pending_options; Type: TABLE DATA; Schema: public; Owner: TheRoasters_Auto
--

COPY public.woocommerce_pending_options (id, pending_attribute_id, woocommerce_value, suggested_name, suggested_name_en, mapped_option_id, status, created_at, updated_at) FROM stdin;
37	7	1KG	\N	1KG	4	mapped	2025-12-08 20:13:02	2025-12-08 20:13:02
38	7	100G	\N	100G	\N	pending	2025-12-08 20:13:02	2025-12-08 20:13:02
39	7	250G	\N	250G	2	mapped	2025-12-08 20:13:02	2025-12-08 20:13:02
40	7	500G	\N	500G	3	mapped	2025-12-08 20:13:02	2025-12-08 20:13:02
41	8	1KG	\N	1KG	4	mapped	2025-12-08 20:33:18	2025-12-08 20:33:18
43	8	250G	\N	250G	2	mapped	2025-12-08 20:33:18	2025-12-08 20:33:18
44	8	500G	\N	500G	3	mapped	2025-12-08 20:33:18	2025-12-08 20:33:18
42	8	100G	\N	100G	32	mapped	2025-12-08 20:33:18	2025-12-08 20:34:55
45	9	1KG	\N	1KG	4	mapped	2025-12-08 20:42:38	2025-12-08 20:42:38
46	9	100G	\N	100G	32	mapped	2025-12-08 20:42:38	2025-12-08 20:42:38
47	9	250G	\N	250G	2	mapped	2025-12-08 20:42:38	2025-12-08 20:42:38
48	9	500G	\N	500G	3	mapped	2025-12-08 20:42:38	2025-12-08 20:42:38
49	10	1KG	\N	1KG	4	mapped	2025-12-08 21:05:50	2025-12-08 21:05:50
50	10	100G	\N	100G	32	mapped	2025-12-08 21:05:50	2025-12-08 21:05:50
51	10	250G	\N	250G	2	mapped	2025-12-08 21:05:50	2025-12-08 21:05:50
52	10	500G	\N	500G	3	mapped	2025-12-08 21:05:50	2025-12-08 21:05:50
53	11	1KG	\N	1KG	4	mapped	2025-12-08 21:18:54	2025-12-08 21:18:54
54	11	100G	\N	100G	32	mapped	2025-12-08 21:18:54	2025-12-08 21:18:54
55	11	250G	\N	250G	2	mapped	2025-12-08 21:18:54	2025-12-08 21:18:54
56	11	500G	\N	500G	3	mapped	2025-12-08 21:18:54	2025-12-08 21:18:54
57	12	1KG	\N	1KG	4	mapped	2025-12-08 21:29:39	2025-12-08 21:29:39
58	12	100G	\N	100G	32	mapped	2025-12-08 21:29:39	2025-12-08 21:29:39
59	12	250G	\N	250G	2	mapped	2025-12-08 21:29:39	2025-12-08 21:29:39
60	12	500G	\N	500G	3	mapped	2025-12-08 21:29:39	2025-12-08 21:29:39
61	13	1KG	\N	1KG	4	mapped	2025-12-08 21:37:06	2025-12-08 21:37:06
62	13	100G	\N	100G	32	mapped	2025-12-08 21:37:06	2025-12-08 21:37:06
63	13	250G	\N	250G	2	mapped	2025-12-08 21:37:06	2025-12-08 21:37:06
64	13	500G	\N	500G	3	mapped	2025-12-08 21:37:06	2025-12-08 21:37:06
65	14	1KG	\N	1KG	4	mapped	2025-12-08 21:59:08	2025-12-08 21:59:08
66	14	100G	\N	100G	32	mapped	2025-12-08 21:59:08	2025-12-08 21:59:08
67	14	250G	\N	250G	2	mapped	2025-12-08 21:59:08	2025-12-08 21:59:08
68	14	500G	\N	500G	3	mapped	2025-12-08 21:59:08	2025-12-08 21:59:08
73	16	1KG	\N	1KG	4	mapped	2025-12-08 22:52:43	2025-12-08 22:52:43
74	16	100G	\N	100G	32	mapped	2025-12-08 22:52:43	2025-12-08 22:52:43
75	16	250G	\N	250G	2	mapped	2025-12-08 22:52:43	2025-12-08 22:52:43
76	16	500G	\N	500G	3	mapped	2025-12-08 22:52:43	2025-12-08 22:52:43
77	17	1KG	\N	1KG	4	mapped	2025-12-08 22:58:08	2025-12-08 22:58:08
78	17	100G	\N	100G	32	mapped	2025-12-08 22:58:08	2025-12-08 22:58:08
79	17	250G	\N	250G	2	mapped	2025-12-08 22:58:09	2025-12-08 22:58:09
80	17	500G	\N	500G	3	mapped	2025-12-08 22:58:09	2025-12-08 22:58:09
81	18	1KG	\N	1KG	4	mapped	2026-01-12 13:09:55	2026-01-12 13:09:55
82	18	100G	\N	100G	32	mapped	2026-01-12 13:09:55	2026-01-12 13:09:55
83	18	250G	\N	250G	2	mapped	2026-01-12 13:09:55	2026-01-12 13:09:55
84	18	500G	\N	500G	3	mapped	2026-01-12 13:09:55	2026-01-12 13:09:55
85	19	1KG	\N	1KG	4	mapped	2026-01-12 13:16:07	2026-01-12 13:16:07
86	19	100G	\N	100G	32	mapped	2026-01-12 13:16:07	2026-01-12 13:16:07
87	19	250G	\N	250G	2	mapped	2026-01-12 13:16:07	2026-01-12 13:16:07
88	19	500G	\N	500G	3	mapped	2026-01-12 13:16:07	2026-01-12 13:16:07
89	20	1KG	\N	1KG	4	mapped	2026-01-12 13:16:40	2026-01-12 13:16:40
90	20	100G	\N	100G	32	mapped	2026-01-12 13:16:40	2026-01-12 13:16:40
91	20	250G	\N	250G	2	mapped	2026-01-12 13:16:40	2026-01-12 13:16:40
92	20	500G	\N	500G	3	mapped	2026-01-12 13:16:40	2026-01-12 13:16:40
93	21	1KG	\N	1KG	4	mapped	2026-01-12 13:17:03	2026-01-12 13:17:03
94	21	100G	\N	100G	32	mapped	2026-01-12 13:17:03	2026-01-12 13:17:03
95	21	250G	\N	250G	2	mapped	2026-01-12 13:17:03	2026-01-12 13:17:03
96	21	500G	\N	500G	3	mapped	2026-01-12 13:17:03	2026-01-12 13:17:03
97	22	1KG	\N	1KG	4	mapped	2026-01-12 13:30:18	2026-01-12 13:30:18
98	22	100G	\N	100G	32	mapped	2026-01-12 13:30:18	2026-01-12 13:30:18
99	22	250G	\N	250G	2	mapped	2026-01-12 13:30:18	2026-01-12 13:30:18
100	22	500G	\N	500G	3	mapped	2026-01-12 13:30:18	2026-01-12 13:30:18
101	23	1KG	\N	1KG	4	mapped	2026-01-12 13:33:43	2026-01-12 13:33:43
102	23	100G	\N	100G	32	mapped	2026-01-12 13:33:43	2026-01-12 13:33:43
103	23	250G	\N	250G	2	mapped	2026-01-12 13:33:43	2026-01-12 13:33:43
104	23	500G	\N	500G	3	mapped	2026-01-12 13:33:43	2026-01-12 13:33:43
105	24	1KG	\N	1KG	4	mapped	2026-01-12 13:36:13	2026-01-12 13:36:13
106	24	100G	\N	100G	32	mapped	2026-01-12 13:36:13	2026-01-12 13:36:13
107	24	250G	\N	250G	2	mapped	2026-01-12 13:36:13	2026-01-12 13:36:13
108	24	500G	\N	500G	3	mapped	2026-01-12 13:36:13	2026-01-12 13:36:13
\.


--
-- Data for Name: woocommerce_variant_mappings; Type: TABLE DATA; Schema: public; Owner: TheRoasters_Auto
--

COPY public.woocommerce_variant_mappings (id, local_variant_id, woocommerce_variation_id, woocommerce_product_id, last_synced_at, sync_status, created_at, updated_at) FROM stdin;
2	64	4088	4077	2025-12-08 20:15:19	synced	2025-12-08 20:15:19	2025-12-08 20:15:19
3	65	4087	4077	2025-12-08 20:15:19	synced	2025-12-08 20:15:19	2025-12-08 20:15:19
4	66	4086	4077	2025-12-08 20:15:19	synced	2025-12-08 20:15:19	2025-12-08 20:15:19
5	67	4085	4077	2025-12-08 20:15:19	synced	2025-12-08 20:15:19	2025-12-08 20:15:19
6	68	4076	4059	2025-12-08 20:34:55	synced	2025-12-08 20:34:55	2025-12-08 20:34:55
7	69	4075	4059	2025-12-08 20:34:55	synced	2025-12-08 20:34:55	2025-12-08 20:34:55
8	70	4074	4059	2025-12-08 20:34:55	synced	2025-12-08 20:34:55	2025-12-08 20:34:55
9	71	4073	4059	2025-12-08 20:34:55	synced	2025-12-08 20:34:55	2025-12-08 20:34:55
10	72	4001	3994	2025-12-08 20:43:57	synced	2025-12-08 20:43:57	2025-12-08 20:43:57
11	73	4000	3994	2025-12-08 20:43:57	synced	2025-12-08 20:43:57	2025-12-08 20:43:57
12	74	3999	3994	2025-12-08 20:43:57	synced	2025-12-08 20:43:57	2025-12-08 20:43:57
13	75	3998	3994	2025-12-08 20:43:57	synced	2025-12-08 20:43:57	2025-12-08 20:43:57
14	82	4029	4025	2025-12-08 21:07:18	synced	2025-12-08 21:07:18	2025-12-08 21:07:18
15	83	4028	4025	2025-12-08 21:07:18	synced	2025-12-08 21:07:18	2025-12-08 21:07:18
16	84	4027	4025	2025-12-08 21:07:18	synced	2025-12-08 21:07:18	2025-12-08 21:07:18
17	85	4026	4025	2025-12-08 21:07:18	synced	2025-12-08 21:07:18	2025-12-08 21:07:18
18	86	4048	4030	2025-12-08 21:20:10	synced	2025-12-08 21:20:10	2025-12-08 21:20:10
19	87	4047	4030	2025-12-08 21:20:10	synced	2025-12-08 21:20:10	2025-12-08 21:20:10
20	88	4046	4030	2025-12-08 21:20:10	synced	2025-12-08 21:20:10	2025-12-08 21:20:10
21	89	4045	4030	2025-12-08 21:20:10	synced	2025-12-08 21:20:10	2025-12-08 21:20:10
22	96	4140	4136	2025-12-08 21:31:10	synced	2025-12-08 21:31:10	2025-12-08 21:31:10
23	97	4139	4136	2025-12-08 21:31:10	synced	2025-12-08 21:31:10	2025-12-08 21:31:10
24	98	4138	4136	2025-12-08 21:31:10	synced	2025-12-08 21:31:10	2025-12-08 21:31:10
25	99	4137	4136	2025-12-08 21:31:10	synced	2025-12-08 21:31:10	2025-12-08 21:31:10
26	106	4157	4151	2025-12-08 21:38:38	synced	2025-12-08 21:38:38	2025-12-08 21:38:38
27	107	4156	4151	2025-12-08 21:38:38	synced	2025-12-08 21:38:38	2025-12-08 21:38:38
28	108	4155	4151	2025-12-08 21:38:38	synced	2025-12-08 21:38:38	2025-12-08 21:38:38
29	109	4154	4151	2025-12-08 21:38:38	synced	2025-12-08 21:38:38	2025-12-08 21:38:38
30	110	4172	4168	2025-12-08 22:01:19	synced	2025-12-08 22:01:19	2025-12-08 22:01:19
31	111	4171	4168	2025-12-08 22:01:19	synced	2025-12-08 22:01:19	2025-12-08 22:01:19
32	112	4170	4168	2025-12-08 22:01:19	synced	2025-12-08 22:01:19	2025-12-08 22:01:19
33	113	4169	4168	2025-12-08 22:01:19	synced	2025-12-08 22:01:19	2025-12-08 22:01:19
34	126	4214	4195	2025-12-08 22:49:04	synced	2025-12-08 22:49:04	2025-12-08 22:49:04
35	127	4213	4195	2025-12-08 22:49:04	synced	2025-12-08 22:49:04	2025-12-08 22:49:04
36	128	4212	4195	2025-12-08 22:49:04	synced	2025-12-08 22:49:04	2025-12-08 22:49:04
37	129	4211	4195	2025-12-08 22:49:04	synced	2025-12-08 22:49:04	2025-12-08 22:49:04
38	130	4788	4782	2025-12-08 22:53:53	synced	2025-12-08 22:53:53	2025-12-08 22:53:53
39	131	4787	4782	2025-12-08 22:53:53	synced	2025-12-08 22:53:53	2025-12-08 22:53:53
40	132	4786	4782	2025-12-08 22:53:53	synced	2025-12-08 22:53:53	2025-12-08 22:53:53
41	133	4785	4782	2025-12-08 22:53:53	synced	2025-12-08 22:53:53	2025-12-08 22:53:53
42	134	4801	4797	2025-12-08 22:59:29	synced	2025-12-08 22:59:29	2025-12-08 22:59:29
43	135	4800	4797	2025-12-08 22:59:29	synced	2025-12-08 22:59:29	2025-12-08 22:59:29
44	136	4799	4797	2025-12-08 22:59:29	synced	2025-12-08 22:59:29	2025-12-08 22:59:29
45	137	4798	4797	2025-12-08 22:59:29	synced	2025-12-08 22:59:29	2025-12-08 22:59:29
46	138	4691	4686	2026-01-12 13:11:26	synced	2026-01-12 13:11:26	2026-01-12 13:11:26
47	139	4690	4686	2026-01-12 13:11:26	synced	2026-01-12 13:11:26	2026-01-12 13:11:26
48	140	4689	4686	2026-01-12 13:11:26	synced	2026-01-12 13:11:26	2026-01-12 13:11:26
49	141	4688	4686	2026-01-12 13:11:26	synced	2026-01-12 13:11:26	2026-01-12 13:11:26
50	142	4667	4661	2026-01-12 13:19:18	synced	2026-01-12 13:19:18	2026-01-12 13:19:18
51	143	4666	4661	2026-01-12 13:19:18	synced	2026-01-12 13:19:18	2026-01-12 13:19:18
52	144	4665	4661	2026-01-12 13:19:18	synced	2026-01-12 13:19:18	2026-01-12 13:19:18
53	145	4664	4661	2026-01-12 13:19:18	synced	2026-01-12 13:19:18	2026-01-12 13:19:18
54	146	4680	4673	2026-01-12 13:20:11	synced	2026-01-12 13:20:11	2026-01-12 13:20:11
55	147	4679	4673	2026-01-12 13:20:11	synced	2026-01-12 13:20:11	2026-01-12 13:20:11
56	148	4678	4673	2026-01-12 13:20:11	synced	2026-01-12 13:20:11	2026-01-12 13:20:11
57	149	4677	4673	2026-01-12 13:20:11	synced	2026-01-12 13:20:11	2026-01-12 13:20:11
58	150	4655	4649	2026-01-12 13:21:52	synced	2026-01-12 13:21:52	2026-01-12 13:21:52
59	151	4654	4649	2026-01-12 13:21:52	synced	2026-01-12 13:21:52	2026-01-12 13:21:52
60	152	4653	4649	2026-01-12 13:21:53	synced	2026-01-12 13:21:53	2026-01-12 13:21:53
61	153	4652	4649	2026-01-12 13:21:53	synced	2026-01-12 13:21:53	2026-01-12 13:21:53
62	154	4614	4607	2026-01-12 13:31:48	synced	2026-01-12 13:31:48	2026-01-12 13:31:48
63	155	4613	4607	2026-01-12 13:31:48	synced	2026-01-12 13:31:48	2026-01-12 13:31:48
64	156	4612	4607	2026-01-12 13:31:48	synced	2026-01-12 13:31:48	2026-01-12 13:31:48
65	157	4611	4607	2026-01-12 13:31:48	synced	2026-01-12 13:31:48	2026-01-12 13:31:48
66	158	4601	4594	2026-01-12 13:34:35	synced	2026-01-12 13:34:35	2026-01-12 13:34:35
67	159	4600	4594	2026-01-12 13:34:35	synced	2026-01-12 13:34:35	2026-01-12 13:34:35
68	160	4599	4594	2026-01-12 13:34:35	synced	2026-01-12 13:34:35	2026-01-12 13:34:35
69	161	4598	4594	2026-01-12 13:34:36	synced	2026-01-12 13:34:36	2026-01-12 13:34:36
70	162	4588	4583	2026-01-12 13:37:10	synced	2026-01-12 13:37:10	2026-01-12 13:37:10
71	163	4587	4583	2026-01-12 13:37:10	synced	2026-01-12 13:37:10	2026-01-12 13:37:10
72	164	4586	4583	2026-01-12 13:37:10	synced	2026-01-12 13:37:10	2026-01-12 13:37:10
73	165	4585	4583	2026-01-12 13:37:10	synced	2026-01-12 13:37:10	2026-01-12 13:37:10
\.


--
-- Data for Name: wordpress_sync_logs; Type: TABLE DATA; Schema: public; Owner: TheRoasters_Auto
--

COPY public.wordpress_sync_logs (id, action, status, product_id, message, data, products_count, success_count, error_count, created_at, updated_at) FROM stdin;
1	import_single	success	38	تم استيراد المنتج: 925 Sterling Silver Pendent Flower - SV60	\N	1	1	0	2025-11-25 22:39:17	2025-11-25 22:39:17
2	import_single	failed	\N	SQLSTATE[23502]: Not null violation: 7 ERROR:  null value in column "product_name" of relation "products" violates not-null constraint\nDETAIL:  Failing row contains (39, null, 750.00, null, 0, t, null, https://www.zayaline.com/wp-content/uploads/2023/11/1-2-1.jpg, null, About Titanium Named after the "Titans" of Greek mythology for i..., 2025-11-25 23:20:38, 2025-11-25 23:20:38, null, The Key of the Nile CZ Stone Egyptian Cross Titanium Necklace - ..., null, About Titanium Named after the "Titans" of Greek mythology for i..., simple, product, null, piece, manual, null, 5000.00, null, null, f, null, 7, 3, null, null, null, null, pending). (Connection: pgsql, SQL: insert into "products" ("product_name", "description", "description_en", "product_price", "stock", "weight", "available", "picture", "product_name_en", "description_ar", "updated_at", "created_at") values (?, About Titanium Named after the "Titans" of Greek mythology for its extreme strength It is an element with the atomic number of 22, the symbol is Ti It is inert and completely corrosion resistant, titanium will not rust, corrode or ever tarnish. 100% Hypoallergenic, you will not be allergic to titanium. Stronger than steel but 42% lighter, it is only slightly heavier than aluminum. Has the highest ratio of strength and density of all metallic materials. 85% of the space shuttle's structure is made of titanium. Exploding in popularity as a jewelry metal. Titanium is a white metal, but unlike gold it is used in jewelry in almost its pure form (approximately 99% pure). Titanium is extremely long wearing. Its natural color is a gray color. Titanium is very lightweight, so a titanium ring will feel much lighter than an 18ct gold Pendant and much lighter than a platinum Pendant. Pendant, About Titanium Named after the "Titans" of Greek mythology for its extreme strength It is an element with the atomic number of 22, the symbol is Ti It is inert and completely corrosion resistant, titanium will not rust, corrode or ever tarnish. 100% Hypoallergenic, you will not be allergic to titanium. Stronger than steel but 42% lighter, it is only slightly heavier than aluminum. Has the highest ratio of strength and density of all metallic materials. 85% of the space shuttle's structure is made of titanium. Exploding in popularity as a jewelry metal. Titanium is a white metal, but unlike gold it is used in jewelry in almost its pure form (approximately 99% pure). Titanium is extremely long wearing. Its natural color is a gray color. Titanium is very lightweight, so a titanium ring will feel much lighter than an 18ct gold Pendant and much lighter than a platinum Pendant. Pendant, 750, 0, ?, 1, https://www.zayaline.com/wp-content/uploads/2023/11/1-2-1.jpg, The Key of the Nile CZ Stone Egyptian Cross Titanium Necklace - LK80, ?, 2025-11-25 23:20:38, 2025-11-25 23:20:38) returning "id")	\N	0	0	0	2025-11-25 23:20:38	2025-11-25 23:20:38
3	import_single	failed	\N	SQLSTATE[23502]: Not null violation: 7 ERROR:  null value in column "product_name" of relation "products" violates not-null constraint\nDETAIL:  Failing row contains (40, null, 750.00, null, 0, t, null, https://www.zayaline.com/wp-content/uploads/2023/11/1-2-1.jpg, null, About Titanium Named after the "Titans" of Greek mythology for i..., 2025-11-25 23:22:40, 2025-11-25 23:22:40, null, The Key of the Nile CZ Stone Egyptian Cross Titanium Necklace - ..., null, About Titanium Named after the "Titans" of Greek mythology for i..., simple, product, null, piece, manual, null, 5000.00, null, null, f, null, 7, 3, null, null, null, null, pending). (Connection: pgsql, SQL: insert into "products" ("product_name", "description", "description_en", "product_price", "stock", "weight", "available", "picture", "product_name_en", "description_ar", "updated_at", "created_at") values (?, About Titanium Named after the "Titans" of Greek mythology for its extreme strength It is an element with the atomic number of 22, the symbol is Ti It is inert and completely corrosion resistant, titanium will not rust, corrode or ever tarnish. 100% Hypoallergenic, you will not be allergic to titanium. Stronger than steel but 42% lighter, it is only slightly heavier than aluminum. Has the highest ratio of strength and density of all metallic materials. 85% of the space shuttle's structure is made of titanium. Exploding in popularity as a jewelry metal. Titanium is a white metal, but unlike gold it is used in jewelry in almost its pure form (approximately 99% pure). Titanium is extremely long wearing. Its natural color is a gray color. Titanium is very lightweight, so a titanium ring will feel much lighter than an 18ct gold Pendant and much lighter than a platinum Pendant. Pendant, About Titanium Named after the "Titans" of Greek mythology for its extreme strength It is an element with the atomic number of 22, the symbol is Ti It is inert and completely corrosion resistant, titanium will not rust, corrode or ever tarnish. 100% Hypoallergenic, you will not be allergic to titanium. Stronger than steel but 42% lighter, it is only slightly heavier than aluminum. Has the highest ratio of strength and density of all metallic materials. 85% of the space shuttle's structure is made of titanium. Exploding in popularity as a jewelry metal. Titanium is a white metal, but unlike gold it is used in jewelry in almost its pure form (approximately 99% pure). Titanium is extremely long wearing. Its natural color is a gray color. Titanium is very lightweight, so a titanium ring will feel much lighter than an 18ct gold Pendant and much lighter than a platinum Pendant. Pendant, 750, 0, ?, 1, https://www.zayaline.com/wp-content/uploads/2023/11/1-2-1.jpg, The Key of the Nile CZ Stone Egyptian Cross Titanium Necklace - LK80, ?, 2025-11-25 23:22:40, 2025-11-25 23:22:40) returning "id")	\N	0	0	0	2025-11-25 23:22:40	2025-11-25 23:22:40
4	import_single	failed	\N	SQLSTATE[23502]: Not null violation: 7 ERROR:  null value in column "product_name" of relation "products" violates not-null constraint\nDETAIL:  Failing row contains (41, null, 795.00, null, 0, t, null, https://www.zayaline.com/wp-content/uploads/2023/11/1-3.jpg, null, 925 Sterling Silver Pendent Flower - SV60 Product Features: Made..., 2025-11-25 23:23:56, 2025-11-25 23:23:56, null, 925 Sterling Silver Pendent Flower - SV60, null, 925 Sterling Silver Pendent Flower - SV60 Product Features: Made..., simple, product, null, piece, manual, null, 5000.00, null, null, f, null, 7, 3, null, null, null, null, pending). (Connection: pgsql, SQL: insert into "products" ("product_name", "description", "description_en", "product_price", "stock", "weight", "available", "picture", "product_name_en", "description_ar", "updated_at", "created_at") values (?, 925 Sterling Silver Pendent Flower - SV60 Product Features: Made of 925 Sterling silver. Gemstone enamel has been used. The Pendent is made by handcraft. The product has a certificate. We advise you not to use soap or any chemicals for a long time because the ring loses its luster . 925 Sterling Silver pendant with a stainless steel chain   925 Sterling silver from LookStock, 925 Sterling Silver Pendent Flower - SV60 Product Features: Made of 925 Sterling silver. Gemstone enamel has been used. The Pendent is made by handcraft. The product has a certificate. We advise you not to use soap or any chemicals for a long time because the ring loses its luster . 925 Sterling Silver pendant with a stainless steel chain   925 Sterling silver from LookStock, 795, 0, ?, 1, https://www.zayaline.com/wp-content/uploads/2023/11/1-3.jpg, 925 Sterling Silver Pendent Flower - SV60, ?, 2025-11-25 23:23:56, 2025-11-25 23:23:56) returning "id")	\N	0	0	0	2025-11-25 23:23:56	2025-11-25 23:23:56
5	import_single	failed	\N	SQLSTATE[23502]: Not null violation: 7 ERROR:  null value in column "product_name" of relation "products" violates not-null constraint\nDETAIL:  Failing row contains (42, null, 750.00, null, 0, t, null, https://www.zayaline.com/wp-content/uploads/2023/11/1-2-1.jpg, null, null, 2025-11-25 23:31:53, 2025-11-25 23:31:53, null, The Key of the Nile CZ Stone Egyptian Cross Titanium Necklace - ..., null, About Titanium Named after the "Titans" of Greek mythology for i..., simple, product, null, piece, manual, null, 5000.00, null, null, f, null, 7, 3, null, null, null, null, pending). (Connection: pgsql, SQL: insert into "products" ("product_name", "description", "description_en", "product_price", "stock", "weight", "available", "picture", "product_name_en", "updated_at", "created_at") values (?, ?, About Titanium Named after the "Titans" of Greek mythology for its extreme strength It is an element with the atomic number of 22, the symbol is Ti It is inert and completely corrosion resistant, titanium will not rust, corrode or ever tarnish. 100% Hypoallergenic, you will not be allergic to titanium. Stronger than steel but 42% lighter, it is only slightly heavier than aluminum. Has the highest ratio of strength and density of all metallic materials. 85% of the space shuttle's structure is made of titanium. Exploding in popularity as a jewelry metal. Titanium is a white metal, but unlike gold it is used in jewelry in almost its pure form (approximately 99% pure). Titanium is extremely long wearing. Its natural color is a gray color. Titanium is very lightweight, so a titanium ring will feel much lighter than an 18ct gold Pendant and much lighter than a platinum Pendant. Pendant, 750, 0, ?, 1, https://www.zayaline.com/wp-content/uploads/2023/11/1-2-1.jpg, The Key of the Nile CZ Stone Egyptian Cross Titanium Necklace - LK80, 2025-11-25 23:31:53, 2025-11-25 23:31:53) returning "id")	\N	0	0	0	2025-11-25 23:31:53	2025-11-25 23:31:53
6	import_single	failed	\N	SQLSTATE[23502]: Not null violation: 7 ERROR:  null value in column "product_name" of relation "products" violates not-null constraint\nDETAIL:  Failing row contains (43, null, 795.00, null, 0, t, null, https://www.zayaline.com/wp-content/uploads/2023/11/1-3.jpg, null, null, 2025-11-25 23:32:28, 2025-11-25 23:32:28, null, 925 Sterling Silver Pendent Flower - SV60, null, 925 Sterling Silver Pendent Flower - SV60 Product Features: Made..., simple, product, null, piece, manual, null, 5000.00, null, null, f, null, 7, 3, null, null, null, null, pending). (Connection: pgsql, SQL: insert into "products" ("product_name", "description", "description_en", "product_price", "stock", "weight", "available", "picture", "product_name_en", "updated_at", "created_at") values (?, ?, 925 Sterling Silver Pendent Flower - SV60 Product Features: Made of 925 Sterling silver. Gemstone enamel has been used. The Pendent is made by handcraft. The product has a certificate. We advise you not to use soap or any chemicals for a long time because the ring loses its luster . 925 Sterling Silver pendant with a stainless steel chain   925 Sterling silver from LookStock, 795, 0, ?, 1, https://www.zayaline.com/wp-content/uploads/2023/11/1-3.jpg, 925 Sterling Silver Pendent Flower - SV60, 2025-11-25 23:32:28, 2025-11-25 23:32:28) returning "id")	\N	0	0	0	2025-11-25 23:32:28	2025-11-25 23:32:28
7	import_single	success	44	تم استيراد المنتج: 925 Sterling Silver Pendent Flower - SV60	\N	1	1	0	2025-11-25 23:39:48	2025-11-25 23:39:48
8	import_single	success	45	تم استيراد المنتج: قلادة زهرة الفضة الإسترليني 925 الفضة الإسترليني - SV60	\N	1	1	0	2025-11-26 00:11:54	2025-11-26 00:11:54
9	import_single	success	46	تم استيراد المنتج: سلسال الصليب المصري المصنوع من التيتانيوم المصنوع من حجر التيتانيوم - LK80	\N	1	1	0	2025-11-26 00:17:38	2025-11-26 00:17:38
10	import_single	success	47	تم استيراد المنتج: قلادة تيتانيوم - GL88	\N	1	1	0	2025-11-26 00:27:25	2025-11-26 00:27:25
11	import_single	success	48	تم استيراد المنتج: قلادة الأزواج التيتانيوم - CP20	\N	1	1	0	2025-11-26 00:33:32	2025-11-26 00:33:32
12	import_single	success	49	تم استيراد المنتج: ليزر أخضر أصلي بقوة 10,000 واط، مصنوع في ألمانيا	\N	1	1	0	2025-11-26 00:40:29	2025-11-26 00:40:29
13	import_single	success	50	تم استيراد المنتج: مجوهرات معلقة من الفضة الإسترليني عيار 925 - SV34	\N	1	1	0	2025-11-26 00:47:06	2025-11-26 00:47:06
14	import_single	success	55	تم استيراد المنتج: ملك الجوز الخام	\N	1	1	0	2025-12-08 20:32:06	2025-12-08 20:32:06
15	import_single	success	66	تم استيراد المنتج: سوري قمر الدين 400 غرام	\N	1	1	0	2026-01-12 12:58:55	2026-01-12 12:58:55
16	import_single	success	69	تم استيراد المنتج: التين السوري	\N	1	1	0	2026-01-12 13:14:06	2026-01-12 13:14:06
17	import_single	success	70	تم استيراد المنتج: التين السوري	\N	1	1	0	2026-01-12 13:15:40	2026-01-12 13:15:40
\.


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

COPY public.zones (id, name, name_ar, price, active, created_at, updated_at) FROM stdin;
1	Greater Cairo	القاهرة الكبرى	120.00	t	2025-11-17 22:10:56	2025-11-17 22:25:06
2	Alexandria	الإسكندرية	125.00	t	2025-11-17 22:10:56	2025-11-18 12:17:28
4	Canal Cities	مدن القناة	130.00	t	2025-11-17 22:10:56	2025-11-18 12:17:38
3	Delta	الدلتا	135.00	t	2025-11-17 22:10:56	2025-11-18 12:17:48
10	New Cities	المدن الجديدة	120.00	t	2025-11-17 22:10:56	2025-11-18 12:18:02
9	North Coast	الساحل الشمالي	150.00	t	2025-11-17 22:10:56	2025-11-18 12:18:13
7	North Sinai	شمال سيناء	150.00	t	2025-11-17 22:10:56	2025-11-18 12:18:23
6	Red Sea	البحر الأحمر	150.00	t	2025-11-17 22:10:56	2025-11-18 12:18:32
8	South Sinai	جنوب سيناء	150.00	t	2025-11-17 22:10:56	2025-11-18 12:18:41
5	Upper Egypt	صعيد مصر	150.00	t	2025-11-17 22:10:56	2025-11-18 12:18:49
\.


--
-- Name: abandoned_carts_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: ai_memories_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.ai_memories_id_seq', 1254, true);


--
-- Name: api_key_logs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.api_key_logs_id_seq', 1719, true);


--
-- Name: api_keys_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.api_keys_id_seq', 12, true);


--
-- Name: cart_sessions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: cashback_transactions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


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

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


--
-- Name: category_offer_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.category_offer_id_seq', 8, true);


--
-- Name: category_product_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.category_product_id_seq', 81, true);


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

SELECT pg_catalog.setval('public.cities_id_seq', 61, true);


--
-- Name: company_document_files_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: company_documents_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: coupon_usages_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: coupons_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.coupons_id_seq', 8, true);


--
-- Name: customers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.customers_id_seq', 7437, true);


--
-- Name: exports_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: failed_import_rows_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: failed_jobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: imports_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: jobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: migrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.migrations_id_seq', 86, true);


--
-- Name: offer_conditions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: offer_products_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.offer_products_id_seq', 12, true);


--
-- Name: offers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: order_items_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.order_items_id_seq', 163, true);


--
-- Name: order_number_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.order_number_seq', 45634222, false);


--
-- Name: orders_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.orders_id_seq', 88, true);


--
-- Name: page_blocks_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: payment_methods_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.payment_methods_id_seq', 3, true);


--
-- Name: permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: personal_access_tokens_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: price_histories_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.price_histories_id_seq', 186, true);


--
-- Name: pricing_rule_usage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: pricing_rules_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: product_attribute_options_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.product_attribute_options_id_seq', 35, true);


--
-- Name: product_attributes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.product_attributes_id_seq', 9, true);


--
-- Name: product_media_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.product_media_id_seq', 3, true);


--
-- Name: product_related_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: product_reviews_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: product_variant_attributes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.product_variant_attributes_id_seq', 334, true);


--
-- Name: product_variants_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.product_variants_id_seq', 165, true);


--
-- Name: products_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.products_id_seq', 76, true);


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

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


--
-- Name: settings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.settings_id_seq', 28, true);


--
-- Name: shipping_companies_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: shipping_prices_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: sma_pending_imports_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.sma_pending_imports_id_seq', 7428, true);


--
-- Name: social_logins_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: stock_movements_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.stock_movements_id_seq', 277, true);


--
-- Name: store_banners_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: store_colors_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: store_navigations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: store_pages_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: store_settings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.store_settings_id_seq', 29, true);


--
-- Name: store_testimonials_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: store_themes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.store_themes_id_seq', 3, true);


--
-- Name: store_translations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.store_translations_id_seq', 75, true);


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

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


--
-- Name: variant_analytics_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: variant_associations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: verification_codes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: wishlists_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: woocommerce_attribute_mappings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: woocommerce_customer_import_logs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.woocommerce_customer_import_logs_id_seq', 135, true);


--
-- Name: woocommerce_import_logs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.woocommerce_import_logs_id_seq', 338, true);


--
-- Name: woocommerce_option_mappings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.woocommerce_option_mappings_id_seq', 18, true);


--
-- Name: woocommerce_pending_attributes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.woocommerce_pending_attributes_id_seq', 25, true);


--
-- Name: woocommerce_pending_customer_imports_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.woocommerce_pending_customer_imports_id_seq', 377, true);


--
-- Name: woocommerce_pending_imports_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.woocommerce_pending_imports_id_seq', 25, true);


--
-- Name: woocommerce_pending_options_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.woocommerce_pending_options_id_seq', 112, true);


--
-- Name: woocommerce_variant_mappings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.woocommerce_variant_mappings_id_seq', 73, true);


--
-- Name: wordpress_sync_logs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: TheRoasters_Auto
--

SELECT pg_catalog.setval('public.wordpress_sync_logs_id_seq', 17, true);


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

SELECT pg_catalog.setval('public.zones_id_seq', 10, true);


--
-- Name: abandoned_carts abandoned_carts_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.abandoned_carts
    ADD CONSTRAINT abandoned_carts_pkey PRIMARY KEY (id);


--
-- Name: ai_memories ai_memories_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.ai_memories
    ADD CONSTRAINT ai_memories_pkey PRIMARY KEY (id);


--
-- Name: api_key_logs api_key_logs_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.api_key_logs
    ADD CONSTRAINT api_key_logs_pkey PRIMARY KEY (id);


--
-- Name: api_keys api_keys_key_hash_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.api_keys
    ADD CONSTRAINT api_keys_key_hash_unique UNIQUE (key_hash);


--
-- Name: api_keys api_keys_key_prefix_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.api_keys
    ADD CONSTRAINT api_keys_key_prefix_unique UNIQUE (key_prefix);


--
-- Name: api_keys api_keys_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.api_keys
    ADD CONSTRAINT api_keys_pkey PRIMARY KEY (id);


--
-- Name: cart_sessions cart_sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.cart_sessions
    ADD CONSTRAINT cart_sessions_pkey PRIMARY KEY (id);


--
-- Name: cart_sessions cart_sessions_session_id_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.cart_sessions
    ADD CONSTRAINT cart_sessions_session_id_unique UNIQUE (session_id);


--
-- Name: cashback_transactions cashback_transactions_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.cashback_transactions
    ADD CONSTRAINT cashback_transactions_pkey PRIMARY KEY (id);


--
-- Name: categories categories_name_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.categories
    ADD CONSTRAINT categories_name_unique UNIQUE (name);


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

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


--
-- Name: category_offer category_offer_category_id_offer_id_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.category_offer
    ADD CONSTRAINT category_offer_category_id_offer_id_unique UNIQUE (category_id, offer_id);


--
-- Name: category_offer category_offer_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.category_offer
    ADD CONSTRAINT category_offer_pkey PRIMARY KEY (id);


--
-- Name: category_product category_product_category_id_product_id_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.category_product
    ADD CONSTRAINT category_product_category_id_product_id_unique UNIQUE (category_id, product_id);


--
-- Name: category_product category_product_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.category_product
    ADD CONSTRAINT category_product_pkey PRIMARY KEY (id);


--
-- Name: cities cities_name_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.cities
    ADD CONSTRAINT cities_name_unique UNIQUE (name);


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

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


--
-- Name: company_document_files company_document_files_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.company_document_files
    ADD CONSTRAINT company_document_files_pkey PRIMARY KEY (id);


--
-- Name: company_documents company_documents_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.company_documents
    ADD CONSTRAINT company_documents_pkey PRIMARY KEY (id);


--
-- Name: company_documents company_documents_uuid_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.company_documents
    ADD CONSTRAINT company_documents_uuid_unique UNIQUE (uuid);


--
-- Name: coupon_usages coupon_usages_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.coupon_usages
    ADD CONSTRAINT coupon_usages_pkey PRIMARY KEY (id);


--
-- Name: coupons coupons_code_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.coupons
    ADD CONSTRAINT coupons_code_unique UNIQUE (code);


--
-- Name: coupons coupons_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.coupons
    ADD CONSTRAINT coupons_pkey PRIMARY KEY (id);


--
-- Name: customers customers_email_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.customers
    ADD CONSTRAINT customers_email_unique UNIQUE (email);


--
-- Name: customers customers_fb_commenter_id_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.customers
    ADD CONSTRAINT customers_fb_commenter_id_unique UNIQUE (fb_commenter_id);


--
-- Name: customers customers_fb_subscriber_id_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.customers
    ADD CONSTRAINT customers_fb_subscriber_id_unique UNIQUE (fb_subscriber_id);


--
-- Name: customers customers_ig_commenter_id_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.customers
    ADD CONSTRAINT customers_ig_commenter_id_unique UNIQUE (ig_commenter_id);


--
-- Name: customers customers_ig_dm_id_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.customers
    ADD CONSTRAINT customers_ig_dm_id_unique UNIQUE (ig_dm_id);


--
-- Name: customers customers_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.customers
    ADD CONSTRAINT customers_pkey PRIMARY KEY (id);


--
-- Name: customers customers_sma_id_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.customers
    ADD CONSTRAINT customers_sma_id_unique UNIQUE (sma_id);


--
-- Name: customers customers_unified_id_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.customers
    ADD CONSTRAINT customers_unified_id_unique UNIQUE (unified_id);


--
-- Name: customers customers_whatsapp_id_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.customers
    ADD CONSTRAINT customers_whatsapp_id_unique UNIQUE (whatsapp_id);


--
-- Name: customers customers_woocommerce_id_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.customers
    ADD CONSTRAINT customers_woocommerce_id_unique UNIQUE (woocommerce_id);


--
-- Name: exports exports_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.exports
    ADD CONSTRAINT exports_pkey PRIMARY KEY (id);


--
-- Name: failed_import_rows failed_import_rows_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.failed_import_rows
    ADD CONSTRAINT failed_import_rows_pkey PRIMARY KEY (id);


--
-- Name: failed_jobs failed_jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

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: TheRoasters_Auto
--

ALTER TABLE ONLY public.failed_jobs
    ADD CONSTRAINT failed_jobs_uuid_unique UNIQUE (uuid);


--
-- Name: imports imports_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.imports
    ADD CONSTRAINT imports_pkey PRIMARY KEY (id);


--
-- Name: job_batches job_batches_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.job_batches
    ADD CONSTRAINT job_batches_pkey PRIMARY KEY (id);


--
-- Name: jobs jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.jobs
    ADD CONSTRAINT jobs_pkey PRIMARY KEY (id);


--
-- Name: migrations migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.migrations
    ADD CONSTRAINT migrations_pkey PRIMARY KEY (id);


--
-- Name: model_has_permissions model_has_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.model_has_permissions
    ADD CONSTRAINT model_has_permissions_pkey PRIMARY KEY (permission_id, model_id, model_type);


--
-- Name: model_has_roles model_has_roles_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.model_has_roles
    ADD CONSTRAINT model_has_roles_pkey PRIMARY KEY (role_id, model_id, model_type);


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

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


--
-- Name: offer_conditions offer_conditions_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.offer_conditions
    ADD CONSTRAINT offer_conditions_pkey PRIMARY KEY (id);


--
-- Name: offer_products offer_products_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.offer_products
    ADD CONSTRAINT offer_products_pkey PRIMARY KEY (id);


--
-- Name: offers offers_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.offers
    ADD CONSTRAINT offers_pkey PRIMARY KEY (id);


--
-- Name: offers offers_slug_en_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.offers
    ADD CONSTRAINT offers_slug_en_unique UNIQUE (slug_en);


--
-- Name: offers offers_slug_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.offers
    ADD CONSTRAINT offers_slug_unique UNIQUE (slug);


--
-- Name: order_items order_items_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.order_items
    ADD CONSTRAINT order_items_pkey PRIMARY KEY (id);


--
-- Name: orders orders_order_number_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.orders
    ADD CONSTRAINT orders_order_number_unique UNIQUE (order_number);


--
-- Name: orders orders_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.orders
    ADD CONSTRAINT orders_pkey PRIMARY KEY (id);


--
-- Name: page_blocks page_blocks_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.page_blocks
    ADD CONSTRAINT page_blocks_pkey PRIMARY KEY (id);


--
-- Name: password_reset_tokens password_reset_tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.password_reset_tokens
    ADD CONSTRAINT password_reset_tokens_pkey PRIMARY KEY (email);


--
-- Name: payment_methods payment_methods_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.payment_methods
    ADD CONSTRAINT payment_methods_pkey PRIMARY KEY (id);


--
-- Name: permissions permissions_name_guard_name_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.permissions
    ADD CONSTRAINT permissions_name_guard_name_unique UNIQUE (name, guard_name);


--
-- Name: permissions permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.permissions
    ADD CONSTRAINT permissions_pkey PRIMARY KEY (id);


--
-- Name: personal_access_tokens personal_access_tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.personal_access_tokens
    ADD CONSTRAINT personal_access_tokens_pkey PRIMARY KEY (id);


--
-- Name: personal_access_tokens personal_access_tokens_token_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.personal_access_tokens
    ADD CONSTRAINT personal_access_tokens_token_unique UNIQUE (token);


--
-- Name: price_histories price_histories_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.price_histories
    ADD CONSTRAINT price_histories_pkey PRIMARY KEY (id);


--
-- Name: pricing_rule_usage pricing_rule_usage_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.pricing_rule_usage
    ADD CONSTRAINT pricing_rule_usage_pkey PRIMARY KEY (id);


--
-- Name: pricing_rules pricing_rules_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.pricing_rules
    ADD CONSTRAINT pricing_rules_pkey PRIMARY KEY (id);


--
-- Name: product_attribute_options product_attribute_options_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.product_attribute_options
    ADD CONSTRAINT product_attribute_options_pkey PRIMARY KEY (id);


--
-- Name: product_attributes product_attributes_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.product_attributes
    ADD CONSTRAINT product_attributes_pkey PRIMARY KEY (id);


--
-- Name: product_attributes product_attributes_slug_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.product_attributes
    ADD CONSTRAINT product_attributes_slug_unique UNIQUE (slug);


--
-- Name: product_media product_media_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.product_media
    ADD CONSTRAINT product_media_pkey PRIMARY KEY (id);


--
-- Name: product_related product_related_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.product_related
    ADD CONSTRAINT product_related_pkey PRIMARY KEY (id);


--
-- Name: product_related product_related_product_id_related_product_id_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.product_related
    ADD CONSTRAINT product_related_product_id_related_product_id_unique UNIQUE (product_id, related_product_id);


--
-- Name: product_reviews product_reviews_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.product_reviews
    ADD CONSTRAINT product_reviews_pkey PRIMARY KEY (id);


--
-- Name: product_variant_attributes product_variant_attributes_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.product_variant_attributes
    ADD CONSTRAINT product_variant_attributes_pkey PRIMARY KEY (id);


--
-- Name: product_variant_attributes product_variant_attributes_variant_id_attribute_id_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.product_variant_attributes
    ADD CONSTRAINT product_variant_attributes_variant_id_attribute_id_unique UNIQUE (variant_id, attribute_id);


--
-- Name: product_variants product_variants_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.product_variants
    ADD CONSTRAINT product_variants_pkey PRIMARY KEY (id);


--
-- Name: product_variants product_variants_sku_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.product_variants
    ADD CONSTRAINT product_variants_sku_unique UNIQUE (sku);


--
-- Name: products products_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.products
    ADD CONSTRAINT products_pkey PRIMARY KEY (id);


--
-- Name: products products_slug_en_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.products
    ADD CONSTRAINT products_slug_en_unique UNIQUE (slug_en);


--
-- Name: products products_slug_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.products
    ADD CONSTRAINT products_slug_unique UNIQUE (slug);


--
-- Name: role_has_permissions role_has_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.role_has_permissions
    ADD CONSTRAINT role_has_permissions_pkey PRIMARY KEY (permission_id, role_id);


--
-- Name: roles roles_name_guard_name_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.roles
    ADD CONSTRAINT roles_name_guard_name_unique UNIQUE (name, guard_name);


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

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


--
-- Name: settings settings_key_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.settings
    ADD CONSTRAINT settings_key_unique UNIQUE (key);


--
-- Name: settings settings_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.settings
    ADD CONSTRAINT settings_pkey PRIMARY KEY (id);


--
-- Name: shipping_companies shipping_companies_name_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.shipping_companies
    ADD CONSTRAINT shipping_companies_name_unique UNIQUE (name);


--
-- Name: shipping_companies shipping_companies_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.shipping_companies
    ADD CONSTRAINT shipping_companies_pkey PRIMARY KEY (id);


--
-- Name: shipping_prices shipping_prices_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.shipping_prices
    ADD CONSTRAINT shipping_prices_pkey PRIMARY KEY (id);


--
-- Name: shipping_prices shipping_prices_zone_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.shipping_prices
    ADD CONSTRAINT shipping_prices_zone_unique UNIQUE (zone);


--
-- Name: sma_pending_imports sma_pending_imports_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.sma_pending_imports
    ADD CONSTRAINT sma_pending_imports_pkey PRIMARY KEY (id);


--
-- Name: sma_pending_imports sma_pending_imports_sma_id_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.sma_pending_imports
    ADD CONSTRAINT sma_pending_imports_sma_id_unique UNIQUE (sma_id);


--
-- Name: social_logins social_logins_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.social_logins
    ADD CONSTRAINT social_logins_pkey PRIMARY KEY (id);


--
-- Name: social_logins social_logins_provider_provider_id_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.social_logins
    ADD CONSTRAINT social_logins_provider_provider_id_unique UNIQUE (provider, provider_id);


--
-- Name: stock_movements stock_movements_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.stock_movements
    ADD CONSTRAINT stock_movements_pkey PRIMARY KEY (id);


--
-- Name: store_banners store_banners_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.store_banners
    ADD CONSTRAINT store_banners_pkey PRIMARY KEY (id);


--
-- Name: store_colors store_colors_key_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.store_colors
    ADD CONSTRAINT store_colors_key_unique UNIQUE (key);


--
-- Name: store_colors store_colors_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.store_colors
    ADD CONSTRAINT store_colors_pkey PRIMARY KEY (id);


--
-- Name: store_navigations store_navigations_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.store_navigations
    ADD CONSTRAINT store_navigations_pkey PRIMARY KEY (id);


--
-- Name: store_pages store_pages_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.store_pages
    ADD CONSTRAINT store_pages_pkey PRIMARY KEY (id);


--
-- Name: store_pages store_pages_slug_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.store_pages
    ADD CONSTRAINT store_pages_slug_unique UNIQUE (slug);


--
-- Name: store_settings store_settings_key_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.store_settings
    ADD CONSTRAINT store_settings_key_unique UNIQUE (key);


--
-- Name: store_settings store_settings_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.store_settings
    ADD CONSTRAINT store_settings_pkey PRIMARY KEY (id);


--
-- Name: store_testimonials store_testimonials_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.store_testimonials
    ADD CONSTRAINT store_testimonials_pkey PRIMARY KEY (id);


--
-- Name: store_themes store_themes_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.store_themes
    ADD CONSTRAINT store_themes_pkey PRIMARY KEY (id);


--
-- Name: store_themes store_themes_slug_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.store_themes
    ADD CONSTRAINT store_themes_slug_unique UNIQUE (slug);


--
-- Name: store_translations store_translations_key_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.store_translations
    ADD CONSTRAINT store_translations_key_unique UNIQUE (key);


--
-- Name: store_translations store_translations_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.store_translations
    ADD CONSTRAINT store_translations_pkey PRIMARY KEY (id);


--
-- Name: verification_codes unique_customer; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.verification_codes
    ADD CONSTRAINT unique_customer UNIQUE (customer_id);


--
-- Name: users users_email_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

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


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

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


--
-- Name: variant_analytics variant_analytics_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.variant_analytics
    ADD CONSTRAINT variant_analytics_pkey PRIMARY KEY (id);


--
-- Name: variant_associations variant_associations_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.variant_associations
    ADD CONSTRAINT variant_associations_pkey PRIMARY KEY (id);


--
-- Name: variant_associations variant_pair_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.variant_associations
    ADD CONSTRAINT variant_pair_unique UNIQUE (variant_a_id, variant_b_id);


--
-- Name: variant_analytics variant_period_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.variant_analytics
    ADD CONSTRAINT variant_period_unique UNIQUE (product_variant_id, period_start, period_end, period_type);


--
-- Name: verification_codes verification_codes_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.verification_codes
    ADD CONSTRAINT verification_codes_pkey PRIMARY KEY (id);


--
-- Name: wishlists wishlists_customer_id_product_id_variant_id_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.wishlists
    ADD CONSTRAINT wishlists_customer_id_product_id_variant_id_unique UNIQUE (customer_id, product_id, variant_id);


--
-- Name: wishlists wishlists_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.wishlists
    ADD CONSTRAINT wishlists_pkey PRIMARY KEY (id);


--
-- Name: woocommerce_attribute_mappings woocommerce_attribute_mappings_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.woocommerce_attribute_mappings
    ADD CONSTRAINT woocommerce_attribute_mappings_pkey PRIMARY KEY (id);


--
-- Name: woocommerce_attribute_mappings woocommerce_attribute_mappings_woocommerce_slug_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.woocommerce_attribute_mappings
    ADD CONSTRAINT woocommerce_attribute_mappings_woocommerce_slug_unique UNIQUE (woocommerce_slug);


--
-- Name: woocommerce_customer_import_logs woocommerce_customer_import_logs_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.woocommerce_customer_import_logs
    ADD CONSTRAINT woocommerce_customer_import_logs_pkey PRIMARY KEY (id);


--
-- Name: woocommerce_import_logs woocommerce_import_logs_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.woocommerce_import_logs
    ADD CONSTRAINT woocommerce_import_logs_pkey PRIMARY KEY (id);


--
-- Name: woocommerce_option_mappings woocommerce_option_mappings_attribute_mapping_id_woocommerce_va; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.woocommerce_option_mappings
    ADD CONSTRAINT woocommerce_option_mappings_attribute_mapping_id_woocommerce_va UNIQUE (attribute_mapping_id, woocommerce_value);


--
-- Name: woocommerce_option_mappings woocommerce_option_mappings_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.woocommerce_option_mappings
    ADD CONSTRAINT woocommerce_option_mappings_pkey PRIMARY KEY (id);


--
-- Name: woocommerce_pending_attributes woocommerce_pending_attributes_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.woocommerce_pending_attributes
    ADD CONSTRAINT woocommerce_pending_attributes_pkey PRIMARY KEY (id);


--
-- Name: woocommerce_pending_customer_imports woocommerce_pending_customer_imports_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.woocommerce_pending_customer_imports
    ADD CONSTRAINT woocommerce_pending_customer_imports_pkey PRIMARY KEY (id);


--
-- Name: woocommerce_pending_customer_imports woocommerce_pending_customer_imports_woocommerce_id_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.woocommerce_pending_customer_imports
    ADD CONSTRAINT woocommerce_pending_customer_imports_woocommerce_id_unique UNIQUE (woocommerce_id);


--
-- Name: woocommerce_pending_imports woocommerce_pending_imports_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.woocommerce_pending_imports
    ADD CONSTRAINT woocommerce_pending_imports_pkey PRIMARY KEY (id);


--
-- Name: woocommerce_pending_imports woocommerce_pending_imports_woocommerce_id_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.woocommerce_pending_imports
    ADD CONSTRAINT woocommerce_pending_imports_woocommerce_id_unique UNIQUE (woocommerce_id);


--
-- Name: woocommerce_pending_options woocommerce_pending_options_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.woocommerce_pending_options
    ADD CONSTRAINT woocommerce_pending_options_pkey PRIMARY KEY (id);


--
-- Name: woocommerce_variant_mappings woocommerce_variant_mappings_local_variant_id_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.woocommerce_variant_mappings
    ADD CONSTRAINT woocommerce_variant_mappings_local_variant_id_unique UNIQUE (local_variant_id);


--
-- Name: woocommerce_variant_mappings woocommerce_variant_mappings_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.woocommerce_variant_mappings
    ADD CONSTRAINT woocommerce_variant_mappings_pkey PRIMARY KEY (id);


--
-- Name: wordpress_sync_logs wordpress_sync_logs_pkey; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.wordpress_sync_logs
    ADD CONSTRAINT wordpress_sync_logs_pkey PRIMARY KEY (id);


--
-- Name: zones zones_name_unique; Type: CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.zones
    ADD CONSTRAINT zones_name_unique UNIQUE (name);


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

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


--
-- Name: abandoned_carts_customer_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX abandoned_carts_customer_id_index ON public.abandoned_carts USING btree (customer_id);


--
-- Name: abandoned_carts_notification_sent_created_at_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX abandoned_carts_notification_sent_created_at_index ON public.abandoned_carts USING btree (notification_sent, created_at);


--
-- Name: ai_memories_message_type_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX ai_memories_message_type_index ON public.ai_memories USING btree (message_type);


--
-- Name: ai_memories_session_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX ai_memories_session_id_index ON public.ai_memories USING btree (session_id);


--
-- Name: api_key_logs_api_key_id_created_at_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX api_key_logs_api_key_id_created_at_index ON public.api_key_logs USING btree (api_key_id, created_at);


--
-- Name: api_key_logs_key_prefix_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX api_key_logs_key_prefix_index ON public.api_key_logs USING btree (key_prefix);


--
-- Name: api_keys_expires_at_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX api_keys_expires_at_index ON public.api_keys USING btree (expires_at);


--
-- Name: api_keys_status_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX api_keys_status_index ON public.api_keys USING btree (status);


--
-- Name: cart_sessions_customer_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX cart_sessions_customer_id_index ON public.cart_sessions USING btree (customer_id);


--
-- Name: cart_sessions_expires_at_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX cart_sessions_expires_at_index ON public.cart_sessions USING btree (expires_at);


--
-- Name: cashback_transactions_customer_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX cashback_transactions_customer_id_index ON public.cashback_transactions USING btree (customer_id);


--
-- Name: cashback_transactions_expires_at_expired_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX cashback_transactions_expires_at_expired_index ON public.cashback_transactions USING btree (expires_at, expired);


--
-- Name: cashback_transactions_order_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX cashback_transactions_order_id_index ON public.cashback_transactions USING btree (order_id);


--
-- Name: cashback_transactions_type_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX cashback_transactions_type_index ON public.cashback_transactions USING btree (type);


--
-- Name: categories_parent_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX categories_parent_id_index ON public.categories USING btree (parent_id);


--
-- Name: company_document_files_company_document_id_is_primary_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX company_document_files_company_document_id_is_primary_index ON public.company_document_files USING btree (company_document_id, is_primary);


--
-- Name: company_document_files_company_document_id_language_position_in; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX company_document_files_company_document_id_language_position_in ON public.company_document_files USING btree (company_document_id, language, "position");


--
-- Name: company_documents_category_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX company_documents_category_index ON public.company_documents USING btree (category);


--
-- Name: company_documents_document_type_is_active_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX company_documents_document_type_is_active_index ON public.company_documents USING btree (document_type, is_active);


--
-- Name: company_documents_expires_at_is_active_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX company_documents_expires_at_is_active_index ON public.company_documents USING btree (expires_at, is_active);


--
-- Name: coupon_usages_coupon_id_customer_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX coupon_usages_coupon_id_customer_id_index ON public.coupon_usages USING btree (coupon_id, customer_id);


--
-- Name: coupon_usages_order_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX coupon_usages_order_id_index ON public.coupon_usages USING btree (order_id);


--
-- Name: coupons_active_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX coupons_active_index ON public.coupons USING btree (active);


--
-- Name: coupons_code_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX coupons_code_index ON public.coupons USING btree (code);


--
-- Name: coupons_customer_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX coupons_customer_id_index ON public.coupons USING btree (customer_id);


--
-- Name: coupons_starts_at_expires_at_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX coupons_starts_at_expires_at_index ON public.coupons USING btree (starts_at, expires_at);


--
-- Name: coupons_type_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX coupons_type_index ON public.coupons USING btree (type);


--
-- Name: customers_cashback_balance_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX customers_cashback_balance_index ON public.customers USING btree (cashback_balance);


--
-- Name: customers_sma_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX customers_sma_id_index ON public.customers USING btree (sma_id);


--
-- Name: customers_woocommerce_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX customers_woocommerce_id_index ON public.customers USING btree (woocommerce_id);


--
-- Name: idx_ai_memories_created; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX idx_ai_memories_created ON public.ai_memories USING btree (created_at);


--
-- Name: idx_ai_memories_message; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX idx_ai_memories_message ON public.ai_memories USING gin (message);


--
-- Name: idx_ai_memories_session; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX idx_ai_memories_session ON public.ai_memories USING btree (session_id);


--
-- Name: idx_ai_memories_type; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX idx_ai_memories_type ON public.ai_memories USING btree (message_type);


--
-- Name: idx_ai_memories_user; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX idx_ai_memories_user ON public.ai_memories USING btree (user_id);


--
-- Name: idx_one_default_per_product; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE UNIQUE INDEX idx_one_default_per_product ON public.product_variants USING btree (product_id) WHERE (is_default = true);


--
-- Name: idx_product_media_position; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX idx_product_media_position ON public.product_media USING btree (product_id, "position");


--
-- Name: idx_product_media_query; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX idx_product_media_query ON public.product_media USING btree (product_id, media_type, media_category);


--
-- Name: idx_verification_customer; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX idx_verification_customer ON public.verification_codes USING btree (customer_id);


--
-- Name: idx_verification_expiry; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX idx_verification_expiry ON public.verification_codes USING btree (expiry_at);


--
-- Name: idx_verification_mobile; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX idx_verification_mobile ON public.verification_codes USING btree (mobile);


--
-- Name: jobs_queue_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX jobs_queue_index ON public.jobs USING btree (queue);


--
-- Name: model_has_permissions_model_id_model_type_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX model_has_permissions_model_id_model_type_index ON public.model_has_permissions USING btree (model_id, model_type);


--
-- Name: model_has_roles_model_id_model_type_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX model_has_roles_model_id_model_type_index ON public.model_has_roles USING btree (model_id, model_type);


--
-- Name: notifications_notifiable_type_notifiable_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX notifications_notifiable_type_notifiable_id_index ON public.notifications USING btree (notifiable_type, notifiable_id);


--
-- Name: offers_slug_en_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX offers_slug_en_index ON public.offers USING btree (slug_en);


--
-- Name: offers_slug_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX offers_slug_index ON public.offers USING btree (slug);


--
-- Name: orders_coupon_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX orders_coupon_id_index ON public.orders USING btree (coupon_id);


--
-- Name: orders_payment_method_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX orders_payment_method_id_index ON public.orders USING btree (payment_method_id);


--
-- Name: orders_payment_status_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX orders_payment_status_index ON public.orders USING btree (payment_status);


--
-- Name: page_blocks_store_page_id_order_index_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX page_blocks_store_page_id_order_index_index ON public.page_blocks USING btree (store_page_id, order_index);


--
-- Name: payment_methods_active_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX payment_methods_active_index ON public.payment_methods USING btree (active);


--
-- Name: payment_methods_sort_order_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX payment_methods_sort_order_index ON public.payment_methods USING btree (sort_order);


--
-- Name: personal_access_tokens_tokenable_type_tokenable_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX personal_access_tokens_tokenable_type_tokenable_id_index ON public.personal_access_tokens USING btree (tokenable_type, tokenable_id);


--
-- Name: price_histories_created_at_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX price_histories_created_at_index ON public.price_histories USING btree (created_at);


--
-- Name: price_histories_product_variant_id_created_at_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX price_histories_product_variant_id_created_at_index ON public.price_histories USING btree (product_variant_id, created_at);


--
-- Name: price_histories_product_variant_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX price_histories_product_variant_id_index ON public.price_histories USING btree (product_variant_id);


--
-- Name: pricing_rule_usage_pricing_rule_id_customer_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX pricing_rule_usage_pricing_rule_id_customer_id_index ON public.pricing_rule_usage USING btree (pricing_rule_id, customer_id);


--
-- Name: pricing_rules_applies_to_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX pricing_rules_applies_to_index ON public.pricing_rules USING btree (applies_to);


--
-- Name: pricing_rules_is_active_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX pricing_rules_is_active_index ON public.pricing_rules USING btree (is_active);


--
-- Name: pricing_rules_priority_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX pricing_rules_priority_index ON public.pricing_rules USING btree (priority);


--
-- Name: pricing_rules_valid_from_valid_until_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX pricing_rules_valid_from_valid_until_index ON public.pricing_rules USING btree (valid_from, valid_until);


--
-- Name: product_media_is_active_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX product_media_is_active_index ON public.product_media USING btree (is_active);


--
-- Name: product_media_media_category_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX product_media_media_category_index ON public.product_media USING btree (media_category);


--
-- Name: product_media_media_type_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX product_media_media_type_index ON public.product_media USING btree (media_type);


--
-- Name: product_media_position_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX product_media_position_index ON public.product_media USING btree ("position");


--
-- Name: product_related_product_id_is_active_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX product_related_product_id_is_active_index ON public.product_related USING btree (product_id, is_active);


--
-- Name: product_related_relevance_score_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX product_related_relevance_score_index ON public.product_related USING btree (relevance_score);


--
-- Name: product_reviews_customer_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX product_reviews_customer_id_index ON public.product_reviews USING btree (customer_id);


--
-- Name: product_reviews_is_approved_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX product_reviews_is_approved_index ON public.product_reviews USING btree (is_approved);


--
-- Name: product_reviews_product_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX product_reviews_product_id_index ON public.product_reviews USING btree (product_id);


--
-- Name: products_slug_en_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX products_slug_en_index ON public.products USING btree (slug_en);


--
-- Name: products_slug_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX products_slug_index ON public.products USING btree (slug);


--
-- Name: products_sync_status_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX products_sync_status_index ON public.products USING btree (sync_status);


--
-- Name: products_woocommerce_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX products_woocommerce_id_index ON public.products USING btree (woocommerce_id);


--
-- Name: sma_pending_imports_email_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX sma_pending_imports_email_index ON public.sma_pending_imports USING btree (email);


--
-- Name: sma_pending_imports_mobile1_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX sma_pending_imports_mobile1_index ON public.sma_pending_imports USING btree (mobile1);


--
-- Name: sma_pending_imports_status_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX sma_pending_imports_status_index ON public.sma_pending_imports USING btree (status);


--
-- Name: social_logins_customer_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX social_logins_customer_id_index ON public.social_logins USING btree (customer_id);


--
-- Name: stock_movements_created_at_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX stock_movements_created_at_index ON public.stock_movements USING btree (created_at);


--
-- Name: stock_movements_movement_type_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX stock_movements_movement_type_index ON public.stock_movements USING btree (movement_type);


--
-- Name: stock_movements_offer_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX stock_movements_offer_id_index ON public.stock_movements USING btree (offer_id);


--
-- Name: stock_movements_order_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX stock_movements_order_id_index ON public.stock_movements USING btree (order_id);


--
-- Name: stock_movements_product_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX stock_movements_product_id_index ON public.stock_movements USING btree (product_id);


--
-- Name: store_banners_is_active_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX store_banners_is_active_index ON public.store_banners USING btree (is_active);


--
-- Name: store_banners_order_index_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX store_banners_order_index_index ON public.store_banners USING btree (order_index);


--
-- Name: store_banners_start_date_end_date_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX store_banners_start_date_end_date_index ON public.store_banners USING btree (start_date, end_date);


--
-- Name: store_pages_is_active_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX store_pages_is_active_index ON public.store_pages USING btree (is_active);


--
-- Name: store_pages_order_index_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX store_pages_order_index_index ON public.store_pages USING btree (order_index);


--
-- Name: store_settings_group_name_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX store_settings_group_name_index ON public.store_settings USING btree (group_name);


--
-- Name: store_testimonials_is_approved_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX store_testimonials_is_approved_index ON public.store_testimonials USING btree (is_approved);


--
-- Name: store_testimonials_is_featured_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX store_testimonials_is_featured_index ON public.store_testimonials USING btree (is_featured);


--
-- Name: store_testimonials_order_index_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX store_testimonials_order_index_index ON public.store_testimonials USING btree (order_index);


--
-- Name: store_themes_is_active_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX store_themes_is_active_index ON public.store_themes USING btree (is_active);


--
-- Name: store_themes_is_default_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX store_themes_is_default_index ON public.store_themes USING btree (is_default);


--
-- Name: store_translations_group_name_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX store_translations_group_name_index ON public.store_translations USING btree (group_name);


--
-- Name: variant_analytics_period_start_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX variant_analytics_period_start_index ON public.variant_analytics USING btree (period_start);


--
-- Name: variant_analytics_period_start_period_end_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX variant_analytics_period_start_period_end_index ON public.variant_analytics USING btree (period_start, period_end);


--
-- Name: variant_analytics_product_variant_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX variant_analytics_product_variant_id_index ON public.variant_analytics USING btree (product_variant_id);


--
-- Name: variant_associations_confidence_score_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX variant_associations_confidence_score_index ON public.variant_associations USING btree (confidence_score);


--
-- Name: wishlists_customer_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX wishlists_customer_id_index ON public.wishlists USING btree (customer_id);


--
-- Name: woocommerce_customer_import_logs_action_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX woocommerce_customer_import_logs_action_index ON public.woocommerce_customer_import_logs USING btree (action);


--
-- Name: woocommerce_customer_import_logs_created_at_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX woocommerce_customer_import_logs_created_at_index ON public.woocommerce_customer_import_logs USING btree (created_at);


--
-- Name: woocommerce_customer_import_logs_customer_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX woocommerce_customer_import_logs_customer_id_index ON public.woocommerce_customer_import_logs USING btree (customer_id);


--
-- Name: woocommerce_customer_import_logs_status_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX woocommerce_customer_import_logs_status_index ON public.woocommerce_customer_import_logs USING btree (status);


--
-- Name: woocommerce_customer_import_logs_woocommerce_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX woocommerce_customer_import_logs_woocommerce_id_index ON public.woocommerce_customer_import_logs USING btree (woocommerce_id);


--
-- Name: woocommerce_import_logs_action_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX woocommerce_import_logs_action_index ON public.woocommerce_import_logs USING btree (action);


--
-- Name: woocommerce_import_logs_batch_id_created_at_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX woocommerce_import_logs_batch_id_created_at_index ON public.woocommerce_import_logs USING btree (batch_id, created_at);


--
-- Name: woocommerce_import_logs_batch_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX woocommerce_import_logs_batch_id_index ON public.woocommerce_import_logs USING btree (batch_id);


--
-- Name: woocommerce_import_logs_log_level_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX woocommerce_import_logs_log_level_index ON public.woocommerce_import_logs USING btree (log_level);


--
-- Name: woocommerce_pending_attributes_status_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX woocommerce_pending_attributes_status_index ON public.woocommerce_pending_attributes USING btree (status);


--
-- Name: woocommerce_pending_customer_imports_email_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX woocommerce_pending_customer_imports_email_index ON public.woocommerce_pending_customer_imports USING btree (email);


--
-- Name: woocommerce_pending_customer_imports_status_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX woocommerce_pending_customer_imports_status_index ON public.woocommerce_pending_customer_imports USING btree (status);


--
-- Name: woocommerce_pending_customer_imports_woocommerce_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX woocommerce_pending_customer_imports_woocommerce_id_index ON public.woocommerce_pending_customer_imports USING btree (woocommerce_id);


--
-- Name: woocommerce_pending_imports_created_at_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX woocommerce_pending_imports_created_at_index ON public.woocommerce_pending_imports USING btree (created_at);


--
-- Name: woocommerce_pending_imports_status_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX woocommerce_pending_imports_status_index ON public.woocommerce_pending_imports USING btree (status);


--
-- Name: woocommerce_pending_imports_woocommerce_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX woocommerce_pending_imports_woocommerce_id_index ON public.woocommerce_pending_imports USING btree (woocommerce_id);


--
-- Name: woocommerce_variant_mappings_woocommerce_variation_id_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX woocommerce_variant_mappings_woocommerce_variation_id_index ON public.woocommerce_variant_mappings USING btree (woocommerce_variation_id);


--
-- Name: wordpress_sync_logs_action_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX wordpress_sync_logs_action_index ON public.wordpress_sync_logs USING btree (action);


--
-- Name: wordpress_sync_logs_created_at_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX wordpress_sync_logs_created_at_index ON public.wordpress_sync_logs USING btree (created_at);


--
-- Name: wordpress_sync_logs_status_index; Type: INDEX; Schema: public; Owner: TheRoasters_Auto
--

CREATE INDEX wordpress_sync_logs_status_index ON public.wordpress_sync_logs USING btree (status);


--
-- Name: orders trigger_update_customer_orders; Type: TRIGGER; Schema: public; Owner: TheRoasters_Auto
--

CREATE TRIGGER trigger_update_customer_orders AFTER INSERT OR UPDATE ON public.orders FOR EACH ROW EXECUTE FUNCTION public.update_customer_total_orders();


--
-- Name: abandoned_carts abandoned_carts_customer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.abandoned_carts
    ADD CONSTRAINT abandoned_carts_customer_id_foreign FOREIGN KEY (customer_id) REFERENCES public.customers(id) ON DELETE CASCADE;


--
-- Name: abandoned_carts abandoned_carts_recovery_order_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.abandoned_carts
    ADD CONSTRAINT abandoned_carts_recovery_order_id_foreign FOREIGN KEY (recovery_order_id) REFERENCES public.orders(id) ON DELETE SET NULL;


--
-- Name: ai_memories ai_memories_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.ai_memories
    ADD CONSTRAINT ai_memories_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE SET NULL;


--
-- Name: api_key_logs api_key_logs_api_key_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.api_key_logs
    ADD CONSTRAINT api_key_logs_api_key_id_foreign FOREIGN KEY (api_key_id) REFERENCES public.api_keys(id) ON DELETE SET NULL;


--
-- Name: api_keys api_keys_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.api_keys
    ADD CONSTRAINT api_keys_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE SET NULL;


--
-- Name: cart_sessions cart_sessions_customer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.cart_sessions
    ADD CONSTRAINT cart_sessions_customer_id_foreign FOREIGN KEY (customer_id) REFERENCES public.customers(id) ON DELETE CASCADE;


--
-- Name: cashback_transactions cashback_transactions_admin_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.cashback_transactions
    ADD CONSTRAINT cashback_transactions_admin_id_foreign FOREIGN KEY (admin_id) REFERENCES public.users(id) ON DELETE SET NULL;


--
-- Name: cashback_transactions cashback_transactions_coupon_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.cashback_transactions
    ADD CONSTRAINT cashback_transactions_coupon_id_foreign FOREIGN KEY (coupon_id) REFERENCES public.coupons(id) ON DELETE SET NULL;


--
-- Name: cashback_transactions cashback_transactions_customer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.cashback_transactions
    ADD CONSTRAINT cashback_transactions_customer_id_foreign FOREIGN KEY (customer_id) REFERENCES public.customers(id) ON DELETE CASCADE;


--
-- Name: cashback_transactions cashback_transactions_order_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.cashback_transactions
    ADD CONSTRAINT cashback_transactions_order_id_foreign FOREIGN KEY (order_id) REFERENCES public.orders(id) ON DELETE SET NULL;


--
-- Name: categories categories_parent_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.categories
    ADD CONSTRAINT categories_parent_id_foreign FOREIGN KEY (parent_id) REFERENCES public.categories(id) ON DELETE SET NULL;


--
-- Name: category_offer category_offer_category_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.category_offer
    ADD CONSTRAINT category_offer_category_id_foreign FOREIGN KEY (category_id) REFERENCES public.categories(id) ON DELETE CASCADE;


--
-- Name: category_offer category_offer_offer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.category_offer
    ADD CONSTRAINT category_offer_offer_id_foreign FOREIGN KEY (offer_id) REFERENCES public.offers(id) ON DELETE CASCADE;


--
-- Name: category_product category_product_category_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.category_product
    ADD CONSTRAINT category_product_category_id_foreign FOREIGN KEY (category_id) REFERENCES public.categories(id) ON DELETE CASCADE;


--
-- Name: category_product category_product_product_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.category_product
    ADD CONSTRAINT category_product_product_id_foreign FOREIGN KEY (product_id) REFERENCES public.products(id) ON DELETE CASCADE;


--
-- Name: cities cities_zone_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.cities
    ADD CONSTRAINT cities_zone_id_foreign FOREIGN KEY (zone_id) REFERENCES public.zones(id) ON DELETE CASCADE;


--
-- Name: company_document_files company_document_files_company_document_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.company_document_files
    ADD CONSTRAINT company_document_files_company_document_id_foreign FOREIGN KEY (company_document_id) REFERENCES public.company_documents(id) ON DELETE CASCADE;


--
-- Name: coupon_usages coupon_usages_coupon_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.coupon_usages
    ADD CONSTRAINT coupon_usages_coupon_id_foreign FOREIGN KEY (coupon_id) REFERENCES public.coupons(id) ON DELETE CASCADE;


--
-- Name: coupon_usages coupon_usages_customer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.coupon_usages
    ADD CONSTRAINT coupon_usages_customer_id_foreign FOREIGN KEY (customer_id) REFERENCES public.customers(id) ON DELETE CASCADE;


--
-- Name: coupon_usages coupon_usages_order_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.coupon_usages
    ADD CONSTRAINT coupon_usages_order_id_foreign FOREIGN KEY (order_id) REFERENCES public.orders(id) ON DELETE CASCADE;


--
-- Name: coupons coupons_customer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.coupons
    ADD CONSTRAINT coupons_customer_id_foreign FOREIGN KEY (customer_id) REFERENCES public.customers(id) ON DELETE SET NULL;


--
-- Name: exports exports_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: failed_import_rows failed_import_rows_import_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.failed_import_rows
    ADD CONSTRAINT failed_import_rows_import_id_foreign FOREIGN KEY (import_id) REFERENCES public.imports(id) ON DELETE CASCADE;


--
-- Name: imports imports_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

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


--
-- Name: model_has_permissions model_has_permissions_permission_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

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;


--
-- Name: model_has_roles model_has_roles_role_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

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;


--
-- Name: offer_conditions offer_conditions_attribute_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.offer_conditions
    ADD CONSTRAINT offer_conditions_attribute_id_foreign FOREIGN KEY (attribute_id) REFERENCES public.product_attributes(id) ON DELETE CASCADE;


--
-- Name: offer_conditions offer_conditions_offer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.offer_conditions
    ADD CONSTRAINT offer_conditions_offer_id_foreign FOREIGN KEY (offer_id) REFERENCES public.offers(id) ON DELETE CASCADE;


--
-- Name: offer_conditions offer_conditions_option_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.offer_conditions
    ADD CONSTRAINT offer_conditions_option_id_foreign FOREIGN KEY (option_id) REFERENCES public.product_attribute_options(id) ON DELETE CASCADE;


--
-- Name: offer_products offer_products_offer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.offer_products
    ADD CONSTRAINT offer_products_offer_id_foreign FOREIGN KEY (offer_id) REFERENCES public.offers(id) ON DELETE CASCADE;


--
-- Name: offer_products offer_products_product_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.offer_products
    ADD CONSTRAINT offer_products_product_id_foreign FOREIGN KEY (product_id) REFERENCES public.products(id) ON DELETE CASCADE;


--
-- Name: offer_products offer_products_variant_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.offer_products
    ADD CONSTRAINT offer_products_variant_id_foreign FOREIGN KEY (variant_id) REFERENCES public.product_variants(id) ON DELETE CASCADE;


--
-- Name: offers offers_category_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.offers
    ADD CONSTRAINT offers_category_id_foreign FOREIGN KEY (category_id) REFERENCES public.categories(id) ON DELETE SET NULL;


--
-- Name: order_items order_items_offer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.order_items
    ADD CONSTRAINT order_items_offer_id_foreign FOREIGN KEY (offer_id) REFERENCES public.offers(id) ON DELETE SET NULL;


--
-- Name: order_items order_items_order_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.order_items
    ADD CONSTRAINT order_items_order_id_foreign FOREIGN KEY (order_id) REFERENCES public.orders(id) ON DELETE CASCADE;


--
-- Name: order_items order_items_product_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.order_items
    ADD CONSTRAINT order_items_product_id_foreign FOREIGN KEY (product_id) REFERENCES public.products(id) ON DELETE SET NULL;


--
-- Name: order_items order_items_variant_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.order_items
    ADD CONSTRAINT order_items_variant_id_foreign FOREIGN KEY (variant_id) REFERENCES public.product_variants(id) ON DELETE SET NULL;


--
-- Name: orders orders_coupon_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.orders
    ADD CONSTRAINT orders_coupon_id_foreign FOREIGN KEY (coupon_id) REFERENCES public.coupons(id) ON DELETE SET NULL;


--
-- Name: orders orders_customer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.orders
    ADD CONSTRAINT orders_customer_id_foreign FOREIGN KEY (customer_id) REFERENCES public.customers(id) ON DELETE SET NULL;


--
-- Name: orders orders_payment_method_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.orders
    ADD CONSTRAINT orders_payment_method_id_foreign FOREIGN KEY (payment_method_id) REFERENCES public.payment_methods(id) ON DELETE SET NULL;


--
-- Name: orders orders_shipping_company_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.orders
    ADD CONSTRAINT orders_shipping_company_id_foreign FOREIGN KEY (shipping_company_id) REFERENCES public.shipping_companies(id) ON DELETE SET NULL;


--
-- Name: page_blocks page_blocks_store_page_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.page_blocks
    ADD CONSTRAINT page_blocks_store_page_id_foreign FOREIGN KEY (store_page_id) REFERENCES public.store_pages(id) ON DELETE CASCADE;


--
-- Name: price_histories price_histories_changed_by_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.price_histories
    ADD CONSTRAINT price_histories_changed_by_user_id_foreign FOREIGN KEY (changed_by_user_id) REFERENCES public.users(id) ON DELETE SET NULL;


--
-- Name: price_histories price_histories_product_variant_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.price_histories
    ADD CONSTRAINT price_histories_product_variant_id_foreign FOREIGN KEY (product_variant_id) REFERENCES public.product_variants(id) ON DELETE CASCADE;


--
-- Name: pricing_rule_usage pricing_rule_usage_customer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.pricing_rule_usage
    ADD CONSTRAINT pricing_rule_usage_customer_id_foreign FOREIGN KEY (customer_id) REFERENCES public.customers(id) ON DELETE CASCADE;


--
-- Name: pricing_rule_usage pricing_rule_usage_order_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.pricing_rule_usage
    ADD CONSTRAINT pricing_rule_usage_order_id_foreign FOREIGN KEY (order_id) REFERENCES public.orders(id) ON DELETE CASCADE;


--
-- Name: pricing_rule_usage pricing_rule_usage_pricing_rule_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.pricing_rule_usage
    ADD CONSTRAINT pricing_rule_usage_pricing_rule_id_foreign FOREIGN KEY (pricing_rule_id) REFERENCES public.pricing_rules(id) ON DELETE CASCADE;


--
-- Name: pricing_rules pricing_rules_created_by_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.pricing_rules
    ADD CONSTRAINT pricing_rules_created_by_user_id_foreign FOREIGN KEY (created_by_user_id) REFERENCES public.users(id) ON DELETE SET NULL;


--
-- Name: product_attribute_options product_attribute_options_attribute_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.product_attribute_options
    ADD CONSTRAINT product_attribute_options_attribute_id_foreign FOREIGN KEY (attribute_id) REFERENCES public.product_attributes(id) ON DELETE CASCADE;


--
-- Name: product_media product_media_product_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.product_media
    ADD CONSTRAINT product_media_product_id_foreign FOREIGN KEY (product_id) REFERENCES public.products(id) ON DELETE CASCADE;


--
-- Name: product_related product_related_product_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.product_related
    ADD CONSTRAINT product_related_product_id_foreign FOREIGN KEY (product_id) REFERENCES public.products(id) ON DELETE CASCADE;


--
-- Name: product_related product_related_related_product_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.product_related
    ADD CONSTRAINT product_related_related_product_id_foreign FOREIGN KEY (related_product_id) REFERENCES public.products(id) ON DELETE CASCADE;


--
-- Name: product_reviews product_reviews_customer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.product_reviews
    ADD CONSTRAINT product_reviews_customer_id_foreign FOREIGN KEY (customer_id) REFERENCES public.customers(id) ON DELETE CASCADE;


--
-- Name: product_reviews product_reviews_order_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.product_reviews
    ADD CONSTRAINT product_reviews_order_id_foreign FOREIGN KEY (order_id) REFERENCES public.orders(id) ON DELETE SET NULL;


--
-- Name: product_reviews product_reviews_product_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.product_reviews
    ADD CONSTRAINT product_reviews_product_id_foreign FOREIGN KEY (product_id) REFERENCES public.products(id) ON DELETE CASCADE;


--
-- Name: product_variant_attributes product_variant_attributes_attribute_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.product_variant_attributes
    ADD CONSTRAINT product_variant_attributes_attribute_id_foreign FOREIGN KEY (attribute_id) REFERENCES public.product_attributes(id) ON DELETE CASCADE;


--
-- Name: product_variant_attributes product_variant_attributes_option_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.product_variant_attributes
    ADD CONSTRAINT product_variant_attributes_option_id_foreign FOREIGN KEY (option_id) REFERENCES public.product_attribute_options(id) ON DELETE CASCADE;


--
-- Name: product_variant_attributes product_variant_attributes_variant_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.product_variant_attributes
    ADD CONSTRAINT product_variant_attributes_variant_id_foreign FOREIGN KEY (variant_id) REFERENCES public.product_variants(id) ON DELETE CASCADE;


--
-- Name: product_variants product_variants_product_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.product_variants
    ADD CONSTRAINT product_variants_product_id_foreign FOREIGN KEY (product_id) REFERENCES public.products(id) ON DELETE CASCADE;


--
-- Name: products products_category_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.products
    ADD CONSTRAINT products_category_id_foreign FOREIGN KEY (category_id) REFERENCES public.categories(id) ON DELETE SET NULL;


--
-- Name: role_has_permissions role_has_permissions_permission_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

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;


--
-- Name: role_has_permissions role_has_permissions_role_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

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;


--
-- Name: sma_pending_imports sma_pending_imports_suggested_city_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.sma_pending_imports
    ADD CONSTRAINT sma_pending_imports_suggested_city_id_foreign FOREIGN KEY (suggested_city_id) REFERENCES public.cities(id) ON DELETE SET NULL;


--
-- Name: social_logins social_logins_customer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.social_logins
    ADD CONSTRAINT social_logins_customer_id_foreign FOREIGN KEY (customer_id) REFERENCES public.customers(id) ON DELETE CASCADE;


--
-- Name: stock_movements stock_movements_created_by_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.stock_movements
    ADD CONSTRAINT stock_movements_created_by_foreign FOREIGN KEY (created_by) REFERENCES public.users(id) ON DELETE SET NULL;


--
-- Name: stock_movements stock_movements_offer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.stock_movements
    ADD CONSTRAINT stock_movements_offer_id_foreign FOREIGN KEY (offer_id) REFERENCES public.offers(id) ON DELETE CASCADE;


--
-- Name: stock_movements stock_movements_order_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.stock_movements
    ADD CONSTRAINT stock_movements_order_id_foreign FOREIGN KEY (order_id) REFERENCES public.orders(id) ON DELETE SET NULL;


--
-- Name: stock_movements stock_movements_product_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.stock_movements
    ADD CONSTRAINT stock_movements_product_id_foreign FOREIGN KEY (product_id) REFERENCES public.products(id) ON DELETE CASCADE;


--
-- Name: stock_movements stock_movements_variant_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.stock_movements
    ADD CONSTRAINT stock_movements_variant_id_foreign FOREIGN KEY (variant_id) REFERENCES public.product_variants(id) ON DELETE CASCADE;


--
-- Name: store_navigations store_navigations_parent_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.store_navigations
    ADD CONSTRAINT store_navigations_parent_id_foreign FOREIGN KEY (parent_id) REFERENCES public.store_navigations(id) ON DELETE CASCADE;


--
-- Name: variant_analytics variant_analytics_product_variant_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.variant_analytics
    ADD CONSTRAINT variant_analytics_product_variant_id_foreign FOREIGN KEY (product_variant_id) REFERENCES public.product_variants(id) ON DELETE CASCADE;


--
-- Name: variant_associations variant_associations_variant_a_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.variant_associations
    ADD CONSTRAINT variant_associations_variant_a_id_foreign FOREIGN KEY (variant_a_id) REFERENCES public.product_variants(id) ON DELETE CASCADE;


--
-- Name: variant_associations variant_associations_variant_b_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.variant_associations
    ADD CONSTRAINT variant_associations_variant_b_id_foreign FOREIGN KEY (variant_b_id) REFERENCES public.product_variants(id) ON DELETE CASCADE;


--
-- Name: wishlists wishlists_customer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.wishlists
    ADD CONSTRAINT wishlists_customer_id_foreign FOREIGN KEY (customer_id) REFERENCES public.customers(id) ON DELETE CASCADE;


--
-- Name: wishlists wishlists_product_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.wishlists
    ADD CONSTRAINT wishlists_product_id_foreign FOREIGN KEY (product_id) REFERENCES public.products(id) ON DELETE CASCADE;


--
-- Name: wishlists wishlists_variant_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.wishlists
    ADD CONSTRAINT wishlists_variant_id_foreign FOREIGN KEY (variant_id) REFERENCES public.product_variants(id) ON DELETE CASCADE;


--
-- Name: woocommerce_attribute_mappings woocommerce_attribute_mappings_local_attribute_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.woocommerce_attribute_mappings
    ADD CONSTRAINT woocommerce_attribute_mappings_local_attribute_id_foreign FOREIGN KEY (local_attribute_id) REFERENCES public.product_attributes(id) ON DELETE CASCADE;


--
-- Name: woocommerce_customer_import_logs woocommerce_customer_import_logs_customer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.woocommerce_customer_import_logs
    ADD CONSTRAINT woocommerce_customer_import_logs_customer_id_foreign FOREIGN KEY (customer_id) REFERENCES public.customers(id) ON DELETE CASCADE;


--
-- Name: woocommerce_option_mappings woocommerce_option_mappings_attribute_mapping_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.woocommerce_option_mappings
    ADD CONSTRAINT woocommerce_option_mappings_attribute_mapping_id_foreign FOREIGN KEY (attribute_mapping_id) REFERENCES public.woocommerce_attribute_mappings(id) ON DELETE CASCADE;


--
-- Name: woocommerce_option_mappings woocommerce_option_mappings_local_option_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.woocommerce_option_mappings
    ADD CONSTRAINT woocommerce_option_mappings_local_option_id_foreign FOREIGN KEY (local_option_id) REFERENCES public.product_attribute_options(id) ON DELETE CASCADE;


--
-- Name: woocommerce_pending_attributes woocommerce_pending_attributes_mapped_attribute_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.woocommerce_pending_attributes
    ADD CONSTRAINT woocommerce_pending_attributes_mapped_attribute_id_foreign FOREIGN KEY (mapped_attribute_id) REFERENCES public.product_attributes(id) ON DELETE SET NULL;


--
-- Name: woocommerce_pending_attributes woocommerce_pending_attributes_pending_import_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.woocommerce_pending_attributes
    ADD CONSTRAINT woocommerce_pending_attributes_pending_import_id_foreign FOREIGN KEY (pending_import_id) REFERENCES public.woocommerce_pending_imports(id) ON DELETE CASCADE;


--
-- Name: woocommerce_pending_customer_imports woocommerce_pending_customer_imports_city_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.woocommerce_pending_customer_imports
    ADD CONSTRAINT woocommerce_pending_customer_imports_city_id_foreign FOREIGN KEY (city_id) REFERENCES public.cities(id) ON DELETE SET NULL;


--
-- Name: woocommerce_pending_customer_imports woocommerce_pending_customer_imports_imported_by_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.woocommerce_pending_customer_imports
    ADD CONSTRAINT woocommerce_pending_customer_imports_imported_by_foreign FOREIGN KEY (imported_by) REFERENCES public.users(id) ON DELETE SET NULL;


--
-- Name: woocommerce_pending_imports woocommerce_pending_imports_reviewed_by_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.woocommerce_pending_imports
    ADD CONSTRAINT woocommerce_pending_imports_reviewed_by_foreign FOREIGN KEY (reviewed_by) REFERENCES public.users(id) ON DELETE SET NULL;


--
-- Name: woocommerce_pending_options woocommerce_pending_options_mapped_option_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.woocommerce_pending_options
    ADD CONSTRAINT woocommerce_pending_options_mapped_option_id_foreign FOREIGN KEY (mapped_option_id) REFERENCES public.product_attribute_options(id) ON DELETE SET NULL;


--
-- Name: woocommerce_pending_options woocommerce_pending_options_pending_attribute_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.woocommerce_pending_options
    ADD CONSTRAINT woocommerce_pending_options_pending_attribute_id_foreign FOREIGN KEY (pending_attribute_id) REFERENCES public.woocommerce_pending_attributes(id) ON DELETE CASCADE;


--
-- Name: woocommerce_variant_mappings woocommerce_variant_mappings_local_variant_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.woocommerce_variant_mappings
    ADD CONSTRAINT woocommerce_variant_mappings_local_variant_id_foreign FOREIGN KEY (local_variant_id) REFERENCES public.product_variants(id) ON DELETE CASCADE;


--
-- Name: wordpress_sync_logs wordpress_sync_logs_product_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: TheRoasters_Auto
--

ALTER TABLE ONLY public.wordpress_sync_logs
    ADD CONSTRAINT wordpress_sync_logs_product_id_foreign FOREIGN KEY (product_id) REFERENCES public.products(id) ON DELETE CASCADE;


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

GRANT ALL ON SCHEMA public TO "TheRoasters_Auto";


--
-- Name: FUNCTION gtrgm_in(cstring); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.gtrgm_in(cstring) TO "TheRoasters_Auto";


--
-- Name: FUNCTION gtrgm_out(public.gtrgm); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.gtrgm_out(public.gtrgm) TO "TheRoasters_Auto";


--
-- Name: FUNCTION generate_order_number(); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.generate_order_number() TO "TheRoasters_Auto";


--
-- Name: FUNCTION gin_extract_query_trgm(text, internal, smallint, internal, internal, internal, internal); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.gin_extract_query_trgm(text, internal, smallint, internal, internal, internal, internal) TO "TheRoasters_Auto";


--
-- Name: FUNCTION gin_extract_value_trgm(text, internal); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.gin_extract_value_trgm(text, internal) TO "TheRoasters_Auto";


--
-- Name: FUNCTION gin_trgm_consistent(internal, smallint, text, integer, internal, internal, internal, internal); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.gin_trgm_consistent(internal, smallint, text, integer, internal, internal, internal, internal) TO "TheRoasters_Auto";


--
-- Name: FUNCTION gin_trgm_triconsistent(internal, smallint, text, integer, internal, internal, internal); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.gin_trgm_triconsistent(internal, smallint, text, integer, internal, internal, internal) TO "TheRoasters_Auto";


--
-- Name: FUNCTION gtrgm_compress(internal); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.gtrgm_compress(internal) TO "TheRoasters_Auto";


--
-- Name: FUNCTION gtrgm_consistent(internal, text, smallint, oid, internal); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.gtrgm_consistent(internal, text, smallint, oid, internal) TO "TheRoasters_Auto";


--
-- Name: FUNCTION gtrgm_decompress(internal); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.gtrgm_decompress(internal) TO "TheRoasters_Auto";


--
-- Name: FUNCTION gtrgm_distance(internal, text, smallint, oid, internal); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.gtrgm_distance(internal, text, smallint, oid, internal) TO "TheRoasters_Auto";


--
-- Name: FUNCTION gtrgm_options(internal); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.gtrgm_options(internal) TO "TheRoasters_Auto";


--
-- Name: FUNCTION gtrgm_penalty(internal, internal, internal); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.gtrgm_penalty(internal, internal, internal) TO "TheRoasters_Auto";


--
-- Name: FUNCTION gtrgm_picksplit(internal, internal); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.gtrgm_picksplit(internal, internal) TO "TheRoasters_Auto";


--
-- Name: FUNCTION gtrgm_same(public.gtrgm, public.gtrgm, internal); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.gtrgm_same(public.gtrgm, public.gtrgm, internal) TO "TheRoasters_Auto";


--
-- Name: FUNCTION gtrgm_union(internal, internal); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.gtrgm_union(internal, internal) TO "TheRoasters_Auto";


--
-- Name: FUNCTION set_limit(real); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.set_limit(real) TO "TheRoasters_Auto";


--
-- Name: FUNCTION set_order_number(); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.set_order_number() TO "TheRoasters_Auto";


--
-- Name: FUNCTION show_limit(); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.show_limit() TO "TheRoasters_Auto";


--
-- Name: FUNCTION show_trgm(text); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.show_trgm(text) TO "TheRoasters_Auto";


--
-- Name: FUNCTION similarity(text, text); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.similarity(text, text) TO "TheRoasters_Auto";


--
-- Name: FUNCTION similarity_dist(text, text); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.similarity_dist(text, text) TO "TheRoasters_Auto";


--
-- Name: FUNCTION similarity_op(text, text); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.similarity_op(text, text) TO "TheRoasters_Auto";


--
-- Name: FUNCTION strict_word_similarity(text, text); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.strict_word_similarity(text, text) TO "TheRoasters_Auto";


--
-- Name: FUNCTION strict_word_similarity_commutator_op(text, text); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.strict_word_similarity_commutator_op(text, text) TO "TheRoasters_Auto";


--
-- Name: FUNCTION strict_word_similarity_dist_commutator_op(text, text); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.strict_word_similarity_dist_commutator_op(text, text) TO "TheRoasters_Auto";


--
-- Name: FUNCTION strict_word_similarity_dist_op(text, text); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.strict_word_similarity_dist_op(text, text) TO "TheRoasters_Auto";


--
-- Name: FUNCTION strict_word_similarity_op(text, text); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.strict_word_similarity_op(text, text) TO "TheRoasters_Auto";


--
-- Name: FUNCTION unaccent(text); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.unaccent(text) TO "TheRoasters_Auto";


--
-- Name: FUNCTION unaccent(regdictionary, text); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.unaccent(regdictionary, text) TO "TheRoasters_Auto";


--
-- Name: FUNCTION unaccent_init(internal); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.unaccent_init(internal) TO "TheRoasters_Auto";


--
-- Name: FUNCTION unaccent_lexize(internal, internal, internal, internal); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.unaccent_lexize(internal, internal, internal, internal) TO "TheRoasters_Auto";


--
-- Name: FUNCTION update_customer_orders_count(); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.update_customer_orders_count() TO "TheRoasters_Auto";


--
-- Name: FUNCTION update_offers_updated_at(); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.update_offers_updated_at() TO "TheRoasters_Auto";


--
-- Name: FUNCTION word_similarity(text, text); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.word_similarity(text, text) TO "TheRoasters_Auto";


--
-- Name: FUNCTION word_similarity_commutator_op(text, text); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.word_similarity_commutator_op(text, text) TO "TheRoasters_Auto";


--
-- Name: FUNCTION word_similarity_dist_commutator_op(text, text); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.word_similarity_dist_commutator_op(text, text) TO "TheRoasters_Auto";


--
-- Name: FUNCTION word_similarity_dist_op(text, text); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.word_similarity_dist_op(text, text) TO "TheRoasters_Auto";


--
-- Name: FUNCTION word_similarity_op(text, text); Type: ACL; Schema: public; Owner: n8n_user
--

GRANT ALL ON FUNCTION public.word_similarity_op(text, text) TO "TheRoasters_Auto";


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

ALTER DEFAULT PRIVILEGES FOR ROLE n8n_user IN SCHEMA public GRANT ALL ON SEQUENCES TO "TheRoasters_Auto";


--
-- Name: DEFAULT PRIVILEGES FOR FUNCTIONS; Type: DEFAULT ACL; Schema: public; Owner: n8n_user
--

ALTER DEFAULT PRIVILEGES FOR ROLE n8n_user IN SCHEMA public GRANT ALL ON FUNCTIONS TO "TheRoasters_Auto";


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

ALTER DEFAULT PRIVILEGES FOR ROLE n8n_user IN SCHEMA public GRANT ALL ON TABLES TO "TheRoasters_Auto";


--
--

\unrestrict Kph4LxjClXdrKaqb2aLHeBjuKjjJ5oyMtbDxGPNpHftm4Xd9uTxSGiHvNNtLKRD

