<?xml version="1.0" encoding="UTF-8"?>
<database name="default" namespace="Sensio\Bundle\BlogBundle\Model" defaultIdMethod="native">

    <table name="sl_blog_post" phpName="Post">
        <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true" />
        <column name="title" type="varchar" size="100" />
        <column name="body" type="longvarchar" size="20" />
        <column name="is_published" type="boolean" defaultValue="true" />
        <column name="created_at" type="timestamp" defaultValue="now"/>
    </table>

    <table name="sl_blog_comment" phpName="Comment">
        <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true" />
        <column name="post_id" type="integer" />
        <column name="author" type="varchar" required="true" size="30" />
        <column name="email" type="varchar" required="true" size="60" />
        <column name="body" type="longvarchar" required="true" />
        <foreign-key foreignTable="sl_blog_post" onDelete="cascade">
            <reference local="post_id" foreign="id" />
        </foreign-key>
    </table>

</database>