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 re...@apache.org on 2001/03/06 07:27:01 UTC
cvs commit: jakarta-slide/src/doc howto-jdbcstore.xml
remm 01/03/05 22:27:01
Modified: src/doc howto-jdbcstore.xml
Log:
- Add initialization scripts for mySQL and Oracle 8i, contributed by Jason Harrop and David McDonnell.
Revision Changes Path
1.2 +114 -12 jakarta-slide/src/doc/howto-jdbcstore.xml
Index: howto-jdbcstore.xml
===================================================================
RCS file: /home/cvs/jakarta-slide/src/doc/howto-jdbcstore.xml,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- howto-jdbcstore.xml 2001/02/09 07:52:06 1.1
+++ howto-jdbcstore.xml 2001/03/06 06:27:00 1.2
@@ -185,30 +185,132 @@
<p>
<pre>
create table objects(uri varchar(65536) primary key, classname varchar(4096);
+
create table children(uri varchar(65536), childuri varchar(65536));
+
create table links(link varchar(65536), linkto varchar(65536));
-create table permissions(object varchar(65536), subject varchar(65536), \
+
+create table permissions(object varchar(65536), subject varchar(65536),
action varchar(65536), inheritable int, negative int);
-create table locks(id varchar(65536), object varchar(4096), \
- subject varchar(4096), type varchar(4096), \
+
+create table locks(id varchar(65536), object varchar(4096),
+ subject varchar(4096), type varchar(4096),
expirationdate varchar(15), inheritable int, xexclusive int);
-create table revisions(uri varchar(65536) primary key, \
+
+create table revisions(uri varchar(65536) primary key,
isversioned int, initialrevision varchar(10));
-create table workingrevision(uri varchar(65536), \
+
+create table workingrevision(uri varchar(65536),
baserevision varchar(20), xnumber varchar(20));
-create table latestrevisions(uri varchar(65536), \
+
+create table latestrevisions(uri varchar(65536),
branchname varchar(4096), xnumber varchar(20));
-create table branches(uri varchar(65536), xnumber varchar(20), \
+
+create table branches(uri varchar(65536), xnumber varchar(20),
childnumber varchar(20));
-create table revision(uri varchar(65536), xnumber varchar(20), \
+
+create table revision(uri varchar(65536), xnumber varchar(20),
branchname varchar(4096));
-create table label(uri varchar(65536), xnumber varchar(20), \
+
+create table label(uri varchar(65536), xnumber varchar(20),
label varchar(4096));
-create table property(uri varchar(65536), xnumber varchar(20), \
- name varchar(4096), value varchar(65536), namespace varchar(4096), \
+
+create table property(uri varchar(65536), xnumber varchar(20),
+ name varchar(4096), value varchar(65536), namespace varchar(4096),
type varchar(100), protected int);
-create table revisioncontent(uri varchar(65536), xnumber varchar(20), \
+
+create table revisioncontent(uri varchar(65536), xnumber varchar(20),
content longvarbinary);
+</pre>
+ </p>
+
+ </section>
+
+ <section title="mySQL">
+
+ <p>
+<pre>
+create database myDB;
+
+use myDB;
+
+create table objects(uri blob not null, primary key uriIndex (uri(255)),
+ classname blob);
+
+create table children(uri blob, childuri blob);
+
+create table links(link blob, linkto blob);
+
+create table permissions(object blob, subject blob, action blob,
+ inheritable int, negative int);
+
+create table locks(id blob, object blob, subject blob, type blob,
+ expirationdate varchar(15), inheritable int, xexclusive int);
+
+create table revisions(uri blob not null, primary key uriIndex
+ (uri(255)), isversioned int, initialrevision varchar(10) );
+
+create table workingrevision(uri blob, baserevision varchar(20), xnumber
+ varchar(20) );
+
+create table latestrevisions(uri blob, branchname blob, xnumber
+ varchar(20) );
+
+create table branches(uri blob, xnumber varchar(20), childnumber
+ varchar(20) );
+
+create table revision(uri blob, xnumber varchar(20), branchname blob );
+
+create table label(uri blob, xnumber varchar(20), label blob );
+
+create table property(uri blob, xnumber varchar(20), name blob, value
+ blob, namespace blob, type varchar(100), protected int );
+</pre>
+ </p>
+
+ </section>
+
+ <section title="Oracle 8i">
+
+ <p>
+<pre>
+create table objects(uri varchar(3200) primary key, classname varchar(4000));
+
+create table children(uri varchar(4000), childuri varchar(4000));
+
+create table links(link varchar(4000), linkto varchar(4000));
+
+create table permissions(object varchar(4000), subject varchar(4000),
+ action varchar(4000), inheritable int, negative int);
+
+create table locks(id varchar(4000), object varchar(4000),
+ subject varchar(4000), type varchar(4000),
+ expirationdate varchar(15), inheritable int, xexclusive int);
+
+create table revisions(uri varchar(3200) primary key,
+ isversioned int, initialrevision varchar(10));
+
+create table workingrevision(uri varchar(4000),
+ baserevision varchar(20), xnumber varchar(20));
+
+create table latestrevisions(uri varchar(4000),
+ branchname varchar(4000), xnumber varchar(20));
+
+create table branches(uri varchar(4000), xnumber varchar(20),
+ childnumber varchar(20));
+
+create table revision(uri varchar(4000), xnumber varchar(20),
+ branchname varchar(4000));
+
+create table label(uri varchar(4000), xnumber varchar(20),
+ label varchar(4000));
+
+create table property(uri varchar(4000), xnumber varchar(20),
+ name varchar(4000), value varchar(4000), namespace varchar(4000),
+ type varchar(100), protected int);
+
+create table revisioncontent(uri varchar(4000), xnumber varchar(20),
+ content blob);
</pre>
</p>