1
|
|
|
<?php |
2
|
|
|
|
3
|
|
|
/** |
4
|
|
|
* webtrees: online genealogy |
5
|
|
|
* Copyright (C) 2023 webtrees development team |
6
|
|
|
* This program is free software: you can redistribute it and/or modify |
7
|
|
|
* it under the terms of the GNU General Public License as published by |
8
|
|
|
* the Free Software Foundation, either version 3 of the License, or |
9
|
|
|
* (at your option) any later version. |
10
|
|
|
* This program is distributed in the hope that it will be useful, |
11
|
|
|
* but WITHOUT ANY WARRANTY; without even the implied warranty of |
12
|
|
|
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
13
|
|
|
* GNU General Public License for more details. |
14
|
|
|
* You should have received a copy of the GNU General Public License |
15
|
|
|
* along with this program. If not, see <https://www.gnu.org/licenses/>. |
16
|
|
|
*/ |
17
|
|
|
|
18
|
|
|
declare(strict_types=1); |
19
|
|
|
|
20
|
|
|
namespace Fisharebest\Webtrees\Schema; |
21
|
|
|
|
22
|
|
|
use Fisharebest\Webtrees\DB; |
23
|
|
|
use Illuminate\Database\Schema\Blueprint; |
24
|
|
|
|
25
|
|
|
/** |
26
|
|
|
* Upgrade the database schema from version 40 to version 41. |
27
|
|
|
*/ |
28
|
|
|
class Migration40 implements MigrationInterface |
29
|
|
|
{ |
30
|
|
|
public function upgrade(): void |
31
|
|
|
{ |
32
|
|
|
// This table was previously created by the news module in 1.7.9. |
33
|
|
|
// These migrations are now part of the core code. |
34
|
|
|
|
35
|
|
|
if (!DB::schema()->hasTable('news')) { |
36
|
|
|
DB::schema()->create('news', static function (Blueprint $table): void { |
37
|
|
|
$table->integer('news_id', true); |
38
|
|
|
$table->integer('user_id')->nullable(); |
39
|
|
|
$table->integer('gedcom_id')->nullable(); |
40
|
|
|
$table->string('subject', 255); |
41
|
|
|
$table->text('body'); |
42
|
|
|
$table->timestamp('updated')->useCurrent(); |
43
|
|
|
|
44
|
|
|
$table->index(['user_id', 'updated']); |
45
|
|
|
$table->index(['gedcom_id', 'updated']); |
46
|
|
|
|
47
|
|
|
$table->foreign('user_id')->references('user_id')->on('user')->onDelete('cascade'); |
48
|
|
|
$table->foreign('gedcom_id')->references('gedcom_id')->on('gedcom')->onDelete('cascade'); |
49
|
|
|
}); |
50
|
|
|
} |
51
|
|
|
} |
52
|
|
|
} |
53
|
|
|
|