use namespace::clean;
use DBIx::Class::Schema::Loader::Table ();
-our $VERSION = '0.07036_04';
+our $VERSION = '0.07039';
=head1 NAME
my @uniqs;
my $keydata = $self->_mysql_table_get_keys($table);
- foreach my $keyname (keys %$keydata) {
+ foreach my $keyname (sort keys %$keydata) {
next if $keyname eq 'PRIMARY';
push(@uniqs, [ $keyname => $keydata->{$keyname} ]);
}
my ($precision, $scale, $column_type, $default) = eval { $self->dbh->selectrow_array(<<'EOF', {}, $table->name, lc($col)) };
SELECT numeric_precision, numeric_scale, column_type, column_default
FROM information_schema.columns
-WHERE table_name = ? AND lower(column_name) = ?
+WHERE table_schema = schema() AND table_name = ? AND lower(column_name) = ?
EOF
my $has_information_schema = not $@;