<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hello,<br>
<br>
When I needed to fix all the OpenStack DB schemas, I used to dump
a pre-production clean DB with mysqldump [...] --no-data[1] and
compare it to the production one.<br>
It worked very well for fixing things up or looking at structure.<br>
<br>
See you,<br>
Regards<br>
<br>
<pre><b>[1] --no-data</b>, <b>-d</b>
Do not write any row information for the table. This is very useful
if you want to get a dump of only the structure for a table.</pre>
<br>
Le 03/12/2015 14:30, Alberto Molina Coballes a écrit :<br>
</div>
<blockquote
cite="mid:CAFnm+roJZ8Y5w0EbanD0ReXVWYzs+iviZqDk-e7AHu5v2rK9Hw@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<div>
<div>Hi Dionisis,<br>
<br>
</div>
<div>Reading your question I've remembered a python script
that generates OpenStack ER diagrams and I've found it
again:<br>
<br>
<a moz-do-not-send="true"
href="https://coderwall.com/p/pngadg/er-diagram-for-openstack-database">https://coderwall.com/p/pngadg/er-diagram-for-openstack-database</a><br>
<br>
</div>
It's really nice and simple, but it needed an update:<br>
<br>
<a moz-do-not-send="true"
href="https://github.com/albertomolina/openstack-db-schema">https://github.com/albertomolina/openstack-db-schema</a><br>
<br>
</div>
<div>Maybe you can find it useful.<br>
</div>
<div><br>
</div>
Cheers<br>
<br>
</div>
Alberto</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2015-12-03 8:45 GMT+01:00 Drakopoulos,
Dionisis (Nokia - GR/Athens) <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:dionisis.drakopoulos@nokia.com"
target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:dionisis.drakopoulos@nokia.com">dionisis.drakopoulos@nokia.com</a></a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="#0563C1" vlink="#954F72" lang="EN-US">
<div>
<p class="MsoNormal"><span
style="font-family:"Arial",sans-serif"> </span></p>
<p class="MsoNormal"><span
style="font-family:"Arial",sans-serif">Good
morning from Greece!</span></p>
<p class="MsoNormal"><span
style="font-family:"Arial",sans-serif">Does
anybody know where to find a valid Database schema
for OpenStack releases?</span></p>
<p class="MsoNormal"><span
style="font-family:"Arial",sans-serif"> </span></p>
<p class="MsoNormal"><span
style="font-family:"Arial",sans-serif">If
not one for all projects, then at least for core
ones.</span></p>
<p class="MsoNormal"><span
style="font-family:"Arial",sans-serif"> </span></p>
<p class="MsoNormal"><span
style="font-family:"Arial",sans-serif">Thank
you!</span></p>
<p class="MsoNormal"><span
style="font-family:"Arial",sans-serif"> </span></p>
<p class="MsoNormal"><b><span
style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#1f497d"
lang="DE">Dionisis (Dennis) Drakopoulos</span></b><b><span
style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black"><br>
</span></b><b><span
style="font-size:9.0pt;font-family:"Arial",sans-serif;color:gray"
lang="FI">OMP MP SW Engineer/SyVe/Maintenance/SL</span></b><b><span
style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#1f497d"
lang="DE"></span></b></p>
<p class="MsoNormal"><b><span
style="font-size:9.0pt;font-family:"Arial",sans-serif;color:gray"
lang="FI">MBB OMP MP R&D 14 GR</span></b><b><span
style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black"></span></b></p>
<p class="MsoNormal"><span
style="font-family:"Nokia Pure
Text",sans-serif;color:#1f497d" lang="DE">____________________________</span><span
style="font-family:"Nokia Pure
Text",sans-serif;color:#1f497d"></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial",sans-serif"> </span></p>
<p class="MsoNormal"><span
style="font-family:"Arial",sans-serif"> </span></p>
</div>
</div>
<br>
_______________________________________________<br>
Mailing list: <a moz-do-not-send="true"
href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack"
rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack</a><br>
Post to : <a moz-do-not-send="true"
href="mailto:openstack@lists.openstack.org">openstack@lists.openstack.org</a><br>
Unsubscribe : <a moz-do-not-send="true"
href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack"
rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack</a><br>
<br>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Mailing list: <a class="moz-txt-link-freetext" href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack</a>
Post to : <a class="moz-txt-link-abbreviated" href="mailto:openstack@lists.openstack.org">openstack@lists.openstack.org</a>
Unsubscribe : <a class="moz-txt-link-freetext" href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack</a>
</pre>
</blockquote>
<br>
</body>
</html>