You are not logged in Log in Join
You are here: Home » Members » jim » ZODB » DDL

Log in
Name

Password

 
 
FrontPage » RelationalStorage » RelationalStorageTableStructures »

DDL

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::

/* 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);