Ramesh N has uploaded a new change for review.

Change subject: engine: duplicating upgrade scripts for 3.5
......................................................................

engine: duplicating upgrade scripts for 3.5

Copying the follwing upgrade scripts to 3.5 numbering 03_05_XXXX
to support upgrade from 3.4 to master.

  03_04_0520_add_tables_for_gluster_volume_and_brick_details.sql
  03_04_0530_gluster_refresh_gluster_volume_details-event_map.sql

Change-Id: Ib4df5b16104ecbd0c6f8e560f8e7d7c10b32bc96
Signed-off-by: Ramesh Nachimuthu <[email protected]>
---
A 
packaging/dbscripts/upgrade/03_05_0010_add_tables_for_gluster_volume_and_brick_details.sql
A 
packaging/dbscripts/upgrade/03_05_0020_gluster_refresh_gluster_volume_details-event_map.sql
2 files changed, 24 insertions(+), 0 deletions(-)


  git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/17/24517/1

diff --git 
a/packaging/dbscripts/upgrade/03_05_0010_add_tables_for_gluster_volume_and_brick_details.sql
 
b/packaging/dbscripts/upgrade/03_05_0010_add_tables_for_gluster_volume_and_brick_details.sql
new file mode 100644
index 0000000..317a566
--- /dev/null
+++ 
b/packaging/dbscripts/upgrade/03_05_0010_add_tables_for_gluster_volume_and_brick_details.sql
@@ -0,0 +1,21 @@
+-- Add gluster_volume_details table
+CREATE TABLE gluster_volume_details
+(
+    volume_id UUID NOT NULL REFERENCES gluster_volumes(id) ON DELETE CASCADE,
+    total_space BIGINT,
+    used_space BIGINT,
+    free_space BIGINT,
+    _update_date TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT LOCALTIMESTAMP,
+    CONSTRAINT pk_gluster_volume_details PRIMARY KEY(volume_id)
+) WITH OIDS;
+
+-- Add gluster_volume_brick_details table
+CREATE TABLE gluster_volume_brick_details
+(
+    brick_id UUID NOT NULL REFERENCES gluster_volume_bricks(id) ON DELETE 
CASCADE,
+    total_space BIGINT,
+    used_space BIGINT,
+    free_space BIGINT,
+    _update_date TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT LOCALTIMESTAMP,
+    CONSTRAINT pk_gluster_volume_brick_details PRIMARY KEY(brick_id)
+) WITH OIDS;
diff --git 
a/packaging/dbscripts/upgrade/03_05_0020_gluster_refresh_gluster_volume_details-event_map.sql
 
b/packaging/dbscripts/upgrade/03_05_0020_gluster_refresh_gluster_volume_details-event_map.sql
new file mode 100644
index 0000000..4241b9f
--- /dev/null
+++ 
b/packaging/dbscripts/upgrade/03_05_0020_gluster_refresh_gluster_volume_details-event_map.sql
@@ -0,0 +1,3 @@
+insert into event_map(event_up_name, event_down_name) 
values('GLUSTER_VOLUME_DETAILS_REFRESH', 'UNASSIGNED');
+insert into event_map(event_up_name, event_down_name) 
values('GLUSTER_VOLUME_DETAILS_REFRESH_FAILED', 'UNASSIGNED');
+


-- 
To view, visit http://gerrit.ovirt.org/24517
To unsubscribe, visit http://gerrit.ovirt.org/settings

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

Reply via email to