You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@stratos.apache.org by ud...@apache.org on 2014/12/15 06:13:01 UTC

stratos git commit: renaming database files

Repository: stratos
Updated Branches:
  refs/heads/4.1.0-test 06ca4ca8a -> 8388e3322


renaming database files


Project: http://git-wip-us.apache.org/repos/asf/stratos/repo
Commit: http://git-wip-us.apache.org/repos/asf/stratos/commit/8388e332
Tree: http://git-wip-us.apache.org/repos/asf/stratos/tree/8388e332
Diff: http://git-wip-us.apache.org/repos/asf/stratos/diff/8388e332

Branch: refs/heads/4.1.0-test
Commit: 8388e33225fcf72aec8a6b4f5be6dcf95d66c1c0
Parents: 06ca4ca
Author: Udara Liyanage <ud...@wso2.com>
Authored: Mon Dec 15 10:42:45 2014 +0530
Committer: Udara Liyanage <ud...@wso2.com>
Committed: Mon Dec 15 10:42:45 2014 +0530

----------------------------------------------------------------------
 .../resources/application-sql.mysql             | 274 -------------------
 1 file changed, 274 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/stratos/blob/8388e332/tools/stratos-installer/resources/application-sql.mysql
----------------------------------------------------------------------
diff --git a/tools/stratos-installer/resources/application-sql.mysql b/tools/stratos-installer/resources/application-sql.mysql
deleted file mode 100755
index b8c9c26..0000000
--- a/tools/stratos-installer/resources/application-sql.mysql
+++ /dev/null
@@ -1,274 +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 schema userstore
---
-
-CREATE DATABASE IF NOT EXISTS USERSTORE_DB_SCHEMA;
-USE USERSTORE_DB_SCHEMA;
-
-CREATE TABLE IF NOT EXISTS SP_APP (
-            ID INTEGER NOT NULL AUTO_INCREMENT,
-            TENANT_ID INTEGER NOT NULL,
-	    	APP_NAME VARCHAR (255) NOT NULL ,
-	    	USER_STORE VARCHAR (255) NOT NULL,
-            USERNAME VARCHAR (255) NOT NULL ,
-            DESCRIPTION VARCHAR (1024),
-	    	ROLE_CLAIM VARCHAR (512),
-            AUTH_TYPE VARCHAR (255) NOT NULL,
-	    	PROVISIONING_USERSTORE_DOMAIN VARCHAR (512),
-	    	IS_LOCAL_CLAIM_DIALECT CHAR(1) DEFAULT '1',
-	    	IS_SEND_LOCAL_SUBJECT_ID CHAR(1) DEFAULT '0',
-	    	IS_SEND_AUTH_LIST_OF_IDPS CHAR(1) DEFAULT '0',
-	    	SUBJECT_CLAIM_URI VARCHAR (512),
-	    	IS_SAAS_APP CHAR(1) DEFAULT '0',
-            PRIMARY KEY (ID)
-)ENGINE INNODB;
-
-ALTER TABLE SP_APP ADD CONSTRAINT APPLICATION_NAME_CONSTRAINT UNIQUE(APP_NAME, TENANT_ID);
-
-CREATE TABLE IF NOT EXISTS SP_INBOUND_AUTH (
-            ID INTEGER NOT NULL AUTO_INCREMENT,
-	     	TENANT_ID INTEGER NOT NULL,
-	     	INBOUND_AUTH_KEY VARCHAR (255) NOT NULL,
-            INBOUND_AUTH_TYPE VARCHAR (255) NOT NULL,
-            PROP_NAME VARCHAR (255),
-            PROP_VALUE VARCHAR (1024) ,
-	     	APP_ID INTEGER NOT NULL,
-            PRIMARY KEY (ID)
-)ENGINE INNODB;
-
-ALTER TABLE SP_INBOUND_AUTH ADD CONSTRAINT APPLICATION_ID_CONSTRAINT FOREIGN KEY (APP_ID) REFERENCES SP_APP (ID) ON DELETE CASCADE;
-
-CREATE TABLE IF NOT EXISTS SP_AUTH_STEP (
-            ID INTEGER NOT NULL AUTO_INCREMENT,
-            TENANT_ID INTEGER NOT NULL,
-	     	STEP_ORDER INTEGER DEFAULT 1,
-            APP_ID INTEGER NOT NULL ,
-            IS_SUBJECT_STEP CHAR(1) DEFAULT '0',
-            IS_ATTRIBUTE_STEP CHAR(1) DEFAULT '0',
-            PRIMARY KEY (ID)
-)ENGINE INNODB;
-
-ALTER TABLE SP_AUTH_STEP ADD CONSTRAINT APPLICATION_ID_CONSTRAINT_STEP FOREIGN KEY (APP_ID) REFERENCES SP_APP (ID) ON DELETE CASCADE;
-
-CREATE TABLE IF NOT EXISTS SP_FEDERATED_IDP (
-            ID INTEGER NOT NULL,
-            TENANT_ID INTEGER NOT NULL,
-            AUTHENTICATOR_ID INTEGER NOT NULL,
-            PRIMARY KEY (ID, AUTHENTICATOR_ID)
-)ENGINE INNODB;
-
-ALTER TABLE SP_FEDERATED_IDP ADD CONSTRAINT STEP_ID_CONSTRAINT FOREIGN KEY (ID) REFERENCES SP_AUTH_STEP (ID) ON DELETE CASCADE;
-
-CREATE TABLE IF NOT EXISTS SP_CLAIM_MAPPING (
-	    	ID INTEGER NOT NULL AUTO_INCREMENT,
-	    	TENANT_ID INTEGER NOT NULL,
-	    	IDP_CLAIM VARCHAR (512) NOT NULL ,
-            SP_CLAIM VARCHAR (512) NOT NULL ,
-	   		APP_ID INTEGER NOT NULL,
-	    	IS_REQUESTED VARCHAR(128) DEFAULT '0',
-			DEFAULT_VALUE VARCHAR(255),
-            PRIMARY KEY (ID)
-)ENGINE INNODB;
-
-ALTER TABLE SP_CLAIM_MAPPING ADD CONSTRAINT CLAIMID_APPID_CONSTRAINT FOREIGN KEY (APP_ID) REFERENCES SP_APP (ID) ON DELETE CASCADE;
-
-CREATE TABLE IF NOT EXISTS SP_ROLE_MAPPING (
-	    	ID INTEGER NOT NULL AUTO_INCREMENT,
-	    	TENANT_ID INTEGER NOT NULL,
-	    	IDP_ROLE VARCHAR (255) NOT NULL ,
-            SP_ROLE VARCHAR (255) NOT NULL ,
-	    	APP_ID INTEGER NOT NULL,
-            PRIMARY KEY (ID)
-)ENGINE INNODB;
-
-ALTER TABLE SP_ROLE_MAPPING ADD CONSTRAINT ROLEID_APPID_CONSTRAINT FOREIGN KEY (APP_ID) REFERENCES SP_APP (ID) ON DELETE CASCADE;
-
-CREATE TABLE IF NOT EXISTS SP_REQ_PATH_AUTHENTICATOR (
-	    	ID INTEGER NOT NULL AUTO_INCREMENT,
-	    	TENANT_ID INTEGER NOT NULL,
-	    	AUTHENTICATOR_NAME VARCHAR (255) NOT NULL ,
-	    	APP_ID INTEGER NOT NULL,
-            PRIMARY KEY (ID)
-)ENGINE INNODB;
-
-ALTER TABLE SP_REQ_PATH_AUTHENTICATOR ADD CONSTRAINT REQ_AUTH_APPID_CONSTRAINT FOREIGN KEY (APP_ID) REFERENCES SP_APP (ID) ON DELETE CASCADE;
-
-CREATE TABLE IF NOT EXISTS SP_PROVISIONING_CONNECTOR (
-	    	ID INTEGER NOT NULL AUTO_INCREMENT,
-	    	TENANT_ID INTEGER NOT NULL,
-            IDP_NAME VARCHAR (255) NOT NULL ,
-	    	CONNECTOR_NAME VARCHAR (255) NOT NULL ,
-	    	APP_ID INTEGER NOT NULL,
-	    	IS_JIT_ENABLED CHAR(1) NOT NULL DEFAULT '0',
-		BLOCKING CHAR(1) NOT NULL DEFAULT '0',
-            PRIMARY KEY (ID)
-)ENGINE INNODB;
-
-ALTER TABLE SP_PROVISIONING_CONNECTOR ADD CONSTRAINT PRO_CONNECTOR_APPID_CONSTRAINT FOREIGN KEY (APP_ID) REFERENCES SP_APP (ID) ON DELETE CASCADE;
-
-CREATE TABLE IF NOT EXISTS IDP (
-			ID INTEGER AUTO_INCREMENT,
-			TENANT_ID INTEGER,
-			NAME VARCHAR(254) NOT NULL,
-			IS_ENABLED CHAR(1) NOT NULL DEFAULT '1',
-			IS_PRIMARY CHAR(1) NOT NULL DEFAULT '0',
-			HOME_REALM_ID VARCHAR(254),
-			IMAGE MEDIUMBLOB,
-			CERTIFICATE BLOB,
-			ALIAS VARCHAR(254),
-			INBOUND_PROV_ENABLED CHAR (1) NOT NULL DEFAULT '0',
-			INBOUND_PROV_USER_STORE_ID VARCHAR(254),
- 			USER_CLAIM_URI VARCHAR(254),
- 			ROLE_CLAIM_URI VARCHAR(254),
-  			DESCRIPTION VARCHAR (1024),
- 			DEFAULT_AUTHENTICATOR_NAME VARCHAR(254),
- 			DEFAULT_PRO_CONNECTOR_NAME VARCHAR(254),
- 			PROVISIONING_ROLE VARCHAR(128),
- 			IS_FEDERATION_HUB CHAR(1) NOT NULL DEFAULT '0',
- 			IS_LOCAL_CLAIM_DIALECT CHAR(1) NOT NULL DEFAULT '0',
-			PRIMARY KEY (ID),
-	                DISPLAY_NAME VARCHAR(254),
-			UNIQUE (TENANT_ID, NAME)
-)ENGINE INNODB;
-
-INSERT INTO IDP (TENANT_ID, NAME, HOME_REALM_ID) VALUES (-1234, 'LOCAL', 'localhost');
-
-CREATE TABLE IF NOT EXISTS IDP_ROLE (
-			ID INTEGER AUTO_INCREMENT,
-			IDP_ID INTEGER,
-			TENANT_ID INTEGER,
-			ROLE VARCHAR(254),
-			PRIMARY KEY (ID),
-			UNIQUE (IDP_ID, ROLE),
-			FOREIGN KEY (IDP_ID) REFERENCES IDP(ID) ON DELETE CASCADE
-)ENGINE INNODB;
-
-CREATE TABLE IF NOT EXISTS IDP_ROLE_MAPPING (
-			ID INTEGER AUTO_INCREMENT,
-			IDP_ROLE_ID INTEGER,
-			TENANT_ID INTEGER,
-			USER_STORE_ID VARCHAR (253),
-			LOCAL_ROLE VARCHAR(253),
-			PRIMARY KEY (ID),
-			UNIQUE (IDP_ROLE_ID, TENANT_ID, USER_STORE_ID, LOCAL_ROLE),
-			FOREIGN KEY (IDP_ROLE_ID) REFERENCES IDP_ROLE(ID) ON DELETE CASCADE
-)ENGINE INNODB;
-
-CREATE TABLE IF NOT EXISTS IDP_CLAIM (
-			ID INTEGER AUTO_INCREMENT,
-			IDP_ID INTEGER,
-			TENANT_ID INTEGER,
-			CLAIM VARCHAR(254),
-			PRIMARY KEY (ID),
-			UNIQUE (IDP_ID, CLAIM),
-			FOREIGN KEY (IDP_ID) REFERENCES IDP(ID) ON DELETE CASCADE
-)ENGINE INNODB;
-
-CREATE TABLE IF NOT EXISTS IDP_CLAIM_MAPPING (
-			ID INTEGER AUTO_INCREMENT,
-			IDP_CLAIM_ID INTEGER,
-			TENANT_ID INTEGER,
-			LOCAL_CLAIM VARCHAR(253),
-		    DEFAULT_VALUE VARCHAR(255),
-	    	IS_REQUESTED VARCHAR(128) DEFAULT '0',
-			PRIMARY KEY (ID),
-			UNIQUE (IDP_CLAIM_ID, TENANT_ID, LOCAL_CLAIM),
-			FOREIGN KEY (IDP_CLAIM_ID) REFERENCES IDP_CLAIM(ID) ON DELETE CASCADE
-)ENGINE INNODB;
-
-CREATE TABLE IF NOT EXISTS IDP_AUTHENTICATOR (
-            ID INTEGER AUTO_INCREMENT,
-            TENANT_ID INTEGER,
-            IDP_ID INTEGER,
-            NAME VARCHAR(255) NOT NULL,
-            IS_ENABLED CHAR (1) DEFAULT '1',
-            DISPLAY_NAME VARCHAR(255),
-            PRIMARY KEY (ID),
-            UNIQUE (TENANT_ID, IDP_ID, NAME),
-            FOREIGN KEY (IDP_ID) REFERENCES IDP(ID) ON DELETE CASCADE
-)ENGINE INNODB;
-
-INSERT INTO IDP_AUTHENTICATOR (TENANT_ID, IDP_ID, NAME) VALUES (-1234, 1, 'saml2sso');
-
-CREATE TABLE IF NOT EXISTS IDP_AUTHENTICATOR_PROPERTY (
-            ID INTEGER AUTO_INCREMENT,
-            TENANT_ID INTEGER,
-            AUTHENTICATOR_ID INTEGER,
-            PROPERTY_KEY VARCHAR(255) NOT NULL,
-            PROPERTY_VALUE VARCHAR(2047),
-            IS_SECRET CHAR (1) DEFAULT '0',
-            PRIMARY KEY (ID),
-            UNIQUE (TENANT_ID, AUTHENTICATOR_ID, PROPERTY_KEY),
-            FOREIGN KEY (AUTHENTICATOR_ID) REFERENCES IDP_AUTHENTICATOR(ID) ON DELETE CASCADE
-)ENGINE INNODB;
-
-CREATE TABLE IF NOT EXISTS IDP_PROVISIONING_CONFIG (
-            ID INTEGER AUTO_INCREMENT,
-            TENANT_ID INTEGER,
-            IDP_ID INTEGER,
-            PROVISIONING_CONNECTOR_TYPE VARCHAR(255) NOT NULL,
-            IS_ENABLED CHAR (1) DEFAULT '0',
-            IS_BLOCKING CHAR (1) DEFAULT '0',
-            PRIMARY KEY (ID),
-            UNIQUE (TENANT_ID, IDP_ID, PROVISIONING_CONNECTOR_TYPE),
-            FOREIGN KEY (IDP_ID) REFERENCES IDP(ID) ON DELETE CASCADE
-)ENGINE INNODB;
-
-CREATE TABLE IF NOT EXISTS IDP_PROV_CONFIG_PROPERTY (
-            ID INTEGER AUTO_INCREMENT,
-            TENANT_ID INTEGER,
-            PROVISIONING_CONFIG_ID INTEGER,
-            PROPERTY_KEY VARCHAR(255) NOT NULL,
-            PROPERTY_VALUE VARCHAR(2048),
-            PROPERTY_BLOB_VALUE BLOB,
-            PROPERTY_TYPE CHAR(32) NOT NULL,
-            IS_SECRET CHAR (1) DEFAULT '0',
-            PRIMARY KEY (ID),
-            UNIQUE (TENANT_ID, PROVISIONING_CONFIG_ID, PROPERTY_KEY),
-            FOREIGN KEY (PROVISIONING_CONFIG_ID) REFERENCES IDP_PROVISIONING_CONFIG(ID) ON DELETE CASCADE
-)ENGINE INNODB;
-
-CREATE TABLE IF NOT EXISTS IDP_PROVISIONING_ENTITY (
-            ID INTEGER AUTO_INCREMENT,
-            PROVISIONING_CONFIG_ID INTEGER,
-            ENTITY_TYPE VARCHAR(255) NOT NULL,
-            ENTITY_LOCAL_USERSTORE VARCHAR(255) NOT NULL,
-            ENTITY_NAME VARCHAR(255) NOT NULL,
-            ENTITY_VALUE VARCHAR(255),
-            TENANT_ID INTEGER,
-            PRIMARY KEY (ID),
-            UNIQUE (ENTITY_TYPE, TENANT_ID, ENTITY_LOCAL_USERSTORE, ENTITY_NAME),
-            UNIQUE (PROVISIONING_CONFIG_ID, ENTITY_TYPE, ENTITY_VALUE),
-            FOREIGN KEY (PROVISIONING_CONFIG_ID) REFERENCES IDP_PROVISIONING_CONFIG(ID) ON DELETE CASCADE
-)ENGINE INNODB;
-
-CREATE TABLE IF NOT EXISTS IDP_LOCAL_CLAIM (
-            ID INTEGER AUTO_INCREMENT,
-            TENANT_ID INTEGER,
-            IDP_ID INTEGER,
-            CLAIM_URI VARCHAR(255) NOT NULL,
-            DEFAULT_VALUE VARCHAR(255),
-	        IS_REQUESTED VARCHAR(128) DEFAULT '0',
-            PRIMARY KEY (ID),
-            UNIQUE (TENANT_ID, IDP_ID, CLAIM_URI),
-            FOREIGN KEY (IDP_ID) REFERENCES IDP(ID) ON DELETE CASCADE
-)ENGINE INNODB;