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

Designating a Primary Key

9 år 4 måneder siden #913 af Robert Garza
Designating a Primary Key blev oprettet af 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

Venligst Log på eller Opret en konto for at deltage i samtalen

9 år 4 måneder siden #919 af Walt Sorensen
Besvaret af Walt Sorensen på emne 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. 
Følgende bruger(e) sagde tak: Andres Maeso, Robert Garza

Venligst Log på eller Opret en konto for at deltage i samtalen

9 år 4 måneder siden #920 af Robert Garza
Besvaret af Robert Garza på emne 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...

Venligst Log på eller Opret en konto for at deltage i samtalen

9 år 4 måneder siden #922 af Walt Sorensen
Besvaret af Walt Sorensen på emne 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
Følgende bruger(e) sagde tak: Andres Maeso, Robert Garza

Venligst Log på eller Opret en konto for at deltage i samtalen

Tid til at oprette siden: 0.052 sekunder
Leveret af Kunena Forum

Vi we benytter cookies, så vi bedst muligt kan levere vores services. For mere information, se vores