You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@stratos.apache.org by sa...@apache.org on 2013/12/22 18:08:58 UTC
git commit: Adding a table to persist service deployment information
Updated Branches:
refs/heads/master 143619358 -> 4b3fdc25a
Adding a table to persist service deployment information
Project: http://git-wip-us.apache.org/repos/asf/incubator-stratos/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-stratos/commit/4b3fdc25
Tree: http://git-wip-us.apache.org/repos/asf/incubator-stratos/tree/4b3fdc25
Diff: http://git-wip-us.apache.org/repos/asf/incubator-stratos/diff/4b3fdc25
Branch: refs/heads/master
Commit: 4b3fdc25a86979d20cfea2a95600297055ce7cc1
Parents: 1436193
Author: Sajith Kariyawasam <sa...@wso2.com>
Authored: Sun Dec 22 22:38:37 2013 +0530
Committer: Sajith Kariyawasam <sa...@wso2.com>
Committed: Sun Dec 22 22:38:37 2013 +0530
----------------------------------------------------------------------
.../dbscripts/stratos_mysql.sql | 21 +++++++++++++++++++-
.../resources/stratos_foundation.sql | 18 +++++++++++++++++
2 files changed, 38 insertions(+), 1 deletion(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/4b3fdc25/products/stratos-controller/dbscripts/stratos_mysql.sql
----------------------------------------------------------------------
diff --git a/products/stratos-controller/dbscripts/stratos_mysql.sql b/products/stratos-controller/dbscripts/stratos_mysql.sql
index ce32a3b..9b2393b 100644
--- a/products/stratos-controller/dbscripts/stratos_mysql.sql
+++ b/products/stratos-controller/dbscripts/stratos_mysql.sql
@@ -76,10 +76,11 @@ CREATE TABLE `stratos_foundation`.`CARTRIDGE_SUBSCRIPTION` (
`STATE` varchar(30) NOT NULL,
`ALIAS` varchar(255) NOT NULL,
`TENANT_DOMAIN` varchar(255) NOT NULL,
- `BASE_DIR` varchar(255) NOT NULL,
+ `BASE_DIR` varchar(255) NULL,
`REPO_ID` int(11) DEFAULT NULL,
`DATA_CARTRIDGE_ID` int(11) DEFAULT NULL,
`MAPPED_DOMAIN` varchar(255),
+ `SUBSCRIPTION_KEY` varchar(255) NOT NULL,
PRIMARY KEY (`SUBSCRIPTION_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
@@ -131,6 +132,24 @@ CREATE TABLE `stratos_foundation`.`REPOSITORY` (
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
+--
+-- Definition of table `stratos_foundation`.`SERVICE`
+--
+DROP TABLE IF EXISTS `stratos_foundation`.`SERVICE`;
+CREATE TABLE `stratos_foundation`.`SERVICE` (
+ `SERVICE_ID` int NOT NULL AUTO_INCREMENT,
+ `TYPE` varchar(255) NOT NULL,
+ `AUTOSCALING_POLICY` varchar(255) NOT NULL,
+ `DEPLOYMENT_POLICY` varchar(255) NOT NULL,
+ `TENANT_RANGE` varchar(255) NOT NULL,
+ `CLUSTER_ID` varchar(255) NOT NULL,
+ `HOST_NAME` varchar(255) NOT NULL,
+ `SUBSCRIPTION_KEY` varchar(255) NOT NULL,
+ PRIMARY KEY (`SERVICE_ID`)
+) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
+
+
+
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/4b3fdc25/tools/stratos-installer/resources/stratos_foundation.sql
----------------------------------------------------------------------
diff --git a/tools/stratos-installer/resources/stratos_foundation.sql b/tools/stratos-installer/resources/stratos_foundation.sql
index a8dce27..a6a2d74 100644
--- a/tools/stratos-installer/resources/stratos_foundation.sql
+++ b/tools/stratos-installer/resources/stratos_foundation.sql
@@ -132,6 +132,24 @@ CREATE TABLE `stratos_foundation`.`REPOSITORY` (
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
+--
+-- Definition of table `stratos_foundation`.`SERVICE`
+--
+DROP TABLE IF EXISTS `stratos_foundation`.`SERVICE`;
+CREATE TABLE `stratos_foundation`.`SERVICE` (
+ `SERVICE_ID` int NOT NULL AUTO_INCREMENT,
+ `TYPE` varchar(255) NOT NULL,
+ `AUTOSCALING_POLICY` varchar(255) NOT NULL,
+ `DEPLOYMENT_POLICY` varchar(255) NOT NULL,
+ `TENANT_RANGE` varchar(255) NOT NULL,
+ `CLUSTER_ID` varchar(255) NOT NULL,
+ `HOST_NAME` varchar(255) NOT NULL,
+ `SUBSCRIPTION_KEY` varchar(255) NOT NULL,
+ PRIMARY KEY (`SERVICE_ID`)
+) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
+
+
+
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;