<schema name="" database="" xmlns="http://sqlfairy.sourceforge.net/sqlfairy.xml">
<extra />
<tables>
- <table name="Basic" order="2">
+ <table name="Basic" order="1">
<extra />
<fields></fields>
<indices></indices>
</tables>
<views></views>
<triggers>
- <trigger name="foo_trigger" database_event="insert" on_table="Basic" perform_action_when="after" order="1">
+ <trigger name="foo_trigger" database_events="insert" on_table="Basic" perform_action_when="after" order="1">
<action>update modified=timestamp();</action>
<extra hello="world" />
</trigger>
<schema name="" database="" xmlns="http://sqlfairy.sourceforge.net/sqlfairy.xml">
<extra />
<tables>
- <table name="Basic" order="3">
+ <table name="Basic" order="1">
<extra />
<fields>
- <field name="foo" data_type="integer" size="10" is_nullable="1" is_auto_increment="0" is_primary_key="0" is_foreign_key="0" order="5">
+ <field name="foo" data_type="integer" size="10" is_nullable="1" is_auto_increment="0" is_primary_key="0" is_foreign_key="0" order="1">
<extra ZEROFILL="1" />
<comments></comments>
</field>
+ <field name="bar" data_type="numeric" size="10,2" is_nullable="1" is_auto_increment="0" is_primary_key="0" is_foreign_key="0" order="2">
+ <extra />
+ <comments></comments>
+ </field>
+ <field name="baz" data_type="decimal" size="8,3" is_nullable="1" is_auto_increment="0" is_primary_key="0" is_foreign_key="0" order="3">
+ <extra />
+ <comments></comments>
+ </field>
</fields>
<indices></indices>
<constraints></constraints>
) or die $t->error;
$f->extra(ZEROFILL => "1");
+ $t->add_field(
+ name => "bar",
+ data_type => "numeric",
+ size => "10,2",
+ ) or die $t->error;
+ $t->add_field(
+ name => "baz",
+ data_type => "decimal",
+ size => [8,3],
+ ) or die $t->error;
+
+
# As we have created a Schema we give translate a dummy string so that
# it will run the produce.
lives_ok {$xml =$obj->translate("FOO");} "Translate (Field.extra) ran";