Update DB dumpHEADmaster

Should probably have been done in 6412f46.

1 files changed, 30 insertions, 17 deletions

diff --git a/db/dump.sql b/db/dump.sql
index 9486eb6..f5747b5 100644
--- a/db/dump.sql
+++ b/db/dump.sql
@@ -36,24 +36,15 @@ COMMENT ON EXTENSION pgcrypto IS 'cryptographic functions';
 --
 
 CREATE TYPE public.assignment_state AS ENUM (
-    'AWAITING_GARDENER_NOTIFICATION',
     'AWAITING_FINISH',
     'AWAITING_WATERMARKING',
-    'AWAITING_OWNER_NOTIFICATION',
-    'DONE'
+    'AWAITING_DONE'
 );
 
 
 ALTER TYPE public.assignment_state OWNER TO postgres;
 
 --
--- Name: TYPE assignment_state; Type: COMMENT; Schema: public; Owner: postgres
---
-
-COMMENT ON TYPE public.assignment_state IS 'The states for an assignment.';
-
-
---
 -- Name: role; Type: TYPE; Schema: public; Owner: postgres
 --
 
@@ -85,7 +76,7 @@ CREATE TABLE public.assignments (
     gardener_id integer NOT NULL,
     cemetary_plot_id integer NOT NULL,
     date date,
-    state public.assignment_state DEFAULT 'AWAITING_GARDENER_NOTIFICATION'::public.assignment_state NOT NULL,
+    state public.assignment_state NOT NULL,
     note text
 );
 
@@ -156,7 +147,8 @@ CREATE TABLE public.images (
     id integer NOT NULL,
     s3_path text NOT NULL,
     original_filename text NOT NULL,
-    assignment_id integer
+    assignment_id integer,
+    is_watermarked boolean DEFAULT false NOT NULL
 );
 
 
@@ -170,6 +162,13 @@ COMMENT ON TABLE public.images IS 'This table stores the images uploaded when fi
 
 
 --
+-- Name: COLUMN images.s3_path; Type: COMMENT; Schema: public; Owner: postgres
+--
+
+COMMENT ON COLUMN public.images.s3_path IS 'Actually the key';
+
+
+--
 -- Name: COLUMN images.assignment_id; Type: COMMENT; Schema: public; Owner: postgres
 --
 
@@ -177,6 +176,13 @@ COMMENT ON COLUMN public.images.assignment_id IS 'Reference to the owning assign
 
 
 --
+-- Name: COLUMN images.is_watermarked; Type: COMMENT; Schema: public; Owner: postgres
+--
+
+COMMENT ON COLUMN public.images.is_watermarked IS 'Whether the watermarking service has already processed this image';
+
+
+--
 -- Name: images_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
 --
 
@@ -245,8 +251,8 @@ ALTER TABLE public.users ALTER COLUMN id ADD GENERATED ALWAYS AS IDENTITY (
 --
 
 COPY public.assignments (id, gardener_id, cemetary_plot_id, date, state, note) FROM stdin;
-2	1	2	2025-03-05	AWAITING_GARDENER_NOTIFICATION	\N
-1	1	1	2025-02-28	AWAITING_WATERMARKING	\N
+2	1	2	2025-03-05	AWAITING_FINISH	\N
+1	1	1	2025-02-28	AWAITING_DONE	\N
 \.
 
 
@@ -264,8 +270,12 @@ COPY public.cemetary_plots (id, address, owner_id, assignment_interval) FROM std
 -- Data for Name: images; Type: TABLE DATA; Schema: public; Owner: postgres
 --
 
-COPY public.images (id, s3_path, original_filename, assignment_id) FROM stdin;
-3	fe5e7c27-99c4-4d4b-ba77-fcad5c6607e3	eva.jpeg	1
+COPY public.images (id, s3_path, original_filename, assignment_id, is_watermarked) FROM stdin;
+4	6891d2b7-e70f-40b4-9b00-91f0a7328dcb	arches.jpg	1	t
+3	fe5e7c27-99c4-4d4b-ba77-fcad5c6607e3	eva.jpeg	1	t
+5	1f10dc53-3652-45fd-9733-3956cef83c1e	en-såret-dansk-soldat.jpg	1	t
+6	f4778e62-0550-40c3-8f6e-22d111cea70e	Millstones-in-the-Woods-at Froggatt-Edge.jpg	1	t
+39	70d92ac7-524d-44f9-9121-9c06d5428a78	arches.jpg	1	f
 \.
 
 
@@ -279,6 +289,9 @@ je2bic5i5jou7woob4ehreoqojuir4co	1	2025-03-19 18:04:35.904+01
 bjt7wgbfrlzrg7fhphsxezpc7fornezv	1	2025-03-19 20:42:57.838+01
 bgrgdtxmiq44ig6dh32pop4wkterqj6r	1	2025-03-20 18:03:54.199+01
 q6ifvlkjdoncw5usnb37da3sf4y3fxyq	1	2025-03-20 20:01:53.318+01
+qjageurk7tusvue5kynu3vqq6xp2w5it	1	2025-03-23 18:35:48.664+01
+rxoatcbnzd2oxo6qbde7h7rdfseoae4y	1	2025-03-23 20:42:10.171+01
+wzds5djedjthteony4f22zrx5ar44yr3	1	2025-03-24 06:44:08.458+01
 \.
 
 
@@ -314,7 +327,7 @@ SELECT pg_catalog.setval('public.cementary_plots_id_seq', 2, true);
 -- Name: images_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
 --
 
-SELECT pg_catalog.setval('public.images_id_seq', 3, true);
+SELECT pg_catalog.setval('public.images_id_seq', 39, true);
 
 
 --