You are viewing a plain text version of this content. The canonical link for it is here.
Posted to slide-dev@jakarta.apache.org by cm...@apache.org on 2002/08/08 23:35:30 UTC
cvs commit: jakarta-slide/src/stores/org/apache/slide/store/impl/rdbms HSQLDBSchema.sql
cmlenz 2002/08/08 14:35:30
Modified: src/stores/org/apache/slide/store/impl/rdbms
HSQLDBSchema.sql
Log:
- Change all the bigint's to int's, so that the schema will actually be
accepted by HSQLDB
- Cosmetics
Revision Changes Path
1.2 +77 -87 jakarta-slide/src/stores/org/apache/slide/store/impl/rdbms/HSQLDBSchema.sql
Index: HSQLDBSchema.sql
===================================================================
RCS file: /home/cvs/jakarta-slide/src/stores/org/apache/slide/store/impl/rdbms/HSQLDBSchema.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- HSQLDBSchema.sql 7 Aug 2002 18:49:49 -0000 1.1
+++ HSQLDBSchema.sql 8 Aug 2002 21:35:30 -0000 1.2
@@ -1,141 +1,131 @@
-
/**********************************************************************/
/****** CREATE SLIDE TABLES FOR HYPERSONIC DB ******/
/**********************************************************************/
CREATE TABLE URI (
- URI_ID INT NOT NULL IDENTITY PRIMARY KEY,
+ URI_ID int NOT NULL IDENTITY PRIMARY KEY,
URI_STRING varchar(800) NOT NULL,
- UNIQUE (URI_ID)
+ UNIQUE (URI_ID)
);
CREATE TABLE OBJECT (
- URI_ID INT PRIMARY KEY,
+ URI_ID int PRIMARY KEY,
CLASS_NAME varchar(255) NOT NULL,
- CONSTRAINT FK_OBJECT_URI_ID
- FOREIGN KEY (URI_ID)
- REFERENCES URI (URI_ID)
+ CONSTRAINT FK_OBJECT
+ FOREIGN KEY (URI_ID) REFERENCES URI (URI_ID)
);
CREATE TABLE CHILDREN (
- URI_ID BIGINT NOT NULL,
- CHILD_URI_ID BIGINT NOT NULL,
- CONSTRAINT FK_CHILD_URI_ID
- FOREIGN KEY (URI_ID) REFERENCES URI (URI_ID),
- FOREIGN KEY (CHILD_URI_ID) REFERENCES URI (URI_ID),
+ URI_ID int NOT NULL,
+ CHILD_URI_ID int NOT NULL,
+ CONSTRAINT FK_CHILDREN
+ FOREIGN KEY (URI_ID) REFERENCES URI (URI_ID),
+ FOREIGN KEY (CHILD_URI_ID) REFERENCES URI (URI_ID),
UNIQUE (URI_ID, CHILD_URI_ID)
);
CREATE TABLE LINKS (
- URI_ID bigint NOT NULL,
- LINK_TO_ID bigint NOT NULL,
- CONSTRAINT FK_URI_ID
- FOREIGN KEY (URI_ID) REFERENCES URI (URI_ID),
- FOREIGN KEY (LINK_TO_ID) REFERENCES URI (URI_ID),
+ URI_ID int NOT NULL,
+ LINK_TO_ID int NOT NULL,
+ CONSTRAINT FK_LINKS
+ FOREIGN KEY (URI_ID) REFERENCES URI (URI_ID),
+ FOREIGN KEY (LINK_TO_ID) REFERENCES URI (URI_ID),
UNIQUE (URI_ID, LINK_TO_ID)
);
-
CREATE TABLE LOCKS (
- LOCK_ID bigint PRIMARY KEY,
- OBJECT_ID bigint NOT NULL,
- SUBJECT_ID bigint NOT NULL,
- TYPE_ID bigint NOT NULL,
- EXPIRATION_DATE numeric(14, 0) NOT NULL,
- IS_INHERITABLE bit NOT NULL,
- IS_EXCLUSIVE bit NOT NULL,
- CONSTRAINT FK_LOCKS_LOCK_ID
- FOREIGN KEY (LOCK_ID) REFERENCES URI (URI_ID),
- FOREIGN KEY (OBJECT_ID) REFERENCES URI (URI_ID),
- FOREIGN KEY (SUBJECT_ID) REFERENCES URI (URI_ID),
- FOREIGN KEY (TYPE_ID) REFERENCES URI (URI_ID)
+ LOCK_ID int PRIMARY KEY,
+ OBJECT_ID int NOT NULL,
+ SUBJECT_ID int NOT NULL,
+ TYPE_ID int NOT NULL,
+ EXPIRATION_DATE numeric(14, 0) NOT NULL,
+ IS_INHERITABLE bit NOT NULL,
+ IS_EXCLUSIVE bit NOT NULL,
+ CONSTRAINT FK_LOCKS
+ FOREIGN KEY (LOCK_ID) REFERENCES URI (URI_ID),
+ FOREIGN KEY (OBJECT_ID) REFERENCES URI (URI_ID),
+ FOREIGN KEY (SUBJECT_ID) REFERENCES URI (URI_ID),
+ FOREIGN KEY (TYPE_ID) REFERENCES URI (URI_ID)
);
-
CREATE TABLE BRANCH (
- BRANCH_ID int NOT NULL IDENTITY PRIMARY KEY,
- BRANCH_STRING varchar(255) NOT NULL,
+ BRANCH_ID int NOT NULL IDENTITY PRIMARY KEY,
+ BRANCH_STRING varchar(255) NOT NULL,
UNIQUE (BRANCH_ID)
);
CREATE TABLE LABEL (
- LABEL_ID int NOT NULL IDENTITY PRIMARY KEY,
- LABEL_STRING varchar(255) NOT NULL,
- UNIQUE (LABEL_ID)
+ LABEL_ID int NOT NULL IDENTITY PRIMARY KEY,
+ LABEL_STRING varchar(255) NOT NULL,
+ UNIQUE (LABEL_ID)
);
CREATE TABLE VERSION (
- URI_ID bigint PRIMARY KEY,
- IS_VERSIONED bit NOT NULL,
- CONSTRAINT FK_VERSION_URI_ID
- FOREIGN KEY (URI_ID)
- REFERENCES URI (URI_ID)
+ URI_ID int PRIMARY KEY,
+ IS_VERSIONED bit NOT NULL,
+ CONSTRAINT FK_VERSION
+ FOREIGN KEY (URI_ID) REFERENCES URI (URI_ID)
);
-
CREATE TABLE VERSION_HISTORY (
- VERSION_ID int IDENTITY PRIMARY KEY,
- URI_ID bigint NOT NULL,
- BRANCH_ID bigint NOT NULL,
- REVISION_NO VARCHAR(20) NOT NULL,
- CONSTRAINT FK_VERSION_ID
- FOREIGN KEY (URI_ID) REFERENCES VERSION (URI_ID),
- FOREIGN KEY (BRANCH_ID) REFERENCES BRANCH (BRANCH_ID),
+ VERSION_ID int IDENTITY PRIMARY KEY,
+ URI_ID int NOT NULL,
+ BRANCH_ID int NOT NULL,
+ REVISION_NO VARCHAR(20) NOT NULL,
+ CONSTRAINT FK_VERSION_HISTORY
+ FOREIGN KEY (URI_ID) REFERENCES VERSION (URI_ID),
+ FOREIGN KEY (BRANCH_ID) REFERENCES BRANCH (BRANCH_ID),
UNIQUE (URI_ID, BRANCH_ID, REVISION_NO)
);
-
CREATE TABLE VERSION_PREDS (
- VERSION_ID bigint NOT NULL,
- PREDECESSOR_ID bigint NOT NULL,
- CONSTRAINT FK_VERSION_ID
- FOREIGN KEY (VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID),
- FOREIGN KEY (PREDECESSOR_ID) REFERENCES VERSION_HISTORY (VERSION_ID),
+ VERSION_ID int NOT NULL,
+ PREDECESSOR_ID int NOT NULL,
+ CONSTRAINT FH_VERSION_PREDS
+ FOREIGN KEY (VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID),
+ FOREIGN KEY (PREDECESSOR_ID) REFERENCES VERSION_HISTORY (VERSION_ID),
UNIQUE (VERSION_ID, PREDECESSOR_ID)
);
-
+
CREATE TABLE VERSION_LABELS (
- VERSION_ID bigint NOT NULL,
- LABEL_ID bigint NOT NULL,
- CONSTRAINT FK_VERSION_ID
- FOREIGN KEY (VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID),
- FOREIGN KEY (LABEL_ID) REFERENCES LABEL (LABEL_ID),
+ VERSION_ID int NOT NULL,
+ LABEL_ID int NOT NULL,
+ CONSTRAINT FK_VERSION_LABELS
+ FOREIGN KEY (VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID),
+ FOREIGN KEY (LABEL_ID) REFERENCES LABEL (LABEL_ID),
UNIQUE (VERSION_ID, LABEL_ID)
);
-
CREATE TABLE VERSION_CONTENT (
- VERSION_ID bigint PRIMARY KEY,
- CONTENT longvarbinary NOT NULL,
- CONSTRAINT FK_VC_VERSION_ID
- FOREIGN KEY (VERSION_ID)
- REFERENCES VERSION_HISTORY (VERSION_ID)
+ VERSION_ID int PRIMARY KEY,
+ CONTENT longvarbinary NOT NULL,
+ CONSTRAINT FK_VERSION_CONTENT
+ FOREIGN KEY (VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID)
);
-
CREATE TABLE PROPERTIES (
- VERSION_ID bigint NOT NULL,
- PROPERTY_NAMESPACE varchar(50) NOT NULL,
- PROPERTY_NAME varchar(50) NOT NULL,
- PROPERTY_VALUE varchar(255) NOT NULL,
- PROPERTY_TYPE varchar(50) NOT NULL,
- IS_PROTECTED bit NOT NULL,
- CONSTRAINT FK_VC_VERSION_ID
- FOREIGN KEY (VERSION_ID)
- REFERENCES VERSION_HISTORY (VERSION_ID),
+ VERSION_ID int NOT NULL,
+ PROPERTY_NAMESPACE varchar(50) NOT NULL,
+ PROPERTY_NAME varchar(50) NOT NULL,
+ PROPERTY_VALUE varchar(255) NOT NULL,
+ PROPERTY_TYPE varchar(50) NOT NULL,
+ IS_PROTECTED bit NOT NULL,
+ CONSTRAINT FK_PROPERTIES
+ FOREIGN KEY (VERSION_ID)
+ REFERENCES VERSION_HISTORY (VERSION_ID),
UNIQUE (VERSION_ID, PROPERTY_NAMESPACE, PROPERTY_NAME)
);
CREATE TABLE PERMISSIONS (
- OBJECT_ID bigint NOT NULL,
- SUBJECT_ID bigint NOT NULL,
- ACTION_ID bigint NOT NULL,
+ OBJECT_ID int NOT NULL,
+ SUBJECT_ID int NOT NULL,
+ ACTION_ID int NOT NULL,
VERSION_NO VARCHAR(20),
- IS_INHERITABLE bit NOT NULL,
- IS_NEGATIVE bit NOT NULL,
- CONSTRAINT FK_VC_VERSION_ID
- FOREIGN KEY (OBJECT_ID) REFERENCES URI (URI_ID),
- FOREIGN KEY (SUBJECT_ID) REFERENCES URI (URI_ID),
- FOREIGN KEY (ACTION_ID) REFERENCES URI (URI_ID),
+ IS_INHERITABLE bit NOT NULL,
+ IS_NEGATIVE bit NOT NULL,
+ CONSTRAINT FK_PERMISSIONS
+ FOREIGN KEY (OBJECT_ID) REFERENCES URI (URI_ID),
+ FOREIGN KEY (SUBJECT_ID) REFERENCES URI (URI_ID),
+ FOREIGN KEY (ACTION_ID) REFERENCES URI (URI_ID),
UNIQUE (OBJECT_ID, SUBJECT_ID, ACTION_ID)
-);
\ No newline at end of file
+);
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>