Database Definition
Discover how to define a MySQL database schema by creating projects and tasks tables and populating them with initial data. Understand how to structure and initialize your database for a PHP CRUD app.
We'll cover the following...
We'll cover the following...
We’ll create three .sql files in the data directory: database.sql, structure.sql, and content.sql.
Let’s get started.
Database schema
The main purpose of the intended application is to track the time we spend on a given project. Each project consists of a number of tasks. All the projects are stored in a relational database called tracker. The relational database management system that is used in this context is MySQL.
In the root directory of our project, we’ll create a new ...