search

LukasStrickler / FixMyTown

https://fix-my-town.vercel.app
1 stars 0 forks source link

dbSchema #52

Closed LukasStrickler closed 1 week ago

LukasStrickler commented 1 week ago

  1. Removed Unused Post Schema and Component:

    • Removed the posts schema from the src/server/db/schema.ts file, as it was not being used.
    • Removed the LatestPost component from the src/components/post.tsx file, as it was also not being used.

  2. Added New Database Schemas:

    • Introduced schema definitions for verificationTokens, users, sessions, and accounts to support authentication and user management functionality.
    • Added new database schemas for pictures, status, types, prios, and reports to support the core functionality of the application, which involves managing and tracking various types of reports.
    • Introduced a protocolls table to store information about report updates, including the time, user, status, and comment.

  3. Database Schema Improvements:

    • Added indexes to the database schema for improved performance.
    • Updated the report table fields to better suit the application's requirements.
    • Added fixmytown_status and fixmytown_types tables to store information about report statuses and types.
vercel[bot] commented 1 week ago

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name Status Preview Comments Updated (UTC)
fix-my-town ✅ Ready (Inspect) Visit Preview 💬 Add feedback Nov 13, 2024 0:30am