123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114 |
- <?php
- namespace OC\Core\Migrations;
- use OCP\DB\ISchemaWrapper;
- use OCP\Migration\IOutput;
- use OCP\Migration\SimpleMigrationStep;
- class Version13000Date20170919121250 extends SimpleMigrationStep {
-
- public function preSchemaChange(IOutput $output, \Closure $schemaClosure, array $options) {
- }
-
- public function changeSchema(IOutput $output, \Closure $schemaClosure, array $options) {
-
- $schema = $schemaClosure();
- $table = $schema->getTable('jobs');
- $column = $table->getColumn('id');
- $column->setUnsigned(true);
- $table = $schema->getTable('authtoken');
- $column = $table->getColumn('id');
- $column->setUnsigned(true);
- $column = $table->getColumn('type');
- $column->setUnsigned(true);
- if ($table->hasColumn('remember')) {
- $column = $table->getColumn('remember');
- $column->setUnsigned(true);
- } else {
- $table->addColumn('remember', 'smallint', [
- 'notnull' => false,
- 'length' => 1,
- 'default' => 0,
- 'unsigned' => true,
- ]);
- }
- $column = $table->getColumn('last_activity');
- $column->setUnsigned(true);
- $column = $table->getColumn('last_check');
- $column->setUnsigned(true);
- $table = $schema->getTable('bruteforce_attempts');
- $column = $table->getColumn('id');
- $column->setUnsigned(true);
- $column = $table->getColumn('occurred');
- $column->setUnsigned(true);
- $table = $schema->getTable('comments');
- $column = $table->getColumn('id');
- $column->setUnsigned(true);
- $column = $table->getColumn('parent_id');
- $column->setUnsigned(true);
- $column = $table->getColumn('topmost_parent_id');
- $column->setUnsigned(true);
- $column = $table->getColumn('children_count');
- $column->setUnsigned(true);
- $table = $schema->getTable('file_locks');
- $column = $table->getColumn('id');
- $column->setUnsigned(true);
- $table = $schema->getTable('systemtag');
- $column = $table->getColumn('id');
- $column->setUnsigned(true);
- $table = $schema->getTable('systemtag_object_mapping');
- $column = $table->getColumn('systemtagid');
- $column->setUnsigned(true);
- $table = $schema->getTable('systemtag_group');
- $column = $table->getColumn('systemtagid');
- $column->setUnsigned(true);
- $table = $schema->getTable('vcategory');
- $column = $table->getColumn('id');
- $column->setUnsigned(true);
- $table = $schema->getTable('vcategory_to_object');
- $column = $table->getColumn('objid');
- $column->setUnsigned(true);
- $column = $table->getColumn('categoryid');
- $column->setUnsigned(true);
- return $schema;
- }
-
- public function postSchemaChange(IOutput $output, \Closure $schemaClosure, array $options) {
- }
- }
|