Author: chathura Date: Fri Feb 8 00:37:47 2008 New Revision: 13445 Log:
Removed the old mysql script. Modified: trunk/registry/modules/core/src/main/resources/database-scripts/mysql-registry.sql Modified: trunk/registry/modules/core/src/main/resources/database-scripts/mysql-registry.sql ============================================================================== --- trunk/registry/modules/core/src/main/resources/database-scripts/mysql-registry.sql (original) +++ trunk/registry/modules/core/src/main/resources/database-scripts/mysql-registry.sql Fri Feb 8 00:37:47 2008 @@ -1,69 +0,0 @@ -CREATE TABLE ARTIFACTS (AID INTEGER PRIMARY KEY AUTO_INCREMENT, - PATH VARCHAR (500) NOT NULL UNIQUE, - MEDIA_TYPE VARCHAR (500), - DIRECTORY INTEGER NOT NULL, - STATE INTEGER, - AUTHOR VARCHAR (500), - CREATED_TIME TIMESTAMP, - LAST_UPDATER VARCHAR (500), - LAST_UPDATED_TIME TIMESTAMP, - DESCRIPTION VARCHAR (500), - CONTENT LONGBLOB); - -CREATE TABLE PROPERTIES (P_ID INTEGER PRIMARY KEY AUTO_INCREMENT, - AID INTEGER NOT NULL, - PKEY VARCHAR (100) NOT NULL, - PVALUE VARCHAR (500) NOT NULL, - UNIQUE (AID, PKEY), - FOREIGN KEY (AID) REFERENCES ARTIFACTS (AID)); - -CREATE TABLE CHILDREN (CID INTEGER PRIMARY KEY AUTO_INCREMENT, - PARENT_ID INTEGER NOT NULL, - CHILD_ID INTEGER NOT NULL, - UNIQUE (PARENT_ID, CHILD_ID), - FOREIGN KEY (PARENT_ID) REFERENCES ARTIFACTS (AID), - FOREIGN KEY (CHILD_ID) REFERENCES ARTIFACTS (AID)); - -CREATE TABLE TAGS (TAG_ID INTEGER PRIMARY KEY AUTO_INCREMENT, - TAG_NAME VARCHAR (500) NOT NULL UNIQUE); - -CREATE TABLE TAGGINGS (TN_ID INTEGER PRIMARY KEY AUTO_INCREMENT, - TAG_ID INTEGER NOT NULL, - AID INTEGER NOT NULL, - USER_ID VARCHAR (20) NOT NULL, - TAGGED_TIME TIMESTAMP NOT NULL, - UNIQUE (TAG_ID, AID, USER_ID), - FOREIGN KEY (TAG_ID) REFERENCES TAGS (TAG_ID), - FOREIGN KEY (AID) REFERENCES ARTIFACTS (AID)); - -CREATE TABLE COMMENTS (CM_ID INTEGER PRIMARY KEY AUTO_INCREMENT, - AID INTEGER NOT NULL, - USER_ID VARCHAR (20) NOT NULL, - COMMENT_TEXT VARCHAR (500) NOT NULL, - COMMENTED_TIME TIMESTAMP NOT NULL, - FOREIGN KEY (AID) REFERENCES ARTIFACTS (AID)); - -CREATE TABLE RATINGS (R_ID INTEGER PRIMARY KEY AUTO_INCREMENT, - AID INTEGER NOT NULL, - USER_ID VARCHAR (20) NOT NULL, - RATING INTEGER NOT NULL, - RATED_TIME TIMESTAMP NOT NULL, - FOREIGN KEY (AID) REFERENCES ARTIFACTS (AID)); - -CREATE TABLE VERSIONS (AID INTEGER NOT NULL, - VN INTEGER NOT NULL, - CONTENT LONGBLOB, - AUTHOR VARCHAR (500), - UPDATED_TIME TIMESTAMP, - UNIQUE (AID,VN), - FOREIGN KEY (AID) REFERENCES ARTIFACTS (AID)); - -CREATE TABLE DEPENDENCY (AID INTEGER NOT NULL, - VN INTEGER NOT NULL, - DAID INTEGER NOT NULL, - DVN INTEGER NOT NULL, - UNIQUE (AID,VN,DAID,DVN), - FOREIGN KEY (DAID) REFERENCES ARTIFACTS (AID), - FOREIGN KEY (AID) REFERENCES ARTIFACTS (AID)); - - _______________________________________________ Registry-dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/registry-dev
