Repository: ambari Updated Branches: refs/heads/trunk bc5d82cad -> 6ee984734
AMBARI-5554 - Ambari Views : Persistence Data Store Project: http://git-wip-us.apache.org/repos/asf/ambari/repo Commit: http://git-wip-us.apache.org/repos/asf/ambari/commit/6ee98473 Tree: http://git-wip-us.apache.org/repos/asf/ambari/tree/6ee98473 Diff: http://git-wip-us.apache.org/repos/asf/ambari/diff/6ee98473 Branch: refs/heads/trunk Commit: 6ee9847342cefeeb372ccd3f53ba855a0e3bd23b Parents: bc5d82c Author: tbeerbower <[email protected]> Authored: Fri Apr 25 13:03:35 2014 -0400 Committer: tbeerbower <[email protected]> Committed: Fri Apr 25 13:46:19 2014 -0400 ---------------------------------------------------------------------- .../main/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/ambari/blob/6ee98473/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 6d14ede..cbf8579 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 @@ -135,12 +135,14 @@ CREATE TABLE ambari.viewinstance (view_name VARCHAR(255) NOT NULL, name VARCHAR( CREATE TABLE ambari.viewinstanceproperty (view_name VARCHAR(255) NOT NULL, view_instance_name VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, value VARCHAR(2000) NOT NULL, PRIMARY KEY(view_name, view_instance_name, name)); CREATE TABLE ambari.viewparameter (view_name VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, description VARCHAR(255), required CHAR(1), PRIMARY KEY(view_name, name)); CREATE TABLE ambari.viewresource (view_name VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, plural_name VARCHAR(255), id_property VARCHAR(255), subResource_names VARCHAR(255), provider VARCHAR(255), service VARCHAR(255), resource VARCHAR(255), PRIMARY KEY(view_name, name)); +CREATE TABLE ambari.viewentity (id BIGINT NOT NULL, view_name VARCHAR(255) NOT NULL, view_instance_name VARCHAR(255) NOT NULL, class_name VARCHAR(255) NOT NULL, id_property VARCHAR(255), PRIMARY KEY(id)); GRANT ALL PRIVILEGES ON TABLE ambari.viewmain TO :username; GRANT ALL PRIVILEGES ON TABLE ambari.viewinstancedata TO :username; GRANT ALL PRIVILEGES ON TABLE ambari.viewinstance TO :username; GRANT ALL PRIVILEGES ON TABLE ambari.viewinstanceproperty TO :username; GRANT ALL PRIVILEGES ON TABLE ambari.viewparameter TO :username; GRANT ALL PRIVILEGES ON TABLE ambari.viewresource TO :username; +GRANT ALL PRIVILEGES ON TABLE ambari.viewentity TO :username; --------altering tables by creating foreign keys---------- ALTER TABLE ambari.clusterconfig ADD CONSTRAINT FK_clusterconfig_cluster_id FOREIGN KEY (cluster_id) REFERENCES ambari.clusters (cluster_id); @@ -184,6 +186,7 @@ ALTER TABLE ambari.viewresource ADD CONSTRAINT FK_viewres_view_name FOREIGN KEY ALTER TABLE ambari.viewinstance ADD CONSTRAINT FK_viewinst_view_name FOREIGN KEY (view_name) REFERENCES viewmain(view_name); ALTER TABLE ambari.viewinstanceproperty ADD CONSTRAINT FK_viewinstprop_view_name FOREIGN KEY (view_name, view_instance_name) REFERENCES viewinstance(view_name, name); ALTER TABLE ambari.viewinstancedata ADD CONSTRAINT FK_viewinstdata_view_name FOREIGN KEY (view_name, view_instance_name) REFERENCES viewinstance(view_name, name); +ALTER TABLE ambari.viewentity ADD CONSTRAINT FK_viewentity_view_name FOREIGN KEY (view_name, view_instance_name) REFERENCES viewinstance(view_name, name); ---------inserting some data----------- @@ -199,7 +202,10 @@ INSERT INTO ambari.ambari_sequences (sequence_name, "value") union all select 'requestschedule_id_seq', 1 union all - select 'resourcefilter_id_seq', 1; + select 'resourcefilter_id_seq', 1 + union all + select 'viewentity_id_seq', 0; + INSERT INTO ambari.Roles (role_name) SELECT 'admin'
