Author: keith Date: Mon Jul 20 01:25:51 2009 New Revision: 41521 URL: http://wso2.org/svn/browse/wso2?view=rev&revision=41521
Log: Recreting the Carbon database cause the deacription field was just 500 and it was not enough. Added: trunk/mashup/java/modules/distribution/dbscripts/ trunk/mashup/java/modules/distribution/dbscripts/h2.sql Modified: trunk/mashup/java/modules/distribution/pom.xml Added: trunk/mashup/java/modules/distribution/dbscripts/h2.sql URL: http://wso2.org/svn/browse/wso2/trunk/mashup/java/modules/distribution/dbscripts/h2.sql?pathrev=41521 ============================================================================== --- (empty file) +++ trunk/mashup/java/modules/distribution/dbscripts/h2.sql Mon Jul 20 01:25:51 2009 @@ -0,0 +1,399 @@ +CREATE TABLE IF NOT EXISTS 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) +); + +CREATE TABLE IF NOT EXISTS REG_LOG ( + REG_LOG_ID INTEGER AUTO_INCREMENT, + 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) +); + +CREATE TABLE IF NOT EXISTS REG_PATH( + REG_PATH_ID INTEGER NOT NULL AUTO_INCREMENT, + REG_PATH_VALUE VARCHAR(2000) NOT NULL, + REG_PATH_PARENT_ID INT, + REG_TENANT_ID INTEGER DEFAULT 0, + CONSTRAINT PK_REG_PATH PRIMARY KEY(REG_PATH_ID) +); +CREATE INDEX IF NOT EXISTS REG_PATH_IND_BY_NAME ON REG_PATH(REG_PATH_VALUE); +CREATE INDEX IF NOT EXISTS REG_PATH_IND_BY_PARENT_ID ON REG_PATH(REG_PATH_PARENT_ID); + + +CREATE TABLE IF NOT EXISTS REG_CONTENT ( + REG_CONTENT_ID INTEGER NOT NULL AUTO_INCREMENT, + REG_CONTENT_DATA LONGBLOB, + REG_TENANT_ID INTEGER DEFAULT 0, + CONSTRAINT PK_REG_CONTENT PRIMARY KEY(REG_CONTENT_ID) +); + +CREATE TABLE IF NOT EXISTS REG_CONTENT_HISTORY ( + REG_CONTENT_ID INTEGER NOT NULL, + REG_CONTENT_DATA LONGBLOB, + REG_DELETED SMALLINT, + REG_TENANT_ID INTEGER DEFAULT 0, + CONSTRAINT PK_REG_CONTENT_HISTORY PRIMARY KEY(REG_CONTENT_ID) +); + +CREATE TABLE IF NOT EXISTS REG_RESOURCE ( + REG_PATH_ID INTEGER NOT NULL, + REG_NAME VARCHAR(256), + REG_VERSION INTEGER NOT NULL AUTO_INCREMENT, + 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) +); + +ALTER TABLE REG_RESOURCE ADD CONSTRAINT IF NOT EXISTS REG_RESOURCE_FK_BY_PATH_ID FOREIGN KEY (REG_PATH_ID) REFERENCES REG_PATH (REG_PATH_ID); +ALTER TABLE REG_RESOURCE ADD CONSTRAINT IF NOT EXISTS REG_RESOURCE_FK_BY_CONTENT_ID FOREIGN KEY (REG_CONTENT_ID) REFERENCES REG_CONTENT (REG_CONTENT_ID); +CREATE INDEX IF NOT EXISTS REG_RESOURCE_IND_BY_NAME ON REG_RESOURCE(REG_NAME); +CREATE INDEX IF NOT EXISTS REG_RESOURCE_IND_BY_PATH_ID_NAME ON REG_RESOURCE(REG_PATH_ID, REG_NAME); + +CREATE TABLE IF NOT EXISTS 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) +); + +ALTER TABLE REG_RESOURCE_HISTORY ADD CONSTRAINT IF NOT EXISTS REG_RESOURCE_HIST_FK_BY_PATHID FOREIGN KEY (REG_PATH_ID) REFERENCES REG_PATH (REG_PATH_ID); +ALTER TABLE REG_RESOURCE_HISTORY ADD CONSTRAINT IF NOT EXISTS REG_RESOURCE_HIST_FK_BY_CONTENT_ID FOREIGN KEY (REG_CONTENT_ID) REFERENCES REG_CONTENT_HISTORY (REG_CONTENT_ID); +CREATE INDEX IF NOT EXISTS REG_RESOURCE_HISTORY_IND_BY_NAME ON REG_RESOURCE_HISTORY(REG_NAME); +CREATE INDEX IF NOT EXISTS REG_RESOURCE_HISTORY_IND_BY_PATH_ID_NAME ON REG_RESOURCE(REG_PATH_ID, REG_NAME); + +CREATE TABLE IF NOT EXISTS REG_COMMENT ( + REG_ID INTEGER NOT NULL AUTO_INCREMENT, + 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) +); + +CREATE TABLE IF NOT EXISTS 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 IF NOT EXISTS REG_RESOURCE_COMMENT_FK_BY_PATH_ID FOREIGN KEY (REG_PATH_ID) REFERENCES REG_PATH (REG_PATH_ID); +ALTER TABLE REG_RESOURCE_COMMENT ADD CONSTRAINT IF NOT EXISTS REG_RESOURCE_COMMENT_FK_BY_COMMENT_ID FOREIGN KEY (REG_COMMENT_ID) REFERENCES REG_COMMENT (REG_ID); +CREATE INDEX IF NOT EXISTS REG_RESOURCE_COMMENT_IND_BY_PATH_ID_AND_RESOURCE_NAME ON REG_RESOURCE_COMMENT(REG_PATH_ID, REG_RESOURCE_NAME); + +CREATE TABLE IF NOT EXISTS REG_RATING ( + REG_ID INTEGER NOT NULL AUTO_INCREMENT, + 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) +); + +CREATE TABLE IF NOT EXISTS 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 IF NOT EXISTS REG_RESOURCE_RATING_FK_BY_PATH_ID FOREIGN KEY (REG_PATH_ID) REFERENCES REG_PATH (REG_PATH_ID); +ALTER TABLE REG_RESOURCE_RATING ADD CONSTRAINT IF NOT EXISTS REG_RESOURCE_RATING_FK_BY_RATING_ID FOREIGN KEY (REG_RATING_ID) REFERENCES REG_RATING (REG_ID); +CREATE INDEX IF NOT EXISTS REG_RESOURCE_RATING_IND_BY_PATH_ID_AND_RESOURCE_NAME ON REG_RESOURCE_RATING(REG_PATH_ID, REG_RESOURCE_NAME); + +CREATE TABLE IF NOT EXISTS REG_TAG ( + REG_ID INTEGER NOT NULL AUTO_INCREMENT, + 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) +); + +CREATE TABLE IF NOT EXISTS 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 IF NOT EXISTS REG_RESOURCE_TAG_FK_BY_PATH_ID FOREIGN KEY (REG_PATH_ID) REFERENCES REG_PATH (REG_PATH_ID); +ALTER TABLE REG_RESOURCE_TAG ADD CONSTRAINT IF NOT EXISTS REG_RESOURCE_TAG_FK_BY_TAG_ID FOREIGN KEY (REG_TAG_ID) REFERENCES REG_TAG (REG_ID); +CREATE INDEX IF NOT EXISTS REG_RESOURCE_TAG_IND_BY_PATH_ID_AND_RESOURCE_NAME ON REG_RESOURCE_TAG(REG_PATH_ID, REG_RESOURCE_NAME); + +CREATE TABLE IF NOT EXISTS REG_PROPERTY ( + REG_ID INTEGER NOT NULL AUTO_INCREMENT, + REG_NAME VARCHAR(100) NOT NULL, + REG_VALUE VARCHAR(1000), + REG_TENANT_ID INTEGER DEFAULT 0, + CONSTRAINT PK_REG_PROPERTY PRIMARY KEY(REG_ID) +); + +CREATE TABLE IF NOT EXISTS 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 IF NOT EXISTS REG_RESOURCE_PROPERTY_FK_BY_PATH_ID FOREIGN KEY (REG_PATH_ID) REFERENCES REG_PATH (REG_PATH_ID); +ALTER TABLE REG_RESOURCE_PROPERTY ADD CONSTRAINT IF NOT EXISTS REG_RESOURCE_PROPERTY_FK_BY_TAG_ID FOREIGN KEY (REG_PROPERTY_ID) REFERENCES REG_PROPERTY (REG_ID); +CREATE INDEX IF NOT EXISTS REG_RESOURCE_PROPERTY_IND_BY_PATH_ID_AND_RESOURCE_NAME ON REG_RESOURCE_PROPERTY(REG_PATH_ID, REG_RESOURCE_NAME); + +CREATE TABLE IF NOT EXISTS REG_ASSOCIATION ( + REG_ASSOCIATION_ID INTEGER AUTO_INCREMENT, + 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) +); + +CREATE TABLE IF NOT EXISTS REG_SNAPSHOT ( + REG_SNAPSHOT_ID INTEGER NOT NULL AUTO_INCREMENT, + REG_PATH_ID INTEGER NOT NULL, + REG_RESOURCE_NAME VARCHAR (256), + REG_RESOURCE_VIDS LONGBLOB NOT NULL, + REG_TENANT_ID INTEGER DEFAULT 0, + CONSTRAINT PK_REG_SNAPSHOT PRIMARY KEY(REG_SNAPSHOT_ID) +); + +ALTER TABLE REG_SNAPSHOT ADD CONSTRAINT IF NOT EXISTS REG_SNAPSHOT_FK_BY_PATH_ID FOREIGN KEY (REG_PATH_ID) REFERENCES REG_PATH (REG_PATH_ID); + +-- ################################ +-- USER MANAGER TABLES +-- ################################ +CREATE TABLE IF NOT EXISTS UM_USER ( + UM_ID INTEGER GENERATED ALWAYS AS IDENTITY, + UM_USER_NAME VARCHAR(255) NOT NULL, + UM_USER_PASSWORD VARCHAR(255) NOT NULL, + UM_TENANT_ID INTEGER DEFAULT 0, + PRIMARY KEY (UM_ID), + UNIQUE(UM_USER_NAME)); + +CREATE TABLE IF NOT EXISTS UM_USER_ATTRIBUTE ( + UM_ID INTEGER GENERATED ALWAYS AS IDENTITY, + 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) REFERENCES UM_USER(UM_ID), + PRIMARY KEY (UM_ID)); + +CREATE TABLE IF NOT EXISTS UM_ROLE ( + UM_ID INTEGER GENERATED ALWAYS AS IDENTITY, + UM_ROLE_NAME VARCHAR(255) NOT NULL, + UM_TENANT_ID INTEGER DEFAULT 0, + PRIMARY KEY (UM_ID), + UNIQUE(UM_ROLE_NAME)); + +CREATE TABLE IF NOT EXISTS UM_ROLE_ATTRIBUTE ( + UM_ID INTEGER GENERATED ALWAYS AS IDENTITY, + UM_ATTR_NAME VARCHAR(255) NOT NULL, + UM_ATTR_VALUE VARCHAR(255), + UM_ROLE_ID INTEGER, + UM_TENANT_ID INTEGER DEFAULT 0, + FOREIGN KEY (UM_ROLE_ID) REFERENCES UM_ROLE(UM_ID), + PRIMARY KEY (UM_ID)); + +CREATE TABLE IF NOT EXISTS UM_PERMISSION ( + UM_ID INTEGER GENERATED ALWAYS AS IDENTITY, + UM_RESOURCE_ID VARCHAR(255) NOT NULL, + UM_ACTION VARCHAR(255) NOT NULL, + UM_TENANT_ID INTEGER DEFAULT 0, + PRIMARY KEY (UM_ID)); + +CREATE INDEX IF NOT EXISTS INDEX_UM_PERMISSION_UM_RESOURCE_ID_UM_ACTION ON UM_PERMISSION (UM_RESOURCE_ID, UM_ACTION); + +CREATE TABLE IF NOT EXISTS UM_ROLE_PERMISSION ( + UM_ID INTEGER GENERATED ALWAYS AS IDENTITY, + UM_PERMISSION_ID INTEGER NOT NULL, + UM_ROLE_ID INTEGER NOT NULL, + UM_IS_ALLOWED SMALLINT NOT NULL, + UM_TENANT_ID INTEGER DEFAULT 0, + UNIQUE (UM_PERMISSION_ID, UM_ROLE_ID), + FOREIGN KEY (UM_PERMISSION_ID) REFERENCES UM_PERMISSION(UM_ID), + FOREIGN KEY (UM_ROLE_ID) REFERENCES UM_ROLE(UM_ID), + PRIMARY KEY (UM_ID)); + +CREATE TABLE IF NOT EXISTS UM_USER_PERMISSION ( + UM_ID INTEGER GENERATED ALWAYS AS IDENTITY, + UM_PERMISSION_ID INTEGER NOT NULL, + UM_USER_ID INTEGER NOT NULL, + UM_IS_ALLOWED SMALLINT NOT NULL, + UNIQUE (UM_PERMISSION_ID, UM_USER_ID), + UM_TENANT_ID INTEGER DEFAULT 0, + FOREIGN KEY (UM_PERMISSION_ID) REFERENCES UM_PERMISSION(UM_ID), + FOREIGN KEY (UM_USER_ID) REFERENCES UM_USER(UM_ID), + PRIMARY KEY (UM_ID)); + +CREATE TABLE IF NOT EXISTS UM_USER_ROLE ( + UM_ID INTEGER GENERATED ALWAYS AS IDENTITY, + 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), + FOREIGN KEY (UM_ROLE_ID) REFERENCES UM_ROLE(UM_ID), + FOREIGN KEY (UM_USER_ID) REFERENCES UM_USER(UM_ID), + PRIMARY KEY (UM_ID)); + +CREATE TABLE IF NOT EXISTS HYBRID_ROLE ( + UM_ID INTEGER GENERATED BY DEFAULT AS IDENTITY, + UM_ROLE_ID VARCHAR(255) NOT NULL, + UM_TENANT_ID INTEGER DEFAULT 0, + PRIMARY KEY (UM_ID), + UNIQUE(UM_ROLE_ID)); + +CREATE TABLE IF NOT EXISTS HYBRID_USER_ROLE ( + UM_ID INTEGER GENERATED BY DEFAULT AS IDENTITY, + UM_USER_ID VARCHAR(255), + UM_ROLE_ID VARCHAR(255) NOT NULL, + UM_TENANT_ID INTEGER DEFAULT 0, + PRIMARY KEY (UM_ID)); + +CREATE TABLE IF NOT EXISTS HYBRID_PERMISSION ( + UM_ID INTEGER GENERATED BY DEFAULT AS IDENTITY, + UM_RESOURCE_ID VARCHAR(255), + UM_ACTION VARCHAR(255) NOT NULL, + UM_TENANT_ID INTEGER DEFAULT 0, + PRIMARY KEY (UM_ID)); + +CREATE TABLE IF NOT EXISTS HYBRID_ROLE_PERMISSION ( + UM_ID INTEGER GENERATED BY DEFAULT AS IDENTITY, + UM_PERMISSION_ID INTEGER NOT NULL, + UM_ROLE_ID VARCHAR(255) NOT NULL, + UM_IS_ALLOWED SMALLINT NOT NULL, + UM_TENANT_ID INTEGER DEFAULT 0, + UNIQUE (UM_PERMISSION_ID, UM_ROLE_ID), + FOREIGN KEY (UM_PERMISSION_ID) REFERENCES HYBRID_PERMISSION(UM_ID), + PRIMARY KEY (UM_ID)); + +CREATE TABLE IF NOT EXISTS HYBRID_USER_PERMISSION ( + UM_ID INTEGER GENERATED BY DEFAULT AS IDENTITY, + UM_PERMISSION_ID INTEGER NOT NULL, + UM_USER_ID VARCHAR(255) NOT NULL, + UM_IS_ALLOWED SMALLINT NOT NULL, + UM_TENANT_ID INTEGER DEFAULT 0, + UNIQUE (UM_PERMISSION_ID, UM_USER_ID), + FOREIGN KEY (UM_PERMISSION_ID) REFERENCES HYBRID_PERMISSION(UM_ID), + PRIMARY KEY (UM_ID)); + + +CREATE TABLE IF NOT EXISTS UM_USER_DATA ( + UM_ID INTEGER GENERATED BY DEFAULT AS IDENTITY, + UM_USER_ID INTEGER NOT NULL, + UM_EMAIL VARCHAR(255), + UM_FIRST_NAME VARCHAR(255), + UM_LAST_NAME VARCHAR(255), + UM_BIRTH_DATE VARCHAR(255), + UM_FULL_NAME VARCHAR(255), + UM_NAME_PREFIX VARCHAR(255), + UM_GENDER VARCHAR(10), + UM_TIME_ZONE VARCHAR(255), + UM_COMPANY_NAME VARCHAR(255), + UM_JOB_TITLE VARCHAR(255), + UM_PRIMARY_PHONE VARCHAR(255), + UM_HOME_PHONE VARCHAR(255), + UM_WORK_PHONE VARCHAR(255), + UM_MOBILE_PHONE VARCHAR(255), + UM_STREET_ADDRESS VARCHAR(255), + UM_CITY VARCHAR(255), + UM_STATE VARCHAR(255), + UM_COUNTRY VARCHAR(255), + UM_POSTAL_CODE VARCHAR(255), + UM_WEB_PAGE VARCHAR(255), + UM_LANGUAGE VARCHAR(255), + UM_BLOG VARCHAR(255), + UM_PROFILE_ID VARCHAR(255), + UM_TENANT_ID INTEGER DEFAULT 0, + FOREIGN KEY (UM_USER_ID) REFERENCES UM_USER(UM_ID), + PRIMARY KEY (UM_ID) +); + + + +CREATE TABLE IF NOT EXISTS UM_BIN_DATA ( + UM_ID INTEGER GENERATED BY DEFAULT AS IDENTITY, + UM_USER_ID INTEGER NOT NULL, + UM_CONTENT_NAME VARCHAR(255) NOT NULL, + UM_CONTENT BLOB NOT NULL, + UM_PROFILE_ID VARCHAR(255) NOT NULL, + UM_TENANT_ID INTEGER DEFAULT 0, + FOREIGN KEY (UM_USER_ID) REFERENCES UM_USER(UM_ID), + PRIMARY KEY (UM_ID) +); + +CREATE TABLE IF NOT EXISTS UM_DIALECT( + UM_ID INTEGER GENERATED BY DEFAULT AS IDENTITY, + UM_DIALECT_URI VARCHAR(255) NOT NULL, + UM_REALM VARCHAR(63) NOT NULL, + UM_TENANT_ID INTEGER DEFAULT 0, + UNIQUE(UM_DIALECT_URI, UM_REALM), + PRIMARY KEY (UM_ID) +); + + +CREATE TABLE IF NOT EXISTS UM_CLAIM( + UM_ID INTEGER GENERATED BY DEFAULT AS IDENTITY, + 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), + FOREIGN KEY(UM_DIALECT_ID) REFERENCES UM_DIALECT(UM_ID), + PRIMARY KEY (UM_ID) +); + +CREATE TABLE IF NOT EXISTS UM_PROFILE_CONFIG( + UM_ID INTEGER GENERATED BY DEFAULT AS IDENTITY, + UM_DIALECT_ID INTEGER, + UM_PROFILE_NAME VARCHAR(255), + UM_TENANT_ID INTEGER DEFAULT 0, + FOREIGN KEY(UM_DIALECT_ID) REFERENCES UM_DIALECT(UM_ID), + PRIMARY KEY (UM_ID) +); + +CREATE TABLE IF NOT EXISTS UM_CLAIM_BEHAVIOR( + UM_ID INTEGER GENERATED BY DEFAULT AS IDENTITY, + UM_PROFILE_ID INTEGER, + UM_CLAIM_ID INTEGER, + UM_BEHAVIOUR SMALLINT, + UM_TENANT_ID INTEGER DEFAULT 0, + FOREIGN KEY(UM_PROFILE_ID) REFERENCES UM_PROFILE_CONFIG(UM_ID), + FOREIGN KEY(UM_CLAIM_ID) REFERENCES UM_CLAIM(UM_ID), + PRIMARY KEY (UM_ID) +); Modified: trunk/mashup/java/modules/distribution/pom.xml URL: http://wso2.org/svn/browse/wso2/trunk/mashup/java/modules/distribution/pom.xml?rev=41521&r1=41520&r2=41521&view=diff ============================================================================== --- trunk/mashup/java/modules/distribution/pom.xml (original) +++ trunk/mashup/java/modules/distribution/pom.xml Mon Jul 20 01:25:51 2009 @@ -817,7 +817,7 @@ <filter token="mashup_version" value="${version}"/> <copy toDir="${basedir}/target/tmp/wso2mashup-${pom.version}/repository/scripts/version.resources" filtering="on"> <fileset dir="../samples/version"/> - </copy> + </copy> </tasks> </configuration> <goals> @@ -871,12 +871,12 @@ <defaultStartLevel>10</defaultStartLevel> </configuration> </plugin> - + <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-antrun-plugin</artifactId> <version>1.1</version> - <executions> + <executions> <execution> <id>finalize</id> <phase>install</phase> @@ -884,8 +884,27 @@ <goal>run</goal> </goals> <configuration> - <tasks> - <echo message="Recereating wso2mashup ZIP file"/> + <tasks> + <echo message="Recereating wso2mashup ZIP file"/> + + <echo message="########### Recreate Default Database ##############"/> + <delete dir="${basedir}/target/tmp/wso2mashup-${pom.version}/database"/> + <path id="h2.classpath"> + <path refid="maven.compile.classpath"/> + </path> + + <sql + driver="org.h2.Driver" + url="jdbc:h2:${basedir}/target/tmp/wso2mashup-${pom.version}/database/WSO2CARBON_DB" + userid="wso2carbon" password="wso2carbon" autocommit="true" + onerror="continue"> + <classpath> + <path refid="h2.classpath"/> + </classpath> + <fileset file="${basedir}/dbscripts/h2.sql"/> + </sql> + <echo message="##################### END ############################"/> + <zip destfile="${basedir}/target/wso2mashup-${pom.version}.zip" update="true"> <zipfileset dir="${basedir}/target/tmp/" excludes="**/*.sh,**/native/*"/> <zipfileset dir="${basedir}/target/tmp/" includes="**/*.sh,**/native/*" filemode="755"/> _______________________________________________ Mashup-dev mailing list [email protected] https://wso2.org/cgi-bin/mailman/listinfo/mashup-dev
