chore: update schema.sql

soedirgo · soedirgo · commit a59adeddc588 · 2022-12-15T17:54:20.000+08:00
diff --git a/migrations/schema.sql b/migrations/schema.sql
@@ -510,25 +510,6 @@ END;
 $$;
 
 
---
--- Name: key_encrypt_secret(); Type: FUNCTION; Schema: pgsodium; Owner: -
---
-
-CREATE FUNCTION pgsodium.key_encrypt_secret() RETURNS trigger
-    LANGUAGE plpgsql
-    AS $$
-    BEGIN
-            new.raw_key = CASE WHEN new.raw_key IS NULL THEN NULL ELSE
-                CASE WHEN new.parent_key IS NULL THEN NULL ELSE
-                        pgsodium.crypto_aead_det_encrypt(new.raw_key::bytea, pg_catalog.convert_to((new.id::text || new.associated_data::text)::text, 'utf8'),
-                new.parent_key::uuid,
-                new.raw_key_nonce
-              ) END END;
-    RETURN new;
-    END;
-    $$;
-
-
 --
 -- Name: extension(text); Type: FUNCTION; Schema: storage; Owner: -
 --
@@ -754,35 +735,6 @@ CREATE TABLE auth.users (
 COMMENT ON TABLE auth.users IS 'Auth: Stores user login data within a secure schema.';
 
 
---
--- Name: decrypted_key; Type: VIEW; Schema: pgsodium; Owner: -
---
-
-CREATE VIEW pgsodium.decrypted_key AS
- SELECT key.id,
-    key.status,
-    key.created,
-    key.expires,
-    key.key_type,
-    key.key_id,
-    key.key_context,
-    key.name,
-    key.associated_data,
-    key.raw_key,
-        CASE
-            WHEN (key.raw_key IS NULL) THEN NULL::bytea
-            ELSE
-            CASE
-                WHEN (key.parent_key IS NULL) THEN NULL::bytea
-                ELSE pgsodium.crypto_aead_det_decrypt(key.raw_key, convert_to(((key.id)::text || key.associated_data), 'utf8'::name), key.parent_key, key.raw_key_nonce)
-            END
-        END AS decrypted_raw_key,
-    key.raw_key_nonce,
-    key.parent_key,
-    key.comment
-   FROM pgsodium.key;
-
-
 --
 -- Name: schema_migrations; Type: TABLE; Schema: public; Owner: -
 --
