Change name of ID field in database

I wanna use default CI tools to work with database, but i also want to change name of ID field to something like - private_messages_ID - to make it easier to make Joins and other combined query...
Is there a way?

You will need to do this using phpMyAdmin or some other tool enter the sql.

Code:

ALTER TABLE `table_name` CHANGE `ID` `private_messages_ID` INT( 11 ) NOT NULL AUTO_INCREMENT

Change table_name to the name of your table.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )