Database


Table of Contents

Basic Schema Syntax 
Reverse engine an existing database 
Generating a YAML Data Model from an Existing Database 
import fixtures 
export fixtures 
Dump existing data into YAML file 
Generate UML diagram from symfony schema 
Usage 
Model visualization with symfony 
Model visualization with symfony 
Model visualization with symfony 
schema xml, database name and propel 
schema xml, database name and propel 
schema xml, database name and propel 
Using multiple databases from Propel 
Updating one table def 
Updating one table def 
implement table with parent child relationship 
implement table with parent child relationship 
implement table with parent child relationship 
Nested Set 
Symfony + PostgreSQL 
Symfony + PostgreSQL 

Basic Schema Syntax 

http://www.symfony-project.org/book/trunk/08-Inside-the-Model-Layer#Basic%20Schema%20Syntax

*Tags*: symfony schema data types

Symfony understands the usual column types: boolean, integer, float, date, varchar(size), longvarchar (converted, for instance, to text in MySQL), and so on. For text content over 256 characters, you need to use the longvarchar type, which has no size (but cannot exceed 65KB in MySQL).