Skip to content

Instantly share code, notes, and snippets.

@KendallHopkins
Created May 12, 2011 18:03
Show Gist options
  • Save KendallHopkins/969094 to your computer and use it in GitHub Desktop.
Save KendallHopkins/969094 to your computer and use it in GitHub Desktop.
<table name="store_category" phpName="store_category">
<vendor type="mysql">
<parameter name="Charset" value="utf8"/>
</vendor>
<behavior name="timestampable"/>
<column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
<column name="name" type="varchar" required="true"/>
<column name="parent_id" type="integer" required="false"/>
<column name="is_displayed" type="boolean" required="true"/>
<foreign-key foreignTable="store_category" onDelete="CASCADE" onUpdate="CASCADE">
<reference local="parent_id" foreign="id"/>
</foreign-key>
</table>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment