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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
|
<?php
class MigrationHistoryReworked extends Migration
{
public function description()
{
return 'Add log actions for migrations';
}
public function up()
{
// Add log actions
$query = "INSERT IGNORE INTO log_actions (
`action_id`, `name`, `description`, `info_template`, `active`, `expires`, `mkdate`, `chdate`
) VALUES (
MD5(:name), :name, :description, :template, :active, 0, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
)";
$statement = DBManager::get()->prepare($query);
$statement->execute([
':name' => 'MIGRATE_UP',
':description' => 'Migration wird durchgeführt',
':template' => '%user hat Migration %affected ausgeführt (Domain: %coaffected)',
':active' => 1,
]);
$statement->execute([
':name' => 'MIGRATE_DOWN',
':description' => 'Migration wird zurückgenommen',
':template' => '%user hat Migration %affected zurückgenommen (Domain: %coaffected)',
':active' => 1,
]);
}
public function down()
{
// Remove log actions
$query = "DELETE `log_actions`, `log_events`
FROM `log_actions`
LEFT JOIN `log_events` USING (`action_id`)
WHERE MD5(:name) = `action_id`";
$statement = DBManager::get()->prepare($query);
$statement->execute([':name' => 'MIGRATE_UP']);
$statement->execute([':name' => 'MIGRATE_DOWN']);
}
}
|
