@@ -15,9 +15,9 @@ |
||
15 | 15 | |
16 | 16 | $this->createTable(self::TABLE, [ |
17 | 17 | 'id' => Schema::TYPE_PK, |
18 | - 'audit_id' => Schema::TYPE_INTEGER . ' NOT NULL', |
|
19 | - 'name' => Schema::TYPE_STRING . '(255) NOT NULL', |
|
20 | - 'type' => Schema::TYPE_STRING . '(255) NULL', |
|
18 | + 'audit_id' => Schema::TYPE_INTEGER.' NOT NULL', |
|
19 | + 'name' => Schema::TYPE_STRING.'(255) NOT NULL', |
|
20 | + 'type' => Schema::TYPE_STRING.'(255) NULL', |
|
21 | 21 | 'packed' => "TINYINT(1) UNSIGNED NOT NULL DEFAULT '0'", |
22 | 22 | 'data' => 'BLOB NOT NULL', |
23 | 23 | ], $tableOptions); |
@@ -15,12 +15,12 @@ |
||
15 | 15 | |
16 | 16 | $this->createTable(self::TABLE, [ |
17 | 17 | 'id' => Schema::TYPE_PK, |
18 | - 'audit_id' => Schema::TYPE_INTEGER . ' NOT NULL', |
|
19 | - 'created' => Schema::TYPE_DATETIME . ' NOT NULL', |
|
20 | - 'message' => Schema::TYPE_STRING . '(512) NOT NULL', |
|
21 | - 'code' => Schema::TYPE_INTEGER . " DEFAULT '0'", |
|
22 | - 'file' => Schema::TYPE_STRING . '(512)', |
|
23 | - 'line' => Schema::TYPE_INTEGER , |
|
18 | + 'audit_id' => Schema::TYPE_INTEGER.' NOT NULL', |
|
19 | + 'created' => Schema::TYPE_DATETIME.' NOT NULL', |
|
20 | + 'message' => Schema::TYPE_STRING.'(512) NOT NULL', |
|
21 | + 'code' => Schema::TYPE_INTEGER." DEFAULT '0'", |
|
22 | + 'file' => Schema::TYPE_STRING.'(512)', |
|
23 | + 'line' => Schema::TYPE_INTEGER, |
|
24 | 24 | 'trace' => 'BLOB', |
25 | 25 | ], $tableOptions); |
26 | 26 |
@@ -20,11 +20,11 @@ |
||
20 | 20 | 'audit_id' => Schema::TYPE_INTEGER, |
21 | 21 | 'old_value' => Schema::TYPE_TEXT, |
22 | 22 | 'new_value' => Schema::TYPE_TEXT, |
23 | - 'action' => Schema::TYPE_STRING . ' NOT NULL', |
|
24 | - 'model' => Schema::TYPE_STRING . ' NOT NULL', |
|
23 | + 'action' => Schema::TYPE_STRING.' NOT NULL', |
|
24 | + 'model' => Schema::TYPE_STRING.' NOT NULL', |
|
25 | 25 | 'field' => Schema::TYPE_STRING, |
26 | - 'stamp' => Schema::TYPE_DATETIME . ' NOT NULL', |
|
27 | - 'model_id' => Schema::TYPE_STRING . ' NOT NULL', |
|
26 | + 'stamp' => Schema::TYPE_DATETIME.' NOT NULL', |
|
27 | + 'model_id' => Schema::TYPE_STRING.' NOT NULL', |
|
28 | 28 | ] |
29 | 29 | ); |
30 | 30 |
@@ -10,11 +10,11 @@ |
||
10 | 10 | { |
11 | 11 | $this->createTable(self::TABLE, [ |
12 | 12 | 'id' => Schema::TYPE_PK, |
13 | - 'audit_id' => Schema::TYPE_INTEGER . ' NOT NULL', |
|
14 | - 'created' => Schema::TYPE_DATETIME . ' NOT NULL', |
|
15 | - 'type' => Schema::TYPE_STRING . '(20) NOT NULL', |
|
16 | - 'message' => Schema::TYPE_TEXT . ' NOT NULL', |
|
17 | - 'origin' => Schema::TYPE_STRING . '(512)', |
|
13 | + 'audit_id' => Schema::TYPE_INTEGER.' NOT NULL', |
|
14 | + 'created' => Schema::TYPE_DATETIME.' NOT NULL', |
|
15 | + 'type' => Schema::TYPE_STRING.'(20) NOT NULL', |
|
16 | + 'message' => Schema::TYPE_TEXT.' NOT NULL', |
|
17 | + 'origin' => Schema::TYPE_STRING.'(512)', |
|
18 | 18 | 'data' => 'BLOB NULL', |
19 | 19 | ], $this->db->driverName === 'mysql' ? 'CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE=InnoDB' : null); |
20 | 20 |
@@ -22,7 +22,7 @@ |
||
22 | 22 | $auditEntry->save(false, ['request_method']); |
23 | 23 | } |
24 | 24 | } |
25 | - echo " done (time: " . sprintf('%.3f', microtime(true) - $time) . "s)\n"; |
|
25 | + echo " done (time: ".sprintf('%.3f', microtime(true) - $time)."s)\n"; |
|
26 | 26 | } |
27 | 27 | |
28 | 28 | public function down() |
@@ -10,16 +10,16 @@ |
||
10 | 10 | $this->dropColumn(self::TABLE, 'url'); |
11 | 11 | $this->dropColumn(self::TABLE, 'redirect'); |
12 | 12 | $this->dropColumn(self::TABLE, 'referrer'); |
13 | - $this->alterColumn(self::TABLE, 'route', Schema::TYPE_STRING . '(512)'); |
|
14 | - $this->alterColumn(self::TABLE, 'request_method', Schema::TYPE_STRING . '(16)'); |
|
13 | + $this->alterColumn(self::TABLE, 'route', Schema::TYPE_STRING.'(512)'); |
|
14 | + $this->alterColumn(self::TABLE, 'request_method', Schema::TYPE_STRING.'(16)'); |
|
15 | 15 | } |
16 | 16 | |
17 | 17 | public function down() |
18 | 18 | { |
19 | - $this->addColumn(self::TABLE, 'url', Schema::TYPE_STRING . '(255)'); |
|
20 | - $this->addColumn(self::TABLE, 'redirect', Schema::TYPE_STRING . '(255)'); |
|
21 | - $this->addColumn(self::TABLE, 'referrer', Schema::TYPE_STRING . '(255)'); |
|
22 | - $this->alterColumn(self::TABLE, 'route', Schema::TYPE_STRING . '(255)'); |
|
23 | - $this->alterColumn(self::TABLE, 'request_method', Schema::TYPE_STRING . '(255)'); |
|
19 | + $this->addColumn(self::TABLE, 'url', Schema::TYPE_STRING.'(255)'); |
|
20 | + $this->addColumn(self::TABLE, 'redirect', Schema::TYPE_STRING.'(255)'); |
|
21 | + $this->addColumn(self::TABLE, 'referrer', Schema::TYPE_STRING.'(255)'); |
|
22 | + $this->alterColumn(self::TABLE, 'route', Schema::TYPE_STRING.'(255)'); |
|
23 | + $this->alterColumn(self::TABLE, 'request_method', Schema::TYPE_STRING.'(255)'); |
|
24 | 24 | } |
25 | 25 | } |
@@ -11,14 +11,14 @@ |
||
11 | 11 | { |
12 | 12 | $this->createTable(self::TABLE, [ |
13 | 13 | 'id' => Schema::TYPE_PK, |
14 | - 'created' => Schema::TYPE_DATETIME . ' NOT NULL', |
|
15 | - 'user_id' => Schema::TYPE_INTEGER . ' DEFAULT 0', |
|
16 | - 'duration' => Schema::TYPE_FLOAT . ' NULL', |
|
17 | - 'ip' => Schema::TYPE_STRING . '(45) NULL', |
|
18 | - 'request_method' => Schema::TYPE_STRING . '(16) NULL', |
|
19 | - 'ajax' => Schema::TYPE_INTEGER . '(1) DEFAULT 0 NOT NULL', |
|
20 | - 'route' => Schema::TYPE_STRING . '(255) NULL', |
|
21 | - 'memory_max' => Schema::TYPE_INTEGER . ' NULL', |
|
14 | + 'created' => Schema::TYPE_DATETIME.' NOT NULL', |
|
15 | + 'user_id' => Schema::TYPE_INTEGER.' DEFAULT 0', |
|
16 | + 'duration' => Schema::TYPE_FLOAT.' NULL', |
|
17 | + 'ip' => Schema::TYPE_STRING.'(45) NULL', |
|
18 | + 'request_method' => Schema::TYPE_STRING.'(16) NULL', |
|
19 | + 'ajax' => Schema::TYPE_INTEGER.'(1) DEFAULT 0 NOT NULL', |
|
20 | + 'route' => Schema::TYPE_STRING.'(255) NULL', |
|
21 | + 'memory_max' => Schema::TYPE_INTEGER.' NULL', |
|
22 | 22 | ], ($this->db->driverName === 'mysql' ? 'CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE=InnoDB' : null)); |
23 | 23 | |
24 | 24 | $this->createIndex('idx_user_id', self::TABLE, ['user_id']); |
@@ -11,8 +11,8 @@ |
||
11 | 11 | { |
12 | 12 | $this->createTable(self::TABLE, [ |
13 | 13 | 'id' => Schema::TYPE_PK, |
14 | - 'entry_id' => Schema::TYPE_INTEGER . ' NOT NULL', |
|
15 | - 'type' => Schema::TYPE_STRING . '(255) NOT NULL', |
|
14 | + 'entry_id' => Schema::TYPE_INTEGER.' NOT NULL', |
|
15 | + 'type' => Schema::TYPE_STRING.'(255) NOT NULL', |
|
16 | 16 | 'data' => Schema::TYPE_BINARY, |
17 | 17 | ], ($this->db->driverName === 'mysql' ? 'CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE=InnoDB' : null)); |
18 | 18 |
@@ -12,15 +12,15 @@ discard block |
||
12 | 12 | $driver = $this->db->driverName; |
13 | 13 | $this->createTable(self::TABLE, [ |
14 | 14 | 'id' => Schema::TYPE_PK, |
15 | - 'entry_id' => Schema::TYPE_INTEGER . ' NOT NULL', |
|
16 | - 'created' => Schema::TYPE_DATETIME . ' NOT NULL', |
|
17 | - 'message' => Schema::TYPE_TEXT . ' NOT NULL', |
|
18 | - 'code' => Schema::TYPE_INTEGER . " DEFAULT '0'", |
|
19 | - 'file' => Schema::TYPE_STRING . '(512)', |
|
20 | - 'line' => Schema::TYPE_INTEGER , |
|
15 | + 'entry_id' => Schema::TYPE_INTEGER.' NOT NULL', |
|
16 | + 'created' => Schema::TYPE_DATETIME.' NOT NULL', |
|
17 | + 'message' => Schema::TYPE_TEXT.' NOT NULL', |
|
18 | + 'code' => Schema::TYPE_INTEGER." DEFAULT '0'", |
|
19 | + 'file' => Schema::TYPE_STRING.'(512)', |
|
20 | + 'line' => Schema::TYPE_INTEGER, |
|
21 | 21 | 'trace' => Schema::TYPE_BINARY, |
22 | - 'hash' => Schema::TYPE_STRING . '(32)', |
|
23 | - 'emailed' => Schema::TYPE_BOOLEAN . " NOT NULL DEFAULT '0'", |
|
22 | + 'hash' => Schema::TYPE_STRING.'(32)', |
|
23 | + 'emailed' => Schema::TYPE_BOOLEAN." NOT NULL DEFAULT '0'", |
|
24 | 24 | ], ($driver === 'mysql' ? 'CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE=InnoDB' : null)); |
25 | 25 | |
26 | 26 | if ($driver != 'sqlite') { |
@@ -28,7 +28,7 @@ discard block |
||
28 | 28 | } |
29 | 29 | |
30 | 30 | // Issue #122: Specified key was too long; max key length is 767 bytes - http://stackoverflow.com/q/1814532/50158 |
31 | - $this->createIndex('idx_file', self::TABLE, ['file' . ($driver === 'mysql' ? '(180)' : '')]); |
|
31 | + $this->createIndex('idx_file', self::TABLE, ['file'.($driver === 'mysql' ? '(180)' : '')]); |
|
32 | 32 | $this->createIndex('idx_emailed', self::TABLE, ['emailed']); |
33 | 33 | } |
34 | 34 |