#=============================================================================
BEGIN {
- maybe_plan(142, 'SQL::Translator::Parser::XML::SQLFairy');
+ maybe_plan(162, 'SQL::Translator::Parser::XML::SQLFairy');
}
my $testschema = "$Bin/data/xml/schema.xml";
tables => [
{
name => "Basic",
+ extra => {
+ foo => "bar",
+ hello => "world",
+ bar => "baz",
+ mysql_table_type => "InnoDB",
+ },
fields => [
{
name => "id",
is_nullable => 1,
comments => "Hello emptytagdef",
},
+ {
+ name => "timest",
+ data_type => "timestamp",
+ size => "0",
+ is_nullable => 1,
+ },
],
constraints => [
{
type => PRIMARY_KEY,
fields => ["id"],
+ extra => {
+ foo => "bar",
+ hello => "world",
+ bar => "baz",
+ },
},
{
name => 'emailuniqueindex',
{
name => "titleindex",
fields => ["title"],
+ extra => {
+ foo => "bar",
+ hello => "world",
+ bar => "baz",
+ },
},
],
} # end table Basic
name => 'email_list',
sql => "SELECT email FROM Basic WHERE email IS NOT NULL",
fields => ['email'],
+ extra => {
+ foo => "bar",
+ hello => "world",
+ bar => "baz",
+ },
},
],
name => 'foo_trigger',
perform_action_when => 'after',
database_event => 'insert',
- on_table => 'foo',
+ on_table => 'Basic',
action => 'update modified=timestamp();',
+ extra => {
+ foo => "bar",
+ hello => "world",
+ bar => "baz",
+ },
},
],
parameters => ['foo', 'bar'],
owner => 'Nomar',
comments => 'Go Sox!',
+ extra => {
+ foo => "bar",
+ hello => "world",
+ bar => "baz",
+ },
},
],