#=============================================================================
BEGIN {
- maybe_plan(142, 'SQL::Translator::Parser::XML::SQLFairy');
+ maybe_plan(150, '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",
size => 10,
is_primary_key => 1,
is_auto_increment => 1,
+ extra => { ZEROFILL => 1 },
},
{
name => "title",
is_unique => 1,
default_value => undef,
is_nullable => 1,
+ extra => {
+ foo => "bar",
+ hello => "world",
+ bar => "baz",
+ }
},
{
name => "explicitnulldef",
data_type => "varchar",
default_value => "",
is_nullable => 1,
+ comments => "Hello emptytagdef",
},
],
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",
+ },
},
],
database_event => 'insert',
on_table => 'foo',
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",
+ },
},
],