Added installed_plugins table
Change-Id: I835eb9cea1d98fdfa33d0c783c44d6b69e50609e
diff --git a/full/Changes b/full/Changes
index 1827ffc..9bf30f2 100644
--- a/full/Changes
+++ b/full/Changes
@@ -5,6 +5,7 @@
- Added redirect URI validation in authorization request (addressed #374)
- Handled user-defined refresh token expiry (added in client info and
list API response)
+ - Added installed_plugins table
# version 0.67.1
diff --git a/full/src/main/resources/db/sqlite/V1.12__plugins.sql b/full/src/main/resources/db/sqlite/V1.12__plugins.sql
new file mode 100644
index 0000000..1de97b4
--- /dev/null
+++ b/full/src/main/resources/db/sqlite/V1.12__plugins.sql
@@ -0,0 +1,15 @@
+CREATE TABLE IF NOT EXISTS installed_plugin (
+ id INTEGER PRIMARY KEY AUTOINCREMENT,
+ installed_by VARCHAR(100) NOT NULL,
+ installed_date TIMESTAMP NOT NULL,
+ client_id VARCHAR(100) NOT NULL,
+ super_client_id VARCHAR(100) NOT NULL,
+ FOREIGN KEY (client_id)
+ REFERENCES oauth2_client(id)
+ ON DELETE CASCADE
+ FOREIGN KEY (super_client_id)
+ REFERENCES oauth2_client(id)
+ ON DELETE CASCADE
+);
+CREATE UNIQUE INDEX IF NOT EXISTS unique_installed_plugin
+ on installed_plugin(installed_by,client_id,super_client_id);