Daniel Erez has uploaded a new change for review.

Change subject: core: introduce libvirt_secrets table
......................................................................

core: introduce libvirt_secrets table

Added libvirt_secret table to represent secrets needed
for ceph authentication (as part of Cinder integration).

[*] https://libvirt.org/formatsecret.html

Change-Id: I588a2cea168ecd7abf0a3f92be5a1573af601281
Bug-Url: https://bugzilla.redhat.com/1185826
Signed-off-by: Daniel Erez <[email protected]>
---
A packaging/dbscripts/upgrade/03_06_1400_libvirt_secrets.sql
1 file changed, 19 insertions(+), 0 deletions(-)


  git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/50/41550/1

diff --git a/packaging/dbscripts/upgrade/03_06_1400_libvirt_secrets.sql 
b/packaging/dbscripts/upgrade/03_06_1400_libvirt_secrets.sql
new file mode 100644
index 0000000..fb2269f
--- /dev/null
+++ b/packaging/dbscripts/upgrade/03_06_1400_libvirt_secrets.sql
@@ -0,0 +1,19 @@
+-- ----------------------------------------------------------------------
+--  table libvirt_secrets
+-- ----------------------------------------------------------------------
+
+CREATE TABLE libvirt_secrets
+(
+  secret_uuid UUID NOT NULL,
+  secret_value TEXT NOT NULL,
+  secret_usage_type integer NOT NULL,
+  secret_description TEXT,
+  provider_id UUID NOT NULL,
+  creation_date timestamp with time zone NOT NULL,
+  _create_date timestamp with time zone DEFAULT ('now'::text)::timestamp 
without time zone,
+  _update_date timestamp with time zone,
+  CONSTRAINT PK_secret_uuid PRIMARY KEY (secret_uuid),
+  FOREIGN KEY (provider_id) REFERENCES providers(id) ON DELETE CASCADE
+);
+
+CREATE INDEX IDX_libvirt_secrets_provider_id ON libvirt_secrets(provider_id);


-- 
To view, visit https://gerrit.ovirt.org/41550
To unsubscribe, visit https://gerrit.ovirt.org/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: I588a2cea168ecd7abf0a3f92be5a1573af601281
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Daniel Erez <[email protected]>
_______________________________________________
Engine-patches mailing list
[email protected]
http://lists.ovirt.org/mailman/listinfo/engine-patches

Reply via email to