12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667 |
- <?php
- declare(strict_types=1);
- namespace OC\Core\Migrations;
- use OCP\DB\ISchemaWrapper;
- use OCP\IDBConnection;
- use OCP\Migration\IOutput;
- use OCP\Migration\SimpleMigrationStep;
- class Version14000Date20180404140050 extends SimpleMigrationStep {
- public function __construct(
- private IDBConnection $connection,
- ) {
- }
- public function name(): string {
- return 'Add lowercase user id column to users table';
- }
- public function description(): string {
- return 'Adds "uid_lower" column to the users table and fills the column to allow indexed case-insensitive searches';
- }
-
- public function changeSchema(IOutput $output, \Closure $schemaClosure, array $options) {
-
- $schema = $schemaClosure();
- $table = $schema->getTable('users');
- $table->addColumn('uid_lower', 'string', [
- 'notnull' => false,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->addIndex(['uid_lower'], 'user_uid_lower');
- return $schema;
- }
-
- public function postSchemaChange(IOutput $output, \Closure $schemaClosure, array $options) {
- $qb = $this->connection->getQueryBuilder();
- $qb->update('users')
- ->set('uid_lower', $qb->func()->lower('uid'));
- $qb->execute();
- }
- }
|