From d9b201f8b19343682a66a0d78428f63b3b83b87f Mon Sep 17 00:00:00 2001 From: Alexander Ebert Date: Sat, 22 Jun 2024 14:02:34 +0200 Subject: [PATCH] =?utf8?q?Remove=20files=20for=20the=20upgrade=205.5=20?= =?utf8?q?=E2=86=92=206.0?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- com.woltlab.wcf/files_pre_check.tar | Bin 40960 -> 0 bytes .../database/update_com.woltlab.wcf_6.0.php | 137 ------------------ .../update_com.woltlab.wcf_6.0_pre.php | 49 ------- ..._com.woltlab.wcf_6.0_reaction_fk_step2.php | 23 --- .../update_com.woltlab.wcf_6.0_style.php | 28 ---- ...com.woltlab.wcf_6.0_trackedVisit_step1.php | 45 ------ ...com.woltlab.wcf_6.0_trackedVisit_step2.php | 98 ------------- ...com.woltlab.wcf_6.0_trackedVisit_step3.php | 41 ------ 8 files changed, 421 deletions(-) delete mode 100644 com.woltlab.wcf/files_pre_check.tar delete mode 100644 wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0.php delete mode 100644 wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0_pre.php delete mode 100644 wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0_reaction_fk_step2.php delete mode 100644 wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0_style.php delete mode 100644 wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0_trackedVisit_step1.php delete mode 100644 wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0_trackedVisit_step2.php delete mode 100644 wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0_trackedVisit_step3.php diff --git a/com.woltlab.wcf/files_pre_check.tar b/com.woltlab.wcf/files_pre_check.tar deleted file mode 100644 index bcd5a8c02a364343f0f6a1ec541a5628b08cfbb6..0000000000000000000000000000000000000000 GIT binary patch literal 0 HcmV?d00001 literal 40960 zcmeHQe^c8?lg{6KirKAPO!mN7G6s@t^1cK+8)^w~7?Rps=O|&zwl1>dm1GFn%6Gq~ zXEf4`Bn#Vt?CqAQ#28C@)YIM5zotjF`qQo1bYMmHW#6CFZ+tg$t*iP?e|Wi5Z(LeI zk5l$O;&H6!?BrcJnFtUU3EaZp!{`59*M&pPvW;PneCIs4KAD~f3))o6@a`l#< z<~n`b3vKqx@dZ1w!_W@cFScg~mdj3OS2)U!;xm38N73~8)|NlT1^z7P+jTz}ZN&iL zmOGldoAF>H-BS;g64wSn#0kzG@W z6PG4*i$96_wXH4a;?%Yx7L9GjuY}wfh_k#~$!&IHh2oe!sI$W%^L+8Ab>-Ufq>!)z zdty1>1_ulKfisQRjpMq^y7GgF4QB!F63}1Qc6}`x2mTEoO*Mt8$OxMChm)X4IG;tdT=+cYmu{~56B;P{b6(iKU3Fm|I7{S zD+7rE8$a<0k4)%|6Aaju?TJq!XB5@p(TL=)%y!|Jg&WC^;Wv19x)+NX%kpDjju*~` zL#OYMV;mv|!3Qbj{t#O0ge+7^Pv8nk57-DAjsON6lG;5;$X(-9r@o+fHuEB9l12vW zQV4JfaEBySu1AN*=a=2X|L(9KUa~zYw0o9$8-lYPZv<&YUm{)nlUW$Do$bxnPPF-p z<$d{Lja}P=24JLNBt##5vAtxZWr8_}_f_Qr@Q8)8>6H8?ZgS;BkOP7kU?+g9uny_uWkL$ zdT;Qby}EpPTL0WqjyH+TPNBYo&Hhu4>#J(IG1i#1-)OoE;H4Q%hk3siJiTRNd11&iBU;*!7oZjn z3i-qmi{|} zEt3BoScn@}to;#B?#Ta8^lN4EzlO29Q{{i(L!S!sKbmy!>`9;GjvAmy2>ZS_bVkS` z1}IyRLj2uxK(eU^`v-43m)(<#vxCm%`EREkk#0@o;FGNDo((WXpBH*WPLXGlnWfz4 z8I?537t>LI*cgFiG_(URsQC2o5qtIVQ`np2!(isdiia{ut4cK57z;$t(JQD<>8i%|f&8jH=P4tIZ$TNqa zpAtEtN-{^RtoQer^XfeovH$x~gb7cDzi#9QC_60a3+}N0rXkjUl=`2!(`Z%pUzO8C zy)U%?Fm@Kqhl_mJ6Oo>kr~nIv4$$;Yru5(+;S72MdkDjc%ESKoIUK{g4wZ7wPtNv# z>A(>@dBXCaKTLq$3#Txt(Quuo$Yh!6=f}IeMr`&|xp}NRNVGhp4%vRIhHqm zVo}Ks6(kC%QL|gz!|t z%25a`ys$rZ9s5c6#dSt6s5Ci%UqoiG`KwRGJvc~KBntwIT_8EL4UJ1EtzNbd&sd$+ zQmqZQYRO4R%ZQs=iGes67QZQuAgKrSZ-R{XOe&AepML>)!TgjA=K5H zxk%TrEYruVycL{=0O+tsPFJ{Sem0fyFkv}c3%R;7BP*}{P}ce3aToFbsJ*>|o;huw zR#CfH0-i1v0o>vL4P!gE{%16rmH&Tu=|6fD`+wOp5igQiQ#3*d%hlUY-@k=vaqS@2 zJ`t~}4Y+(tSADhmxq3@pc6*$XAg>_@aSu6Q#?Nq%9B4j`8T?9_*zj%wFZ2l7??TH12 z-l=E_RCWIdofPS{dOwLvT^6DTZqAi_S(Z-Qd?1nuxr=yprI++z+yZc9)h zz0YG**kW|hkEJ8N=&|`q{JuClA{4T<Y4K7Z)`*% z7$tA|v5n=RQ|pr*3CgIC1Jqz8GhHL1EOF-HZ%Y2eIux2fk+U+QaPu_qBma}{y0S<~ zw^+!r#d3^QHN7=r8&ScYp(xr9Zl@7^A7@96fd;ThyVZ(5j>y!we~OfQJ!$%phrd6+ zv2cc#TnZ*+ZoWyRX=BdTfr(mGtQ0qtve)AFf^thr{u#B0Xg64qsa4>xv_W6;f;;@b z<2li5bjG9e!&)xsQ|P$E{~JwXJL~@&&C35P9DKO98UN24;*b=0%$`i6TXrR7&xQ_q zs$t-$J-~-S#flTUoZ!yt?3^0!&|7qknjEf0EirWA;gC^KkEk7>_{e0#qBTHk7geTE zp<=E-V%S%KzHYu+M9St^uJZ+FPzXY&3>`GBF>1WamYDZl`!mc998Tv7sS|HUO}8NY zl^YN|WWXWJrPzjm83yN^Nw6Kiw;%Zvr~e_Kt~1f`{+=4CsC7Mp2ld!6@F%Rs9meaE zlk@KR+5YL}(aCr%EBbBOx*);!^w|B6Lmxd*P|OooWA*r{}#pVpMU>pXZ#IwsX6?VR zQ}zFAa(bvgitB$c7qAKFP*bIkS^hguGJdbc*1YQs>?h&y&eD5_fxKZF^rHQbD(UrAsHg-1{)|>HSHa5^+mmJx~ffoMn;ut+urj~{AFHljR3z#aU6;J5BogzW2t<8`J_+ZeF*HcDk?WxezGr3oj5N?7 z7!pVs)}eob|w?-5OTav$A=4!bo+CSbjd8v<7J1N=w4O}6o;6}OU4XJJWaIokV+}*3>*~i=SFpWCUGm5 z3BXE%x?;%eurV!YYCIEhfgE;8T&Kcn<4!{l{!W=4*z8P9BzHjCm|BBQpxHx;0xjKFtjy_%M9$x{1X<&0{z{3t2(^V%r^Ep)pph!%;^WV8 zCO>`&tPS7Tqqveg(`WQ9^(j0@nHysZt3@+(>0f4<;)jQ3o?IEsD-(oS8r9<1a0qZZ+1VHCdH%i z7GP46O8KwIXjA4ugNI~sxJ~GsSDS{9s&be|n_5fz=0nK=px3W51 zhPu2MlG}-z3t3@4^NN(31SFGz0;Yb;(DSev%I8*^$oW!^#*@>#s9se4mt@9LhRCFf z&fGjfh_7o~L4S-etANcbc;307879wzzEgV>dKWcSIpxlq0}V4nXo(&#gM3O4&=~u! zTGA9t3w(Wn7p+s{kUvsFv;v)_J;COHn)jsXmmJRcs6%f$D=gX3SE5B;AsB1()iwIo_o*u&K2W=x;9f;JA6p^N7!ykr@Ng3@}4@-sKC+|L&P z%FMW6M)CE6^hJ?KNm+?gnSf@8O=g}iL2)mW>Ja$={vX3HlCK2R=8++ibP9-wl?r`g zrNQ&ib65 zx?O&%qCyEJ>!7ez7nG!>aVwG=a2TBMSqObnMU+9aAgZ?H5~ zxnJWmS08H*Z7~Lx*77w>orT1AgOgzhGa(0TP$kLW8dOj>iV-OgaZ%J;L}|)%kOIKP z23}tH$iQl2pC_Ht{5%HK2E1CmNI}Ysbfs!h40jJBM90W1>`-@L(F~#X242(26?Uk7 zgIH0JZ=l0D!PH%=+2j*nnqt)olLAs0MD{FW5EML361;lVqTEa`I++cMq`0MstLAE` zmqE)&Q+iBH^_*s`+Qvt*L{A7XEl)FJor7L^z@@5QCyP z(cqGCA7mhSGYPG^77B#mGf>w%o zJ+%Z-lM0QMF5n?zie>B(!3~P0;)S*RB#G%GxQtxB9aNJH@6DnWt<0+bB1C?$0@^lN zBp9*_<~G-G-M{k=h+P~YjVNNI1kFf>x7~1?NRgx>X*@k&$hx38K^UAEQ4@{Ph^K5u zHe!8_`{}r!Brh8UFC&|KK-Gj}aF0jS#4G7?+LV)t)yJ7@(P~pFnhd2TXJzuD@RJ8% z(9HsGpx|=p+{5a93MoUJB&b`>+vfqZBaa2YRFeitr8~CJUeUIKwDkz{Sp2K+rPEvc zP}QCkq^zV~kjKjklrP05FAAY0Z732|8}dqls*04MY#v@hE6*N5a1sBAGLh;eLN&-e zDKDwc8Qj70U@UF{DS|x21JdwN13zsW# zA2!mFQjao)mb=2OBxK=n0nW8Em|1SOABHqb-{INZ#5(-X_DG1ju2z=U-3{HoU^OE1 zF>a1+8E6y#gFh+t@VMJKJ7;+Q^$Bg$NPhS?VDMJ*%j;Kwd^e;X0!4DpFY(eIh4N{(?BGV#bEO2(}f-}E1xW@Y#PqA>C^UM+Sn{N5C8sHXXayd zBzW|(`lqDjBS_^SkS~o+eORr0j;+`Xz>jJ-NF<>lrySEhmNyiKKVn}`wdeDp_IecI z(*7S(mMeVKL)jNWVSC?F&-_vERlfhH(QFyn=RY)BrcpirLFM5?z1R1Dil-fj-SSc^ zn9KLt=ui2?LF~<>4T`OLi?(y(%fhl7G)uoCO7746s~!vir__s|;2;Ou!z^&^UY|dJ zyZ71|;X!NdcxoW5mXGGnJprQl`giugnN1>!VphgD_M>C$qIyq@x>kVjadjwQT;WL= z!R-nV+9h`lpPpOvxu;zc@5e#-Wq-cw@>BX&Da+NahYyn5K)G)zI_LRw`nno?_f?ID z8}Y*mF4gY{x%4O^O5OkFD82K_u44ZOEe0t8Je5% zl^3H0D4VO3DK>x(+X@s7h<-L-;kmz~XpAjzDF?(MI*47wq-pC#$M79L{vmxE&;<)vz#k~Ot%>03Pt2}|ysGLVp$69erKS4FTq0;KX@e67#7;n4Ra;d}88G1zoK zA5+F|zM@zi6}^nwY09EbnS_fe291t>6cw%s$xGFvqw@W#^M!8*UraO0%u7OlEgV~B zYo|~NV(o02MT1l$)OAW`6wcB>7nv7U7zyuItc0brqwM~~WMn}P<)0rKchUHd=NKzS zfOo`ycoU)`=v;c{v>`W>>uIC_H-8Nd&DZOx+)$vYf)}UGpgY z8#|rvW7?{_R2--{P;sE*K*fQI0~H4<4pbbdI8bq*;y}fLiUSn~Dh^Z}s5nq@pyEKq nfr|ptq9^ diff --git a/wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0.php b/wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0.php deleted file mode 100644 index 1d030f413f..0000000000 --- a/wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0.php +++ /dev/null @@ -1,137 +0,0 @@ - - */ - -use wcf\system\database\table\column\BigintDatabaseTableColumn; -use wcf\system\database\table\column\DefaultFalseBooleanDatabaseTableColumn; -use wcf\system\database\table\column\EnumDatabaseTableColumn; -use wcf\system\database\table\column\MediumtextDatabaseTableColumn; -use wcf\system\database\table\column\NotNullInt10DatabaseTableColumn; -use wcf\system\database\table\column\NotNullVarchar255DatabaseTableColumn; -use wcf\system\database\table\column\SmallintDatabaseTableColumn; -use wcf\system\database\table\column\TinyintDatabaseTableColumn; -use wcf\system\database\table\column\VarbinaryDatabaseTableColumn; -use wcf\system\database\table\column\VarcharDatabaseTableColumn; -use wcf\system\database\table\DatabaseTable; -use wcf\system\database\table\index\DatabaseTableForeignKey; -use wcf\system\database\table\index\DatabaseTablePrimaryIndex; -use wcf\system\database\table\PartialDatabaseTable; - -return [ - PartialDatabaseTable::create('wcf1_acp_template') - ->columns([ - NotNullInt10DatabaseTableColumn::create('packageID'), - ]), - // This needs to be separate, because the FK needs to be adjusted first. - PartialDatabaseTable::create('wcf1_article') - ->foreignKeys([ - DatabaseTableForeignKey::create() - ->columns(['categoryID']) - ->referencedTable('wcf1_category') - ->referencedColumns(['categoryID']) - ->onDelete('CASCADE'), - ]), - PartialDatabaseTable::create('wcf1_article') - ->columns([ - SmallintDatabaseTableColumn::create('attachments') - ->length(5) - ->notNull() - ->defaultValue(0), - NotNullInt10DatabaseTableColumn::create('categoryID'), - ]), - PartialDatabaseTable::create('wcf1_captcha_question') - ->columns([ - NotNullInt10DatabaseTableColumn::create('views') - ->defaultValue(0), - NotNullInt10DatabaseTableColumn::create('correctSubmissions') - ->defaultValue(0), - NotNullInt10DatabaseTableColumn::create('incorrectSubmissions') - ->defaultValue(0), - ]), - PartialDatabaseTable::create('wcf1_language_item') - ->columns([ - NotNullInt10DatabaseTableColumn::create('packageID'), - ]), - PartialDatabaseTable::create('wcf1_language') - ->columns([ - VarcharDatabaseTableColumn::create('locale') - ->notNull() - ->length(50) - ->defaultValue(''), - ]), - PartialDatabaseTable::create('wcf1_package_installation_node') - ->columns([ - NotNullVarchar255DatabaseTableColumn::create('nodeType'), - ]), - DatabaseTable::create('wcf1_package_audit_log') - ->columns([ - BigintDatabaseTableColumn::create('logID') - ->length(20) - ->notNull() - ->autoIncrement(), - MediumtextDatabaseTableColumn::create('payload') - ->notNull(), - NotNullVarchar255DatabaseTableColumn::create('time'), - NotNullVarchar255DatabaseTableColumn::create('wcfVersion'), - NotNullVarchar255DatabaseTableColumn::create('requestId'), - ]) - ->indices([ - DatabaseTablePrimaryIndex::create() - ->columns(['logID']), - ]), - PartialDatabaseTable::create('wcf1_package_installation_file_log') - ->columns([ - NotNullInt10DatabaseTableColumn::create('packageID'), - VarbinaryDatabaseTableColumn::create('sha256') - ->length(32) - ->defaultValue(null), - BigintDatabaseTableColumn::create('lastUpdated') - ->length(20) - ->defaultValue(null), - ]), - PartialDatabaseTable::create('wcf1_package_installation_plugin') - ->columns([ - NotNullInt10DatabaseTableColumn::create('packageID'), - ]), - PartialDatabaseTable::create('wcf1_package_installation_sql_log') - ->columns([ - NotNullInt10DatabaseTableColumn::create('packageID'), - ]), - PartialDatabaseTable::create('wcf1_page') - ->columns([ - TinyintDatabaseTableColumn::create('isLandingPage') - ->drop(), - ]), - PartialDatabaseTable::create('wcf1_style') - ->columns([ - EnumDatabaseTableColumn::create('apiVersion') - ->drop(), - ]), - PartialDatabaseTable::create('wcf1_user_group_option') - ->columns([ - NotNullInt10DatabaseTableColumn::create('packageID'), - ]), - PartialDatabaseTable::create('wcf1_user') - ->columns([ - TinyintDatabaseTableColumn::create('enableGravatar') - ->drop(), - VarcharDatabaseTableColumn::create('gravatarFileExtension') - ->drop(), - ]), - PartialDatabaseTable::create('wcf1_package_compatibility') - ->drop(), - PartialDatabaseTable::create('wcf1_package_update_compatibility') - ->drop(), - PartialDatabaseTable::create('wcf1_package_update_optional') - ->drop(), - PartialDatabaseTable::create('wcf1_user_notification_to_user') - ->drop(), - PartialDatabaseTable::create('wcf1_cli_history') - ->drop(), -]; diff --git a/wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0_pre.php b/wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0_pre.php deleted file mode 100644 index 7fdc723c55..0000000000 --- a/wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0_pre.php +++ /dev/null @@ -1,49 +0,0 @@ - - */ - -use wcf\system\database\table\column\BigintDatabaseTableColumn; -use wcf\system\database\table\column\MediumtextDatabaseTableColumn; -use wcf\system\database\table\column\NotNullVarchar255DatabaseTableColumn; -use wcf\system\database\table\column\VarbinaryDatabaseTableColumn; -use wcf\system\database\table\DatabaseTable; -use wcf\system\database\table\index\DatabaseTablePrimaryIndex; -use wcf\system\database\table\PartialDatabaseTable; - -return [ - PartialDatabaseTable::create('wcf1_package_installation_node') - ->columns([ - NotNullVarchar255DatabaseTableColumn::create('nodeType'), - ]), - DatabaseTable::create('wcf1_package_audit_log') - ->columns([ - BigintDatabaseTableColumn::create('logID') - ->length(20) - ->notNull() - ->autoIncrement(), - MediumtextDatabaseTableColumn::create('payload') - ->notNull(), - NotNullVarchar255DatabaseTableColumn::create('time'), - NotNullVarchar255DatabaseTableColumn::create('wcfVersion'), - NotNullVarchar255DatabaseTableColumn::create('requestId'), - ]) - ->indices([ - DatabaseTablePrimaryIndex::create() - ->columns(['logID']), - ]), - PartialDatabaseTable::create('wcf1_package_installation_file_log') - ->columns([ - VarbinaryDatabaseTableColumn::create('sha256') - ->length(32) - ->defaultValue(null), - BigintDatabaseTableColumn::create('lastUpdated') - ->length(20) - ->defaultValue(null), - ]), -]; diff --git a/wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0_reaction_fk_step2.php b/wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0_reaction_fk_step2.php deleted file mode 100644 index da2498e4b8..0000000000 --- a/wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0_reaction_fk_step2.php +++ /dev/null @@ -1,23 +0,0 @@ - - */ - -use wcf\system\database\table\index\DatabaseTableForeignKey; -use wcf\system\database\table\PartialDatabaseTable; - -return [ - PartialDatabaseTable::create('wcf1_like') - ->foreignKeys([ - DatabaseTableForeignKey::create() - ->columns(['reactionTypeID']) - ->referencedTable('wcf1_reaction_type') - ->referencedColumns(['reactionTypeID']) - ->onDelete('CASCADE'), - ]), -]; diff --git a/wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0_style.php b/wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0_style.php deleted file mode 100644 index 1fa8335115..0000000000 --- a/wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0_style.php +++ /dev/null @@ -1,28 +0,0 @@ - - */ - -use wcf\system\database\table\column\DefaultFalseBooleanDatabaseTableColumn; -use wcf\system\database\table\column\MediumtextDatabaseTableColumn; -use wcf\system\database\table\PartialDatabaseTable; - -return [ - PartialDatabaseTable::create('wcf1_style') - ->columns([ - DefaultFalseBooleanDatabaseTableColumn::create('hasDarkMode'), - ]), - PartialDatabaseTable::create('wcf1_style_variable') - ->columns([ - MediumtextDatabaseTableColumn::create('defaultValueDarkMode'), - ]), - PartialDatabaseTable::create('wcf1_style_variable_value') - ->columns([ - MediumtextDatabaseTableColumn::create('variableValueDarkMode'), - ]), -]; diff --git a/wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0_trackedVisit_step1.php b/wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0_trackedVisit_step1.php deleted file mode 100644 index 84306eb696..0000000000 --- a/wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0_trackedVisit_step1.php +++ /dev/null @@ -1,45 +0,0 @@ - - */ - -use wcf\system\database\table\index\DatabaseTableForeignKey; -use wcf\system\database\table\PartialDatabaseTable; - -return [ - PartialDatabaseTable::create('wcf1_tracked_visit') - ->foreignKeys([ - DatabaseTableForeignKey::create() - ->columns(['objectTypeID']) - ->referencedTable('wcf1_object_type') - ->referencedColumns(['objectTypeID']) - ->onDelete('CASCADE') - ->drop(), - DatabaseTableForeignKey::create() - ->columns(['userID']) - ->referencedTable('wcf1_user') - ->referencedColumns(['userID']) - ->onDelete('CASCADE') - ->drop(), - ]), - PartialDatabaseTable::create('wcf1_tracked_visit_type') - ->foreignKeys([ - DatabaseTableForeignKey::create() - ->columns(['objectTypeID']) - ->referencedTable('wcf1_object_type') - ->referencedColumns(['objectTypeID']) - ->onDelete('CASCADE') - ->drop(), - DatabaseTableForeignKey::create() - ->columns(['userID']) - ->referencedTable('wcf1_user') - ->referencedColumns(['userID']) - ->onDelete('CASCADE') - ->drop(), - ]), -]; diff --git a/wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0_trackedVisit_step2.php b/wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0_trackedVisit_step2.php deleted file mode 100644 index 6185706796..0000000000 --- a/wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0_trackedVisit_step2.php +++ /dev/null @@ -1,98 +0,0 @@ - - */ - -use wcf\system\database\table\index\DatabaseTableIndex; -use wcf\system\database\table\PartialDatabaseTable; - -return [ - PartialDatabaseTable::create('wcf1_tracked_visit') - ->indices([ - DatabaseTableIndex::create('visitTime') - ->columns([ - 'visitTime', - ]), - DatabaseTableIndex::create('userID_objectTypeID_objectID') - ->type(DatabaseTableIndex::UNIQUE_TYPE) - ->columns([ - 'userID', - 'objectTypeID', - 'objectID', - ]), - DatabaseTableIndex::create('') - ->type(DatabaseTableIndex::UNIQUE_TYPE) - ->columns([ - 'objectTypeID', - 'objectID', - 'userID', - ]) - ->drop(), - DatabaseTableIndex::create('') - ->type(DatabaseTableIndex::UNIQUE_TYPE) - ->columns([ - 'userID', - 'visitTime', - ]) - ->drop(), - DatabaseTableIndex::create('objectTypeID') - ->type(DatabaseTableIndex::UNIQUE_TYPE) - ->columns([ - 'objectTypeID', - 'objectID', - 'userID', - ]) - ->drop(), - DatabaseTableIndex::create('userID') - ->columns([ - 'userID', - 'visitTime', - ]) - ->drop(), - ]), - PartialDatabaseTable::create('wcf1_tracked_visit_type') - ->indices([ - DatabaseTableIndex::create('visitTime') - ->columns([ - 'visitTime', - ]), - DatabaseTableIndex::create('userID_objectTypeID') - ->type(DatabaseTableIndex::UNIQUE_TYPE) - ->columns([ - 'userID', - 'objectTypeID', - ]), - DatabaseTableIndex::create('') - ->type(DatabaseTableIndex::UNIQUE_TYPE) - ->columns([ - 'objectTypeID', - 'userID', - ]) - ->drop(), - DatabaseTableIndex::create('') - ->type(DatabaseTableIndex::UNIQUE_TYPE) - ->columns([ - 'userID', - 'visitTime', - ]) - ->drop(), - DatabaseTableIndex::create('objectTypeID') - ->type(DatabaseTableIndex::UNIQUE_TYPE) - ->columns([ - 'objectTypeID', - 'userID', - ]) - ->drop(), - DatabaseTableIndex::create('userID') - ->columns([ - 'userID', - 'visitTime', - ]) - ->drop(), - ]), -]; diff --git a/wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0_trackedVisit_step3.php b/wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0_trackedVisit_step3.php deleted file mode 100644 index 3ed0d7ebea..0000000000 --- a/wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.0_trackedVisit_step3.php +++ /dev/null @@ -1,41 +0,0 @@ - - */ - -use wcf\system\database\table\index\DatabaseTableForeignKey; -use wcf\system\database\table\PartialDatabaseTable; - -return [ - PartialDatabaseTable::create('wcf1_tracked_visit') - ->foreignKeys([ - DatabaseTableForeignKey::create() - ->columns(['objectTypeID']) - ->referencedTable('wcf1_object_type') - ->referencedColumns(['objectTypeID']) - ->onDelete('CASCADE'), - DatabaseTableForeignKey::create() - ->columns(['userID']) - ->referencedTable('wcf1_user') - ->referencedColumns(['userID']) - ->onDelete('CASCADE'), - ]), - PartialDatabaseTable::create('wcf1_tracked_visit_type') - ->foreignKeys([ - DatabaseTableForeignKey::create() - ->columns(['objectTypeID']) - ->referencedTable('wcf1_object_type') - ->referencedColumns(['objectTypeID']) - ->onDelete('CASCADE'), - DatabaseTableForeignKey::create() - ->columns(['userID']) - ->referencedTable('wcf1_user') - ->referencedColumns(['userID']) - ->onDelete('CASCADE'), - ]), -]; -- 2.20.1