123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103 |
- <?php
- declare(strict_types=1);
- namespace OCA\DAV\Migration;
- use OCP\DB\ISchemaWrapper;
- use OCP\DB\Types;
- use OCP\Migration\IOutput;
- use OCP\Migration\SimpleMigrationStep;
- class Version1012Date20190808122342 extends SimpleMigrationStep {
-
- public function changeSchema(IOutput $output,
- \Closure $schemaClosure,
- array $options):?ISchemaWrapper {
-
- $schema = $schemaClosure();
- if (!$schema->hasTable('calendar_reminders')) {
- $table = $schema->createTable('calendar_reminders');
- $table->addColumn('id', Types::BIGINT, [
- 'autoincrement' => true,
- 'notnull' => true,
- 'length' => 11,
- 'unsigned' => true,
- ]);
- $table->addColumn('calendar_id', Types::BIGINT, [
- 'notnull' => true,
- 'length' => 11,
- ]);
- $table->addColumn('object_id', Types::BIGINT, [
- 'notnull' => true,
- 'length' => 11,
- ]);
- $table->addColumn('is_recurring', Types::SMALLINT, [
- 'notnull' => false,
- 'length' => 1,
- ]);
- $table->addColumn('uid', Types::STRING, [
- 'notnull' => true,
- 'length' => 255,
- ]);
- $table->addColumn('recurrence_id', Types::BIGINT, [
- 'notnull' => false,
- 'length' => 11,
- 'unsigned' => true,
- ]);
- $table->addColumn('is_recurrence_exception', Types::SMALLINT, [
- 'notnull' => true,
- 'length' => 1,
- ]);
- $table->addColumn('event_hash', Types::STRING, [
- 'notnull' => true,
- 'length' => 255,
- ]);
- $table->addColumn('alarm_hash', Types::STRING, [
- 'notnull' => true,
- 'length' => 255,
- ]);
- $table->addColumn('type', Types::STRING, [
- 'notnull' => true,
- 'length' => 255,
- ]);
- $table->addColumn('is_relative', Types::SMALLINT, [
- 'notnull' => true,
- 'length' => 1,
- ]);
- $table->addColumn('notification_date', Types::BIGINT, [
- 'notnull' => true,
- 'length' => 11,
- 'unsigned' => true,
- ]);
- $table->addColumn('is_repeat_based', Types::SMALLINT, [
- 'notnull' => true,
- 'length' => 1,
- ]);
- $table->setPrimaryKey(['id']);
- $table->addIndex(['object_id'], 'calendar_reminder_objid');
- $table->addIndex(['uid', 'recurrence_id'], 'calendar_reminder_uidrec');
- return $schema;
- }
- return null;
- }
- }
|