History for DDL

??changed:
-
DDL for RelationalStorage (Interbase)

  Jim -- Does Interbase support Long Raw?
  
  Chris -- No

    Are you allowed more than one blob column per table? How expensive are they

  Chris -- yes.  I don't know how expensive they are...

  The DDL::

<pre>
/* Replace the CREATE DATABASE path argument with
the path and file you want to use for your
InterbaseStorage

$Id: InterbaseStorage.sql,v 1.1.1.1 2000/06/11 06:05:53 chrism Exp $
*/

CREATE DATABASE '/home/chrism/zope_storage.gdb';

create table zodb_data (
        z_oid           char(12) not null,
        z_serial        char(12) not null,
        z_pre           char(12) default '' not null,
        z_status        char(1) default '' not null,
        z_data          blob,
        z_datalen       integer default 0 not null,
        z_version       varchar(252) default '' not null,
        z_nv            char(12) default '' not null,
        z_dataserial    char(12) default '' not null,
        primary key (z_oid, z_serial)
);

create table zodb_trans (
        z_serial        char(12) not null primary key,
        z_status        char(1) default '' not null,
        z_user          varchar(255) default '' not null,
        z_desc          varchar(255) default '' not null,
        z_ext           blob
);

create table zodb_pack (
       z_oid           char(12) not null primary key,
       z_serial        char(12) default '' not null
);

create index ix_serial on zodb_data (z_serial);
create index ix_oid on zodb_data (z_oid);
create index ix_pre on zodb_data (z_pre);
create index ix_nv on zodb_data (z_nv);
create index ix_dataserial on zodb_data (z_dataserial);
create index ix_status on zodb_data (z_status);
create index ix_serstat on zodb_data (z_serial, z_status);
create index ix_serds on zodb_data (z_serial, z_dataserial);
</pre>