Database field_data

I recently had a situation where I needed to know if a column was an auto incremented field.  I was using primary_key, but discovered that something can be primary_key and not auto increment ;-)

I have provided my own implementation from the mysql_result by putting it in MY_Model class and added this property:

PHP Code:

$F->auto_increment = strripos($field -> Extra, 'auto_increment') !== FALSE ? 1 : 0; 


It would be very helpful to have this become part of the standard field_data in a future version of CI.

You'll discover many more things like that in the future ... including that AUTO_INCREMENT is a MySQL-specific feature, and as such is not suitable for inclusion in the otherwise platform-agnostic DB layer that CodeIgniter has.