diff options
| -rw-r--r-- | db/dump.sql | 47 |
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); -- |