<div dir="ltr">With a basic concerto db, and a few flag adjustments the space comes down to 256MB, and it generates in 2 minutes on a test system.<div><br></div><div>-nopages -norows -degree 1<br></div><div><br></div><div>-degree 1 only generates graphs for one link away, skips the 2 degree graphs.</div><div>-norows skips counting rows.<br></div><div>-nopages disables the paging, so all fields are shown in one display.<br></div><div><br></div><div>Installing seems like it can be done with 2 commands on Debian 11.9</div><div>sudo apt install graphviz default-jre libpostgresql-jdbc-java<br></div><div>wget <a href="https://github.com/schemaspy/schemaspy/releases/download/v6.2.4/schemaspy-6.2.4.jar" target="_blank">https://github.com/schemaspy/schemaspy/releases/download/v6.2.4/schemaspy-6.2.4.jar</a></div><div><br></div><div>I'm not familiar at all with how the documentation server is setup. Is there already a postgres cluster setup that the script could use and just create/drop databases on? Should it be as self contained as possible, using its own copy of the git repo?</div><div><br></div><div>I'm currently envisioning one script that runs on a schedule that handles finding situations where the schema documentation needs to be updated.</div><div><br></div><div>That would call another script that would take a release name and database info as arguments, switch to that branch in git, install the database and generate the schemaspy output.</div><div><br></div><div>How does that sound?</div><div>Josh</div><div><br></div><div><br><div><br></div><div><br></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Apr 25, 2024 at 9:45 AM Blake Graham-Henderson <<a href="mailto:blake@mobiusconsortium.org" target="_blank">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"><u></u>
<div>
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 href="https://us02web.zoom.us/j/85975936703?pwd=NUZMRHNjM3FYK21tN0NTZCtuSExuQT09" target="_blank">https://us02web.zoom.us/j/85975936703?pwd=NUZMRHNjM3FYK21tN0NTZCtuSExuQT09</a><br>
<br>
<pre cols="72">-Blake-
Conducting Magic
Will consume any data format
MOBIUS
</pre>
<div>On 4/25/2024 7:47 AM, Josh Stompro
wrote:<br>
</div>
<blockquote type="cite">
<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">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">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">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">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">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" 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">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">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">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;" 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">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">http://help.georgialibraries.org</a> | <a href="mailto:help@georgialibraries.org" rel="noreferrer" target="_blank">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"><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;" width="36" height="36"></span></span></a><a href="https://www.twitter.com/georgialibs" style="text-decoration:none" rel="noreferrer" target="_blank"><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;" width="35" height="35"></span></span></a><a href="https://www.instagram.com/georgialibraries/" style="text-decoration:none" rel="noreferrer" target="_blank"><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;" width="34" height="34"></span></span></a><a href="https://www.twitter.com/georgialibs" style="text-decoration:none" rel="noreferrer" target="_blank"><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"><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">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">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">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;" 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">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;" 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;" 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;" 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"><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">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">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"><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">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;" 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">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;" 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;" 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;" 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"><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">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">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">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">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">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">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">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">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">Evergreen-documentation@list.evergreen-ils.org</a>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-documentation" rel="noreferrer" target="_blank">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">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">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-documentation</a><br>
</blockquote>
</div>
</blockquote>
<br>
</div>
</blockquote>
</div>
</blockquote>
<br>
</div>
</blockquote></div>