Martin Peřina has posted comments on this change. Change subject: core: Add ExternalVariable entity ......................................................................
Patch Set 2: (2 comments) http://gerrit.ovirt.org/#/c/27934/2/packaging/dbscripts/upgrade/03_05_0490_add_external_variable.sql File packaging/dbscripts/upgrade/03_05_0490_add_external_variable.sql: Line 2: -- Table is used to exchange data with external systems Line 3: -- Line 4: CREATE TABLE external_variable ( Line 5: var_name VARCHAR(50) NOT NULL, Line 6: var_value VARCHAR(255), > I would go here for text data type as in vdc_options Do you mean to change it to VARCHAR(4000) same as option_value in vdc_options? Line 7: updated TIMESTAMP WITH TIME ZONE NOT NULL, Line 8: CONSTRAINT pk_external_variable PRIMARY KEY(var_name) Line 9: ) WITH OIDS; Line 10: Line 7: updated TIMESTAMP WITH TIME ZONE NOT NULL, Line 8: CONSTRAINT pk_external_variable PRIMARY KEY(var_name) Line 9: ) WITH OIDS; Line 10: Line 11: CREATE INDEX idx_external_variable_updated ON external_variable(updated); > I don't see anything in the SPs that selected according to the updated colu Well, currently I don't need to select records update from, so I will remove this index. -- To view, visit http://gerrit.ovirt.org/27934 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: comment Gerrit-Change-Id: I61ffd646c102c01c34478309d072f74a8f7d7edf Gerrit-PatchSet: 2 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Martin Peřina <mper...@redhat.com> Gerrit-Reviewer: Barak Azulay <bazu...@redhat.com> Gerrit-Reviewer: Eli Mesika <emes...@redhat.com> Gerrit-Reviewer: Martin Peřina <mper...@redhat.com> Gerrit-Reviewer: Oved Ourfali <oourf...@redhat.com> Gerrit-Reviewer: automat...@ovirt.org Gerrit-Reviewer: oVirt Jenkins CI Server Gerrit-HasComments: Yes _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
