boundary rework plugin/host_plugin sql and accompanying domain

rework plugin/host_plugin sql and accompanying domain

Open kheina opened this issue 2 years ago • 3 comments

trafficstars

reworks the database structure for plugins to no longer use individual tables for each type of plugin and instead uses a single table plugin for all plugins and helper tables plugin_<type>_supported to flag a specific plugin as supported those functions.

added necessary fields from plugin_host to plugin
migrated all entries from plugin_host to plugin
created plugin_host_supported
flagged all existing plugins as supporting host
removed plugin_host
updated all existing code references and tests to plugin_host to use new plugin and plugin_host_supported tables and proto definitions

Mar 30 '23 16:03 kheina

Database schema diff between main and dmiu_plugin-restructure @ 85360ebb3b8c7a19e95e50045a0fc11c43a76825

To understand how these diffs are generated and some limitations see the documentation of the script.

Functions

Unchanged

Tables

diff --git a/.schema-diff/tables_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin.sql b/.schema-diff/tables_7673502f2d23996536fa55869ba2d7a00f41bf9e/plugin.sql
index bd529c796..92e74bab5 100644
--- a/.schema-diff/tables_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin.sql
+++ b/.schema-diff/tables_7673502f2d23996536fa55869ba2d7a00f41bf9e/plugin.sql
@@ -27,7 +27,11 @@ set default_table_access_method = heap;
 create table public.plugin (
     public_id public.wt_plugin_id not null,
     name public.wt_name,
-    scope_id public.wt_scope_id not null
+    scope_id public.wt_scope_id not null,
+    description text,
+    create_time public.wt_timestamp,
+    update_time public.wt_timestamp,
+    version public.wt_version
 );
 
 
diff --git a/.schema-diff/tables_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host.sql b/.schema-diff/tables_7673502f2d23996536fa55869ba2d7a00f41bf9e/plugin_host_supported.sql
similarity index 64%
rename from .schema-diff/tables_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host.sql
rename to .schema-diff/tables_7673502f2d23996536fa55869ba2d7a00f41bf9e/plugin_host_supported.sql
index a7117768e..d8e3b440b 100644
--- a/.schema-diff/tables_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host.sql
+++ b/.schema-diff/tables_7673502f2d23996536fa55869ba2d7a00f41bf9e/plugin_host_supported.sql
@@ -21,17 +21,11 @@ set default_tablespace = '';
 set default_table_access_method = heap;
 
 --
--- name: plugin_host; type: table; schema: public; owner: -
+-- name: plugin_host_supported; type: table; schema: public; owner: -
 --
 
