Hi Christian, Thanks for the fast response. I haven't tried upgrading things. I guess I could try that, but I got the impression from somewhere that it would be difficult to do so from the early version that we are currently running. If you think it is worth trying, then that is probably the ideal route.
cheers, jon On Fri, Aug 20, 2010 at 8:16 PM, Christian Hammond <chip...@chipx86.com>wrote: > Hi Jon, > > Your plan to use ALTER TABLE should work. review_request_id just holds the > current ID. That's what should be auto_increment. I think so long as you do > that, you'll see the review request ID number you expect. > > By the way, what problems did you hit with upgrading? > > Christian > > -- > Christian Hammond - chip...@chipx86.com > Review Board - http://www.reviewboard.org > VMware, Inc. - http://www.vmware.com > > > On Fri, Aug 20, 2010 at 5:47 PM, jon <latch...@gmail.com> wrote: > >> Apologies if this has been covered before, google didn't seem to have >> an obvious answer. Is it possible to set a starting review # for a >> clean install? >> >> The issue is that we have a pre-1.0 installation that has been in use >> for awhile now. Instead of trying to figure out how to upgrade the >> database, I've just created a fresh new installation (of 1.5rc1) on a >> fresh new server and we are just going to consider the previous >> version effectively read-only. >> >> But, on the new server, I'd like to start the review number +1 higher >> than the old server so that we don't have conflicting numbers in svn >> commit messages. >> >> I see that reviews_review.id is auto_increment. I know that I can do: >> "ALTER TABLE reviews_review AUTO_INCREMENT = 100;", but I also see a >> 'review_request_id' column. What is that used for? Do you see any >> other issues with this approach? >> >> thanks, >> >> jon >> >> -- >> Want to help the Review Board project? Donate today at >> http://www.reviewboard.org/donate/ >> Happy user? Let us know at http://www.reviewboard.org/users/ >> -~----------~----~----~----~------~----~------~--~--- >> To unsubscribe from this group, send email to >> reviewboard+unsubscr...@googlegroups.com<reviewboard%2bunsubscr...@googlegroups.com> >> For more options, visit this group at >> http://groups.google.com/group/reviewboard?hl=en > > > -- > Want to help the Review Board project? Donate today at > http://www.reviewboard.org/donate/ > Happy user? Let us know at http://www.reviewboard.org/users/ > -~----------~----~----~----~------~----~------~--~--- > To unsubscribe from this group, send email to > reviewboard+unsubscr...@googlegroups.com<reviewboard%2bunsubscr...@googlegroups.com> > For more options, visit this group at > http://groups.google.com/group/reviewboard?hl=en -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ Happy user? Let us know at http://www.reviewboard.org/users/ -~----------~----~----~----~------~----~------~--~--- To unsubscribe from this group, send email to reviewboard+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en
