<?xml version="1.0" encoding="UTF-8"?>
<database defaultIdMethod="native" name="thelia" namespace="OrderComment\Model">
    <table name="order_comment">
        <column autoIncrement="true" name="id" primaryKey="true" required="true" type="INTEGER" />
        <column name="order_id" required="true" type="INTEGER" />
        <column name="comment" required="true" type="LONGVARCHAR" />

        <foreign-key foreignTable="order" name="fk_order_comment_order_id" onDelete="CASCADE" onUpdate="RESTRICT">
            <reference foreign="id" local="order_id" />
        </foreign-key>
    </table>
    <external-schema filename="local/config/schema.xml" referenceOnly="true" />
</database>
