Re: Official (unofficial?!) mySQL config SQL script MISTAKE!

[K.C. Baltz]

You should be referring to the official page,  
http://jakarta.apache.org/slide/howto-jdbcstore.html.   It only has a 
single create table for the permissions table and no 'permission' table. 

K.C.

Stuart MacPherson wrote:

Reformatted so you can read it better...

Anyone have any ideas?!



-----Original Message-----
From: Stuart MacPherson [mailto:[EMAIL PROTECTED] 
Sent: 31 July 2003 16:34
To: 'Slide Users Mailing List'
Subject: RE: Official (unofficial?!) mySQL config SQL script MISTAKE!



-----Original Message-----
From: Stuart MacPherson [mailto:[EMAIL PROTECTED] 
Sent: 31 July 2003 15:27
To: 'Slide Users Mailing List'
Subject: Official (unofficial?!) mySQL config SQL script MISTAKE!

Look at this SQL script I got from the unofficial FAQ site for configuring a
mySQL store. see anything wrong?!


It's trying to create the tablename 'permissions' twice. I assume that one
is meant to be 'permission' (singular!) but. which one?


Many thanks

stu





create database slide;

use slide;

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 );
create table revisioncontent(uri blob, xnumber varchar(20), content blob);

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


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



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