View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001653 | OXID eShop (all versions) | 4.07. Source code, Test | public | 2010-02-12 18:29 | 2012-12-10 13:45 |
| Reporter | tomas_liubinas | Assigned To | |||
| Priority | high | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Fixed in Version | 4.3.0 revision 26948 | ||||
| Summary | 0001653: Database structure for EE and PE differs | ||||
| Description | While working on English demo data I took some time to go through all install sql files. And noticed some suspicious places when comparing CE and EE install SQLs: 1. Indexes in oxarticle table differs. 2. oxcountries table has oxshopid field 3. oxgbentries has no index on shopid field in ee. 4. different indexes on oxobject2attribute 5. oxobject2category has no indexes on shopincl and excl fields in ee. 6. indexes differ on oxobject2discount 7. oxobject2role in EE is not indexed at all. Correct? 8. OXBILLUSTIDSTATUS field in oxorder table 9. different indexes on oxuser table 10. [removed] 11. oxreviews in PE has oxshopid field (should be removed) 12. oxroles table is not indexed. 13. oxrolefields is not indexed. 14. Strange index on oxselectlists on oxtitle field in EE 15. OXUSTIDSTATUS field in oxuser table 16. OXWRONGLOGINS field in oxuser table 17. OXLNAME is indexed in oxuser table (ee) 18. oxnewssubscribed UNIQUE KEY in EE, in PE not. 19. oxvendor index differences 20. oxcache table is not indexed 21. oxobjectrights is not indexed 22. oxstates table differences | ||||
| Tags | No tags attached. | ||||
| Theme | |||||
| Browser | All | ||||
| PHP Version | any | ||||
| Database Version | any | ||||
