
create table objects(uri varchar(100) primary key, classname text);

create table children(uri varchar(100), childuri varchar(100));

create table links(link varchar(100), linkto varchar(100));

create table permissions(object varchar(100), revisionnumber varchar(20), 
  subject varchar(100), action varchar(100), inheritable int, negative int);

create table locks(id varchar(100), object varchar(100), subject varchar(100), type varchar(100), 
  expirationdate varchar(15), inheritable int, xexclusive int);

create table revisions(uri varchar(100) primary key, isversioned int, initialrevision varchar(10) );

create table workingrevision(uri varchar(100), baserevision varchar(20), xnumber 
  varchar(20) );

create table latestrevisions(uri varchar(100), branchname text, xnumber 
  varchar(20) );

create table branches(uri varchar(100), xnumber varchar(20), childnumber 
  varchar(20) );

create table revision(uri varchar(100), xnumber varchar(20), branchname text);

create table label(uri varchar(100), xnumber varchar(20), label text);

create table property(uri varchar(100), xnumber varchar(20), name text, value 
  text, namespace text, type varchar(100), protected int);

create table revisioncontent(uri varchar(100), xnumber varchar(20), content image);


