You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@stratos.apache.org by is...@apache.org on 2014/04/01 14:29:05 UTC
git commit: Remove unnecessary files and changes for stratos-setup.sh
Repository: incubator-stratos
Updated Branches:
refs/heads/master f402bada0 -> 4762e5d10
Remove unnecessary files and changes for stratos-setup.sh
Signed-off-by: M. Isuru Tharanga Chrishantha Perera <is...@apache.org>
Project: http://git-wip-us.apache.org/repos/asf/incubator-stratos/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-stratos/commit/4762e5d1
Tree: http://git-wip-us.apache.org/repos/asf/incubator-stratos/tree/4762e5d1
Diff: http://git-wip-us.apache.org/repos/asf/incubator-stratos/diff/4762e5d1
Branch: refs/heads/master
Commit: 4762e5d104ca9c4e0da8902fe266103e069ebba9
Parents: f402bad
Author: Dinesh Bandara <di...@wso2.com>
Authored: Tue Apr 1 17:31:14 2014 +0530
Committer: M. Isuru Tharanga Chrishantha Perera <is...@apache.org>
Committed: Tue Apr 1 17:58:38 2014 +0530
----------------------------------------------------------------------
.../resources/add_entry_zone_file.sh | 70 ---
.../resources/billing-mysql.sql | 143 ------
.../resources/gitolite-suexec-wrapper.sh | 30 --
.../resources/metering_mysql.sql | 172 -------
tools/stratos-installer/resources/notify.php | 62 ---
tools/stratos-installer/resources/registry.sql | 407 ----------------
.../resources/remove_entry_zone_file.sh | 75 ---
.../resources/stratos_foundation.sql | 159 ------
tools/stratos-installer/resources/userstore.sql | 481 -------------------
tools/stratos-installer/stratos-setup.sh | 45 +-
10 files changed, 22 insertions(+), 1622 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/4762e5d1/tools/stratos-installer/resources/add_entry_zone_file.sh
----------------------------------------------------------------------
diff --git a/tools/stratos-installer/resources/add_entry_zone_file.sh b/tools/stratos-installer/resources/add_entry_zone_file.sh
deleted file mode 100644
index c9593e0..0000000
--- a/tools/stratos-installer/resources/add_entry_zone_file.sh
+++ /dev/null
@@ -1,70 +0,0 @@
-#!/bin/bash
-#
-#
-# Licensed to the Apache Software Foundation (ASF) under one
-# or more contributor license agreements. See the NOTICE file
-# distributed with this work for additional information
-# regarding copyright ownership. The ASF licenses this file
-# to you under the Apache License, Version 2.0 (the
-# "License"); you may not use this file except in compliance
-# with the License. You may obtain a copy of the License at
-#
-# http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing,
-# software distributed under the License is distributed on an
-# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-# KIND, either express or implied. See the License for the
-# specific language governing permissions and limitations
-# under the License.
-#
-#
-zone_file=$3
-subdomain=$1
-ip=$2
-
-# check the file
-if [ -f {$zone_file} ]; then
- echo "Error: zone does not exist"
- exit 1
-fi
-echo "File $zone_file exists"
-
-#appending the zone file
-echo "$subdomain IN A $ip">> $zone_file
-echo "Added subdomain to the file"
-
-# get serial number
-serial=$(grep 'Serial' $zone_file | awk '{print $1}')
-echo "Serial number " $serial
-# get serial number's date
-serialdate=$(echo $serial | cut -b 1-8)
-# get today's date in same style
-date=$(date +%Y%m%d)
-
-
-#Serial number's date
-serialdate=$(echo $serial | cut -b 1-8)
-echo "serial date" $serialdate
-# get today's date in same style
-date=$(date +%Y%m%d)
-echo "Now date" $date
-
-# compare date and serial date
-if [ $serialdate = $date ]
- then
- # if equal, just add 1
- newserial=$(expr $serial + 1)
- echo "same date"
- else
- # if not equal, make a new one and add 00
- newserial=$(echo $date"00")
-fi
-
-echo "Adding subdomain $1 and ip $2 to $3"
-sed -i "s/.*Serial.*/ \t\t\t\t$newserial ; Serial./" $zone_file
-
-
-
-#reloading bind server
-/etc/init.d/bind9 reload
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/4762e5d1/tools/stratos-installer/resources/billing-mysql.sql
----------------------------------------------------------------------
diff --git a/tools/stratos-installer/resources/billing-mysql.sql b/tools/stratos-installer/resources/billing-mysql.sql
deleted file mode 100644
index 07aca63..0000000
--- a/tools/stratos-installer/resources/billing-mysql.sql
+++ /dev/null
@@ -1,143 +0,0 @@
-/*
-* Licensed to the Apache Software Foundation (ASF) under one
-* or more contributor license agreements. See the NOTICE file
-* distributed with this work for additional information
-* regarding copyright ownership. The ASF licenses this file
-* to you under the Apache License, Version 2.0 (the
-* "License"); you may not use this file except in compliance
-* with the License. You may obtain a copy of the License at
-*
-* http://www.apache.org/licenses/LICENSE-2.0
-*
-* Unless required by applicable law or agreed to in writing,
-* software distributed under the License is distributed on an
-* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-* KIND, either express or implied. See the License for the
-* specific language governing permissions and limitations
-* under the License.
-*/
-
-CREATE DATABASE IF NOT EXISTS billing;
-USE billing;
-
-
-CREATE TABLE IF NOT EXISTS BC_CUSTOMER (
- BC_ID INTEGER AUTO_INCREMENT,
- BC_NAME VARCHAR (64),
- BC_STARTED_DATE TIMESTAMP,
- BC_EMAIL VARCHAR (64),
- BC_ADDRESS VARCHAR (256),
- CONSTRAINT PK_BC_CUSTOMER PRIMARY KEY (BC_ID)
-)ENGINE INNODB;
-
-CREATE INDEX BC_CUSTOMER_IND_BY_BC_NAME USING HASH ON BC_CUSTOMER(BC_NAME);
-CREATE INDEX BC_CUSTOMER_IND_BY_BC_EMAIL USING HASH ON BC_CUSTOMER(BC_EMAIL);
-
-CREATE TABLE IF NOT EXISTS BC_ITEM (
- BC_ID INTEGER AUTO_INCREMENT,
- BC_NAME VARCHAR (64),
- BC_COST VARCHAR (64),
- BC_DESCRIPTION VARCHAR(128),
- BC_PARENT_ITEM_ID INTEGER,
- CONSTRAINT PK_BC_ITEM PRIMARY KEY (BC_ID)
-)ENGINE INNODB;
-INSERT INTO BC_ITEM (BC_NAME,BC_COST,BC_DESCRIPTION,BC_PARENT_ITEM_ID) values ("Demo",NULL,NULL,NULL);
-INSERT INTO BC_ITEM (BC_NAME,BC_COST,BC_DESCRIPTION,BC_PARENT_ITEM_ID) values ("SMB",NULL,NULL,NULL);
-INSERT INTO BC_ITEM (BC_NAME,BC_COST,BC_DESCRIPTION,BC_PARENT_ITEM_ID) values ("Professional",NULL,NULL,NULL);
-INSERT INTO BC_ITEM (BC_NAME,BC_COST,BC_DESCRIPTION,BC_PARENT_ITEM_ID) values ("Enterprise",NULL,NULL,NULL);
-
-ALTER TABLE BC_ITEM ADD CONSTRAINT BC_ITEM_FK_BY_PARENT_ITEM_ID FOREIGN KEY (BC_PARENT_ITEM_ID) REFERENCES BC_ITEM (BC_ID);
-
-
-CREATE TABLE IF NOT EXISTS BC_SUBSCRIPTION (
- BC_ID INTEGER AUTO_INCREMENT,
- BC_FILTER VARCHAR (32),
- BC_IS_ACTIVE INTEGER,
- BC_ACTIVE_SINCE TIMESTAMP,
- BC_ACTIVE_UNTIL TIMESTAMP,
- BC_ITEM_ID INTEGER,
- BC_TENANT_ID INTEGER,
- CONSTRAINT PK_BC_SUBSCRIPTION PRIMARY KEY (BC_ID)
-)ENGINE INNODB;
-
-ALTER TABLE BC_SUBSCRIPTION ADD CONSTRAINT BC_SUBSCRIPTION_FK_BY_ITEM_ID FOREIGN KEY (BC_ITEM_ID) REFERENCES BC_ITEM (BC_ID);
-
-CREATE TABLE IF NOT EXISTS BC_INVOICE (
- BC_ID INTEGER AUTO_INCREMENT,
- BC_TENANT_ID INTEGER,
- BC_DATE TIMESTAMP,
- BC_START_DATE TIMESTAMP,
- BC_END_DATE TIMESTAMP,
- BC_BOUGHT_FORWARD VARCHAR (64),
- BC_CARRIED_FORWARD VARCHAR (64),
- BC_TOTAL_PAYMENTS VARCHAR (64),
- BC_TOTAL_COST VARCHAR (64),
- CONSTRAINT PK_BC_INVOICE PRIMARY KEY (BC_ID)
-)ENGINE INNODB;
-
-
-CREATE TABLE IF NOT EXISTS BC_PAYMENT (
- BC_ID INTEGER AUTO_INCREMENT,
- BC_DATE TIMESTAMP,
- BC_AMOUNT VARCHAR (64),
- BC_DESCRIPTION VARCHAR (128),
- BC_INVOICE_ID INTEGER,
- BC_TENANT_ID INTEGER,
- CONSTRAINT PK_BC_SUBSCRIPTION_ORDER PRIMARY KEY (BC_ID)
-)ENGINE INNODB;
-
-ALTER TABLE BC_PAYMENT ADD CONSTRAINT BC_PAYMENT_FK_BY_INVOICE_ID FOREIGN KEY (BC_INVOICE_ID) REFERENCES BC_INVOICE (BC_ID);
-
-CREATE TABLE IF NOT EXISTS BC_REGISTRATION_PAYMENT (
- BC_ID INTEGER AUTO_INCREMENT,
- BC_DATE TIMESTAMP,
- BC_AMOUNT VARCHAR (64),
- BC_DESCRIPTION VARCHAR (128),
- BC_USAGE_PLAN VARCHAR (64),
- BC_TENANT_ID INTEGER,
- CONSTRAINT PK_BC_REGISTRATION_PAYMENT PRIMARY KEY (BC_ID)
-)ENGINE INNODB;
-
--- this is n-n relationship
-CREATE TABLE IF NOT EXISTS BC_PAYMENT_SUBSCRIPTION (
- BC_PAYMENT_ID INTEGER,
- BC_SUBSCRIPTION_ID INTEGER,
- CONSTRAINT PK_BC_SUBSCRIPTION_ORDER PRIMARY KEY (BC_PAYMENT_ID, BC_SUBSCRIPTION_ID)
-)ENGINE INNODB;
-
-ALTER TABLE BC_PAYMENT_SUBSCRIPTION ADD CONSTRAINT BC_PAYMENT_SUBSCRIPTION_FK_BY_PAYMENT_ID FOREIGN KEY (BC_PAYMENT_ID) REFERENCES BC_PAYMENT (BC_ID);
-ALTER TABLE BC_PAYMENT_SUBSCRIPTION ADD CONSTRAINT BC_PAYMENT_SUBSCRIPTION_FK_BY_SUBSCRIPTION_ID FOREIGN KEY (BC_SUBSCRIPTION_ID) REFERENCES BC_SUBSCRIPTION (BC_ID);
-
-CREATE TABLE IF NOT EXISTS BC_INVOICE_SUBSCRIPTION (
- BC_ID INTEGER AUTO_INCREMENT,
- BC_INVOICE_ID INTEGER,
- BC_SUBSCRIPTION_ID INTEGER,
- CONSTRAINT PK_BC_INVOICE_ITEM PRIMARY KEY (BC_ID)
-)ENGINE INNODB;
-
-ALTER TABLE BC_INVOICE_SUBSCRIPTION ADD CONSTRAINT BC_INVOICE_SUBSCRIPTION_FK_BY_INVOICE_ID FOREIGN KEY (BC_INVOICE_ID) REFERENCES BC_INVOICE (BC_ID);
-ALTER TABLE BC_INVOICE_SUBSCRIPTION ADD CONSTRAINT BC_INVOICE_SUBSCRIPTION_FK_BY_SUBSCRIPTION_ID FOREIGN KEY (BC_SUBSCRIPTION_ID) REFERENCES BC_SUBSCRIPTION (BC_ID);
-
-
-CREATE TABLE IF NOT EXISTS BC_INVOICE_SUBSCRIPTION_ITEM (
- BC_INVOICE_SUBSCRIPTION_ID INTEGER,
- BC_ITEM_ID INTEGER,
- BC_COST VARCHAR (64),
- BC_DESCRIPTION varchar (64),
- CONSTRAINT PK_BC_INVOICE_SUBSCRIPTION_ITEM PRIMARY KEY (BC_INVOICE_SUBSCRIPTION_ID, BC_ITEM_ID)
-)ENGINE INNODB;
-
-ALTER TABLE BC_INVOICE_SUBSCRIPTION_ITEM ADD CONSTRAINT BC_INVOICE_SUBSCRIPTION_ITEM_FK_BY_INVOICE_SUBSCRIPTION_ID FOREIGN KEY (BC_INVOICE_SUBSCRIPTION_ID) REFERENCES BC_INVOICE_SUBSCRIPTION (BC_ID);
-ALTER TABLE BC_INVOICE_SUBSCRIPTION_ITEM ADD CONSTRAINT BC_INVOICE_SUBSCRIPTION_ITEM_FK_BY_ITEM_ID FOREIGN KEY (BC_ITEM_ID) REFERENCES BC_ITEM(BC_ID);
-
-CREATE TABLE IF NOT EXISTS BC_DISCOUNT (
- BC_ID INTEGER AUTO_INCREMENT,
- BC_TENANT_ID INTEGER,
- BC_PERCENTAGE FLOAT,
- BC_AMOUNT FLOAT,
- BC_START_DATE TIMESTAMP,
- BC_END_DATE TIMESTAMP,
- BC_PERCENTAGE_TYPE INTEGER,
- CONSTRAINT PK_BC_DISCOUNT PRIMARY KEY (BC_ID)
-)ENGINE INNODB;
-
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/4762e5d1/tools/stratos-installer/resources/gitolite-suexec-wrapper.sh
----------------------------------------------------------------------
diff --git a/tools/stratos-installer/resources/gitolite-suexec-wrapper.sh b/tools/stratos-installer/resources/gitolite-suexec-wrapper.sh
deleted file mode 100644
index 03d6550..0000000
--- a/tools/stratos-installer/resources/gitolite-suexec-wrapper.sh
+++ /dev/null
@@ -1,30 +0,0 @@
-#!/bin/bash
-#
-#
-# Licensed to the Apache Software Foundation (ASF) under one
-# or more contributor license agreements. See the NOTICE file
-# distributed with this work for additional information
-# regarding copyright ownership. The ASF licenses this file
-# to you under the Apache License, Version 2.0 (the
-# "License"); you may not use this file except in compliance
-# with the License. You may obtain a copy of the License at
-#
-# http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing,
-# software distributed under the License is distributed on an
-# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-# KIND, either express or implied. See the License for the
-# specific language governing permissions and limitations
-# under the License.
-#
-#
-
-USER=$1
-
-export GIT_PROJECT_ROOT="/home/git/repositories"
-export GITOLITE_HTTP_HOME="/home/git"
-export GIT_HTTP_BACKEND="/usr/lib/git-core/git-http-backend"
-
-
-exec /usr/share/gitolite/gl-auth-command $USER
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/4762e5d1/tools/stratos-installer/resources/metering_mysql.sql
----------------------------------------------------------------------
diff --git a/tools/stratos-installer/resources/metering_mysql.sql b/tools/stratos-installer/resources/metering_mysql.sql
deleted file mode 100644
index 8908ef0..0000000
--- a/tools/stratos-installer/resources/metering_mysql.sql
+++ /dev/null
@@ -1,172 +0,0 @@
-/*
-* Licensed to the Apache Software Foundation (ASF) under one
-* or more contributor license agreements. See the NOTICE file
-* distributed with this work for additional information
-* regarding copyright ownership. The ASF licenses this file
-* to you under the Apache License, Version 2.0 (the
-* "License"); you may not use this file except in compliance
-* with the License. You may obtain a copy of the License at
-*
-* http://www.apache.org/licenses/LICENSE-2.0
-*
-* Unless required by applicable law or agreed to in writing,
-* software distributed under the License is distributed on an
-* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-* KIND, either express or implied. See the License for the
-* specific language governing permissions and limitations
-* under the License.
-*/
-
--- WSO2 METERING DATABASE SQL FOR MySQL
-
-SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-
-SET AUTOCOMMIT=0;
-
-CREATE DATABASE IF NOT EXISTS billing;
-USE billing;
-
-START TRANSACTION;
-
---
--- TABLES
---
-
-CREATE TABLE IF NOT EXISTS USAGE_HOURLY_ANALYTICS (
- ID VARCHAR(200) NOT NULL,
- HOUR_FACT TIMESTAMP,
- SERVER_NAME VARCHAR(100),
- TENANT_ID VARCHAR(50),
- PAYLOAD_TYPE VARCHAR(50),
- PAYLOAD_VALUE BIGINT,
- PRIMARY KEY (`ID`)
-) ENGINE=INNODB;
-
-CREATE TABLE IF NOT EXISTS USAGE_DAILY_ANALYTICS (
- ID VARCHAR(200) NOT NULL,
- DAY_FACT TIMESTAMP,
- SERVER_NAME VARCHAR(100),
- TENANT_ID VARCHAR(50),
- PAYLOAD_TYPE VARCHAR(50),
- PAYLOAD_VALUE BIGINT,
- PRIMARY KEY (`ID`)
-) ENGINE=INNODB;
-
-CREATE TABLE IF NOT EXISTS USAGE_MONTHLY_ANALYTICS (
- ID VARCHAR(200) NOT NULL,
- MONTH_FACT TIMESTAMP,
- SERVER_NAME VARCHAR(100),
- TENANT_ID VARCHAR(50),
- PAYLOAD_TYPE VARCHAR(50),
- PAYLOAD_VALUE BIGINT,
- PRIMARY KEY (`ID`)
-) ENGINE=INNODB;
-
-CREATE TABLE IF NOT EXISTS USAGE_LAST_HOURLY_TS (
- ID VARCHAR(200) NOT NULL,
- TIMESTMP TIMESTAMP,
- PRIMARY KEY (`ID`)
-) ENGINE=INNODB;
-
-CREATE TABLE IF NOT EXISTS USAGE_LAST_DAILY_TS (
- ID VARCHAR(200) NOT NULL,
- TIMESTMP TIMESTAMP,
- PRIMARY KEY (`ID`)
-) ENGINE=INNODB;
-
-CREATE TABLE IF NOT EXISTS USAGE_LAST_MONTHLY_TS (
- ID VARCHAR(200) NOT NULL,
- TIMESTMP TIMESTAMP,
- PRIMARY KEY (`ID`)
-) ENGINE=INNODB;
-
-CREATE TABLE IF NOT EXISTS SERVICE_STATS_HOURLY_ANALYTICS (
- ID VARCHAR(200) NOT NULL,
- HOUR_FACT TIMESTAMP,
- SERVER_NAME VARCHAR(100),
- TENANT_ID VARCHAR(50),
- REQUEST_COUNT BIGINT,
- RESPONSE_COUNT BIGINT,
- FAULT_COUNT BIGINT,
- PRIMARY KEY (`ID`)
-) ENGINE=INNODB;
-
-CREATE TABLE IF NOT EXISTS SERVICE_STATS_DAILY_ANALYTICS (
- ID VARCHAR(200) NOT NULL,
- DAY_FACT TIMESTAMP,
- SERVER_NAME VARCHAR(100),
- TENANT_ID VARCHAR(50),
- REQUEST_COUNT BIGINT,
- RESPONSE_COUNT BIGINT,
- FAULT_COUNT BIGINT,
- PRIMARY KEY (`ID`)
-) ENGINE=INNODB;
-
-CREATE TABLE IF NOT EXISTS SERVICE_STATS_MONTHLY_ANALYTICS (
- ID VARCHAR(200) NOT NULL,
- MONTH_FACT TIMESTAMP,
- SERVER_NAME VARCHAR(100),
- TENANT_ID VARCHAR(50),
- REQUEST_COUNT BIGINT,
- RESPONSE_COUNT BIGINT,
- FAULT_COUNT BIGINT,
- PRIMARY KEY (`ID`)
-) ENGINE=INNODB;
-
-CREATE TABLE IF NOT EXISTS SERVICE_STATS_LAST_HOURLY_TS (
- ID VARCHAR(200) NOT NULL,
- TIMESTMP TIMESTAMP,
- PRIMARY KEY (`ID`)
-) ENGINE=INNODB;
-
-CREATE TABLE IF NOT EXISTS SERVICE_STATS_LAST_DAILY_TS (
- ID VARCHAR(200) NOT NULL,
- TIMESTMP TIMESTAMP,
- PRIMARY KEY (`ID`)
-) ENGINE=INNODB;
-
-CREATE TABLE IF NOT EXISTS SERVICE_STATS_LAST_MONTHLY_TS (
- ID VARCHAR(200) NOT NULL,
- TIMESTMP TIMESTAMP,
- PRIMARY KEY (`ID`)
-) ENGINE=INNODB;
-
-CREATE TABLE IF NOT EXISTS REGISTRY_USAGE_HOURLY_ANALYTICS (
- ID VARCHAR(50),
- TENANT_ID VARCHAR(50),
- HISTORY_USAGE BIGINT,
- CURRENT_USAGE BIGINT,
- PRIMARY KEY (`ID`)
-) ENGINE=INNODB;
-
-CREATE TABLE IF NOT EXISTS CARTRIDGE_STATS_HOURLY_ANALYTICS (
- HOUR_FACT TIMESTAMP,
- TENANT_ID VARCHAR(50),
- CARTRIDGE_TYPE VARCHAR(20),
- IMAGE_ID VARCHAR(100),
- NODE_ID VARCHAR(100),
- DURATION_HOURS INT(5),
- PRIMARY KEY (`NODE_ID`)
-) ENGINE=INNODB;
-
-CREATE TABLE IF NOT EXISTS CARTRIDGE_STATS_LAST_HOURLY_TS (
- ID VARCHAR(200) NOT NULL,
- TIMESTMP TIMESTAMP,
- PRIMARY KEY (`ID`)
-) ENGINE=INNODB;
-
-CREATE TABLE IF NOT EXISTS CARTRIDGE_STATS_LAST_DAILY_TS (
- ID VARCHAR(200) NOT NULL,
- TIMESTMP TIMESTAMP,
- PRIMARY KEY (`ID`)
-) ENGINE=INNODB;
-
-CREATE TABLE IF NOT EXISTS CARTRIDGE_STATS_LAST_MONTHLY_TS (
- ID VARCHAR(200) NOT NULL,
- TIMESTMP TIMESTAMP,
- PRIMARY KEY (`ID`)
-) ENGINE=INNODB;
-
-
-COMMIT;
-
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/4762e5d1/tools/stratos-installer/resources/notify.php
----------------------------------------------------------------------
diff --git a/tools/stratos-installer/resources/notify.php b/tools/stratos-installer/resources/notify.php
deleted file mode 100644
index 7f80aa7..0000000
--- a/tools/stratos-installer/resources/notify.php
+++ /dev/null
@@ -1,62 +0,0 @@
-<?php
-/*
- *
- * Licensed to the Apache Software Foundation (ASF) under one
- * or more contributor license agreements. See the NOTICE file
- * distributed with this work for additional information
- * regarding copyright ownership. The ASF licenses this file
- * to you under the Apache License, Version 2.0 (the
- * "License"); you may not use this file except in compliance
- * with the License. You may obtain a copy of the License at
- *
- * http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing,
- * software distributed under the License is distributed on an
- * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
- * KIND, either express or implied. See the License for the
- * specific language governing permissions and limitations
- * under the License.
- *
-*/
-
-// sample json
-
-//$dd='{"pusher":{"name":"none"},"repository":{"name":"wordpress","has_wiki":true,"size":6668,"created_at":"2012-11-28T21:00:56-08:00","private":false,"watchers":0,"fork":false,"language":"PHP","url":"https://github.com/lakwarus/wordpress","id":6915450,"pushed_at":"2012-12-02T22:34:01-08:00","has_downloads":true,"open_issues":0,"has_issues":true,"forks":0,"stargazers":0,"description":"","owner":{"name":"lakwarus","email":"lakwarus@gmail.com"}},"forced":false,"after":"bf3e4bbe16336b272ca7230eecd1f42cd569d850","head_commit":{"modified":[],"added":["test.txt"],"timestamp":"2012-12-02T22:33:22-08:00","removed":[],"author":{"name":"Lakmal Warusawithana","username":"lakwarus","email":"lakmal@wso2.com"},"url":"https://github.com/lakwarus/wordpress/commit/bf3e4bbe16336b272ca7230eecd1f42cd569d850","id":"bf3e4bbe16336b272ca7230eecd1f42cd569d850","distinct":true,"message":">>>>>>>>>","committer":{"name":"Lakmal Warusawithana","username":"lakwarus","email":"lakmal@wso2.com"}},"deleted":false,"c
ommits":[{"modified":["README.md"],"added":[],"timestamp":"2012-12-02T22:18:54-08:00","removed":[],"author":{"name":"Lakmal Warusawithana","username":"lakwarus","email":"lakmal@wso2.com"},"url":"https://github.com/lakwarus/wordpress/commit/7afd4089f402cc9926aa5490cbcef21d77f63265","id":"7afd4089f402cc9926aa5490cbcef21d77f63265","distinct":true,"message":"add","committer":{"name":"Lakmal Warusawithana","username":"lakwarus","email":"lakmal@wso2.com"}},{"modified":["README.md"],"added":[],"timestamp":"2012-12-02T22:22:11-08:00","removed":[],"author":{"name":"Lakmal Warusawithana","username":"lakwarus","email":"lakmal@wso2.com"},"url":"https://github.com/lakwarus/wordpress/commit/817137d6f40ff0065d1687437a67c2bb42ea98c8","id":"817137d6f40ff0065d1687437a67c2bb42ea98c8","distinct":true,"message":"add","committer":{"name":"Lakmal Warusawithana","username":"lakwarus","email":"lakmal@wso2.com"}},{"modified":[],"added":["test.txt"],"timestamp":"2012-12-02T22:33:22-08:00","removed":[],"author
":{"name":"Lakmal Warusawithana","username":"lakwarus","email":"lakmal@wso2.com"},"url":"https://github.com/lakwarus/wordpress/commit/bf3e4bbe16336b272ca7230eecd1f42cd569d850","id":"bf3e4bbe16336b272ca7230eecd1f42cd569d850","distinct":true,"message":">>>>>>>>>","committer":{"name":"Lakmal Warusawithana","username":"lakwarus","email":"lakmal@wso2.com"}}],"ref":"refs/heads/master","before":"d5d7e4ab8ae58af96dd151bdf536644323e901e3","compare":"https://github.com/lakwarus/wordpress/compare/d5d7e4ab8ae5...bf3e4bbe1633","created":false}';
-
-
-$json = json_decode($_POST['payload']);
-#$json = json_decode($dd);
-$repository=$json->repository;
-
-$jsonIterator = new RecursiveIteratorIterator(
- new RecursiveArrayIterator(json_decode(json_encode($repository), TRUE)),
- RecursiveIteratorIterator::SELF_FIRST);
-
-foreach ($jsonIterator as $key => $val) {
- if(is_array($val)) {
- } else {
- if($key=="url"){
- $giturl=$val;
- }
- }
-}
-#echo $giturl;
-
-$xml="<?xml version=\"1.0\"?><soapenv:Envelope xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsd=\"http://org.apache.axis2/xsd\"><soapenv:Header/><soapenv:Body><xsd:synchronize><xsd:repositoryURL>".$giturl."</xsd:repositoryURL></xsd:synchronize></soapenv:Body></soapenv:Envelope>";
-
-$url = 'https://203.143.18.246:9445/services/RepoNotificationService';
-$ch = curl_init($url);
-curl_setopt($ch, CURLOPT_MUTE, 1);
-curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
-curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
-curl_setopt($ch, CURLOPT_POST, 1);
-curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: text/xml'));
-curl_setopt($ch, CURLOPT_POSTFIELDS, "$xml");
-curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
-
-$response = curl_exec($ch);
-
-curl_close($ch);
-
-?>
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/4762e5d1/tools/stratos-installer/resources/registry.sql
----------------------------------------------------------------------
diff --git a/tools/stratos-installer/resources/registry.sql b/tools/stratos-installer/resources/registry.sql
deleted file mode 100644
index 2e5dd06..0000000
--- a/tools/stratos-installer/resources/registry.sql
+++ /dev/null
@@ -1,407 +0,0 @@
-/*
-* Licensed to the Apache Software Foundation (ASF) under one
-* or more contributor license agreements. See the NOTICE file
-* distributed with this work for additional information
-* regarding copyright ownership. The ASF licenses this file
-* to you under the Apache License, Version 2.0 (the
-* "License"); you may not use this file except in compliance
-* with the License. You may obtain a copy of the License at
-*
-* http://www.apache.org/licenses/LICENSE-2.0
-*
-* Unless required by applicable law or agreed to in writing,
-* software distributed under the License is distributed on an
-* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-* KIND, either express or implied. See the License for the
-* specific language governing permissions and limitations
-* under the License.
-*/
-
-CREATE DATABASE IF NOT EXISTS registry;
-USE registry;
-
-CREATE TABLE IF NOT EXISTS REG_CLUSTER_LOCK (
- REG_LOCK_NAME VARCHAR (20),
- REG_LOCK_STATUS VARCHAR (20),
- REG_LOCKED_TIME TIMESTAMP,
- REG_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (REG_LOCK_NAME)
-)ENGINE INNODB;
-
-CREATE TABLE IF NOT EXISTS REG_LOG (
- REG_LOG_ID INTEGER AUTO_INCREMENT,
- REG_PATH VARCHAR (750),
- REG_USER_ID VARCHAR (31) NOT NULL,
- REG_LOGGED_TIME TIMESTAMP NOT NULL,
- REG_ACTION INTEGER NOT NULL,
- REG_ACTION_DATA VARCHAR (500),
- REG_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (REG_LOG_ID, REG_TENANT_ID)
-)ENGINE INNODB;
-
--- The REG_PATH_VALUE should be less than 767 bytes, and hence was fixed at 750.
--- See CARBON-5917.
-
-CREATE TABLE IF NOT EXISTS REG_PATH(
- REG_PATH_ID INTEGER NOT NULL AUTO_INCREMENT,
- REG_PATH_VALUE VARCHAR(750) NOT NULL,
- REG_PATH_PARENT_ID INTEGER,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_PATH PRIMARY KEY(REG_PATH_ID, REG_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE INDEX REG_PATH_IND_BY_PATH_VALUE USING HASH ON REG_PATH(REG_PATH_VALUE, REG_TENANT_ID);
-CREATE INDEX REG_PATH_IND_BY_PATH_PARENT_ID USING HASH ON REG_PATH(REG_PATH_PARENT_ID, REG_TENANT_ID);
-
-CREATE TABLE IF NOT EXISTS REG_CONTENT (
- REG_CONTENT_ID INTEGER NOT NULL AUTO_INCREMENT,
- REG_CONTENT_DATA LONGBLOB,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_CONTENT PRIMARY KEY(REG_CONTENT_ID, REG_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE IF NOT EXISTS REG_CONTENT_HISTORY (
- REG_CONTENT_ID INTEGER NOT NULL,
- REG_CONTENT_DATA LONGBLOB,
- REG_DELETED SMALLINT,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_CONTENT_HISTORY PRIMARY KEY(REG_CONTENT_ID, REG_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE IF NOT EXISTS REG_RESOURCE (
- REG_PATH_ID INTEGER NOT NULL,
- REG_NAME VARCHAR(256),
- REG_VERSION INTEGER NOT NULL AUTO_INCREMENT,
- REG_MEDIA_TYPE VARCHAR(500),
- REG_CREATOR VARCHAR(31) NOT NULL,
- REG_CREATED_TIME TIMESTAMP NOT NULL,
- REG_LAST_UPDATOR VARCHAR(31),
- REG_LAST_UPDATED_TIME TIMESTAMP NOT NULL,
- REG_DESCRIPTION VARCHAR(1000),
- REG_CONTENT_ID INTEGER,
- REG_TENANT_ID INTEGER DEFAULT 0,
- REG_UUID VARCHAR(100) NOT NULL,
- CONSTRAINT PK_REG_RESOURCE PRIMARY KEY(REG_VERSION, REG_TENANT_ID)
-)ENGINE INNODB;
-
-ALTER TABLE REG_RESOURCE ADD CONSTRAINT REG_RESOURCE_FK_BY_PATH_ID FOREIGN KEY (REG_PATH_ID, REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID, REG_TENANT_ID);
-ALTER TABLE REG_RESOURCE ADD CONSTRAINT REG_RESOURCE_FK_BY_CONTENT_ID FOREIGN KEY (REG_CONTENT_ID, REG_TENANT_ID) REFERENCES REG_CONTENT (REG_CONTENT_ID, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_IND_BY_NAME USING HASH ON REG_RESOURCE(REG_NAME, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_IND_BY_PATH_ID_NAME USING HASH ON REG_RESOURCE(REG_PATH_ID, REG_NAME, REG_TENANT_ID);
-
-CREATE TABLE IF NOT EXISTS REG_RESOURCE_HISTORY (
- REG_PATH_ID INTEGER NOT NULL,
- REG_NAME VARCHAR(256),
- REG_VERSION INTEGER NOT NULL,
- REG_MEDIA_TYPE VARCHAR(500),
- REG_CREATOR VARCHAR(31) NOT NULL,
- REG_CREATED_TIME TIMESTAMP NOT NULL,
- REG_LAST_UPDATOR VARCHAR(31),
- REG_LAST_UPDATED_TIME TIMESTAMP NOT NULL,
- REG_DESCRIPTION VARCHAR(1000),
- REG_CONTENT_ID INTEGER,
- REG_DELETED SMALLINT,
- REG_TENANT_ID INTEGER DEFAULT 0,
- REG_UUID VARCHAR(100) NOT NULL,
- CONSTRAINT PK_REG_RESOURCE_HISTORY PRIMARY KEY(REG_VERSION, REG_TENANT_ID)
-)ENGINE INNODB;
-
-ALTER TABLE REG_RESOURCE_HISTORY ADD CONSTRAINT REG_RESOURCE_HIST_FK_BY_PATHID FOREIGN KEY (REG_PATH_ID, REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID, REG_TENANT_ID);
-ALTER TABLE REG_RESOURCE_HISTORY ADD CONSTRAINT REG_RESOURCE_HIST_FK_BY_CONTENT_ID FOREIGN KEY (REG_CONTENT_ID, REG_TENANT_ID) REFERENCES REG_CONTENT_HISTORY (REG_CONTENT_ID, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_HISTORY_IND_BY_NAME USING HASH ON REG_RESOURCE_HISTORY(REG_NAME, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_HISTORY_IND_BY_PATH_ID_NAME USING HASH ON REG_RESOURCE(REG_PATH_ID, REG_NAME, REG_TENANT_ID);
-
-CREATE TABLE IF NOT EXISTS REG_COMMENT (
- REG_ID INTEGER NOT NULL AUTO_INCREMENT,
- REG_COMMENT_TEXT VARCHAR(500) NOT NULL,
- REG_USER_ID VARCHAR(31) NOT NULL,
- REG_COMMENTED_TIME TIMESTAMP NOT NULL,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_COMMENT PRIMARY KEY(REG_ID, REG_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE IF NOT EXISTS REG_RESOURCE_COMMENT (
- REG_COMMENT_ID INTEGER NOT NULL,
- REG_VERSION INTEGER,
- REG_PATH_ID INTEGER,
- REG_RESOURCE_NAME VARCHAR(256),
- REG_TENANT_ID INTEGER DEFAULT 0
-)ENGINE INNODB;
-
-ALTER TABLE REG_RESOURCE_COMMENT ADD CONSTRAINT REG_RESOURCE_COMMENT_FK_BY_PATH_ID FOREIGN KEY (REG_PATH_ID, REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID, REG_TENANT_ID);
-ALTER TABLE REG_RESOURCE_COMMENT ADD CONSTRAINT REG_RESOURCE_COMMENT_FK_BY_COMMENT_ID FOREIGN KEY (REG_COMMENT_ID, REG_TENANT_ID) REFERENCES REG_COMMENT (REG_ID, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_COMMENT_IND_BY_PATH_ID_AND_RESOURCE_NAME USING HASH ON REG_RESOURCE_COMMENT(REG_PATH_ID, REG_RESOURCE_NAME, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_COMMENT_IND_BY_VERSION USING HASH ON REG_RESOURCE_COMMENT(REG_VERSION, REG_TENANT_ID);
-
-CREATE TABLE IF NOT EXISTS REG_RATING (
- REG_ID INTEGER NOT NULL AUTO_INCREMENT,
- REG_RATING INTEGER NOT NULL,
- REG_USER_ID VARCHAR(31) NOT NULL,
- REG_RATED_TIME TIMESTAMP NOT NULL,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_RATING PRIMARY KEY(REG_ID, REG_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE IF NOT EXISTS REG_RESOURCE_RATING (
- REG_RATING_ID INTEGER NOT NULL,
- REG_VERSION INTEGER,
- REG_PATH_ID INTEGER,
- REG_RESOURCE_NAME VARCHAR(256),
- REG_TENANT_ID INTEGER DEFAULT 0
-)ENGINE INNODB;
-
-ALTER TABLE REG_RESOURCE_RATING ADD CONSTRAINT REG_RESOURCE_RATING_FK_BY_PATH_ID FOREIGN KEY (REG_PATH_ID, REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID, REG_TENANT_ID);
-ALTER TABLE REG_RESOURCE_RATING ADD CONSTRAINT REG_RESOURCE_RATING_FK_BY_RATING_ID FOREIGN KEY (REG_RATING_ID, REG_TENANT_ID) REFERENCES REG_RATING (REG_ID, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_RATING_IND_BY_PATH_ID_AND_RESOURCE_NAME USING HASH ON REG_RESOURCE_RATING(REG_PATH_ID, REG_RESOURCE_NAME, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_RATING_IND_BY_VERSION USING HASH ON REG_RESOURCE_RATING(REG_VERSION, REG_TENANT_ID);
-
-
-CREATE TABLE IF NOT EXISTS REG_TAG (
- REG_ID INTEGER NOT NULL AUTO_INCREMENT,
- REG_TAG_NAME VARCHAR(500) NOT NULL,
- REG_USER_ID VARCHAR(31) NOT NULL,
- REG_TAGGED_TIME TIMESTAMP NOT NULL,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_TAG PRIMARY KEY(REG_ID, REG_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE IF NOT EXISTS REG_RESOURCE_TAG (
- REG_TAG_ID INTEGER NOT NULL,
- REG_VERSION INTEGER,
- REG_PATH_ID INTEGER,
- REG_RESOURCE_NAME VARCHAR(256),
- REG_TENANT_ID INTEGER DEFAULT 0
-)ENGINE INNODB;
-
-ALTER TABLE REG_RESOURCE_TAG ADD CONSTRAINT REG_RESOURCE_TAG_FK_BY_PATH_ID FOREIGN KEY (REG_PATH_ID, REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID, REG_TENANT_ID);
-ALTER TABLE REG_RESOURCE_TAG ADD CONSTRAINT REG_RESOURCE_TAG_FK_BY_TAG_ID FOREIGN KEY (REG_TAG_ID, REG_TENANT_ID) REFERENCES REG_TAG (REG_ID, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_TAG_IND_BY_PATH_ID_AND_RESOURCE_NAME USING HASH ON REG_RESOURCE_TAG(REG_PATH_ID, REG_RESOURCE_NAME, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_TAG_IND_BY_VERSION USING HASH ON REG_RESOURCE_TAG(REG_VERSION, REG_TENANT_ID);
-
-CREATE TABLE IF NOT EXISTS REG_PROPERTY (
- REG_ID INTEGER NOT NULL AUTO_INCREMENT,
- REG_NAME VARCHAR(100) NOT NULL,
- REG_VALUE VARCHAR(1000),
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_PROPERTY PRIMARY KEY(REG_ID, REG_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE IF NOT EXISTS REG_RESOURCE_PROPERTY (
- REG_PROPERTY_ID INTEGER NOT NULL,
- REG_VERSION INTEGER,
- REG_PATH_ID INTEGER,
- REG_RESOURCE_NAME VARCHAR(256),
- REG_TENANT_ID INTEGER DEFAULT 0
-)ENGINE INNODB;
-
-ALTER TABLE REG_RESOURCE_PROPERTY ADD CONSTRAINT REG_RESOURCE_PROPERTY_FK_BY_PATH_ID FOREIGN KEY (REG_PATH_ID, REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID, REG_TENANT_ID);
-ALTER TABLE REG_RESOURCE_PROPERTY ADD CONSTRAINT REG_RESOURCE_PROPERTY_FK_BY_TAG_ID FOREIGN KEY (REG_PROPERTY_ID, REG_TENANT_ID) REFERENCES REG_PROPERTY (REG_ID, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_PROPERTY_IND_BY_PATH_ID_AND_RESOURCE_NAME USING HASH ON REG_RESOURCE_PROPERTY(REG_PATH_ID, REG_RESOURCE_NAME, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_PROPERTY_IND_BY_VERSION USING HASH ON REG_RESOURCE_PROPERTY(REG_VERSION, REG_TENANT_ID);
-
--- CREATE TABLE IF NOT EXISTS REG_ASSOCIATIONS (
--- SRC_PATH_ID INTEGER,
--- SRC_RESOURCE_NAME VARCHAR(256),
--- SRC_VERSION INTEGER,
--- TGT_PATH_ID INTEGER,
--- TGT_RESOURCE_NAME VARCHAR(256),
--- TGT_VERSION INTEGER
--- )ENGINE INNODB;
---
--- ALTER TABLE REG_ASSOCIATIONS ADD CONSTRAINT REG_ASSOCIATIONS_FK_BY_SRC_PATH_ID FOREIGN KEY (SRC_PATH_ID) REFERENCES REG_PATH (PATH_ID);
--- ALTER TABLE REG_ASSOCIATIONS ADD CONSTRAINT REG_ASSOCIATIONS_FK_BY_TGT_PATH_ID FOREIGN KEY (TGT_PATH_ID) REFERENCES REG_PATH (PATH_ID);
--- CREATE INDEX REG_ASSOCIATIONS_IND_BY_SRC_VERSION ON REG_ASSOCIATIONS(SRC_VERSION);
--- CREATE INDEX REG_ASSOCIATIONS_IND_BY_TGT_VERSION ON REG_ASSOCIATIONS(TGT_VERSION);
--- CREATE INDEX REG_ASSOCIATIONS_IND_BY_SRC_RESOURCE_NAME ON REG_ASSOCIATIONS(SRC_RESOURCE_NAME);
--- CREATE INDEX REG_ASSOCIATIONS_IND_BY_TGT_RESOURCE_NAME ON REG_ASSOCIATIONS(TGT_RESOURCE_NAME);
-
-
-
-CREATE TABLE IF NOT EXISTS REG_ASSOCIATION (
- REG_ASSOCIATION_ID INTEGER AUTO_INCREMENT,
- REG_SOURCEPATH VARCHAR (750) NOT NULL,
- REG_TARGETPATH VARCHAR (750) NOT NULL,
- REG_ASSOCIATION_TYPE VARCHAR (2000) NOT NULL,
- REG_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (REG_ASSOCIATION_ID, REG_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE IF NOT EXISTS REG_SNAPSHOT (
- REG_SNAPSHOT_ID INTEGER NOT NULL AUTO_INCREMENT,
- REG_PATH_ID INTEGER NOT NULL,
- REG_RESOURCE_NAME VARCHAR(255),
- REG_RESOURCE_VIDS LONGBLOB NOT NULL,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_SNAPSHOT PRIMARY KEY(REG_SNAPSHOT_ID, REG_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE INDEX REG_SNAPSHOT_IND_BY_PATH_ID_AND_RESOURCE_NAME USING HASH ON REG_SNAPSHOT(REG_PATH_ID, REG_RESOURCE_NAME, REG_TENANT_ID);
-
-ALTER TABLE REG_SNAPSHOT ADD CONSTRAINT REG_SNAPSHOT_FK_BY_PATH_ID FOREIGN KEY (REG_PATH_ID, REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID, REG_TENANT_ID);
-
-
--- ################################
--- USER MANAGER TABLES
--- ################################
-
-CREATE TABLE UM_TENANT (
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_DOMAIN_NAME VARCHAR(255) NOT NULL,
- UM_EMAIL VARCHAR(255),
- UM_ACTIVE BOOLEAN DEFAULT FALSE,
- UM_CREATED_DATE TIMESTAMP NOT NULL,
- UM_USER_CONFIG LONGBLOB,
- PRIMARY KEY (UM_ID),
- UNIQUE(UM_DOMAIN_NAME)
-)ENGINE INNODB;
-
-CREATE UNIQUE INDEX INDEX_UM_TENANT_UM_DOMAIN_NAME
- ON UM_TENANT (UM_DOMAIN_NAME);
-
-CREATE TABLE UM_USER (
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_USER_NAME VARCHAR(255) NOT NULL,
- UM_USER_PASSWORD VARCHAR(255) NOT NULL,
- UM_SALT_VALUE VARCHAR(31),
- UM_REQUIRE_CHANGE BOOLEAN DEFAULT FALSE,
- UM_CHANGED_TIME TIMESTAMP NOT NULL,
- UM_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (UM_ID, UM_TENANT_ID),
- UNIQUE(UM_USER_NAME, UM_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE UM_ROLE (
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_ROLE_NAME VARCHAR(255) NOT NULL,
- UM_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (UM_ID, UM_TENANT_ID),
- UNIQUE(UM_ROLE_NAME, UM_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE UM_PERMISSION (
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_RESOURCE_ID VARCHAR(255) NOT NULL,
- UM_ACTION VARCHAR(255) NOT NULL,
- UM_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE INDEX INDEX_UM_PERMISSION_UM_RESOURCE_ID_UM_ACTION ON UM_PERMISSION (UM_RESOURCE_ID, UM_ACTION, UM_TENANT_ID);
-
-CREATE TABLE UM_ROLE_PERMISSION (
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_PERMISSION_ID INTEGER NOT NULL,
- UM_ROLE_NAME VARCHAR(255) NOT NULL,
- UM_IS_ALLOWED SMALLINT NOT NULL,
- UM_TENANT_ID INTEGER DEFAULT 0,
- FOREIGN KEY (UM_PERMISSION_ID, UM_TENANT_ID) REFERENCES UM_PERMISSION(UM_ID, UM_TENANT_ID),
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-)ENGINE INNODB;
-
--- REMOVED UNIQUE (UM_PERMISSION_ID, UM_ROLE_ID)
-CREATE TABLE UM_USER_PERMISSION (
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_PERMISSION_ID INTEGER NOT NULL,
- UM_USER_NAME VARCHAR(255) NOT NULL,
- UM_IS_ALLOWED SMALLINT NOT NULL,
- UM_TENANT_ID INTEGER DEFAULT 0,
- FOREIGN KEY (UM_PERMISSION_ID, UM_TENANT_ID) REFERENCES UM_PERMISSION(UM_ID, UM_TENANT_ID),
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-)ENGINE INNODB;
-
--- REMOVED UNIQUE (UM_PERMISSION_ID, UM_USER_ID)
-CREATE TABLE UM_USER_ROLE (
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_ROLE_ID INTEGER NOT NULL,
- UM_USER_ID INTEGER NOT NULL,
- UM_TENANT_ID INTEGER DEFAULT 0,
- UNIQUE (UM_USER_ID, UM_ROLE_ID, UM_TENANT_ID),
- FOREIGN KEY (UM_ROLE_ID, UM_TENANT_ID) REFERENCES UM_ROLE(UM_ID, UM_TENANT_ID),
- FOREIGN KEY (UM_USER_ID, UM_TENANT_ID) REFERENCES UM_USER(UM_ID, UM_TENANT_ID),
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-)ENGINE INNODB;
-
-
-CREATE TABLE UM_USER_ATTRIBUTE (
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_ATTR_NAME VARCHAR(255) NOT NULL,
- UM_ATTR_VALUE VARCHAR(1024),
- UM_PROFILE_ID VARCHAR(255),
- UM_USER_ID INTEGER,
- UM_TENANT_ID INTEGER DEFAULT 0,
- FOREIGN KEY (UM_USER_ID, UM_TENANT_ID) REFERENCES UM_USER(UM_ID, UM_TENANT_ID),
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-)ENGINE INNODB;
-
-
-
-CREATE TABLE UM_DIALECT(
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_DIALECT_URI VARCHAR(255) NOT NULL,
- UM_TENANT_ID INTEGER DEFAULT 0,
- UNIQUE(UM_DIALECT_URI, UM_TENANT_ID),
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE UM_CLAIM(
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_DIALECT_ID INTEGER NOT NULL,
- UM_CLAIM_URI VARCHAR(255) NOT NULL,
- UM_DISPLAY_TAG VARCHAR(255),
- UM_DESCRIPTION VARCHAR(255),
- UM_MAPPED_ATTRIBUTE VARCHAR(255),
- UM_REG_EX VARCHAR(255),
- UM_SUPPORTED SMALLINT,
- UM_REQUIRED SMALLINT,
- UM_DISPLAY_ORDER INTEGER,
- UM_TENANT_ID INTEGER DEFAULT 0,
- UNIQUE(UM_DIALECT_ID, UM_CLAIM_URI, UM_TENANT_ID),
- FOREIGN KEY(UM_DIALECT_ID, UM_TENANT_ID) REFERENCES UM_DIALECT(UM_ID, UM_TENANT_ID),
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE UM_PROFILE_CONFIG(
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_DIALECT_ID INTEGER NOT NULL,
- UM_PROFILE_NAME VARCHAR(255),
- UM_TENANT_ID INTEGER DEFAULT 0,
- FOREIGN KEY(UM_DIALECT_ID, UM_TENANT_ID) REFERENCES UM_DIALECT(UM_ID, UM_TENANT_ID),
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE UM_CLAIM_BEHAVIOR(
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_PROFILE_ID INTEGER,
- UM_CLAIM_ID INTEGER,
- UM_BEHAVIOUR SMALLINT,
- UM_TENANT_ID INTEGER DEFAULT 0,
- FOREIGN KEY(UM_PROFILE_ID, UM_TENANT_ID) REFERENCES UM_PROFILE_CONFIG(UM_ID, UM_TENANT_ID),
- FOREIGN KEY(UM_CLAIM_ID, UM_TENANT_ID) REFERENCES UM_CLAIM(UM_ID, UM_TENANT_ID),
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE UM_HYBRID_ROLE(
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_ROLE_NAME VARCHAR(255),
- UM_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE UM_HYBRID_USER_ROLE(
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_USER_NAME VARCHAR(255),
- UM_ROLE_ID INTEGER NOT NULL,
- UM_TENANT_ID INTEGER DEFAULT 0,
- UNIQUE (UM_USER_NAME, UM_ROLE_ID, UM_TENANT_ID),
- FOREIGN KEY (UM_ROLE_ID, UM_TENANT_ID) REFERENCES UM_HYBRID_ROLE(UM_ID, UM_TENANT_ID),
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE UM_HYBRID_REMEMBER_ME(
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_USER_NAME VARCHAR(255) NOT NULL,
- UM_COOKIE_VALUE VARCHAR(1024),
- UM_CREATED_TIME TIMESTAMP,
- UM_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-)ENGINE INNODB;
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/4762e5d1/tools/stratos-installer/resources/remove_entry_zone_file.sh
----------------------------------------------------------------------
diff --git a/tools/stratos-installer/resources/remove_entry_zone_file.sh b/tools/stratos-installer/resources/remove_entry_zone_file.sh
deleted file mode 100644
index c36e539..0000000
--- a/tools/stratos-installer/resources/remove_entry_zone_file.sh
+++ /dev/null
@@ -1,75 +0,0 @@
-#!/bin/bash
-#
-#
-# Licensed to the Apache Software Foundation (ASF) under one
-# or more contributor license agreements. See the NOTICE file
-# distributed with this work for additional information
-# regarding copyright ownership. The ASF licenses this file
-# to you under the Apache License, Version 2.0 (the
-# "License"); you may not use this file except in compliance
-# with the License. You may obtain a copy of the License at
-#
-# http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing,
-# software distributed under the License is distributed on an
-# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-# KIND, either express or implied. See the License for the
-# specific language governing permissions and limitations
-# under the License.
-#
-#
-zone_file=$2
-subdomain=$1
-
-# check the file
-if [ -f {$zone_file} ]; then
- echo "Error: zone does not exist"
- exit 1
-fi
-echo "File $zone_file exists"
-
-# find entry to delete
-entry=$(grep $subdomain $zone_file)
-#sed "/$entry/d" $zone_file
-
-sed "/$entry/d" $zone_file >tmp
-mv tmp $zone_file
-
-echo "entry to delete $entry"
-
-
-# get serial number
-serial=$(grep 'Serial' $zone_file | awk '{print $1}')
-echo "Serial number " $serial
-# get serial number's date
-serialdate=$(echo $serial | cut -b 1-8)
-# get today's date in same style
-date=$(date +%Y%m%d)
-
-
-#Serial number's date
-serialdate=$(echo $serial | cut -b 1-8)
-echo "serial date" $serialdate
-# get today's date in same style
-date=$(date +%Y%m%d)
-echo "Now date" $date
-
-# compare date and serial date
-if [ $serialdate = $date ]
- then
- # if equal, just add 1
- newserial=$(expr $serial + 1)
- echo "same date"
- else
- # if not equal, make a new one and add 00
- newserial=$(echo $date"00")
-fi
-
-echo "Adding subdomain $1 and ip $2 to $3"
-sed -i "s/.*Serial.*/ \t\t\t\t$newserial ; Serial./" $zone_file
-
-
-
-#reloading bind server
-/etc/init.d/bind9 reload
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/4762e5d1/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
deleted file mode 100644
index a6a2d74..0000000
--- a/tools/stratos-installer/resources/stratos_foundation.sql
+++ /dev/null
@@ -1,159 +0,0 @@
-/*
-* Licensed to the Apache Software Foundation (ASF) under one
-* or more contributor license agreements. See the NOTICE file
-* distributed with this work for additional information
-* regarding copyright ownership. The ASF licenses this file
-* to you under the Apache License, Version 2.0 (the
-* "License"); you may not use this file except in compliance
-* with the License. You may obtain a copy of the License at
-*
-* http://www.apache.org/licenses/LICENSE-2.0
-*
-* Unless required by applicable law or agreed to in writing,
-* software distributed under the License is distributed on an
-* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-* KIND, either express or implied. See the License for the
-* specific language governing permissions and limitations
-* under the License.
-*/
-
--- MySQL Administrator dump 1.4
---
--- ------------------------------------------------------
--- Server version 5.5.24-0ubuntu0.12.04.1
-
-
-/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
-/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
-/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
-/*!40101 SET NAMES utf8 */;
-
-/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
-/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
-/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-
-
---
--- Create schema stratos_foundation
---
-
-CREATE DATABASE IF NOT EXISTS stratos_foundation;
-USE stratos_foundation;
-
---
--- Definition of table `stratos_foundation`.`CARTRIDGE_INSTANCE`
---
-
-DROP TABLE IF EXISTS `stratos_foundation`.`CARTRIDGE_INSTANCE`;
-CREATE TABLE `stratos_foundation`.`CARTRIDGE_INSTANCE` (
- `ID` int(11) NOT NULL AUTO_INCREMENT,
- `INSTANCE_IP` varchar(255) NOT NULL,
- `TENANT_ID` int(11) DEFAULT NULL,
- `TENANT_DOMAIN` varchar(255) DEFAULT NULL,
- `CARTRIDGE_TYPE` varchar(255) NOT NULL,
- `STATE` varchar(255) NOT NULL,
- `CLUSTER_DOMAIN` varchar(255) NOT NULL,
- `CLUSTER_SUBDOMAIN` varchar(255) NOT NULL,
- PRIMARY KEY (`ID`)
-) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
-
---
--- Definition of table `stratos_foundation`.`CARTRIDGE_SUBSCRIPTION`
---
-
-DROP TABLE IF EXISTS `stratos_foundation`.`CARTRIDGE_SUBSCRIPTION`;
-CREATE TABLE `stratos_foundation`.`CARTRIDGE_SUBSCRIPTION` (
- `SUBSCRIPTION_ID` int(11) NOT NULL AUTO_INCREMENT,
- `TENANT_ID` int(11) NOT NULL,
- `CARTRIDGE` varchar(30) NOT NULL,
- `PROVIDER` varchar(30) NOT NULL,
- `HOSTNAME` varchar(255) NOT NULL,
- `POLICY` varchar(50) NULL,
- `CLUSTER_DOMAIN` varchar(255) NOT NULL,
- `CLUSTER_SUBDOMAIN` varchar(255) NOT NULL,
- `MGT_DOMAIN` varchar(255) NOT NULL,
- `MGT_SUBDOMAIN` varchar(255) NOT NULL,
- `STATE` varchar(30) NOT NULL,
- `ALIAS` varchar(255) NOT NULL,
- `TENANT_DOMAIN` 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;
-
-
-
---
--- Definition of table `stratos_foundation`.`DATA_CARTRIDGE`
---
-
-DROP TABLE IF EXISTS `stratos_foundation`.`DATA_CARTRIDGE`;
-CREATE TABLE `stratos_foundation`.`DATA_CARTRIDGE` (
- `DATA_CART_ID` int(11) NOT NULL AUTO_INCREMENT,
- `TYPE` varchar(30) NOT NULL,
- `USER_NAME` varchar(255) NOT NULL,
- `PASSWORD` varchar(255) NOT NULL,
- `STATE` varchar(255) NOT NULL,
- PRIMARY KEY (`DATA_CART_ID`) USING BTREE
-) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
-
-
---
--- Definition of table `stratos_foundation`.`PORT_MAPPING`
---
-
-DROP TABLE IF EXISTS `stratos_foundation`.`PORT_MAPPING`;
-CREATE TABLE `stratos_foundation`.`PORT_MAPPING` (
- `PORT_MAPPING_ID` int(11) NOT NULL AUTO_INCREMENT,
- `SUBSCRIPTION_ID` int(11) NOT NULL,
- `TYPE` varchar(30) NOT NULL,
- `PRIMARY_PORT` varchar(30) NOT NULL,
- `PROXY_PORT` varchar(30) NOT NULL,
- `STATE` varchar(30) NOT NULL,
- PRIMARY KEY (`PORT_MAPPING_ID`)
-) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
-
-
---
--- Definition of table `stratos_foundation`.`REPOSITORY`
---
-
-DROP TABLE IF EXISTS `stratos_foundation`.`REPOSITORY`;
-CREATE TABLE `stratos_foundation`.`REPOSITORY` (
- `REPO_ID` int(11) NOT NULL AUTO_INCREMENT,
- `REPO_NAME` varchar(255) NOT NULL,
- `STATE` varchar(30) NOT NULL,
- `REPO_USER_NAME` varchar(255) NOT NULL,
- `REPO_USER_PASSWORD` varchar(255) NOT NULL,
- PRIMARY KEY (`REPO_ID`)
-) 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 */;
-/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
-/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
-/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
-/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/4762e5d1/tools/stratos-installer/resources/userstore.sql
----------------------------------------------------------------------
diff --git a/tools/stratos-installer/resources/userstore.sql b/tools/stratos-installer/resources/userstore.sql
deleted file mode 100644
index a82fc61..0000000
--- a/tools/stratos-installer/resources/userstore.sql
+++ /dev/null
@@ -1,481 +0,0 @@
-/*
-* Licensed to the Apache Software Foundation (ASF) under one
-* or more contributor license agreements. See the NOTICE file
-* distributed with this work for additional information
-* regarding copyright ownership. The ASF licenses this file
-* to you under the Apache License, Version 2.0 (the
-* "License"); you may not use this file except in compliance
-* with the License. You may obtain a copy of the License at
-*
-* http://www.apache.org/licenses/LICENSE-2.0
-*
-* Unless required by applicable law or agreed to in writing,
-* software distributed under the License is distributed on an
-* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-* KIND, either express or implied. See the License for the
-* specific language governing permissions and limitations
-* under the License.
-*/
-
-CREATE DATABASE IF NOT EXISTS userstore;
-USE userstore;
-
-CREATE TABLE IF NOT EXISTS REG_CLUSTER_LOCK (
- REG_LOCK_NAME VARCHAR (20),
- REG_LOCK_STATUS VARCHAR (20),
- REG_LOCKED_TIME TIMESTAMP,
- REG_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (REG_LOCK_NAME)
-)ENGINE INNODB;
-
-CREATE TABLE IF NOT EXISTS REG_LOG (
- REG_LOG_ID INTEGER AUTO_INCREMENT,
- REG_PATH VARCHAR (750),
- REG_USER_ID VARCHAR (31) NOT NULL,
- REG_LOGGED_TIME TIMESTAMP NOT NULL,
- REG_ACTION INTEGER NOT NULL,
- REG_ACTION_DATA VARCHAR (500),
- REG_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (REG_LOG_ID, REG_TENANT_ID)
-)ENGINE INNODB;
-
--- The REG_PATH_VALUE should be less than 767 bytes, and hence was fixed at 750.
--- See CARBON-5917.
-
-CREATE TABLE IF NOT EXISTS REG_PATH(
- REG_PATH_ID INTEGER NOT NULL AUTO_INCREMENT,
- REG_PATH_VALUE VARCHAR(750) NOT NULL,
- REG_PATH_PARENT_ID INTEGER,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_PATH PRIMARY KEY(REG_PATH_ID, REG_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE INDEX REG_PATH_IND_BY_PATH_VALUE USING HASH ON REG_PATH(REG_PATH_VALUE, REG_TENANT_ID);
-CREATE INDEX REG_PATH_IND_BY_PATH_PARENT_ID USING HASH ON REG_PATH(REG_PATH_PARENT_ID, REG_TENANT_ID);
-
-CREATE TABLE IF NOT EXISTS REG_CONTENT (
- REG_CONTENT_ID INTEGER NOT NULL AUTO_INCREMENT,
- REG_CONTENT_DATA LONGBLOB,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_CONTENT PRIMARY KEY(REG_CONTENT_ID, REG_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE IF NOT EXISTS REG_CONTENT_HISTORY (
- REG_CONTENT_ID INTEGER NOT NULL,
- REG_CONTENT_DATA LONGBLOB,
- REG_DELETED SMALLINT,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_CONTENT_HISTORY PRIMARY KEY(REG_CONTENT_ID, REG_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE IF NOT EXISTS REG_RESOURCE (
- REG_PATH_ID INTEGER NOT NULL,
- REG_NAME VARCHAR(256),
- REG_VERSION INTEGER NOT NULL AUTO_INCREMENT,
- REG_MEDIA_TYPE VARCHAR(500),
- REG_CREATOR VARCHAR(31) NOT NULL,
- REG_CREATED_TIME TIMESTAMP NOT NULL DEFAULT 0,
- REG_LAST_UPDATOR VARCHAR(31),
- REG_LAST_UPDATED_TIME TIMESTAMP NOT NULL DEFAULT 0,
- REG_DESCRIPTION VARCHAR(1000),
- REG_CONTENT_ID INTEGER,
- REG_TENANT_ID INTEGER DEFAULT 0,
- REG_UUID VARCHAR(100) NOT NULL,
- CONSTRAINT PK_REG_RESOURCE PRIMARY KEY(REG_VERSION, REG_TENANT_ID)
-)ENGINE INNODB;
-
-ALTER TABLE REG_RESOURCE ADD CONSTRAINT REG_RESOURCE_FK_BY_PATH_ID FOREIGN KEY (REG_PATH_ID, REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID, REG_TENANT_ID);
-ALTER TABLE REG_RESOURCE ADD CONSTRAINT REG_RESOURCE_FK_BY_CONTENT_ID FOREIGN KEY (REG_CONTENT_ID, REG_TENANT_ID) REFERENCES REG_CONTENT (REG_CONTENT_ID, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_IND_BY_NAME USING HASH ON REG_RESOURCE(REG_NAME, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_IND_BY_PATH_ID_NAME USING HASH ON REG_RESOURCE(REG_PATH_ID, REG_NAME, REG_TENANT_ID);
-
-CREATE TABLE IF NOT EXISTS REG_RESOURCE_HISTORY (
- REG_PATH_ID INTEGER NOT NULL,
- REG_NAME VARCHAR(256),
- REG_VERSION INTEGER NOT NULL,
- REG_MEDIA_TYPE VARCHAR(500),
- REG_CREATOR VARCHAR(31) NOT NULL,
- REG_CREATED_TIME TIMESTAMP NOT NULL,
- REG_LAST_UPDATOR VARCHAR(31),
- REG_LAST_UPDATED_TIME TIMESTAMP NOT NULL,
- REG_DESCRIPTION VARCHAR(1000),
- REG_CONTENT_ID INTEGER,
- REG_DELETED SMALLINT,
- REG_TENANT_ID INTEGER DEFAULT 0,
- REG_UUID VARCHAR(100) NOT NULL,
- CONSTRAINT PK_REG_RESOURCE_HISTORY PRIMARY KEY(REG_VERSION, REG_TENANT_ID)
-)ENGINE INNODB;
-
-ALTER TABLE REG_RESOURCE_HISTORY ADD CONSTRAINT REG_RESOURCE_HIST_FK_BY_PATHID FOREIGN KEY (REG_PATH_ID, REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID, REG_TENANT_ID);
-ALTER TABLE REG_RESOURCE_HISTORY ADD CONSTRAINT REG_RESOURCE_HIST_FK_BY_CONTENT_ID FOREIGN KEY (REG_CONTENT_ID, REG_TENANT_ID) REFERENCES REG_CONTENT_HISTORY (REG_CONTENT_ID, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_HISTORY_IND_BY_NAME USING HASH ON REG_RESOURCE_HISTORY(REG_NAME, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_HISTORY_IND_BY_PATH_ID_NAME USING HASH ON REG_RESOURCE(REG_PATH_ID, REG_NAME, REG_TENANT_ID);
-
-CREATE TABLE IF NOT EXISTS REG_COMMENT (
- REG_ID INTEGER NOT NULL AUTO_INCREMENT,
- REG_COMMENT_TEXT VARCHAR(500) NOT NULL,
- REG_USER_ID VARCHAR(31) NOT NULL,
- REG_COMMENTED_TIME TIMESTAMP NOT NULL,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_COMMENT PRIMARY KEY(REG_ID, REG_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE IF NOT EXISTS REG_RESOURCE_COMMENT (
- REG_COMMENT_ID INTEGER NOT NULL,
- REG_VERSION INTEGER,
- REG_PATH_ID INTEGER,
- REG_RESOURCE_NAME VARCHAR(256),
- REG_TENANT_ID INTEGER DEFAULT 0
-)ENGINE INNODB;
-
-ALTER TABLE REG_RESOURCE_COMMENT ADD CONSTRAINT REG_RESOURCE_COMMENT_FK_BY_PATH_ID FOREIGN KEY (REG_PATH_ID, REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID, REG_TENANT_ID);
-ALTER TABLE REG_RESOURCE_COMMENT ADD CONSTRAINT REG_RESOURCE_COMMENT_FK_BY_COMMENT_ID FOREIGN KEY (REG_COMMENT_ID, REG_TENANT_ID) REFERENCES REG_COMMENT (REG_ID, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_COMMENT_IND_BY_PATH_ID_AND_RESOURCE_NAME USING HASH ON REG_RESOURCE_COMMENT(REG_PATH_ID, REG_RESOURCE_NAME, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_COMMENT_IND_BY_VERSION USING HASH ON REG_RESOURCE_COMMENT(REG_VERSION, REG_TENANT_ID);
-
-CREATE TABLE IF NOT EXISTS REG_RATING (
- REG_ID INTEGER NOT NULL AUTO_INCREMENT,
- REG_RATING INTEGER NOT NULL,
- REG_USER_ID VARCHAR(31) NOT NULL,
- REG_RATED_TIME TIMESTAMP NOT NULL,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_RATING PRIMARY KEY(REG_ID, REG_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE IF NOT EXISTS REG_RESOURCE_RATING (
- REG_RATING_ID INTEGER NOT NULL,
- REG_VERSION INTEGER,
- REG_PATH_ID INTEGER,
- REG_RESOURCE_NAME VARCHAR(256),
- REG_TENANT_ID INTEGER DEFAULT 0
-)ENGINE INNODB;
-
-ALTER TABLE REG_RESOURCE_RATING ADD CONSTRAINT REG_RESOURCE_RATING_FK_BY_PATH_ID FOREIGN KEY (REG_PATH_ID, REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID, REG_TENANT_ID);
-ALTER TABLE REG_RESOURCE_RATING ADD CONSTRAINT REG_RESOURCE_RATING_FK_BY_RATING_ID FOREIGN KEY (REG_RATING_ID, REG_TENANT_ID) REFERENCES REG_RATING (REG_ID, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_RATING_IND_BY_PATH_ID_AND_RESOURCE_NAME USING HASH ON REG_RESOURCE_RATING(REG_PATH_ID, REG_RESOURCE_NAME, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_RATING_IND_BY_VERSION USING HASH ON REG_RESOURCE_RATING(REG_VERSION, REG_TENANT_ID);
-
-
-CREATE TABLE IF NOT EXISTS REG_TAG (
- REG_ID INTEGER NOT NULL AUTO_INCREMENT,
- REG_TAG_NAME VARCHAR(500) NOT NULL,
- REG_USER_ID VARCHAR(31) NOT NULL,
- REG_TAGGED_TIME TIMESTAMP NOT NULL,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_TAG PRIMARY KEY(REG_ID, REG_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE IF NOT EXISTS REG_RESOURCE_TAG (
- REG_TAG_ID INTEGER NOT NULL,
- REG_VERSION INTEGER,
- REG_PATH_ID INTEGER,
- REG_RESOURCE_NAME VARCHAR(256),
- REG_TENANT_ID INTEGER DEFAULT 0
-)ENGINE INNODB;
-
-ALTER TABLE REG_RESOURCE_TAG ADD CONSTRAINT REG_RESOURCE_TAG_FK_BY_PATH_ID FOREIGN KEY (REG_PATH_ID, REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID, REG_TENANT_ID);
-ALTER TABLE REG_RESOURCE_TAG ADD CONSTRAINT REG_RESOURCE_TAG_FK_BY_TAG_ID FOREIGN KEY (REG_TAG_ID, REG_TENANT_ID) REFERENCES REG_TAG (REG_ID, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_TAG_IND_BY_PATH_ID_AND_RESOURCE_NAME USING HASH ON REG_RESOURCE_TAG(REG_PATH_ID, REG_RESOURCE_NAME, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_TAG_IND_BY_VERSION USING HASH ON REG_RESOURCE_TAG(REG_VERSION, REG_TENANT_ID);
-
-CREATE TABLE IF NOT EXISTS REG_PROPERTY (
- REG_ID INTEGER NOT NULL AUTO_INCREMENT,
- REG_NAME VARCHAR(100) NOT NULL,
- REG_VALUE VARCHAR(1000),
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_PROPERTY PRIMARY KEY(REG_ID, REG_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE IF NOT EXISTS REG_RESOURCE_PROPERTY (
- REG_PROPERTY_ID INTEGER NOT NULL,
- REG_VERSION INTEGER,
- REG_PATH_ID INTEGER,
- REG_RESOURCE_NAME VARCHAR(256),
- REG_TENANT_ID INTEGER DEFAULT 0
-)ENGINE INNODB;
-
-ALTER TABLE REG_RESOURCE_PROPERTY ADD CONSTRAINT REG_RESOURCE_PROPERTY_FK_BY_PATH_ID FOREIGN KEY (REG_PATH_ID, REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID, REG_TENANT_ID);
-ALTER TABLE REG_RESOURCE_PROPERTY ADD CONSTRAINT REG_RESOURCE_PROPERTY_FK_BY_TAG_ID FOREIGN KEY (REG_PROPERTY_ID, REG_TENANT_ID) REFERENCES REG_PROPERTY (REG_ID, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_PROPERTY_IND_BY_PATH_ID_AND_RESOURCE_NAME USING HASH ON REG_RESOURCE_PROPERTY(REG_PATH_ID, REG_RESOURCE_NAME, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_PROPERTY_IND_BY_VERSION USING HASH ON REG_RESOURCE_PROPERTY(REG_VERSION, REG_TENANT_ID);
-
--- CREATE TABLE IF NOT EXISTS REG_ASSOCIATIONS (
--- SRC_PATH_ID INTEGER,
--- SRC_RESOURCE_NAME VARCHAR(256),
--- SRC_VERSION INTEGER,
--- TGT_PATH_ID INTEGER,
--- TGT_RESOURCE_NAME VARCHAR(256),
--- TGT_VERSION INTEGER
--- )ENGINE INNODB;
---
--- ALTER TABLE REG_ASSOCIATIONS ADD CONSTRAINT REG_ASSOCIATIONS_FK_BY_SRC_PATH_ID FOREIGN KEY (SRC_PATH_ID) REFERENCES REG_PATH (PATH_ID);
--- ALTER TABLE REG_ASSOCIATIONS ADD CONSTRAINT REG_ASSOCIATIONS_FK_BY_TGT_PATH_ID FOREIGN KEY (TGT_PATH_ID) REFERENCES REG_PATH (PATH_ID);
--- CREATE INDEX REG_ASSOCIATIONS_IND_BY_SRC_VERSION ON REG_ASSOCIATIONS(SRC_VERSION);
--- CREATE INDEX REG_ASSOCIATIONS_IND_BY_TGT_VERSION ON REG_ASSOCIATIONS(TGT_VERSION);
--- CREATE INDEX REG_ASSOCIATIONS_IND_BY_SRC_RESOURCE_NAME ON REG_ASSOCIATIONS(SRC_RESOURCE_NAME);
--- CREATE INDEX REG_ASSOCIATIONS_IND_BY_TGT_RESOURCE_NAME ON REG_ASSOCIATIONS(TGT_RESOURCE_NAME);
-
-
-
-CREATE TABLE IF NOT EXISTS REG_ASSOCIATION (
- REG_ASSOCIATION_ID INTEGER AUTO_INCREMENT,
- REG_SOURCEPATH VARCHAR (750) NOT NULL,
- REG_TARGETPATH VARCHAR (750) NOT NULL,
- REG_ASSOCIATION_TYPE VARCHAR (2000) NOT NULL,
- REG_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (REG_ASSOCIATION_ID, REG_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE IF NOT EXISTS REG_SNAPSHOT (
- REG_SNAPSHOT_ID INTEGER NOT NULL AUTO_INCREMENT,
- REG_PATH_ID INTEGER NOT NULL,
- REG_RESOURCE_NAME VARCHAR(255),
- REG_RESOURCE_VIDS LONGBLOB NOT NULL,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_SNAPSHOT PRIMARY KEY(REG_SNAPSHOT_ID, REG_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE INDEX REG_SNAPSHOT_IND_BY_PATH_ID_AND_RESOURCE_NAME USING HASH ON REG_SNAPSHOT(REG_PATH_ID, REG_RESOURCE_NAME, REG_TENANT_ID);
-
-ALTER TABLE REG_SNAPSHOT ADD CONSTRAINT REG_SNAPSHOT_FK_BY_PATH_ID FOREIGN KEY (REG_PATH_ID, REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID, REG_TENANT_ID);
-
-
--- ################################
--- USER MANAGER TABLES
--- ################################
-
-CREATE TABLE UM_TENANT (
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_DOMAIN_NAME VARCHAR(255) NOT NULL,
- UM_EMAIL VARCHAR(255),
- UM_ACTIVE BOOLEAN DEFAULT FALSE,
- UM_CREATED_DATE TIMESTAMP NOT NULL,
- UM_USER_CONFIG LONGBLOB,
- PRIMARY KEY (UM_ID),
- UNIQUE(UM_DOMAIN_NAME)
-)ENGINE INNODB;
-
-CREATE TABLE UM_DOMAIN(
- UM_DOMAIN_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_DOMAIN_NAME VARCHAR(255),
- UM_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (UM_DOMAIN_ID, UM_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE UNIQUE INDEX INDEX_UM_TENANT_UM_DOMAIN_NAME
- ON UM_TENANT (UM_DOMAIN_NAME);
-
-CREATE TABLE UM_USER (
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_USER_NAME VARCHAR(255) NOT NULL,
- UM_USER_PASSWORD VARCHAR(255) NOT NULL,
- UM_SALT_VALUE VARCHAR(31),
- UM_REQUIRE_CHANGE BOOLEAN DEFAULT FALSE,
- UM_CHANGED_TIME TIMESTAMP NOT NULL,
- UM_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (UM_ID, UM_TENANT_ID),
- UNIQUE(UM_USER_NAME, UM_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE UM_SYSTEM_USER (
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_USER_NAME VARCHAR(255) NOT NULL,
- UM_USER_PASSWORD VARCHAR(255) NOT NULL,
- UM_SALT_VALUE VARCHAR(31),
- UM_REQUIRE_CHANGE BOOLEAN DEFAULT FALSE,
- UM_CHANGED_TIME TIMESTAMP NOT NULL,
- UM_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (UM_ID, UM_TENANT_ID),
- UNIQUE(UM_USER_NAME, UM_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE UM_ROLE (
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_ROLE_NAME VARCHAR(255) NOT NULL,
- UM_TENANT_ID INTEGER DEFAULT 0,
- UM_SHARED_ROLE BOOLEAN DEFAULT FALSE,
- PRIMARY KEY (UM_ID, UM_TENANT_ID),
- UNIQUE(UM_ROLE_NAME, UM_TENANT_ID)
-)ENGINE INNODB;
-
-
-CREATE TABLE UM_MODULE(
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_MODULE_NAME VARCHAR(100),
- UNIQUE(UM_MODULE_NAME),
- PRIMARY KEY(UM_ID)
-)ENGINE INNODB;
-
-CREATE TABLE UM_MODULE_ACTIONS(
- UM_ACTION VARCHAR(255) NOT NULL,
- UM_MODULE_ID INTEGER NOT NULL,
- PRIMARY KEY(UM_ACTION, UM_MODULE_ID),
- FOREIGN KEY (UM_MODULE_ID) REFERENCES UM_MODULE(UM_ID) ON DELETE CASCADE
-)ENGINE INNODB;
-
-CREATE TABLE UM_PERMISSION (
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_RESOURCE_ID VARCHAR(255) NOT NULL,
- UM_ACTION VARCHAR(255) NOT NULL,
- UM_TENANT_ID INTEGER DEFAULT 0,
- UM_MODULE_ID INTEGER DEFAULT 0,
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE INDEX INDEX_UM_PERMISSION_UM_RESOURCE_ID_UM_ACTION ON UM_PERMISSION (UM_RESOURCE_ID, UM_ACTION, UM_TENANT_ID);
-
-CREATE TABLE UM_ROLE_PERMISSION (
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_PERMISSION_ID INTEGER NOT NULL,
- UM_ROLE_NAME VARCHAR(255) NOT NULL,
- UM_IS_ALLOWED SMALLINT NOT NULL,
- UM_TENANT_ID INTEGER DEFAULT 0,
- UM_DOMAIN_ID INTEGER,
- UNIQUE (UM_PERMISSION_ID, UM_ROLE_NAME, UM_TENANT_ID, UM_DOMAIN_ID),
- FOREIGN KEY (UM_PERMISSION_ID, UM_TENANT_ID) REFERENCES UM_PERMISSION(UM_ID, UM_TENANT_ID),
- FOREIGN KEY (UM_DOMAIN_ID, UM_TENANT_ID) REFERENCES UM_DOMAIN(UM_DOMAIN_ID, UM_TENANT_ID) ON DELETE CASCADE,
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-)ENGINE INNODB;
-
--- REMOVED UNIQUE (UM_PERMISSION_ID, UM_ROLE_ID)
-CREATE TABLE UM_USER_PERMISSION (
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_PERMISSION_ID INTEGER NOT NULL,
- UM_USER_NAME VARCHAR(255) NOT NULL,
- UM_IS_ALLOWED SMALLINT NOT NULL,
- UM_TENANT_ID INTEGER DEFAULT 0,
- FOREIGN KEY (UM_PERMISSION_ID, UM_TENANT_ID) REFERENCES UM_PERMISSION(UM_ID, UM_TENANT_ID),
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-)ENGINE INNODB;
-
--- REMOVED UNIQUE (UM_PERMISSION_ID, UM_USER_ID)
-CREATE TABLE UM_USER_ROLE (
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_ROLE_ID INTEGER NOT NULL,
- UM_USER_ID INTEGER NOT NULL,
- UM_TENANT_ID INTEGER DEFAULT 0,
- UNIQUE (UM_USER_ID, UM_ROLE_ID, UM_TENANT_ID),
- FOREIGN KEY (UM_ROLE_ID, UM_TENANT_ID) REFERENCES UM_ROLE(UM_ID, UM_TENANT_ID),
- FOREIGN KEY (UM_USER_ID, UM_TENANT_ID) REFERENCES UM_USER(UM_ID, UM_TENANT_ID),
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE UM_SHARED_USER_ROLE(
- UM_ROLE_ID INTEGER NOT NULL,
- UM_USER_ID INTEGER NOT NULL,
- UM_USER_TENANT_ID INTEGER NOT NULL,
- UM_ROLE_TENANT_ID INTEGER NOT NULL,
- UNIQUE(UM_USER_ID,UM_ROLE_ID,UM_USER_TENANT_ID, UM_ROLE_TENANT_ID),
- FOREIGN KEY(UM_ROLE_ID,UM_ROLE_TENANT_ID) REFERENCES UM_ROLE(UM_ID,UM_TENANT_ID) ON DELETE CASCADE,
- FOREIGN KEY(UM_USER_ID,UM_USER_TENANT_ID) REFERENCES UM_USER(UM_ID,UM_TENANT_ID) ON DELETE CASCADE
-)ENGINE INNODB;
-
-CREATE TABLE UM_ACCOUNT_MAPPING(
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_USER_NAME VARCHAR(255) NOT NULL,
- UM_TENANT_ID INTEGER NOT NULL,
- UM_USER_STORE_DOMAIN VARCHAR(100),
- UM_ACC_LINK_ID INTEGER NOT NULL,
- UNIQUE(UM_USER_NAME, UM_TENANT_ID, UM_USER_STORE_DOMAIN, UM_ACC_LINK_ID),
- FOREIGN KEY (UM_TENANT_ID) REFERENCES UM_TENANT(UM_ID) ON DELETE CASCADE,
- PRIMARY KEY (UM_ID)
-)ENGINE INNODB;
-
-
-CREATE TABLE UM_USER_ATTRIBUTE (
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_ATTR_NAME VARCHAR(255) NOT NULL,
- UM_ATTR_VALUE VARCHAR(1024),
- UM_PROFILE_ID VARCHAR(255),
- UM_USER_ID INTEGER,
- UM_TENANT_ID INTEGER DEFAULT 0,
- FOREIGN KEY (UM_USER_ID, UM_TENANT_ID) REFERENCES UM_USER(UM_ID, UM_TENANT_ID),
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-)ENGINE INNODB;
-
-
-
-CREATE TABLE UM_DIALECT(
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_DIALECT_URI VARCHAR(255) NOT NULL,
- UM_TENANT_ID INTEGER DEFAULT 0,
- UNIQUE(UM_DIALECT_URI, UM_TENANT_ID),
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE UM_CLAIM(
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_DIALECT_ID INTEGER NOT NULL,
- UM_CLAIM_URI VARCHAR(255) NOT NULL,
- UM_DISPLAY_TAG VARCHAR(255),
- UM_DESCRIPTION VARCHAR(255),
- UM_MAPPED_ATTRIBUTE_DOMAIN VARCHAR(255),
- UM_MAPPED_ATTRIBUTE VARCHAR(255),
- UM_REG_EX VARCHAR(255),
- UM_SUPPORTED SMALLINT,
- UM_REQUIRED SMALLINT,
- UM_DISPLAY_ORDER INTEGER,
- UM_CHECKED_ATTRIBUTE SMALLINT,
- UM_READ_ONLY SMALLINT,
- UM_TENANT_ID INTEGER DEFAULT 0,
- UNIQUE(UM_DIALECT_ID, UM_CLAIM_URI, UM_TENANT_ID,UM_MAPPED_ATTRIBUTE_DOMAIN),
- FOREIGN KEY(UM_DIALECT_ID, UM_TENANT_ID) REFERENCES UM_DIALECT(UM_ID, UM_TENANT_ID),
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-)ENGINE INNODB;
-
-
-CREATE TABLE UM_PROFILE_CONFIG(
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_DIALECT_ID INTEGER NOT NULL,
- UM_PROFILE_NAME VARCHAR(255),
- UM_TENANT_ID INTEGER DEFAULT 0,
- FOREIGN KEY(UM_DIALECT_ID, UM_TENANT_ID) REFERENCES UM_DIALECT(UM_ID, UM_TENANT_ID),
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-)ENGINE INNODB;
-
-
-CREATE TABLE UM_HYBRID_ROLE(
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_ROLE_NAME VARCHAR(255),
- UM_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE UM_HYBRID_USER_ROLE(
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_USER_NAME VARCHAR(255),
- UM_ROLE_ID INTEGER NOT NULL,
- UM_TENANT_ID INTEGER DEFAULT 0,
- UM_DOMAIN_ID INTEGER,
- UNIQUE (UM_USER_NAME, UM_ROLE_ID, UM_TENANT_ID, UM_DOMAIN_ID),
- FOREIGN KEY (UM_ROLE_ID, UM_TENANT_ID) REFERENCES UM_HYBRID_ROLE(UM_ID, UM_TENANT_ID),
- FOREIGN KEY (UM_DOMAIN_ID, UM_TENANT_ID) REFERENCES UM_DOMAIN(UM_DOMAIN_ID, UM_TENANT_ID) ON DELETE CASCADE,
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE UM_SYSTEM_ROLE(
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_ROLE_NAME VARCHAR(255),
- UM_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE UM_SYSTEM_USER_ROLE(
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_USER_NAME VARCHAR(255),
- UM_ROLE_ID INTEGER NOT NULL,
- UM_TENANT_ID INTEGER DEFAULT 0,
- UNIQUE (UM_USER_NAME, UM_ROLE_ID, UM_TENANT_ID),
- FOREIGN KEY (UM_ROLE_ID, UM_TENANT_ID) REFERENCES UM_SYSTEM_ROLE(UM_ID, UM_TENANT_ID),
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-)ENGINE INNODB;
-
-
-CREATE TABLE UM_HYBRID_REMEMBER_ME(
- UM_ID INTEGER NOT NULL AUTO_INCREMENT,
- UM_USER_NAME VARCHAR(255) NOT NULL,
- UM_COOKIE_VALUE VARCHAR(1024),
- UM_CREATED_TIME TIMESTAMP,
- UM_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-)ENGINE INNODB;
http://git-wip-us.apache.org/repos/asf/incubator-stratos/blob/4762e5d1/tools/stratos-installer/stratos-setup.sh
----------------------------------------------------------------------
diff --git a/tools/stratos-installer/stratos-setup.sh b/tools/stratos-installer/stratos-setup.sh
index 8f9519a..6183895 100755
--- a/tools/stratos-installer/stratos-setup.sh
+++ b/tools/stratos-installer/stratos-setup.sh
@@ -29,7 +29,6 @@ set -e
source "./conf/stratos-setup.conf"
export LOG=$log_path/stratos-setup.log
-profile_list="default;cc;as;sm"
profile="default"
config_mb="true"
activemq_client_libs=(activemq-broker-5.8.0.jar activemq-client-5.8.0.jar geronimo-j2ee-management_1.1_spec-1.0.1.jar geronimo-jms_1.1_spec-1.1.1.jar hawtbuf-1.2.jar)
@@ -483,31 +482,31 @@ do
esac
done
-arr=$(echo $profile_list | tr " " "\n")
-
-for x in $arr
-do
- if [[ $x = "default" ]]; then
- profile="default"
- elif [[ $x = "cc" ]]; then
- profile="cc"
- elif [[ $x = "as" ]]; then
- profile="as"
- elif [[ $x = "sm" ]]; then
- profile="sm"
- else
- echo "Inavlid profile : 'default' profile will be selected."
- fi
-done
-
-echo "You have selected profile : $profile"
-
profile_list=`echo $profile_list | sed 's/^ *//g' | sed 's/ *$//g'`
-if [[ -z $profile_list || $profile_list = "" ]]; then
- help
- exit 1
+if [[ !(-z $profile_list || $profile_list = "") ]]; then
+ arr=$(echo $profile_list | tr " " "\n")
+echo $arr
+ for x in $arr
+ do
+ if [[ $x = "default" ]]; then
+ profile="default"
+ elif [[ $x = "cc" ]]; then
+ profile="cc"
+ elif [[ $x = "as" ]]; then
+ profile="as"
+ elif [[ $x = "sm" ]]; then
+ profile="sm"
+ else
+ echo "Invalid profile."
+ exit 1
+ fi
+ done
+ echo "You have selected the profile : $profile"
+else
+ echo "You have not provided a profile : default profile will be selected."
fi
+
if [[ $host_user == "" ]]; then
echo "user provided in conf/stratos-setup.conf is null. Please provide a user"
exit 1