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:00:20 UTC
[06/10] stratos git commit: Rename security-sql.mysql to
security-mysql.sql
Rename security-sql.mysql to security-mysql.sql
Project: http://git-wip-us.apache.org/repos/asf/stratos/repo
Commit: http://git-wip-us.apache.org/repos/asf/stratos/commit/2c255029
Tree: http://git-wip-us.apache.org/repos/asf/stratos/tree/2c255029
Diff: http://git-wip-us.apache.org/repos/asf/stratos/diff/2c255029
Branch: refs/heads/4.1.0-test
Commit: 2c2550294042f9a2e900dcbd299071bad0b51db1
Parents: 02d5a2e
Author: Vishanth <vi...@gmail.com>
Authored: Tue Dec 9 17:23:50 2014 +0530
Committer: Udara Liyanage <ud...@wso2.com>
Committed: Mon Dec 15 10:29:45 2014 +0530
----------------------------------------------------------------------
.../resources/security-mysql.sql | 207 +++++++++++++++++++
.../resources/security-sql.mysql | 207 -------------------
2 files changed, 207 insertions(+), 207 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/stratos/blob/2c255029/tools/stratos-installer/resources/security-mysql.sql
----------------------------------------------------------------------
diff --git a/tools/stratos-installer/resources/security-mysql.sql b/tools/stratos-installer/resources/security-mysql.sql
new file mode 100755
index 0000000..20e528c
--- /dev/null
+++ b/tools/stratos-installer/resources/security-mysql.sql
@@ -0,0 +1,207 @@
+/*
+* 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 IDN_BASE_TABLE (
+ PRODUCT_NAME VARCHAR(20),
+ PRIMARY KEY (PRODUCT_NAME)
+)ENGINE INNODB;
+
+INSERT INTO IDN_BASE_TABLE values ('WSO2 Identity Server');
+
+CREATE TABLE IDN_OAUTH_CONSUMER_APPS (
+ CONSUMER_KEY VARCHAR(255),
+ CONSUMER_SECRET VARCHAR(512),
+ USERNAME VARCHAR(255),
+ TENANT_ID INTEGER DEFAULT 0,
+ APP_NAME VARCHAR(255),
+ OAUTH_VERSION VARCHAR(128),
+ CALLBACK_URL VARCHAR(1024),
+ GRANT_TYPES VARCHAR (1024),
+ PRIMARY KEY (CONSUMER_KEY)
+)ENGINE INNODB;
+
+CREATE TABLE IDN_OAUTH1A_REQUEST_TOKEN (
+ REQUEST_TOKEN VARCHAR(255),
+ REQUEST_TOKEN_SECRET VARCHAR(512),
+ CONSUMER_KEY VARCHAR(255),
+ CALLBACK_URL VARCHAR(1024),
+ SCOPE VARCHAR(2048),
+ AUTHORIZED VARCHAR(128),
+ OAUTH_VERIFIER VARCHAR(512),
+ AUTHZ_USER VARCHAR(512),
+ PRIMARY KEY (REQUEST_TOKEN),
+ FOREIGN KEY (CONSUMER_KEY) REFERENCES IDN_OAUTH_CONSUMER_APPS(CONSUMER_KEY) ON DELETE CASCADE
+)ENGINE INNODB;
+
+CREATE TABLE IDN_OAUTH1A_ACCESS_TOKEN (
+ ACCESS_TOKEN VARCHAR(255),
+ ACCESS_TOKEN_SECRET VARCHAR(512),
+ CONSUMER_KEY VARCHAR(255),
+ SCOPE VARCHAR(2048),
+ AUTHZ_USER VARCHAR(512),
+ PRIMARY KEY (ACCESS_TOKEN),
+ FOREIGN KEY (CONSUMER_KEY) REFERENCES IDN_OAUTH_CONSUMER_APPS(CONSUMER_KEY) ON DELETE CASCADE
+)ENGINE INNODB;
+
+CREATE TABLE IDN_OAUTH2_AUTHORIZATION_CODE (
+ AUTHORIZATION_CODE VARCHAR(255),
+ CONSUMER_KEY VARCHAR(255),
+ CALLBACK_URL VARCHAR(1024),
+ SCOPE VARCHAR(2048),
+ AUTHZ_USER VARCHAR(512),
+ TIME_CREATED TIMESTAMP,
+ VALIDITY_PERIOD BIGINT,
+ PRIMARY KEY (AUTHORIZATION_CODE),
+ FOREIGN KEY (CONSUMER_KEY) REFERENCES IDN_OAUTH_CONSUMER_APPS(CONSUMER_KEY) ON DELETE CASCADE
+)ENGINE INNODB;
+
+CREATE TABLE IDN_OAUTH2_ACCESS_TOKEN (
+ ACCESS_TOKEN VARCHAR(255),
+ REFRESH_TOKEN VARCHAR(255),
+ CONSUMER_KEY VARCHAR(255),
+ AUTHZ_USER VARCHAR(100),
+ USER_TYPE VARCHAR (25),
+ TIME_CREATED TIMESTAMP DEFAULT 0,
+ VALIDITY_PERIOD BIGINT,
+ TOKEN_SCOPE VARCHAR(25),
+ TOKEN_STATE VARCHAR(25) DEFAULT 'ACTIVE',
+ TOKEN_STATE_ID VARCHAR (255) DEFAULT 'NONE',
+ PRIMARY KEY (ACCESS_TOKEN),
+ FOREIGN KEY (CONSUMER_KEY) REFERENCES IDN_OAUTH_CONSUMER_APPS(CONSUMER_KEY) ON DELETE CASCADE,
+ CONSTRAINT CON_APP_KEY UNIQUE (CONSUMER_KEY,AUTHZ_USER,USER_TYPE,TOKEN_SCOPE,TOKEN_STATE,TOKEN_STATE_ID)
+)ENGINE INNODB;
+
+CREATE INDEX IDX_AT_CK_AU ON IDN_OAUTH2_ACCESS_TOKEN(CONSUMER_KEY, AUTHZ_USER, TOKEN_STATE, USER_TYPE);
+
+CREATE TABLE IF NOT EXISTS IDN_OAUTH2_SCOPE (
+ SCOPE_ID INT(11) NOT NULL AUTO_INCREMENT,
+ SCOPE_KEY VARCHAR(100) NOT NULL,
+ NAME VARCHAR(255) NULL,
+ DESCRIPTION VARCHAR(512) NULL,
+ TENANT_ID INT(11) NOT NULL DEFAULT 0,
+ ROLES VARCHAR (500) NULL,
+ PRIMARY KEY (SCOPE_ID)
+)ENGINE INNODB;
+
+CREATE TABLE IF NOT EXISTS IDN_OAUTH2_RESOURCE_SCOPE (
+ RESOURCE_PATH VARCHAR(255) NOT NULL,
+ SCOPE_ID INTEGER (11) NOT NULL,
+ PRIMARY KEY (RESOURCE_PATH),
+ FOREIGN KEY (SCOPE_ID) REFERENCES IDN_OAUTH2_SCOPE (SCOPE_ID)
+)ENGINE INNODB;
+
+CREATE TABLE IDN_SCIM_GROUP (
+ ID INTEGER AUTO_INCREMENT,
+ TENANT_ID INTEGER NOT NULL,
+ ROLE_NAME VARCHAR(255) NOT NULL,
+ ATTR_NAME VARCHAR(1024) NOT NULL,
+ ATTR_VALUE VARCHAR(1024),
+ PRIMARY KEY (ID)
+)ENGINE INNODB;
+
+CREATE TABLE IDN_SCIM_PROVIDER (
+ CONSUMER_ID VARCHAR(255) NOT NULL,
+ PROVIDER_ID VARCHAR(255) NOT NULL,
+ USER_NAME VARCHAR(255) NOT NULL,
+ USER_PASSWORD VARCHAR(255) NOT NULL,
+ USER_URL VARCHAR(1024) NOT NULL,
+ GROUP_URL VARCHAR(1024),
+ BULK_URL VARCHAR(1024),
+ PRIMARY KEY (CONSUMER_ID,PROVIDER_ID)
+)ENGINE INNODB;
+
+CREATE TABLE IDN_OPENID_REMEMBER_ME (
+ USER_NAME VARCHAR(255) NOT NULL,
+ TENANT_ID INTEGER DEFAULT 0,
+ COOKIE_VALUE VARCHAR(1024),
+ CREATED_TIME TIMESTAMP,
+ PRIMARY KEY (USER_NAME, TENANT_ID)
+)ENGINE INNODB;
+
+CREATE TABLE IDN_OPENID_USER_RPS (
+ USER_NAME VARCHAR(255) NOT NULL,
+ TENANT_ID INTEGER DEFAULT 0,
+ RP_URL VARCHAR(255) NOT NULL,
+ TRUSTED_ALWAYS VARCHAR(128) DEFAULT 'FALSE',
+ LAST_VISIT DATE NOT NULL,
+ VISIT_COUNT INTEGER DEFAULT 0,
+ DEFAULT_PROFILE_NAME VARCHAR(255) DEFAULT 'DEFAULT',
+ PRIMARY KEY (USER_NAME, TENANT_ID, RP_URL)
+)ENGINE INNODB;
+
+CREATE TABLE IDN_OPENID_ASSOCIATIONS (
+ HANDLE VARCHAR(255) NOT NULL,
+ ASSOC_TYPE VARCHAR(255) NOT NULL,
+ EXPIRE_IN TIMESTAMP NOT NULL,
+ MAC_KEY VARCHAR(255) NOT NULL,
+ ASSOC_STORE VARCHAR(128) DEFAULT 'SHARED',
+ PRIMARY KEY (HANDLE)
+)ENGINE INNODB;
+
+CREATE TABLE IDN_STS_STORE (
+ ID INTEGER AUTO_INCREMENT,
+ TOKEN_ID VARCHAR(255) NOT NULL,
+ TOKEN_CONTENT BLOB(1024) NOT NULL,
+ CREATE_DATE TIMESTAMP NOT NULL,
+ EXPIRE_DATE TIMESTAMP NOT NULL,
+ STATE INTEGER DEFAULT 0,
+ PRIMARY KEY (ID)
+)ENGINE INNODB;
+
+CREATE TABLE IDN_IDENTITY_USER_DATA (
+ TENANT_ID INTEGER DEFAULT -1234,
+ USER_NAME VARCHAR(255) NOT NULL,
+ DATA_KEY VARCHAR(255) NOT NULL,
+ DATA_VALUE VARCHAR(255) NOT NULL,
+ PRIMARY KEY (TENANT_ID, USER_NAME, DATA_KEY)
+)ENGINE INNODB;
+
+CREATE TABLE IDN_IDENTITY_META_DATA (
+ USER_NAME VARCHAR(255) NOT NULL,
+ TENANT_ID INTEGER DEFAULT -1234,
+ METADATA_TYPE VARCHAR(255) NOT NULL,
+ METADATA VARCHAR(255) NOT NULL,
+ VALID VARCHAR(255) NOT NULL,
+ PRIMARY KEY (TENANT_ID, USER_NAME, METADATA_TYPE,METADATA)
+)ENGINE INNODB;
+
+CREATE TABLE IF NOT EXISTS IDN_THRIFT_SESSION (
+ SESSION_ID VARCHAR(255) NOT NULL,
+ USER_NAME VARCHAR(255) NOT NULL,
+ CREATED_TIME VARCHAR(255) NOT NULL,
+ LAST_MODIFIED_TIME VARCHAR(255) NOT NULL,
+ PRIMARY KEY (SESSION_ID)
+)ENGINE INNODB;
+
+CREATE TABLE IF NOT EXISTS IDN_ASSOCIATED_ID (
+ ID INTEGER AUTO_INCREMENT,
+ IDP_USER_ID VARCHAR(255) NOT NULL,
+ TENANT_ID INTEGER DEFAULT -1234,
+ IDP_ID VARCHAR(255) NOT NULL,
+ USER_NAME VARCHAR(255) NOT NULL,
+ PRIMARY KEY (ID),
+ UNIQUE(IDP_USER_ID, TENANT_ID, IDP_ID)
+)ENGINE INNODB;
http://git-wip-us.apache.org/repos/asf/stratos/blob/2c255029/tools/stratos-installer/resources/security-sql.mysql
----------------------------------------------------------------------
diff --git a/tools/stratos-installer/resources/security-sql.mysql b/tools/stratos-installer/resources/security-sql.mysql
deleted file mode 100755
index 20e528c..0000000
--- a/tools/stratos-installer/resources/security-sql.mysql
+++ /dev/null
@@ -1,207 +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 IDN_BASE_TABLE (
- PRODUCT_NAME VARCHAR(20),
- PRIMARY KEY (PRODUCT_NAME)
-)ENGINE INNODB;
-
-INSERT INTO IDN_BASE_TABLE values ('WSO2 Identity Server');
-
-CREATE TABLE IDN_OAUTH_CONSUMER_APPS (
- CONSUMER_KEY VARCHAR(255),
- CONSUMER_SECRET VARCHAR(512),
- USERNAME VARCHAR(255),
- TENANT_ID INTEGER DEFAULT 0,
- APP_NAME VARCHAR(255),
- OAUTH_VERSION VARCHAR(128),
- CALLBACK_URL VARCHAR(1024),
- GRANT_TYPES VARCHAR (1024),
- PRIMARY KEY (CONSUMER_KEY)
-)ENGINE INNODB;
-
-CREATE TABLE IDN_OAUTH1A_REQUEST_TOKEN (
- REQUEST_TOKEN VARCHAR(255),
- REQUEST_TOKEN_SECRET VARCHAR(512),
- CONSUMER_KEY VARCHAR(255),
- CALLBACK_URL VARCHAR(1024),
- SCOPE VARCHAR(2048),
- AUTHORIZED VARCHAR(128),
- OAUTH_VERIFIER VARCHAR(512),
- AUTHZ_USER VARCHAR(512),
- PRIMARY KEY (REQUEST_TOKEN),
- FOREIGN KEY (CONSUMER_KEY) REFERENCES IDN_OAUTH_CONSUMER_APPS(CONSUMER_KEY) ON DELETE CASCADE
-)ENGINE INNODB;
-
-CREATE TABLE IDN_OAUTH1A_ACCESS_TOKEN (
- ACCESS_TOKEN VARCHAR(255),
- ACCESS_TOKEN_SECRET VARCHAR(512),
- CONSUMER_KEY VARCHAR(255),
- SCOPE VARCHAR(2048),
- AUTHZ_USER VARCHAR(512),
- PRIMARY KEY (ACCESS_TOKEN),
- FOREIGN KEY (CONSUMER_KEY) REFERENCES IDN_OAUTH_CONSUMER_APPS(CONSUMER_KEY) ON DELETE CASCADE
-)ENGINE INNODB;
-
-CREATE TABLE IDN_OAUTH2_AUTHORIZATION_CODE (
- AUTHORIZATION_CODE VARCHAR(255),
- CONSUMER_KEY VARCHAR(255),
- CALLBACK_URL VARCHAR(1024),
- SCOPE VARCHAR(2048),
- AUTHZ_USER VARCHAR(512),
- TIME_CREATED TIMESTAMP,
- VALIDITY_PERIOD BIGINT,
- PRIMARY KEY (AUTHORIZATION_CODE),
- FOREIGN KEY (CONSUMER_KEY) REFERENCES IDN_OAUTH_CONSUMER_APPS(CONSUMER_KEY) ON DELETE CASCADE
-)ENGINE INNODB;
-
-CREATE TABLE IDN_OAUTH2_ACCESS_TOKEN (
- ACCESS_TOKEN VARCHAR(255),
- REFRESH_TOKEN VARCHAR(255),
- CONSUMER_KEY VARCHAR(255),
- AUTHZ_USER VARCHAR(100),
- USER_TYPE VARCHAR (25),
- TIME_CREATED TIMESTAMP DEFAULT 0,
- VALIDITY_PERIOD BIGINT,
- TOKEN_SCOPE VARCHAR(25),
- TOKEN_STATE VARCHAR(25) DEFAULT 'ACTIVE',
- TOKEN_STATE_ID VARCHAR (255) DEFAULT 'NONE',
- PRIMARY KEY (ACCESS_TOKEN),
- FOREIGN KEY (CONSUMER_KEY) REFERENCES IDN_OAUTH_CONSUMER_APPS(CONSUMER_KEY) ON DELETE CASCADE,
- CONSTRAINT CON_APP_KEY UNIQUE (CONSUMER_KEY,AUTHZ_USER,USER_TYPE,TOKEN_SCOPE,TOKEN_STATE,TOKEN_STATE_ID)
-)ENGINE INNODB;
-
-CREATE INDEX IDX_AT_CK_AU ON IDN_OAUTH2_ACCESS_TOKEN(CONSUMER_KEY, AUTHZ_USER, TOKEN_STATE, USER_TYPE);
-
-CREATE TABLE IF NOT EXISTS IDN_OAUTH2_SCOPE (
- SCOPE_ID INT(11) NOT NULL AUTO_INCREMENT,
- SCOPE_KEY VARCHAR(100) NOT NULL,
- NAME VARCHAR(255) NULL,
- DESCRIPTION VARCHAR(512) NULL,
- TENANT_ID INT(11) NOT NULL DEFAULT 0,
- ROLES VARCHAR (500) NULL,
- PRIMARY KEY (SCOPE_ID)
-)ENGINE INNODB;
-
-CREATE TABLE IF NOT EXISTS IDN_OAUTH2_RESOURCE_SCOPE (
- RESOURCE_PATH VARCHAR(255) NOT NULL,
- SCOPE_ID INTEGER (11) NOT NULL,
- PRIMARY KEY (RESOURCE_PATH),
- FOREIGN KEY (SCOPE_ID) REFERENCES IDN_OAUTH2_SCOPE (SCOPE_ID)
-)ENGINE INNODB;
-
-CREATE TABLE IDN_SCIM_GROUP (
- ID INTEGER AUTO_INCREMENT,
- TENANT_ID INTEGER NOT NULL,
- ROLE_NAME VARCHAR(255) NOT NULL,
- ATTR_NAME VARCHAR(1024) NOT NULL,
- ATTR_VALUE VARCHAR(1024),
- PRIMARY KEY (ID)
-)ENGINE INNODB;
-
-CREATE TABLE IDN_SCIM_PROVIDER (
- CONSUMER_ID VARCHAR(255) NOT NULL,
- PROVIDER_ID VARCHAR(255) NOT NULL,
- USER_NAME VARCHAR(255) NOT NULL,
- USER_PASSWORD VARCHAR(255) NOT NULL,
- USER_URL VARCHAR(1024) NOT NULL,
- GROUP_URL VARCHAR(1024),
- BULK_URL VARCHAR(1024),
- PRIMARY KEY (CONSUMER_ID,PROVIDER_ID)
-)ENGINE INNODB;
-
-CREATE TABLE IDN_OPENID_REMEMBER_ME (
- USER_NAME VARCHAR(255) NOT NULL,
- TENANT_ID INTEGER DEFAULT 0,
- COOKIE_VALUE VARCHAR(1024),
- CREATED_TIME TIMESTAMP,
- PRIMARY KEY (USER_NAME, TENANT_ID)
-)ENGINE INNODB;
-
-CREATE TABLE IDN_OPENID_USER_RPS (
- USER_NAME VARCHAR(255) NOT NULL,
- TENANT_ID INTEGER DEFAULT 0,
- RP_URL VARCHAR(255) NOT NULL,
- TRUSTED_ALWAYS VARCHAR(128) DEFAULT 'FALSE',
- LAST_VISIT DATE NOT NULL,
- VISIT_COUNT INTEGER DEFAULT 0,
- DEFAULT_PROFILE_NAME VARCHAR(255) DEFAULT 'DEFAULT',
- PRIMARY KEY (USER_NAME, TENANT_ID, RP_URL)
-)ENGINE INNODB;
-
-CREATE TABLE IDN_OPENID_ASSOCIATIONS (
- HANDLE VARCHAR(255) NOT NULL,
- ASSOC_TYPE VARCHAR(255) NOT NULL,
- EXPIRE_IN TIMESTAMP NOT NULL,
- MAC_KEY VARCHAR(255) NOT NULL,
- ASSOC_STORE VARCHAR(128) DEFAULT 'SHARED',
- PRIMARY KEY (HANDLE)
-)ENGINE INNODB;
-
-CREATE TABLE IDN_STS_STORE (
- ID INTEGER AUTO_INCREMENT,
- TOKEN_ID VARCHAR(255) NOT NULL,
- TOKEN_CONTENT BLOB(1024) NOT NULL,
- CREATE_DATE TIMESTAMP NOT NULL,
- EXPIRE_DATE TIMESTAMP NOT NULL,
- STATE INTEGER DEFAULT 0,
- PRIMARY KEY (ID)
-)ENGINE INNODB;
-
-CREATE TABLE IDN_IDENTITY_USER_DATA (
- TENANT_ID INTEGER DEFAULT -1234,
- USER_NAME VARCHAR(255) NOT NULL,
- DATA_KEY VARCHAR(255) NOT NULL,
- DATA_VALUE VARCHAR(255) NOT NULL,
- PRIMARY KEY (TENANT_ID, USER_NAME, DATA_KEY)
-)ENGINE INNODB;
-
-CREATE TABLE IDN_IDENTITY_META_DATA (
- USER_NAME VARCHAR(255) NOT NULL,
- TENANT_ID INTEGER DEFAULT -1234,
- METADATA_TYPE VARCHAR(255) NOT NULL,
- METADATA VARCHAR(255) NOT NULL,
- VALID VARCHAR(255) NOT NULL,
- PRIMARY KEY (TENANT_ID, USER_NAME, METADATA_TYPE,METADATA)
-)ENGINE INNODB;
-
-CREATE TABLE IF NOT EXISTS IDN_THRIFT_SESSION (
- SESSION_ID VARCHAR(255) NOT NULL,
- USER_NAME VARCHAR(255) NOT NULL,
- CREATED_TIME VARCHAR(255) NOT NULL,
- LAST_MODIFIED_TIME VARCHAR(255) NOT NULL,
- PRIMARY KEY (SESSION_ID)
-)ENGINE INNODB;
-
-CREATE TABLE IF NOT EXISTS IDN_ASSOCIATED_ID (
- ID INTEGER AUTO_INCREMENT,
- IDP_USER_ID VARCHAR(255) NOT NULL,
- TENANT_ID INTEGER DEFAULT -1234,
- IDP_ID VARCHAR(255) NOT NULL,
- USER_NAME VARCHAR(255) NOT NULL,
- PRIMARY KEY (ID),
- UNIQUE(IDP_USER_ID, TENANT_ID, IDP_ID)
-)ENGINE INNODB;