74 lines
2.5 KiB
PHP
74 lines
2.5 KiB
PHP
<?php
|
|
|
|
namespace Zotlabs\Update;
|
|
|
|
class _1231 {
|
|
|
|
function run() {
|
|
|
|
q("START TRANSACTION");
|
|
|
|
if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) {
|
|
$r1 = q("DROP INDEX item_uid");
|
|
$r2 = q("DROP INDEX item_aid");
|
|
$r3 = q("DROP INDEX item_restrict");
|
|
$r4 = q("DROP INDEX item_flags");
|
|
$r5 = q("DROP INDEX item_private");
|
|
$r6 = q("DROP INDEX item_starred");
|
|
$r7 = q("DROP INDEX item_thread_top");
|
|
$r8 = q("DROP INDEX item_retained");
|
|
$r9 = q("DROP INDEX item_deleted");
|
|
$r10 = q("DROP INDEX item_type");
|
|
$r11 = q("DROP INDEX item_hidden");
|
|
$r12 = q("DROP INDEX item_unpublished");
|
|
$r13 = q("DROP INDEX item_delayed");
|
|
$r14 = q("DROP INDEX item_pending_remove");
|
|
$r15 = q("DROP INDEX item_blocked");
|
|
$r16 = q("DROP INDEX item_unseen");
|
|
$r17 = q("DROP INDEX item_relay");
|
|
$r18 = q("DROP INDEX item_verified");
|
|
$r19 = q("DROP INDEX item_notshown");
|
|
|
|
$r20 = q("create index item_uid_item_type on item (uid, item_type)");
|
|
$r21 = q("create index item_uid_item_thread_top on item (uid, item_thread_top)");
|
|
$r22 = q("create index item_uid_item_blocked on item (uid, item_blocked)");
|
|
$r23 = q("create index item_uid_item_wall on item (uid, item_wall)");
|
|
$r24 = q("create index item_uid_item_starred on item (uid, item_starred)");
|
|
$r25 = q("create index item_uid_item_retained on item (uid, item_retained)");
|
|
$r26 = q("create index item_uid_item_private on item (uid, item_private)");
|
|
$r27 = q("create index item_uid_resource_type on item (uid, resource_type)");
|
|
$r28 = q("create index item_item_deleted_item_pending_remove_changed on item (item_deleted, item_pending_remove, changed)");
|
|
$r29 = q("create index item_item_pending_remove_changed on item (item_pending_remove, changed)");
|
|
|
|
$r30 = q("create index item_thr_parent on item (thr_parent)");
|
|
|
|
$r = (
|
|
$r1 && $r2 && $r3 && $r4 && $r5 && $r6 && $r7 && $r8 && $r9 && $r10 && $r11 && $r12 && $r13 && $r14
|
|
&& $r15 && $r16 && $r17 && $r18 && $r19 && $r20 && $r21 && $r22 && $r23 && $r24 && $r25 && $r26
|
|
&& $r27 && $r28 && $r29 && $r30
|
|
);
|
|
}
|
|
else {
|
|
|
|
$r1 = q("ALTER TABLE item DROP INDEX item_unseen");
|
|
$r2 = q("ALTER TABLE item DROP INDEX item_relay");
|
|
$r3 = q("ALTER TABLE item DROP INDEX item_verified");
|
|
$r4 = q("ALTER TABLE item DROP INDEX item_notshown");
|
|
|
|
$r5 = q("ALTER TABLE item ADD INDEX thr_parent (thr_parent)");
|
|
|
|
$r = ($r1 && $r2 && $r3 && $r4 && $r5);
|
|
}
|
|
|
|
if($r) {
|
|
q("COMMIT");
|
|
return UPDATE_SUCCESS;
|
|
}
|
|
|
|
q("ROLLBACK");
|
|
return UPDATE_FAILED;
|
|
|
|
}
|
|
|
|
}
|