app/Schema/Migration37.php

1 <?php
8  * the Free Software Foundation, either version 3 of the License, or
9  * (at your option) any later version.
28  * Upgrade the database schema from version 37 to version 38.
35         DB::schema()->dropIfExists('site_access_rule');
36         DB::schema()->dropIfExists('next_id');
40         if (!DB::schema()->hasTable('media_file')) {
41             DB::schema()->create('media_file', static function (Blueprint $table): void {
42                 $table->integer('id', true);
43                 $table->string('m_id', 20);
44                 $table->integer('m_file');
45                 $table->string('multimedia_file_refn', 248); // GEDCOM only allows 30 characters
46                 $table->string('multimedia_format', 4);
47                 $table->string('source_media_type', 15);
48                 $table->string('descriptive_title', 248);
50                 $table->index(['m_id', 'm_file']);
51                 $table->index(['m_file', 'm_id']);
52                 $table->index(['m_file', 'multimedia_file_refn']);
53                 $table->index(['m_file', 'multimedia_format']);
54                 $table->index(['m_file', 'source_media_type']);
55                 $table->index(['m_file', 'descriptive_title']);
59 …    if (DB::table('media_file')->count() === 0 && DB::schema()->hasColumn('media', 'm_filename')) {
60             (new Builder(DB::connection()))->from('media_file')->insertUsing([
68                 // SQLite also supports SUBSTRING() from 3.34.0 (2020-12-01)
71                 $query->select([
78                 ])->from('media');
82             DB::schema()->table('media', static function (Blueprint $table): void {
83                 $table->dropColumn('m_filename');
85             DB::schema()->table('media', static function (Blueprint $table): void {
86                 $table->dropColumn('m_ext');
88             DB::schema()->table('media', static function (Blueprint $table): void {
89                 $table->dropColumn('m_type');
91             DB::schema()->table('media', static function (Blueprint $table): void {
92                 $table->dropColumn('m_titl');