×
Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues
Designating a Primary Key
Robert Garza
New Member
Posts: 2
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
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.
Walt Sorensen
Senior Member
Posts: 54
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.
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.
Robert Garza
New Member
Posts: 2
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...
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.
Walt Sorensen
Senior Member
Posts: 54
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
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