Doctrine is smart enough to generate the database schema corresponding to the entity mapping information.
Note
It's a good practice to always design entities first and to generate the related database schema after that.
To do this, we will again use Command-Line Tools installed in the first chapter. Type this command in the root directory of our project:
php vendor/bin/doctrine.php orm:schema-tool:create
The following text must be printed in the terminal:
ATTENTION: This operation should not be executed in a production environment.
Creating database schema...
Database schema created successfully!
A new table called Post has been created in the database. You can use the SQLite client to show the structure of the generated table:
sqlite3 data/blog.db ".schema Post"
It should return the following query:
CREATE TABLE Post (id INTEGER NOT NULL, title VARCHAR(255) NOT NULL, body CLOB NOT NULL, publicationDate DATETIME NOT NULL, PRIMARY KEY(id)); CREATE INDEX...