Moti Asayag has posted comments on this change.

Change subject: <WIP>engine: add feature comptability check for VDS
......................................................................


Patch Set 6:

(3 comments)

https://gerrit.ovirt.org/#/c/39756/6/packaging/dbscripts/upgrade/03_06_1250_add_cluster_features_table.sql
File packaging/dbscripts/upgrade/03_06_1250_add_cluster_features_table.sql:

Line 4: -- 
----------------------------------------------------------------------
Line 5: 
Line 6: CREATE TABLE cluster_features
Line 7: (
Line 8:   vds_group_id UUID NOT NULL,
s/vds_group_id/cluster_id
Line 9:   feature varchar(256) NOT NULL,
Line 10:   is_enabled BOOLEAN,
Line 11:   CONSTRAINT PK_cluster_features PRIMARY KEY (vds_group_id, feature),
Line 12:   FOREIGN KEY (vds_group_id) REFERENCES vds_groups(vds_group_id) ON 
DELETE CASCADE


Line 6: CREATE TABLE cluster_features
Line 7: (
Line 8:   vds_group_id UUID NOT NULL,
Line 9:   feature varchar(256) NOT NULL,
Line 10:   is_enabled BOOLEAN,
is there a chance that a feature which isn't enabled for this cluster should 
appear in the table ?
Line 11:   CONSTRAINT PK_cluster_features PRIMARY KEY (vds_group_id, feature),
Line 12:   FOREIGN KEY (vds_group_id) REFERENCES vds_groups(vds_group_id) ON 
DELETE CASCADE
Line 13: ) ;
Line 14: 


Line 14: 
Line 15: CREATE UNIQUE INDEX IDX_cluster_features ON 
cluster_features(vds_group_id, feature);
Line 16: 
Line 17: -- Comma separated values of all the features supported by the VDSM
Line 18: select fn_db_add_column('vds_dynamic', 'supported_features', 'TEXT');
> so , this should be host_features
this is already a host table (vds_dynamic) so don't think we should repeat the 
host as a prefix. This field 'supported_features' represents the features which 
are supported by the host, as reported by vdsm.


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

Gerrit-MessageType: comment
Gerrit-Change-Id: Icba02b189a169bc676e0c5f47f7aaf394f0b49a6
Gerrit-PatchSet: 6
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Ramesh N <[email protected]>
Gerrit-Reviewer: Eli Mesika <[email protected]>
Gerrit-Reviewer: Kanagaraj M <[email protected]>
Gerrit-Reviewer: Moti Asayag <[email protected]>
Gerrit-Reviewer: Oved Ourfali <[email protected]>
Gerrit-Reviewer: Ramesh N <[email protected]>
Gerrit-Reviewer: Sahina Bose <[email protected]>
Gerrit-Reviewer: Shubhendu Tripathi <[email protected]>
Gerrit-Reviewer: [email protected]
Gerrit-Reviewer: oVirt Jenkins CI Server
Gerrit-HasComments: Yes
_______________________________________________
Engine-patches mailing list
[email protected]
http://lists.ovirt.org/mailman/listinfo/engine-patches

Reply via email to