View Issue Details

IDProjectCategoryView StatusLast Update
0006895OXID eShop (all versions)4.01. Database handlingpublic2018-09-03 11:54
Reportersimon.runer 
PrioritynormalSeveritytweakReproducibilityalways
Status acknowledgedResolutionopen 
Product Version6.0.3 
Target VersionFixed in Version 
Summary0006895: Column OXTYPE missing in oxobject2group and misleading MySql comment
DescriptionThe comment on table oxobject2group says (https://github.com/OXID-eSales/oxideshop_ce/blob/master/source/Setup/Sql/database_schema.sql)
"Shows many-to-many relationship between users and groups" which is incorrect. There are stored also relationships between oxpayments and oxgroups and probably others.
As in other tables there should by a OXTYPE column to identify the related table.

TagsDatabase
ThemeNot defined
BrowserNot defined
PHP VersionNot defined
MySQL VersionNot defined

Activities

QA

2018-09-03 11:53

administrator   ~0012604

Also misleading is the comment for the attribute oxobjectid, which reads "User id".

[sp]