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
28
|
/**
* 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 IDENTITY PRIMARY KEY,
[level] integer,
[category] varchar(255),
[log_time] float,
[prefix] text,
[message] text
);
create index [idx_log_level] on [log] ([level]);
create index [idx_log_category] on [log] ([category]);
|
