Blame view

vendor/yiisoft/yii2/log/migrations/schema-mysql.sql 837 Bytes
abf1649b   andryeyev   Чистая установка ...
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
  /**
   * 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`          bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
     `level`       integer,
     `category`    varchar(255),
     `log_time`    double,
     `prefix`      text,
     `message`     text,
     key `idx_log_level` (`level`),
     key `idx_log_category` (`category`)
  ) engine InnoDB;