/
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.