1 files changed, 19 insertions, 0 deletions
diff --git a/lib/api-config/src/schema/delete_schema.rs b/lib/api-config/src/schema/delete_schema.rs
new file mode 100644
index 0000000..86e71d5
--- /dev/null
+++ b/lib/api-config/src/schema/delete_schema.rs
@@ -0,0 +1,19 @@
+use tracing::debug;
+
+use crate::{ConfigurationError, schema::SchemaService};
+
+pub(super) async fn delete_schema(
+    state: &SchemaService,
+    kind: &str,
+    version: &str,
+) -> Result<(), ConfigurationError> {
+    debug!("deleting transaction schema");
+    sqlx::query!(
+        "delete from transaction_schema where schema_type = $1 and schema_version = $2",
+        kind,
+        version,
+    )
+    .execute(&state.database)
+    .await?;
+    Ok(())
+}