Error in the HSQLDB schema

[Jean-Baptiste Lièvremont]

There is a missing parenthesis at the end of the first statement of the 
HSQLDB Schema ( from 
http://www.java-internals.com/code/slide/docs/howto-jdbcstore.html). The 
correct schema is:

create table objects(uri varchar(65536) primary key, classname varchar(4096));
create table children(uri varchar(65536), childuri varchar(65536));
create table links(link varchar(65536), linkto varchar(65536));
create table permissions(object varchar(65536), revisionnumber varchar(20), 
 subject varchar(65536), action varchar(65536), inheritable int, 
 negative int);

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

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

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

create table latestrevisions(uri varchar(65536), 
 branchname varchar(4096), xnumber varchar(20));

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

create table revision(uri varchar(65536), xnumber varchar(20), 
 branchname varchar(4096));

create table label(uri varchar(65536), xnumber varchar(20), 
 label varchar(4096));

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

create table revisioncontent(uri varchar(65536), xnumber varchar(20), 
 content longvarbinary);

Regards
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]