I don't think there is any 'should' about it... why then is there a link from the 'official' pages to the unofficial pages, if they did not believe the information held within was wholeheartedly correct?
I don't feel I am wrong to be looking at the unofficial FAQ if it is 'authorised' (if not officiated) by way of being linked by an apache group page; whoever wrote the page needs to change it. In the meantime, I will look at the link you supplied... Many thanks, Stuart -----Original Message----- From: K.C. Baltz [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 16:45 To: Slide Users Mailing List Subject: Re: Official (unofficial?!) mySQL config SQL script MISTAKE! 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
