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 <[email protected]> Authored: Sun Dec 22 22:38:37 2013 +0530 Committer: Sajith Kariyawasam <[email protected]> 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 */;
