<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
Josh,<br>
<br>
I wasn't going to worry about the super old versions. Though, we
could. And yes, we'd need to setup a version of postgres that more
closely matches the version of Evergreen for it's time. Maybe it's
reasonable to only worry about the versions of Evergreen that are
available in our documentation site (it goes back to 3.6 which is
when we implemented the Antora generator).<br>
<br>
The nice thing is, we'd only need to do it once (hopefully). Whereas
the newer versions of Evergreen would need to be refreshed each time
the schema changes. Probably with each point release just to keep it
frosty. Once a release is no longer supported, we can stop
generating the HTML for it.<br>
<br>
The disk usage is more considerable that I thought. The community
documentation server has a 50GB disk. We'd need to ask for a
dedicated schemaspy disk to be added to the VM. I'll ask around for
that.<br>
<br>
I think a dedicated index page would be needed to link everyone to
the different versions of the schema. And that could live in a
special folder on the web server.<br>
<br>
I'm in the dev hackfest zoom meeting:<br>
<br>
<a class="moz-txt-link-freetext" href="https://us02web.zoom.us/j/85975936703?pwd=NUZMRHNjM3FYK21tN0NTZCtuSExuQT09">https://us02web.zoom.us/j/85975936703?pwd=NUZMRHNjM3FYK21tN0NTZCtuSExuQT09</a><br>
<br>
<pre class="moz-signature" cols="72">-Blake-
Conducting Magic
Will consume any data format
MOBIUS
</pre>
<div class="moz-cite-prefix">On 4/25/2024 7:47 AM, Josh Stompro
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAGOQQftib3Z1MEq8LhZnmrb+0ZnN0Emu=nt5ZQUk=YR1XEOJUA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">Sounds good, let's talk today about it.
<div><br>
</div>
<div>When I ran schemaspy on a copy of our 3.11 production
system, it generated 600MB of data. I'll try it on a freshly
configured DB to see if it is any smaller.</div>
<div><br>
</div>
<div>git branch -a --list *origin/tags/rel_* |wc <br>
</div>
<div>gives me 388 releases in git, but we probably just want the
latest for each version... any maybe just do 2.0 and greater,
which is 26 releases, 15GB of data. </div>
<div><br>
</div>
<div>I wonder if we will run into issues with Postgresql
versions? I know older EG releases won't install on PG14+ in
some cases. So we may need to map PG versions to EG releases
and keep that up to date? Maybe we can parse that out of the
Readme, looking for "minimum supported" and "PostgreSQL \d+"
near each other.</div>
<div><br>
</div>
<div>Josh</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Wed, Apr 24, 2024, 5:00 PM
Blake Graham-Henderson <<a
href="mailto:blake@mobiusconsortium.org" target="_blank"
moz-do-not-send="true" class="moz-txt-link-freetext">blake@mobiusconsortium.org</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote"
style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div> Josh,<br>
<br>
I'm glad you saw this thread and brought it back up! I do
see a way forward using schemaspy. If you want to pick this
up, I think we'd appreciate some code that can automate the
generation of the HTML. Using a postgres server paired with
the Evergreen git repo. The missing link is the code to
bring the git branch to a specific version, install the
Evergreen database onto the postgres server, then execute
the signalspy code. And the output of that would then need
to be injected into a page somewhere. The last piece of
getting a pointer to the entry html page will require
permissions on the docs server. We can put our heads
together and I'm sure we can get it worked out!<br>
<br>
Maybe at the hackfest tomorrow!?<br>
<pre cols="72">-Blake-
Conducting Magic
Will consume any data format
MOBIUS
</pre>
<div>On 4/24/2024 4:43 PM, Josh Stompro wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Hello Blake, I'm curious if you want help
with this? I've been missing the old autodoc based
database schema and was just going to volunteer to try
and help get that going again, but saw this email about
a new version.
<div>
<div><br>
</div>
<div>I was also looking at <a
href="https://dbdocs.io/" rel="noreferrer"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">https://dbdocs.io/</a>
which has nice output, but I think that is a cloud
provider that hosts the output which may not be what
we are looking for.</div>
<div><br>
</div>
<div>It would also be nice to have links in the
Database Schema Map section of <a
href="http://olddocs.evergreen-ils.org"
rel="noreferrer" target="_blank"
moz-do-not-send="true">olddocs.evergreen-ils.org</a>
updated with a 3.10 link to Michele's work at <a
href="https://wiki.evergreen-ils.org/doku.php?id=newdevs:db:schemas:3.10_schma"
rel="noreferrer" target="_blank"
moz-do-not-send="true"
class="moz-txt-link-freetext">https://wiki.evergreen-ils.org/doku.php?id=newdevs:db:schemas:3.10_schma</a>
, but I think I'm just used to going there to find
it... I need to retrain to go to the old docs
section... <a
href="https://docs.evergreen-ils.org/docs/latest/appendix/previous_docs.html"
rel="noreferrer" target="_blank"
moz-do-not-send="true"
class="moz-txt-link-freetext">https://docs.evergreen-ils.org/docs/latest/appendix/previous_docs.html</a></div>
<div><br>
</div>
<div>I tried out schemaspy and it seems pretty nice.
It displays comments, and the relationship diagrams
are fun.</div>
<div><img alt="image.png" moz-do-not-send="true"
width="472" height="468"><br>
</div>
<div><br>
</div>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Mon, Jan 1, 2024 at
2:12 PM Blake Henderson via Evergreen-documentation
<<a
href="mailto:evergreen-documentation@list.evergreen-ils.org"
rel="noreferrer" target="_blank"
moz-do-not-send="true" class="moz-txt-link-freetext">evergreen-documentation@list.evergreen-ils.org</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote"
style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<p>All,</p>
<p>I was thinking about baking in an autogenerated
PG browsable schema using Schemaspy. <a
href="https://schemaspy.org/samples/epivirusurf/" rel="noreferrer"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">https://schemaspy.org/samples/epivirusurf/</a></p>
<p>I saw it a few years ago and I tucked that in the
back of my mind to setup a way to have our
documentation server contain a section for all
versions of Evergreen's Database schema. With a
bit of elbow grease, we could loop through each
git branch and generate Evergreen schema pages
going back to 2.0. Plus have a nightly build of
current main, like we do for our Antora docs.<br>
</p>
<p>Which occurred to me after we adopted Antora -
seeing that we lost a couple of our features:
database details, downloadable PDF version of the
docs.</p>
<p>Of course, I haven't done anything! But I did
create that <a
href="https://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/support-scripts/make_concerto_from_evergreen_db.pl;h=e7d6159fcddc8541fa6676e0e87ef9e715bfff27;hb=refs/heads/main"
rel="noreferrer" target="_blank"
moz-do-not-send="true">Perl script</a> to make
it easier to create blank installations of the
Evergreen database on a PG server, which would be
useful for this automation.<br>
</p>
<pre cols="72">-Blake-
Conducting Magic
Can consume data in any format
MOBIUS
</pre>
<div>On 12/28/2023 2:06 PM, Terran McCanna via
Evergreen-documentation wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Thanik you!!<br clear="all">
<div>
<div>
<div dir="ltr" class="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div><br>
<div dir="ltr"
style="margin-left:0pt">
<table
style="border:medium none;border-collapse:collapse">
<colgroup><col
width="94"><col
width="530"></colgroup><tbody>
<tr
style="height:123pt">
<td
style="vertical-align:top;padding:5pt">
<p dir="ltr"
style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span
style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap"><span
style="border:none;display:inline-block;overflow:hidden;width:75px;height:75px"><img
src="https://lh6.googleusercontent.com/fJoF6o0xl9XByQZmykva1sv2n_cKGUXL_BH4crkpJgSqDu-yU7-5jIypuXBsEuoXCCBAAUQ2jUztJlZDNUVOlwl1bWZIL1W4wmFuEEzCLVMxUyhzdkV7jkcRcdZZni2z8OPz4xJA"
style="margin-left: 0px; margin-top: 0px;" moz-do-not-send="true"
width="75"
height="75"></span></span></p>
</td>
<td
style="vertical-align:top;padding:5pt">
<p dir="ltr"
style="line-height:1.2;margin-top:0pt;margin-bottom:0pt;margin-left:9pt"><span
style="font-size:11pt;font-family:Verdana;color:rgb(30,67,155);background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">Terran McCanna, PINES Program Manager</span></p>
<hr>
<p dir="ltr"
style="line-height:1.2;margin-top:0pt;margin-bottom:0pt;margin-left:9pt"><span
style="font-size:10pt;font-family:Verdana;color:rgb(0,0,0);background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap"></span><span
style="font-size:9pt;font-family:Verdana;color:rgb(30,67,155);background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">Georgia Public Library Service | University System of Georgia</span></p>
<p dir="ltr"
style="line-height:1.2;margin-top:0pt;margin-bottom:0pt;margin-left:9pt"><span
style="font-size:9pt;font-family:Verdana;color:rgb(30,67,155);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">2872 Woodcock Blvd, Suite 250 l Atlanta, GA 30341</span></p>
<p dir="ltr"
style="line-height:1.2;margin-top:0pt;margin-bottom:0pt;margin-left:9pt"><span
style="font-size:9pt;font-family:Verdana;color:rgb(30,67,155);background-color:rgb(255,255,255);font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">(404) 235-7138</span><span
style="font-size:9pt;font-family:Verdana;color:rgb(30,67,155);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap"> | <a
href="mailto:tmccanna@georgialibraries.org" rel="noreferrer"
target="_blank" moz-do-not-send="true" class="moz-txt-link-freetext">tmccanna@georgialibraries.org</a>
</span></p>
<p dir="ltr"
style="line-height:1.2;margin-top:0pt;margin-bottom:0pt;margin-left:9pt"><span
style="font-size:9pt;font-family:Verdana;color:rgb(30,67,155);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap"><a
href="http://help.georgialibraries.org" rel="noreferrer" target="_blank"
moz-do-not-send="true" class="moz-txt-link-freetext">http://help.georgialibraries.org</a> | <a
href="mailto:help@georgialibraries.org" rel="noreferrer" target="_blank"
moz-do-not-send="true" class="moz-txt-link-freetext">help@georgialibraries.org</a>
</span></p>
<br>
<p dir="ltr"
style="line-height:1.2;margin-top:0pt;margin-bottom:0pt;margin-left:9pt"><a
href="https://www.facebook.com/georgialibraries"
style="text-decoration:none" rel="noreferrer" target="_blank"
moz-do-not-send="true"><span
style="font-size:9pt;font-family:Verdana;color:rgb(17,85,204);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:underline;vertical-align:baseline;white-space:pre-wrap"><span
style="border:none;display:inline-block;overflow:hidden;width:36px;height:36px"><img
src="https://lh4.googleusercontent.com/77DYzuoZ-zqC0pyQuYNKCrWaPuOANHsYTJze0JxE_iK4yW2sCswywdPCC8hCHOIyhO7KKIO-L6dlN1wIqdHFcyJmTa1fuc5Ok34dR8FQTtZHawpgNmovGxjg9RS0-WI74dFDHw0_"
style="margin-left: 0px; margin-top: 0px;" moz-do-not-send="true"
width="36"
height="36"></span></span></a><a
href="https://www.twitter.com/georgialibs" style="text-decoration:none"
rel="noreferrer" target="_blank" moz-do-not-send="true"><span
style="font-size:10pt;font-family:Verdana;color:rgb(17,85,204);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:underline;vertical-align:baseline;white-space:pre-wrap"><span
style="border:none;display:inline-block;overflow:hidden;width:35px;height:35px"><img
src="https://lh4.googleusercontent.com/1bKX66xWgHe-v5FD5l-hYX4FrZDXi1Y2aKr0DZLDA_oEHy7s01WVqgVilQcwGBzRQZAg3yOePmZncGwtiYGSgavOkb0T5Tj3c46iUJ7ZE7h-MUEhVwXQs7Oc3cahIYMN2SGlk_6b"
style="margin-left: 0px; margin-top: 0px;" moz-do-not-send="true"
width="35"
height="35"></span></span></a><a
href="https://www.instagram.com/georgialibraries/"
style="text-decoration:none" rel="noreferrer" target="_blank"
moz-do-not-send="true"><span
style="font-size:11pt;font-family:Verdana;color:rgb(17,85,204);background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:underline;vertical-align:baseline;white-space:pre-wrap"><span
style="border:none;display:inline-block;overflow:hidden;width:34px;height:34px"><img
src="https://lh3.googleusercontent.com/U7PH5YIQnuRvbeMnGOlJAEPAre7Zqx_I6IDJAtJVwUDCp1-TmjSwP_x21qKx8ApsbcaILIuSpL3Pzau2Rz-phR_4IPcLR4LrIha_JMDHqombNtsfa1uhXcYS02QWTAyYqSf3ES_n"
style="margin-left: 0px; margin-top: 0px;" moz-do-not-send="true"
width="34"
height="34"></span></span></a><a
href="https://www.twitter.com/georgialibs" style="text-decoration:none"
rel="noreferrer" target="_blank" moz-do-not-send="true"><span
style="font-size:10pt;font-family:Verdana;color:rgb(17,85,204);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:underline;vertical-align:baseline;white-space:pre-wrap"></span></a></p>
</td>
</tr>
<tr
style="height:21pt">
<td colspan="2"
style="vertical-align:top;padding:5pt">
<p dir="ltr"
style="line-height:1.2;margin-top:0pt;margin-bottom:0pt;text-align:center"><a
href="http://georgialibraries.org" style="text-decoration:none"
rel="noreferrer" target="_blank" moz-do-not-send="true"><span
style="font-size:10pt;font-family:Verdana;color:rgb(17,85,204);background-color:rgb(255,255,255);font-weight:400;font-style:italic;font-variant:normal;text-decoration:underline;vertical-align:baseline;white-space:pre-wrap">Join our email list</span></a><span
style="font-size:10pt;font-family:Verdana;color:rgb(0,0,0);background-color:rgb(255,255,255);font-weight:400;font-style:italic;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap"> </span><span
style="font-size:10pt;font-family:Verdana;color:rgb(67,67,67);background-color:rgb(255,255,255);font-weight:400;font-style:italic;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">for stories of Georgia libraries making an impact in our communities.</span></p>
</td>
</tr>
</tbody>
</table>
</div>
<br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Thu, Dec
28, 2023 at 2:54 PM Andrea Buntz Neiman via
Evergreen-documentation <<a
href="mailto:evergreen-documentation@list.evergreen-ils.org"
rel="noreferrer" target="_blank"
moz-do-not-send="true"
class="moz-txt-link-freetext">evergreen-documentation@list.evergreen-ils.org</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote"
style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">I updated the 3.2 link on the
newdevs page, and I'll put links in for the
3.2 and 3.10 schemas on the <a
href="https://docs.evergreen-ils.org/docs/latest/appendix/previous_docs.html"
rel="noreferrer" target="_blank"
moz-do-not-send="true">previous docs</a>
page.
<div><br>
</div>
<div>(and thank you, Michele, for the
updated schema!)</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Thu,
Dec 14, 2023 at 9:25 AM Tiffany Little via
Evergreen-documentation <<a
href="mailto:evergreen-documentation@list.evergreen-ils.org"
rel="noreferrer" target="_blank"
moz-do-not-send="true"
class="moz-txt-link-freetext">evergreen-documentation@list.evergreen-ils.org</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote"
style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div class="gmail_default"
style="font-family:tahoma,sans-serif;font-size:small">That's perfect,
thank you Michele!!</div>
<div>
<div dir="ltr" class="gmail_signature">
<div dir="ltr"><span><br>
<div dir="ltr"
style="margin-left:0pt"
align="left">
<table
style="border:medium;border-collapse:collapse">
<colgroup><col width="89"><col
width="414"></colgroup><tbody>
<tr style="height:123pt">
<td
style="vertical-align:top;padding:5pt;overflow:hidden">
<p dir="ltr"
style="line-height:1.44;margin-top:0pt;margin-bottom:0pt"><span
style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><span
style="border:medium;display:inline-block;overflow:hidden;width:75px;height:75px"><img
src="https://lh6.googleusercontent.com/8c2XlzLbIIC6nDoa4yqQ8MzA0npF4WXpUnhhoK_uTqralZtjqVXRwPgmRep3jGYP6q41Sb0ULXqxX-QppYTC8cQyIfBAdqzLBgqvcQwVczkqqiunlj0KIbvy-R3bp-E0mlhF0A4v"
style="margin-left: 0px; margin-top: 0px;" moz-do-not-send="true"
width="75"
height="75"></span></span></p>
</td>
<td
style="vertical-align:top;padding:5pt;overflow:hidden">
<p dir="ltr"
style="line-height:1.44;margin-left:9pt;margin-top:0pt;margin-bottom:0pt"><span></span></p>
<p dir="ltr"
style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span
style="font-family:Verdana,sans-serif;color:rgb(30,67,155);background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">Tiffany Little, PINES Bibliographic Projects Manager</span></p>
<hr>
<p dir="ltr"
style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span
style="font-size:9pt;font-family:Verdana,sans-serif;color:rgb(30,67,155);background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">Georgia Public Library Service</span></p>
<p dir="ltr"
style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span
style="font-size:9pt;font-family:Verdana,sans-serif;color:rgb(30,67,155);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">2872 Woodcock Blvd, Suite 250 | Atlanta, GA 30341</span></p>
<p dir="ltr"
style="line-height:1.44;margin-left:9pt;margin-top:0pt;margin-bottom:0pt"><span></span></p>
<p dir="ltr"
style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span
style="font-size:9pt;font-family:Verdana,sans-serif;color:rgb(30,67,155);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">(404) 235-7161 | <a
href="mailto:tlittle@georgialibraries.org" rel="noreferrer"
target="_blank"
moz-do-not-send="true" class="moz-txt-link-freetext">tlittle@georgialibraries.org</a></span></p>
<br>
<p dir="ltr"
style="line-height:1.44;margin-left:9pt;margin-top:0pt;margin-bottom:0pt"><span
style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><span
style="border:medium;display:inline-block;overflow:hidden;width:36px;height:36px"><img
src="https://lh6.googleusercontent.com/ql1so1R8csbb2W7DW5vjWe3mTAcApuM7a5CMXbsYnhmF1bDmG62LM_C1BOOyWdkb2PZGKGlaYRIceHjsSvsWPXNw6HPCKqtFLMKCJiPVU0RXu2dAey13WZ02Q6E6FmzNDJ_d9iBf"
style="margin-left: 0px; margin-top: 0px;" moz-do-not-send="true"
width="36"
height="36"></span></span><span
style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><span
style="border:medium;display:inline-block;overflow:hidden;width:35px;height:35px"><img
src="https://lh3.googleusercontent.com/2qSr0-AREIyPSTC1gMsjyXLaBT-yQ7kS6iKvd1L9XrCXxhJDWCRo5eXBHCi7f35AZASOOyiH2Si-wtuXNR8YaA2j-17GWBmmo1mpGxXa7m-JwF4AzUD_5tZZE9n1NVilAJcnGtQs"
style="margin-left: 0px; margin-top: 0px;" moz-do-not-send="true"
width="35"
height="35"></span></span><span
style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><span
style="border:medium;display:inline-block;overflow:hidden;width:35px;height:35px"><img
src="https://lh6.googleusercontent.com/-jM_GEWd7EZGo5MFiR1koKEkiupb_lmwNEMpNiQE3U6k1C2FkyuiNjtGKlWWGfX8zbZ1135yhOHnJSINmMTXgEQuu2RlHIg5hDKxaJ9cmh3Nr6el_vN4ZHlXcAmoCPPWduwXi26m"
style="margin-left: 0px; margin-top: 0px;" moz-do-not-send="true"
width="35"
height="35"></span></span></p>
</td>
</tr>
<tr style="height:21pt">
<td colspan="2"
style="vertical-align:top;padding:5pt;overflow:hidden">
<p dir="ltr"
style="line-height:1.44;text-align:center;margin-top:0pt;margin-bottom:0pt"><a
href="http://georgialibraries.org/" rel="noreferrer" target="_blank"
moz-do-not-send="true"><span
style="font-size:8pt;font-family:Verdana;color:rgb(17,85,204);background-color:transparent;font-style:italic;vertical-align:baseline;white-space:pre-wrap">Join our email list</span></a><span
style="font-size:8pt;font-family:Verdana;color:rgb(0,0,0);background-color:transparent;font-style:italic;vertical-align:baseline;white-space:pre-wrap"> </span><span
style="font-size:8pt;font-family:Verdana;color:rgb(67,67,67);background-color:transparent;font-style:italic;vertical-align:baseline;white-space:pre-wrap">for stories of Georgia libraries making an impact in our communities.</span></p>
</td>
</tr>
</tbody>
</table>
</div>
</span></div>
</div>
</div>
<br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On
Wed, Dec 13, 2023 at 8:59 AM Morgan,
Michele <<a
href="mailto:mmorgan@noblenet.org"
rel="noreferrer" target="_blank"
moz-do-not-send="true"
class="moz-txt-link-freetext">mmorgan@noblenet.org</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote"
style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div class="gmail_default"
style="font-family:verdana,sans-serif">Hi Tiffany,</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif"><br>
</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif">There's a database schema section
on the New Devs page with a link
to those schemas:</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif"><br>
</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif"><a
href="https://wiki.evergreen-ils.org/doku.php?id=newdevs:db:schemas"
rel="noreferrer" target="_blank"
moz-do-not-send="true"
class="moz-txt-link-freetext">https://wiki.evergreen-ils.org/doku.php?id=newdevs:db:schemas</a><br>
</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif"><br>
</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif">There's also a 3.10 schema there
which was part of my tuit
challenge from the
conference. 🍪🙂</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif"><br>
</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif">Hope this helps!</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif">Michele</div>
<div>
<div dir="ltr"
class="gmail_signature">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div><span
style="font-family:verdana,sans-serif"><br>
</span></div>
<div><span
style="font-family:verdana,sans-serif">--</span><br>
</div>
<div><font
face="verdana, sans-serif">Michele M. Morgan, <span
style="font-size:12.8px">Systems Support Specialist<br>
</span></font></div>
<div><span
style="font-size:12.8px"><font face="verdana, sans-serif">North of
Boston Library
Exchange,
Danvers
Massachusetts</font></span></div>
<div><span
style="font-size:12.8px"><a href="mailto:mmorgan@noblenet.org"
rel="noreferrer"
target="_blank"
moz-do-not-send="true"><font face="verdana, sans-serif">mmorgan@noblenet.org</font></a></span></div>
<div><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On
Wed, Dec 13, 2023 at 8:48 AM
Tiffany Little via
Evergreen-documentation <<a
href="mailto:evergreen-documentation@list.evergreen-ils.org"
rel="noreferrer" target="_blank"
moz-do-not-send="true"
class="moz-txt-link-freetext">evergreen-documentation@list.evergreen-ils.org</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote"
style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div class="gmail_default"
style="font-family:tahoma,sans-serif;font-size:small">Good morning,</div>
<div class="gmail_default"
style="font-family:tahoma,sans-serif;font-size:small"><br>
</div>
<div class="gmail_default"
style="font-family:tahoma,sans-serif;font-size:small">Since the docs got
moved last month(?), I'm not
able to find the old database
schema pages that we had.
(Although they were admittedly
outdated, like 3.2 or
something.) I actually did use
those--can someone point me to
where they're at now?<br>
</div>
<div class="gmail_default"
style="font-family:tahoma,sans-serif;font-size:small"><br>
</div>
<div class="gmail_default"
style="font-family:tahoma,sans-serif;font-size:small">Thanks!<br>
Tiffany</div>
<div>
<div dir="ltr"
class="gmail_signature">
<div dir="ltr"><span><br>
<div dir="ltr"
style="margin-left:0pt" align="left">
<table
style="border:medium;border-collapse:collapse">
<colgroup><col
width="89"><col
width="414"></colgroup><tbody>
<tr
style="height:123pt">
<td
style="vertical-align:top;padding:5pt;overflow:hidden">
<p dir="ltr"
style="line-height:1.44;margin-top:0pt;margin-bottom:0pt"><span
style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><span
style="border:medium;display:inline-block;overflow:hidden;width:75px;height:75px"><img
src="https://lh6.googleusercontent.com/8c2XlzLbIIC6nDoa4yqQ8MzA0npF4WXpUnhhoK_uTqralZtjqVXRwPgmRep3jGYP6q41Sb0ULXqxX-QppYTC8cQyIfBAdqzLBgqvcQwVczkqqiunlj0KIbvy-R3bp-E0mlhF0A4v"
style="margin-left: 0px; margin-top: 0px;" moz-do-not-send="true"
width="75"
height="75"></span></span></p>
</td>
<td
style="vertical-align:top;padding:5pt;overflow:hidden">
<p dir="ltr"
style="line-height:1.44;margin-left:9pt;margin-top:0pt;margin-bottom:0pt"><span></span></p>
<p dir="ltr"
style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span
style="font-family:Verdana,sans-serif;color:rgb(30,67,155);background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">Tiffany Little, PINES Bibliographic Projects Manager</span></p>
<hr>
<p dir="ltr"
style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span
style="font-size:9pt;font-family:Verdana,sans-serif;color:rgb(30,67,155);background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">Georgia Public Library Service</span></p>
<p dir="ltr"
style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span
style="font-size:9pt;font-family:Verdana,sans-serif;color:rgb(30,67,155);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">2872 Woodcock Blvd, Suite 250 | Atlanta, GA 30341</span></p>
<p dir="ltr"
style="line-height:1.44;margin-left:9pt;margin-top:0pt;margin-bottom:0pt"><span></span></p>
<p dir="ltr"
style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span
style="font-size:9pt;font-family:Verdana,sans-serif;color:rgb(30,67,155);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">(404) 235-7161 | <a
href="mailto:tlittle@georgialibraries.org" rel="noreferrer"
target="_blank" moz-do-not-send="true" class="moz-txt-link-freetext">tlittle@georgialibraries.org</a></span></p>
<br>
<p dir="ltr"
style="line-height:1.44;margin-left:9pt;margin-top:0pt;margin-bottom:0pt"><span
style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><span
style="border:medium;display:inline-block;overflow:hidden;width:36px;height:36px"><img
src="https://lh6.googleusercontent.com/ql1so1R8csbb2W7DW5vjWe3mTAcApuM7a5CMXbsYnhmF1bDmG62LM_C1BOOyWdkb2PZGKGlaYRIceHjsSvsWPXNw6HPCKqtFLMKCJiPVU0RXu2dAey13WZ02Q6E6FmzNDJ_d9iBf"
style="margin-left: 0px; margin-top: 0px;" moz-do-not-send="true"
width="36"
height="36"></span></span><span
style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><span
style="border:medium;display:inline-block;overflow:hidden;width:35px;height:35px"><img
src="https://lh3.googleusercontent.com/2qSr0-AREIyPSTC1gMsjyXLaBT-yQ7kS6iKvd1L9XrCXxhJDWCRo5eXBHCi7f35AZASOOyiH2Si-wtuXNR8YaA2j-17GWBmmo1mpGxXa7m-JwF4AzUD_5tZZE9n1NVilAJcnGtQs"
style="margin-left: 0px; margin-top: 0px;" moz-do-not-send="true"
width="35"
height="35"></span></span><span
style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><span
style="border:medium;display:inline-block;overflow:hidden;width:35px;height:35px"><img
src="https://lh6.googleusercontent.com/-jM_GEWd7EZGo5MFiR1koKEkiupb_lmwNEMpNiQE3U6k1C2FkyuiNjtGKlWWGfX8zbZ1135yhOHnJSINmMTXgEQuu2RlHIg5hDKxaJ9cmh3Nr6el_vN4ZHlXcAmoCPPWduwXi26m"
style="margin-left: 0px; margin-top: 0px;" moz-do-not-send="true"
width="35"
height="35"></span></span></p>
</td>
</tr>
<tr
style="height:21pt">
<td colspan="2"
style="vertical-align:top;padding:5pt;overflow:hidden">
<p dir="ltr"
style="line-height:1.44;text-align:center;margin-top:0pt;margin-bottom:0pt"><a
href="http://georgialibraries.org/" rel="noreferrer" target="_blank"
moz-do-not-send="true"><span
style="font-size:8pt;font-family:Verdana;color:rgb(17,85,204);background-color:transparent;font-style:italic;vertical-align:baseline;white-space:pre-wrap">Join our email list</span></a><span
style="font-size:8pt;font-family:Verdana;color:rgb(0,0,0);background-color:transparent;font-style:italic;vertical-align:baseline;white-space:pre-wrap"> </span><span
style="font-size:8pt;font-family:Verdana;color:rgb(67,67,67);background-color:transparent;font-style:italic;vertical-align:baseline;white-space:pre-wrap">for stories of Georgia libraries making an impact in our communities.</span></p>
</td>
</tr>
</tbody>
</table>
</div>
</span></div>
</div>
</div>
</div>
_______________________________________________<br>
Evergreen-documentation mailing
list<br>
<a
href="mailto:Evergreen-documentation@list.evergreen-ils.org"
rel="noreferrer" target="_blank"
moz-do-not-send="true"
class="moz-txt-link-freetext">Evergreen-documentation@list.evergreen-ils.org</a><br>
<a
href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-documentation"
rel="noreferrer noreferrer"
target="_blank"
moz-do-not-send="true"
class="moz-txt-link-freetext">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-documentation</a><br>
</blockquote>
</div>
</blockquote>
</div>
_______________________________________________<br>
Evergreen-documentation mailing list<br>
<a
href="mailto:Evergreen-documentation@list.evergreen-ils.org"
rel="noreferrer" target="_blank"
moz-do-not-send="true"
class="moz-txt-link-freetext">Evergreen-documentation@list.evergreen-ils.org</a><br>
<a
href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-documentation"
rel="noreferrer noreferrer"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-documentation</a><br>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
<span class="gmail_signature_prefix">-- </span><br>
<div dir="ltr" class="gmail_signature">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div
style="color:rgb(136,136,136);font-size:12.8px"><span
style="font-size:12.8px">Andrea
Buntz Neiman, MLS</span><br>
</div>
<div
style="color:rgb(136,136,136);font-size:12.8px">Project Manager for
Software Development | Product
Specialist</div>
<div
style="color:rgb(136,136,136);font-size:12.8px">Equinox Open Library
Initiative</div>
<div
style="color:rgb(136,136,136);font-size:12.8px"><a
href="mailto:abneiman@equinoxoli.org" rel="noreferrer" target="_blank"
moz-do-not-send="true">abneiman@equinoxOLI.org</a></div>
<div
style="color:rgb(136,136,136);font-size:12.8px"><span
style="font-size:12.8px">1-877-OPEN-ILS </span><span
style="font-size:12.8px">(673-6457)</span><br>
</div>
<div
style="color:rgb(136,136,136);font-size:12.8px"><span
style="font-size:12.8px">Direct:
770-709-5583</span></div>
<div><font color="#0000ee"><u><a
href="https://www.equinoxOLI.org/" rel="noreferrer" target="_blank"
moz-do-not-send="true">https://www.equinoxOLI.org/</a></u></font><br>
</div>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<br>
Evergreen-documentation mailing list<br>
<a
href="mailto:Evergreen-documentation@list.evergreen-ils.org"
rel="noreferrer" target="_blank"
moz-do-not-send="true"
class="moz-txt-link-freetext">Evergreen-documentation@list.evergreen-ils.org</a><br>
<a
href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-documentation"
rel="noreferrer noreferrer" target="_blank"
moz-do-not-send="true"
class="moz-txt-link-freetext">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-documentation</a><br>
</blockquote>
</div>
<br>
<fieldset></fieldset>
<pre>_______________________________________________
Evergreen-documentation mailing list
<a href="mailto:Evergreen-documentation@list.evergreen-ils.org"
rel="noreferrer" target="_blank"
moz-do-not-send="true"
class="moz-txt-link-freetext">Evergreen-documentation@list.evergreen-ils.org</a>
<a
href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-documentation"
rel="noreferrer" target="_blank"
moz-do-not-send="true"
class="moz-txt-link-freetext">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-documentation</a>
</pre>
</blockquote>
</div>
_______________________________________________<br>
Evergreen-documentation mailing list<br>
<a
href="mailto:Evergreen-documentation@list.evergreen-ils.org"
rel="noreferrer" target="_blank"
moz-do-not-send="true" class="moz-txt-link-freetext">Evergreen-documentation@list.evergreen-ils.org</a><br>
<a
href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-documentation"
rel="noreferrer noreferrer" target="_blank"
moz-do-not-send="true" class="moz-txt-link-freetext">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-documentation</a><br>
</blockquote>
</div>
</blockquote>
<br>
</div>
</blockquote>
</div>
</blockquote>
<br>
</body>
</html>