dirkv 01/08/31 15:14:31
Modified: src/doc howto-jdbcstore.xml
Log:
add create script for Cloudscape
tested by Jacob Lund
Revision Changes Path
1.6 +46 -0 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.5
retrieving revision 1.6
diff -u -r1.5 -r1.6
--- howto-jdbcstore.xml 2001/06/24 22:20:38 1.5
+++ howto-jdbcstore.xml 2001/08/31 22:14:31 1.6
@@ -320,6 +320,52 @@
</section>
+ <section name="Cloudscape">
+
+ <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), revisionnumber varchar(20),
+ 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 long varbinary);
+</pre>
+ </p>
+
+ </section>
+
<section name="Microsoft SQL Server">
<p>
