× Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues

Designating a Primary Key

pred 9 rokmi 3 mesiacmi #913 od Robert Garza
Designating a Primary Key bolo vytvorené Robert Garza
I have imported a SQL Script into Component Creator but how do I know that the fields I created to be primary keys are actually primary keys.

Or...how do I designate a primary key in an imported table?

Am I stuck using "id" as the only field name for a primary key?


Thanks

Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.

pred 9 rokmi 3 mesiacmi #919 od Walt Sorensen
Odpoveď od Walt Sorensen na tému Designating a Primary Key
Generally speaking when working with Joomla components you will want to use `id` as your table's unique primary key field.
Without getting into a lot of explanation as to why, or identifying exceptions to this rule of thumb; I would say that you will likely save yourself from a lot of headaches by sticking with this general convention. 
Nasledujúci užívateľ(ia) povedali ďakujem: Andres Maeso, Robert Garza

Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.

pred 9 rokmi 3 mesiacmi #920 od Robert Garza
Odpoveď od Robert Garza na tému Designating a Primary Key
Thanks!!  Also, just wondering....

Are there any other preferred names for other fields/columns - created_by, active, checked_out_by, ..etc...

Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.

pred 9 rokmi 3 mesiacmi #922 od Walt Sorensen
Odpoveď od Walt Sorensen na tému Designating a Primary Key
Yes there are "reserved" field names for the table

There is some information in the JTable tutorial docs.joomla.org/Using_the_JTable_class
(The tutorial does need some technical review, but will give you some good general direction)

There is also a way to specify custom names for fields documented in the API api.joomla.org/cms-3/classes/JTable.html
Nasledujúci užívateľ(ia) povedali ďakujem: Andres Maeso, Robert Garza

Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.

Čas vytvorenia stránky: 0.049 sekúnd
Funguje na Kunena fórum

We use cookies so that you can place orders and we can provide a better service. You can control the use of cookies at the individual browser level. If you reject cookies, you may still use our website, but your ability to use some features or areas of our website may be limited.