Repository: ambari Updated Branches: refs/heads/trunk 311619306 -> e87d962c8
AMBARI-16029: Ambari version history - Create DB table, constraints and sequence id. Project: http://git-wip-us.apache.org/repos/asf/ambari/repo Commit: http://git-wip-us.apache.org/repos/asf/ambari/commit/e87d962c Tree: http://git-wip-us.apache.org/repos/asf/ambari/tree/e87d962c Diff: http://git-wip-us.apache.org/repos/asf/ambari/diff/e87d962c Branch: refs/heads/trunk Commit: e87d962c8f5493f5f78e9fc5cb2a3c9a0b8b9afb Parents: 3116193 Author: Nahappan Somasundaram <nsomasunda...@hortonworks.com> Authored: Mon May 2 14:19:48 2016 -0700 Committer: Nahappan Somasundaram <nsomasunda...@hortonworks.com> Committed: Tue May 3 12:49:14 2016 -0700 ---------------------------------------------------------------------- .../src/main/resources/Ambari-DDL-Derby-CREATE.sql | 12 ++++++++++++ .../src/main/resources/Ambari-DDL-MySQL-CREATE.sql | 12 ++++++++++++ .../src/main/resources/Ambari-DDL-Oracle-CREATE.sql | 11 +++++++++++ .../main/resources/Ambari-DDL-Postgres-CREATE.sql | 13 +++++++++++++ .../Ambari-DDL-Postgres-EMBEDDED-CREATE.sql | 16 +++++++++++++++- .../resources/Ambari-DDL-SQLAnywhere-CREATE.sql | 12 ++++++++++++ .../main/resources/Ambari-DDL-SQLServer-CREATE.sql | 14 +++++++++++++- 7 files changed, 88 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/ambari/blob/e87d962c/ambari-server/src/main/resources/Ambari-DDL-Derby-CREATE.sql ---------------------------------------------------------------------- diff --git a/ambari-server/src/main/resources/Ambari-DDL-Derby-CREATE.sql b/ambari-server/src/main/resources/Ambari-DDL-Derby-CREATE.sql index 0cf3537..c902637 100644 --- a/ambari-server/src/main/resources/Ambari-DDL-Derby-CREATE.sql +++ b/ambari-server/src/main/resources/Ambari-DDL-Derby-CREATE.sql @@ -830,6 +830,16 @@ CREATE TABLE servicecomponent_history( CONSTRAINT FK_sc_history_to_stack_id FOREIGN KEY (to_stack_id) REFERENCES stack (stack_id) ); +CREATE TABLE ambari_operation_history( + id BIGINT NOT NULL, + from_version VARCHAR(255) NOT NULL, + to_version VARCHAR(255) NOT NULL, + start_time BIGINT NOT NULL, + end_time BIGINT, + operation_type VARCHAR(255) NOT NULL, + comments CLOB, + CONSTRAINT PK_ambari_operation_history PRIMARY KEY (id) +); -- tasks indices -- CREATE INDEX idx_stage_request_id ON stage (request_id); @@ -1080,6 +1090,8 @@ INSERT INTO ambari_sequences (sequence_name, sequence_value) select 'servicecomponent_history_id_seq', 0 FROM SYSIBM.SYSDUMMY1 union all select 'blueprint_setting_id_seq', 0 FROM SYSIBM.SYSDUMMY1; + union all + select 'ambari_operation_history_id_seq', 0 FROM SYSIBM.SYSDUMMY1; INSERT INTO adminresourcetype (resource_type_id, resource_type_name) http://git-wip-us.apache.org/repos/asf/ambari/blob/e87d962c/ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql ---------------------------------------------------------------------- diff --git a/ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql b/ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql index 2142eb6..fca3be3 100644 --- a/ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql +++ b/ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql @@ -837,6 +837,17 @@ CREATE TABLE servicecomponent_history( CONSTRAINT FK_sc_history_to_stack_id FOREIGN KEY (to_stack_id) REFERENCES stack (stack_id) ); +CREATE TABLE ambari_operation_history( + id BIGINT NOT NULL, + from_version VARCHAR(255) NOT NULL, + to_version VARCHAR(255) NOT NULL, + start_time BIGINT NOT NULL, + end_time BIGINT, + operation_type VARCHAR(255) NOT NULL, + comments TEXT, + CONSTRAINT PK_ambari_operation_history PRIMARY KEY (id) +); + -- tasks indices -- CREATE INDEX idx_stage_request_id ON stage (request_id); CREATE INDEX idx_hrc_request_id ON host_role_command (request_id); @@ -1038,6 +1049,7 @@ INSERT INTO ambari_sequences(sequence_name, sequence_value) values ('hostcompone INSERT INTO ambari_sequences(sequence_name, sequence_value) values ('servicecomponentdesiredstate_id_seq', 0); INSERT INTO ambari_sequences(sequence_name, sequence_value) values ('servicecomponent_history_id_seq', 0); INSERT INTO ambari_sequences(sequence_name, sequence_value) values ('blueprint_setting_id_seq', 0); +INSERT INTO ambari_sequences(sequence_name, sequence_value) values ('ambari_operation_history_id_seq', 0); insert into adminresourcetype (resource_type_id, resource_type_name) select 1, 'AMBARI' http://git-wip-us.apache.org/repos/asf/ambari/blob/e87d962c/ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql ---------------------------------------------------------------------- diff --git a/ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql b/ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql index a118ffa..ce0bd84 100644 --- a/ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql +++ b/ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql @@ -827,6 +827,16 @@ CREATE TABLE servicecomponent_history( CONSTRAINT FK_sc_history_to_stack_id FOREIGN KEY (to_stack_id) REFERENCES stack (stack_id) ); +CREATE TABLE ambari_operation_history( + id NUMBER(19) NOT NULL, + from_version VARCHAR2(255) NOT NULL, + to_version VARCHAR2(255) NOT NULL, + start_time NUMBER(19) NOT NULL, + end_time NUMBER(19), + operation_type VARCHAR2(255) NOT NULL, + comments CLOB, + CONSTRAINT PK_ambari_operation_history PRIMARY KEY (id) +); -- tasks indices -- CREATE INDEX idx_stage_request_id ON stage (request_id); @@ -1030,6 +1040,7 @@ INSERT INTO ambari_sequences(sequence_name, sequence_value) values ('hostcompone INSERT INTO ambari_sequences(sequence_name, sequence_value) values ('servicecomponentdesiredstate_id_seq', 0); INSERT INTO ambari_sequences(sequence_name, sequence_value) values ('servicecomponent_history_id_seq', 0); INSERT INTO ambari_sequences(sequence_name, sequence_value) values ('blueprint_setting_id_seq', 0); +INSERT INTO ambari_sequences(sequence_name, sequence_value) values ('ambari_operation_history_id_seq', 0); INSERT INTO metainfo("metainfo_key", "metainfo_value") values ('version', '${ambariSchemaVersion}'); http://git-wip-us.apache.org/repos/asf/ambari/blob/e87d962c/ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql ---------------------------------------------------------------------- diff --git a/ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql b/ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql index 3032dbf..85cc0be 100644 --- a/ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql +++ b/ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql @@ -829,6 +829,17 @@ CREATE TABLE servicecomponent_history( CONSTRAINT FK_sc_history_to_stack_id FOREIGN KEY (to_stack_id) REFERENCES stack (stack_id) ); +CREATE TABLE ambari_operation_history( + id BIGINT NOT NULL, + from_version VARCHAR(255) NOT NULL, + to_version VARCHAR(255) NOT NULL, + start_time BIGINT NOT NULL, + end_time BIGINT, + operation_type VARCHAR(255) NOT NULL, + comments TEXT, + CONSTRAINT PK_ambari_operation_history PRIMARY KEY (id) +); + -- tasks indices -- CREATE INDEX idx_stage_request_id ON stage (request_id); CREATE INDEX idx_hrc_request_id ON host_role_command (request_id); @@ -1076,6 +1087,8 @@ INSERT INTO ambari_sequences (sequence_name, sequence_value) select 'servicecomponent_history_id_seq', 0 union all select 'blueprint_setting_id_seq', 0; + union all + select 'ambari_operation_history_id_seq', 0; INSERT INTO adminresourcetype (resource_type_id, resource_type_name) http://git-wip-us.apache.org/repos/asf/ambari/blob/e87d962c/ambari-server/src/main/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql ---------------------------------------------------------------------- diff --git a/ambari-server/src/main/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql b/ambari-server/src/main/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql index af6e319..0f3a2c2 100644 --- a/ambari-server/src/main/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql +++ b/ambari-server/src/main/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql @@ -964,10 +964,22 @@ CREATE TABLE ambari.servicecomponent_history( CONSTRAINT FK_sc_history_to_stack_id FOREIGN KEY (to_stack_id) REFERENCES ambari.stack (stack_id) ); +CREATE TABLE ambari.ambari_operation_history( + id BIGINT NOT NULL, + from_version VARCHAR(255) NOT NULL, + to_version VARCHAR(255) NOT NULL, + start_time BIGINT NOT NULL, + end_time BIGINT, + operation_type VARCHAR(255) NOT NULL, + comments TEXT, + CONSTRAINT PK_ambari_operation_history PRIMARY KEY (id) +); + GRANT ALL PRIVILEGES ON TABLE ambari.upgrade TO :username; GRANT ALL PRIVILEGES ON TABLE ambari.upgrade_group TO :username; GRANT ALL PRIVILEGES ON TABLE ambari.upgrade_item TO :username; GRANT ALL PRIVILEGES ON TABLE ambari.servicecomponent_history TO :username; +GRANT ALL PRIVILEGES ON TABLE ambari.ambari_operation_history TO :username; -- tasks indices -- CREATE INDEX idx_stage_request_id ON ambari.stage (request_id); @@ -1232,7 +1244,9 @@ INSERT INTO ambari.ambari_sequences (sequence_name, sequence_value) union all select 'servicecomponent_history_id_seq', 0 union all - select 'blueprint_setting_id_seq', 0; + select 'blueprint_setting_id_seq', 0 + union all + select 'ambari_operation_history_id_seq', 0; INSERT INTO ambari.adminresourcetype (resource_type_id, resource_type_name) SELECT 1, 'AMBARI' http://git-wip-us.apache.org/repos/asf/ambari/blob/e87d962c/ambari-server/src/main/resources/Ambari-DDL-SQLAnywhere-CREATE.sql ---------------------------------------------------------------------- diff --git a/ambari-server/src/main/resources/Ambari-DDL-SQLAnywhere-CREATE.sql b/ambari-server/src/main/resources/Ambari-DDL-SQLAnywhere-CREATE.sql index 37acfea..b89389c 100644 --- a/ambari-server/src/main/resources/Ambari-DDL-SQLAnywhere-CREATE.sql +++ b/ambari-server/src/main/resources/Ambari-DDL-SQLAnywhere-CREATE.sql @@ -826,6 +826,17 @@ CREATE TABLE servicecomponent_history( CONSTRAINT FK_sc_history_to_stack_id FOREIGN KEY (to_stack_id) REFERENCES stack (stack_id) ); +CREATE TABLE ambari_operation_history( + id NUMERIC(19) NOT NULL, + from_version VARCHAR(255) NOT NULL, + to_version VARCHAR(255) NOT NULL, + start_time NUMERIC(19) NOT NULL, + end_time NUMERIC(19), + operation_type VARCHAR(255) NOT NULL, + comments TEXT, + CONSTRAINT PK_ambari_operation_history PRIMARY KEY (id) +); + -- tasks indices -- CREATE INDEX idx_stage_request_id ON stage (request_id); @@ -1028,6 +1039,7 @@ INSERT INTO ambari_sequences(sequence_name, sequence_value) values ('hostcompone INSERT INTO ambari_sequences(sequence_name, sequence_value) values ('servicecomponentdesiredstate_id_seq', 0); INSERT INTO ambari_sequences(sequence_name, sequence_value) values ('servicecomponent_history_id_seq', 0); INSERT INTO ambari_sequences(sequence_name, sequence_value) values ('blueprint_setting_id_seq', 0); +INSERT INTO ambari_sequences(sequence_name, sequence_value) values ('ambari_operation_history_id_seq', 0); insert into adminresourcetype (resource_type_id, resource_type_name) select 1, 'AMBARI' http://git-wip-us.apache.org/repos/asf/ambari/blob/e87d962c/ambari-server/src/main/resources/Ambari-DDL-SQLServer-CREATE.sql ---------------------------------------------------------------------- diff --git a/ambari-server/src/main/resources/Ambari-DDL-SQLServer-CREATE.sql b/ambari-server/src/main/resources/Ambari-DDL-SQLServer-CREATE.sql index b97403f..1107c4d 100644 --- a/ambari-server/src/main/resources/Ambari-DDL-SQLServer-CREATE.sql +++ b/ambari-server/src/main/resources/Ambari-DDL-SQLServer-CREATE.sql @@ -847,6 +847,17 @@ CREATE TABLE servicecomponent_history( CONSTRAINT FK_sc_history_to_stack_id FOREIGN KEY (to_stack_id) REFERENCES stack (stack_id) ); +CREATE TABLE ambari_operation_history( + id BIGINT NOT NULL, + from_version VARCHAR(255) NOT NULL, + to_version VARCHAR(255) NOT NULL, + start_time BIGINT NOT NULL, + end_time BIGINT, + operation_type VARCHAR(255) NOT NULL, + comments TEXT, + CONSTRAINT PK_ambari_operation_history PRIMARY KEY (id) +); + -- tasks indices -- CREATE INDEX idx_stage_request_id ON stage (request_id); @@ -1053,7 +1064,8 @@ BEGIN TRANSACTION ('hostcomponentstate_id_seq', 0), ('servicecomponentdesiredstate_id_seq', 0), ('servicecomponent_history_id_seq', 0), - ('blueprint_setting_id_seq', 0); + ('blueprint_setting_id_seq', 0), + ('ambari_operation_history_id_seq', 0); insert into adminresourcetype (resource_type_id, resource_type_name) values