edit-task

Task Name:

Task Description:

TaskGroup ID:

Start Date:

Start Time:

Duration:

Priority:

Status:

Add Photo:

Owner ID:

Content: use HTML Edit Content

<h1 style="text-align: center;">SCRIPT-db_create-v-014</h1>
<h2>[previously]</h2>
<ol>
<li><strong>*] HAVE previous -v-012,</strong></li>
<ol>
<li>*] doc records show -v-013, looks like it only had&nbsp;'minor' revisions</li>
</ol>
<li><strong>x]&nbsp;FORWARD ENGINEER -&nbsp;create script from existing db_instance - global</strong></li>
<ol>
<li>x] use most recent 'reverse engineerED' version&nbsp;of __</li>
</ol>
<li><strong>x]&nbsp;DROP VIEW&nbsp;viewBooksInLibrary</strong></li>
<ol>
<li>x]</li>
</ol>
<li><strong>x]&nbsp;DROP VIEW&nbsp;viewChaptersInBook</strong></li>
<ol>
<li>x]</li>
</ol>
<li><strong>x]&nbsp;COMPARE&nbsp;- VERSUS&nbsp;- DB17 ( this was the last db generated )</strong></li>
<ol>
<li>x] use svr phpAdmin to Export structure ( this is unformatted text, hard to read )</li>
<li>x] use workbench to build 'model' from script&nbsp; (reverse engineer)</li>
<li>x] use workbench to build create 'script' from model ( forward engineer)</li>
<li>* loc = my db/</li>
</ol>
<li><strong>x] COMPARE: db17&nbsp;TO:&nbsp;&nbsp;db_create-v-014 - 14 - DOESNT HAVE</strong></li>
<ol>
<li><strong><span style="background-color: #ffff00;">] tech_hw table</span></strong></li>
<li>Dep] viewBooksInLibrary</li>
<li>Dep] viewChaptersInBook</li>
<li>Dep] webPagesMembership</li>
</ol>
<li><strong>*] MISSING from INVENTORY</strong></li>
<ol>
<li><strong><span style="background-color: #ffff00;">] visits</span></strong></li>
</ol>
<li><strong>x] VERIFY -v-013 changes</strong></li>
<ol>
<li>x] TABLE webpagesMember dropped</li>
<li>x] field &nbsp;</li>
<li>*] DID NOT - reorder tables in APP structure VS alpha order</li>
</ol>
<li><strong>x] VERIFY -v-013-rev-001 changes</strong></li>
<ol>
<li>x] add photo field to {L2} books</li>
<li>x] size photo field 1024</li>
</ol></ol>
<h2>[currently]</h2>
<ol>
<li>&gt; x] &nbsp;check db_1 ... db_x for view_address RE: PRB address-book-NF on user ###</li>
<ol>
<li>x] recreated VIEW but PRB exists</li>
</ol></ol>
<h2>[next]</h2>
<ol>
<li>]</li>
</ol>