I'm currently building project using bonfire and codeigniter framework, using bonfire is much easier to create some CRUD in my project. I'm using module builder to create the CRUD from my existing table in my database MySQL. But now i have a problem with primary key which i set from module builder. This is my problem:
For example, i have table called "bank" in my database, this table have structure like this :
nobank varchar(12),
name varchar(10)
i set the nobank as primary key, then i create the module called bank and set from this table, once build complete it show the table content.
this is the problem, i view the table content which have the nobank (for example) A001 , it showing correctly, but when i create new row, using create() to input to my table, the nobank i inputted didn't stored to the table, i didn't set the auto increment to nobank column, because auto increment didn't allow char. and if i set the primary key to another column, the nobank value is stored, how to fix this ?