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

Designating a Primary Key

9 jaren 4 maanden geleden #913 door Robert Garza
Designating a Primary Key werd gestart door 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

Gelieve Inloggen of een account aanmaken om deel te nemen aan het gesprek.

9 jaren 4 maanden geleden #919 door Walt Sorensen
Beantwoord door Walt Sorensen in 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. 
De volgende gebruiker (s) zei dank u: Andres Maeso, Robert Garza

Gelieve Inloggen of een account aanmaken om deel te nemen aan het gesprek.

9 jaren 4 maanden geleden #920 door Robert Garza
Beantwoord door Robert Garza in 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...

Gelieve Inloggen of een account aanmaken om deel te nemen aan het gesprek.

9 jaren 4 maanden geleden #922 door Walt Sorensen
Beantwoord door Walt Sorensen in 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
De volgende gebruiker (s) zei dank u: Andres Maeso, Robert Garza

Gelieve Inloggen of een account aanmaken om deel te nemen aan het gesprek.

Tijd voor maken pagina: 0.072 seconden
Gemaakt door 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.