----- Message d'origine ----- De : "Dirk Verbeeck" <[EMAIL PROTECTED]> � : "Slide Developers List" <[EMAIL PROTECTED]> Envoy� : dimanche 18 novembre 2001 19:36 Objet : Re: PostgreSQL supported ! > > Great news, another DB supported > and a very good one > > Thanks for testing, > Dirk
Thanks JDBC ! and thanks for putting it in the Howto Jean-Philippe > > > > Jean-Philippe Courson wrote: > > > > Hi, > > > > PostgreSQL is able to store slide's content using oid data type for blobs. > > > > I have tested it and it works perfect. > > > > Folows the PostgreSQL database creation script (the Oracle one with just > > oid replacing blob) > > > > I think it would be a good thing to add it to the JDBC Store Howto. > > > > Jean-Philippe > > > > 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); > > > > -- > > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
