Database Definition
Create the SQL files that we'll use to initialize our application.
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 ...