public function up()
{
$this->createTable(\app\models\Book::tableName(), ['id' => Schema::TYPE_PK, 'name' => Schema::TYPE_STRING . ' NOT NULL', 'date_create' => Schema::TYPE_DATETIME . ' NOT NULL', 'date_update' => Schema::TYPE_TIMESTAMP . ' ON UPDATE CURRENT_TIMESTAMP', 'preview' => Schema::TYPE_STRING, 'date' => Schema::TYPE_DATE . ' NOT NULL', 'author_id' => Schema::TYPE_INTEGER . ' NOT NULL']);
$books = [['name' => 'Go Set a Watchman: A Novel', 'preview' => 'http://ecx.images-amazon.com/images/I/51EU92Bi4GL._SL160_PIsitb-sticker-arrow-dp,TopRight,12,-18_SH30_OU01_SL150_.jpg', 'author_id' => 1, 'date' => '2015-07-14'], ['name' => 'StrengthsFinder 2.0', 'preview' => 'http://ecx.images-amazon.com/images/I/41d%2B2MQkK3L._SL160_PIsitb-sticker-arrow-dp,TopRight,12,-18_SH30_OU01_SL150_.jpg', 'author_id' => 2, 'date' => '2007-02-01'], ['name' => 'First 100 Words', 'preview' => 'http://ecx.images-amazon.com/images/I/51dxds64%2ByL._SL160_PIsitb-sticker-arrow-dp,TopRight,12,-18_SH30_OU01_SL150_.jpg', 'author_id' => 3, 'date' => '2011-05-10']];
foreach ($books as $b) {
$book = new \app\models\Book();
$book->attributes = $b;
$book->date_create = date('Y-m-d H:i:s');
$book->save();
}
}
