(public).sospep.systems ~ view step ~ LIST

<h1 style="text-align: center;">LIST - steps - database inventory</h1>
<h2>[have]</h2>
<ol>
<li><strong>[*]&nbsp;HAVE -&nbsp;an inventory of dbs</strong></li>
<ol>
<li>*] 1 user can have multiple dbs</li>
<li>*] Y analysis - <span style="text-decoration: underline;">multi-tenant VS single-tenant architecture</span></li>
</ol>
<li><strong>*] HAVE - features - our&nbsp;UI users =</strong></li>
<ol>
<li>x] view all dbs ,</li>
<li>x] view all dbs with details,</li>
<li>x] next available db</li>
<li>] ADD db</li>
<ol>
<li>] PRB - ADD db - ERROR about inserting duplicate value in index</li>
</ol></ol></ol>
<h2>[beforehand]</h2>
<ol>
<li><strong>[] MANUAL- CREATE the db</strong></li>
<ol>
<li>x] for each new db - run the 'desired ver' 'create script'</li>
<li>x] login to svr admin panel,</li>
<li>x] open db admin</li>
<li>x] new db, SET users AS ] don, ] admin, ] viewer</li>
<li>x] execute a&nbsp;'db create' script (v # )</li>
<li><strong>[*] feature update</strong></li>
</ol>
<li><strong>[]&nbsp;MANUAL - CREATE a db record in the db_owners table(manual)</strong></li>
<ol>
<li>x] for each db, req fields = name</li>
<li>*] SET status available = 1, true</li>
</ol>
<li><strong>[] USER Registration process</strong></li>
<ol>
<li>x] automatically assigns an 'available'&nbsp;db to a new registered and confirmed user</li>
</ol>
<li>]</li>
</ol>
<h2>[previously]</h2>
<ol>
<li><strong>[*] on our site, when a new user confirms their registration</strong></li>
<ol>
<li>] the "next-available" db is assgined to the "new user" from the "db-inventory"</li>
<li>] the users is added to the site config&nbsp;file to&nbsp;enable connection to the new db</li>
</ol></ol>
<h2>[currently]</h2>
<ol>
<li>]</li>
</ol>
<h2>[next]</h2>
<ol>
<li>]</li>
</ol>
<p>&nbsp;</p>
<h2>[FIX PRB]</h2>
<ol>
<li><strong>] FIX PRB - ADD db</strong></li>
<ol>
<li>] # 4674 - FIX-PRB - add-db - PRB=</li>
</ol>
<li><strong>] FIX PRB</strong></li>
<ol>
<li>] # 4674&nbsp;- FIX-PRB - views NOT tables, PRB=</li>
</ol></ol>

~ view step ~ Procedure] database-inventory FROM [ App] db IN [ servers] prj-022-sospep