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

[Stuart MacPherson <ap...@dsl.pipex.com>]

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

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

[Stuart MacPherson <ap...@dsl.pipex.com>]

-----Original Message-----
From: Stuart MacPherson [mailto:aprw00@dsl.pipex.com] 
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: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org