Is it approved of to use the id as a meaningful number? I have always assumed that you should not do this as, for example, once you have added number 1000 and deleted it (possibly by mistake) you cannot ever use this number again (without hacking). If you need a meaningful number then I would suggest adding a ticket_number field and controlling this by hand.
2009/4/6 Michael Satterwhite <[email protected]> > > Duggan Roberts wrote: > > Thank you very much. You are right about the id and that is sufficient > > for > > me to use as ticket id. Now just for personal know how, How can I change > > the > > id from numbering 1,2,3 to 1001, 1002, 1003? > > > > On Sun, Apr 5, 2009 at 1:16 PM, Michael Satterwhite < > > Either as a migration or as raw SQL, enter the following statement: > > Alter table <table-name> AUTO_INCREMENT = 1000; > > > -- > Posted via http://www.ruby-forum.com/. > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
