| 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 |