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
