In-Portal Issue Tracker

Welcome to the In-Portal Open Source CMS Issue Tracker! This is a central management / tracking tool for all types of tasks / issues / bugs for the In-Portal Project. Before reporting any issues, please make sure to read the Guide into Issue Tracker and How to Properly Test and Report Bugs!

Viewing Issue Simple Details Jump to Notes ] Wiki ]  Related Changesets ] View Advanced ] Issue History ] Print ]
ID Category Type Reproducibility Date Submitted Last Update
0001011 [In-Portal CMS] Database bug report always 2011-03-11 10:58 2012-07-25 05:32
Reporter Dmitry View Status public Project Name In-Portal CMS
Assigned To alex Developer
Priority minor Resolution fixed Fixed in Version 5.2.0-B1
Status closed Product Version 5.1.2-B2 Target Version 5.2.0
Time EstimateNo estimate
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
Additional Information
Tags No tags attached.
Reference https://groups.google.com/d/topic/in-portal-dev/IOtkQI-oiis/discussion
Change Log Message Renamed Tables for Core
Estimate Points 3
Attached Files patch file icon mass_table_renaming_core.patch [^] (301,982 bytes) 2012-01-06 11:15
patch file icon mass_table_renaming_modules.patch [^] (300,649 bytes) 2012-01-06 14:33
patch file icon mass_table_renaming_themes.patch [^] (56,378 bytes) 2012-01-06 14:35 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
related to 0001006closed (5.1.2)Dmitry Delete Deprecated Code and Tables 
related to 0001153active (Icebox) Minimizing In-Portal CORE 

-  Notes
User avatar (0004391)
alex (manager)
2012-01-06 04:12

Used this "TableName(\s|[^\w]|$)" regular expression to find all table usages.
User avatar (0004397)
alex (manager)
2012-01-06 14:35

Will test all together later.
User avatar (0004398)
alex (manager)
2012-01-06 14:38

Fix committed to 5.2.x branch. Commit Message:

Fixes 0001011: Review and Rename Table Names in CORE
User avatar (0004997)
alex (manager)
2012-07-25 05:32

Since 5.2.0 version was released.

