Add a Lightweight AI Blog System

Add a lightweight AI-powered blog system to this existing Base44 app.

Before making changes, scan the full app so you understand the current pages, components, layout, navigation, auth flow, user roles, data models, backend functions, public routes, SEO setup, and design patterns. Do not break existing features. Build the blog system using the app's current design style, permissions, and structure.

CORE GOAL: Let authorized users configure basic blog settings, create posts manually, generate posts with AI, edit/save drafts, publish, schedule, manage categories and tags, display public blog pages, add basic SEO fields, and track basic blog activity.

1. BLOG SETTINGS — enable/disable blog, blog name, description, default author name/bio/avatar, default blog route, posts per page, show author box, show related posts, enable AI generation, enable scheduled publishing. Only authorized users can edit.

2. DATA MODELS:
BlogSettings — user_id, workspace/account_id (if used), blog_enabled, blog_name, blog_description, default_author_name/bio/avatar_url, posts_per_page, show_author_box, show_related_posts, enable_ai_generation, enable_scheduled_publishing, timestamps.
BlogPost — user_id, workspace/account_id, title, slug, excerpt, content_markdown, content_html, status (draft/scheduled/published/archived), target_keyword, category_id, tag_ids, author_name/bio/avatar_url, featured_image_url, featured_image_alt, meta_title, meta_description, canonical_url, reading_time_minutes, word_count, scheduled_at, published_at, timestamps.
BlogCategory / BlogTag — user_id, workspace/account_id, name, slug, description, is_active, timestamps.
BlogLog — user_id, event_type, related_post_id, status, message, created_at.
Apply strict ownership rules so users cannot access another user's blog data.

3. ADMIN PAGES — Blog Dashboard (total/draft/scheduled/published counts, recent posts, quick buttons); Blog Posts (view/search/filter by status, create/edit/duplicate/archive/publish/schedule); Blog Editor (title, slug, excerpt, content editor, category, tags, featured image + alt, meta title/description, status, scheduled date; save draft, publish now, schedule, preview, word count, reading time, basic SEO preview); Categories and Tags (create/edit/deactivate, clean slugs); Blog Settings.

4. PUBLIC PAGES — Blog Index (/blog: published posts only, featured/latest section, recent grid, category + tag filter, search, pagination/load-more, empty state); Blog Post Page (/blog/[slug]: published only, title, excerpt, featured image, author info, published date, reading time, category, tags, content, related posts if enabled, proper not-found state); Category Page (/blog/category/[slug]); Tag Page (/blog/tag/[slug]). Draft, scheduled, archived, and unpublished posts must never be publicly visible.

5. AI BLOG GENERATOR — page/panel with inputs: topic, target keyword, secondary keywords, search intent, target audience, tone, article length, category, tags, CTA, custom instructions. Backend function generateBlogPost outputs title options, recommended title, slug, excerpt, outline, full article, meta title/description, suggested category/tags, featured image prompt + alt text. Save as draft. Writing rules: no fake statistics or testimonials, no keyword stuffing, write for humans first, match search intent, clear headings, short paragraphs, strong intro, useful conclusion, one clear CTA.

6. BASIC SEO FIELDS — target keyword, meta title, meta description, canonical URL, featured image alt text; show a checklist (title/slug/meta title/meta description/content/alt text/target keyword exist). Do not block publishing unless title, slug, and content are missing.

7. SCHEDULING & PUBLISHING — save draft, publish now, schedule, cancel schedule, reschedule, archive. Backend functions: createBlogPost, updateBlogPost, publishBlogPostNow, scheduleBlogPost, cancelScheduledBlogPost, archiveBlogPost, processScheduledBlogPosts. Create an automation that publishes scheduled posts when scheduled_at is due. Rules: drafts/scheduled/archived not public; published appear publicly; slugs unique.

8. BASIC LOGS — settings updated, post created/updated/AI-generated/scheduled/published/archived, publishing failed. Add a simple Blog Logs page for admins.

9. SAFETY & PERMISSIONS — users access only their own blog data; public pages show only published posts; admin pages and settings protected; drafts never exposed; scheduled posts hidden before publish time; archived hidden; slugs validated; duplicate slugs blocked; missing title/content prevents publishing.

10. FINAL QA — test settings save, dashboard load, manual + AI post creation, editing, draft save, publish now, scheduling, public index + post pages, category/tag filters, hidden drafts/scheduled/archived posts publicly, mobile layout, permissions, and that existing app features still work.

Return a final summary: what was built, pages added, data models added, backend functions added, automations added, public routes added, files changed, manual setup needed, and what to test before launch.