(public).sospep.events ~ view task ~ DB-create-v-017

<h1 style="text-align: center;">SCRIPT-db_create-v-017</h1>
<h2>[previously]</h2>
<ol>
<li><strong>[REFERENCE] HAVE </strong></li>
<ol>
<li>] # # - script.sql create-database - &nbsp;<a href="/view/task?id=2793" target="_blank">ovu, status</a></li>
</ol>
<li><strong>[2015-09-20]</strong></li>
<ol>
<li>x] # # - ADD 'url' field to locations table</li>
</ol>
<li><strong>[00:00] NEW task</strong></li>
<ol>
<li>x] # # - EDIT 'priority' field for steps, NOT NULL default = -5,</li>
</ol>
<li><strong>[***] ADDed 'default records' DATA SET</strong></li>
<ol>
<li>x] automatically generate 'content records' to populate new instance of db</li>
<li>x] will maintain 'default data set' as a seperate file VS adding to this script</li>
<li>*] dds will be a temporary solution until import default data, default data on public is setup&nbsp;</li>
<li>x] FILE= default-data-set.sql</li>
</ol></ol>
<h2>[currently]</h2>
<ol>
<li><strong>] INV</strong></li>
<ol>
<li>] alter table statement - steps priority NOT NULL default = -15</li>
<li>] alter table statement - new field = location.url&nbsp;</li>
</ol></ol>
<h2>[next]</h2>
<ol>
<li><strong>[] view problem</strong></li>
<ol>
<li>] download and swap 'view' scripts</li>
</ol>
<li><strong>[] schema.mwb VS create-script.sql</strong></li>
<ol>
<li>] y do we need 'create' file, cant we just fwd engineer a create script?</li>
<li>] plus document</li>
</ol>
<li><strong>] FIND</strong></li>
<ol>
<li>] db script (stored procedure ON DB __)&nbsp; sp generated the a whole new instance of db,</li>
<li>*] didnt work on hosted server b/c of permissions</li>
</ol>
<li><strong>x] &nbsp;check db_1 ... db_x for view_address RE: PRB address-book-NF on user ###</strong></li>
<ol>
<li>x] recreated VIEW but PRB exists</li>
</ol>
<li><strong>*] MISSING from INVENTORY</strong></li>
<ol>
<li><strong><span style="background-color: #ffff00;">] TABLE visits</span></strong></li>
<li><span style="background-color: #ffff00;"><strong>?] </strong>tech-hw (custom)</span></li>
</ol>
<li>] compare - global(35)</li>
<ol>
<li>] has visits, no tech-hw, also has (2) dropped, bookChapters, cur script should = 32</li>
</ol></ol>
<p>&nbsp;</p>

~ view task ~ TaskGroup] DB FROM [ Plan] doc-projects IN [ calendars] prj-022-sospep