Schema Renaming: Categories to Topics & Chatbots to Domains

[coderabbitai]

Overview

This issue tracks the schema renaming changes required across the codebase:

Database Schema Changes (Hasura)

Table Renames

• Rename 'categories' to 'topics'
• Rename 'chatbot' related tables to 'domain'
• Update foreign key constraints

New Structure

• Domains (previously Chatbots)
  • Categories (context-dependent)
  • Subcategories (context-dependent)
  • Tags (for filtering)

Frontend Updates

Route Updates

• ./apps/masterbots.ai/app/(browse)/[category]/[threadId]/page.tsx
• ./apps/masterbots.ai/app/(browse)/[category]/[threadId]/sitemap.ts
• ./apps/masterbots.ai/app/(browse)/[category]/page.tsx
• ./apps/masterbots.ai/app/(browse)/[category]/sitemap.ts
• ./apps/masterbots.ai/app/(browse)/layout.tsx
• ./apps/masterbots.ai/app/(browse)/page.tsx
• ./apps/masterbots.ai/app/(browse)/sitemap.ts
• ./apps/masterbots.ai/app/actions/ai-executers.ts
• ./apps/masterbots.ai/app/actions/ai-main-call.ts
• ./apps/masterbots.ai/app/actions/dub-co.ts
• ./apps/masterbots.ai/app/actions/index.ts
• ./apps/masterbots.ai/app/actions/subscriptions.ts
• ./apps/masterbots.ai/app/api/admin/admin-actions.ts
• ./apps/masterbots.ai/app/api/admin/route.ts
• ./apps/masterbots.ai/app/api/auth/[...nextauth]/route.ts
• ./apps/masterbots.ai/app/api/auth/forgot-password/route.ts
• ./apps/masterbots.ai/app/api/auth/reset-password/route.ts
• ./apps/masterbots.ai/app/api/auth/signup/route.ts
• ./apps/masterbots.ai/app/api/auth/verify-email/route.ts
• ./apps/masterbots.ai/app/api/chat/models/models.ts
• ./apps/masterbots.ai/app/api/chat/route.ts
• ./apps/masterbots.ai/app/api/cron/unverified-users/route.ts
• ./apps/masterbots.ai/app/api/og/edge-client.ts
• ./apps/masterbots.ai/app/api/og/route.tsx
• ./apps/masterbots.ai/app/api/payment/intent/route.tsx
• ./apps/masterbots.ai/app/api/payment/plans/route.tsx
• ./apps/masterbots.ai/app/api/payment/subscription/route.tsx
• ./apps/masterbots.ai/app/api/payment/sumarize/route.tsx
• ./apps/masterbots.ai/app/api/wordware/describe/route.ts
• ./apps/masterbots.ai/app/api/wordware/models/model.ts
• ./apps/masterbots.ai/app/api/wordware/run/route.ts
• ./apps/masterbots.ai/app/auth/forgot-password/page.tsx
• ./apps/masterbots.ai/app/auth/reset-password/page.tsx
• ./apps/masterbots.ai/app/auth/signin/page.tsx
• ./apps/masterbots.ai/app/auth/signup/page.tsx
• ./apps/masterbots.ai/app/auth/verify/[[...params]]/page.tsx
• ./apps/masterbots.ai/app/b/[id]/[threadId]/page.tsx
• ./apps/masterbots.ai/app/b/[id]/[threadId]/sitemap.ts
• ./apps/masterbots.ai/app/b/[id]/layout.tsx
• ./apps/masterbots.ai/app/b/[id]/page.tsx
• ./apps/masterbots.ai/app/b/[id]/sitemap.ts
• ./apps/masterbots.ai/app/c/[category]/[chatbot]/page.tsx
• ./apps/masterbots.ai/app/c/[category]/[chatbot]/sitemap.ts
• ./apps/masterbots.ai/app/c/[category]/page.tsx
• ./apps/masterbots.ai/app/c/[category]/sitemap.ts
• ./apps/masterbots.ai/app/c/layout.tsx
• ./apps/masterbots.ai/app/c/p/[category]/[expertise]/[chatbot]/page.tsx
• ./apps/masterbots.ai/app/c/p/[category]/[expertise]/[chatbot]/sitemap.ts
• ./apps/masterbots.ai/app/c/p/[category]/[expertise]/page.tsx
• ./apps/masterbots.ai/app/c/p/[category]/[expertise]/sitemap.ts
• ./apps/masterbots.ai/app/c/p/[category]/page.tsx
• ./apps/masterbots.ai/app/c/p/[category]/sitemap.ts
• ./apps/masterbots.ai/app/c/p/layout.tsx
• ./apps/masterbots.ai/app/c/p/page.tsx
• ./apps/masterbots.ai/app/c/p/sitemap.ts
• ./apps/masterbots.ai/app/c/page.tsx
• ./apps/masterbots.ai/app/c/sitemap.ts
• ./apps/masterbots.ai/app/error.tsx
• ./apps/masterbots.ai/app/layout.tsx
• ./apps/masterbots.ai/app/share/[id]/page.tsx
• ./apps/masterbots.ai/app/terms/layout.tsx
• ./apps/masterbots.ai/app/terms/page.tsx
• ./apps/masterbots.ai/app/u/[slug]/layout.tsx
• ./apps/masterbots.ai/app/u/[slug]/s/pref/page.tsx
• ./apps/masterbots.ai/app/u/[slug]/s/subs/page.tsx
• ./apps/masterbots.ai/app/u/[slug]/t/[category]/[chatbot]/[threadId]/page.tsx
• ./apps/masterbots.ai/app/u/[slug]/t/[category]/[chatbot]/page.tsx
• ./apps/masterbots.ai/app/u/[slug]/t/[category]/page.tsx
• ./apps/masterbots.ai/app/u/[slug]/t/page.tsx
• ./apps/masterbots.ai/app/u/[slug]/t/sitemap.ts
• ./apps/masterbots.ai/app/u/layout.tsx
• ./apps/masterbots.ai/app/u/s/subs/[intentid]/page.tsx
• ./apps/masterbots.ai/app/wordware/layout.tsx
• ./apps/masterbots.ai/app/wordware/page.tsx

