RE: Re: [viewvc-users] The root

On 01/17/2013 01:55 PM, C. Michael Pilato wrote:

> If I'm reading the schema correctly (founding in the 'make-database'
> script), though -- and that's a non-trivially-sized "if" -- the dependency
> chain ends there, and you could remove the offending row from "repositories"
> plus any rows in "tags" and "checkins" which refer to that repositoryid.

Unfortunately, I don't think it's quite that simple... it looks like many of the fields in the "checkins" table are references to the other tables.   For instance the "checkins" table has a "branchid" field, which must be a reference to the "branches" table.

That means I'd need to find all entries in the "checkins" table with a "repositoryid" for the 'XXX' repository and then from that set of results, find all "branchids" and remove them from the "branches" table.

Would need to do the same thing for each of the "people" (whoid), "dirs" (dirid), "files" (fileid) and "descs (descid) tables.

Then I'd also need to look for records in the checkouts table where the "repository" field matches 'XXX'.

------------------------------------------------------
http://viewvc.tigris.org/ds/viewMessage.do?dsForumId=4255&dsMessageId=3044494

To unsubscribe from this discussion, e-mail: [[email protected]].