text: /**
   * Database schema required by \yii\log\DbTarget.
   *
   * The indexes declared are not required. They are mainly used to improve the performance
   * of some queries about message levels and categories. Depending on your actual needs, you may
   * want to create additional indexes (e.g. index on `log_time`).
   *
   * @author Alexander Makarov <sam@rmcreative.ru>
   * @link http://www.yiiframework.com/
   * @copyright 2008 Yii Software LLC
   * @license http://www.yiiframework.com/license/
   * @since 2.0.1
   */
  
  drop table if exists "log";
  
  create table "log"
  (
     "id"          integer PRIMARY KEY AUTOINCREMENT NOT NULL,
     "level"       integer,
     "category"    varchar(255),
     "log_time"    integer,
     "prefix"      text,
     "message"     text
  );
  
  create index "idx_log_level" on "log" ("level");
  create index "idx_log_category" on "log" ("category");