Version14000Date20180626223656.php 2.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869
  1. <?php
  2. /**
  3. * @copyright Copyright (c) 2018 Arthur Schiwon <blizzz@arthur-schiwon.de>
  4. *
  5. * @author Arthur Schiwon <blizzz@arthur-schiwon.de>
  6. *
  7. * @license GNU AGPL version 3 or any later version
  8. *
  9. * This program is free software: you can redistribute it and/or modify
  10. * it under the terms of the GNU Affero General Public License as
  11. * published by the Free Software Foundation, either version 3 of the
  12. * License, or (at your option) any later version.
  13. *
  14. * This program is distributed in the hope that it will be useful,
  15. * but WITHOUT ANY WARRANTY; without even the implied warranty of
  16. * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  17. * GNU Affero General Public License for more details.
  18. *
  19. * You should have received a copy of the GNU Affero General Public License
  20. * along with this program. If not, see <http://www.gnu.org/licenses/>.
  21. *
  22. */
  23. namespace OC\Core\Migrations;
  24. use OCP\DB\ISchemaWrapper;
  25. use OCP\Migration\SimpleMigrationStep;
  26. class Version14000Date20180626223656 extends SimpleMigrationStep {
  27. public function changeSchema(\OCP\Migration\IOutput $output, \Closure $schemaClosure, array $options) {
  28. /** @var ISchemaWrapper $schema */
  29. $schema = $schemaClosure();
  30. if(!$schema->hasTable('whats_new')) {
  31. $table = $schema->createTable('whats_new');
  32. $table->addColumn('id', 'integer', [
  33. 'autoincrement' => true,
  34. 'notnull' => true,
  35. 'length' => 4,
  36. 'unsigned' => true,
  37. ]);
  38. $table->addColumn('version', 'string', [
  39. 'notnull' => true,
  40. 'length' => 64,
  41. 'default' => '11',
  42. ]);
  43. $table->addColumn('etag', 'string', [
  44. 'notnull' => true,
  45. 'length' => 64,
  46. 'default' => '',
  47. ]);
  48. $table->addColumn('last_check', 'integer', [
  49. 'notnull' => true,
  50. 'length' => 4,
  51. 'unsigned' => true,
  52. 'default' => 0,
  53. ]);
  54. $table->addColumn('data', 'text', [
  55. 'notnull' => true,
  56. 'default' => '',
  57. ]);
  58. $table->setPrimaryKey(['id']);
  59. $table->addUniqueIndex(['version'], 'version');
  60. $table->addIndex(['version', 'etag'], 'version_etag_idx');
  61. }
  62. return $schema;
  63. }
  64. }