In-Portal Issue Tracker - In-Portal CMS
Viewing Issue Advanced Details
ID: Category: Type: Reproducibility: Date Submitted: Last Update:
1011 [In-Portal CMS] Database bug report always 2011-03-11 10:58 2012-07-25 05:32
Reporter: Dmitry Platform:  
Assigned To: alex OS:  
Priority: minor OS Version:  
Status: closed Product Version: 5.1.2-B2  
Product Build: Resolution: fixed  
 
ETA: none Fixed in Version: 5.2.0-B1  
Reference: https://groups.google.com/d/topic/in-portal-dev/IOtkQI-oiis/discussion
Change Log Message: Renamed Tables for Core
Estimate Points: 3
Summary: 0001011: Review and Rename Table Names in CORE
Description: As part of currently "Minimize In-Portal Core with ability to download/update Modules online discussion" ( https://groups.google.com/forum/#!topic/in-portal-dev/vuGnrVy25cA/discussion ) where we started to break In-Portal CORE on a smaller pieces reviewing it's Table Structure.

Incorrectly named Tables:

Agents => ScheduledSystemEvents
BanRules => UserBanRules
Cache => SystemCache
ConfigurationValues => SystemSettings
Category => Categories
CustomField => CustomFields
Drafts => FormSubmissionReplyDrafts
Events => EmailEvents
Favorites => UserFavorites (new change)
Images => CatalogImages (better name for a future)
ItemFiles => CatalogFiles (better name for a future)
ItemRating => CatalogRatings (better name for a future)
ItemReview => CatalogReviews (better name for a future)
Language => Languages
PermCache => CategoryPermissionsCache
PermissionConfig => CategoryPermissionsConfig
Phrase => LanguageLabels
PortalGroup => UserGroups
PersistantSessionData = UserPersistentSessionData
PortalUser => Users
PortalUserCustomData => UserCustomData
RelatedSearches => CategoryRelatedSearches
Relationship => CatalogRelationships
SearchLog => SearchLogs
SessionData => UserSessionData
SessionLogs => UserSessionLogs
Skins => AdminSkins
SubmissionLog => FormSubmissionReplies
Theme => Themes
UserGroup => UserGroupRelations
UserSession => UserSessions
Visits => UserVisits
Steps To Reproduce:
Additional Information:
Relationships
related to 0001006closed  (5.1.2)Dmitry Delete Deprecated Code and Tables 
related to 0001153active  (Icebox) Minimizing In-Portal CORE 
Attached Files: patch mass_table_renaming_core.patch (301,982) 2012-01-06 11:15
http://tracker.in-portal.org/file_download.php?file_id=1470&type=bug
patch mass_table_renaming_modules.patch (300,649) 2012-01-06 14:33
http://tracker.in-portal.org/file_download.php?file_id=1471&type=bug
patch mass_table_renaming_themes.patch (56,378) 2012-01-06 14:35
http://tracker.in-portal.org/file_download.php?file_id=1472&type=bug
Issue History
Date Modified Username Field Change
2012-07-25 05:32 alex Note Added: 0004997
2012-07-25 05:32 alex Status resolved => closed
2012-01-06 14:38 alex Note Added: 0004398
2012-01-06 14:38 alex Status reviewed and tested => resolved
2012-01-06 14:38 alex Fixed in Version => 5.2.0-B1
2012-01-06 14:38 alex Resolution open => fixed
2012-01-06 14:38 alex Assigned To !COMMUNITY => alex
2012-01-06 14:38 alex Changeset attached 5.2.x r15012
2012-01-06 14:38 alex Changeset attached 5.2.x r15011
2012-01-06 14:38 alex Changeset attached 5.2.x r15010
2012-01-06 14:37 alex Changeset attached 5.2.x r15009
2012-01-06 14:37 alex Changeset attached 5.2.x r15008
2012-01-06 14:37 alex Changeset attached 5.2.x r15007
2012-01-06 14:37 alex Changeset attached 1.2.x r15006
2012-01-06 14:36 alex Changeset attached 1.2.x r15005
2012-01-06 14:36 alex Changeset attached 1.0.x r15004
2012-01-06 14:36 alex Changeset attached 5.2.x r15003
2012-01-06 14:36 alex Changeset attached 1.2.x r15002
2012-01-06 14:35 alex Note Added: 0004397
2012-01-06 14:35 alex Status needs testing => reviewed and tested
2012-01-06 14:35 alex Time Estimate Removed 3 =>
2012-01-06 14:35 alex Assigned To => !COMMUNITY
2012-01-06 14:35 alex Developer => alex
2012-01-06 14:35 alex Status active => needs testing
2012-01-06 14:35 alex File Added: mass_table_renaming_themes.patch
2012-01-06 14:33 alex File Added: mass_table_renaming_modules.patch
2012-01-06 11:15 alex File Added: mass_table_renaming_core.patch
2012-01-06 11:14 alex Description Updated bug_revision_view_page.php?rev_id=959#r959
2012-01-06 04:12 alex Note Added: 0004391
2012-01-05 11:40 alex Description Updated bug_revision_view_page.php?rev_id=958#r958
2011-12-18 15:09 Dmitry Relationship added related to 0001153
2011-10-22 16:11 alex Relationship added related to 0001006
2011-10-22 05:39 alex Estimate Points => 3
2011-09-26 04:50 alex Time Estimate Added 3
2011-09-23 20:59 Dmitry Priority normal => minor
2011-03-14 14:54 Dmitry Description Updated bug_revision_view_page.php?rev_id=700#r700
2011-03-11 10:58 Dmitry New Issue
2011-03-11 10:58 Dmitry Reference => https://groups.google.com/d/topic/in-portal-dev/IOtkQI-oiis/discussion
2011-03-11 10:58 Dmitry Change Log Message => Renamed Tables for Core

Notes
(0004391)
alex   
2012-01-06 04:12   
Used this "TableName(\s|[^\w]|$)" regular expression to find all table usages.
(0004397)
alex   
2012-01-06 14:35   
Will test all together later.
(0004398)
alex   
2012-01-06 14:38   
Fix committed to 5.2.x branch. Commit Message:

Fixes 0001011: Review and Rename Table Names in CORE
(0004997)
alex   
2012-07-25 05:32   
Since 5.2.0 version was released.