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/18 07:38:08 UTC
[06/50] [abbrv] stratos git commit: removing application-sql.mysql in
stratos-installer dir
removing application-sql.mysql in stratos-installer dir
Project: http://git-wip-us.apache.org/repos/asf/stratos/repo
Commit: http://git-wip-us.apache.org/repos/asf/stratos/commit/363dd6eb
Tree: http://git-wip-us.apache.org/repos/asf/stratos/tree/363dd6eb
Diff: http://git-wip-us.apache.org/repos/asf/stratos/diff/363dd6eb
Branch: refs/heads/master
Commit: 363dd6ebfe2c880b41bc918b9bacdbecc88cac0e
Parents: aeca91f
Author: Martin Eppel <me...@cisco..com>
Authored: Mon Dec 15 16:27:31 2014 -0800
Committer: Udara Liyanage <ud...@wso2.com>
Committed: Thu Dec 18 12:06:56 2014 +0530
----------------------------------------------------------------------
tools/stratos-installer/application-sql.mysql | 274 ---------------------
1 file changed, 274 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/stratos/blob/363dd6eb/tools/stratos-installer/application-sql.mysql
----------------------------------------------------------------------
diff --git a/tools/stratos-installer/application-sql.mysql b/tools/stratos-installer/application-sql.mysql
deleted file mode 100755
index b8c9c26..0000000
--- a/tools/stratos-installer/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;