commit b22242ec7f2f8154312f3df3a258caa36f7f3aea
parent 577dceb262fb6107ee0e49cf45dec5870266d26b
Author: Christian Grothoff <christian@grothoff.org>
Date: Sun, 16 Nov 2025 19:15:30 +0100
extensions must be public
Diffstat:
2 files changed, 7 insertions(+), 2 deletions(-)
diff --git a/src/backenddb/merchant-0025.sql b/src/backenddb/merchant-0025.sql
@@ -24,11 +24,14 @@ BEGIN;
-- Check patch versioning is in place.
SELECT _v.register_patch('merchant-0025', NULL, NULL);
-SET search_path TO merchant;
+SET search_path TO public;
-- We will need this for LIKE-style pattern matching "gin" indices.
CREATE EXTENSION IF NOT EXISTS pg_trgm;
+SET search_path TO merchant;
+
+
-- See enum GNUNET_TIME_RounderInterval
CREATE TYPE time_rounder_interval
AS ENUM ('NONE', 'SECOND', 'MINUTE', 'HOUR', 'DAY', 'WEEK', 'MONTH', 'QUARTER', 'YEAR');
diff --git a/src/backenddb/merchant-0026.sql b/src/backenddb/merchant-0026.sql
@@ -24,10 +24,12 @@ BEGIN;
-- Check patch versioning is in place.
SELECT _v.register_patch('merchant-0026', NULL, NULL);
-SET search_path TO merchant;
+SET search_path TO public;
CREATE EXTENSION IF NOT EXISTS pgcrypto;
+SET search_path TO merchant;
+
ALTER TABLE merchant_inventory
ADD COLUMN image_hash TEXT;