| 1 | <?php | ||
| 5 | class ArticlePosts extends AbstractMigration | ||
| 6 | { | ||
| 7 | public function up() | ||
| 8 |     { | ||
| 9 |         $this->table('article_posts', ['id' => false]) | ||
| 10 |             ->addColumn('article_uuid', 'binary', ['limit' => 16]) | ||
| 11 |             ->addColumn('title', 'text') | ||
| 12 |             ->addColumn('body', 'text') | ||
| 13 |             ->addColumn('lead', 'text') | ||
| 14 |             ->addColumn('featured_img', 'text', ['null' => true]) | ||
| 15 |             ->addColumn('main_img', 'text', ['null' => true]) | ||
| 16 |             ->addColumn('has_layout', 'boolean', ['default' => true]) | ||
| 17 |             ->addForeignKey('article_uuid', 'articles', 'article_uuid', ['delete' => 'NO_ACTION', 'update' => 'NO_ACTION']) | ||
| 18 | ->create(); | ||
| 19 | } | ||
| 20 | |||
| 21 | public function down() | ||
| 22 |     { | ||
| 23 |         $this->dropTable('article_posts'); | ||
| 24 | } | ||
| 25 | } | ||
| 26 |