# TASK — Database Preparation from PDD v1.0

You are preparing the database foundation for the INVEETAIRE project.

This is NOT a Sprint implementation task.

Do NOT modify any PHP source code.

Do NOT modify documentation.

Do NOT implement Workspace features.

Your responsibility is to convert the approved Physical Database Design (PDD v1.0) into executable SQL.

## Source of Truth

Use ONLY the Physical Database Design (PDD v1.0).

Do not invent tables or columns.

If any ambiguity exists, stop and report it.

## Objectives

Generate:

1. `database/schema.sql`

   * Complete CREATE TABLE statements.
   * Primary Keys.
   * Foreign Keys.
   * Indexes.
   * Default values.
   * Engine = InnoDB.
   * Charset = utf8mb4.

2. `database/seed.sql`

   * Reference/master data defined in the PDD (e.g. roles, event_types, commercial_plans, and other documented seed data).
   * Use idempotent inserts where appropriate.

3. `database/README.md`

   * Explain how to import `schema.sql`.
   * Explain how to run `seed.sql`.
   * State the required MariaDB/MySQL version.
   * List any assumptions or prerequisites.

## Constraints

* Do not modify application code.
* Do not create PHP migrations.
* Do not change the PDD.
* Do not add tables or columns not defined in the PDD.
* Do not generate placeholder SQL.

If the PDD contains missing or conflicting definitions, stop and produce a conflict report instead of guessing.

## Deliverables

* `database/schema.sql`
* `database/seed.sql`
* `database/README.md`

After completion, provide a report summarizing:

* Number of tables created.
* Number of foreign keys.
* Number of indexes.
* Seeded reference tables.
* Any ambiguities encountered.

Stop after the report and wait for approval.