Feeling Lucky
?
[#4943] - Table definitions for #_contentitem_tag_map are different
- Closed
- 14 Apr 2015
- Medium
- Build: master
- # 4943
installation/sql//joomla.sql contains different definitions for a unique key. For MySQL it specifies type_id, content_item_id, tag_id. For both PostgreSQL it specifies type_alias, content_item_id, tag_id.
It is not difficult to make them the same, the question is which one is right?
Couldn't say from the usage of the table in Joomla, maybe the people from the SQL Performance had a look into this.
jissues-bot
- | Labels |
Added:
?
|
||
brianteeman
- | Category | ⇒ | SQL Tags |
| Status | New | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2015-04-14 23:52:25 |
we need to use the same pk key on all db's
in this case the mysql pk is the one