Component Updates

• ./apps/masterbots.ai/components/auth/forgot-password-form.tsx
• ./apps/masterbots.ai/components/auth/reset-password-form.tsx
• ./apps/masterbots.ai/components/auth/signin-form.tsx
• ./apps/masterbots.ai/components/auth/signup-form.tsx
• ./apps/masterbots.ai/components/auth/user-login.tsx
• ./apps/masterbots.ai/components/layout/footer/footer-ct.tsx
• ./apps/masterbots.ai/components/layout/footer/footer.tsx
• ./apps/masterbots.ai/components/layout/header/header.tsx
• ./apps/masterbots.ai/components/layout/header/user-menu.tsx
• ./apps/masterbots.ai/components/layout/profile/hero.tsx
• ./apps/masterbots.ai/components/layout/profile/profile-page-sidebar.tsx
• ./apps/masterbots.ai/components/layout/providers.tsx
• ./apps/masterbots.ai/components/layout/sidebar/profile-sidebar.tsx
• ./apps/masterbots.ai/components/layout/sidebar/sidebar-actions.tsx
• ./apps/masterbots.ai/components/layout/sidebar/sidebar-category-general.tsx
• ./apps/masterbots.ai/components/layout/sidebar/sidebar-filter-input.tsx
• ./apps/masterbots.ai/components/layout/sidebar/sidebar-footer.tsx
• ./apps/masterbots.ai/components/layout/sidebar/sidebar-header.tsx
• ./apps/masterbots.ai/components/layout/sidebar/sidebar-item.tsx
• ./apps/masterbots.ai/components/layout/sidebar/sidebar-items.tsx
• ./apps/masterbots.ai/components/layout/sidebar/sidebar-link.tsx
• ./apps/masterbots.ai/components/layout/sidebar/sidebar-list.tsx
• ./apps/masterbots.ai/components/layout/sidebar/sidebar-mobile.tsx
• ./apps/masterbots.ai/components/layout/sidebar/sidebar-responsive.tsx
• ./apps/masterbots.ai/components/layout/sidebar/sidebar-toggle.tsx
• ./apps/masterbots.ai/components/layout/sidebar/sidebar.tsx
• ./apps/masterbots.ai/components/layout/tailwind-indicator.tsx
• ./apps/masterbots.ai/components/routes/browse/browse-accordion.tsx
• ./apps/masterbots.ai/components/routes/browse/browse-category-button.tsx
• ./apps/masterbots.ai/components/routes/browse/browse-category-tabs.tsx
• ./apps/masterbots.ai/components/routes/browse/browse-chat-message-list.tsx
• ./apps/masterbots.ai/components/routes/browse/browse-chat-message.tsx
• ./apps/masterbots.ai/components/routes/browse/browse-chat-messages.tsx
• ./apps/masterbots.ai/components/routes/browse/browse-chatbot-desktop-details.tsx
• ./apps/masterbots.ai/components/routes/browse/browse-chatbot-details.tsx
• ./apps/masterbots.ai/components/routes/browse/browse-chatbot-mobile-details.tsx
• ./apps/masterbots.ai/components/routes/browse/browse-list-item.tsx
• ./apps/masterbots.ai/components/routes/browse/browse-list.tsx
• ./apps/masterbots.ai/components/routes/browse/browse-search-input.tsx
• ./apps/masterbots.ai/components/routes/browse/browse-specific-thread-list.tsx
• ./apps/masterbots.ai/components/routes/browse/browse-thread.tsx
• ./apps/masterbots.ai/components/routes/browse/browse-user-details.tsx
• ./apps/masterbots.ai/components/routes/chat/admin-mode-approve.tsx
• ./apps/masterbots.ai/components/routes/chat/admin-mode-toggle.tsx
• ./apps/masterbots.ai/components/routes/chat/chat-accordion.tsx
• ./apps/masterbots.ai/components/routes/chat/chat-chatbot-details.tsx
• ./apps/masterbots.ai/components/routes/chat/chat-chatbot.tsx
• ./apps/masterbots.ai/components/routes/chat/chat-clickable-text.tsx
• ./apps/masterbots.ai/components/routes/chat/chat-combobox.tsx
• ./apps/masterbots.ai/components/routes/chat/chat-history.tsx
• ./apps/masterbots.ai/components/routes/chat/chat-layout-section.tsx
• ./apps/masterbots.ai/components/routes/chat/chat-list.tsx
• ./apps/masterbots.ai/components/routes/chat/chat-message-actions.tsx
• ./apps/masterbots.ai/components/routes/chat/chat-message.tsx
• ./apps/masterbots.ai/components/routes/chat/chat-onboarding-chatbot-mobile.tsx
• ./apps/masterbots.ai/components/routes/chat/chat-options.tsx
• ./apps/masterbots.ai/components/routes/chat/chat-panel-header.tsx
• ./apps/masterbots.ai/components/routes/chat/chat-panel.tsx
• ./apps/masterbots.ai/components/routes/chat/chat-scroll-anchor.tsx
• ./apps/masterbots.ai/components/routes/chat/chat-search-input.tsx
• ./apps/masterbots.ai/components/routes/chat/chat-selected-chatbot-mobile.tsx
• ./apps/masterbots.ai/components/routes/chat/chat-share-dialog.tsx
• ./apps/masterbots.ai/components/routes/chat/chat-thread-list-panel.tsx
• ./apps/masterbots.ai/components/routes/chat/chat.tsx
• ./apps/masterbots.ai/components/routes/chat/new-chat.tsx
• ./apps/masterbots.ai/components/routes/chat/onboarding-chatbot-details.tsx
• ./apps/masterbots.ai/components/routes/chat/onboarding-chatbot-mobile-details.tsx
• ./apps/masterbots.ai/components/routes/chat/prompt-form.tsx
• ./apps/masterbots.ai/components/routes/chat/share-button.tsx
• ./apps/masterbots.ai/components/routes/profile/user-card.tsx
• ./apps/masterbots.ai/components/routes/profile/user-thread-list.tsx
• ./apps/masterbots.ai/components/routes/subscription/checkout.tsx
• ./apps/masterbots.ai/components/routes/subscription/payment-information.tsx
• ./apps/masterbots.ai/components/routes/subscription/plan-card.tsx
• ./apps/masterbots.ai/components/routes/subscription/plans.tsx
• ./apps/masterbots.ai/components/routes/subscription/receipt.tsx
• ./apps/masterbots.ai/components/routes/subscription/stripe-element.tsx
• ./apps/masterbots.ai/components/routes/subscription/subscription.tsx
• ./apps/masterbots.ai/components/routes/subscription/succes-content.tsx
• ./apps/masterbots.ai/components/routes/thread/thread-component.tsx
• ./apps/masterbots.ai/components/routes/thread/thread-date-range-picker.tsx
• ./apps/masterbots.ai/components/routes/thread/thread-list.tsx
• ./apps/masterbots.ai/components/routes/thread/thread-panel.tsx
• ./apps/masterbots.ai/components/routes/thread/thread-popup.tsx
• ./apps/masterbots.ai/components/routes/thread/thread-publicity-switch.tsx
• ./apps/masterbots.ai/components/routes/thread/thread-share-link.tsx
• ./apps/masterbots.ai/components/routes/thread/user-thread-panel.tsx
• ./apps/masterbots.ai/components/shared/alert-dialogue.tsx
• ./apps/masterbots.ai/components/shared/button-scroll-to-bottom.tsx
• ./apps/masterbots.ai/components/shared/chatbot-avatar.tsx
• ./apps/masterbots.ai/components/shared/error-content.tsx
• ./apps/masterbots.ai/components/shared/external-link.tsx
• ./apps/masterbots.ai/components/shared/font-size-selector.tsx
• ./apps/masterbots.ai/components/shared/loading-state.tsx
• ./apps/masterbots.ai/components/shared/login-button.tsx
• ./apps/masterbots.ai/components/shared/markdown.tsx
• ./apps/masterbots.ai/components/shared/no-results-card.tsx
• ./apps/masterbots.ai/components/shared/og-bg-image.tsx
• ./apps/masterbots.ai/components/shared/og-image.tsx
• ./apps/masterbots.ai/components/shared/password-strength-meter.tsx
• ./apps/masterbots.ai/components/shared/short-message.tsx
• ./apps/masterbots.ai/components/shared/skeletons/browse-list-skeleton.tsx
• ./apps/masterbots.ai/components/shared/skeletons/browse-skeletons.tsx
• ./apps/masterbots.ai/components/shared/skeletons/chat-chatbot-details-skeleton.tsx
• ./apps/masterbots.ai/components/shared/skeletons/no-results-skeleton.tsx
• ./apps/masterbots.ai/components/shared/skeletons/profile-sidebar-skeleton.tsx
• ./apps/masterbots.ai/components/shared/theme-toggle.tsx
• ./apps/masterbots.ai/components/shared/wordware-chat.tsx
• ./apps/masterbots.ai/components/ui/accordion.tsx
• ./apps/masterbots.ai/components/ui/alert-dialog.tsx
• ./apps/masterbots.ai/components/ui/badge.tsx
• ./apps/masterbots.ai/components/ui/button.tsx
• ./apps/masterbots.ai/components/ui/calendar.tsx
• ./apps/masterbots.ai/components/ui/card.tsx
• ./apps/masterbots.ai/components/ui/checkbox.tsx
• ./apps/masterbots.ai/components/ui/codeblock.tsx
• ./apps/masterbots.ai/components/ui/command.tsx
• ./apps/masterbots.ai/components/ui/dialog.tsx
• ./apps/masterbots.ai/components/ui/dropdown-menu.tsx
• ./apps/masterbots.ai/components/ui/icons.tsx
• ./apps/masterbots.ai/components/ui/input.tsx
• ./apps/masterbots.ai/components/ui/label.tsx
• ./apps/masterbots.ai/components/ui/menubar.tsx
• ./apps/masterbots.ai/components/ui/pagination.tsx
• ./apps/masterbots.ai/components/ui/popover.tsx
• ./apps/masterbots.ai/components/ui/select.tsx
• ./apps/masterbots.ai/components/ui/separator.tsx
• ./apps/masterbots.ai/components/ui/sheet.tsx
• ./apps/masterbots.ai/components/ui/skeleton.tsx
• ./apps/masterbots.ai/components/ui/sonner.tsx
• ./apps/masterbots.ai/components/ui/switch.tsx
• ./apps/masterbots.ai/components/ui/textarea.tsx
• ./apps/masterbots.ai/components/ui/tooltip.tsx
• ./apps/masterbots.ai/components/ui/wizard/hook/index.tsx
• ./apps/masterbots.ai/components/ui/wizard/hook/useWizard.tsx
• ./apps/masterbots.ai/components/ui/wizard/index.tsx

Service Layer Updates

• ./apps/masterbots.ai/services/admin/admin.service.ts
• ./apps/masterbots.ai/services/hasura/hasura.service.ts
• ./apps/masterbots.ai/services/hasura/hasura.service.type.ts
• ./apps/masterbots.ai/services/hasura/index.ts

Type Definition Updates

• Update types.ts
• Update generated GraphQL types
• Update schema definitions

Testing Requirements

• Database migration testing
• Route functionality testing
• UI component testing
• API endpoint testing

Documentation Updates

• Update API documentation
• Update database schema documentation
• Update component documentation

Notes

• This is a breaking change that requires careful coordination
• Changes should be made incrementally to maintain system stability
• Each component should be tested thoroughly after updates

Related

PR: #344