/
ResourceId field refactoring

ResourceId field refactoring

Imported From: http://groups.google.com/group/in-portal-dev/browse_thread/thread/c05f8b2e7d7a0574#

I propose to refactor implementation of ResourceId field. Now ResourceId field is unique for all database. We should add Prefix column, where ResourceId column is being used (not in main tables of course) and store ID of item instead of it's ResourceId (category item review system is using this for now using ItemId and ItemPrefix fields). This will be faster to query and use. For example we don't need additional database query to get actual item's ID by it's resource id.

Related Tasks

INP-528 - Getting issue details... STATUS