feat(config): typologies

1 files changed, 11 insertions, 0 deletions

diff --git a/crates/configuration/migrations/20250816073400_typology.sql b/crates/configuration/migrations/20250816073400_typology.sql
new file mode 100644
index 0000000..85f8b14
--- /dev/null
+++ b/crates/configuration/migrations/20250816073400_typology.sql
@@ -0,0 +1,11 @@
+create table typology (
+    uuid uuid primary key,
+    configuration jsonb not null,
+    id text generated always as (
+        configuration->>'id'
+    ) stored,
+    version text generated always as (
+        configuration->>'version'
+    ) stored,
+    unique (id, version)
+);