# Grange Station MySQL Setup

This folder contains the starter MySQL schema for a real booking backend.

## Import With Command Line

From PowerShell, run:

```powershell
mysql -u YOUR_MYSQL_USER -p < "C:\Users\nodor\Desktop\Building\Codex\grange-station-website\database\grange_station_schema.sql"
```

## Import With phpMyAdmin

1. Open phpMyAdmin.
2. Go to Import.
3. Choose `grange_station_schema.sql`.
4. Run the import.

The script uses the database named `gstation`.

If your hosting account does not allow `CREATE DATABASE`, create the database in your hosting control panel first, then remove or skip these lines at the top of the SQL file before import:

```sql
CREATE DATABASE IF NOT EXISTS gstation
  CHARACTER SET utf8mb4
  COLLATE utf8mb4_unicode_ci;

USE gstation;
```

## What It Creates

- `booking_requests`: public reservation/viewing inquiries.
- `booking_request_addons`: selected add-ons for each request.
- `confirmed_bookings`: confirmed dates/times shown as unavailable on the public calendar.
- `availability_blocks`: owner holds or maintenance blocks.
- `rental_addons`: tables, chairs, linens, setup time, photo access, and similar options.
- `vendor_categories`: catering, rentals, music/DJ, bar service, desserts.
- `preferred_vendors`: preferred vendor directory.
- `admin_users`: owner/manager login accounts for the future backend.
- `audit_events`: change history.

## Important

The current website is still a static prototype. To make every visitor see the same requests and confirmed bookings, the form needs a backend API that writes to this MySQL database and reads confirmed bookings from it.

For production, do not store plain-text passwords. Use a backend password hashing function such as PHP `password_hash()` or equivalent.