Hi James,

If you want the counter to be #1, you'll have to do some stuff in SQL to
reset auto_increment.

I'd start by going into the admin UI -> Database -> Review Requests,
selecting all, and deleting everything. That should also delete the
associated diffs, file attachments, etc. (If not, you can delete those
separately).

Then, to get back to square one, you can open your MySQL (assuming MySQL)
console for the database and do:

    ALTER TABLE reviews_reviewrequest AUTO_INCREMENT = 1

If you care about the IDs for the other affected tables, you'll need to do
it there as well.

Another option is to just dump the database and edit the resulting SQL file.

This isn't a standard use case, so we have nothing to help with any of this.

Christian

-- 
Christian Hammond - chip...@chipx86.com
Review Board - http://www.reviewboard.org
Beanbag, Inc. - http://www.beanbaginc.com


On Wed, Dec 4, 2013 at 12:03 PM, James Short <shor...@gmail.com> wrote:

> Is there a way to reset the reviews in the database to 'state zero'?  I
> just setup our reviewboard and I've been doing a lot of testing using RBT
> to establish our teams workflow and I just want to wipe out all those fake
> reviews/comments/diffs/attachements and start from scratch with a new
> counter (next review being #1) but not start the database over and have to
> reconfigure everything.  Is there a way to do that with rb-site manage?
>
> Thanks
>
> --
> Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
> ---
> Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
> ---
> Happy user? Let us know at http://www.reviewboard.org/users/
> ---
> You received this message because you are subscribed to the Google Groups
> "reviewboard" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to reviewboard+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
---
Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
---
Happy user? Let us know at http://www.reviewboard.org/users/
--- 
You received this message because you are subscribed to the Google Groups 
"reviewboard" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to