WCF/wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.2_step1.php at b03b71d45914e6ae9689412d148a1347bf78741c · WoltLab/WCF · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
<?php

/**
 * Updates the database layout during the update from 6.1 to 6.2.
 *
 * @author    Olaf Braun
 * @copyright 2001-2024 WoltLab GmbH
 * @license   GNU Lesser General Public License <http://opensource.org/licenses/lgpl-license.php>
 */

use wcf\system\database\table\column\IntDatabaseTableColumn;
use wcf\system\database\table\column\MediumtextDatabaseTableColumn;
use wcf\system\database\table\column\NotNullVarchar255DatabaseTableColumn;
use wcf\system\database\table\column\ObjectIdDatabaseTableColumn;
use wcf\system\database\table\DatabaseTable;
use wcf\system\database\table\index\DatabaseTableForeignKey;
use wcf\system\database\table\index\DatabaseTableIndex;
use wcf\system\database\table\index\DatabaseTablePrimaryIndex;
use wcf\system\database\table\PartialDatabaseTable;

return [
    PartialDatabaseTable::create('wcf1_user')
        ->columns([
            IntDatabaseTableColumn::create('avatarFileID')
                ->length(10)
                ->defaultValue(null),
            IntDatabaseTableColumn::create('coverPhotoFileID')
                ->length(10)
                ->defaultValue(null),
        ])
        ->foreignKeys([
            DatabaseTableForeignKey::create()
                ->columns(['avatarFileID'])
                ->referencedTable('wcf1_file')
                ->referencedColumns(['fileID'])
                ->onDelete('SET NULL'),
            DatabaseTableForeignKey::create()
                ->columns(['coverPhotoFileID'])
                ->referencedTable('wcf1_file')
                ->referencedColumns(['fileID'])
                ->onDelete('SET NULL'),
        ]),
    PartialDatabaseTable::create('wcf1_unfurl_url_image')
        ->columns([
            IntDatabaseTableColumn::create('fileID')
                ->length(10)
                ->defaultValue(null),
        ])
        ->foreignKeys([
            DatabaseTableForeignKey::create()
                ->columns(['fileID'])
                ->referencedTable('wcf1_file')
                ->referencedColumns(['fileID'])
                ->onDelete('SET NULL'),
        ]),
    PartialDatabaseTable::create('wcf1_contact_option')
        ->columns([
            MediumtextDatabaseTableColumn::create('configuration'),
        ]),
    PartialDatabaseTable::create('wcf1_file')
        ->columns([
            IntDatabaseTableColumn::create('uploadTime'),
        ]),
    DatabaseTable::create('wcf1_user_rank_content')
        ->columns([
            ObjectIdDatabaseTableColumn::create('contentID'),
            IntDatabaseTableColumn::create('rankID')
                ->notNull(),
            IntDatabaseTableColumn::create('languageID'),
            NotNullVarchar255DatabaseTableColumn::create('title'),
        ])
        ->indices([
            DatabaseTablePrimaryIndex::create()
                ->columns(['contentID']),
            DatabaseTableIndex::create('id')
                ->columns(['rankID', 'languageID']),
        ])
        ->foreignKeys([
            DatabaseTableForeignKey::create()
                ->columns(['rankID'])
                ->referencedTable('wcf1_user_rank')
                ->referencedColumns(['rankID'])
                ->onDelete('CASCADE'),
            DatabaseTableForeignKey::create()
                ->columns(['languageID'])
                ->referencedTable('wcf1_language')
                ->referencedColumns(['languageID'])
                ->onDelete('CASCADE'),
        ]),
    DatabaseTable::create('wcf1_bbcode_content')
        ->columns([
            ObjectIdDatabaseTableColumn::create('contentID'),
            IntDatabaseTableColumn::create('bbcodeID')
                ->notNull(),
            IntDatabaseTableColumn::create('languageID'),
            NotNullVarchar255DatabaseTableColumn::create('buttonLabel'),
        ])
        ->indices([
            DatabaseTablePrimaryIndex::create()
                ->columns(['contentID']),
            DatabaseTableIndex::create('id')
                ->columns(['bbcodeID', 'languageID']),
        ])
        ->foreignKeys([
            DatabaseTableForeignKey::create()
                ->columns(['bbcodeID'])
                ->referencedTable('wcf1_bbcode')
                ->referencedColumns(['bbcodeID'])
                ->onDelete('CASCADE'),
            DatabaseTableForeignKey::create()
                ->columns(['languageID'])
                ->referencedTable('wcf1_language')
                ->referencedColumns(['languageID'])
                ->onDelete('CASCADE'),
        ]),
];