#=============================================================================
BEGIN {
- eval {require Template;};
-
- if ( $@ ) {
- plan skip_all => 'Template not installed?'
- }
-
- maybe_plan(6,
- 'XML::XPath',
+ maybe_plan(6,
'SQL::Translator::Parser::XML::SQLFairy',
- 'Template',
+ 'Template 2.20',
'Test::Differences'
);
}
is_nullable: 0
default_value: hello
is_primary_key: 0
- is_unique: 0
+ is_unique: 1
is_auto_increment: 0
is_foreign_key: 0
foreign_key_reference:
email
data_type: varchar
- size: 255
+ size: 500
is_nullable: 1
default_value:
is_primary_key: 0
options:
is_valid: 1
+ very_long_index_name_on_title_field_which_should_be_truncated_for_various_rdbms
+ type: UNIQUE
+ fields: title
+ expression:
+ match_type:
+ reference_fields:
+ reference_table:
+ deferrable: 1
+ on_delete:
+ on_update:
+ options:
+ is_valid: 1
+
?
type: FOREIGN KEY
fields: another_id
is_foreign_key: 0
foreign_key_reference:
is_valid: 1
- order: 10
+ order: 1
+ table: Another
+
+ num
+ data_type: numeric
+ size: 10,2
+ is_nullable: 1
+ default_value:
+ is_primary_key: 0
+ is_unique: 0
+ is_auto_increment: 0
+ is_foreign_key: 0
+ foreign_key_reference:
+ is_valid: 1
+ order: 2
table: Another