Hi!

I have a problem when I try to use scaffolding in one of my tables: it doesn’t appear any field to edit, and none of them has default value, so I have an error when I try to insert.

The table is this:

group_id INTEGER NOT NULL
user_id   INTEGER NOT NULL

and both fields are in the primary key (I imagine that that’s the reason they don’t appear).

Is this a bug or a feature???

Thank you.

A table should only have one primary key, and as far as I know, CI won’t show these field types as editable in Scaffolding.

Ok, so it’s a feature, in that case I can’t use scaffolding :(

The table only have one primary key (it’s THE primary key). If you are trying to say that the primary key should have only one field, IMHO I think that it’s wrong, at least in my experience.

I’ve always worked with DB2 for banking systems (some tables with more than 5 Billion records!!!), and you have to be really careful with the order of the fields, the size and the indexes: the best is to have just one index, that it’s the primary and unique key, the cluster index, and the search index, so you don’t need extra fields (ID), and you improve the performance in joins and most frequent selects (it’s very important the order of the fields in the index and the fields you use in the where clause).

Thank you.