#
#
#
# SQL-Ledger Dataset name and Dataset Owner
#
SLDB=sqlledger
SLOWN=SQL-Ledger_Owner

#
# Ledger-SMB Dataset name and Dataset Owner
#
LSDB=lsmbprod
LSOWN=ledgersmb

# Installation directory

IDIR=`pwd`

psql template1 -c "DROP DATABASE ${LSDB};"

pg_dump ${SLDB} > sl2ls.sql

sed -i -e "s/${SLOWN}/${LSOWN}/" sl2ls.sql
sed -i -e "s/SQL_ASCII/LATIN1/" sl2ls.sql

createdb -O ${LSOWN} ${LSDB}

psql ${LSDB} ${LSOWN} -c "\i ${IDIR}/sql/Pg-central.sql"

psql template1 -c "ALTER USER ${LSOWN} WITH superuser;"

psql ${LSDB} ${LSOWN} -c "\i sl2ls.sql"

psql template1 -c "ALTER USER ${LSOWN} WITH nosuperuser;"

cd ${IDIR}/sql/legacy/

psql ${LSDB} ${LSOWN} -c "SELECT version FROM defaults;"

psql ${LSDB} ${LSOWN} -c "\i Pg-upgrade-2.6.12-2.6.17.sql"

psql ${LSDB} ${LSOWN} -c "SELECT version FROM defaults;"

psql ${LSDB} ${LSOWN} -c "\i Pg-upgrade-2.6.17-2.6.18.sql"

psql ${LSDB} ${LSOWN} -c "SELECT version FROM defaults;"

psql ${LSDB} ${LSOWN} -c "\i Pg-upgrade-2.6.18-2.6.19.sql"

echo '###############################################################'
echo
echo 'Should error with--> ERROR:  column "version" does not exist'
echo
echo '###############################################################'

psql ${LSDB} ${LSOWN} -c "SELECT version FROM defaults;"

psql ${LSDB} ${LSOWN} -c "update users_conf set password = md5('apasswrd');"

cd ${IDIR}

./import_members.pl users/members

psql ${LSDB} ${LSOWN} -c "SELECT * FROM users;"

