diff options
| author | Andrew Manning <tamanning@zoho.com> | 2018-02-20 21:11:59 -0500 |
|---|---|---|
| committer | Andrew Manning <tamanning@zoho.com> | 2018-02-20 21:11:59 -0500 |
| commit | 8e5c1135c3e2644ea8501eda067e2b994faa44ab (patch) | |
| tree | 6b72038214359dcf8eff040a68874583e7174800 /Zotlabs/Update/_1156.php | |
| parent | 89a825cd038df7da609d64ef0254ba58caaede31 (diff) | |
| parent | 85a6dd60316eefbdaf072e59621d681a3cf2546b (diff) | |
| download | volse-hubzilla-8e5c1135c3e2644ea8501eda067e2b994faa44ab.tar.gz volse-hubzilla-8e5c1135c3e2644ea8501eda067e2b994faa44ab.tar.bz2 volse-hubzilla-8e5c1135c3e2644ea8501eda067e2b994faa44ab.zip | |
Merge branch 'dev' into oauth2
Diffstat (limited to 'Zotlabs/Update/_1156.php')
| -rw-r--r-- | Zotlabs/Update/_1156.php | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/Zotlabs/Update/_1156.php b/Zotlabs/Update/_1156.php new file mode 100644 index 000000000..536a219d8 --- /dev/null +++ b/Zotlabs/Update/_1156.php @@ -0,0 +1,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; +} + + +}
\ No newline at end of file |