You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@stratos.apache.org by im...@apache.org on 2015/01/24 11:29:01 UTC
[10/34] stratos git commit: Removing unused components
http://git-wip-us.apache.org/repos/asf/stratos/blob/ee5e9639/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/oracle.sql
----------------------------------------------------------------------
diff --git a/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/oracle.sql b/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/oracle.sql
deleted file mode 100644
index def74c8..0000000
--- a/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/oracle.sql
+++ /dev/null
@@ -1,663 +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 TABLE REG_CLUSTER_LOCK (
- REG_LOCK_NAME VARCHAR2(20),
- REG_LOCK_STATUS VARCHAR2(20),
- REG_LOCKED_TIME TIMESTAMP,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_CLUSTER_LOCK PRIMARY KEY (REG_LOCK_NAME))
-/
-CREATE TABLE REG_LOG (
- REG_LOG_ID INTEGER,
- REG_PATH VARCHAR2(2000),
- REG_USER_ID VARCHAR2(31) NOT NULL,
- REG_LOGGED_TIME TIMESTAMP NOT NULL,
- REG_ACTION INTEGER NOT NULL,
- REG_ACTION_DATA VARCHAR2(500),
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_LOG PRIMARY KEY (REG_LOG_ID, REG_TENANT_ID))
-/
-CREATE SEQUENCE REG_LOG_SEQUENCE START WITH 1 INCREMENT BY 1 NOCACHE
-/
-CREATE OR REPLACE TRIGGER REG_LOG_TRIGGER
- BEFORE INSERT
- ON REG_LOG
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT REG_LOG_SEQUENCE.nextval INTO :NEW.REG_LOG_ID FROM dual;
- END;
-/
-
-CREATE TABLE REG_PATH(
- REG_PATH_ID INTEGER NULL,
- REG_PATH_VALUE VARCHAR2(2000) NOT NULL,
- REG_PATH_PARENT_ID INTEGER,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_PATH PRIMARY KEY(REG_PATH_ID, REG_TENANT_ID))
-/
-CREATE INDEX REG_PATH_IND_BY_PATH_VALUE ON REG_PATH(REG_PATH_VALUE, REG_TENANT_ID)
-/
-CREATE INDEX REG_PATH_IND_BY_PARENT_ID ON REG_PATH(REG_PATH_PARENT_ID, REG_TENANT_ID)
-/
-CREATE SEQUENCE REG_PATH_SEQUENCE START WITH 1 INCREMENT BY 1 NOCACHE
-/
-CREATE OR REPLACE TRIGGER REG_PATH_TRIGGER
- BEFORE INSERT
- ON REG_PATH
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT REG_PATH_SEQUENCE.nextval INTO :NEW.REG_PATH_ID FROM dual;
- END;
-/
-
-CREATE TABLE REG_CONTENT (
- REG_CONTENT_ID INTEGER,
- REG_CONTENT_DATA BLOB,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_CONTENT PRIMARY KEY(REG_CONTENT_ID, REG_TENANT_ID))
-/
-CREATE SEQUENCE REG_CONTENT_SEQUENCE START WITH 1 INCREMENT BY 1 NOCACHE
-/
-CREATE OR REPLACE TRIGGER REG_CONTENT_TRIGGER
- BEFORE INSERT
- ON REG_CONTENT
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT REG_CONTENT_SEQUENCE.nextval INTO :NEW.REG_CONTENT_ID FROM dual;
- END;
-/
-
-CREATE TABLE REG_CONTENT_HISTORY (
- REG_CONTENT_ID INTEGER NOT NULL,
- REG_CONTENT_DATA BLOB,
- REG_DELETED SMALLINT,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_CONTENT_HISTORY PRIMARY KEY(REG_CONTENT_ID, REG_TENANT_ID))
-/
-CREATE TABLE REG_RESOURCE (
- REG_PATH_ID INTEGER NOT NULL,
- REG_NAME VARCHAR2(256),
- REG_VERSION INTEGER,
- REG_MEDIA_TYPE VARCHAR2(500),
- REG_CREATOR VARCHAR2(31) NOT NULL,
- REG_CREATED_TIME TIMESTAMP NOT NULL,
- REG_LAST_UPDATOR VARCHAR2(31),
- REG_LAST_UPDATED_TIME TIMESTAMP NOT NULL,
- REG_DESCRIPTION VARCHAR2(1000),
- REG_CONTENT_ID INTEGER,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT FK_REG_RES_PATH FOREIGN KEY (REG_PATH_ID,REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID,REG_TENANT_ID),
- CONSTRAINT PK_REG_RESOURCE PRIMARY KEY(REG_VERSION, REG_TENANT_ID))
-/
-CREATE SEQUENCE REG_RESOURCE_SEQUENCE START WITH 1 INCREMENT BY 1 NOCACHE
-/
-CREATE OR REPLACE TRIGGER REG_RESOURCE_TRIGGER
- BEFORE INSERT
- ON REG_RESOURCE
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT REG_RESOURCE_SEQUENCE.nextval INTO :NEW.REG_VERSION FROM dual;
- END;
-/
-
-CREATE INDEX REG_RESOURCE_IND_BY_NAME ON REG_RESOURCE(REG_NAME, REG_TENANT_ID)
-/
-CREATE INDEX REG_RESOURCE_IND_BY_PATH_ID ON REG_RESOURCE(REG_PATH_ID, REG_NAME, REG_TENANT_ID)
-/
-CREATE TABLE REG_RESOURCE_HISTORY (
- REG_PATH_ID INTEGER NOT NULL,
- REG_NAME VARCHAR2(256),
- REG_VERSION INTEGER NOT NULL,
- REG_MEDIA_TYPE VARCHAR2(500),
- REG_CREATOR VARCHAR2(31) NOT NULL,
- REG_CREATED_TIME TIMESTAMP NOT NULL,
- REG_LAST_UPDATOR VARCHAR2(31),
- REG_LAST_UPDATED_TIME TIMESTAMP NOT NULL,
- REG_DESCRIPTION VARCHAR2(1000),
- REG_CONTENT_ID INTEGER,
- REG_DELETED SMALLINT,
- REG_TENANT_ID INTEGER DEFAULT 0,
- FOREIGN KEY (REG_PATH_ID,REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID,REG_TENANT_ID),
- FOREIGN KEY (REG_CONTENT_ID,REG_TENANT_ID) REFERENCES REG_CONTENT_HISTORY (REG_CONTENT_ID,REG_TENANT_ID),
- CONSTRAINT PK_REG_RESOURCE_HISTORY PRIMARY KEY(REG_VERSION, REG_TENANT_ID))
-/
-CREATE INDEX REG_RES_HIST_IND_BY_NAME ON REG_RESOURCE_HISTORY(REG_NAME, REG_TENANT_ID)
-/
-CREATE INDEX REG_RES_HIST_IND_BY_PATH_ID ON REG_RESOURCE_HISTORY(REG_PATH_ID, REG_NAME, REG_TENANT_ID)
-/
-CREATE TABLE REG_COMMENT (
- REG_ID INTEGER,
- REG_COMMENT_TEXT VARCHAR2(500) NOT NULL,
- REG_USER_ID VARCHAR2(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))
-/
-CREATE SEQUENCE REG_COMMENT_SEQUENCE START WITH 1 INCREMENT BY 1 NOCACHE
-/
-CREATE OR REPLACE TRIGGER REG_COMMENT_TRIGGER
- BEFORE INSERT
- ON REG_COMMENT
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT REG_COMMENT_SEQUENCE.nextval INTO :NEW.REG_ID FROM dual;
- END;
-/
-
-CREATE TABLE REG_RESOURCE_COMMENT (
- REG_COMMENT_ID INTEGER NOT NULL,
- REG_VERSION INTEGER,
- REG_PATH_ID INTEGER,
- REG_RESOURCE_NAME VARCHAR2(256),
- FOREIGN KEY (REG_PATH_ID,REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID,REG_TENANT_ID),
- FOREIGN KEY (REG_COMMENT_ID,REG_TENANT_ID) REFERENCES REG_COMMENT (REG_ID,REG_TENANT_ID),
- REG_TENANT_ID INTEGER DEFAULT 0)
-/
-CREATE INDEX REG_RES_COMM_BY_PATH_ID ON REG_RESOURCE_COMMENT(REG_PATH_ID, REG_RESOURCE_NAME, REG_TENANT_ID)
-/
-CREATE INDEX REG_RES_COMM_BY_VERSION ON REG_RESOURCE_COMMENT(REG_VERSION, REG_TENANT_ID)
-/
-CREATE TABLE REG_RATING (
- REG_ID INTEGER,
- REG_RATING INTEGER NOT NULL,
- REG_USER_ID VARCHAR2(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))
-/
-CREATE SEQUENCE REG_RATING_SEQUENCE START WITH 1 INCREMENT BY 1 NOCACHE
-/
-CREATE OR REPLACE TRIGGER REG_RATING_TRIGGER
- BEFORE INSERT
- ON REG_RATING
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT REG_RATING_SEQUENCE.nextval INTO :NEW.REG_ID FROM dual;
- END;
-/
-
-CREATE TABLE REG_RESOURCE_RATING (
- REG_RATING_ID INTEGER NOT NULL,
- REG_VERSION INTEGER,
- REG_PATH_ID INTEGER,
- REG_RESOURCE_NAME VARCHAR2(256),
- FOREIGN KEY (REG_PATH_ID,REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID,REG_TENANT_ID),
- FOREIGN KEY (REG_RATING_ID,REG_TENANT_ID) REFERENCES REG_RATING (REG_ID,REG_TENANT_ID),
- REG_TENANT_ID INTEGER DEFAULT 0)
-/
-CREATE INDEX REG_RATING_IND_BY_PATH_ID ON REG_RESOURCE_RATING(REG_PATH_ID, REG_RESOURCE_NAME, REG_TENANT_ID)
-/
-CREATE INDEX REG_RATING_IND_BY_VERSION ON REG_RESOURCE_RATING(REG_VERSION, REG_TENANT_ID)
-/
-CREATE TABLE REG_TAG (
- REG_ID INTEGER,
- REG_TAG_NAME VARCHAR2(500) NOT NULL,
- REG_USER_ID VARCHAR2(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))
-/
-CREATE SEQUENCE REG_TAG_SEQUENCE START WITH 1 INCREMENT BY 1 NOCACHE
-/
-CREATE OR REPLACE TRIGGER REG_TAG_TRIGGER
- BEFORE INSERT
- ON REG_TAG
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT REG_TAG_SEQUENCE.nextval INTO :NEW.REG_ID FROM dual;
- END;
-/
-
-
-CREATE TABLE REG_RESOURCE_TAG (
- REG_TAG_ID INTEGER NOT NULL,
- REG_VERSION INTEGER,
- REG_PATH_ID INTEGER,
- REG_RESOURCE_NAME VARCHAR2(256),
- FOREIGN KEY (REG_PATH_ID,REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID,REG_TENANT_ID),
- FOREIGN KEY (REG_TAG_ID,REG_TENANT_ID) REFERENCES REG_TAG (REG_ID,REG_TENANT_ID),
- REG_TENANT_ID INTEGER DEFAULT 0)
-/
-CREATE INDEX REG_TAG_IND_BY_PATH_ID ON REG_RESOURCE_TAG(REG_PATH_ID, REG_RESOURCE_NAME, REG_TENANT_ID)
-/
-CREATE INDEX REG_TAG_IND_BY_VERSION ON REG_RESOURCE_TAG(REG_VERSION, REG_TENANT_ID)
-/
-CREATE TABLE REG_PROPERTY (
- REG_ID INTEGER,
- REG_NAME VARCHAR2(100) NOT NULL,
- REG_VALUE VARCHAR2(1000),
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_PROPERTY PRIMARY KEY(REG_ID, REG_TENANT_ID))
-/
-CREATE SEQUENCE REG_PROPERTY_SEQUENCE START WITH 1 INCREMENT BY 1 NOCACHE
-/
-CREATE OR REPLACE TRIGGER REG_PROPERTY_TRIGGER
- BEFORE INSERT
- ON REG_PROPERTY
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT REG_PROPERTY_SEQUENCE.nextval INTO :NEW.REG_ID FROM dual;
- END;
-/
-
-CREATE TABLE REG_RESOURCE_PROPERTY (
- REG_PROPERTY_ID INTEGER NOT NULL,
- REG_VERSION INTEGER,
- REG_PATH_ID INTEGER,
- REG_RESOURCE_NAME VARCHAR2(256),
- FOREIGN KEY (REG_PATH_ID,REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID,REG_TENANT_ID),
- FOREIGN KEY (REG_PROPERTY_ID,REG_TENANT_ID) REFERENCES REG_PROPERTY (REG_ID,REG_TENANT_ID),
- REG_TENANT_ID INTEGER DEFAULT 0)
-/
-CREATE INDEX REG_RESC_PROP_BY_VERN_PROPID ON REG_RESOURCE_PROPERTY(REG_PROPERTY_ID,REG_VERSION, REG_TENANT_ID)
-/
-CREATE INDEX REG_RESC_PROP_BY_VERN_PATHNAME ON REG_RESOURCE_PROPERTY(REG_PROPERTY_ID,REG_PATH_ID,REG_RESOURCE_NAME, REG_TENANT_ID)
-/
-CREATE TABLE REG_ASSOCIATION (
- REG_ASSOCIATION_ID INTEGER,
- REG_SOURCEPATH VARCHAR2 (2000) NOT NULL,
- REG_TARGETPATH VARCHAR2 (2000) NOT NULL,
- REG_ASSOCIATION_TYPE VARCHAR2 (2000) NOT NULL,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_ASSOCIATION PRIMARY KEY (REG_ASSOCIATION_ID, REG_TENANT_ID))
-/
-CREATE SEQUENCE REG_ASSOCIATION_SEQUENCE START WITH 1 INCREMENT BY 1 NOCACHE
-/
-CREATE OR REPLACE TRIGGER REG_ASSOCIATION_TRIGGER
- BEFORE INSERT
- ON REG_ASSOCIATION
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT REG_ASSOCIATION_SEQUENCE.nextval INTO :NEW.REG_ASSOCIATION_ID FROM dual;
- END;
-/
-
-CREATE TABLE REG_SNAPSHOT (
- REG_SNAPSHOT_ID INTEGER,
- REG_PATH_ID INTEGER NOT NULL,
- REG_RESOURCE_NAME VARCHAR2(256),
- REG_RESOURCE_VIDS BLOB NOT NULL,
- REG_TENANT_ID INTEGER DEFAULT 0,
- FOREIGN KEY (REG_PATH_ID,REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID,REG_TENANT_ID),
- CONSTRAINT PK_REG_SNAPSHOT PRIMARY KEY(REG_SNAPSHOT_ID, REG_TENANT_ID))
-/
-CREATE INDEX REG_SNAPSHOT_PATH_ID ON REG_SNAPSHOT(REG_PATH_ID, REG_RESOURCE_NAME, REG_TENANT_ID)
-/
-CREATE SEQUENCE REG_SNAPSHOT_SEQUENCE START WITH 1 INCREMENT BY 1 NOCACHE
-/
-CREATE OR REPLACE TRIGGER REG_SNAPSHOT_TRIGGER
- BEFORE INSERT
- ON REG_SNAPSHOT
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT REG_SNAPSHOT_SEQUENCE.nextval INTO :NEW.REG_SNAPSHOT_ID FROM dual;
- END;
-/
-/
-CREATE TABLE UM_TENANT (
- UM_ID INTEGER,
- UM_DOMAIN_NAME VARCHAR(255) NOT NULL,
- UM_EMAIL VARCHAR(255),
- UM_ACTIVE NUMBER(1) DEFAULT 0,
- PRIMARY KEY (UM_ID),
- UNIQUE(UM_DOMAIN_NAME))
-/
-CREATE SEQUENCE UM_TENANT_SEQUENCE START WITH 1 INCREMENT BY 1 NOCACHE
-/
-CREATE OR REPLACE TRIGGER UM_TENANT_TRIGGER
- BEFORE INSERT
- ON UM_TENANT
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_TENANT_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-CREATE TABLE UM_USER (
- UM_ID INTEGER,
- UM_USER_NAME VARCHAR2(255) NOT NULL,
- UM_USER_PASSWORD VARCHAR2(255) NOT NULL,
- UM_SALT_VALUE VARCHAR(31),
- UM_REQUIRE_CHANGE NUMBER(1) DEFAULT 0,
- 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))
-/
-CREATE SEQUENCE UM_USER_SEQUENCE START WITH 1 INCREMENT BY 1 NOCACHE
-/
-CREATE OR REPLACE TRIGGER UM_USER_TRIGGER
- BEFORE INSERT
- ON UM_USER
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_USER_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-
-CREATE TABLE UM_USER_ATTRIBUTE (
- UM_ID INTEGER,
- UM_ATTR_NAME VARCHAR2(255) NOT NULL,
- UM_ATTR_VALUE VARCHAR2(255),
- 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) ON DELETE CASCADE,
- PRIMARY KEY (UM_ID, UM_TENANT_ID))
-/
-CREATE SEQUENCE UM_USER_ATTRIBUTE_SEQUENCE START WITH 1 INCREMENT BY 1 NOCACHE
-/
-CREATE OR REPLACE TRIGGER UM_USER_ATTRIBUTE_TRIGGER
- BEFORE INSERT
- ON UM_USER_ATTRIBUTE
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_USER_ATTRIBUTE_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-
-CREATE TABLE UM_ROLE (
- UM_ID INTEGER,
- UM_ROLE_NAME VARCHAR2(255) NOT NULL,
- UM_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (UM_ID, UM_TENANT_ID),
- UNIQUE(UM_ROLE_NAME, UM_TENANT_ID))
-/
-CREATE SEQUENCE UM_ROLE_SEQUENCE START WITH 1 INCREMENT BY 1 NOCACHE
-/
-CREATE OR REPLACE TRIGGER UM_ROLE_TRIGGER
- BEFORE INSERT
- ON UM_ROLE
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_ROLE_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-
-CREATE TABLE UM_PERMISSION (
- UM_ID INTEGER,
- UM_RESOURCE_ID VARCHAR2(255) NOT NULL,
- UM_ACTION VARCHAR2(255) NOT NULL,
- UM_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (UM_ID, UM_TENANT_ID))
-/
-CREATE SEQUENCE UM_PERMISSION_SEQUENCE START WITH 1 INCREMENT BY 1 NOCACHE
-/
-CREATE OR REPLACE TRIGGER UM_PERMISSION_TRIGGER
- BEFORE INSERT
- ON UM_PERMISSION
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_PERMISSION_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-
-CREATE TABLE UM_ROLE_PERMISSION (
- UM_ID INTEGER,
- 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,
- UNIQUE (UM_PERMISSION_ID, UM_ROLE_NAME, UM_TENANT_ID),
- FOREIGN KEY (UM_PERMISSION_ID, UM_TENANT_ID) REFERENCES UM_PERMISSION(UM_ID, UM_TENANT_ID) ON DELETE CASCADE,
- --FOREIGN KEY (UM_ROLE_ID) REFERENCES UM_ROLE(UM_ID) ON DELETE CASCADE,
- PRIMARY KEY (UM_ID, UM_TENANT_ID))
-/
-CREATE SEQUENCE UM_ROLE_PERMISSION_SEQUENCE START WITH 1 INCREMENT BY 1 NOCACHE
-/
-CREATE OR REPLACE TRIGGER UM_ROLE_PERMISSION_TRIGGER
- BEFORE INSERT
- ON UM_ROLE_PERMISSION
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_ROLE_PERMISSION_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-
-CREATE TABLE UM_USER_PERMISSION (
- UM_ID INTEGER,
- 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,
- UNIQUE (UM_PERMISSION_ID, UM_USER_NAME, UM_TENANT_ID),
- FOREIGN KEY (UM_PERMISSION_ID, UM_TENANT_ID) REFERENCES UM_PERMISSION(UM_ID, UM_TENANT_ID) ON DELETE CASCADE,
- --FOREIGN KEY (UM_USER_ID) REFERENCES UM_USER(UM_ID) ON DELETE CASCADE,
- PRIMARY KEY (UM_ID, UM_TENANT_ID))
-/
-CREATE SEQUENCE UM_USER_PERMISSION_SEQUENCE START WITH 1 INCREMENT BY 1 NOCACHE
-/
-CREATE OR REPLACE TRIGGER UM_USER_PERMISSION_TRIGGER
- BEFORE INSERT
- ON UM_USER_PERMISSION
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_USER_PERMISSION_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-
-CREATE TABLE UM_USER_ROLE (
- UM_ID INTEGER,
- 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) ON DELETE CASCADE,
- FOREIGN KEY (UM_USER_ID, UM_TENANT_ID) REFERENCES UM_USER(UM_ID, UM_TENANT_ID) ON DELETE CASCADE,
- PRIMARY KEY (UM_ID, UM_TENANT_ID))
-/
-CREATE SEQUENCE UM_USER_ROLE_SEQUENCE START WITH 1 INCREMENT BY 1 NOCACHE
-/
-CREATE OR REPLACE TRIGGER UM_USER_ROLE_TRIGGER
- BEFORE INSERT
- ON UM_USER_ROLE
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_USER_ROLE_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-
-CREATE TABLE HYBRID_ROLE (
- UM_ID INTEGER,
- UM_ROLE_ID VARCHAR(255) NOT NULL,
- UM_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (UM_ID, UM_TENANT_ID),
- UNIQUE(UM_ROLE_ID, UM_TENANT_ID))
-/
-CREATE SEQUENCE HYBRID_ROLE_SEQUENCE START WITH 1 INCREMENT BY 1 NOCACHE
-/
-CREATE OR REPLACE TRIGGER HYBRID_ROLE_TRIGGER
- BEFORE INSERT
- ON HYBRID_ROLE
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT HYBRID_ROLE_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-
-CREATE TABLE HYBRID_USER_ROLE (
- UM_ID INTEGER,
- UM_USER_ID VARCHAR(255),
- UM_ROLE_ID VARCHAR(255) NOT NULL,
- UM_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (UM_ID, UM_TENANT_ID))
-/
-CREATE SEQUENCE HYBRID_USER_ROLE_SEQUENCE START WITH 1 INCREMENT BY 1 NOCACHE
-/
-CREATE OR REPLACE TRIGGER HYBRID_USER_ROLE_TRIGGER
- BEFORE INSERT
- ON HYBRID_USER_ROLE
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT HYBRID_USER_ROLE_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-
-CREATE TABLE UM_DIALECT(
- UM_ID INTEGER,
- 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)
-)
-/
-CREATE SEQUENCE UM_DIALECT_SEQUENCE START WITH 1 INCREMENT BY 1 NOCACHE
-/
-CREATE OR REPLACE TRIGGER UM_DIALECT_TRIGGER
- BEFORE INSERT
- ON UM_DIALECT
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_DIALECT_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-
-CREATE TABLE UM_CLAIM(
- UM_ID INTEGER,
- 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)
-)
-/
-CREATE SEQUENCE UM_CLAIM_SEQUENCE START WITH 1 INCREMENT BY 1 NOCACHE
-/
-CREATE OR REPLACE TRIGGER UM_CLAIM_TRIGGER
- BEFORE INSERT
- ON UM_CLAIM
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_CLAIM_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-
-CREATE TABLE UM_PROFILE_CONFIG(
- UM_ID INTEGER,
- UM_DIALECT_ID INTEGER,
- 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)
-)
-/
-CREATE SEQUENCE UM_PROFILE_CONFIG_SEQUENCE START WITH 1 INCREMENT BY 1 NOCACHE
-/
-CREATE OR REPLACE TRIGGER UM_PROFILE_CONFIG_TRIGGER
- BEFORE INSERT
- ON UM_PROFILE_CONFIG
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_PROFILE_CONFIG_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-
-CREATE TABLE UM_CLAIM_BEHAVIOR(
- UM_ID INTEGER,
- 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)
-)
-/
-CREATE SEQUENCE UM_CLAIM_BEHAVIOR_SEQUENCE START WITH 1 INCREMENT BY 1 NOCACHE
-/
-CREATE OR REPLACE TRIGGER UM_CLAIM_BEHAVIOR_TRIGGER
- BEFORE INSERT
- ON UM_CLAIM_BEHAVIOR
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_CLAIM_BEHAVIOR_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-
-CREATE TABLE UM_HYBRID_ROLE(
- UM_ID INTEGER NOT NULL,
- UM_ROLE_NAME VARCHAR(255),
- UM_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-)
-/
-CREATE SEQUENCE UM_HYBRID_ROLE_SEQUENCE START WITH 1 INCREMENT BY 1 NOCACHE
-/
-CREATE OR REPLACE TRIGGER UM_HYBRID_ROLE_TRIGGER
- BEFORE INSERT
- ON UM_HYBRID_ROLE
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_HYBRID_ROLE_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-CREATE TABLE UM_HYBRID_USER_ROLE(
- UM_ID INTEGER NOT NULL,
- 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)
-)
-/
-CREATE SEQUENCE UM_HYBRID_USER_ROLE_SEQUENCE START WITH 1 INCREMENT BY 1 NOCACHE
-/
-CREATE OR REPLACE TRIGGER UM_HYBRID_USER_ROLE_TRIGGER
- BEFORE INSERT
- ON UM_HYBRID_USER_ROLE
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_HYBRID_USER_ROLE_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
http://git-wip-us.apache.org/repos/asf/stratos/blob/ee5e9639/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/oracle_rac.sql
----------------------------------------------------------------------
diff --git a/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/oracle_rac.sql b/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/oracle_rac.sql
deleted file mode 100644
index d608d76..0000000
--- a/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/oracle_rac.sql
+++ /dev/null
@@ -1,663 +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 TABLE REG_CLUSTER_LOCK (
- REG_LOCK_NAME VARCHAR2(20),
- REG_LOCK_STATUS VARCHAR2(20),
- REG_LOCKED_TIME TIMESTAMP,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_CLUSTER_LOCK PRIMARY KEY (REG_LOCK_NAME))
-/
-CREATE TABLE REG_LOG (
- REG_LOG_ID INTEGER,
- REG_PATH VARCHAR2(2000),
- REG_USER_ID VARCHAR2(31) NOT NULL,
- REG_LOGGED_TIME TIMESTAMP NOT NULL,
- REG_ACTION INTEGER NOT NULL,
- REG_ACTION_DATA VARCHAR2(500),
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_LOG PRIMARY KEY (REG_LOG_ID, REG_TENANT_ID))
-/
-CREATE SEQUENCE REG_LOG_SEQUENCE START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
-/
-CREATE OR REPLACE TRIGGER REG_LOG_TRIGGER
- BEFORE INSERT
- ON REG_LOG
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT REG_LOG_SEQUENCE.nextval INTO :NEW.REG_LOG_ID FROM dual;
- END;
-/
-
-CREATE TABLE REG_PATH(
- REG_PATH_ID INTEGER NULL,
- REG_PATH_VALUE VARCHAR2(2000) NOT NULL,
- REG_PATH_PARENT_ID INTEGER,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_PATH PRIMARY KEY(REG_PATH_ID, REG_TENANT_ID))
-/
-CREATE INDEX REG_PATH_IND_BY_PATH_VALUE ON REG_PATH(REG_PATH_VALUE, REG_TENANT_ID)
-/
-CREATE INDEX REG_PATH_IND_BY_PARENT_ID ON REG_PATH(REG_PATH_PARENT_ID, REG_TENANT_ID)
-/
-CREATE SEQUENCE REG_PATH_SEQUENCE START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
-/
-CREATE OR REPLACE TRIGGER REG_PATH_TRIGGER
- BEFORE INSERT
- ON REG_PATH
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT REG_PATH_SEQUENCE.nextval INTO :NEW.REG_PATH_ID FROM dual;
- END;
-/
-
-CREATE TABLE REG_CONTENT (
- REG_CONTENT_ID INTEGER,
- REG_CONTENT_DATA BLOB,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_CONTENT PRIMARY KEY(REG_CONTENT_ID, REG_TENANT_ID))
-/
-CREATE SEQUENCE REG_CONTENT_SEQUENCE START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
-/
-CREATE OR REPLACE TRIGGER REG_CONTENT_TRIGGER
- BEFORE INSERT
- ON REG_CONTENT
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT REG_CONTENT_SEQUENCE.nextval INTO :NEW.REG_CONTENT_ID FROM dual;
- END;
-/
-
-CREATE TABLE REG_CONTENT_HISTORY (
- REG_CONTENT_ID INTEGER NOT NULL,
- REG_CONTENT_DATA BLOB,
- REG_DELETED SMALLINT,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_CONTENT_HISTORY PRIMARY KEY(REG_CONTENT_ID, REG_TENANT_ID))
-/
-CREATE TABLE REG_RESOURCE (
- REG_PATH_ID INTEGER NOT NULL,
- REG_NAME VARCHAR2(256),
- REG_VERSION INTEGER,
- REG_MEDIA_TYPE VARCHAR2(500),
- REG_CREATOR VARCHAR2(31) NOT NULL,
- REG_CREATED_TIME TIMESTAMP NOT NULL,
- REG_LAST_UPDATOR VARCHAR2(31),
- REG_LAST_UPDATED_TIME TIMESTAMP NOT NULL,
- REG_DESCRIPTION VARCHAR2(1000),
- REG_CONTENT_ID INTEGER,
- REG_TENANT_ID INTEGER DEFAULT 0,
- FOREIGN KEY (REG_PATH_ID,REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID,REG_TENANT_ID),
- CONSTRAINT PK_REG_RESOURCE PRIMARY KEY(REG_VERSION, REG_TENANT_ID))
-/
-CREATE SEQUENCE REG_RESOURCE_SEQUENCE START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
-/
-CREATE OR REPLACE TRIGGER REG_RESOURCE_TRIGGER
- BEFORE INSERT
- ON REG_RESOURCE
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT REG_RESOURCE_SEQUENCE.nextval INTO :NEW.REG_VERSION FROM dual;
- END;
-/
-
-CREATE INDEX REG_RESOURCE_IND_BY_NAME ON REG_RESOURCE(REG_NAME, REG_TENANT_ID)
-/
-CREATE INDEX REG_RESOURCE_IND_BY_PATH_ID ON REG_RESOURCE(REG_PATH_ID, REG_NAME, REG_TENANT_ID)
-/
-CREATE TABLE REG_RESOURCE_HISTORY (
- REG_PATH_ID INTEGER NOT NULL,
- REG_NAME VARCHAR2(256),
- REG_VERSION INTEGER NOT NULL,
- REG_MEDIA_TYPE VARCHAR2(500),
- REG_CREATOR VARCHAR2(31) NOT NULL,
- REG_CREATED_TIME TIMESTAMP NOT NULL,
- REG_LAST_UPDATOR VARCHAR2(31),
- REG_LAST_UPDATED_TIME TIMESTAMP NOT NULL,
- REG_DESCRIPTION VARCHAR2(1000),
- REG_CONTENT_ID INTEGER,
- REG_DELETED SMALLINT,
- REG_TENANT_ID INTEGER DEFAULT 0,
- FOREIGN KEY (REG_PATH_ID,REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID,REG_TENANT_ID),
- FOREIGN KEY (REG_CONTENT_ID,REG_TENANT_ID) REFERENCES REG_CONTENT_HISTORY (REG_CONTENT_ID,REG_TENANT_ID),
- CONSTRAINT PK_REG_RESOURCE_HISTORY PRIMARY KEY(REG_VERSION, REG_TENANT_ID))
-/
-CREATE INDEX REG_RES_HIST_IND_BY_NAME ON REG_RESOURCE_HISTORY(REG_NAME, REG_TENANT_ID)
-/
-CREATE INDEX REG_RES_HIST_IND_BY_PATH_ID ON REG_RESOURCE_HISTORY(REG_PATH_ID, REG_NAME, REG_TENANT_ID)
-/
-CREATE TABLE REG_COMMENT (
- REG_ID INTEGER,
- REG_COMMENT_TEXT VARCHAR2(500) NOT NULL,
- REG_USER_ID VARCHAR2(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))
-/
-CREATE SEQUENCE REG_COMMENT_SEQUENCE START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
-/
-CREATE OR REPLACE TRIGGER REG_COMMENT_TRIGGER
- BEFORE INSERT
- ON REG_COMMENT
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT REG_COMMENT_SEQUENCE.nextval INTO :NEW.REG_ID FROM dual;
- END;
-/
-
-CREATE TABLE REG_RESOURCE_COMMENT (
- REG_COMMENT_ID INTEGER NOT NULL,
- REG_VERSION INTEGER,
- REG_PATH_ID INTEGER,
- REG_RESOURCE_NAME VARCHAR2(256),
- FOREIGN KEY (REG_PATH_ID,REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID,REG_TENANT_ID),
- FOREIGN KEY (REG_COMMENT_ID,REG_TENANT_ID) REFERENCES REG_COMMENT (REG_ID,REG_TENANT_ID),
- REG_TENANT_ID INTEGER DEFAULT 0)
-/
-CREATE INDEX REG_RES_COMM_BY_PATH_ID ON REG_RESOURCE_COMMENT(REG_PATH_ID, REG_RESOURCE_NAME, REG_TENANT_ID)
-/
-CREATE INDEX REG_RES_COMM_BY_VERSION ON REG_RESOURCE_COMMENT(REG_VERSION, REG_TENANT_ID)
-/
-CREATE TABLE REG_RATING (
- REG_ID INTEGER,
- REG_RATING INTEGER NOT NULL,
- REG_USER_ID VARCHAR2(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))
-/
-CREATE SEQUENCE REG_RATING_SEQUENCE START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
-/
-CREATE OR REPLACE TRIGGER REG_RATING_TRIGGER
- BEFORE INSERT
- ON REG_RATING
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT REG_RATING_SEQUENCE.nextval INTO :NEW.REG_ID FROM dual;
- END;
-/
-
-CREATE TABLE REG_RESOURCE_RATING (
- REG_RATING_ID INTEGER NOT NULL,
- REG_VERSION INTEGER,
- REG_PATH_ID INTEGER,
- REG_RESOURCE_NAME VARCHAR2(256),
- FOREIGN KEY (REG_PATH_ID,REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID,REG_TENANT_ID),
- FOREIGN KEY (REG_RATING_ID,REG_TENANT_ID) REFERENCES REG_RATING (REG_ID,REG_TENANT_ID),
- REG_TENANT_ID INTEGER DEFAULT 0)
-/
-CREATE INDEX REG_RATING_IND_BY_PATH_ID ON REG_RESOURCE_RATING(REG_PATH_ID, REG_RESOURCE_NAME, REG_TENANT_ID)
-/
-CREATE INDEX REG_RATING_IND_BY_VERSION ON REG_RESOURCE_RATING(REG_VERSION, REG_TENANT_ID)
-/
-CREATE TABLE REG_TAG (
- REG_ID INTEGER,
- REG_TAG_NAME VARCHAR2(500) NOT NULL,
- REG_USER_ID VARCHAR2(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))
-/
-CREATE SEQUENCE REG_TAG_SEQUENCE START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
-/
-CREATE OR REPLACE TRIGGER REG_TAG_TRIGGER
- BEFORE INSERT
- ON REG_TAG
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT REG_TAG_SEQUENCE.nextval INTO :NEW.REG_ID FROM dual;
- END;
-/
-
-
-CREATE TABLE REG_RESOURCE_TAG (
- REG_TAG_ID INTEGER NOT NULL,
- REG_VERSION INTEGER,
- REG_PATH_ID INTEGER,
- REG_RESOURCE_NAME VARCHAR2(256),
- FOREIGN KEY (REG_PATH_ID,REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID,REG_TENANT_ID),
- FOREIGN KEY (REG_TAG_ID,REG_TENANT_ID) REFERENCES REG_TAG (REG_ID,REG_TENANT_ID),
- REG_TENANT_ID INTEGER DEFAULT 0)
-/
-CREATE INDEX REG_TAG_IND_BY_PATH_ID ON REG_RESOURCE_TAG(REG_PATH_ID, REG_RESOURCE_NAME, REG_TENANT_ID)
-/
-CREATE INDEX REG_TAG_IND_BY_VERSION ON REG_RESOURCE_TAG(REG_VERSION, REG_TENANT_ID)
-/
-CREATE TABLE REG_PROPERTY (
- REG_ID INTEGER,
- REG_NAME VARCHAR2(100) NOT NULL,
- REG_VALUE VARCHAR2(1000),
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_PROPERTY PRIMARY KEY(REG_ID, REG_TENANT_ID))
-/
-CREATE SEQUENCE REG_PROPERTY_SEQUENCE START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
-/
-CREATE OR REPLACE TRIGGER REG_PROPERTY_TRIGGER
- BEFORE INSERT
- ON REG_PROPERTY
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT REG_PROPERTY_SEQUENCE.nextval INTO :NEW.REG_ID FROM dual;
- END;
-/
-
-CREATE TABLE REG_RESOURCE_PROPERTY (
- REG_PROPERTY_ID INTEGER NOT NULL,
- REG_VERSION INTEGER,
- REG_PATH_ID INTEGER,
- REG_RESOURCE_NAME VARCHAR2(256),
- FOREIGN KEY (REG_PATH_ID,REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID,REG_TENANT_ID),
- FOREIGN KEY (REG_PROPERTY_ID,REG_TENANT_ID) REFERENCES REG_PROPERTY (REG_ID,REG_TENANT_ID),
- REG_TENANT_ID INTEGER DEFAULT 0)
-/
-CREATE INDEX REG_RESC_PROP_BY_VERN_PROPID ON REG_RESOURCE_PROPERTY(REG_PROPERTY_ID,REG_VERSION, REG_TENANT_ID)
-/
-CREATE INDEX REG_RESC_PROP_BY_VERN_PATHNAME ON REG_RESOURCE_PROPERTY(REG_PROPERTY_ID,REG_PATH_ID,REG_RESOURCE_NAME, REG_TENANT_ID)
-/
-CREATE TABLE REG_ASSOCIATION (
- REG_ASSOCIATION_ID INTEGER,
- REG_SOURCEPATH VARCHAR2 (2000) NOT NULL,
- REG_TARGETPATH VARCHAR2 (2000) NOT NULL,
- REG_ASSOCIATION_TYPE VARCHAR2 (2000) NOT NULL,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_ASSOCIATION PRIMARY KEY (REG_ASSOCIATION_ID, REG_TENANT_ID))
-/
-CREATE SEQUENCE REG_ASSOCIATION_SEQUENCE START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
-/
-CREATE OR REPLACE TRIGGER REG_ASSOCIATION_TRIGGER
- BEFORE INSERT
- ON REG_ASSOCIATION
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT REG_ASSOCIATION_SEQUENCE.nextval INTO :NEW.REG_ASSOCIATION_ID FROM dual;
- END;
-/
-
-CREATE TABLE REG_SNAPSHOT (
- REG_SNAPSHOT_ID INTEGER,
- REG_PATH_ID INTEGER NOT NULL,
- REG_RESOURCE_NAME VARCHAR2(256),
- REG_RESOURCE_VIDS BLOB NOT NULL,
- REG_TENANT_ID INTEGER DEFAULT 0,
- FOREIGN KEY (REG_PATH_ID,REG_TENANT_ID) REFERENCES REG_PATH (REG_PATH_ID,REG_TENANT_ID),
- CONSTRAINT PK_REG_SNAPSHOT PRIMARY KEY(REG_SNAPSHOT_ID, REG_TENANT_ID))
-/
-CREATE INDEX REG_SNAPSHOT_PATH_ID ON REG_SNAPSHOT(REG_PATH_ID, REG_RESOURCE_NAME, REG_TENANT_ID)
-/
-CREATE SEQUENCE REG_SNAPSHOT_SEQUENCE START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
-/
-CREATE OR REPLACE TRIGGER REG_SNAPSHOT_TRIGGER
- BEFORE INSERT
- ON REG_SNAPSHOT
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT REG_SNAPSHOT_SEQUENCE.nextval INTO :NEW.REG_SNAPSHOT_ID FROM dual;
- END;
-/
-/
-CREATE TABLE UM_TENANT (
- UM_ID INTEGER,
- UM_DOMAIN_NAME VARCHAR(255) NOT NULL,
- UM_EMAIL VARCHAR(255),
- UM_ACTIVE NUMBER(1) DEFAULT 0,
- PRIMARY KEY (UM_ID),
- UNIQUE(UM_DOMAIN_NAME))
-/
-CREATE SEQUENCE UM_TENANT_SEQUENCE START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
-/
-CREATE OR REPLACE TRIGGER UM_TENANT_TRIGGER
- BEFORE INSERT
- ON UM_TENANT
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_TENANT_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-CREATE TABLE UM_USER (
- UM_ID INTEGER,
- UM_USER_NAME VARCHAR2(255) NOT NULL,
- UM_USER_PASSWORD VARCHAR2(255) NOT NULL,
- UM_SALT_VALUE VARCHAR(31),
- UM_REQUIRE_CHANGE NUMBER(1) DEFAULT 0,
- 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))
-/
-CREATE SEQUENCE UM_USER_SEQUENCE START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
-/
-CREATE OR REPLACE TRIGGER UM_USER_TRIGGER
- BEFORE INSERT
- ON UM_USER
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_USER_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-
-CREATE TABLE UM_USER_ATTRIBUTE (
- UM_ID INTEGER,
- UM_ATTR_NAME VARCHAR2(255) NOT NULL,
- UM_ATTR_VALUE VARCHAR2(255),
- 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) ON DELETE CASCADE,
- PRIMARY KEY (UM_ID, UM_TENANT_ID))
-/
-CREATE SEQUENCE UM_USER_ATTRIBUTE_SEQUENCE START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
-/
-CREATE OR REPLACE TRIGGER UM_USER_ATTRIBUTE_TRIGGER
- BEFORE INSERT
- ON UM_USER_ATTRIBUTE
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_USER_ATTRIBUTE_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-
-CREATE TABLE UM_ROLE (
- UM_ID INTEGER,
- UM_ROLE_NAME VARCHAR2(255) NOT NULL,
- UM_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (UM_ID, UM_TENANT_ID),
- UNIQUE(UM_ROLE_NAME, UM_TENANT_ID))
-/
-CREATE SEQUENCE UM_ROLE_SEQUENCE START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
-/
-CREATE OR REPLACE TRIGGER UM_ROLE_TRIGGER
- BEFORE INSERT
- ON UM_ROLE
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_ROLE_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-
-CREATE TABLE UM_PERMISSION (
- UM_ID INTEGER,
- UM_RESOURCE_ID VARCHAR2(255) NOT NULL,
- UM_ACTION VARCHAR2(255) NOT NULL,
- UM_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (UM_ID, UM_TENANT_ID))
-/
-CREATE SEQUENCE UM_PERMISSION_SEQUENCE START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
-/
-CREATE OR REPLACE TRIGGER UM_PERMISSION_TRIGGER
- BEFORE INSERT
- ON UM_PERMISSION
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_PERMISSION_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-
-CREATE TABLE UM_ROLE_PERMISSION (
- UM_ID INTEGER,
- 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,
- UNIQUE (UM_PERMISSION_ID, UM_ROLE_NAME, UM_TENANT_ID),
- FOREIGN KEY (UM_PERMISSION_ID, UM_TENANT_ID) REFERENCES UM_PERMISSION(UM_ID, UM_TENANT_ID) ON DELETE CASCADE,
- --FOREIGN KEY (UM_ROLE_ID) REFERENCES UM_ROLE(UM_ID) ON DELETE CASCADE,
- PRIMARY KEY (UM_ID, UM_TENANT_ID))
-/
-CREATE SEQUENCE UM_ROLE_PERMISSION_SEQUENCE START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
-/
-CREATE OR REPLACE TRIGGER UM_ROLE_PERMISSION_TRIGGER
- BEFORE INSERT
- ON UM_ROLE_PERMISSION
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_ROLE_PERMISSION_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-
-CREATE TABLE UM_USER_PERMISSION (
- UM_ID INTEGER,
- 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,
- UNIQUE (UM_PERMISSION_ID, UM_USER_NAME, UM_TENANT_ID),
- FOREIGN KEY (UM_PERMISSION_ID, UM_TENANT_ID) REFERENCES UM_PERMISSION(UM_ID, UM_TENANT_ID) ON DELETE CASCADE,
- --FOREIGN KEY (UM_USER_ID) REFERENCES UM_USER(UM_ID) ON DELETE CASCADE,
- PRIMARY KEY (UM_ID, UM_TENANT_ID))
-/
-CREATE SEQUENCE UM_USER_PERMISSION_SEQUENCE START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
-/
-CREATE OR REPLACE TRIGGER UM_USER_PERMISSION_TRIGGER
- BEFORE INSERT
- ON UM_USER_PERMISSION
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_USER_PERMISSION_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-
-CREATE TABLE UM_USER_ROLE (
- UM_ID INTEGER,
- 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) ON DELETE CASCADE,
- FOREIGN KEY (UM_USER_ID, UM_TENANT_ID) REFERENCES UM_USER(UM_ID, UM_TENANT_ID) ON DELETE CASCADE,
- PRIMARY KEY (UM_ID, UM_TENANT_ID))
-/
-CREATE SEQUENCE UM_USER_ROLE_SEQUENCE START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
-/
-CREATE OR REPLACE TRIGGER UM_USER_ROLE_TRIGGER
- BEFORE INSERT
- ON UM_USER_ROLE
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_USER_ROLE_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-
-CREATE TABLE HYBRID_ROLE (
- UM_ID INTEGER,
- UM_ROLE_ID VARCHAR(255) NOT NULL,
- UM_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (UM_ID, UM_TENANT_ID),
- UNIQUE(UM_ROLE_ID, UM_TENANT_ID))
-/
-CREATE SEQUENCE HYBRID_ROLE_SEQUENCE START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
-/
-CREATE OR REPLACE TRIGGER HYBRID_ROLE_TRIGGER
- BEFORE INSERT
- ON HYBRID_ROLE
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT HYBRID_ROLE_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-
-CREATE TABLE HYBRID_USER_ROLE (
- UM_ID INTEGER,
- UM_USER_ID VARCHAR(255),
- UM_ROLE_ID VARCHAR(255) NOT NULL,
- UM_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (UM_ID, UM_TENANT_ID))
-/
-CREATE SEQUENCE HYBRID_USER_ROLE_SEQUENCE START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
-/
-CREATE OR REPLACE TRIGGER HYBRID_USER_ROLE_TRIGGER
- BEFORE INSERT
- ON HYBRID_USER_ROLE
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT HYBRID_USER_ROLE_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-
-CREATE TABLE UM_DIALECT(
- UM_ID INTEGER,
- 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)
-)
-/
-CREATE SEQUENCE UM_DIALECT_SEQUENCE START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
-/
-CREATE OR REPLACE TRIGGER UM_DIALECT_TRIGGER
- BEFORE INSERT
- ON UM_DIALECT
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_DIALECT_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-
-CREATE TABLE UM_CLAIM(
- UM_ID INTEGER,
- 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)
-)
-/
-CREATE SEQUENCE UM_CLAIM_SEQUENCE START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
-/
-CREATE OR REPLACE TRIGGER UM_CLAIM_TRIGGER
- BEFORE INSERT
- ON UM_CLAIM
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_CLAIM_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-
-CREATE TABLE UM_PROFILE_CONFIG(
- UM_ID INTEGER,
- UM_DIALECT_ID INTEGER,
- 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)
-)
-/
-CREATE SEQUENCE UM_PROFILE_CONFIG_SEQUENCE START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
-/
-CREATE OR REPLACE TRIGGER UM_PROFILE_CONFIG_TRIGGER
- BEFORE INSERT
- ON UM_PROFILE_CONFIG
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_PROFILE_CONFIG_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-
-CREATE TABLE UM_CLAIM_BEHAVIOR(
- UM_ID INTEGER,
- 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)
-)
-/
-CREATE SEQUENCE UM_CLAIM_BEHAVIOR_SEQUENCE START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
-/
-CREATE OR REPLACE TRIGGER UM_CLAIM_BEHAVIOR_TRIGGER
- BEFORE INSERT
- ON UM_CLAIM_BEHAVIOR
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_CLAIM_BEHAVIOR_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-
-CREATE TABLE UM_HYBRID_ROLE(
- UM_ID INTEGER NOT NULL,
- UM_ROLE_NAME VARCHAR(255),
- UM_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-)
-/
-CREATE SEQUENCE UM_HYBRID_ROLE_SEQUENCE START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
-/
-CREATE OR REPLACE TRIGGER UM_HYBRID_ROLE_TRIGGER
- BEFORE INSERT
- ON UM_HYBRID_ROLE
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_HYBRID_ROLE_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
-CREATE TABLE UM_HYBRID_USER_ROLE(
- UM_ID INTEGER NOT NULL,
- 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)
-)
-/
-CREATE SEQUENCE UM_HYBRID_USER_ROLE_SEQUENCE START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
-/
-CREATE OR REPLACE TRIGGER UM_HYBRID_USER_ROLE_TRIGGER
- BEFORE INSERT
- ON UM_HYBRID_USER_ROLE
- REFERENCING NEW AS NEW
- FOR EACH ROW
- BEGIN
- SELECT UM_HYBRID_USER_ROLE_SEQUENCE.nextval INTO :NEW.UM_ID FROM dual;
- END;
-/
http://git-wip-us.apache.org/repos/asf/stratos/blob/ee5e9639/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/postgresql.sql
----------------------------------------------------------------------
diff --git a/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/postgresql.sql b/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/postgresql.sql
deleted file mode 100644
index 36ae8a1..0000000
--- a/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/dbscripts/postgresql.sql
+++ /dev/null
@@ -1,446 +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.
-*/
-
-DROP TABLE IF EXISTS REG_CLUSTER_LOCK;
-CREATE TABLE 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)
-);
-
-DROP TABLE IF EXISTS REG_LOG;
-DROP SEQUENCE IF EXISTS REG_LOG_PK_SEQ;
-CREATE SEQUENCE REG_LOG_PK_SEQ;
-CREATE TABLE REG_LOG (
- REG_LOG_ID INTEGER DEFAULT NEXTVAL('REG_LOG_PK_SEQ'),
- REG_PATH VARCHAR (2000),
- REG_USER_ID VARCHAR (20) 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)
-);
-
-DROP TABLE IF EXISTS REG_PATH;
-DROP SEQUENCE IF EXISTS REG_PATH_PK_SEQ;
-CREATE SEQUENCE REG_PATH_PK_SEQ;
-CREATE TABLE REG_PATH(
- REG_PATH_ID INTEGER DEFAULT NEXTVAL('REG_PATH_PK_SEQ'),
- REG_PATH_VALUE VARCHAR(2000) 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)
-);
-
-CREATE INDEX REG_PATH_IND_BY_PATH_VALUE ON REG_PATH(REG_PATH_VALUE, REG_TENANT_ID);
-CREATE INDEX REG_PATH_IND_BY_PATH_PARENT_ID ON REG_PATH(REG_PATH_PARENT_ID, REG_TENANT_ID);
-
-DROP TABLE IF EXISTS REG_CONTENT;
-DROP SEQUENCE IF EXISTS REG_CONTENT_PK_SEQ;
-CREATE SEQUENCE REG_CONTENT_PK_SEQ;
-CREATE TABLE REG_CONTENT (
- REG_CONTENT_ID INTEGER DEFAULT NEXTVAL('REG_CONTENT_PK_SEQ'),
- REG_CONTENT_DATA BYTEA,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_CONTENT PRIMARY KEY(REG_CONTENT_ID, REG_TENANT_ID)
-);
-
-DROP TABLE IF EXISTS REG_CONTENT_HISTORY;
-CREATE TABLE REG_CONTENT_HISTORY (
- REG_CONTENT_ID INTEGER NOT NULL,
- REG_CONTENT_DATA BYTEA,
- REG_DELETED SMALLINT,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_CONTENT_HISTORY PRIMARY KEY(REG_CONTENT_ID, REG_TENANT_ID)
-);
-
-DROP TABLE IF EXISTS REG_RESOURCE;
-DROP SEQUENCE IF EXISTS REG_RESOURCE_PK_SEQ;
-CREATE SEQUENCE REG_RESOURCE_PK_SEQ;
-CREATE TABLE REG_RESOURCE (
- REG_PATH_ID INTEGER NOT NULL,
- REG_NAME VARCHAR(256),
- REG_VERSION INTEGER DEFAULT NEXTVAL('REG_RESOURCE_PK_SEQ'),
- REG_MEDIA_TYPE VARCHAR(500),
- REG_CREATOR VARCHAR(20) NOT NULL,
- REG_CREATED_TIME TIMESTAMP NOT NULL,
- REG_LAST_UPDATOR VARCHAR(20),
- REG_LAST_UPDATED_TIME TIMESTAMP NOT NULL,
- REG_DESCRIPTION VARCHAR(1000),
- REG_CONTENT_ID INTEGER,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_RESOURCE PRIMARY KEY(REG_VERSION, REG_TENANT_ID)
-);
-
-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 ON REG_RESOURCE(REG_NAME, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_IND_BY_PATH_ID_NAME ON REG_RESOURCE(REG_PATH_ID, REG_NAME, REG_TENANT_ID);
-
-DROP TABLE IF EXISTS REG_RESOURCE_HISTORY;
-CREATE TABLE 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(20) NOT NULL,
- REG_CREATED_TIME TIMESTAMP NOT NULL,
- REG_LAST_UPDATOR VARCHAR(20),
- REG_LAST_UPDATED_TIME TIMESTAMP NOT NULL,
- REG_DESCRIPTION VARCHAR(1000),
- REG_CONTENT_ID INTEGER,
- REG_DELETED SMALLINT,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_RESOURCE_HISTORY PRIMARY KEY(REG_VERSION, REG_TENANT_ID)
-);
-
-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 ON REG_RESOURCE_HISTORY(REG_NAME, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_HISTORY_IND_BY_PATH_ID_NAME ON REG_RESOURCE(REG_PATH_ID, REG_NAME, REG_TENANT_ID);
-
-DROP TABLE IF EXISTS REG_COMMENT;
-DROP SEQUENCE IF EXISTS REG_COMMENT_PK_SEQ;
-CREATE SEQUENCE REG_COMMENT_PK_SEQ;
-CREATE TABLE REG_COMMENT (
- REG_ID INTEGER DEFAULT NEXTVAL('REG_COMMENT_PK_SEQ'),
- REG_COMMENT_TEXT VARCHAR(500) NOT NULL,
- REG_USER_ID VARCHAR(20) 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)
-);
-
-DROP TABLE IF EXISTS REG_RESOURCE_COMMENT;
-CREATE TABLE 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
-);
-
-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 ON REG_RESOURCE_COMMENT(REG_PATH_ID, REG_RESOURCE_NAME, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_COMMENT_IND_BY_VERSION ON REG_RESOURCE_COMMENT(REG_VERSION, REG_TENANT_ID);
-
-DROP TABLE IF EXISTS REG_RATING;
-DROP SEQUENCE IF EXISTS REG_RATING_PK_SEQ;
-CREATE SEQUENCE REG_RATING_PK_SEQ;
-CREATE TABLE REG_RATING (
- REG_ID INTEGER DEFAULT NEXTVAL('REG_RATING_PK_SEQ'),
- REG_RATING INTEGER NOT NULL,
- REG_USER_ID VARCHAR(20) 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)
-);
-
-DROP TABLE IF EXISTS REG_RESOURCE_RATING;
-CREATE TABLE 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
-);
-
-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 ON REG_RESOURCE_RATING(REG_PATH_ID, REG_RESOURCE_NAME, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_RATING_IND_BY_VERSION ON REG_RESOURCE_RATING(REG_VERSION, REG_TENANT_ID);
-
-DROP TABLE IF EXISTS REG_TAG;
-DROP SEQUENCE IF EXISTS REG_TAG_PK_SEQ;
-CREATE SEQUENCE REG_TAG_PK_SEQ;
-CREATE TABLE REG_TAG (
- REG_ID INTEGER DEFAULT NEXTVAL('REG_TAG_PK_SEQ'),
- REG_TAG_NAME VARCHAR(500) NOT NULL,
- REG_USER_ID VARCHAR(20) 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)
-);
-
-DROP TABLE IF EXISTS REG_RESOURCE_TAG;
-CREATE TABLE 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
-);
-
-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 ON REG_RESOURCE_TAG(REG_PATH_ID, REG_RESOURCE_NAME, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_TAG_IND_BY_VERSION ON REG_RESOURCE_TAG(REG_VERSION, REG_TENANT_ID);
-
-DROP TABLE IF EXISTS REG_PROPERTY;
-DROP SEQUENCE IF EXISTS REG_PROPERTY_PK_SEQ;
-CREATE SEQUENCE REG_PROPERTY_PK_SEQ;
-CREATE TABLE REG_PROPERTY (
- REG_ID INTEGER DEFAULT NEXTVAL('REG_PROPERTY_PK_SEQ'),
- 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)
-);
-
-DROP TABLE IF EXISTS REG_RESOURCE_PROPERTY;
-CREATE TABLE 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
-);
-
-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 ON REG_RESOURCE_PROPERTY(REG_PATH_ID, REG_RESOURCE_NAME, REG_TENANT_ID);
-CREATE INDEX REG_RESOURCE_PROPERTY_IND_BY_VERSION ON REG_RESOURCE_PROPERTY(REG_VERSION, REG_TENANT_ID);
-
-
-DROP TABLE IF EXISTS REG_ASSOCIATION;
-DROP SEQUENCE IF EXISTS REG_ASSOCIATION_PK_SEQ;
-CREATE SEQUENCE REG_ASSOCIATION_PK_SEQ;
-CREATE TABLE REG_ASSOCIATION (
- REG_ASSOCIATION_ID INTEGER DEFAULT NEXTVAL('REG_ASSOCIATION_PK_SEQ'),
- REG_SOURCEPATH VARCHAR (2000) NOT NULL,
- REG_TARGETPATH VARCHAR (2000) NOT NULL,
- REG_ASSOCIATION_TYPE VARCHAR (2000) NOT NULL,
- REG_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (REG_ASSOCIATION_ID, REG_TENANT_ID)
-);
-
-DROP TABLE IF EXISTS REG_SNAPSHOT;
-DROP SEQUENCE IF EXISTS REG_SNAPSHOT_PK_SEQ;
-CREATE SEQUENCE REG_SNAPSHOT_PK_SEQ;
-CREATE TABLE REG_SNAPSHOT (
- REG_SNAPSHOT_ID INTEGER DEFAULT NEXTVAL('REG_SNAPSHOT_PK_SEQ'),
- REG_PATH_ID INTEGER NOT NULL,
- REG_RESOURCE_NAME VARCHAR(255),
- REG_RESOURCE_VIDS BYTEA NOT NULL,
- REG_TENANT_ID INTEGER DEFAULT 0,
- CONSTRAINT PK_REG_SNAPSHOT PRIMARY KEY(REG_SNAPSHOT_ID, REG_TENANT_ID)
-);
-
-CREATE INDEX REG_SNAPSHOT_IND_BY_PATH_ID_AND_RESOURCE_NAME 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
--- ################################
-
-DROP TABLE IF EXISTS UM_TENANT;
-DROP SEQUENCE IF EXISTS UM_TENANT_PK_SEQ;
-CREATE SEQUENCE UM_TENANT_PK_SEQ;
-CREATE TABLE UM_TENANT (
- UM_ID INTEGER DEFAULT NEXTVAL('UM_TENANT_PK_SEQ'),
- UM_DOMAIN_NAME VARCHAR(255) NOT NULL,
- UM_EMAIL VARCHAR(255),
- UM_ACTIVE BOOLEAN DEFAULT FALSE,
- PRIMARY KEY (UM_ID),
- UNIQUE(UM_DOMAIN_NAME));
-
-DROP TABLE IF EXISTS UM_USER CASCADE;
-DROP SEQUENCE IF EXISTS UM_USER_PK_SEQ;
-CREATE SEQUENCE UM_USER_PK_SEQ;
-CREATE TABLE UM_USER (
- UM_ID INTEGER DEFAULT NEXTVAL('UM_USER_PK_SEQ'),
- 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)
-);
-
-DROP TABLE IF EXISTS UM_ROLE CASCADE;
-DROP SEQUENCE IF EXISTS UM_ROLE_PK_SEQ;
-CREATE SEQUENCE UM_ROLE_PK_SEQ;
-CREATE TABLE UM_ROLE (
- UM_ID INTEGER DEFAULT NEXTVAL('UM_ROLE_PK_SEQ'),
- 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)
-);
-
-DROP TABLE IF EXISTS UM_PERMISSION CASCADE;
-DROP SEQUENCE IF EXISTS UM_PERMISSION_PK_SEQ;
-CREATE SEQUENCE UM_PERMISSION_PK_SEQ;
-CREATE TABLE UM_PERMISSION (
- UM_ID INTEGER DEFAULT NEXTVAL('UM_PERMISSION_PK_SEQ'),
- 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)
-);
-
-CREATE INDEX INDEX_UM_PERMISSION_UM_RESOURCE_ID_UM_ACTION
- ON UM_PERMISSION (UM_RESOURCE_ID, UM_ACTION, UM_TENANT_ID);
-
-
-DROP TABLE IF EXISTS UM_ROLE_PERMISSION;
-DROP SEQUENCE IF EXISTS UM_ROLE_PERMISSION_PK_SEQ;
-CREATE SEQUENCE UM_ROLE_PERMISSION_PK_SEQ;
-CREATE TABLE UM_ROLE_PERMISSION (
- UM_ID INTEGER DEFAULT NEXTVAL('UM_ROLE_PERMISSION_PK_SEQ'),
- 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)
-);
-
--- REMOVED UNIQUE (UM_PERMISSION_ID, UM_ROLE_ID)
-DROP TABLE IF EXISTS UM_USER_PERMISSION;
-DROP SEQUENCE IF EXISTS UM_USER_PERMISSION_PK_SEQ;
-CREATE SEQUENCE UM_USER_PERMISSION_PK_SEQ;
-CREATE TABLE UM_USER_PERMISSION (
- UM_ID INTEGER DEFAULT NEXTVAL('UM_USER_PERMISSION_PK_SEQ'),
- 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)
-);
-
--- REMOVED UNIQUE (UM_PERMISSION_ID, UM_USER_ID)
-DROP TABLE IF EXISTS UM_USER_ROLE;
-DROP SEQUENCE IF EXISTS UM_USER_ROLE_PK_SEQ;
-CREATE SEQUENCE UM_USER_ROLE_PK_SEQ;
-CREATE TABLE UM_USER_ROLE (
- UM_ID INTEGER DEFAULT NEXTVAL('UM_USER_ROLE_PK_SEQ'),
- 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)
-);
-
-DROP TABLE IF EXISTS UM_USER_ATTRIBUTE;
-DROP SEQUENCE IF EXISTS UM_USER_ATTRIBUTE_PK_SEQ;
-CREATE SEQUENCE UM_USER_ATTRIBUTE_PK_SEQ;
-CREATE TABLE UM_USER_ATTRIBUTE (
- UM_ID INTEGER DEFAULT NEXTVAL('UM_USER_ATTRIBUTE_PK_SEQ'),
- 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)
-);
-
-
-DROP TABLE IF EXISTS UM_DIALECT CASCADE;
-DROP SEQUENCE IF EXISTS UM_DIALECT_PK_SEQ;
-CREATE SEQUENCE UM_DIALECT_PK_SEQ;
-CREATE TABLE UM_DIALECT(
- UM_ID INTEGER DEFAULT NEXTVAL('UM_DIALECT_PK_SEQ'),
- 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)
-);
-
-DROP TABLE IF EXISTS UM_CLAIM;
-DROP SEQUENCE IF EXISTS UM_CLAIM_PK_SEQ;
-CREATE SEQUENCE UM_CLAIM_PK_SEQ;
-CREATE TABLE UM_CLAIM(
- UM_ID INTEGER DEFAULT NEXTVAL('UM_CLAIM_PK_SEQ'),
- 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)
-);
-
-DROP TABLE IF EXISTS UM_PROFILE_CONFIG;
-DROP SEQUENCE IF EXISTS UM_PROFILE_CONFIG_PK_SEQ;
-CREATE SEQUENCE UM_PROFILE_CONFIG_PK_SEQ;
-CREATE TABLE UM_PROFILE_CONFIG(
- UM_ID INTEGER DEFAULT NEXTVAL('UM_PROFILE_CONFIG_PK_SEQ'),
- 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)
-);
-
-DROP TABLE IF EXISTS UM_CLAIM_BEHAVIOR;
-DROP SEQUENCE IF EXISTS UM_CLAIM_BEHAVIOR_PK_SEQ;
-CREATE SEQUENCE UM_CLAIM_BEHAVIOR_PK_SEQ;
-CREATE TABLE UM_CLAIM_BEHAVIOR(
- UM_ID INTEGER DEFAULT NEXTVAL('UM_CLAIM_BEHAVIOR_PK_SEQ'),
- 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)
-);
-
-DROP TABLE IF EXISTS UM_HYBRID_ROLE;
-DROP SEQUENCE IF EXISTS UM_HYBRID_ROLE_PK_SEQ;
-CREATE SEQUENCE UM_HYBRID_ROLE_PK_SEQ;
-CREATE TABLE UM_HYBRID_ROLE(
- UM_ID INTEGER DEFAULT NEXTVAL('UM_HYBRID_ROLE_PK_SEQ'),
- UM_ROLE_NAME VARCHAR(255),
- UM_TENANT_ID INTEGER DEFAULT 0,
- PRIMARY KEY (UM_ID, UM_TENANT_ID)
-);
-
-DROP TABLE IF EXISTS UM_HYBRID_USER_ROLE;
-DROP SEQUENCE IF EXISTS UM_HYBRID_USER_ROLE_PK_SEQ;
-CREATE SEQUENCE UM_HYBRID_USER_ROLE_PK_SEQ;
-CREATE TABLE UM_HYBRID_USER_ROLE(
- UM_ID INTEGER DEFAULT NEXTVAL('UM_HYBRID_USER_ROLE_PK_SEQ'),
- 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)
-);
-
http://git-wip-us.apache.org/repos/asf/stratos/blob/ee5e9639/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/repository/README
----------------------------------------------------------------------
diff --git a/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/repository/README b/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/repository/README
deleted file mode 100644
index bdd5963..0000000
--- a/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/repository/README
+++ /dev/null
@@ -1,22 +0,0 @@
-CARBON_HOME/repository is the main repository for all kind of deployments and
-configurations in Carbon. This includes all Axis2 artifacts, Synapse artifacts etc. In
-addition to that, Axis2 configurations, Carbon configurations etc are also hosted
-under this folder.
-
-1. lib
- Directory contains all the client side Axis2 libraries. These libraries will be copied here after
- starting the server once or by running 'ant' from CARBON_HOME/bin.
-
-2. deployment
- Directory can be used to deploy Axis2 (can have Synapse, BPel stuff as well) artifacts for both
- server side and client side. See deployment/README for more details.
-
-3. conf
- Directory contains all the configuration files. axis2.xml, carbon.xml etc.
-
-4. components
- Directory contains all OSGi related stuff. Carbon bundles, OSGi configuration
- files and p2 stuff. See components/README for more details.
-
-5. logs
- Directory contains all Carbon logs.
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/stratos/blob/ee5e9639/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/repository/conf/README
----------------------------------------------------------------------
diff --git a/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/repository/conf/README b/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/repository/conf/README
deleted file mode 100644
index 3faeb49..0000000
--- a/components/org.apache.stratos.throttling.manager/src/test/resources/carbon-home/repository/conf/README
+++ /dev/null
@@ -1,39 +0,0 @@
-CARBON_HOME/repository/conf directory contains all the Carbon configuration files
-
-1. axis2.xml
- The Apache Axis2 configuration file. Apache Axis2 is used at the core
- of WSO2 Carbon.
-
-2. carbon.xml
- The Carbon server configuration file
-
-3. mime.types
- Defines MIME types to file extension mappings.
-
-4. README
- This file
-
-5. registry.xml
- The Carbon registry configuration file. This will be used when the WSO2
- Embedded Registry is used.
-
-6. synapse.xml
- The Apache Synapse configuration file. This will be used if Apache Synapse
- or WSO2 ESB related Carbon components are deployed.
-
-7. mgt-transports.xml
- Used in standalone mode to configure HTTP/S transports for the Carbon management console
-
-8. user-mgt.xml
- The User Manager configuration file used for configuring user management
- details.
-
-9. wrapper.conf
- The Java Service Wrapper (JSW) configuration file. JSW is used for running
- Carbon as a Unix daemon or Windows NT service.
-
-10. secret-conf.properties
- The Secret Manager Configuration that is used by secret vault component
-
-11 cipher-text.properties
- File based secret repository