0
0
Fork 0
mirror of https://github.com/kevinpapst/kimai2.git synced 2025-05-02 16:30:03 +00:00
kevinpapst_kimai2/migrations/Version20230819090536.php
Kevin Papst 02bcd45116
Release 2.5.0 (#4454)
- added command to list users
- corrected wrong german translation
- work contract validations
- prevent error with missing params
- use collapsible, minor UI improvement
- added classes to target menu buttons in custom rules
- disable webpack notifier, incompatible with mac arm
- use explicit menu service to generate menu
- bump to fontawesome 6 and replace restart icon
- change repeat icon for recent activities
- moved user bookmarks (favorites) to top nav
- fix totp seconds window (leeway)
- new migration to fix remaining user preferences with dots in name
- remove duplicate named column in user screen
- unify and added translations
- added missing filter and tags to InvoiceSecurity
2023-12-01 11:38:17 +01:00

48 lines
1.3 KiB
PHP

<?php
declare(strict_types=1);
/*
* This file is part of the Kimai time-tracking app.
*
* For the full copyright and license information, please view the LICENSE
* file that was distributed with this source code.
*/
namespace DoctrineMigrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
/**
* @version 2.0.31
*/
final class Version20230819090536 extends AbstractMigration
{
public function getDescription(): string
{
return 'Adds the supervisor columns to the user-table';
}
public function up(Schema $schema): void
{
$table = $schema->getTable('kimai2_users');
$table->addColumn('supervisor_id', 'integer', ['length' => 11, 'notnull' => false, 'default' => null]);
$table->addForeignKeyConstraint('kimai2_users', ['supervisor_id'], ['id'], ['onDelete' => 'SET NULL'], 'FK_B9AC5BCE19E9AC5F');
$table->addIndex(['supervisor_id'], 'IDX_B9AC5BCE19E9AC5F');
}
public function down(Schema $schema): void
{
$table = $schema->getTable('kimai2_users');
$table->removeForeignKey('FK_B9AC5BCE19E9AC5F');
$table->dropIndex('IDX_B9AC5BCE19E9AC5F');
$table->dropColumn('supervisor_id');
}
public function isTransactional(): bool
{
return false;
}
}