I would start the next review at 10001 so that the first review gets a fish trophy ;-)
Terry From: [email protected] [mailto:[email protected]] On Behalf Of Christian Hammond Sent: Tuesday, September 18, 2018 9:12 PM To: [email protected] Subject: Re: New Install - set starting review number? Hi Peter, What issues did you hit before? (Have we already talked about them? Apologies if we have..). We can generally help with relocation and upgrade issues under support contracts, in case you want to discuss that option. As for ID numbers, they're based on the next auto-incremented ID returned from the database. So what you can do is create a dummy entry in reviews_reviewrequest with ID, say, 9999, and then Review Board's next ID will be 10000. You can then delete the dummy entry so it's not sticking around. I'd recommend taking the time to go through every table from the old database and make sure there's a dummy entry at a higher ID in the new database, to basically reserve space in each table. That way, if you want to work with us later on getting the old data moved over to the newer version, we should be able to just merge the databases and keep all history in the new place. Christian On Tue, Sep 18, 2018 at 4:17 PM Peter Howard <[email protected]<mailto:[email protected]>> wrote: Dear all, I've just done a new ReviewBoard install (CentOS7, RB 2.5.17), given "issues" trying to transfer our existing (ancient) install. This means the old site is going to remain live indefinitely for historical purposes. What I would like to do with the new site is get review numbers in the new site to start from well above the last number in the old site, to make it clear at a glance which site holds the reivew. Is there an easy/straightforward way to do that? Thanks, PJH -- Supercharge your Review Board with Power Pack: https://www.reviewboard.org/powerpack/ Want us to host Review Board for you? Check out RBCommons: https://rbcommons.com/ Happy user? Let us know! https://www.reviewboard.org/users/ --- You received this message because you are subscribed to the Google Groups "Review Board Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- Christian Hammond President/CEO of Beanbag<https://www.beanbaginc.com/> Makers of Review Board<https://www.reviewboard.org/> -- Supercharge your Review Board with Power Pack: https://www.reviewboard.org/powerpack/ Want us to host Review Board for you? Check out RBCommons: https://rbcommons.com/ Happy user? Let us know! https://www.reviewboard.org/users/ --- You received this message because you are subscribed to the Google Groups "Review Board Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- Supercharge your Review Board with Power Pack: https://www.reviewboard.org/powerpack/ Want us to host Review Board for you? Check out RBCommons: https://rbcommons.com/ Happy user? Let us know! https://www.reviewboard.org/users/ --- You received this message because you are subscribed to the Google Groups "Review Board Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
