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

Designating a Primary Key

9 года 3 мес. назад #913 от Robert Garza
Robert Garza создал тему: Designating a Primary Key
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

Пожалуйста Войти или Регистрация, чтобы присоединиться к беседе.

9 года 3 мес. назад #919 от Walt Sorensen
Walt Sorensen ответил в теме 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. 
Спасибо сказали: Andres Maeso, Robert Garza

Пожалуйста Войти или Регистрация, чтобы присоединиться к беседе.

9 года 3 мес. назад #920 от Robert Garza
Robert Garza ответил в теме 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...

Пожалуйста Войти или Регистрация, чтобы присоединиться к беседе.

9 года 3 мес. назад #922 от Walt Sorensen
Walt Sorensen ответил в теме 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
Спасибо сказали: Andres Maeso, Robert Garza

Пожалуйста Войти или Регистрация, чтобы присоединиться к беседе.

Время создания страницы: 0.055 секунд
Работает на 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.