exit
gs/4c/ee?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>tree</a><a class='active' href='/notmuch/commit/tags/4c/ee?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>commit</a><a href='/notmuch/diff/tags/4c/ee?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>diff</a></td><td class='form'><form class='right' method='get' action='/notmuch/log/tags/4c/ee'>
<input type='hidden' name='h' value='master'/><input type='hidden' name='id' value='fd54908da2b05c526dd3bee9b6dcd093214a220d'/><select name='qt'>
<option value='grep'>log msg</option>
<option value='author'>author</option>
<option value='committer'>committer</option>
<option value='range'>range</option>
</select>
<input class='txt' type='search' size='10' name='q' value=''/>
<input type='submit' value='search'/>
</form>
</td></tr></table>
<div class='path'>path: <a href='/notmuch/commit/?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>root</a>/<a href='/notmuch/commit/tags?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>tags</a>/<a href='/notmuch/commit/tags/4c?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>4c</a>/<a href='/notmuch/commit/tags/4c/ee?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>ee</a></div><div class='content'><div class='cgit-panel'><b>diff options</b><form method='get'><input type='hidden' name='h' value='master'/><input type='hidden' name='id' value='fd54908da2b05c526dd3bee9b6dcd093214a220d'/><table><tr><td colspan='2'/></tr><tr><td class='label'>context:</td><td class='ctrl'><select name='context' onchange='this.form.submit();'><option value='1'>1</option><option value='2'>2</option><option value='3' selected='selected'>3</option><option value='4'>4</option><option value='5'>5</option><option value='6'>6</option><option value='7'>7</option><option value='8'>8</option><option value='9'>9</option><option value='10'>10</option><option value='15'>15</option><option value='20'>20</option><option value='25'>25</option><option value='30'>30</option><option value='35'>35</option><option value='40'>40</option></select></td></tr><tr><td class='label'>space:</td><td class='ctrl'><select name='ignorews' onchange='this.form.submit();'><option value='0' selected='selected'>include</option><option value='1'>ignore</option></select></td></tr><tr><td class='label'>mode:</td><td class='ctrl'><select name='dt' onchange='this.form.submit();'><option value='0' selected='selected'>unified</option><option value='1'>ssdiff</option><option value='2'>stat only</option></select></td></tr><tr><td/><td class='ctrl'><noscript><input type='submit' value='reload'/></noscript></td></tr></table></form></div><table summary='commit info' class='commit-info'>
<tr><th>author</th><td>Jonas Smedegaard &lt;dr@jones.dk&gt;</td><td class='right'>2023-06-27 09:35:08 +0200</td></tr>
<tr><th>committer</th><td>Jonas Smedegaard &lt;dr@jones.dk&gt;</td><td class='right'>2023-06-27 09:35:08 +0200</td></tr>
<tr><th>commit</th><td colspan='2' class='oid'><a href='/notmuch/commit/tags/4c/ee?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>fd54908da2b05c526dd3bee9b6dcd093214a220d</a> (<a href='/notmuch/patch/tags/4c/ee?id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>patch</a>)</td></tr>
<tr><th>tree</th><td colspan='2' class='oid'><a href='/notmuch/tree/?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>c69c845069c99d1d01044f6fafda7c08433329c6</a> /<a href='/notmuch/tree/tags/4c/ee?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>tags/4c/ee</a></td></tr>
<tr><th>parent</th><td colspan='2' class='oid'><a href='/notmuch/commit/tags/4c/ee?h=master&amp;id=ba46132213560cf3335d53560d519c0ec0190da2'>ba46132213560cf3335d53560d519c0ec0190da2</a> (<a href='/notmuch/diff/tags/4c/ee?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d&amp;id2=ba46132213560cf3335d53560d519c0ec0190da2'>diff</a>)</td></tr></table>
<div class='commit-subject'><span class='decoration'><a class='branch-deco' href='/notmuch/log/tags/4c/ee?h=master'>master</a></span></div><div class='commit-msg'></div><div class='diffstat-header'><a href='/notmuch/diff/?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>Diffstat</a> (limited to 'tags/4c/ee')</div><table summary='diffstat' class='diffstat'><tr><td class='mode'>-rw-r--r--</td><td class='add'><a href='/notmuch/diff/tags/4c/ee/01293d0e-0c14-1a4a-0ede-3dca855ec1bf@gmail.com/debian?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>tags/4c/ee/01293d0e-0c14-1a4a-0ede-3dca855ec1bf@gmail.com/debian</a></td><td class='right'>0</td><td class='graph'><table summary='file diffstat' width='0%'><tr><td class='add' style='width: -nan%;'/><td class='rem' style='width: -nan%;'/><td class='none' style='width: -nan%;'/></tr></table></td></tr>
<tr><td class='mode'>-rw-r--r--</td><td class='add'><a href='/notmuch/diff/tags/4c/ee/01293d0e-0c14-1a4a-0ede-3dca855ec1bf@gmail.com/inbox?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>tags/4c/ee/01293d0e-0c14-1a4a-0ede-3dca855ec1bf@gmail.com/inbox</a></td><td class='right'>0</td><td class='graph'><table summary='file diffstat' width='0%'><tr><td class='add' style='width: -nan%;'/><td class='rem' style='width: -nan%;'/><td class='none' style='width: -nan%;'/></tr></table></td></tr>
<tr><td class='mode'>-rw-r--r--</td><td class='add'><a href='/notmuch/diff/tags/4c/ee/01293d0e-0c14-1a4a-0ede-3dca855ec1bf@gmail.com/old?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>tags/4c/ee/01293d0e-0c14-1a4a-0ede-3dca855ec1bf@gmail.com/old</a></td><td class='right'>0</td><td class='graph'><table summary='file diffstat' width='0%'><tr><td class='add' style='width: -nan%;'/><td class='rem' style='width: -nan%;'/><td class='none' style='width: -nan%;'/></tr></table></td></tr>
<tr><td class='mode'>-rw-r--r--</td><td class='add'><a href='/notmuch/diff/tags/4c/ee/057f7554-b1df-4ebc-9112-033e9cd89d62@EXCH01.datacom.local/attachment?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>tags/4c/ee/057f7554-b1df-4ebc-9112-033e9cd89d62@EXCH01.datacom.local/attachment</a></td><td class='right'>0</td><td class='graph'><table summary='file diffstat' width='0%'><tr><td class='add' style='width: -nan%;'/><td class='rem' style='width: -nan%;'/><td class='none' style='width: -nan%;'/></tr></table></td></tr>
<tr><td class='mode'>-rw-r--r--</td><td class='add'><a href='/notmuch/diff/tags/4c/ee/057f7554-b1df-4ebc-9112-033e9cd89d62@EXCH01.datacom.local/inbox?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>tags/4c/ee/057f7554-b1df-4ebc-9112-033e9cd89d62@EXCH01.datacom.local/inbox</a></td><td class='right'>0</td><td class='graph'><table summary='file diffstat' width='0%'><tr><td class='add' style='width: -nan%;'/><td class='rem' style='width: -nan%;'/><td class='none' style='width: -nan%;'/></tr></table></td></tr>
<tr><td class='mode'>-rw-r--r--</td><td class='add'><a href='/notmuch/diff/tags/4c/ee/057f7554-b1df-4ebc-9112-033e9cd89d62@EXCH01.datacom.local/old?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>tags/4c/ee/057f7554-b1df-4ebc-9112-033e9cd89d62@EXCH01.datacom.local/old</a></td><td class='right'>0</td><td class='graph'><table summary='file diffstat' width='0%'><tr><td class='add' style='width: -nan%;'/><td class='rem' style='width: -nan%;'/><td class='none' style='width: -nan%;'/></tr></table></td></tr>
<tr><td class='mode'>-rw-r--r--</td><td class='add'><a href='/notmuch/diff/tags/4c/ee/1094473167.515.31.camel@elzar.trd.linpro.no/skolelinux?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>tags/4c/ee/1094473167.515.31.camel@elzar.trd.linpro.no/skolelinux</a></td><td class='right'>0</td><td class='graph'><table summary='file diffstat' width='0%'><tr><td class='add' style='width: -nan%;'/><td class='rem' style='width: -nan%;'/><td class='none' style='width: -nan%;'/></tr></table></td></tr>
<tr><td class='mode'>-rw-r--r--</td><td class='add'><a href='/notmuch/diff/tags/4c/ee/10FAB952-CDE5-4C49-80DF-9928AEC450B2@garycmartin.com/sugar?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>tags/4c/ee/10FAB952-CDE5-4C49-80DF-9928AEC450B2@garycmartin.com/sugar</a></td><td class='right'>0</td><td class='graph'><table summary='file diffstat' width='0%'><tr><td class='add' style='width: -nan%;'/><td class='rem' style='width: -nan%;'/><td class='none' style='width: -nan%;'/></tr></table></td></tr>
<tr><td class='mode'>-rw-r--r--</td><td class='add'><a href='/notmuch/diff/tags/4c/ee/10FAB952-CDE5-4C49-80DF-9928AEC450B2@garycmartin.com/unread?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>tags/4c/ee/10FAB952-CDE5-4C49-80DF-9928AEC450B2@garycmartin.com/unread</a></td><td class='right'>0</td><td class='graph'><table summary='file diffstat' width='0%'><tr><td class='add' style='width: -nan%;'/><td class='rem' style='width: -nan%;'/><td class='none' style='width: -nan%;'/></tr></table></td></tr>
<tr><td class='mode'>-rw-r--r--</td><td class='add'><a href='/notmuch/diff/tags/4c/ee/1311108017.59044.YahooMailClassic@web161008.mail.bf1.yahoo.com/debian?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>tags/4c/ee/1311108017.59044.YahooMailClassic@web161008.mail.bf1.yahoo.com/debian</a></td><td class='right'>0</td><td class='graph'><table summary='file diffstat' width='0%'><tr><td class='add' style='width: -nan%;'/><td class='rem' style='width: -nan%;'/><td class='none' style='width: -nan%;'/></tr></table></td></tr>
<tr><td class='mode'>-rw-r--r--</td><td class='add'><a href='/notmuch/diff/tags/4c/ee/20080401104333.GJ22276@horacrux/debian?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>tags/4c/ee/20080401104333.GJ22276@horacrux/debian</a></td><td class='right'>0</td><td class='graph'><table summary='file diffstat' width='0%'><tr><td class='add' style='width: -nan%;'/><td class='rem' style='width: -nan%;'/><td class='none' style='width: -nan%;'/></tr></table></td></tr>
<tr><td class='mode'>-rw-r--r--</td><td class='add'><a href='/notmuch/diff/tags/4c/ee/20160930120007.0A09A3BA5@lxp5.free-owl.de/sys?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>tags/4c/ee/20160930120007.0A09A3BA5@lxp5.free-owl.de/sys</a></td><td class='right'>0</td><td class='graph'><table summary='file diffstat' width='0%'><tr><td class='add' style='width: -nan%;'/><td class='rem' style='width: -nan%;'/><td class='none' style='width: -nan%;'/></tr></table></td></tr>
<tr><td class='mode'>-rw-r--r--</td><td class='add'><a href='/notmuch/diff/tags/4c/ee/20160930120007.0A09A3BA5@lxp5.free-owl.de/unread?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>tags/4c/ee/20160930120007.0A09A3BA5@lxp5.free-owl.de/unread</a></td><td class='right'>0</td><td class='graph'><table summary='file diffstat' width='0%'><tr><td class='add' style='width: -nan%;'/><td class='rem' style='width: -nan%;'/><td class='none' style='width: -nan%;'/></tr></table></td></tr>
<tr><td class='mode'>-rw-r--r--</td><td class='add'><a href='/notmuch/diff/tags/4c/ee/4B05406E.7020300@enrgies.com/openmoko?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>tags/4c/ee/4B05406E.7020300@enrgies.com/openmoko</a></td><td class='right'>0</td><td class='graph'><table summary='file diffstat' width='0%'><tr><td class='add' style='width: -nan%;'/><td class='rem' style='width: -nan%;'/><td class='none' style='width: -nan%;'/></tr></table></td></tr>
<tr><td class='mode'>-rw-r--r--</td><td class='add'><a href='/notmuch/diff/tags/4c/ee/4B654B63C9A4614EA1F088B2490E8F3A069B5F5A@UCEXBWP009.ep.parl.union.eu/inbox?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>tags/4c/ee/4B654B63C9A4614EA1F088B2490E8F3A069B5F5A@UCEXBWP009.ep.parl.union.eu/inbox</a></td><td class='right'>0</td><td class='graph'><table summary='file diffstat' width='0%'><tr><td class='add' style='width: -nan%;'/><td class='rem' style='width: -nan%;'/><td class='none' style='width: -nan%;'/></tr></table></td></tr>
<tr><td class='mode'>-rw-r--r--</td><td class='add'><a href='/notmuch/diff/tags/4c/ee/4B654B63C9A4614EA1F088B2490E8F3A069B5F5A@UCEXBWP009.ep.parl.union.eu/old?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>tags/4c/ee/4B654B63C9A4614EA1F088B2490E8F3A069B5F5A@UCEXBWP009.ep.parl.union.eu/old</a></td><td class='right'>0</td><td class='graph'><table summary='file diffstat' width='0%'><tr><td class='add' style='width: -nan%;'/><td class='rem' style='width: -nan%;'/><td class='none' style='width: -nan%;'/></tr></table></td></tr>
<tr><td class='mode'>-rw-r--r--</td><td class='add'><a href='/notmuch/diff/tags/4c/ee/CAEPJg0SAiMHOe49vZ1GV_xxgbKtYYxr0E4LSzGAGcwyHVaN8bg@mail.gmail.com/debian?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>tags/4c/ee/CAEPJg0SAiMHOe49vZ1GV_xxgbKtYYxr0E4LSzGAGcwyHVaN8bg@mail.gmail.com/debian</a></td><td class='right'>0</td><td class='graph'><table summary='file diffstat' width='0%'><tr><td class='add' style='width: -nan%;'/><td class='rem' style='width: -nan%;'/><td class='none' style='width: -nan%;'/></tr></table></td></tr>
<tr><td class='mode'>-rw-r--r--</td><td class='add'><a href='/notmuch/diff/tags/4c/ee/CAH8mndKJmgfG9cca_yWN5AQw1Emum-tVs_5PJRX7pTrARzPLCA@mail.gmail.com/sugar?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>tags/4c/ee/CAH8mndKJmgfG9cca_yWN5AQw1Emum-tVs_5PJRX7pTrARzPLCA@mail.gmail.com/sugar</a></td><td class='right'>0</td><td class='graph'><table summary='file diffstat' width='0%'><tr><td class='add' style='width: -nan%;'/><td class='rem' style='width: -nan%;'/><td class='none' style='width: -nan%;'/></tr></table></td></tr>
<tr><td class='mode'>-rw-r--r--</td><td class='add'><a href='/notmuch/diff/tags/4c/ee/CAH8mndKJmgfG9cca_yWN5AQw1Emum-tVs_5PJRX7pTrARzPLCA@mail.gmail.com/unread?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>tags/4c/ee/CAH8mndKJmgfG9cca_yWN5AQw1Emum-tVs_5PJRX7pTrARzPLCA@mail.gmail.com/unread</a></td><td class='right'>0</td><td class='graph'><table summary='file diffstat' width='0%'><tr><td class='add' style='width: -nan%;'/><td class='rem' style='width: -nan%;'/><td class='none' style='width: -nan%;'/></tr></table></td></tr>
<tr><td class='mode'>-rw-r--r--</td><td class='add'><a href='/notmuch/diff/tags/4c/ee/Pine.LNX.4.55.0707131054020.16589@baffin/spi?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>tags/4c/ee/Pine.LNX.4.55.0707131054020.16589@baffin/spi</a></td><td class='right'>0</td><td class='graph'><table summary='file diffstat' width='0%'><tr><td class='add' style='width: -nan%;'/><td class='rem' style='width: -nan%;'/><td class='none' style='width: -nan%;'/></tr></table></td></tr>
<tr><td class='mode'>-rw-r--r--</td><td class='add'><a href='/notmuch/diff/tags/4c/ee/a04310103b5f0d25019ea@%255b195.97.163.50%255d/inbox?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>tags/4c/ee/a04310103b5f0d25019ea@%5b195.97.163.50%5d/inbox</a></td><td class='right'>0</td><td class='graph'><table summary='file diffstat' width='0%'><tr><td class='add' style='width: -nan%;'/><td class='rem' style='width: -nan%;'/><td class='none' style='width: -nan%;'/></tr></table></td></tr>
<tr><td class='mode'>-rw-r--r--</td><td class='add'><a href='/notmuch/diff/tags/4c/ee/a04310103b5f0d25019ea@%255b195.97.163.50%255d/old?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>tags/4c/ee/a04310103b5f0d25019ea@%5b195.97.163.50%5d/old</a></td><td class='right'>0</td><td class='graph'><table summary='file diffstat' width='0%'><tr><td class='add' style='width: -nan%;'/><td class='rem' style='width: -nan%;'/><td class='none' style='width: -nan%;'/></tr></table></td></tr>
<tr><td class='mode'>-rw-r--r--</td><td class='add'><a href='/notmuch/diff/tags/4c/ee/handler.692749.D692749.135414363813777.ackdone@bugs.debian.org/debian?h=master&amp;id=fd54908da2b05c526dd3bee9b6dcd093214a220d'>tags/4c/ee/handler.692749.D692749.135414363813777.ackdone@bugs.debian.org/debian</a></td><td class='right'>0</td><td class='graph'><table summary='file diffstat' width='0%'><tr><td class='add' style='width: -nan%;'/><td class='rem' style='width: -nan%;'/><td class='none' style='width: -nan%;'/></tr></table></td></tr>
</table><div class='diffstat-summary'>23 files changed, 0 insertions, 0 deletions</div><table summary='diff' class='diff'><tr><td>