Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases now! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Persistence in PHP with Doctrine ORM

You're reading from   Persistence in PHP with Doctrine ORM This book is designed for PHP developers and architects who want to modernize their skills through better understanding of Persistence and ORM. You'll learn through explanations and code samples, all tied to the full development of a web application.

Arrow left icon
Product type Book
Published in Dec 2013
Publisher Packt
ISBN-13 9781782164104
Pages 114 pages
Edition 1st Edition
Languages
Arrow right icon
Author (1):
Arrow left icon
Kevin Dunglas Kevin Dunglas
Author Profile Icon Kevin Dunglas
Kevin Dunglas
Arrow right icon
View More author details
Toc

Creating the database schema


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...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime