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

Designating a Primary Key

9 lata 4 miesiąc temu #913 przez Robert Garza
Designating a Primary Key was created by 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

Proszę Zaloguj lub Zarejestruj się, aby dołączyć do konwersacji.

9 lata 4 miesiąc temu #919 przez Walt Sorensen
Replied by Walt Sorensen on topic 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. 
Za tę wiadomość podziękował(a): Andres Maeso, Robert Garza

Proszę Zaloguj lub Zarejestruj się, aby dołączyć do konwersacji.

9 lata 4 miesiąc temu #920 przez Robert Garza
Replied by Robert Garza on topic 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...

Proszę Zaloguj lub Zarejestruj się, aby dołączyć do konwersacji.

9 lata 4 miesiąc temu #922 przez Walt Sorensen
Replied by Walt Sorensen on topic 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
Za tę wiadomość podziękował(a): Andres Maeso, Robert Garza

Proszę Zaloguj lub Zarejestruj się, aby dołączyć do konwersacji.

Czas generowania strony: 0.053 s.
Zasilane przez Forum Kunena

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.