Adding database creation command to mysqlscript.sql file
Project: http://git-wip-us.apache.org/repos/asf/stratos/repo Commit: http://git-wip-us.apache.org/repos/asf/stratos/commit/8eb8de21 Tree: http://git-wip-us.apache.org/repos/asf/stratos/tree/8eb8de21 Diff: http://git-wip-us.apache.org/repos/asf/stratos/diff/8eb8de21 Branch: refs/heads/stratos-4.1.x Commit: 8eb8de21b3d1d4808793fcdab6fd45ca00861f2b Parents: dfa4486 Author: Thanuja <[email protected]> Authored: Tue Sep 29 09:38:19 2015 +0530 Committer: Imesh Gunaratne <[email protected]> Committed: Tue Sep 29 14:40:49 2015 +0530 ---------------------------------------------------------------------- extensions/das/metering-service/capps/mysqlscript.sql | 1 + 1 file changed, 1 insertion(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/stratos/blob/8eb8de21/extensions/das/metering-service/capps/mysqlscript.sql ---------------------------------------------------------------------- diff --git a/extensions/das/metering-service/capps/mysqlscript.sql b/extensions/das/metering-service/capps/mysqlscript.sql index f198060..7e783a9 100644 --- a/extensions/das/metering-service/capps/mysqlscript.sql +++ b/extensions/das/metering-service/capps/mysqlscript.sql @@ -1,3 +1,4 @@ +CREATE DATABASE ANALYTICS_PROCESSED_DATA_STORE; CREATE TABLE ANALYTICS_PROCESSED_DATA_STORE.MEMBER_STATUS(Time long, ApplicationId VARCHAR(150), ClusterAlias VARCHAR(150), MemberId VARCHAR(150), MemberStatus VARCHAR(50)); CREATE TABLE ANALYTICS_PROCESSED_DATA_STORE.MEMBER_COUNT(Time long, ApplicationId VARCHAR(150), ClusterAlias VARCHAR(150), CreatedInstanceCount int, InitializedInstanceCount int, ActiveInstanceCount int, TerminatedInstanceCount int); CREATE TABLE ANALYTICS_PROCESSED_DATA_STORE.SCALING_DETAILS(Time VARCHAR(50), ScalingDecisionId VARCHAR(150), ClusterId VARCHAR(150), MinInstanceCount INT, MaxInstanceCount INT, RIFPredicted INT, RIFThreshold INT ,RIFRequiredInstances INT, MCPredicted INT, MCThreshold INT, MCRequiredInstances INT ,LAPredicted INT, LAThreshold INT,LARequiredInstances INT,RequiredInstanceCount INT ,ActiveInstanceCount INT, AdditionalInstanceCount INT, ScalingReason VARCHAR(150));
