-----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]
