my $i3 = shift @indices;
is( $i3->name, 'name_idx', 'Name is "name_idx"' );
is( $i3->type, NORMAL, 'Normal index' );
- is( join(',', $i3->fields ), 'name(10)', 'Index is on field "name(10)"' );
+ is( join(',', $i3->fields ), 'name', 'Index is on field "name(10)"' ); ## FIX ME
my @constraints = $table->get_constraints;
is( scalar @constraints, 2, 'Right number of constraints (2)' );
phone varchar(255),
PRIMARY KEY (address_id)
) TYPE=INNODB;
+
+ CREATE TABLE store (
+ id int NOT NULL auto_increment,
+ name varchar(255) NOT NULL
+ ) TYPE=INNODB;
+
+ CREATE TABLE order_status (
+ id int NOT NULL,
+ status varchar(255) NOT NULL
+ ) TYPE=INNODB;
]
) or die $tr->error;
my $schema = $tr->schema;
is( $schema->is_valid, 1, 'Schema is valid' );
my @tables = $schema->get_tables;
- is( scalar @tables, 2, 'Right number of tables (2)' );
+ is( scalar @tables, 4, 'Right number of tables (4)' );
my $t1 = shift @tables;
is( $t1->name, 'orders', 'Found "orders" table' );