Auto_increment question?


#1

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


#2

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


#3

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 S. <


#4

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 S. <

Either as a migration or as raw SQL, enter the following statement:

Alter table AUTO_INCREMENT = 1000;


#5

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 S. removed_email_address@domain.invalid