(public).sospep.events ~ view task ~ FIX-PRB-DB-create-v-016

<h1 style="text-align: center;">FIX-PRB - create-db-script-v-016</h1>
<h2>[previously]</h2>
<ol>
<li><strong>[2014-12-25] FIX PRB - ADD db</strong></li>
<ol>
<li>*] ERROR MSG- A duplicate value cannot be inserted into a unique index. [ Table name = db_owner,Constraint name = PK_db_owner_id ]</li>
<li>x] TRY WORKAROUND - manually add record&nbsp;TO:TABLE db owner, used WM ide,</li>
<li>x] RESULT = PASS - added 3 records, 18,19,20</li>
<li>] ( need auto increment field for id,</li>
<li>] can't CHANGE existing id field to&nbsp;autoincrement, ERROR re&nbsp;incompatible values(int)&nbsp;)</li>
</ol>
<li><strong>[2014-12-27] FIX PRB - ERROR w/create-script</strong></li>
<ol>
<li>] view buying -</li>
<ol>
<li>PRB- ERROR on sort by, no field itemcategories</li>
</ol></ol>
<li><strong>[2014-12-27] FIX PRB - TABLES NOT VIEWS</strong></li>
<ol>
<li>x]&nbsp; view priority, view priority1</li>
<ol>
<li>PRB = these are showing up/being created&nbsp;as TABLES in db VS as&nbsp;VIEWS</li>
</ol>
<li>*]&nbsp;HAVE = dload of&nbsp;'view&nbsp;priority' 'create script'&nbsp;from public, created as VIEW</li>
<li>] COMPARE to</li>
<li>] REPLACE IN 'db-create-script-v-016'</li>
<li>*]&nbsp;HAVE = create script from schema .mwb -v-016</li>
<li>x] TEST script for both,</li>
<li>x] RESULT = PASS</li>
<li>*] USE default schema - ERROR re: permissions, REMOVE line</li>
</ol>
<li><strong>[2014-12-27] ADD db's</strong></li>
<ol>
<li>x] # 19 -</li>
<li>x] # 20 -</li>
</ol>
<li><strong>[2014-12-27] create using script</strong></li>
<ol>
<li><strong>] # 19 - use file import sql VS copy/paste</strong></li>
<ol>
<li>*] PRB error on view-priority</li>
<li>x] 30/32 created</li>
<li>*] REM the DROP TABLE if EXISTS line, both views are created OK</li>
<li>]</li>
</ol>
<li><strong>] # 20 -</strong></li>
<ol>
<li>*] PRB = same error</li>
<li>x] created 2 tables for view-priority,</li>
<li>x] delete tables</li>
<li>x] paste 'create view' script</li>
</ol></ol></ol>
<h2>[currently]</h2>
<ol>
<li>] &nbsp;</li>
</ol>
<h2>[next]</h2>
<ol>
<li>] TRY - paste script VS import</li>
<li>] TRY - genereate script from model, ] check counter #'s</li>
</ol>

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