Eli Mesika has uploaded a new change for review. Change subject: core: squash 03_00_0130_change_dwh_history_timekeeping_date_type.sql ......................................................................
core: squash 03_00_0130_change_dwh_history_timekeeping_date_type.sql Change-Id: I4ec50e9454d033fdacc0e9a60eedadf08f986708 Signed-off-by: Eli Mesika <[email protected]> --- M backend/manager/dbscripts/create_tables.sql M backend/manager/dbscripts/insert_data.sql D backend/manager/dbscripts/upgrade/03_00_0130_change_dwh_history_timekeeping_date_type.sql 3 files changed, 11 insertions(+), 9 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/58/15458/1 diff --git a/backend/manager/dbscripts/create_tables.sql b/backend/manager/dbscripts/create_tables.sql index 5007d3f..ffd3de5 100644 --- a/backend/manager/dbscripts/create_tables.sql +++ b/backend/manager/dbscripts/create_tables.sql @@ -1122,7 +1122,7 @@ ( var_name VARCHAR(50) NOT NULL, var_value VARCHAR(255), -var_datetime TIMESTAMP +var_datetime TIMESTAMP WITH TIME ZONE ) WITH OIDS; -- ---------------------------------------------------------------------- diff --git a/backend/manager/dbscripts/insert_data.sql b/backend/manager/dbscripts/insert_data.sql index 05e3e3f..9cedff8 100644 --- a/backend/manager/dbscripts/insert_data.sql +++ b/backend/manager/dbscripts/insert_data.sql @@ -78,3 +78,13 @@ select insert_data(); drop function insert_data(); + +/****************************************************************************************************** + DWH DATA +******************************************************************************************************/ + +-- Inserting data to history timekeeping for host sync of slow changing data in dynamic configuration and statistical tables. + +Insert into dwh_history_timekeeping SELECT 'lastFullHostCheck',NULL,to_timestamp('01/01/2000', 'DD/MM/YYYY') WHERE not exists (SELECT var_name FROM dwh_history_timekeeping WHERE var_name ='lastFullHostCheck'); + + diff --git a/backend/manager/dbscripts/upgrade/03_00_0130_change_dwh_history_timekeeping_date_type.sql b/backend/manager/dbscripts/upgrade/03_00_0130_change_dwh_history_timekeeping_date_type.sql deleted file mode 100644 index 4e3b233..0000000 --- a/backend/manager/dbscripts/upgrade/03_00_0130_change_dwh_history_timekeeping_date_type.sql +++ /dev/null @@ -1,8 +0,0 @@ --- change var_datetime in table dwh_history_timekeeping to save time zone - -select fn_db_change_column_type('dwh_history_timekeeping','var_datetime','timestamp without time zone','timestamp with time zone'); - --- Inserting data to history timekeeping for host sync of slow changing data in dynamic configuration and statistical tables. - -Insert into dwh_history_timekeeping SELECT 'lastFullHostCheck',NULL,to_timestamp('01/01/2000', 'DD/MM/YYYY') WHERE not exists (SELECT var_name FROM dwh_history_timekeeping WHERE var_name ='lastFullHostCheck'); - -- To view, visit http://gerrit.ovirt.org/15458 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I4ec50e9454d033fdacc0e9a60eedadf08f986708 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Eli Mesika <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