-create table public.plugin_host (
-    public_id public.wt_plugin_id not null,
-    scope_id public.wt_scope_id not null,
-    name public.wt_name,
-    description text,
-    create_time public.wt_timestamp,
-    update_time public.wt_timestamp,
-    version public.wt_version
+create table public.plugin_host_supported (
+    public_id public.wt_plugin_id not null
 );
 
 
diff --git a/.schema-diff/tables_743bbf88ac43f9b58e99e021bfa57d66d282aabc/public plugin_host.sql b/.schema-diff/tables_7673502f2d23996536fa55869ba2d7a00f41bf9e/public plugin_host_supported.sql
similarity index 100%
rename from .schema-diff/tables_743bbf88ac43f9b58e99e021bfa57d66d282aabc/public plugin_host.sql
rename to .schema-diff/tables_7673502f2d23996536fa55869ba2d7a00f41bf9e/public plugin_host_supported.sql

Views

Unchanged

Triggers

diff --git a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host default_create_time_column.sql b/.schema-diff/triggers_7673502f2d23996536fa55869ba2d7a00f41bf9e/plugin default_create_time_column.sql
similarity index 78%
rename from .schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host default_create_time_column.sql
rename to .schema-diff/triggers_7673502f2d23996536fa55869ba2d7a00f41bf9e/plugin default_create_time_column.sql
index 31ec8e4fd..8503cdb1a 100644
--- a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host default_create_time_column.sql	
+++ b/.schema-diff/triggers_7673502f2d23996536fa55869ba2d7a00f41bf9e/plugin default_create_time_column.sql	
@@ -17,10 +17,10 @@ set client_min_messages = warning;
 set row_security = off;
 
 --
--- name: plugin_host default_create_time_column; type: trigger; schema: public; owner: -
+-- name: plugin default_create_time_column; type: trigger; schema: public; owner: -
 --
 
-create trigger default_create_time_column before insert on public.plugin_host for each row execute function public.default_create_time();
+create trigger default_create_time_column before insert on public.plugin for each row execute function public.default_create_time();
 
 
 --
diff --git a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin immutable_columns.sql b/.schema-diff/triggers_7673502f2d23996536fa55869ba2d7a00f41bf9e/plugin immutable_columns.sql
index 389c30405..2d2de7ef0 100644
--- a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin immutable_columns.sql	
+++ b/.schema-diff/triggers_7673502f2d23996536fa55869ba2d7a00f41bf9e/plugin immutable_columns.sql	
@@ -20,7 +20,7 @@ set row_security = off;
 -- name: plugin immutable_columns; type: trigger; schema: public; owner: -
 --
 
-create trigger immutable_columns before update on public.plugin for each row execute function public.immutable_columns('public_id');
+create trigger immutable_columns before update on public.plugin for each row execute function public.immutable_columns('public_id', 'create_time');
 
 
 --
diff --git a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host update_time_column.sql b/.schema-diff/triggers_7673502f2d23996536fa55869ba2d7a00f41bf9e/plugin update_time_column.sql
similarity index 80%
rename from .schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host update_time_column.sql
rename to .schema-diff/triggers_7673502f2d23996536fa55869ba2d7a00f41bf9e/plugin update_time_column.sql
index b2bd529ed..3a1a2d3db 100644
--- a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host update_time_column.sql	
+++ b/.schema-diff/triggers_7673502f2d23996536fa55869ba2d7a00f41bf9e/plugin update_time_column.sql	
@@ -17,10 +17,10 @@ set client_min_messages = warning;
 set row_security = off;
 
 --
--- name: plugin_host update_time_column; type: trigger; schema: public; owner: -
+-- name: plugin update_time_column; type: trigger; schema: public; owner: -
 --
 
-create trigger update_time_column before update on public.plugin_host for each row execute function public.update_time_column();
+create trigger update_time_column before update on public.plugin for each row execute function public.update_time_column();
 
 
 --
diff --git a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host update_version_column.sql b/.schema-diff/triggers_7673502f2d23996536fa55869ba2d7a00f41bf9e/plugin update_version_column.sql
similarity index 79%
rename from .schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host update_version_column.sql
rename to .schema-diff/triggers_7673502f2d23996536fa55869ba2d7a00f41bf9e/plugin update_version_column.sql
index 1fc1fb4ce..84b92564e 100644
--- a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host update_version_column.sql	
+++ b/.schema-diff/triggers_7673502f2d23996536fa55869ba2d7a00f41bf9e/plugin update_version_column.sql	
@@ -17,10 +17,10 @@ set client_min_messages = warning;
 set row_security = off;
 
 --
--- name: plugin_host update_version_column; type: trigger; schema: public; owner: -
+-- name: plugin update_version_column; type: trigger; schema: public; owner: -
 --
 
-create trigger update_version_column after update on public.plugin_host for each row execute function public.update_version_column();
+create trigger update_version_column after update on public.plugin for each row execute function public.update_version_column();
 
 
 --
diff --git a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host delete_plugin_subtype.sql b/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host delete_plugin_subtype.sql
deleted file mode 100644
index 0cf7afbf7..000000000
--- a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host delete_plugin_subtype.sql	
+++ /dev/null
@@ -1,29 +0,0 @@
---
--- postgresql database dump
---
-
--- dumped from database version 13.10
--- dumped by pg_dump version 14.7 (ubuntu 14.7-1.pgdg22.04+1)
-
-set statement_timeout = 0;
-set lock_timeout = 0;
-set idle_in_transaction_session_timeout = 0;
-set client_encoding = 'utf8';
-set standard_conforming_strings = on;
-select pg_catalog.set_config('search_path', '', false);
-set check_function_bodies = false;
-set xmloption = content;
-set client_min_messages = warning;
-set row_security = off;
-
---
--- name: plugin_host delete_plugin_subtype; type: trigger; schema: public; owner: -
---
-
-create trigger delete_plugin_subtype after delete on public.plugin_host for each row execute function public.delete_plugin_subtype();
-
-
---
--- postgresql database dump complete
---
-
diff --git a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host immutable_columns.sql b/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host immutable_columns.sql
deleted file mode 100644
index 0d5dc74da..000000000
--- a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host immutable_columns.sql	
+++ /dev/null
@@ -1,29 +0,0 @@
---
--- postgresql database dump
---
-
--- dumped from database version 13.10
--- dumped by pg_dump version 14.7 (ubuntu 14.7-1.pgdg22.04+1)
-
-set statement_timeout = 0;
-set lock_timeout = 0;
-set idle_in_transaction_session_timeout = 0;
-set client_encoding = 'utf8';
-set standard_conforming_strings = on;
-select pg_catalog.set_config('search_path', '', false);
-set check_function_bodies = false;
-set xmloption = content;
-set client_min_messages = warning;
-set row_security = off;
-
---
--- name: plugin_host immutable_columns; type: trigger; schema: public; owner: -
---
-
-create trigger immutable_columns before update on public.plugin_host for each row execute function public.immutable_columns('public_id', 'create_time');
-
-
---
--- postgresql database dump complete
---
-
diff --git a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host insert_plugin_subtype.sql b/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host insert_plugin_subtype.sql
deleted file mode 100644
index e22ea8286..000000000
--- a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host insert_plugin_subtype.sql	
+++ /dev/null
@@ -1,29 +0,0 @@
---
--- postgresql database dump
---
-
--- dumped from database version 13.10
--- dumped by pg_dump version 14.7 (ubuntu 14.7-1.pgdg22.04+1)
-
-set statement_timeout = 0;
-set lock_timeout = 0;
-set idle_in_transaction_session_timeout = 0;
-set client_encoding = 'utf8';
-set standard_conforming_strings = on;
-select pg_catalog.set_config('search_path', '', false);
-set check_function_bodies = false;
-set xmloption = content;
-set client_min_messages = warning;
-set row_security = off;
-
---
--- name: plugin_host insert_plugin_subtype; type: trigger; schema: public; owner: -
---
-
-create trigger insert_plugin_subtype before insert on public.plugin_host for each row execute function public.insert_plugin_subtype();
-
-
---
--- postgresql database dump complete
---
-
diff --git a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host update_plugin_subtype.sql b/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host update_plugin_subtype.sql
deleted file mode 100644
index 580b2f92a..000000000
--- a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host update_plugin_subtype.sql	
+++ /dev/null
@@ -1,29 +0,0 @@
---
--- postgresql database dump
---
-
--- dumped from database version 13.10
--- dumped by pg_dump version 14.7 (ubuntu 14.7-1.pgdg22.04+1)
-
-set statement_timeout = 0;
-set lock_timeout = 0;
-set idle_in_transaction_session_timeout = 0;
-set client_encoding = 'utf8';
-set standard_conforming_strings = on;
-select pg_catalog.set_config('search_path', '', false);
-set check_function_bodies = false;
-set xmloption = content;
-set client_min_messages = warning;
-set row_security = off;
-
---
--- name: plugin_host update_plugin_subtype; type: trigger; schema: public; owner: -
---
-
-create trigger update_plugin_subtype before update on public.plugin_host for each row execute function public.update_plugin_subtype();
-
-
---
--- postgresql database dump complete
---
-

Indexes

Unchanged

Constraints

diff --git a/.schema-diff/constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/host_pkey.sql b/.schema-diff/constraints_7673502f2d23996536fa55869ba2d7a00f41bf9e/host_pkey.sql
index 4070914a0..98917c122 100644
--- a/.schema-diff/constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/host_pkey.sql
+++ b/.schema-diff/constraints_7673502f2d23996536fa55869ba2d7a00f41bf9e/host_pkey.sql
@@ -2,8 +2,6 @@
     add constraint host_pkey primary key (public_id);
 -- name: host_plugin_host host_plugin_host_pkey; type: constraint; schema: public; owner: -
     add constraint host_plugin_host_pkey primary key (public_id);
--- name: plugin_host plugin_host_pkey; type: constraint; schema: public; owner: -
-    add constraint plugin_host_pkey primary key (public_id);
 -- name: session_host_set_host session_host_set_host_pkey; type: constraint; schema: public; owner: -
     add constraint session_host_set_host_pkey primary key (session_id);
 -- name: static_host static_host_pkey; type: constraint; schema: public; owner: -
diff --git a/.schema-diff/constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host_pkey.sql b/.schema-diff/constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host_pkey.sql
deleted file mode 100644
index 218f0cc08..000000000
--- a/.schema-diff/constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host_pkey.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- name: host_plugin_host host_plugin_host_pkey; type: constraint; schema: public; owner: -
-    add constraint host_plugin_host_pkey primary key (public_id);
--- name: plugin_host plugin_host_pkey; type: constraint; schema: public; owner: -
-    add constraint plugin_host_pkey primary key (public_id);
diff --git a/.schema-diff/constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host_scope_id_name_uq.sql b/.schema-diff/constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host_scope_id_name_uq.sql
deleted file mode 100644
index 0d49a7d4d..000000000
--- a/.schema-diff/constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host_scope_id_name_uq.sql
+++ /dev/null
@@ -1,2 +0,0 @@
--- name: plugin_host plugin_host_scope_id_name_uq; type: constraint; schema: public; owner: -
-    add constraint plugin_host_scope_id_name_uq unique (scope_id, name);
diff --git a/.schema-diff/constraints_7673502f2d23996536fa55869ba2d7a00f41bf9e/plugin_host_supported_pkey.sql b/.schema-diff/constraints_7673502f2d23996536fa55869ba2d7a00f41bf9e/plugin_host_supported_pkey.sql
new file mode 100644
index 000000000..1c0e83ea7
--- /dev/null
+++ b/.schema-diff/constraints_7673502f2d23996536fa55869ba2d7a00f41bf9e/plugin_host_supported_pkey.sql
@@ -0,0 +1,2 @@
+-- name: plugin_host_supported plugin_host_supported_pkey; type: constraint; schema: public; owner: -
+    add constraint plugin_host_supported_pkey primary key (public_id);

Foreign Key Constraints

diff --git a/.schema-diff/fk_constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/host_fkey.sql b/.schema-diff/fk_constraints_7673502f2d23996536fa55869ba2d7a00f41bf9e/host_fkey.sql
index dffd44cdf..b2531b727 100644
--- a/.schema-diff/fk_constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/host_fkey.sql
+++ b/.schema-diff/fk_constraints_7673502f2d23996536fa55869ba2d7a00f41bf9e/host_fkey.sql
@@ -8,5 +8,3 @@
     add constraint host_fkey foreign key (host_id) references public.host(public_id) on update cascade on delete set null;
 -- name: host_plugin_set_member host_plugin_host_fkey; type: fk constraint; schema: public; owner: -
     add constraint host_plugin_host_fkey foreign key (catalog_id, host_id) references public.host_plugin_host(catalog_id, public_id) on update cascade on delete cascade;
--- name: host_plugin_catalog plugin_host_fkey; type: fk constraint; schema: public; owner: -
-    add constraint plugin_host_fkey foreign key (plugin_id) references public.plugin_host(public_id) on update cascade on delete cascade;
diff --git a/.schema-diff/fk_constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/iam_scope_global_fkey.sql b/.schema-diff/fk_constraints_7673502f2d23996536fa55869ba2d7a00f41bf9e/iam_scope_global_fkey.sql
index 0b85da7e2..4cbea874c 100644
--- a/.schema-diff/fk_constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/iam_scope_global_fkey.sql
+++ b/.schema-diff/fk_constraints_7673502f2d23996536fa55869ba2d7a00f41bf9e/iam_scope_global_fkey.sql
@@ -1,4 +1,2 @@
 -- name: plugin iam_scope_global_fkey; type: fk constraint; schema: public; owner: -
     add constraint iam_scope_global_fkey foreign key (scope_id) references public.iam_scope_global(scope_id) on update cascade on delete cascade;
--- name: plugin_host iam_scope_global_fkey; type: fk constraint; schema: public; owner: -
-    add constraint iam_scope_global_fkey foreign key (scope_id) references public.iam_scope_global(scope_id) on update cascade on delete cascade;
diff --git a/.schema-diff/fk_constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_fk.sql b/.schema-diff/fk_constraints_7673502f2d23996536fa55869ba2d7a00f41bf9e/plugin_fk.sql
index 69dfb3ab9..26dddcc38 100644
--- a/.schema-diff/fk_constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_fk.sql
+++ b/.schema-diff/fk_constraints_7673502f2d23996536fa55869ba2d7a00f41bf9e/plugin_fk.sql
@@ -1,4 +1,2 @@
 -- name: job plugin_fk; type: fk constraint; schema: public; owner: -
     add constraint plugin_fk foreign key (plugin_id) references public.plugin(public_id) on update cascade on delete cascade;
--- name: plugin_host plugin_fkey; type: fk constraint; schema: public; owner: -
-    add constraint plugin_fkey foreign key (scope_id, public_id) references public.plugin(scope_id, public_id) on update cascade on delete cascade;
diff --git a/.schema-diff/fk_constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_fkey.sql b/.schema-diff/fk_constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_fkey.sql
deleted file mode 100644
index 1f2d6ff35..000000000
--- a/.schema-diff/fk_constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_fkey.sql
+++ /dev/null
@@ -1,2 +0,0 @@
--- name: plugin_host plugin_fkey; type: fk constraint; schema: public; owner: -
-    add constraint plugin_fkey foreign key (scope_id, public_id) references public.plugin(scope_id, public_id) on update cascade on delete cascade;
diff --git a/.schema-diff/fk_constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host_fkey.sql b/.schema-diff/fk_constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host_fkey.sql
deleted file mode 100644
index 1943ca2ca..000000000
--- a/.schema-diff/fk_constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host_fkey.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- name: host_plugin_set_member host_plugin_host_fkey; type: fk constraint; schema: public; owner: -
-    add constraint host_plugin_host_fkey foreign key (catalog_id, host_id) references public.host_plugin_host(catalog_id, public_id) on update cascade on delete cascade;
--- name: host_plugin_catalog plugin_host_fkey; type: fk constraint; schema: public; owner: -
-    add constraint plugin_host_fkey foreign key (plugin_id) references public.plugin_host(public_id) on update cascade on delete cascade;
diff --git a/.schema-diff/fk_constraints_7673502f2d23996536fa55869ba2d7a00f41bf9e/plugin_host_supported_fkey.sql b/.schema-diff/fk_constraints_7673502f2d23996536fa55869ba2d7a00f41bf9e/plugin_host_supported_fkey.sql
new file mode 100644
index 000000000..28082285c
--- /dev/null
+++ b/.schema-diff/fk_constraints_7673502f2d23996536fa55869ba2d7a00f41bf9e/plugin_host_supported_fkey.sql
@@ -0,0 +1,2 @@
+-- name: host_plugin_catalog plugin_host_supported_fkey; type: fk constraint; schema: public; owner: -
+    add constraint plugin_host_supported_fkey foreign key (plugin_id) references public.plugin_host_supported(public_id) on update cascade on delete cascade;
diff --git a/.schema-diff/fk_constraints_7673502f2d23996536fa55869ba2d7a00f41bf9e/plugin_host_supported_public_id_fkey.sql b/.schema-diff/fk_constraints_7673502f2d23996536fa55869ba2d7a00f41bf9e/plugin_host_supported_public_id_fkey.sql
new file mode 100644
index 000000000..872c357ca
--- /dev/null
+++ b/.schema-diff/fk_constraints_7673502f2d23996536fa55869ba2d7a00f41bf9e/plugin_host_supported_public_id_fkey.sql
@@ -0,0 +1,2 @@
+-- name: plugin_host_supported plugin_host_supported_public_id_fkey; type: fk constraint; schema: public; owner: -
+    add constraint plugin_host_supported_public_id_fkey foreign key (public_id) references public.plugin(public_id) on update cascade on delete cascade;

Mar 30 '23 16:03 github-actions[bot]

Database schema diff between main and dmiu_plugin-restructure @ f4d19404e9348ef470cfa173a5d4cad1e6073709

To understand how these diffs are generated and some limitations see the documentation of the script.

Functions

Unchanged

Tables

diff --git a/.schema-diff/tables_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin.sql b/.schema-diff/tables_d35b145c15631f5aa89d615f27e56823b3510d7c/plugin.sql
index bd529c796..92e74bab5 100644
--- a/.schema-diff/tables_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin.sql
+++ b/.schema-diff/tables_d35b145c15631f5aa89d615f27e56823b3510d7c/plugin.sql
@@ -27,7 +27,11 @@ set default_table_access_method = heap;
 create table public.plugin (
     public_id public.wt_plugin_id not null,
     name public.wt_name,
-    scope_id public.wt_scope_id not null
+    scope_id public.wt_scope_id not null,
+    description text,
+    create_time public.wt_timestamp,
+    update_time public.wt_timestamp,
+    version public.wt_version
 );
 
 
diff --git a/.schema-diff/tables_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host.sql b/.schema-diff/tables_d35b145c15631f5aa89d615f27e56823b3510d7c/plugin_host_supported.sql
similarity index 64%
rename from .schema-diff/tables_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host.sql
rename to .schema-diff/tables_d35b145c15631f5aa89d615f27e56823b3510d7c/plugin_host_supported.sql
index a7117768e..d8e3b440b 100644
--- a/.schema-diff/tables_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host.sql
+++ b/.schema-diff/tables_d35b145c15631f5aa89d615f27e56823b3510d7c/plugin_host_supported.sql
@@ -21,17 +21,11 @@ set default_tablespace = '';
 set default_table_access_method = heap;
 
 --
--- name: plugin_host; type: table; schema: public; owner: -
+-- name: plugin_host_supported; type: table; schema: public; owner: -
 --
 
-create table public.plugin_host (
-    public_id public.wt_plugin_id not null,
-    scope_id public.wt_scope_id not null,
-    name public.wt_name,
-    description text,
-    create_time public.wt_timestamp,
-    update_time public.wt_timestamp,
-    version public.wt_version
+create table public.plugin_host_supported (
+    public_id public.wt_plugin_id not null
 );
 
 
diff --git a/.schema-diff/tables_743bbf88ac43f9b58e99e021bfa57d66d282aabc/public plugin_host.sql b/.schema-diff/tables_d35b145c15631f5aa89d615f27e56823b3510d7c/public plugin_host_supported.sql
similarity index 100%
rename from .schema-diff/tables_743bbf88ac43f9b58e99e021bfa57d66d282aabc/public plugin_host.sql
rename to .schema-diff/tables_d35b145c15631f5aa89d615f27e56823b3510d7c/public plugin_host_supported.sql

Views

Unchanged

Triggers

diff --git a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host default_create_time_column.sql b/.schema-diff/triggers_d35b145c15631f5aa89d615f27e56823b3510d7c/plugin default_create_time_column.sql
similarity index 78%
rename from .schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host default_create_time_column.sql
rename to .schema-diff/triggers_d35b145c15631f5aa89d615f27e56823b3510d7c/plugin default_create_time_column.sql
index 31ec8e4fd..8503cdb1a 100644
--- a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host default_create_time_column.sql	
+++ b/.schema-diff/triggers_d35b145c15631f5aa89d615f27e56823b3510d7c/plugin default_create_time_column.sql	
@@ -17,10 +17,10 @@ set client_min_messages = warning;
 set row_security = off;
 
 --
--- name: plugin_host default_create_time_column; type: trigger; schema: public; owner: -
+-- name: plugin default_create_time_column; type: trigger; schema: public; owner: -
 --
 
-create trigger default_create_time_column before insert on public.plugin_host for each row execute function public.default_create_time();
+create trigger default_create_time_column before insert on public.plugin for each row execute function public.default_create_time();
 
 
 --
diff --git a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin immutable_columns.sql b/.schema-diff/triggers_d35b145c15631f5aa89d615f27e56823b3510d7c/plugin immutable_columns.sql
index 389c30405..2d2de7ef0 100644
--- a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin immutable_columns.sql	
+++ b/.schema-diff/triggers_d35b145c15631f5aa89d615f27e56823b3510d7c/plugin immutable_columns.sql	
@@ -20,7 +20,7 @@ set row_security = off;
 -- name: plugin immutable_columns; type: trigger; schema: public; owner: -
 --
 
-create trigger immutable_columns before update on public.plugin for each row execute function public.immutable_columns('public_id');
+create trigger immutable_columns before update on public.plugin for each row execute function public.immutable_columns('public_id', 'create_time');
 
 
 --
diff --git a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host update_time_column.sql b/.schema-diff/triggers_d35b145c15631f5aa89d615f27e56823b3510d7c/plugin update_time_column.sql
similarity index 80%
rename from .schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host update_time_column.sql
rename to .schema-diff/triggers_d35b145c15631f5aa89d615f27e56823b3510d7c/plugin update_time_column.sql
index b2bd529ed..3a1a2d3db 100644
--- a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host update_time_column.sql	
+++ b/.schema-diff/triggers_d35b145c15631f5aa89d615f27e56823b3510d7c/plugin update_time_column.sql	
@@ -17,10 +17,10 @@ set client_min_messages = warning;
 set row_security = off;
 
 --
--- name: plugin_host update_time_column; type: trigger; schema: public; owner: -
+-- name: plugin update_time_column; type: trigger; schema: public; owner: -
 --
 
-create trigger update_time_column before update on public.plugin_host for each row execute function public.update_time_column();
+create trigger update_time_column before update on public.plugin for each row execute function public.update_time_column();
 
 
 --
diff --git a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host update_version_column.sql b/.schema-diff/triggers_d35b145c15631f5aa89d615f27e56823b3510d7c/plugin update_version_column.sql
similarity index 79%
rename from .schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host update_version_column.sql
rename to .schema-diff/triggers_d35b145c15631f5aa89d615f27e56823b3510d7c/plugin update_version_column.sql
index 1fc1fb4ce..84b92564e 100644
--- a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host update_version_column.sql	
+++ b/.schema-diff/triggers_d35b145c15631f5aa89d615f27e56823b3510d7c/plugin update_version_column.sql	
@@ -17,10 +17,10 @@ set client_min_messages = warning;
 set row_security = off;
 
 --
--- name: plugin_host update_version_column; type: trigger; schema: public; owner: -
+-- name: plugin update_version_column; type: trigger; schema: public; owner: -
 --
 
-create trigger update_version_column after update on public.plugin_host for each row execute function public.update_version_column();
+create trigger update_version_column after update on public.plugin for each row execute function public.update_version_column();
 
 
 --
diff --git a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host delete_plugin_subtype.sql b/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host delete_plugin_subtype.sql
deleted file mode 100644
index 0cf7afbf7..000000000
--- a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host delete_plugin_subtype.sql	
+++ /dev/null
@@ -1,29 +0,0 @@
---
--- postgresql database dump
---
-
--- dumped from database version 13.10
--- dumped by pg_dump version 14.7 (ubuntu 14.7-1.pgdg22.04+1)
-
-set statement_timeout = 0;
-set lock_timeout = 0;
-set idle_in_transaction_session_timeout = 0;
-set client_encoding = 'utf8';
-set standard_conforming_strings = on;
-select pg_catalog.set_config('search_path', '', false);
-set check_function_bodies = false;
-set xmloption = content;
-set client_min_messages = warning;
-set row_security = off;
-
---
--- name: plugin_host delete_plugin_subtype; type: trigger; schema: public; owner: -
---
-
-create trigger delete_plugin_subtype after delete on public.plugin_host for each row execute function public.delete_plugin_subtype();
-
-
---
--- postgresql database dump complete
---
-
diff --git a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host immutable_columns.sql b/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host immutable_columns.sql
deleted file mode 100644
index 0d5dc74da..000000000
--- a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host immutable_columns.sql	
+++ /dev/null
@@ -1,29 +0,0 @@
---
--- postgresql database dump
---
-
--- dumped from database version 13.10
--- dumped by pg_dump version 14.7 (ubuntu 14.7-1.pgdg22.04+1)
-
-set statement_timeout = 0;
-set lock_timeout = 0;
-set idle_in_transaction_session_timeout = 0;
-set client_encoding = 'utf8';
-set standard_conforming_strings = on;
-select pg_catalog.set_config('search_path', '', false);
-set check_function_bodies = false;
-set xmloption = content;
-set client_min_messages = warning;
-set row_security = off;
-
---
--- name: plugin_host immutable_columns; type: trigger; schema: public; owner: -
---
-
-create trigger immutable_columns before update on public.plugin_host for each row execute function public.immutable_columns('public_id', 'create_time');
-
-
---
--- postgresql database dump complete
---
-
diff --git a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host insert_plugin_subtype.sql b/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host insert_plugin_subtype.sql
deleted file mode 100644
index e22ea8286..000000000
--- a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host insert_plugin_subtype.sql	
+++ /dev/null
@@ -1,29 +0,0 @@
---
--- postgresql database dump
---
-
--- dumped from database version 13.10
--- dumped by pg_dump version 14.7 (ubuntu 14.7-1.pgdg22.04+1)
-
-set statement_timeout = 0;
-set lock_timeout = 0;
-set idle_in_transaction_session_timeout = 0;
-set client_encoding = 'utf8';
-set standard_conforming_strings = on;
-select pg_catalog.set_config('search_path', '', false);
-set check_function_bodies = false;
-set xmloption = content;
-set client_min_messages = warning;
-set row_security = off;
-
---
--- name: plugin_host insert_plugin_subtype; type: trigger; schema: public; owner: -
---
-
-create trigger insert_plugin_subtype before insert on public.plugin_host for each row execute function public.insert_plugin_subtype();
-
-
---
--- postgresql database dump complete
---
-
diff --git a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host update_plugin_subtype.sql b/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host update_plugin_subtype.sql
deleted file mode 100644
index 580b2f92a..000000000
--- a/.schema-diff/triggers_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host update_plugin_subtype.sql	
+++ /dev/null
@@ -1,29 +0,0 @@
---
--- postgresql database dump
---
-
--- dumped from database version 13.10
--- dumped by pg_dump version 14.7 (ubuntu 14.7-1.pgdg22.04+1)
-
-set statement_timeout = 0;
-set lock_timeout = 0;
-set idle_in_transaction_session_timeout = 0;
-set client_encoding = 'utf8';
-set standard_conforming_strings = on;
-select pg_catalog.set_config('search_path', '', false);
-set check_function_bodies = false;
-set xmloption = content;
-set client_min_messages = warning;
-set row_security = off;
-
---
--- name: plugin_host update_plugin_subtype; type: trigger; schema: public; owner: -
---
-
-create trigger update_plugin_subtype before update on public.plugin_host for each row execute function public.update_plugin_subtype();
-
-
---
--- postgresql database dump complete
---
-

Indexes

Unchanged

Constraints

diff --git a/.schema-diff/constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/host_pkey.sql b/.schema-diff/constraints_d35b145c15631f5aa89d615f27e56823b3510d7c/host_pkey.sql
index 4070914a0..98917c122 100644
--- a/.schema-diff/constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/host_pkey.sql
+++ b/.schema-diff/constraints_d35b145c15631f5aa89d615f27e56823b3510d7c/host_pkey.sql
@@ -2,8 +2,6 @@
     add constraint host_pkey primary key (public_id);
 -- name: host_plugin_host host_plugin_host_pkey; type: constraint; schema: public; owner: -
     add constraint host_plugin_host_pkey primary key (public_id);
--- name: plugin_host plugin_host_pkey; type: constraint; schema: public; owner: -
-    add constraint plugin_host_pkey primary key (public_id);
 -- name: session_host_set_host session_host_set_host_pkey; type: constraint; schema: public; owner: -
     add constraint session_host_set_host_pkey primary key (session_id);
 -- name: static_host static_host_pkey; type: constraint; schema: public; owner: -
diff --git a/.schema-diff/constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host_pkey.sql b/.schema-diff/constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host_pkey.sql
deleted file mode 100644
index 218f0cc08..000000000
--- a/.schema-diff/constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host_pkey.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- name: host_plugin_host host_plugin_host_pkey; type: constraint; schema: public; owner: -
-    add constraint host_plugin_host_pkey primary key (public_id);
--- name: plugin_host plugin_host_pkey; type: constraint; schema: public; owner: -
-    add constraint plugin_host_pkey primary key (public_id);
diff --git a/.schema-diff/constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host_scope_id_name_uq.sql b/.schema-diff/constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host_scope_id_name_uq.sql
deleted file mode 100644
index 0d49a7d4d..000000000
--- a/.schema-diff/constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host_scope_id_name_uq.sql
+++ /dev/null
@@ -1,2 +0,0 @@
--- name: plugin_host plugin_host_scope_id_name_uq; type: constraint; schema: public; owner: -
-    add constraint plugin_host_scope_id_name_uq unique (scope_id, name);
diff --git a/.schema-diff/constraints_d35b145c15631f5aa89d615f27e56823b3510d7c/plugin_host_supported_pkey.sql b/.schema-diff/constraints_d35b145c15631f5aa89d615f27e56823b3510d7c/plugin_host_supported_pkey.sql
new file mode 100644
index 000000000..1c0e83ea7
--- /dev/null
+++ b/.schema-diff/constraints_d35b145c15631f5aa89d615f27e56823b3510d7c/plugin_host_supported_pkey.sql
@@ -0,0 +1,2 @@
+-- name: plugin_host_supported plugin_host_supported_pkey; type: constraint; schema: public; owner: -
+    add constraint plugin_host_supported_pkey primary key (public_id);

Foreign Key Constraints

diff --git a/.schema-diff/fk_constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/host_fkey.sql b/.schema-diff/fk_constraints_d35b145c15631f5aa89d615f27e56823b3510d7c/host_fkey.sql
index dffd44cdf..b2531b727 100644
--- a/.schema-diff/fk_constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/host_fkey.sql
+++ b/.schema-diff/fk_constraints_d35b145c15631f5aa89d615f27e56823b3510d7c/host_fkey.sql
@@ -8,5 +8,3 @@
     add constraint host_fkey foreign key (host_id) references public.host(public_id) on update cascade on delete set null;
 -- name: host_plugin_set_member host_plugin_host_fkey; type: fk constraint; schema: public; owner: -
     add constraint host_plugin_host_fkey foreign key (catalog_id, host_id) references public.host_plugin_host(catalog_id, public_id) on update cascade on delete cascade;
--- name: host_plugin_catalog plugin_host_fkey; type: fk constraint; schema: public; owner: -
-    add constraint plugin_host_fkey foreign key (plugin_id) references public.plugin_host(public_id) on update cascade on delete cascade;
diff --git a/.schema-diff/fk_constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/iam_scope_global_fkey.sql b/.schema-diff/fk_constraints_d35b145c15631f5aa89d615f27e56823b3510d7c/iam_scope_global_fkey.sql
index 0b85da7e2..4cbea874c 100644
--- a/.schema-diff/fk_constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/iam_scope_global_fkey.sql
+++ b/.schema-diff/fk_constraints_d35b145c15631f5aa89d615f27e56823b3510d7c/iam_scope_global_fkey.sql
@@ -1,4 +1,2 @@
 -- name: plugin iam_scope_global_fkey; type: fk constraint; schema: public; owner: -
     add constraint iam_scope_global_fkey foreign key (scope_id) references public.iam_scope_global(scope_id) on update cascade on delete cascade;
--- name: plugin_host iam_scope_global_fkey; type: fk constraint; schema: public; owner: -
-    add constraint iam_scope_global_fkey foreign key (scope_id) references public.iam_scope_global(scope_id) on update cascade on delete cascade;
diff --git a/.schema-diff/fk_constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_fk.sql b/.schema-diff/fk_constraints_d35b145c15631f5aa89d615f27e56823b3510d7c/plugin_fk.sql
index 69dfb3ab9..26dddcc38 100644
--- a/.schema-diff/fk_constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_fk.sql
+++ b/.schema-diff/fk_constraints_d35b145c15631f5aa89d615f27e56823b3510d7c/plugin_fk.sql
@@ -1,4 +1,2 @@
 -- name: job plugin_fk; type: fk constraint; schema: public; owner: -
     add constraint plugin_fk foreign key (plugin_id) references public.plugin(public_id) on update cascade on delete cascade;
--- name: plugin_host plugin_fkey; type: fk constraint; schema: public; owner: -
-    add constraint plugin_fkey foreign key (scope_id, public_id) references public.plugin(scope_id, public_id) on update cascade on delete cascade;
diff --git a/.schema-diff/fk_constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_fkey.sql b/.schema-diff/fk_constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_fkey.sql
deleted file mode 100644
index 1f2d6ff35..000000000
--- a/.schema-diff/fk_constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_fkey.sql
+++ /dev/null
@@ -1,2 +0,0 @@
--- name: plugin_host plugin_fkey; type: fk constraint; schema: public; owner: -
-    add constraint plugin_fkey foreign key (scope_id, public_id) references public.plugin(scope_id, public_id) on update cascade on delete cascade;
diff --git a/.schema-diff/fk_constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host_fkey.sql b/.schema-diff/fk_constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host_fkey.sql
deleted file mode 100644
index 1943ca2ca..000000000
--- a/.schema-diff/fk_constraints_743bbf88ac43f9b58e99e021bfa57d66d282aabc/plugin_host_fkey.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- name: host_plugin_set_member host_plugin_host_fkey; type: fk constraint; schema: public; owner: -
-    add constraint host_plugin_host_fkey foreign key (catalog_id, host_id) references public.host_plugin_host(catalog_id, public_id) on update cascade on delete cascade;
--- name: host_plugin_catalog plugin_host_fkey; type: fk constraint; schema: public; owner: -
-    add constraint plugin_host_fkey foreign key (plugin_id) references public.plugin_host(public_id) on update cascade on delete cascade;
diff --git a/.schema-diff/fk_constraints_d35b145c15631f5aa89d615f27e56823b3510d7c/plugin_host_supported_fkey.sql b/.schema-diff/fk_constraints_d35b145c15631f5aa89d615f27e56823b3510d7c/plugin_host_supported_fkey.sql
new file mode 100644
index 000000000..28082285c
--- /dev/null
+++ b/.schema-diff/fk_constraints_d35b145c15631f5aa89d615f27e56823b3510d7c/plugin_host_supported_fkey.sql
@@ -0,0 +1,2 @@
+-- name: host_plugin_catalog plugin_host_supported_fkey; type: fk constraint; schema: public; owner: -
+    add constraint plugin_host_supported_fkey foreign key (plugin_id) references public.plugin_host_supported(public_id) on update cascade on delete cascade;
diff --git a/.schema-diff/fk_constraints_d35b145c15631f5aa89d615f27e56823b3510d7c/plugin_host_supported_public_id_fkey.sql b/.schema-diff/fk_constraints_d35b145c15631f5aa89d615f27e56823b3510d7c/plugin_host_supported_public_id_fkey.sql
new file mode 100644
index 000000000..872c357ca
--- /dev/null
+++ b/.schema-diff/fk_constraints_d35b145c15631f5aa89d615f27e56823b3510d7c/plugin_host_supported_public_id_fkey.sql
@@ -0,0 +1,2 @@
+-- name: plugin_host_supported plugin_host_supported_public_id_fkey; type: fk constraint; schema: public; owner: -
+    add constraint plugin_host_supported_public_id_fkey foreign key (public_id) references public.plugin(public_id) on update cascade on delete cascade;

Mar 30 '23 17:03 github-actions[bot]

Database schema diff between main and dmiu_plugin-restructure @ 15922d71f47700e06e42fd36ec7a59cb359bce3c

To understand how these diffs are generated and some limitations see the documentation of the script.

Functions

diff --git a/.schema-diff/funcs_16f48686a79d19f764ea4187cffa972a2ad361f2/_wtt_load_widgets_hosts.sql b/.schema-diff/funcs_312837caffb0ddf4b348cfa934214e89e91cf201/_wtt_load_widgets_hosts.sql
index 7ad9d400c..f202fd9cc 100644
--- a/.schema-diff/funcs_16f48686a79d19f764ea4187cffa972a2ad361f2/_wtt_load_widgets_hosts.sql
+++ b/.schema-diff/funcs_312837caffb0ddf4b348cfa934214e89e91cf201/_wtt_load_widgets_hosts.sql
@@ -70,11 +70,16 @@ create function public._wtt_load_widgets_hosts() returns void
      where h.catalog_id = s.catalog_id
        and h.address like '%.widget';
 
-    insert into plugin_host
+    insert into plugin
       (scope_id, public_id, name)
     values
       ('global', 'plg___wb-hplg', 'short host plugin');
 
+    insert into plugin_host_supported
+      (public_id)
+    values
+      ('plg___wb-hplg');
+
     insert into host_plugin_catalog
       (project_id, public_id, plugin_id, name, attributes)
     values

Tables

diff --git a/.schema-diff/tables_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin.sql b/.schema-diff/tables_312837caffb0ddf4b348cfa934214e89e91cf201/plugin.sql
index bd529c796..92e74bab5 100644
--- a/.schema-diff/tables_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin.sql
+++ b/.schema-diff/tables_312837caffb0ddf4b348cfa934214e89e91cf201/plugin.sql
@@ -27,7 +27,11 @@ set default_table_access_method = heap;
 create table public.plugin (
     public_id public.wt_plugin_id not null,
     name public.wt_name,
-    scope_id public.wt_scope_id not null
+    scope_id public.wt_scope_id not null,
+    description text,
+    create_time public.wt_timestamp,
+    update_time public.wt_timestamp,
+    version public.wt_version
 );
 
 
diff --git a/.schema-diff/tables_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host.sql b/.schema-diff/tables_312837caffb0ddf4b348cfa934214e89e91cf201/plugin_host_supported.sql
similarity index 64%
rename from .schema-diff/tables_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host.sql
rename to .schema-diff/tables_312837caffb0ddf4b348cfa934214e89e91cf201/plugin_host_supported.sql
index a7117768e..d8e3b440b 100644
--- a/.schema-diff/tables_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host.sql
+++ b/.schema-diff/tables_312837caffb0ddf4b348cfa934214e89e91cf201/plugin_host_supported.sql
@@ -21,17 +21,11 @@ set default_tablespace = '';
 set default_table_access_method = heap;
 
 --
--- name: plugin_host; type: table; schema: public; owner: -
+-- name: plugin_host_supported; type: table; schema: public; owner: -
 --
 
-create table public.plugin_host (
-    public_id public.wt_plugin_id not null,
-    scope_id public.wt_scope_id not null,
-    name public.wt_name,
-    description text,
-    create_time public.wt_timestamp,
-    update_time public.wt_timestamp,
-    version public.wt_version
+create table public.plugin_host_supported (
+    public_id public.wt_plugin_id not null
 );
 
 
diff --git a/.schema-diff/tables_16f48686a79d19f764ea4187cffa972a2ad361f2/public plugin_host.sql b/.schema-diff/tables_312837caffb0ddf4b348cfa934214e89e91cf201/public plugin_host_supported.sql
similarity index 100%
rename from .schema-diff/tables_16f48686a79d19f764ea4187cffa972a2ad361f2/public plugin_host.sql
rename to .schema-diff/tables_312837caffb0ddf4b348cfa934214e89e91cf201/public plugin_host_supported.sql

Views

Unchanged

Triggers

diff --git a/.schema-diff/triggers_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host default_create_time_column.sql b/.schema-diff/triggers_312837caffb0ddf4b348cfa934214e89e91cf201/plugin default_create_time_column.sql
similarity index 78%
rename from .schema-diff/triggers_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host default_create_time_column.sql
rename to .schema-diff/triggers_312837caffb0ddf4b348cfa934214e89e91cf201/plugin default_create_time_column.sql
index 31ec8e4fd..8503cdb1a 100644
--- a/.schema-diff/triggers_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host default_create_time_column.sql	
+++ b/.schema-diff/triggers_312837caffb0ddf4b348cfa934214e89e91cf201/plugin default_create_time_column.sql	
@@ -17,10 +17,10 @@ set client_min_messages = warning;
 set row_security = off;
 
 --
--- name: plugin_host default_create_time_column; type: trigger; schema: public; owner: -
+-- name: plugin default_create_time_column; type: trigger; schema: public; owner: -
 --
 
-create trigger default_create_time_column before insert on public.plugin_host for each row execute function public.default_create_time();
+create trigger default_create_time_column before insert on public.plugin for each row execute function public.default_create_time();
 
 
 --
diff --git a/.schema-diff/triggers_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin immutable_columns.sql b/.schema-diff/triggers_312837caffb0ddf4b348cfa934214e89e91cf201/plugin immutable_columns.sql
index 389c30405..2d2de7ef0 100644
--- a/.schema-diff/triggers_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin immutable_columns.sql	
+++ b/.schema-diff/triggers_312837caffb0ddf4b348cfa934214e89e91cf201/plugin immutable_columns.sql	
@@ -20,7 +20,7 @@ set row_security = off;
 -- name: plugin immutable_columns; type: trigger; schema: public; owner: -
 --
 
-create trigger immutable_columns before update on public.plugin for each row execute function public.immutable_columns('public_id');
+create trigger immutable_columns before update on public.plugin for each row execute function public.immutable_columns('public_id', 'create_time');
 
 
 --
diff --git a/.schema-diff/triggers_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host update_time_column.sql b/.schema-diff/triggers_312837caffb0ddf4b348cfa934214e89e91cf201/plugin update_time_column.sql
similarity index 80%
rename from .schema-diff/triggers_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host update_time_column.sql
rename to .schema-diff/triggers_312837caffb0ddf4b348cfa934214e89e91cf201/plugin update_time_column.sql
index b2bd529ed..3a1a2d3db 100644
--- a/.schema-diff/triggers_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host update_time_column.sql	
+++ b/.schema-diff/triggers_312837caffb0ddf4b348cfa934214e89e91cf201/plugin update_time_column.sql	
@@ -17,10 +17,10 @@ set client_min_messages = warning;
 set row_security = off;
 
 --
--- name: plugin_host update_time_column; type: trigger; schema: public; owner: -
+-- name: plugin update_time_column; type: trigger; schema: public; owner: -
 --
 
-create trigger update_time_column before update on public.plugin_host for each row execute function public.update_time_column();
+create trigger update_time_column before update on public.plugin for each row execute function public.update_time_column();
 
 
 --
diff --git a/.schema-diff/triggers_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host update_version_column.sql b/.schema-diff/triggers_312837caffb0ddf4b348cfa934214e89e91cf201/plugin update_version_column.sql
similarity index 79%
rename from .schema-diff/triggers_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host update_version_column.sql
rename to .schema-diff/triggers_312837caffb0ddf4b348cfa934214e89e91cf201/plugin update_version_column.sql
index 1fc1fb4ce..84b92564e 100644
--- a/.schema-diff/triggers_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host update_version_column.sql	
+++ b/.schema-diff/triggers_312837caffb0ddf4b348cfa934214e89e91cf201/plugin update_version_column.sql	
@@ -17,10 +17,10 @@ set client_min_messages = warning;
 set row_security = off;
 
 --
--- name: plugin_host update_version_column; type: trigger; schema: public; owner: -
+-- name: plugin update_version_column; type: trigger; schema: public; owner: -
 --
 
-create trigger update_version_column after update on public.plugin_host for each row execute function public.update_version_column();
+create trigger update_version_column after update on public.plugin for each row execute function public.update_version_column();
 
 
 --
diff --git a/.schema-diff/triggers_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host delete_plugin_subtype.sql b/.schema-diff/triggers_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host delete_plugin_subtype.sql
deleted file mode 100644
index 0cf7afbf7..000000000
--- a/.schema-diff/triggers_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host delete_plugin_subtype.sql	
+++ /dev/null
@@ -1,29 +0,0 @@
---
--- postgresql database dump
---
-
--- dumped from database version 13.10
--- dumped by pg_dump version 14.7 (ubuntu 14.7-1.pgdg22.04+1)
-
-set statement_timeout = 0;
-set lock_timeout = 0;
-set idle_in_transaction_session_timeout = 0;
-set client_encoding = 'utf8';
-set standard_conforming_strings = on;
-select pg_catalog.set_config('search_path', '', false);
-set check_function_bodies = false;
-set xmloption = content;
-set client_min_messages = warning;
-set row_security = off;
-
---
--- name: plugin_host delete_plugin_subtype; type: trigger; schema: public; owner: -
---
-
-create trigger delete_plugin_subtype after delete on public.plugin_host for each row execute function public.delete_plugin_subtype();
-
-
---
--- postgresql database dump complete
---
-
diff --git a/.schema-diff/triggers_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host immutable_columns.sql b/.schema-diff/triggers_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host immutable_columns.sql
deleted file mode 100644
index 0d5dc74da..000000000
--- a/.schema-diff/triggers_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host immutable_columns.sql	
+++ /dev/null
@@ -1,29 +0,0 @@
---
--- postgresql database dump
---
-
--- dumped from database version 13.10
--- dumped by pg_dump version 14.7 (ubuntu 14.7-1.pgdg22.04+1)
-
-set statement_timeout = 0;
-set lock_timeout = 0;
-set idle_in_transaction_session_timeout = 0;
-set client_encoding = 'utf8';
-set standard_conforming_strings = on;
-select pg_catalog.set_config('search_path', '', false);
-set check_function_bodies = false;
-set xmloption = content;
-set client_min_messages = warning;
-set row_security = off;
-
---
--- name: plugin_host immutable_columns; type: trigger; schema: public; owner: -
---
-
-create trigger immutable_columns before update on public.plugin_host for each row execute function public.immutable_columns('public_id', 'create_time');
-
-
---
--- postgresql database dump complete
---
-
diff --git a/.schema-diff/triggers_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host insert_plugin_subtype.sql b/.schema-diff/triggers_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host insert_plugin_subtype.sql
deleted file mode 100644
index e22ea8286..000000000
--- a/.schema-diff/triggers_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host insert_plugin_subtype.sql	
+++ /dev/null
@@ -1,29 +0,0 @@
---
--- postgresql database dump
---
-
--- dumped from database version 13.10
--- dumped by pg_dump version 14.7 (ubuntu 14.7-1.pgdg22.04+1)
-
-set statement_timeout = 0;
-set lock_timeout = 0;
-set idle_in_transaction_session_timeout = 0;
-set client_encoding = 'utf8';
-set standard_conforming_strings = on;
-select pg_catalog.set_config('search_path', '', false);
-set check_function_bodies = false;
-set xmloption = content;
-set client_min_messages = warning;
-set row_security = off;
-
---
--- name: plugin_host insert_plugin_subtype; type: trigger; schema: public; owner: -
---
-
-create trigger insert_plugin_subtype before insert on public.plugin_host for each row execute function public.insert_plugin_subtype();
-
-
---
--- postgresql database dump complete
---
-
diff --git a/.schema-diff/triggers_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host update_plugin_subtype.sql b/.schema-diff/triggers_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host update_plugin_subtype.sql
deleted file mode 100644
index 580b2f92a..000000000
--- a/.schema-diff/triggers_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host update_plugin_subtype.sql	
+++ /dev/null
@@ -1,29 +0,0 @@
---
--- postgresql database dump
---
-
--- dumped from database version 13.10
--- dumped by pg_dump version 14.7 (ubuntu 14.7-1.pgdg22.04+1)
-
-set statement_timeout = 0;
-set lock_timeout = 0;
-set idle_in_transaction_session_timeout = 0;
-set client_encoding = 'utf8';
-set standard_conforming_strings = on;
-select pg_catalog.set_config('search_path', '', false);
-set check_function_bodies = false;
-set xmloption = content;
-set client_min_messages = warning;
-set row_security = off;
-
---
--- name: plugin_host update_plugin_subtype; type: trigger; schema: public; owner: -
---
-
-create trigger update_plugin_subtype before update on public.plugin_host for each row execute function public.update_plugin_subtype();
-
-
---
--- postgresql database dump complete
---
-

Indexes

Unchanged

Constraints

diff --git a/.schema-diff/constraints_16f48686a79d19f764ea4187cffa972a2ad361f2/host_pkey.sql b/.schema-diff/constraints_312837caffb0ddf4b348cfa934214e89e91cf201/host_pkey.sql
index 4070914a0..98917c122 100644
--- a/.schema-diff/constraints_16f48686a79d19f764ea4187cffa972a2ad361f2/host_pkey.sql
+++ b/.schema-diff/constraints_312837caffb0ddf4b348cfa934214e89e91cf201/host_pkey.sql
@@ -2,8 +2,6 @@
     add constraint host_pkey primary key (public_id);
 -- name: host_plugin_host host_plugin_host_pkey; type: constraint; schema: public; owner: -
     add constraint host_plugin_host_pkey primary key (public_id);
--- name: plugin_host plugin_host_pkey; type: constraint; schema: public; owner: -
-    add constraint plugin_host_pkey primary key (public_id);
 -- name: session_host_set_host session_host_set_host_pkey; type: constraint; schema: public; owner: -
     add constraint session_host_set_host_pkey primary key (session_id);
 -- name: static_host static_host_pkey; type: constraint; schema: public; owner: -
diff --git a/.schema-diff/constraints_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host_pkey.sql b/.schema-diff/constraints_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host_pkey.sql
deleted file mode 100644
index 218f0cc08..000000000
--- a/.schema-diff/constraints_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host_pkey.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- name: host_plugin_host host_plugin_host_pkey; type: constraint; schema: public; owner: -
-    add constraint host_plugin_host_pkey primary key (public_id);
--- name: plugin_host plugin_host_pkey; type: constraint; schema: public; owner: -
-    add constraint plugin_host_pkey primary key (public_id);
diff --git a/.schema-diff/constraints_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host_scope_id_name_uq.sql b/.schema-diff/constraints_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host_scope_id_name_uq.sql
deleted file mode 100644
index 0d49a7d4d..000000000
--- a/.schema-diff/constraints_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host_scope_id_name_uq.sql
+++ /dev/null
@@ -1,2 +0,0 @@
--- name: plugin_host plugin_host_scope_id_name_uq; type: constraint; schema: public; owner: -
-    add constraint plugin_host_scope_id_name_uq unique (scope_id, name);
diff --git a/.schema-diff/constraints_312837caffb0ddf4b348cfa934214e89e91cf201/plugin_host_supported_pkey.sql b/.schema-diff/constraints_312837caffb0ddf4b348cfa934214e89e91cf201/plugin_host_supported_pkey.sql
new file mode 100644
index 000000000..1c0e83ea7
--- /dev/null
+++ b/.schema-diff/constraints_312837caffb0ddf4b348cfa934214e89e91cf201/plugin_host_supported_pkey.sql
@@ -0,0 +1,2 @@
+-- name: plugin_host_supported plugin_host_supported_pkey; type: constraint; schema: public; owner: -
+    add constraint plugin_host_supported_pkey primary key (public_id);

Foreign Key Constraints

diff --git a/.schema-diff/fk_constraints_16f48686a79d19f764ea4187cffa972a2ad361f2/host_fkey.sql b/.schema-diff/fk_constraints_312837caffb0ddf4b348cfa934214e89e91cf201/host_fkey.sql
index dffd44cdf..b2531b727 100644
--- a/.schema-diff/fk_constraints_16f48686a79d19f764ea4187cffa972a2ad361f2/host_fkey.sql
+++ b/.schema-diff/fk_constraints_312837caffb0ddf4b348cfa934214e89e91cf201/host_fkey.sql
@@ -8,5 +8,3 @@
     add constraint host_fkey foreign key (host_id) references public.host(public_id) on update cascade on delete set null;
 -- name: host_plugin_set_member host_plugin_host_fkey; type: fk constraint; schema: public; owner: -
     add constraint host_plugin_host_fkey foreign key (catalog_id, host_id) references public.host_plugin_host(catalog_id, public_id) on update cascade on delete cascade;
--- name: host_plugin_catalog plugin_host_fkey; type: fk constraint; schema: public; owner: -
-    add constraint plugin_host_fkey foreign key (plugin_id) references public.plugin_host(public_id) on update cascade on delete cascade;
diff --git a/.schema-diff/fk_constraints_16f48686a79d19f764ea4187cffa972a2ad361f2/iam_scope_global_fkey.sql b/.schema-diff/fk_constraints_312837caffb0ddf4b348cfa934214e89e91cf201/iam_scope_global_fkey.sql
index 0b85da7e2..4cbea874c 100644
--- a/.schema-diff/fk_constraints_16f48686a79d19f764ea4187cffa972a2ad361f2/iam_scope_global_fkey.sql
+++ b/.schema-diff/fk_constraints_312837caffb0ddf4b348cfa934214e89e91cf201/iam_scope_global_fkey.sql
@@ -1,4 +1,2 @@
 -- name: plugin iam_scope_global_fkey; type: fk constraint; schema: public; owner: -
     add constraint iam_scope_global_fkey foreign key (scope_id) references public.iam_scope_global(scope_id) on update cascade on delete cascade;
--- name: plugin_host iam_scope_global_fkey; type: fk constraint; schema: public; owner: -
-    add constraint iam_scope_global_fkey foreign key (scope_id) references public.iam_scope_global(scope_id) on update cascade on delete cascade;
diff --git a/.schema-diff/fk_constraints_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_fk.sql b/.schema-diff/fk_constraints_312837caffb0ddf4b348cfa934214e89e91cf201/plugin_fk.sql
index 69dfb3ab9..26dddcc38 100644
--- a/.schema-diff/fk_constraints_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_fk.sql
+++ b/.schema-diff/fk_constraints_312837caffb0ddf4b348cfa934214e89e91cf201/plugin_fk.sql
@@ -1,4 +1,2 @@
 -- name: job plugin_fk; type: fk constraint; schema: public; owner: -
     add constraint plugin_fk foreign key (plugin_id) references public.plugin(public_id) on update cascade on delete cascade;
--- name: plugin_host plugin_fkey; type: fk constraint; schema: public; owner: -
-    add constraint plugin_fkey foreign key (scope_id, public_id) references public.plugin(scope_id, public_id) on update cascade on delete cascade;
diff --git a/.schema-diff/fk_constraints_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_fkey.sql b/.schema-diff/fk_constraints_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_fkey.sql
deleted file mode 100644
index 1f2d6ff35..000000000
--- a/.schema-diff/fk_constraints_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_fkey.sql
+++ /dev/null
@@ -1,2 +0,0 @@
--- name: plugin_host plugin_fkey; type: fk constraint; schema: public; owner: -
-    add constraint plugin_fkey foreign key (scope_id, public_id) references public.plugin(scope_id, public_id) on update cascade on delete cascade;
diff --git a/.schema-diff/fk_constraints_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host_fkey.sql b/.schema-diff/fk_constraints_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host_fkey.sql
deleted file mode 100644
index 1943ca2ca..000000000
--- a/.schema-diff/fk_constraints_16f48686a79d19f764ea4187cffa972a2ad361f2/plugin_host_fkey.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- name: host_plugin_set_member host_plugin_host_fkey; type: fk constraint; schema: public; owner: -
-    add constraint host_plugin_host_fkey foreign key (catalog_id, host_id) references public.host_plugin_host(catalog_id, public_id) on update cascade on delete cascade;
--- name: host_plugin_catalog plugin_host_fkey; type: fk constraint; schema: public; owner: -
-    add constraint plugin_host_fkey foreign key (plugin_id) references public.plugin_host(public_id) on update cascade on delete cascade;
diff --git a/.schema-diff/fk_constraints_312837caffb0ddf4b348cfa934214e89e91cf201/plugin_host_supported_fkey.sql b/.schema-diff/fk_constraints_312837caffb0ddf4b348cfa934214e89e91cf201/plugin_host_supported_fkey.sql
new file mode 100644
index 000000000..28082285c
--- /dev/null
+++ b/.schema-diff/fk_constraints_312837caffb0ddf4b348cfa934214e89e91cf201/plugin_host_supported_fkey.sql
@@ -0,0 +1,2 @@
+-- name: host_plugin_catalog plugin_host_supported_fkey; type: fk constraint; schema: public; owner: -
+    add constraint plugin_host_supported_fkey foreign key (plugin_id) references public.plugin_host_supported(public_id) on update cascade on delete cascade;
diff --git a/.schema-diff/fk_constraints_312837caffb0ddf4b348cfa934214e89e91cf201/plugin_host_supported_public_id_fkey.sql b/.schema-diff/fk_constraints_312837caffb0ddf4b348cfa934214e89e91cf201/plugin_host_supported_public_id_fkey.sql
new file mode 100644
index 000000000..872c357ca
--- /dev/null
+++ b/.schema-diff/fk_constraints_312837caffb0ddf4b348cfa934214e89e91cf201/plugin_host_supported_public_id_fkey.sql
@@ -0,0 +1,2 @@
+-- name: plugin_host_supported plugin_host_supported_public_id_fkey; type: fk constraint; schema: public; owner: -
+    add constraint plugin_host_supported_public_id_fkey foreign key (public_id) references public.plugin(public_id) on update cascade on delete cascade;

Mar 30 '23 19:03 github-actions[bot]

boundary boundary copied to clipboard

rework plugin/host_plugin sql and accompanying domain

Functions

Tables

Views

Triggers

Indexes

Constraints

Foreign Key Constraints

Functions

Tables

Views

Triggers

Indexes

Constraints

Foreign Key Constraints

Functions

Tables

Views

Triggers

Indexes

Constraints

Foreign Key Constraints

boundary
boundary copied to clipboard