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:32 UTC
cvs commit: jakarta-slide/docs howto-jdbcstore.html
remm 01/03/05 22:27:32
Modified: docs howto-jdbcstore.html
Log:
- Add initialization scripts for mySQL and Oracle 8i, contributed by Jason Harrop and David McDonnell.
Revision Changes Path
1.8 +111 -13 jakarta-slide/docs/howto-jdbcstore.html
Index: howto-jdbcstore.html
===================================================================
RCS file: /home/cvs/jakarta-slide/docs/howto-jdbcstore.html,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -r1.7 -r1.8
--- howto-jdbcstore.html 2001/03/03 23:37:56 1.7
+++ howto-jdbcstore.html 2001/03/06 06:27:32 1.8
@@ -13,7 +13,7 @@
<a href="#Revision">Revision</a><br></small><small>
<a href="#Label">Label</a><br></small><small>
<a href="#Property">Property</a><br></small><small>
- <a href="#Revisioncontent">Revisioncontent</a><br></small><small><a href="#Hypersonic SQL">Hypersonic SQL</a><br></small><br><a name="Initialization"><h2>Initialization</h2></a><blockquote>
+ <a href="#Revisioncontent">Revisioncontent</a><br></small><small><a href="#Hypersonic SQL">Hypersonic SQL</a><br></small><small><a href="#mySQL">mySQL</a><br></small><small><a href="#Oracle 8i">Oracle 8i</a><br></small><br><a name="Initialization"><h2>Initialization</h2></a><blockquote>
<p>
On the first startup of the Store, it will attempt to automatically
@@ -188,35 +188,133 @@
<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>
<br></p>
+ </blockquote><a name="mySQL"><h2>mySQL</h2></a><blockquote>
+
+ <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>
+ <br></p>
+
+ </blockquote><a name="Oracle 8i"><h2>Oracle 8i</h2></a><blockquote>
+
+ <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>
+ <br></p>
+
</blockquote><br></td></tr><tr><td width="120" bgcolor="#ffffff"></td><td valign="top" width="11" height="11" bgcolor="#ffffff"></td><td valign="top" bgcolor="#ffffff"><img width="11" height="11" src="style/images/blank.gif"></td></tr><tr><td width="120" bgcolor="#ffffff"></td><td width="11" bgcolor="#ffffff"><img width="11" height="11" src="style/images/blank.gif"></td><td valign="top" bgcolor="#ffffff"></td></tr><tr><td width="120" bgcolor="#ffffff"></td><td valign="top" width="11" bgcolor="#ffffff"></td><td valign="top" bgcolor="#ffffff"><img width="11" height="11" src="style/images/blank.gif"></td></tr><tr><td width="120" bgcolor="#ffffff"></td><td width="11" bgcolor="#ffffff"> </td><td bgcolor="#ffffff"><small><hr><notice>
- $Revision: 1.7 $ $Author: remm $ $Date: 2001/03/03 23:37:56 $
+ $Revision: 1.8 $ $Author: remm $ $Date: 2001/03/06 06:27:32 $
</notice><br> <br></small><small><hr><notice>
Java, JDBC, JNDI, JTA, JMS, Sun, Sun Microsystems are trademarks
or registered trademarks of Sun Microsystems, Inc. in the United States