<div dir="ltr">For reports a view can work.<br><br><div class="gmail_quote"><div dir="ltr">El vie., 21 jul. 2017 a las 2:49, Katrin (<<a href="mailto:katrin.fischer.83@web.de">katrin.fischer.83@web.de</a>>) escribió:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<p>Merging the tables can only be a long term solution, but we need
a solution for the stable branches now. If we agree to merge, not
only reports will be affected for some of the tables, it will be a
lot of work.<br>
</p></div><div text="#000000" bgcolor="#FFFFFF">
<p>Katrin<br>
</p></div><div text="#000000" bgcolor="#FFFFFF">
<br>
<div class="m_-5844685952089073016moz-cite-prefix">On 21.07.2017 05:57, David Cook wrote:<br>
</div>
<blockquote type="cite">
<div class="m_-5844685952089073016WordSection1">
<p class="MsoNormal"><a name="m_-5844685952089073016__MailEndCompose"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Jonathan,
have you thought anymore about merging the deleted* tables
back in with the active tables? This would have the
benefit of fixing problems with things like “Checkout
history” where issues containing deleted borrowers or
deleted items have these details nullified and thus
disappear from the system. <u></u><u></u></span></a></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">I
suppose we’d have to make sure the deleted flag is indexed,
and it would mean changing many SQL reports not to include
deleted records… so that might be easier said than done.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Alternatively,
maybe we need more robust logical (ie code) ways of managing
the relationships between active and inactive (ie deleted)
data? I mean… what’s the point of keeping a history of data
if we can’t use it?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">David
Cook<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Systems
Librarian<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Prosentient
Systems<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">72/330
Wattle St<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Ultimo,
NSW 2007<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Australia<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Office:
02 9212 0899<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Direct:
02 8005 0595<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" lang="EN-US">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" lang="EN-US"> <a class="m_-5844685952089073016moz-txt-link-abbreviated" href="mailto:koha-devel-bounces@lists.koha-community.org" target="_blank">koha-devel-bounces@lists.koha-community.org</a>
[<a class="m_-5844685952089073016moz-txt-link-freetext" href="mailto:koha-devel-bounces@lists.koha-community.org" target="_blank">mailto:koha-devel-bounces@lists.koha-community.org</a>] <b>On
Behalf Of </b>Jonathan Druart<br>
<b>Sent:</b> Friday, 21 July 2017 3:23 AM<br>
<b>To:</b> <a class="m_-5844685952089073016moz-txt-link-abbreviated" href="mailto:koha-devel@lists.koha-community.org" target="_blank">koha-devel@lists.koha-community.org</a><br>
<b>Subject:</b> Re: [Koha-devel] AUTO_INCREMENT fix -
prevent data lost<u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">And see bug 18966 for a third (last!?)
round. I tried to resume in the description of the bug
what has been done and what I propose to move forward.<br>
BE INVOLVED!<u></u><u></u></p>
</div>
<div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">On Wed, 12 Jul 2017 at 15:11
Jonathan Druart <<a href="mailto:jonathan.druart@bugs.koha-community.org" target="_blank">jonathan.druart@bugs.koha-community.org</a>>
wrote:<u></u><u></u></p>
</div>
<blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">Hi devs,<u></u><u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Please
review and test <a href="https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix" target="_blank">https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix</a><u></u><u></u></p>
</div>
<p class="MsoNormal">I have added a ref
from the Koha on Debian wiki page <a href="https://wiki.koha-community.org/wiki/Koha_on_Debian#Further_Configuration" target="_blank">https://wiki.koha-community.org/wiki/Koha_on_Debian#Further_Configuration</a><u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">It sounds
like I should add it somewhere more
visible, but do not find where, any ideas?<u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">See also bug
18931 where I would like to add a warning on
the about page if data are corrupted.<u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Please review
quickly, that way we can share the tips on the
general mailing list.<u></u><u></u></p>
</div>
<p class="MsoNormal">Cheers,<u></u><u></u></p>
</div>
<p class="MsoNormal">Jonathan<u></u><u></u></p>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="m_-5844685952089073016mimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
Koha-devel mailing list
<a class="m_-5844685952089073016moz-txt-link-abbreviated" href="mailto:Koha-devel@lists.koha-community.org" target="_blank">Koha-devel@lists.koha-community.org</a>
<a class="m_-5844685952089073016moz-txt-link-freetext" href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a>
website : <a class="m_-5844685952089073016moz-txt-link-freetext" href="http://www.koha-community.org/" target="_blank">http://www.koha-community.org/</a>
git : <a class="m_-5844685952089073016moz-txt-link-freetext" href="http://git.koha-community.org/" target="_blank">http://git.koha-community.org/</a>
bugs : <a class="m_-5844685952089073016moz-txt-link-freetext" href="http://bugs.koha-community.org/" target="_blank">http://bugs.koha-community.org/</a></pre>
</blockquote>
<br>
</div>
_______________________________________________<br>
Koha-devel mailing list<br>
<a href="mailto:Koha-devel@lists.koha-community.org" target="_blank">Koha-devel@lists.koha-community.org</a><br>
<a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" rel="noreferrer" target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br>
website : <a href="http://www.koha-community.org/" rel="noreferrer" target="_blank">http://www.koha-community.org/</a><br>
git : <a href="http://git.koha-community.org/" rel="noreferrer" target="_blank">http://git.koha-community.org/</a><br>
bugs : <a href="http://bugs.koha-community.org/" rel="noreferrer" target="_blank">http://bugs.koha-community.org/</a></blockquote></div></div><div dir="ltr">-- <br></div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div style="color:rgb(117,117,117);font-family:"helvetica neue",helvetica,arial,sans-serif;font-size:12.8px">Tomás Cohen Arazi</div><div style="color:rgb(117,117,117);font-family:"helvetica neue",helvetica,arial,sans-serif;font-size:12.8px">Theke Solutions (<a href="http://theke.io/">https://theke.io</a>)<br>✆ +54 9351 3513384<br>GPG: B2F3C15F</div></div></div>