Sahina Bose has uploaded a new change for review. Change subject: engine: Added tables for geo replication entities ......................................................................
engine: Added tables for geo replication entities Added sql script to create tables for geo-rep related entities Change-Id: I231092cfc969030e144a7ddd08187ce1c47a29db Signed-off-by: Sahina Bose <sab...@redhat.com> --- A packaging/dbscripts/upgrade/03_06_0010_gluster_georep_tables.sql 1 file changed, 47 insertions(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/47/29947/1 diff --git a/packaging/dbscripts/upgrade/03_06_0010_gluster_georep_tables.sql b/packaging/dbscripts/upgrade/03_06_0010_gluster_georep_tables.sql new file mode 100644 index 0000000..50c4c96 --- /dev/null +++ b/packaging/dbscripts/upgrade/03_06_0010_gluster_georep_tables.sql @@ -0,0 +1,47 @@ +-- Add gluster_georep_session table +CREATE TABLE gluster_georep_session +( + session_id UUID NOT NULL, + master_volume_id UUID NOT NULL, + session_key VARCHAR(150) NOT NULL, + slave_host_name VARCHAR(50), + slave_host_uuid UUID, + slave_volume_name VARCHAR(50), + status VARCHAR, + _create_date TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT LOCALTIMESTAMP, + _update_date TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT LOCALTIMESTAMP, + CONSTRAINT pk_gluster_georep_session PRIMARY KEY(session_id) +) WITH OIDS; +CREATE UNIQUE INDEX IDX_gluster_georep_session_unique ON gluster_georep_session(master_volume_id, session_key); + +-- Add gluster_georep_config +CREATE TABLE gluster_georep_config +( + session_id UUID NOT NULL REFERENCES gluster_georep_session(session_id) ON DELETE CASCADE, + config_key VARCHAR(50), + config_value VARCHAR(50), + _update_date TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT LOCALTIMESTAMP, + CONSTRAINT pk_gluster_georep_config PRIMARY KEY(session_id, config_key) +) WITH OIDS; + +-- Add gluster_georep_session_details table +CREATE TABLE gluster_georep_session_details +( + session_id UUID NOT NULL REFERENCES gluster_georep_session(session_id) ON DELETE CASCADE, + master_brick_id UUID NOT NULL REFERENCES gluster_volume_bricks(id), + slave_host_name VARCHAR(50) NOT NULL, + slave_host_uuid UUID NOT NULL, + status VARCHAR(20), + checkpoint_status VARCHAR(20), + crawl_status VARCHAR(20), + files_synced BIGINT, + files_pending BIGINT, + bytes_pending BIGINT, + deletes_pending BIGINT, + files_skipped BIGINT, + _update_date TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT LOCALTIMESTAMP, + CONSTRAINT pk_gluster_georep_session_details PRIMARY KEY(session_id, master_brick_id) +) WITH OIDS; + +ALTER TABLE ONLY gluster_georep_session + ADD CONSTRAINT fk_gluster_georep_session_vol_id FOREIGN KEY (master_volume_id) REFERENCES gluster_volumes(id) ON DELETE CASCADE; -- To view, visit http://gerrit.ovirt.org/29947 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I231092cfc969030e144a7ddd08187ce1c47a29db Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Sahina Bose <sab...@redhat.com> _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