- Related Changesets
In-Portal CMS: 5.2.x r15012
Timestamp: 2012-01-06 14:38:49
Author: alex
Details ] Diff ]
Fixes 0001011: Review and Rename Table Names in CORE
mod - /in-portal/branches/5.2.x/core/install/install_data.sql Diff ] File ]
mod - /in-portal/branches/5.2.x/core/install/install_schema.sql Diff ] File ]
mod - /in-portal/branches/5.2.x/core/install/install_toolkit.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/install/remove_schema.sql Diff ] File ]
mod - /in-portal/branches/5.2.x/core/install/steps_db.xml Diff ] File ]
mod - /in-portal/branches/5.2.x/core/install/upgrades.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/install/upgrades.sql Diff ] File ]
mod - /in-portal/branches/5.2.x/core/install/utf.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/install.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/kernel/application.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/kernel/db/cat_dbitem.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/kernel/db/cat_event_handler.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/kernel/db/cat_tag_processor.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/kernel/languages/phrases_cache.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/kernel/managers/cache_manager.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/kernel/managers/rewrite_url_processor.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/kernel/nparser/template_cache.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/kernel/processors/main_processor.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/kernel/session/inp_session_storage.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/kernel/session/session.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/kernel/session/session_storage.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/kernel/utility/debugger.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/kernel/utility/temp_handler.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/admin/admin_events_handler.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/ban_rules/ban_rules_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/categories/cache_updater.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/categories/categories_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/categories/categories_event_handler.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/categories/categories_tag_processor.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/category_items/category_items_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/config_search/config_search_event_handler.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/configuration/configuration_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/custom_data/custom_data_event_handler.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/custom_fields/custom_fields_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/email_events/email_events_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/email_events/email_events_event_handler.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/favorites/favorites_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/fck/fck_eh.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/files/files_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/forms/drafts/drafts_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/forms/submission_log/submission_log_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/general/general_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/groups/groups_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/groups/groups_event_handler.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/helpers/ajax_form_helper.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/helpers/cat_dbitem_export_helper.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/helpers/category_helper.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/helpers/count_helper.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/helpers/file_helper.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/helpers/image_helper.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/helpers/language_import_helper.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/helpers/mailing_list_helper.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/helpers/menu_helper.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/helpers/mod_rewrite_helper.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/helpers/page_helper.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/helpers/permissions_helper.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/helpers/rating_helper.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/helpers/recursive_helper.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/helpers/skin_helper.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/helpers/themes_helper.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/helpers/user_helper.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/images/image_event_handler.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/images/images_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/languages/languages_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/languages/languages_event_handler.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/languages/languages_item.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/logs/change_logs/change_logs_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/logs/search_logs/search_logs_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/logs/session_logs/session_logs_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/mailing_lists/mailing_lists_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/page_revisions/page_revisions_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/permission_types/permission_types_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/permissions/permissions_tag_processor.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/phrases/phrases_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/promo_block_groups/promo_block_group_eh.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/promo_block_groups/promo_block_groups_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/promo_blocks/promo_block_eh.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/related_searches/related_searches_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/relationship/relationship_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/reviews/reviews_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/site_domains/site_domains_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/skins/skins_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/spam_reports/spam_reports_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/structure/structure_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/themes/themes_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/translator/translator_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/user_groups/user_groups_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/user_groups/user_groups_eh.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/user_profile/user_profile_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/user_profile/user_profile_tp.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/users/users_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/users/users_event_handler.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/users/users_item.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/users/users_tag_processor.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/visits/visits_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/tools/show_cache.php Diff ] File ]
Modules :: In-News: 5.2.x r15011
Timestamp: 2012-01-06 14:38:17
Author: alex
Details ] Diff ]
Bug 0001011: Review and Rename Table Names in CORE
mod - /modules/in-news/branches/5.2.x/install/install_data.sql Diff ] File ]
mod - /modules/in-news/branches/5.2.x/install/upgrades.sql Diff ] File ]
mod - /modules/in-news/branches/5.2.x/units/articles/articles_config.php Diff ] File ]
Modules :: In-Link: 5.2.x r15010
Timestamp: 2012-01-06 14:38:07
Author: alex
Details ] Diff ]
Bug 0001011: Review and Rename Table Names in CORE
mod - /modules/in-link/branches/5.2.x/install/install_data.sql Diff ] File ]
mod - /modules/in-link/branches/5.2.x/install/upgrades.sql Diff ] File ]
mod - /modules/in-link/branches/5.2.x/units/link_validation/link_validation_config.php Diff ] File ]
mod - /modules/in-link/branches/5.2.x/units/links/links_config.php Diff ] File ]
mod - /modules/in-link/branches/5.2.x/units/listings/listings_config.php Diff ] File ]
Modules :: In-Commerce: 5.2.x r15009
Timestamp: 2012-01-06 14:37:54
Author: alex
Details ] Diff ]
Bug 0001011: Review and Rename Table Names in CORE
mod - /w/in-commerce/branches/5.2.x/install/install_data.sql Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/install/upgrades.sql Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/addresses/addresses_event_handler.php Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/affiliate_payments/affiliate_payments_config.php Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/affiliate_plans_items/affiliate_plans_items_config.php Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/affiliates/affiliates_config.php Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/coupon_items/coupon_items_config.php Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/coupons/coupons_config.php Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/currencies/currencies_config.php Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/discount_items/discount_items_config.php Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/discount_items/discount_items_event_handler.php Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/discounts/discounts_config.php Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/gateways/gw_classes/google_checkout.php Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/manufacturers/manufacturers_event_handler.php Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/orders/order_calculator.php Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/orders/orders_config.php Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/orders/orders_event_handler.php Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/payment_type/payment_type_tag_processor.php Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/pricing/pricing_event_handler.php Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/products/products_config.php Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/products/products_event_handler.php Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/products/products_tag_processor.php Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/reports/reports_event_handler.php Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/reports/reports_tag_processor.php Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/shipping/shipping_event_handler.php Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/shipping/shipping_tag_processor.php Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/shipping_quote_engines/shipping_quote_engine_event_handler.php Diff ] File ]
Modules :: In-Bulletin: 5.2.x r15008
Timestamp: 2012-01-06 14:37:30
Author: alex
Details ] Diff ]
Bug 0001011: Review and Rename Table Names in CORE
mod - /modules/in-bulletin/branches/5.2.x/install/install_data.sql Diff ] File ]
mod - /modules/in-bulletin/branches/5.2.x/install/upgrades.sql Diff ] File ]
mod - /modules/in-bulletin/branches/5.2.x/units/poll_comments/poll_comments_config.php Diff ] File ]
mod - /modules/in-bulletin/branches/5.2.x/units/posts/post_eh.php Diff ] File ]
mod - /modules/in-bulletin/branches/5.2.x/units/posts/post_tp.php Diff ] File ]
mod - /modules/in-bulletin/branches/5.2.x/units/posts/posts_config.php Diff ] File ]
mod - /modules/in-bulletin/branches/5.2.x/units/private_messages/private_messages_config.php Diff ] File ]
mod - /modules/in-bulletin/branches/5.2.x/units/topics/topics_config.php Diff ] File ]
Modules :: Custom: 1.2.x r15006
Timestamp: 2012-01-06 14:37:04
Author: alex
Details ] Diff ]
Bug 0001011: Review and Rename Table Names in CORE
mod - /modules/custom/branches/1.2.x/install/upgrades.sql Diff ] File ]
Themes :: Simple: 1.2.x r15005
Timestamp: 2012-01-06 14:36:48
Author: alex
Details ] Diff ]
Bug 0001011: Review and Rename Table Names in CORE
mod - /themes/simple/branches/1.2.x/_install/install_data.sql Diff ] File ]
Themes :: Modern-Store: 1.0.x r15004
Timestamp: 2012-01-06 14:36:37
Author: alex
Details ] Diff ]
Bug 0001011: Review and Rename Table Names in CORE
mod - /themes/modern-store/branches/1.0.x/_install/install_data.sql Diff ] File ]
Themes :: Default: 5.2.x r15003
Timestamp: 2012-01-06 14:36:26
Author: alex
Details ] Diff ]
Bug 0001011: Review and Rename Table Names in CORE
mod - /themes/default/branches/5.2.x/_install/install_data.sql Diff ] File ]
Themes :: Advanced: 1.2.x r15002
Timestamp: 2012-01-06 14:36:11
Author: alex
Details ] Diff ]
Bug 0001011: Review and Rename Table Names in CORE
mod - /themes/advanced/branches/1.2.x/_install/install_data.sql Diff ] File ]
mod - /themes/advanced/branches/1.2.x/in-bulletin/_install/install_data.sql Diff ] File ]
mod - /themes/advanced/branches/1.2.x/in-commerce/_install/install_data.sql Diff ] File ]
mod - /themes/advanced/branches/1.2.x/in-link/_install/install_data.sql Diff ] File ]
mod - /themes/advanced/branches/1.2.x/in-news/_install/install_data.sql Diff ] File ]

- 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 View Revisions
2012-01-06 04:12 alex Note Added: 0004391
2012-01-05 11:40 alex Description Updated View Revisions
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 View Revisions
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



Web Development by Intechnic
In-Portal Open Source CMS
In-Portal Open Source CMS
Copyright © 2000 - 2009 MantisBT Group

Powered by Mantis Bugtracker