Forum: Ruby on Rails auto_increment question???

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
69624563bf1db893866f851edd6e06a4?d=identicon&s=25 kingduggan (Guest)
on 2009-04-05 18:39
(Received via mailing list)
Hello All,

So I am new to rails and the first project I am creating is a
ticketing system to log customer support. All I am trying to do is
have the primary id of each new ticket auto increment like ticket id
1001, 1002, 1003, ect. and display the ticket id in the show tickets.

I am confused because I'm not sure if this would be created doing a
migration or in the model tickets after the migration has been done??

Any help would be great.

Thanks,

Duggan
9e6d05909dc733af570faadce1392e67?d=identicon&s=25 Michael Satterwhite (msatterwhite)
on 2009-04-05 20:16
kingduggan wrote:
> Hello All,
>
> So I am new to rails and the first project I am creating is a
> ticketing system to log customer support. All I am trying to do is
> have the primary id of each new ticket auto increment like ticket id
> 1001, 1002, 1003, ect. and display the ticket id in the show tickets.
>
> I am confused because I'm not sure if this would be created doing a
> migration or in the model tickets after the migration has been done??
>
> Any help would be great.

Unless I'm not understanding the question, you already have this.

With ActiveRecord, (by default) every record has an id that will be
unique. You don't have to do anything to get it. While you can override
it, every table has a field named 'id'. This will be incremented and
maintained by the system. In MySQL it will be an 'auto_increment' field
and defined as the primary key.

---Michael
69624563bf1db893866f851edd6e06a4?d=identicon&s=25 Duggan Roberts (Guest)
on 2009-04-06 17:18
(Received via mailing list)
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 <
9e6d05909dc733af570faadce1392e67?d=identicon&s=25 Michael Satterwhite (msatterwhite)
on 2009-04-06 18:04
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;
5f94b9b346c2aa648a80bc259978e5bc?d=identicon&s=25 Colin Law (Guest)
on 2009-04-06 18:29
(Received via mailing list)
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 <rails-mailing-list@andreas-s.net>
This topic is locked and can not be replied to.