[PR #2] [CLOSED] fix(db): remove unnecessary fields from vehicles and ratings tables #1

New issue

Closed

opened 2026-05-06 16:09:05 +02:00 by BreizhHardware · 0 comments

BreizhHardware commented

2026-05-06 16:09:05 +02:00

Owner

📋 Pull Request Information

Original PR: https://github.com/BreizhHardware/projet-web-cipa4/pull/2
Author: @BreizhHardware
Created: 2/3/2026
Status: ❌ Closed

Base: main ← Head: feat/backend

📝 Commits (1)

563e07c fix(db): remove unnecessary fields from vehicles and ratings tables

📊 Changes

1 file changed (+5 additions, -5 deletions)

View changed files

📝 php/utils/init_db.php (+5 -5)

📄 Description

This pull request updates the database schema in php/utils/init_db.php to better support trip preferences and simplifies some table structures. The most important changes are grouped below:

Trip Preferences Enhancements:

Added new columns to the trips table: smoking_allowed, pets_allowed, and luggage_allowed, each defaulting to 0, to allow users to specify trip preferences.

Table Structure Simplification:

Removed the license_plate and seats columns from the cars table, streamlining car information.
Removed the comment column from the ratings table, simplifying the ratings data model.

_{🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.}

## 📋 Pull Request Information **Original PR:** https://github.com/BreizhHardware/projet-web-cipa4/pull/2 **Author:** [@BreizhHardware](https://github.com/BreizhHardware) **Created:** 2/3/2026 **Status:** ❌ Closed **Base:** `main` ← **Head:** `feat/backend` --- ### 📝 Commits (1) - [`563e07c`](https://github.com/BreizhHardware/projet-web-cipa4/commit/563e07c999ba7bd89126b468329e0237787ab40e) fix(db): remove unnecessary fields from vehicles and ratings tables ### 📊 Changes **1 file changed** (+5 additions, -5 deletions) <details> <summary>View changed files</summary> 📝 `php/utils/init_db.php` (+5 -5) </details> ### 📄 Description This pull request updates the database schema in `php/utils/init_db.php` to better support trip preferences and simplifies some table structures. The most important changes are grouped below: **Trip Preferences Enhancements:** * Added new columns to the `trips` table: `smoking_allowed`, `pets_allowed`, and `luggage_allowed`, each defaulting to 0, to allow users to specify trip preferences. **Table Structure Simplification:** * Removed the `license_plate` and `seats` columns from the `cars` table, streamlining car information. * Removed the `comment` column from the `ratings` table, simplifying the ratings data model. --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>