public function testBasicCreateTableWithPrefixPrimaryAndForeignKeysWithCascadeDelete() { $blueprint = new Blueprint('users'); $blueprint->create(); $blueprint->integer('id')->primary(); $blueprint->string('email'); $blueprint->integer('foo_id'); $blueprint->foreign('foo_id')->references('id')->on('orders')->onDelete('cascade'); $grammar = $this->getGrammar(); $grammar->setTablePrefix('prefix_'); $conn = $this->getConnection(); $statements = $blueprint->toSql($conn, $grammar); $this->assertEquals(1, count($statements)); $this->assertEquals('create table prefix_users ( id number(10,0) not null, email varchar2(255) not null, foo_id number(10,0) not null, constraint users_foo_id_foreign foreign key ( foo_id ) references prefix_orders ( id ) on delete cascade, constraint users_id_primary primary key ( id ) )', $statements[0]); }