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 di...@apache.org on 2001/11/18 19:21:36 UTC
cvs commit: jakarta-slide/src/doc howto-jdbcstore.xml
dirkv 01/11/18 10:21:36
Modified: src/doc howto-jdbcstore.xml
Log:
- add PostgreSQL database creation script
tested by Jean-Philippe Courson
Revision Changes Path
1.8 +47 -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.7
retrieving revision 1.8
diff -u -r1.7 -r1.8
--- howto-jdbcstore.xml 2001/09/11 00:37:36 1.7
+++ howto-jdbcstore.xml 2001/11/18 18:21:35 1.8
@@ -282,6 +282,53 @@
</p>
</section>
+
+ <section name="PostgreSQL">
+
+ <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 oid);
+
+</pre>
+ </p>
+
+ </section>
<section name="Oracle 8i">
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>