$column63->addVendorInfo(new VendorInfo('mysql', ['Charset' => 'latin1', 'Collate' => 'latin1_general_ci'])); $column64 = new Column('is_published', 'boolean'); $column64->setNotNull(); $column64->setDefaultValue('false'); /* Foreign Keys */ $fkAuthorPost = new ForeignKey('fk_post_has_author'); $fkAuthorPost->addReference('author_id', 'id'); $fkAuthorPost->setForeignTableCommonName('blog_author'); $fkAuthorPost->setRefPhpName('Posts'); $fkAuthorPost->setPhpName('Author'); $fkAuthorPost->setDefaultJoin('Criteria::LEFT_JOIN'); $fkAuthorPost->setOnDelete('CASCADE'); $fkCategoryPost = new ForeignKey('fk_post_has_category'); $fkCategoryPost->addReference('category_id', 'id'); $fkCategoryPost->setForeignTableCommonName('blog_category'); $fkCategoryPost->setRefPhpName('Posts'); $fkCategoryPost->setPhpName('Category'); $fkCategoryPost->setDefaultJoin('Criteria::INNER_JOIN'); $fkCategoryPost->setOnDelete('SETNULL'); $fkPostTag = new ForeignKey('fk_post_has_tags'); $fkPostTag->addReference('post_id', 'id'); $fkPostTag->setForeignTableCommonName('blog_post'); $fkPostTag->setPhpName('Post'); $fkPostTag->setDefaultJoin('Criteria::LEFT_JOIN'); $fkPostTag->setOnDelete('CASCADE'); $fkTagPost = new ForeignKey('fk_tag_has_posts'); $fkTagPost->addReference('tag_id', 'id'); $fkTagPost->setForeignTableCommonName('blog_tag'); $fkTagPost->setPhpName('Tag'); $fkTagPost->setDefaultJoin('Criteria::LEFT_JOIN'); $fkTagPost->setOnDelete('CASCADE');
public function testSetNames() { $fk = new ForeignKey(); $fk->setName('book_author'); $fk->setPhpName('Author'); $fk->setRefPhpName('Books'); $this->assertSame('book_author', $fk->getName()); $this->assertSame('Author', $fk->getPhpName()); $this->assertSame('Books', $fk->getRefPhpName()); }