Remy Maucherat wrote:
>
> Note : If someone could contribute SQL scripts for the database creation on
> DBs other than hSQL, I would appreciate it. Thanks !
>
MySQL:
#drop database myDB;
create database myDB;
use myDB;
create table objects(uri blob not null, primary key uriIndex (uri(255)),
classname blob);
create table children(uri blob, childuri blob);
create table links(link blob, linkto blob);
create table permissions(object blob, subject blob, action blob,
inheritable int, negative int);
create table locks(id blob, object blob, subject blob, type blob,
expirationdate varchar(15), inheritable int, xexclusive int);
create table revisions(uri blob not null, primary key uriIndex
(uri(255)), isversioned int, initialrevision varchar(10) );
create table workingrevision(uri blob, baserevision varchar(20), xnumber
varchar(20) );
create table latestrevisions(uri blob, branchname blob, xnumber
varchar(20) );
create table branches(uri blob, xnumber varchar(20), childnumber
varchar(20) );
create table revision(uri blob, xnumber varchar(20), branchname blob );
create table label(uri blob, xnumber varchar(20), label blob );
create table property(uri blob, xnumber varchar(20), name blob, value
blob, namespace blob, type varchar(100), protected int );
