btcpayserver-plugin-builder/PluginBuilder/Data/Scripts/13.PluginOwner.sql
2025-08-07 10:23:17 +01:00

7 lines
191 B
SQL

ALTER TABLE users_plugins
ADD COLUMN is_primary_owner BOOLEAN DEFAULT FALSE;
CREATE UNIQUE INDEX ux_one_primary_owner_per_plugin
ON users_plugins(plugin_slug)
WHERE is_primary_owner = TRUE;