dsavazzi 2004/11/13 07:02:28
Modified: src/conf/schema OracleSchema.sql
Log:
Changed some VARCHAR2 columns to size 4000
Revision Changes Path
1.2 +12 -12 jakarta-slide/src/conf/schema/OracleSchema.sql
Index: OracleSchema.sql
===================================================================
RCS file: /home/cvs/jakarta-slide/src/conf/schema/OracleSchema.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- OracleSchema.sql 13 May 2004 07:17:57 -0000 1.1
+++ OracleSchema.sql 13 Nov 2004 15:02:28 -0000 1.2
@@ -32,7 +32,7 @@
CREATE TABLE "URI" (
"URI_ID" NUMBER(10) NOT NULL,
- "URI_STRING" VARCHAR2(2500) NOT NULL,
+ "URI_STRING" VARCHAR2(4000) NOT NULL,
PRIMARY KEY("URI_ID"),
UNIQUE("URI_STRING")
) CACHE NOLOGGING;
@@ -48,7 +48,7 @@
CREATE TABLE "BINDING" (
"URI_ID" NUMBER(10) NOT NULL,
- "NAME" VARCHAR2(512) NOT NULL,
+ "NAME" VARCHAR2(4000) NOT NULL,
"CHILD_UURI_ID" NUMBER(10) NOT NULL,
PRIMARY KEY("URI_ID", "NAME", "CHILD_UURI_ID"),
FOREIGN KEY("URI_ID") REFERENCES "URI"("URI_ID"),
@@ -57,7 +57,7 @@
CREATE TABLE "PARENT_BINDING" (
"URI_ID" NUMBER(10) NOT NULL,
- "NAME" VARCHAR2(512) NOT NULL,
+ "NAME" VARCHAR2(4000) NOT NULL,
"PARENT_UURI_ID" NUMBER(10) NOT NULL,
PRIMARY KEY("URI_ID", "NAME", "PARENT_UURI_ID"),
FOREIGN KEY("URI_ID") REFERENCES "URI"("URI_ID"),
@@ -80,7 +80,7 @@
"EXPIRATION_DATE" NUMBER(14) NOT NULL,
"IS_INHERITABLE" NUMBER(1) NOT NULL,
"IS_EXCLUSIVE" NUMBER(1) NOT NULL,
- "OWNER" VARCHAR2(512),
+ "OWNER" VARCHAR2(4000),
PRIMARY KEY("LOCK_ID"),
FOREIGN KEY("LOCK_ID") REFERENCES "URI"("URI_ID"),
FOREIGN KEY("OBJECT_ID") REFERENCES "URI"("URI_ID"),
@@ -90,14 +90,14 @@
CREATE TABLE "BRANCH" (
"BRANCH_ID" NUMBER(10) NOT NULL,
- "BRANCH_STRING" VARCHAR2(512) NOT NULL,
+ "BRANCH_STRING" VARCHAR2(4000) NOT NULL,
PRIMARY KEY("BRANCH_ID"),
UNIQUE("BRANCH_STRING")
) CACHE NOLOGGING;
CREATE TABLE "LABEL" (
"LABEL_ID" NUMBER(10) NOT NULL,
- "LABEL_STRING" VARCHAR2(512) NOT NULL,
+ "LABEL_STRING" VARCHAR2(4000) NOT NULL,
PRIMARY KEY("LABEL_ID")
) CACHE NOLOGGING;
@@ -112,7 +112,7 @@
"VERSION_ID" NUMBER(10) NOT NULL,
"URI_ID" NUMBER(10) NOT NULL,
"BRANCH_ID" NUMBER(10) NOT NULL,
- "REVISION_NO" VARCHAR2(20) NOT NULL,
+ "REVISION_NO" VARCHAR2(255) NOT NULL,
PRIMARY KEY("VERSION_ID"),
UNIQUE("URI_ID", "BRANCH_ID", "REVISION_NO"),
FOREIGN KEY("URI_ID") REFERENCES "URI"("URI_ID"),
@@ -145,10 +145,10 @@
CREATE TABLE "PROPERTIES" (
"VERSION_ID" NUMBER(10) NOT NULL,
- "PROPERTY_NAMESPACE" VARCHAR2(50) NOT NULL,
- "PROPERTY_NAME" VARCHAR2(50) NOT NULL,
- "PROPERTY_VALUE" VARCHAR2(255),
- "PROPERTY_TYPE" VARCHAR2(50),
+ "PROPERTY_NAMESPACE" VARCHAR2(255) NOT NULL,
+ "PROPERTY_NAME" VARCHAR2(255) NOT NULL,
+ "PROPERTY_VALUE" VARCHAR2(4000),
+ "PROPERTY_TYPE" VARCHAR2(255),
"IS_PROTECTED" NUMBER(1) NOT NULL,
UNIQUE("VERSION_ID", "PROPERTY_NAMESPACE", "PROPERTY_NAME"),
FOREIGN KEY("VERSION_ID") REFERENCES "VERSION_HISTORY"("VERSION_ID")
@@ -158,7 +158,7 @@
"OBJECT_ID" NUMBER(10) NOT NULL,
"SUBJECT_ID" NUMBER(10) NOT NULL,
"ACTION_ID" NUMBER(10) NOT NULL,
- "VERSION_NO" VARCHAR2(20),
+ "VERSION_NO" VARCHAR2(255),
"IS_INHERITABLE" NUMBER(1) NOT NULL,
"IS_NEGATIVE" NUMBER(1) NOT NULL,
"SUCCESSION" NUMBER(10) NOT NULL,
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
