blob: 536a219d8072f4d49eb7b1dd5371a3096c0bcd9c (
plain) (
blame)
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
|
<?php
namespace Zotlabs\Update;
class _1156 {
function run() {
$r1 = q("ALTER TABLE mail ADD conv_guid CHAR( 255 ) NOT NULL DEFAULT '' ");
$r2 = q("create index conv_guid on mail ( conv_guid ) ");
$r3 = q("select mail.id, mail.convid, conv.guid from mail left join conv on mail.convid = conv.id where true");
if($r3) {
foreach($r3 as $rr) {
if($rr['convid']) {
q("update mail set conv_guid = '%s' where id = %d",
dbesc($rr['guid']),
intval($rr['id'])
);
}
}
}
if($r1 && $r2)
return UPDATE_SUCCESS;
return UPDATE_FAILED;
}
}
|
