1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495 |
- <?php
- namespace OC\Core\Migrations;
- use OCP\DB\ISchemaWrapper;
- use OCP\DB\Types;
- use OCP\Migration\IOutput;
- use OCP\Migration\SimpleMigrationStep;
- class Version13000Date20170705121758 extends SimpleMigrationStep {
-
- public function changeSchema(IOutput $output, \Closure $schemaClosure, array $options) {
-
- $schema = $schemaClosure();
- if (!$schema->hasTable('personal_sections')) {
- $table = $schema->createTable('personal_sections');
- $table->addColumn('id', Types::STRING, [
- 'notnull' => false,
- 'length' => 64,
- ]);
- $table->addColumn('class', Types::STRING, [
- 'notnull' => true,
- 'length' => 255,
- ]);
- $table->addColumn('priority', Types::INTEGER, [
- 'notnull' => true,
- 'length' => 6,
- 'default' => 0,
- ]);
- $table->setPrimaryKey(['id'], 'personal_sections_id_index');
- $table->addUniqueIndex(['class'], 'personal_sections_class');
- }
- if (!$schema->hasTable('personal_settings')) {
- $table = $schema->createTable('personal_settings');
- $table->addColumn('id', Types::INTEGER, [
- 'autoincrement' => true,
- 'notnull' => true,
- 'length' => 20,
- ]);
- $table->addColumn('class', Types::STRING, [
- 'notnull' => true,
- 'length' => 255,
- ]);
- $table->addColumn('section', Types::STRING, [
- 'notnull' => false,
- 'length' => 64,
- ]);
- $table->addColumn('priority', Types::INTEGER, [
- 'notnull' => true,
- 'length' => 6,
- 'default' => 0,
- ]);
- $table->setPrimaryKey(['id'], 'personal_settings_id_index');
- $table->addUniqueIndex(['class'], 'personal_settings_class');
- $table->addIndex(['section'], 'personal_settings_section');
- }
- return $schema;
- }
- }
|